Commit graph

364 commits

Author SHA1 Message Date
Skjalf
fc621f6897 fix(DB): Rename duplicate progression_61_64_down.sql filenames
DBUpdater requires unique filenames across all brackets. Append the
hosting bracket suffix to disambiguate.

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
2026-03-23 01:13:10 -03:00
Andrew
fe93b0bbd0
refactor(DB): Consolidate small SQL files by table per bracket (#468)
Merge small SQL files that target the same database table and share the
same bracket prefix into consolidated files. This reduces file count by
22 (from 230 to 208) while preserving all SQL content and comments.
Document SQL file naming conventions and organization rules in README.

Co-authored-by: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
2026-03-23 01:10:45 -03:00
Andrew
6d0cffb146
fix(DB): Update SQL for creature_template schema changes (#467)
Move `scale` to `creature_template_model.DisplayScale` for Lord Kazzak
(entry 12397) as `scale` column was removed from `creature_template`.

Co-authored-by: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
2026-03-22 22:15:43 -03:00
Andrew
76c577fbdd
fix(DB): Add missing Hateful Gladiator items for Magister Brasael (31581) (#466)
NPC 31581 was missing 50 Hateful Gladiator items (Hunter, Druid, Rogue,
Priest, Mage, Warlock pieces) that NPC 31579 already had.

Co-authored-by: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-21 04:48:06 -03:00
Andrew
0251b89c08
Move Hateful Gladiator vendor gear to Naxxramas bracket (80_1_3) (#465)
Co-authored-by: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-14 08:32:44 -03:00
Andrew
32ea14a305
Add Naxxramas bracket (80_1_3) and clean up WotLK raid bracket SQL
* Initial plan

* 

- Create new Bracket_80_1_3 for Naxxramas (Tier 7: Naxx, EoE, OS, VoA)
- Add bracket directory, loader, and SQL disable file
- Update ProgressionSystem.h with new bracket entry (BRACKET_MAX 38→39)
- Update ProgressionSystem_loader.cpp with new AddBracket_80_1_C_Scripts
- Update progression_system.conf.dist with new config entry
- Move VoA enable from Ulduar bracket to Naxxramas bracket
- Remove raids_disables.sql from ToC bracket (now handled by Naxx bracket)

Co-authored-by: Nyeriah <47818697+Nyeriah@users.noreply.github.com>

* Final progress update

Co-authored-by: Nyeriah <47818697+Nyeriah@users.noreply.github.com>

* Remove accidentally committed codeql file and update .gitignore

Co-authored-by: Nyeriah <47818697+Nyeriah@users.noreply.github.com>

---------

Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>
2026-02-16 15:13:43 -03:00
Benjamin Jackson
2c1014517a
Add progression for Love is in the Air neck pieces. (#460) 2026-02-09 18:26:49 -03:00
Skjalf
abfff59d98 Move Onyxia revert file up a few brackets
Moved progression_60_2_1_onyxia_down.sql from Bracket_80_1_1 to Bracket_80_4_2 to reflect updated directory structure.
2026-01-15 22:59:15 -03:00
Skjalf
2f77aa2274 fix: Update Naxx 25 emblems to valour 2026-01-15 20:52:12 -03:00
Skjalf
4e897f7f40 Update progression_61_64_npc_trainer_TBCprofs_down_2.sql 2025-12-31 06:23:59 -03:00
Skjalf
cf97553a47 Comment out TBC profession trainer SQL changes
The SQL statements for restoring TBC profession trainer items have been commented out, effectively disabling their execution. This may be for testing, rollback, or to temporarily prevent these changes from being applied.
2025-12-31 06:11:11 -03:00
Skjalf
b7ed6632b1 Comment out trainer item removal SQL statements
The DELETE statements for removing specific TBC items and Brilliant Glass from trainers have been commented out, likely to temporarily retain these items in trainers or for testing purposes.
2025-12-31 05:57:52 -03:00
Skjalf
ef6eeb62af Comment out SQL trainer modifications
All SQL statements modifying npc_trainer for flying and flight forms have been commented out, effectively disabling these changes without deleting them.
2025-12-31 05:35:07 -03:00
Skjalf
4c535e8982 Implement progression info command 2025-12-24 01:06:36 -03:00
Skjalf
dc343c8cad Phase out pvp vendors 2025-12-17 05:08:52 -03:00
Skjalf
a9b7f3e447 Switch Emblem of Triumph for Heroism 2025-12-17 05:05:59 -03:00
Skjalf
776329e4af Update phaseMask for specific creatures
Set phaseMask to 2 for creatures with GUIDs 133920 and 125693 in the progression_80_1_2_pvp_vendors.sql script.
2025-12-17 05:04:47 -03:00
Skjalf
d5ab0468e4 Refactor PVP vendor SQL and add down migration
Removed redundant INSERT statements from progression_80_1_2_pvp_vendors.sql and added a corresponding down migration script in Bracket_80_2. This improves migration management and separation of up/down SQL logic.
2025-12-16 19:29:16 -03:00
Skjalf
b51429355e Spawn pvp hateful acessory vendors 2025-12-16 19:03:53 -03:00
Skjalf
e7b96ea85f Rename vendor SQL file to flight master
Renamed 'progression_71_74_npc_vendor - kopia.sql' to 'progression_71_74_flight_master.sql' for improved clarity and organization.
2025-12-12 19:12:05 -03:00
Skjalf
c1cc79edd6 Remove Hateful valor items 2025-12-11 22:25:28 -03:00
Skjalf
1084c8380b Update config option to Bracket_80_1_1 in loaders
Changed the configuration key from 'ProgressionSystem.Bracket_80_1' to 'ProgressionSystem.Bracket_80_1_1' in Bracket_50_59_2_loader.cpp and Bracket_80_1_loader.cpp for consistency and correct feature gating.
2025-12-06 09:14:02 -03:00
Skjalf
d9dadea97f Restrict dungeon item level update to difficulty 1
The SQL update now applies the min_avg_item_level change to dungeons with difficulty 1 only, ensuring other difficulties remain unaffected.
2025-12-06 07:50:21 -03:00
Skjalf
bd0850674e Update min_avg_item_level for select dungeons
Sets min_avg_item_level to 150 for specific dungeon IDs in dungeon_access_template. Dungeon AN is intentionally left at 180 as noted.
2025-12-04 22:03:37 -03:00
Skjalf
41a17ec7cf Enable heroic dungeons in progression disables SQL
Adds a SQL script to remove disables for specific dungeon entries, enabling heroic dungeons in the progression bracket.
2025-12-04 21:47:45 -03:00
Skjalf
369e79b29d Set RewardAmount1 for quest 24788 in RDF quests SQL
Added `RewardAmount1 = 1` to the quest with ID 24788 to specify the reward amount for the daily first Valor (heroic) quest.
2025-12-04 21:44:12 -03:00
Skjalf
333dc8c6cb Rename AddBracket_80_1_Scripts to AddBracket_80_1_A_Scripts
Renamed the function AddBracket_80_1_Scripts to AddBracket_80_1_A_Scripts in both its definition and all usages to improve naming consistency and clarity.
2025-12-04 21:41:42 -03:00
Skjalf
cef629bf6b Add AddBracket_80_1_B_Scripts to loader
Introduces the AddBracket_80_1_B_Scripts function declaration and ensures it is called within Addmod_progression_systemScripts. This allows scripts for the 80_1_B bracket to be properly loaded.
2025-12-04 21:39:42 -03:00
Skjalf
f72a3f4680 Implement bracket 80_1_2 (heroic dungeons) 2025-12-04 21:37:40 -03:00
Ryan Turner
b4fc8cc297
Archmage Lan'dalock no longer offers any gossip or quests (#447)
* Updated min count to match max count

For this bracket should only 2 tokens!

* Update progression_80_1_disables.sql

* Modify disables and update creature_template for quests

Update gossip menu and npcflag for Archmage Lan'dalock.

* Revert whaterevr bs github keeps doing

* Update progression_80_4_1_disables.sql
2025-12-04 20:57:14 -03:00
sogladev
e37da74a5a
Remove Naxxramas' 'Orb of Naxxramas' Sapphiron Teleport skip (#448) 2025-12-04 20:56:48 -03:00
Skjalf
9657f27332 fix typo 2 2025-11-26 20:28:36 -03:00
Skjalf
4333990b57 fix query 2025-11-23 12:19:09 -03:00
Skjalf
8a96803ef6 Enable Tier 1 raids 2025-11-21 09:26:23 -03:00
Ryan Turner
e252def6ad
Disable quests locked instances (#444)
* The Forge of Souls quest available

* Trial of the Crusader quest avaiable

* Ruby santcum quest

* Forbid players for getting quest that require an instance

* Adds back Proof of Demise: The Black Knight

Implemented with the Call of the Crusade and gets removed with Fall of the Lich King

* Update progression_80_4_1_disables.sql

* Removed the wrong instance from ulduar bracket

* Remove Raids weekely

Todo re-add them later phases

* Revert "Remove Raids weekely"

This reverts commit 6f94d6532b.

* Update progression_80_1_disables.sql

* Remove proof demise

* Update progression_80_3_disables.sql

---------

Co-authored-by: FlyingArowana <TheSCREWEDSoftware@users.noreply.github.com>
2025-11-21 09:20:58 -03:00
Skjalf
d9bdee9cd8 Fix up Frozo 2025-11-15 06:15:51 -03:00
Ryan Turner
5ed3814faa
Progression for Kirin Tor rings and Frozo (#443)
* Updated min count to match max count

For this bracket should only 2 tokens!

* Added ulduar text to the tier

* Adds inscribed rings with ulduar release

* Update progression_80_2_inscribed_kirin_tor_rings.sql

* Commment for Trial of the Crusader with the tier

* Kirin tor Etched  rings with trial of the crusader

* Use the patch name

* Added runed rings for icc bracket

* Revert "Updated min count to match max count"

This reverts commit 08db8646b7.

I've no clue why this ona fresh repo is here as a old change.

* Added delete statement

* Remove frozo

* Re-add frozo on drop

* Add  frozo and his shop back in fall of lich king

* Proper progression done to frozo no need to phase

* Reverted 8bc8bcb074

* Instead of delete and add, rephase to 1

* Update progression_80_1_frozo_the_renowned.sql

* Update progression_80_1_frozo_the_renowned_down.sql

---------

Co-authored-by: FlyingArowana <TheSCREWEDSoftware@users.noreply.github.com>
2025-11-14 09:48:27 -03:00
Skjalf
33b5abcb53 Fix sourcetype 2025-11-13 23:43:38 -03:00
Skjalf
7c2efc5364 Disable epic jc gem transmutation spells 2025-11-13 23:35:06 -03:00
Skjalf
009fa5bdd5 Remove epic JC gems from vendors 2025-11-13 23:28:51 -03:00
Skjalf
49295a2510 Reset WotLK dungeon rewards 2025-11-13 06:11:24 -03:00
Skjalf
d2a2962a8b Phase out some progression npcs 2025-11-11 02:29:55 -03:00
Skjalf
f01e0be81d Remove Kirin Tor rings 2025-11-09 19:36:54 -03:00
Skjalf
effbda6040 Rename T5 down loot SQL file for clarity
Renamed progression_70_3_1_loot_t5_down.sql to progression_70_3_1_loot_t5_down_two.sql to improve file naming consistency and clarity.
2025-11-08 15:16:58 -03:00
Skjalf
c6a29c9f3f Add SQL script to remove warbear loot references
Introduces progression_80_1_warbear_down.sql to delete specific loot and condition entries related to warbear from the database for bracket 80_1.
2025-11-08 13:02:39 -03:00
Andrew
b18d429ef6
Enable normal dungeons in progression disables 2025-11-08 10:49:15 -03:00
Benjamin Jackson
fbd56ac4f0
Add progression stages for the Argent Tournament and its quests. (#378)
* Create progression_0_disables_ArgentTournamentquests.sql

* Create progression_0_disables_ArgentTournamentquests_down.sql

* Create progression_80_2_ArgentTournamentConstructionQuests.sql

* Update progression_80_2_ArgentTournamentConstructionQuests.sql

* Rename progression_0_disables_ArgentTournamentquests_down.sql to progression_0_disables_ArgentTournamentConstructionquests_down.sql

* Create progression_80_2_ArgentTournamentConstructionQuests_down.sql

* Create progression_0_disables_ArgentTournamentquests_down.sql
2025-11-08 04:34:28 -03:00
Skjalf
7a60732d2c Add RDF quest reward updates for bracket 80_1 2025-11-03 03:40:04 -03:00
Skjalf
72b2814482 Refactor boss state and console flag logic in SSC script
Simplified and clarified the logic for checking boss states and setting the Lady Vashj bridge console's selectable flag in Serpentshrine Cavern. Reduced nesting and improved early returns for better readability and maintainability.
2025-10-17 23:52:22 -03:00
Skjalf
186267ef53 Refactor event boss quest rewards to unified script
Removed custom boss scripts for Coren Direbrew and Apothecary Hummel, consolidating event quest reward logic into a single unit script. The new script handles quest completion and rewards for Headless Horseman, Coren Direbrew, and Apothecary Hummel based on dungeon and event state, reducing code duplication and improving maintainability.
2025-10-17 23:45:34 -03:00