diff options
| -rw-r--r-- | sql/updates/world/2012_11_19_02_world_ysera.sql | 71 |
1 files changed, 71 insertions, 0 deletions
diff --git a/sql/updates/world/2012_11_19_02_world_ysera.sql b/sql/updates/world/2012_11_19_02_world_ysera.sql new file mode 100644 index 00000000000..1ab92cc4dee --- /dev/null +++ b/sql/updates/world/2012_11_19_02_world_ysera.sql @@ -0,0 +1,71 @@ +-- Dragonblight (Emerald Dragonshrine) +-- Ysera should be laying down +DELETE FROM `creature_addon` WHERE `guid`=108844; +INSERT INTO `creature_addon` (`guid`,`bytes1`) VALUES +(108844,3); +-- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +-- Grizzly Hills (Bloodmoon Isle) +-- Adding teleport +DELETE FROM `game_tele` WHERE `id`=1422; +INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES +(1422,4682.07,-5569.67,53.61,3.85,571,"BloodmoonIsle"); -- Teleport location (roughly): http://www.wowhead.com/maps?data=394:844258 +-- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +-- Bloodmoon worgen +UPDATE `creature` SET `spawndist`=2.5,`movementType`=1 WHERE `guid` IN (108834,108799,108829); +UPDATE `creature` SET `spawndist`=5,`movementType`=1 WHERE `guid` IN (108830,108828,108784); +UPDATE `creature` SET `spawndist`=6,`movementType`=1 WHERE `guid`=108784; +-- Bloodmoon Cultists +UPDATE `creature` SET `position_x`=4599.94,`position_y`=-5706.74,`position_z`=184.50,`orientation`=3.72,`spawndist`=5 WHERE `guid`=109406; +DELETE FROM `creature_addon` WHERE `guid` IN (109406,109407,109383,109412,109334,109385,109168,109147,109239,109240,109410,109411,109146,109169,109403,113585,109405,109408,109404); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`) VALUES +(109406,0,8),(109407,0,8),(109383,0,8), +(109412,0,1),(109334,0,1),(109168,0,1), +(109147,0,1),(109240,0,1),(109239,0,1), +(109411,0,1),(109410,0,1),(109169,0,1), +(109146,0,1),(109403,0,8),(113585,0,8), +(109405,0,8),(109408,0,8),(109404,1094040,0), +(109385,1093850,0); +DELETE FROM `creature` WHERE `guid` IN (113585,109404); +INSERT INTO `creature` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`curhealth`,`curmana`,`MovementType`) VALUES +(109404,27024,571,4676.16,-5575.82,53.61,0.85,120,6,9940,0,2), +(109385,26935,571,4550.15,-5493.45,2.19,0.85,120,6,9940,0,2); +-- Pathing Bloodmoon Cultist 1/2 +DELETE FROM `waypoint_data` WHERE `id` IN (1093850,1094040); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`) VALUES +(1093850,1,4550.159180,-5493.454102,2.198123,0), +(1093850,2,4560.156250,-5505.391113,2.247392,0), +(1093850,3,4568.288574,-5540.102051,2.325547,0), +(1093850,4,4570.309570,-5555.015625,3.725862,0), +(1093850,5,4593.584473,-5583.147461,17.485140,0), +(1093850,6,4640.961426,-5587.870117,43.030090,0), +(1093850,7,4663.515625,-5596.525391,51.983559,0), +(1093850,8,4666.571777,-5585.750488,53.366554,0), +(1093850,9,4679.179199,-5572.404297,53.618946,0), +(1093850,10,4659.498047,-5593.301270,50.779484,0), +(1093850,11,4633.121582,-5588.121582,38.891140,0), +(1093850,12,4607.767090,-5586.987793,24.787226,0), +(1093850,13,4588.015625,-5577.846680,13.770270,0), +(1093850,14,4570.691895,-5554.702148,3.706614,0), +(1093850,15,4564.821289,-5511.260742,2.249003,0), +-- Pathing Bloodmoon Cultist 2/2 +(1094040,1,4676.167969,-5575.823730,53.619122,3000), +(1094040,2,4665.977051,-5586.124512,53.232887,0), +(1094040,3,4668.571289,-5599.335938,53.233620,0), +(1094040,4,4678.922363,-5609.084961,58.034130,0), +(1094040,5,4691.944336,-5631.230469,74.489761,0), +(1094040,6,4692.178711,-5648.943359,79.715866,0), +(1094040,7,4675.570313,-5656.392090,85.288292,0), +(1094040,8,4643.766113,-5657.881836,105.69108,0), +(1094040,9,4630.772461,-5652.050293,110.18435,0), +(1094040,10,4647.054688,-5657.352539,103.57666,0), +(1094040,11,4674.222656,-5656.737793,85.933739,0), +(1094040,12,4692.171387,-5649.309082,79.797195,0), +(1094040,13,4692.635254,-5633.777832,75.973076,0), +(1094040,14,4677.485352,-5607.687500,57.116299,0), +(1094040,15,4665.121094,-5596.857910,52.347866,0), +(1094040,16,4666.613770,-5585.797363,53.372700,0); +-- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +-- Varlam +UPDATE `creature` SET `position_x`=4700.48,`position_y`=-5568.50,`position_z`=53.61,`orientation`=3.39 WHERE `guid`=113673; +-- Shade of Arugal +UPDATE `creature` SET `position_x`=4590.02,`position_y`=-5712.43,`position_z`=184.50,`orientation`=1.01 WHERE `guid`=108492; |