Commit graph

8088 commits

Author SHA1 Message Date
github-actions[bot]
bbd52a1443 SQL: Promote pending updates
Some checks failed
ubuntu-pch-smoke / pch-smoke (push) Has been cancelled
ubuntu-build / build (push) Has been cancelled
windows-build / build (push) Has been cancelled
Referenced commit(s): 2f4594ff13
2026-08-17 07:27:01 +00:00
DigiD702
2f4594ff13 Database: Scale MoP creature melee damage to retail samples.
Keep level 1 on the current curve. Ramp damage_exp4 through levels 2-7 to 1.78x and apply that scale from level 8 up, matching retail white hits at 8 and 15. Rewrite curve-sourced templates and leftover overscaled combat NPCs onto the calibrated values.
2026-08-17 00:25:33 -07:00
github-actions[bot]
0a620ab975 SQL: Promote pending updates
Referenced commit(s): 52f2401433
2026-08-17 03:13:27 +00:00
AlterEgo
52f2401433
Restore lost update that didn't make it into the last release from 6e864d8cbe
Signed-off-by: AlterEgo <admin@projectskyfire.org>
2026-08-16 22:12:39 -05:00
github-actions[bot]
3878e33a8c SQL: Promote pending updates
Referenced commit(s): 9d040aba69
2026-08-17 03:01:09 +00:00
DigiD702
9d040aba69 Merge branch 'fix/creature-aggro-range' 2026-08-16 19:22:17 -07:00
github-actions[bot]
db5cc00234 SQL: Promote pending updates
Referenced commit(s): e6b89921a2
2026-08-17 02:12:13 +00:00
DigiD702
e6b89921a2 Database: Unlock Extinguishing Hope for all classes with Blackrock Invasion.
PrevQuestId 28823 only counted the warrior Rear is Clear completion, so other
classes never saw Extinguishing Hope. Require an active Blackrock Invasion
instead; that quest is already unlocked by every class's Rear is Clear.
2026-08-16 19:05:58 -07:00
DigiD702
63b4bf7192 Database: Correct Northshire Worg and fire-trigger NPC flags. 2026-08-16 19:05:57 -07:00
DigiD702
1dc0dba8b4 [Core/SQL] Use MoP health and damage curves for creature stats.
Restore the per-expansion creature_classlevelstats schema and select the current-client basehp4 and damage_exp4 curves for every creature, so NPC health and melee damage match 5.4.8 rather than legacy expansion values. creature_template.exp stays content metadata and no longer selects a stat curve.

Give combat-capable templates that carried placeholder damage (0/0, 1/1, 2/2, or inverted ranges) values from the class level curve. damage_exp4 already holds the weapon damage average, so it is used directly rather than scaled, and attack power comes from the same curve. Authored Health_mod and mana modifiers are preserved, and helpers, vehicles, bosses, and unreferenced templates are excluded.
2026-08-16 19:05:56 -07:00
DigiD702
839c5275fb [Core/Creature] Read aggro radius from creature_template.detection_range.
The same-level aggro radius was a single hardcoded 20 yards for every creature,
so starting-zone mobs noticed players from across the camp and one pull dragged
in its neighbors. The radius is now a per-creature value defaulting to 20, with
the starting-zone level bracket set to 10, and the range check measures center
to center instead of adding both models' combat reaches on top of it.
2026-08-16 15:54:23 -07:00
AlterEgo
e73070ed08
Moving updates for a new db release. Updated base auth and character files
Signed-off-by: AlterEgo <admin@projectskyfire.org>
2026-08-15 08:57:34 -05:00
github-actions[bot]
0e3e1a7295 SQL: Promote pending updates
Referenced commit(s): c377bc5b20
2026-08-15 00:38:02 +00:00
DigiD702
c377bc5b20 [Core/SQL] Script quest 25027 Bramblestaff vine RP.
Spell 73141 is a dummy with no server handler, so a SpellScript awards the
objective credit and hands off to Three-Tooth's SAI. She stays a normal mob
(staff or kill both work anywhere), runs the vine grab RP on staff use, keeps
her ritual casts on the invisible ILM bunny, and respawns both Deviate Crones
with her on open-world respawn.
2026-08-14 17:36:54 -07:00
AriDEV3
58accd7dc9 Database: Fix import error in last commit.
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-14 16:57:32 +02:00
github-actions[bot]
274b86ff53 SQL: Promote pending updates
Referenced commit(s): 4f800cccd4
2026-08-14 14:56:14 +00:00
AriDEV3
4f800cccd4 Database: Add Details, RequestItemsText and OfferRewardText for quests "The Trogg Threat", "In Defense of the King's Lands", "A Decisive Strike", "Bigger and Uglier" and "Onward to Thelsamar".
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-14 16:55:02 +02:00
AriDEV3
a2ae20318c Database: Fix comment in previous commit.
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-14 10:54:20 +02:00
github-actions[bot]
d86ea543da SQL: Promote pending updates
Referenced commit(s): b338212db3
2026-08-14 08:45:09 +00:00
AriDEV3
b338212db3 Database: Implement Gyrocopter flights to/from Ironforge Airfield.
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-14 10:44:04 +02:00
github-actions[bot]
f9e05d283f SQL: Promote pending updates
Referenced commit(s): d6c7d6d9a0
2026-08-14 08:21:30 +00:00
AriDEV3
d6c7d6d9a0 Database: Update Details, RequestItemsText and OfferRewardText for quests "The Lost Pilot", "A Pilot's Revenge" and "South Gate Status Report"
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-14 10:20:42 +02:00
github-actions[bot]
8b542154b7 SQL: Promote pending updates
Referenced commit(s): b4bfe88b4e
2026-08-14 08:08:16 +00:00
AriDEV3
b4bfe88b4e Database: Add OfferRewardText for quest "Hero's Call: Loch Modan!".
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-14 10:07:23 +02:00
github-actions[bot]
c87ec97fd9 SQL: Promote pending updates
Referenced commit(s): f54f0f3b99
2026-08-14 07:31:43 +00:00
AriDEV3
f54f0f3b99 Database: Implement quest "Reinforcements for Loch Modan". 2026-08-14 09:30:56 +02:00
DigiD702
88afc29e14 [SQL] Consolidate Teegan Expedition updates into world_01.
Merge hub scripting with the final Gaines rope rescue and remove the superseded world_02 file that overwrote it on apply.
2026-08-13 23:01:57 -07:00
github-actions[bot]
bf8c21c371 SQL: Promote pending updates
Referenced commit(s): e030301653
2026-08-14 05:50:45 +00:00
DigiD702
e030301653 [SQL/SAI] Script Teegan's Expedition and fix Gaines rescue.
Add hub gossip, quest gating, and Ambassador Gaines rope/pole rescue for quest 25022.
2026-08-13 22:47:36 -07:00
DigiD702
fe85fbb074 [SQL/Loot] Restore Karga Rageroar MoP Classic drop table.
Replace helm-only loot with the Wowhead MoP Classic drops while keeping Rageroar's Helm as a quest item.
2026-08-13 20:05:32 -07:00
github-actions[bot]
4d00e6d075 SQL: Promote pending updates
Referenced commit(s): 4c58be630b
2026-08-14 02:54:46 +00:00
DigiD702
4c58be630b [SQL/SAI] Script quest 24956 Silencing Rageroar.
Bastoon starts RP on approach, shields Karga, then engages; Karga unlocks after Bastoon dies with helm loot. Fixes flee/return reset and open-world linked respawn via Bastoon as master timer.

