Commit graph

7888 commits

Author SHA1 Message Date
AlterEgo
7a72c48521
Update auth and character base schemas 2026-08-04 18:14:45 -05:00
AlterEgo
641407434c
Fix email login conversion SQL compatibility 2026-08-04 17:54:31 -05:00
AlterEgo
2f4e627da8
Add self-service email login conversion 2026-08-04 17:39:56 -05:00
AlterEgo
5100a9f1d3
Merge remote-tracking branch 'origin/main' into no_patch 2026-08-04 17:10:16 -05:00
github-actions[bot]
1b3a91c229 SQL: Promote pending updates
Referenced commit(s): beee8177d8
2026-08-04 19:23:48 +00:00
AriDEV3
beee8177d8 Database: Implement quest "Forced to Watch from Afar"
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-04 21:22:57 +02:00
github-actions[bot]
fd27f04194 SQL: Promote pending updates
Referenced commit(s): 170b92c918
2026-08-04 13:56:17 +00:00
DigiD702
170b92c918 [Core/Spell] Fix Shadowstep
Reject self-targets when Auto Self Cast selects the caster, and keep combat
on same-map spell teleports so SPELL_GO smoke is not dropped by CANCEL_COMBAT.
Closes #926.
2026-08-04 06:55:28 -07:00
github-actions[bot]
002f37ea4c SQL: Promote pending updates
Referenced commit(s): d9621c1d31
2026-08-04 13:02:15 +00:00
AriDEV3
d9621c1d31 Database: "Rejold's New Brew" quest no longer unlocks quest "The Perfect Stout" in Mists of Pandaria.
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-04 15:01:19 +02:00
AlterEgo
e3e5d56c0d
Add modify currency command 2026-08-04 06:38:24 -05:00
github-actions[bot]
7bd47e9ee0 SQL: Promote pending updates
Referenced commit(s): 36e3054b50
2026-08-04 10:54:54 +00:00
AriDEV3
36e3054b50 Database: Quest "Beer Basted Boar Ribs" is no longer a cooking quest.
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-04 12:54:07 +02:00
github-actions[bot]
3b2a95cc6a SQL: Promote pending updates
Referenced commit(s): 31bfcc24e4
2026-08-04 07:00:15 +00:00
DigiD702
31bfcc24e4 [Core/Spell] Fix Hemorrhage
Apply the lingering bleed DoT from the direct strike and keep the dagger
damage bonus in the spell script instead of the generic weapon effect.
2026-08-03 23:59:28 -07:00
github-actions[bot]
91a47839e9 SQL: Promote pending updates
Referenced commit(s): 722d6421e5
2026-08-04 06:47:51 +00:00
DigiD702
722d6421e5 [Core/Spell] Fix Burst of Speed
Link 108212 to the 70% speed buff and keep the cast from breaking stealth.
2026-08-03 23:47:06 -07:00
github-actions[bot]
02827d92e9 SQL: Promote pending updates
Referenced commit(s): f0f0ea7f7a
2026-08-04 06:31:37 +00:00
DigiD702
f0f0ea7f7a [Core/Spell] Fix Sanguinary Vein
Apply the 35% damage-taken debuff while Rupture, Garrote, or Crimson Tempest
is active (Hemorrhage DoT with Glyph of Hemorrhaging Veins). Closes #942.
2026-08-03 23:30:41 -07:00
DigiD702
ddff68808f [Core/Spell] Fix Honor Among Thieves
Party/raid spell and ability crits grant a combo point while in combat,
with a 2s ICD applied after the combo cast so CheckCast does not fail
with SPELL_FAILED_NOT_READY. Removes the incorrect apply-time cast handler.
2026-08-03 23:30:40 -07:00
github-actions[bot]
fe6f1bae4f SQL: Promote pending updates
Referenced commit(s): 15b73ddc2d
2026-08-04 05:29:23 +00:00
DigiD702
cf04115a18 [Core/Spell] Fix Blindside
Limit Blindside procs to Mutilate weapon hits and only consume the buff when
Dispatch is used.

