Skip to content

[DB/SPAWNS] [FIX] Caladis Brightspear & Silver Covenant Sentinel missing spawns #9082

Closed
Foldor opened this Issue Jan 28, 2013 · 3 comments

3 participants

@Foldor
Foldor commented Jan 28, 2013

Missing spawns from the Frozen Halls subzone in Icecrown - visible only if you have http://www.wowhead.com/spell=71313 (should be given when you accept the quest Reforging the Sword (Alliance version) (afaik).

spawns taken from 434 sniff: http://paste2.org/p/2805914

Database: 335.50 + all updates upto & including da080ac

SET @CGUID := XXXXX; -- set by TDB team (3)

DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+2;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(@CGUID+0, 36656, 571, 1, 1, 5647.669, 2106.526, 798.1375, 4.764749, 120, 0, 0), -- Silver Covenant Sentinel (Area: 4862)
(@CGUID+1, 36656, 571, 1, 1, 5657.819, 2105.712, 798.1375, 4.590216, 120, 0, 0), -- Silver Covenant Sentinel (Area: 4862)
(@CGUID+2, 36624, 571, 1, 1, 5652.733, 2106.208, 798.1375, 4.572762, 120, 0, 0); -- Caladis Brightspear (Area: 4862)

DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+2;
INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
(@CGUID+0, 0, 0, 0x10000, 0x1, 0, '71311'),
(@CGUID+1, 0, 0, 0x10000, 0x1, 0, '71311'),
(@CGUID+2, 0, 0, 0x10000, 0x1, 0, '71311');
@Aokromes
TrinityCore member

Don't use creature_addon if all spawns from a mob shares the same data, use creature_template_addon instead.

@Foldor
Foldor commented Jan 28, 2013

When i followed the TC wiki it says (http://collab.kpsn.org/display/tc/Creature+addon+tc2#Creatureaddontc2-guid/entry)

"For creature_addon, this field signifies a unique creature guid. It will affect just that creature whose GUID matches the one specified here."

These creatures can be found both at Quel'delar's rest, just outside of the Argent Tournament, and in the Frozen Halls, as far as i know, only the Frozen Halls copy's have this aura, so i thought creature_addon would be the way to go, but if creature_template_addon is still the correct way of doing it, i'll change it..

@Aokromes
TrinityCore member

You don't have read me :)

"These creatures can be found both at Quel'delar's rest, just outside of the Argent Tournament, and in the Frozen Halls, as far as i know, only the Frozen Halls copy's have this aura, so i thought creature_addon would be the way to go"

So, yes c_a is correct.

@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
foldor DB/Creature: add missing Silver Convenant in Frozen Halls
Closes #9082
1039321
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.