Closes #1280
2026-08-13 19:52:05 -07:00
github-actions[bot]
daab67137e SQL: Promote pending updates
Referenced commit(s): c80bc663b7
2026-08-13 19:59:38 +00:00
AlterEgo
c80bc663b7
Implement From the Shadows and fix the duplicate cellar door auto-close
Adds Lorna Crowley's quest-accept handler, the Gilnean Mastiff tracking
pet with a collar-triggered ability to reveal and engage stealthed
Bloodfang Lurkers, and a recall trigger to work around a navmesh gap
in the cellar stairwell. Also stops the surviving cellar door from
auto-closing after use.
2026-08-13 14:58:36 -05:00
github-actions[bot]
e44797e0f7 SQL: Promote pending updates
Referenced commit(s): dc61c594e4
2026-08-13 18:21:35 +00:00
AlterEgo
dc61c594e4
Implement The Rebel Lord's Arsenal and fix related Gilneas City issues
Adds the Josiah Avery quest-reward handler and worgen-bite reveal
cutscene for quest 14159, using phaseId-based phasing so Lorna Crowley
and the phase-4 Avery double are actually visible during the scene.
Also removes a duplicate Cellar Door spawn that blocked the working
one, and fixes a generic trigger's visibility flag.
2026-08-13 13:20:40 -05:00
github-actions[bot]
8938383a91 SQL: Promote pending updates
Referenced commit(s): 206880bcf3
2026-08-13 17:49:38 +00:00
AriDEV3
206880bcf3 Database: Add RequestItemsText and OfferRewardText for quest "Demanding Answers".
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-13 19:48:48 +02:00
github-actions[bot]
2fed0d4867 SQL: Promote pending updates
Referenced commit(s): 7fac03762d
2026-08-13 15:33:32 +00:00
AriDEV3
7fac03762d Database: Implement quest "Extinguish the Fires".
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-13 17:32:35 +02:00
AriDEV3
9808c88027 Database: Use summon spell for summoning Tombs.
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-13 17:23:24 +02:00
github-actions[bot]
7cbea66d96 SQL: Promote pending updates
Referenced commit(s): b818a3a007
2026-08-13 05:10:50 +00:00
AriDEV3
b818a3a007 Database: Implement quest "Entombed in Ice".
Signed-off-by: AriDEV3 <aridev@projectskyfire.org>
2026-08-13 07:10:03 +02:00
github-actions[bot]
0a4443b7aa SQL: Promote pending updates
Referenced commit(s): 42163b724d
2026-08-13 02:08:15 +00:00
AlterEgo
42163b724d
Implement By the Skin of His Teeth encounter and King Genn Greymane dialogue
Adds the Sean Dempsey wave-spawner, Lord Darius Crowley quest-accept
trigger and combat, and four rooftop worgen fighters for quest 14154.
Also wires up King Genn Greymane's ambient reflection line via SmartAI.
2026-08-12 21:07:13 -05:00
github-actions[bot]
b5e21f495c SQL: Promote pending updates
Referenced commit(s): c70f49411d
2026-08-12 23:26:38 +00:00
AlterEgo
c70f49411d
Remove trainer-taught spells from Huntsman Blake 2026-08-12 18:25:51 -05:00
github-actions[bot]
a100a86f97 SQL: Promote pending updates
Referenced commit(s): 4581bc6238
2026-08-12 23:18:58 +00:00
AlterEgo
4581bc6238
Implement Evacuate the Merchant Square door event
Adds go_merchant_square_door, scripted in its own Gilneas folder: using
a door spawns a frightened citizen who flees toward the square while a
rampaging worgen gives chase, then grants evacuation credit. Guards
against repeat farming with a per-player per-door usage gate.
2026-08-12 18:18:04 -05:00
github-actions[bot]
30a6192339 SQL: Promote pending updates
Referenced commit(s): 1cfc162c48
2026-08-12 19:06:14 +00:00