[Complete] Add Some Missing Azure Scalebane Spawns To Crystalsong Forest

TrinityCore Development TrinityCore Code Discussion
1

[CODE]-- Add some missing Azure Scalebane Spawns to crystalsong Forest
SET @GUID := 209190;
DELETE FROM creature WHERE guid BETWEEN @GUID AND @GUID+7;
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,unit_flags,dynamicflags) VALUES
(@GUID,31402,571,1,1,0,0,5220.886,591.7798,187.861328,4.866286,180,10,0,1,0,1,0,0),
(@GUID+1,31402,571,1,1,0,0,5344.32,595.7,183.07399,4.99164152,180,10,0,1,0,1,0,0),
(@GUID+2,31402,571,1,1,0,0,5411.67773,623.1622,178.355133,0.87266463,180,10,0,1,0,1,0,0),
(@GUID+3,31402,571,1,1,0,0,5434.40332,783.9654,182.770508,0.5726554,180,10,0,1,0,1,0,0),
(@GUID+4,31402,571,1,1,0,0,5464.40771,716.290344,171.820313,2.65290046,180,10,0,1,0,1,0,0),
(@GUID+5,31402,571,1,1,0,0,5573.34326,862.8543,161.738586,1.48352981,180,10,0,1,0,1,0,0),
(@GUID+6,31402,571,1,1,0,0,5659.52734,987.839844,174.5677,0.314159274,180,0,0,1,0,0,570688256,32),
(@GUID+7,31402,571,1,1,0,0,5660.18652,1028.454,174.562653,2.79252672,180,0,0,1,0,0,570688256,32);
– Addons for dead appearance
DELETE FROM creature_addon WHERE guid IN (@GUID+6,@GUID+7);
INSERT INTO creature_addon (guid,bytes2,auras) VALUES
(@GUID+6,1,29266),
(@GUID+7,1,29266);[/sql]

Thanks Malcrom, I love your fixes!!!

[/CODE]

2

I thought you said you were retired? or was that retarded?

/emoticons/default_smile.png

3

retarded most likely

4

Because I am a cool guy, here’s something related to the above post

UPDATE `creature_model_info` SET `bounding_radius`=0.465,`combat_reach`=1.5,`gender`=0 WHERE `modelid`=25195; -- Azure Scalebane
DELETE FROM `creature_template_addon` WHERE `entry`=31402;
INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
(31402,0,0,1,0, NULL); -- Azure Scalebane
[/sql]

Paradox and Bio, what's up with all the friendliness?
5

… retarded. Wrong word maybe?

6

WOW, thanks for your fixes Malcrom…Your awesome /emoticons/default_smile.png

7

Wow thanks Malcrom you are fag but still awesome

8

I’m retarded…less retarded than Kiper though /emoticons/default_smile.png