DB/Misc: Ysera@Emerald Dragonshrine should lay down and ground work on Bloodmoon Isle

Closes #8305

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;