Closes #956
2026-08-03 22:28:44 -07:00
DigiD702
cffa3a8116 [Core/Spell] Fix Cut to the Chase
Bind Cut to the Chase and restrict its proc to Envenom so Slice and Dice
refreshes to the 5 combo point maximum duration.

Closes #957
2026-08-03 22:28:43 -07:00
DigiD702
5e2b30d449 [Core/Spell] Fix Venomous Wounds
Proc Nature damage and 10 Energy from poisoned Rupture/Garrote ticks, and refund
Energy from remaining Rupture duration when the target dies.

Closes #963
2026-08-03 22:28:43 -07:00
github-actions[bot]
532b3e2f4f SQL: Promote pending updates
Referenced commit(s): 724d97f65e
2026-08-04 04:52:59 +00:00
DigiD702
07b7f381b6 [Core/Spell] Fix Killing Spree
Require a valid enemy target, hop only that target unless Blade Flurry is up,
and drive teleports/attacks from the aura script instead of random area picks.

Closes #966
2026-08-03 21:52:10 -07:00
DigiD702
cbf195970c [Core/Spell] Fix Revealing Strike
Convert the dummy finisher-efficiency effect to taken-damage mod for Eviscerate,
Rupture, and Crimson Tempest; add Kidney Shot duration and Sinister Strike extra
combo point scripts.

Closes #968
2026-08-03 21:52:10 -07:00
github-actions[bot]
497ae7dc88 SQL: Promote pending updates
Referenced commit(s): a0c3e93871
2026-08-04 04:29:12 +00:00
DigiD702
a0c3e93871 [Core/Spell] Fix Crimson Tempest
Crimson Tempest only dealt its initial AoE hit and never applied the bleed.
After each hit, apply DoT 122233 at 240% of that damage over 6 ticks, including
bleed damage modifiers.

Closes #953
2026-08-03 21:28:23 -07:00
DigiD702
0641dd000a [Core/Spell] Fix Fan of Knives
Fan of Knives awarded combo points on every area target, so the last/random
hit became the combo target. Restrict the combo-point effect to the current
combo or selected enemy so CPs always land on your target.

Closes #955
2026-08-03 21:28:20 -07:00
github-actions[bot]
c0678117bd SQL: Promote pending updates
Referenced commit(s): dbb635d97a
2026-08-04 03:17:29 +00:00
DigiD702
dbb635d97a [Core/Spell] Fix Vanish
Vanish only entered normal Stealth because trigger spell 18461 is missing from
Spell.dbc and SPELL_EFFECT_176 did nothing. Apply Vanish aura 11327 (or
Subterfuge Vanish 115193), run sanctuary, leave combat outside encounters, and
return to Stealth when the aura expires.

Closes #935
2026-08-03 20:16:45 -07:00
DigiD702
364fc8f5c7 [Core/Spell] Fix Subterfuge
Subterfuge Stealth was stripped on cast/damage before scripts could run, so
the 3s Subterfuge buff never applied. Keep 115191/115193 through those
interrupts, proc or FoK/Crimson Tempest into 115192, and drop the stealth
forms when that buff expires.

Closes #922
2026-08-03 20:16:42 -07:00
AlterEgo
582a75da4e
Add SRP verifier storage for login identities
Add account_login_identity storage so email-shaped login names can use SRP verifier data generated for the same client-sent identity string. Wire auth challenge, reconnect, realm list lookup, account creation, password changes, username changes, email invalidation, and schema updates around the new identity table.

Signed-off-by: AlterEgo <admin@projectskyfire.org>
2026-08-03 21:20:11 -05:00
github-actions[bot]
e8188dd3e2 SQL: Promote pending updates
Referenced commit(s): 74016c4844
2026-08-04 02:07:12 +00:00
DigiD702
74016c4844 [Core/Spell] Fix Bandit's Guile
Bandit's Guile never built insight. Count Sinister Strike and Revealing Strike
hits to advance Shallow -> Moderate -> Deep insight with the matching damage
buff, and stop stacking while Deep Insight is active.

