diff options
| -rw-r--r-- | sql/updates/world/2015_05_22_08_world_335.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_22_08_world_335.sql b/sql/updates/world/2015_05_22_08_world_335.sql new file mode 100644 index 00000000000..9cdb7edf295 --- /dev/null +++ b/sql/updates/world/2015_05_22_08_world_335.sql @@ -0,0 +1,32 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (14661) AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(14661, 0, 0, 0, 0, 0, 100, 0, 3000, 5000, 4000, 6000, 11, 5416, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0,0,'Stinglasher - IC - cast Venom Sting'), +(14661, 0, 1, 0, 0, 0, 100, 0, 6000, 8000, 7000, 10000, 11, 6607, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0,0,'Stinglasher - IC - cast Lash'); + +UPDATE `creature_template` SET `InhabitType`=4, `AIName`='SmartAI' WHERE `entry`=14661; +UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (50074); +UPDATE `creature_addon` SET `path_id`=500740 WHERE `guid` IN (50074); + +DELETE FROM `waypoint_data` WHERE (`id`=500740); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(500740, 1, -5219.040039, 90.906799, 31.608503, 0, 0, 0, 0, 100, 0), +(500740, 2, -5224.050293, 76.003220, 29.438269, 0, 0, 0, 0, 100, 0), +(500740, 3, -5239.147949, 63.874466, 25.338007, 0, 0, 0, 0, 100, 0), +(500740, 4, -5238.693848, 49.682274, 24.432926, 0, 0, 0, 0, 100, 0), +(500740, 5, -5246.642578, 32.150028, 19.696297, 0, 0, 0, 0, 100, 0), +(500740, 6, -5261.720703, 17.697470, 18.217318, 0, 0, 0, 0, 100, 0), +(500740, 7, -5275.494629, 20.200960, 19.163641, 0, 0, 0, 0, 100, 0), +(500740, 8, -5287.398438, 15.724384, 19.484865, 0, 0, 0, 0, 100, 0), +(500740, 9, -5285.921875, -4.451639, 19.543159, 0, 0, 0, 0, 100, 0), +(500740, 10, -5266.689453, -10.566733, 15.15608, 0, 0, 0, 0, 100, 0), +(500740, 11, -5260.603027, -1.987386, 14.133003, 0, 0, 0, 0, 100, 0), +(500740, 12, -5260.889160, 16.419760, 17.921291, 0, 0, 0, 0, 100, 0), +(500740, 13, -5244.723145, 31.915073, 19.788879, 0, 0, 0, 0, 100, 0), +(500740, 14, -5240.108887, 48.679680, 24.157497, 0, 0, 0, 0, 100, 0), +(500740, 15, -5240.560547, 62.042046, 25.325819, 0, 0, 0, 0, 100, 0), +(500740, 16, -5225.194336, 76.540390, 29.50018, 0, 0, 0, 0, 100, 0), +(500740, 17, -5221.191406, 84.720314, 31.15358, 0, 0, 0, 0, 100, 0), +(500740, 18, -5207.856934, 125.004700, 33.70418, 0, 0, 0, 0, 100, 0), +(500740, 19, -5189.811523, 162.779144, 49.10691, 0, 0, 0, 0, 100, 0), +(500740, 20, -5185.788086, 183.261688, 49.97140, 0, 0, 0, 0, 100, 0); |