Hi all,
I’ve tried to fix the dungeon finder rewards
Here’s my first fix :
DELETE FROM `lfg_dungeon_rewards`;
INSERT INTO `lfg_dungeon_rewards` (`dungeonId`,`maxLevel`,`firstQuestId`,`firstMoneyVar`,`firstXPVar`,`otherQuestId`,`otherMoneyVar`,`otherXPVar`) VALUES
(8,25,24882,0,0,24890,0,0), -- Shadowfang Keep
(6,25,24882,0,0,24890,0,0), -- Deadmines
(24,55,24885,0,0,24893,0,0), -- Zul'Farrak
(276,55,24885,0,0,24893,0,0), -- Blackrock Depths - Upper City
(30,60,24886,0,0,24894,0,0), -- Blackrock Depths - Prison
(164,34,24883,0,0,24891,0,0), -- Scarlet Monastery - Cathedral
(40,55,24885,0,0,24893,0,0), -- Stratholme - Main Gate
(140,64,24887,0,0,24895,0,0), -- Slave Pens
(148,70,24888,0,0,24896,0,0), -- Mana-Tombs
(137,64,24887,0,0,24895,0,0), -- Blood Furnace
(146,70,24888,0,0,24896,0,0), -- Underbog
(170,70,24888,0,0,24896,0,0), -- The Escape From Durnholde
(150,70,24888,0,0,24896,0,0), -- Sethekk Halls
(151,70,24888,0,0,24896,0,0), -- Shadow Labyrinth
(171,70,24888,0,0,24896,0,0), -- The Black Morass
(147,70,24888,0,0,24896,0,0), -- The Steamvault
(138,70,24888,0,0,24896,0,0), -- Shattered Halls
(172,70,24888,0,0,24896,0,0), -- The Mechanar
(173,70,24888,0,0,24896,0,0), -- The Botanica
(174,70,24888,0,0,24896,0,0), -- The Arcatraz
(198,70,24888,0,0,24896,0,0), -- Magisters' Terrace
(149,70,24888,0,0,24896,0,0), -- Auchenai Crypts
(242,80,24788,0,0,24789,0,0), -- Utgarde Keep H
(226,80,24788,0,0,24789,0,0), -- The Nexus H
(210,80,24788,0,0,24789,0,0), -- The Culling of Stratholme H
(241,80,24788,0,0,24789,0,0), -- Azjol-Nerub H
(219,80,24788,0,0,24789,0,0), -- Ahn'kahet: The Old Kingdom H
(215,80,24788,0,0,24789,0,0), -- Drak'Tharon Keep H
(221,80,24788,0,0,24789,0,0), -- Violet Hold H
(217,80,24788,0,0,24789,0,0), -- Gundrak H
(213,80,24788,0,0,24789,0,0), -- Halls of Stone H
(212,80,24788,0,0,24789,0,0), -- Halls of Lightning H
(211,80,24788,0,0,24789,0,0), -- The Oculus H
(205,80,24788,0,0,24789,0,0), -- Utgarde Pinnacle H
(249,80,24788,0,0,24789,0,0), -- Trial of the Champion H
(252,80,24788,0,0,24789,0,0), -- The Forge of Souls H
(254,80,24788,0,0,24789,0,0), -- Pit of Saron H
(256,80,24788,0,0,24789,0,0), -- Halls of Reflection H
(202,80,24790,0,0,24791,0,0), -- Utgarde Keep
(225,80,24790,0,0,24791,0,0), -- The Nexus
(204,80,24790,0,0,24791,0,0), -- Azjol-Nerub
(218,80,24790,0,0,24791,0,0), -- Ahn'kahet: The Old Kingdom
(214,80,24790,0,0,24791,0,0), -- Drak'Tharon Keep
(220,80,24790,0,0,24791,0,0), -- Violet Hold
(216,80,24790,0,0,24791,0,0), -- Gundrak
(208,80,24790,0,0,24791,0,0), -- Halls of Stone
(207,80,24790,0,0,24791,0,0), -- Halls of Lightning
(206,80,24790,0,0,24791,0,0), -- The Oculus
(203,80,24790,0,0,24791,0,0), -- Utgarde Pinnacle
(245,80,24790,0,0,24791,0,0), -- Trial of the Champion
(251,80,24790,0,0,24791,0,0), -- The Forge of Souls
(253,80,24790,0,0,24791,0,0), -- Pit of Saron
(255,80,24790,0,0,24791,0,0); -- Halls of Reflection
[/sql]
The dungeonID are based on http://www.trinitycore.org/t/trinitycore/ticket/292
But my fix doesn’t work for any dungeon. Somebody has an idea to finally fix that?
PS : I seek for a good and stable DBC reader, i’ve tried some DBC readers but without success
PS2 : Maybe be a core side fix too ?
Thanks for your help
Regards.
// Hope my english is understandable