Closes #964
2026-08-03 19:06:23 -07:00
DigiD702
2531b7262d [Core/Spell] Fix Restless Blades
Restless Blades never reduced cooldowns. Proc from damaging finishers and cut
Adrenaline Rush, Killing Spree, Redirect, Shadow Blades, and Sprint by the
dummy amount times spent combo points.

Closes #967
2026-08-03 19:06:11 -07:00
DigiD702
cc9a88a854 [Core/Spell] Fix Ruthlessness
Ruthlessness triggered Combo Point Delayed (139569), but that dummy never granted
a combo point after the finisher cleared CPs. Schedule spell 139546 after the
finish phase, and allow Ruthlessness/Relentless Strikes ADD_TARGET_TRIGGER to
fire for only one hit target.

Closes #969
2026-08-03 19:05:59 -07:00
DigiD702
e0d8e6a77a [Core/Spell] Fix Combat Potency
Combat Potency restored Energy on every successful off-hand hit (100% proc).
Roll the MoP off-hand speed formula (~20% at 1.4s, higher for slower weapons)
and allow Main Gauche / Shadow Blade off-hand hits to participate.

Closes #965
2026-08-03 19:05:39 -07:00
github-actions[bot]
2f875f255d SQL: Promote pending updates
Referenced commit(s): 4a8c0fbf98
2026-08-04 00:17:01 +00:00
AlterEgo
4a8c0fbf98
Fix Death Knight runic script activation
Register the missing Death Knight spell scripts, bind their world database rows, and make Runic Empowerment select across the full depleted rune set without dividing by zero.

Closes #1253

Closes #1254

Signed-off-by: AlterEgo <admin@projectskyfire.org>
2026-08-03 19:15:59 -05:00
github-actions[bot]
15f0b4570e SQL: Promote pending updates
Referenced commit(s): e0c6ee60d7
2026-08-03 23:59:25 +00:00
AlterEgo
e0c6ee60d7
Fix hunter Thrill of the Hunt proc
Replace the obsolete disabled script path with a data-driven proc filter for spell 109306. The proc now uses the live talent aura, fires at 30 percent from focus-spending ranged hunter attacks and Kill Command, and lets the triggered 34720 aura handle the three discounted Arcane Shot or Multi-Shot casts.

Closes #1261

Signed-off-by: AlterEgo <admin@projectskyfire.org>
2026-08-03 18:58:32 -05:00
github-actions[bot]
7729de527f SQL: Promote pending updates
Referenced commit(s): ad7f6eeaca
2026-08-03 22:46:35 +00:00
AlterEgo
ad7f6eeaca
Restore Ardent Defender behavior
Re-enable the Paladin aura script with 5.4 damage reduction and lethal-hit rescue handling, add focused calculation coverage, and restore the spell script binding through pending SQL.

Closes #1264

Signed-off-by: AlterEgo <admin@projectskyfire.org>
2026-08-03 17:45:21 -05:00
github-actions[bot]
4c0667ef31 SQL: Promote pending updates
Referenced commit(s): 77d56fa262
2026-08-03 21:36:30 +00:00
AlterEgo
77d56fa262
Persist spell charge cooldown state
Save active spell charge buckets in the characters database, restore offline recharge progress on login, and keep player dumps aware of the new charge table.

Signed-off-by: AlterEgo <admin@projectskyfire.org>
2026-08-03 16:35:41 -05:00
github-actions[bot]
82f2c774fa SQL: Promote pending updates
Referenced commit(s): 67b0c20a8d
2026-08-03 19:06:09 +00:00
AriDEV3
67b0c20a8d Database: Add some vendor data to vendors in "Shrine of Seven Stars"
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-03 21:05:14 +02:00
github-actions[bot]
3d8ada3794 SQL: Promote pending updates
Referenced commit(s): ff001e7692
2026-08-03 14:03:59 +00:00