diff options
| -rw-r--r-- | sql/updates/world/2011_03_23_4_world_creature.sql | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/sql/updates/world/2011_03_23_4_world_creature.sql b/sql/updates/world/2011_03_23_4_world_creature.sql new file mode 100644 index 00000000000..9d9edec6452 --- /dev/null +++ b/sql/updates/world/2011_03_23_4_world_creature.sql @@ -0,0 +1,42 @@ +-- Spawn Missing Argent Crusaders +-- Redid Exisiting to make Adding simpler +SET @GUID=54706; +DELETE FROM `creature` WHERE id IN (28029,28026); +INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES +(107427,28029,571,1,1,26231,0,5514,-2398.25,292.502,1.5708,300,0,0,9572,3561,0,0,0,0,0), +(107428,28029,571,1,1,26228,0,5485.95,-2500.14,292.433,0.934353,300,0,0,9572,3561,0,0,0,0,0), +(107429,28029,571,1,1,26229,0,5495.16,-2439.33,292.498,5.44414,300,0,0,9572,3561,0,0,0,0,0), +(107430,28029,571,1,1,26230,0,5490.07,-2495.2,292.429,3.93988,300,0,0,9572,3561,0,0,0,0,0), +(107431,28029,571,1,1,26230,0,5496.85,-2383.57,292.502,2.30383,300,0,0,9572,3561,0,0,0,0,0), +(@GUID+0,28029,571,1,1,0,0,5442.812,-2554.325,297.783,1.554819,300,0,0,1,1,0,0,0,0,0), +(@GUID+1,28029,571,1,1,0,0,5451.548,-2516.311,292.445,0.1570796,300,0,0,1,1,0,0,0,0,0), +(@GUID+2,28029,571,1,1,0,0,5445.436,-2513.325,292.5019,1.64061,300,0,0,1,1,0,0,0,0,0), +(@GUID+3,28029,571,1,1,0,0,5384.553,-2402.976,292.5019,0.8726646,300,0,0,1,1,0,0,0,0,0), +(@GUID+4,28029,571,1,1,0,0,5386.06,-2421.43,292.5019,1.53589,300,0,0,1,1,0,0,0,0,0), +(@GUID+5,28029,571,1,1,0,0,5383.483,-2472.9,292.5019,1.570796,300,0,0,1,1,0,0,0,0,0), +(@GUID+6,28029,571,1,1,0,0,5400.021,-2448.991,292.5019,2.321288,300,0,0,1,1,0,0,0,0,0), +(@GUID+7,28029,571,1,1,0,0,5369.318,-2443.405,292.5019,0.9424778,300,0,0,1,1,0,0,0,0,0), +(@GUID+8,28029,571,1,1,0,0,5409.107,-2361.323,292.5019,0.6283185,300,0,0,1,1,0,0,0,0,0), +(@GUID+9,28029,571,1,1,0,0,5464.651,-2496.451,292.5019,1.48353,300,0,0,1,1,0,0,0,0,0), +(@GUID+10,28029,571,1,1,0,0,5435.183,-2513.578,292.445,0.918852,300,0,0,1,1,0,0,0,0,0), +(@GUID+11,28029,571,1,1,0,0,5400.03,-2506.189,292.5019,1.553343,300,0,0,1,1,0,0,0,0,0), +(@GUID+12,28029,571,1,1,0,0,5450.897,-2457.951,292.5019,1.553343,300,0,0,1,1,0,0,0,0,0), +-- rampaging Geist +(107193,28026,571,1,1,25286,0,5497.21,-2080.43,240.865,0.857485,300,5,0,10635,0,0,1,0,0,0), +(107194,28026,571,1,1,25402,0,5511.68,-2358.28,292.441,2.71292,300,5,0,10635,0,0,1,0,0,0), +(107195,28026,571,1,1,25402,0,5512.46,-2455.17,292.424,2.97264,300,5,0,10635,0,0,1,0,0,0), +(107196,28026,571,1,1,25286,0,5519.86,-2423.45,292.473,3.83817,300,5,0,10635,0,0,1,0,0,0), +(107197,28026,571,1,1,25286,0,5488.13,-2497.19,292.429,3.93989,300,5,0,10635,0,0,1,0,0,0), +(32067,28026,571,1,1,0,0,5429.262,-2486.59,292.5296,2.737376,300,5,0,10635,0,0,1,0,0,0), +(32068,28026,571,1,1,0,0,5408.888,-2479.563,292.5296,0.7370623,300,5,0,10635,0,0,1,0,0,0), +(32070,28026,571,1,1,0,0,5419.276,-2505.731,292.5433,4.015942,300,5,0,10635,0,0,1,0,0,0), +(32071,28026,571,1,1,0,0,5384.713,-2463.133,292.843,2.721308,300,5,0,10635,0,0,1,0,0,0), +(32073,28026,571,1,1,0,0,5383.064,-2413.345,292.5399,6.069617,300,5,0,10635,0,0,1,0,0,0), +(32074,28026,571,1,1,0,0,5394.180,-2442.885,292.468,2.731286,300,5,0,10635,0,0,1,0,0,0), +(518,28026,571,1,1,0,0,5452.489,-2447.378,292.5435,0.3663993,300,5,0,10635,0,0,1,0,0,0); + +-- Addon data +DELETE FROM `creature_template_addon` WHERE `entry` IN (28029,28026); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(28029,0,0,1,375, NULL), -- Argent Crusader +(28026,0,0,1,0, NULL); -- Rampaging Geist |