diff options
31 files changed, 1659 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_01_00_world_2015_05_26_04.sql b/sql/updates/world/2015_07_01_00_world_2015_05_26_04.sql new file mode 100644 index 00000000000..29b0e1afdfe --- /dev/null +++ b/sql/updates/world/2015_07_01_00_world_2015_05_26_04.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (20748); +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 +(20748,0,0,0,25,0,100,0,0,0,0,0,11,37691,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Thunderlord Dire Wolf - On Reset - Cast Stealth Detection'), +(20748,0,1,0,0,0,100,0,4000,6000,10000,11000,11,5781,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Thunderlord Dire Wolf - IC - Cast Threatening Growl'), +(20748,0,2,0,8,0,100,0,32578,0,120000,120000,33,21142,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Thunderlord Dire Wolf - on spell hit - Credit quest'); diff --git a/sql/updates/world/2015_07_01_01_world_2015_05_21_02.sql b/sql/updates/world/2015_07_01_01_world_2015_05_21_02.sql new file mode 100644 index 00000000000..386bbf48d09 --- /dev/null +++ b/sql/updates/world/2015_07_01_01_world_2015_05_21_02.sql @@ -0,0 +1,55 @@ +-- +-- DB/Quest: The Earthbinder +-- Tola'thion SAI +SET @ENTRY := 19293; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,19,0,100,0,10349,0,0,0,45,1,0,0,0,0,0,19,19294,50,0,0,0,0,0,"Tola'thion - On Quest 'The Earthbinder' Taken - Set Data 1 0"); + +-- Earthbinder Galandria Nightbreeze SAI +SET @ENTRY := 19294; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,38,0,100,0,1,0,0,0,1,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Data Set 1 0 - Say Line 0"), +(@ENTRY,0,1,2,20,0,100,0,10349,0,0,0,80,@ENTRY*100+00,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Quest 'The Earthbinder' Finished - Run Script"), +(@ENTRY,0,2,5,61,0,100,0,10349,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Quest 'The Earthbinder' Finished - Set Active On"), +(@ENTRY,0,3,0,38,0,100,0,2,0,0,0,80,@ENTRY*100+01,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Data Set 2 0 - Run Script"), +(@ENTRY,0,4,0,11,0,100,0,0,0,0,0,81,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Respawn - Set Npc Flags Gossip & Questgiver"), +(@ENTRY,0,5,0,61,0,100,0,10349,0,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Quest 'The Earthbinder' Finished - Set Run Off"); + +-- Actionlist SAI +SET @ENTRY := 1929400; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9; +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 +(@ENTRY,9,0,0,0,0,100,0,3000,3000,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Script - Set Npc Flag "), +(@ENTRY,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,21,50,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Script - Set Orientation Closest Player"), +(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Script - Say Line 1"), +(@ENTRY,9,3,0,0,0,100,0,6000,6000,0,0,69,0,0,0,0,0,0,8,0,0,0,-286.7666,4729.429,18.4418,1.727876,"Earthbinder Galandria Nightbreeze - On Script - Move To Position"), +(@ENTRY,9,4,0,0,0,100,0,11000,11000,0,0,5,16,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Script - Play Emote 16"), +(@ENTRY,9,5,0,0,0,100,0,3000,3000,0,0,5,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Script - Play Emote 0"), +(@ENTRY,9,6,0,0,0,100,0,0,0,0,0,50,184450,60,0,0,0,0,8,0,0,0,-287.0193,4731.628,18.21704,2.583081,"Earthbinder Galandria Nightbreeze - On Script - Summon Gameobject 'Crimson Crystal Shard'"), +(@ENTRY,9,7,0,0,0,100,0,4000,4000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthbinder Galandria Nightbreeze - On Script - Say Line 2"), +(@ENTRY,9,8,0,0,0,100,0,0,0,0,0,12,20599,3,60000,1,0,0,8,0,0,0,-288.1897,4733.63,18.29823,5.044002,"Earthbinder Galandria Nightbreeze - On Script - Summon Creature 'Lured Colossus'"); + +-- Actionlist SAI +SET @ENTRY := 1929401; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9; +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 +(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-294.765991,4715.080078,28.186199,0.209440,"On Script - Move To Position"), +(@ENTRY,9,1,0,0,0,100,0,13000,13000,0,0,66,0,0,0,0,0,0,1,0,0,0,0,0,0,0.209440,"On Script - Set Orientation Home Position"), +(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,81,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Set Npc Flags Gossip & Questgiver"); + +-- Lured Colossus SAI +SET @ENTRY := 20599; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,6,0,100,0,0,0,0,0,45,2,0,0,0,0,0,19,19294,50,0,0,0,0,0,"Lured Colossus - On Just Died - Set Data 2 0"); + +DELETE FROM `creature_text` WHERE `entry`=19294; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(19294, 0, 0, 'Up here on the hill, $n.', 15, 0, 100, 0, 0, 0, 18293, 0, 'Earthbinder Galandria Nightbreeze'), +(19294, 1, 0, 'I have an idea. Let\'s plant this shard in the ground and see what happens', 12, 0, 100, 0, 0, 0, 18289, 0, 'Earthbinder Galandria Nightbreeze'), +(19294, 2, 0, 'The evil emanating from the crystal shard has lured one of the colossi. Put it down quick!', 12, 0, 100, 0, 0, 0, 18291, 0, 'Earthbinder Galandria Nightbreeze'); diff --git a/sql/updates/world/2015_07_01_02_world_2015_05_21_00.sql b/sql/updates/world/2015_07_01_02_world_2015_05_21_00.sql new file mode 100644 index 00000000000..c076920bbba --- /dev/null +++ b/sql/updates/world/2015_07_01_02_world_2015_05_21_00.sql @@ -0,0 +1,2 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (37748) AND `SourceGroup`=6; diff --git a/sql/updates/world/2015_07_01_03_world_2015_05_26_03.sql b/sql/updates/world/2015_07_01_03_world_2015_05_26_03.sql new file mode 100644 index 00000000000..30b5103caa8 --- /dev/null +++ b/sql/updates/world/2015_07_01_03_world_2015_05_26_03.sql @@ -0,0 +1,3 @@ +-- +DELETE FROM `spell_group` WHERE `id`=1001 AND `spell_id` IN (45694, 20875, 25804, 25722, 25037); +INSERT INTO `spell_group` (`id`, `spell_id`) VALUES (1001, 45694), (1001, 20875), (1001, 25804), (1001, 25722), (1001, 25037); diff --git a/sql/updates/world/2015_07_01_04_world_2015_05_26_02.sql b/sql/updates/world/2015_07_01_04_world_2015_05_26_02.sql new file mode 100644 index 00000000000..6f6092f2054 --- /dev/null +++ b/sql/updates/world/2015_07_01_04_world_2015_05_26_02.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (12479, 12480, -12480) AND `spell_effect` IN (12480, 530, -530); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(12479, 12480, 0, 'Hex of Jammal''an'), +(12480, 530, 0, 'Hex of Jammal''an'), +(-12480, -530, 0, 'Hex of Jammal''an'); + +UPDATE `smart_scripts` SET `event_type`=0, `Comment`= "Jammal'an the Prophet - In combat - Cast 'Hex of Jammal'an' (Phase 1)" WHERE `entryorguid`=5710 AND `source_Type`=0 AND `id`=5; diff --git a/sql/updates/world/2015_07_01_05_world_2015_05_26_01.sql b/sql/updates/world/2015_07_01_05_world_2015_05_26_01.sql new file mode 100644 index 00000000000..7c8a18ed042 --- /dev/null +++ b/sql/updates/world/2015_07_01_05_world_2015_05_26_01.sql @@ -0,0 +1,40 @@ +-- +DELETE FROM `creature_formations` WHERE `leaderGUID`=26233; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES +(26233,26233,0,0,2),(26233,26192,15,0,2),(26233,26194,15,90,2),(26233,26193,9,0,2),(26233,26195,9,90,2); +UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (26233); +UPDATE `creature_addon` SET `path_id`=262330 WHERE `guid` IN (26233); +DELETE FROM `creature_addon` WHERE `guid` IN (26233); +INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (26233, 262330); +DELETE FROM `waypoint_data` WHERE `id` IN (262330); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(262330, 1,-1317.949951, -926.414978, 1.9346, 0, 0, 0, 0, 100, 0), +(262330, 2,-1244.693726, -980.329773, -4.920392, 0, 0, 0, 0, 100, 0), +(262330, 3,-1193.669312, -948.340393, -3.643325, 0, 0, 0, 0, 100, 0), +(262330, 4,-1182.622681, -859.417419, -11.058956, 0, 0, 0, 0, 100, 0), +(262330, 5,-1183.541138, -796.475952, -36.551662, 0, 0, 0, 0, 100, 0), +(262330, 6,-1182.812988, -740.116638, -52.754967, 0, 0, 0, 0, 100, 0), +(262330, 7,-1200.200806, -605.367249, -57.754887, 0, 0, 0, 0, 100, 0), +(262330, 8,-1242.377563, -494.067078, -57.610630, 0, 0, 0, 0, 100, 0), +(262330, 9,-1468.878052, -522.602173, -55.496475, 0, 0, 0, 0, 100, 0), +(262330, 10,-1551.133789, -656.098145, -50.817574, 0, 0, 0, 0, 100, 0), +(262330, 11,-1394.677490, -802.561279, -21.880009, 0, 0, 0, 0, 100, 0), +(262330, 12,-1317.949951, -926.414978, 1.9346, 0, 0, 0, 0, 100, 0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=26213; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES +(26213,26213,0,0,2),(26213,26185,15,0,2),(26213,26207,15,90,2),(26213,26186,9,0,2),(26213,26187,9,90,2); +UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (26213); +UPDATE `creature_addon` SET `path_id`=262130 WHERE `guid` IN (26213); +DELETE FROM `creature_addon` WHERE `guid` IN (26213); +INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (26213, 262130); +DELETE FROM `waypoint_data` WHERE `id` IN (262130); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(262130, 1,-2545.065918, 21.190157, 11.805480, 0, 0, 0, 0, 100, 0), +(262130, 2,-2487.883789, 100.192146, 33.786736, 0, 0, 0, 0, 100, 0), +(262130, 3,-2420.558350, 88.399445, 38.040539, 0, 0, 0, 0, 100, 0), +(262130, 4,-2318.995361, 115.247169, 50.718586, 0, 0, 0, 0, 100, 0), +(262130, 5,-2284.748779, 27.045509, 22.492968, 0, 0, 0, 0, 100, 0), +(262130, 6,-2349.130615, -61.506725, -8.763674, 0, 0, 0, 0, 100, 0); + +UPDATE `creature` SET `MovementType`=1, `spawndist`=15 WHERE `guid` IN (26214, 26231, 26189, 26188, 26196, 26184, 26210, 26209, 26211, 26232, 26190, 26191, 26212); diff --git a/sql/updates/world/2015_07_01_06_world_2015_05_25_00.sql b/sql/updates/world/2015_07_01_06_world_2015_05_25_00.sql new file mode 100644 index 00000000000..ae68df82667 --- /dev/null +++ b/sql/updates/world/2015_07_01_06_world_2015_05_25_00.sql @@ -0,0 +1,6 @@ +-- +-- Forsaken Crossbowman SAI +SET @ENTRY := 23883; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=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 +(@ENTRY,0,0,0,1,0,100,0,0,2000,2000,3000,11,61512,0,0,0,0,0,19,23803,200,0,0,0,0,0,"Forsaken Crossbowman - Out of Combat - Cast 'Shoot'"); diff --git a/sql/updates/world/2015_07_01_07_world_2015_05_24_08.sql b/sql/updates/world/2015_07_01_07_world_2015_05_24_08.sql new file mode 100644 index 00000000000..fa80ae132fd --- /dev/null +++ b/sql/updates/world/2015_07_01_07_world_2015_05_24_08.sql @@ -0,0 +1,94 @@ +-- Complete UP Movement +SET @NPC := 126159; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=408.6479,`position_y`=-247.8646,`position_z`=105.1593 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,408.6479,-247.8646,105.1593,0,0,0,0,100,0), +(@PATH,2,413.1479,-247.3646,105.4093,0,0,0,0,100,0), +(@PATH,3,417.3979,-247.1146,105.4093,0,0,0,0,100,0), +(@PATH,4,421.3979,-246.8646,105.1593,0,0,0,0,100,0), +(@PATH,5,424.6479,-246.8646,105.4093,0,0,0,0,100,0), +(@PATH,6,431.6479,-246.3646,105.1593,0,0,0,0,100,0), +(@PATH,7,437.3979,-245.8646,105.1593,0,0,0,0,100,0), +(@PATH,8,439.8979,-245.6146,105.1593,0,6000,0,0,100,0), +(@PATH,9,439.8979,-245.6146,105.1593,0,0,0,0,100,0), +(@PATH,10,437.3979,-245.8646,105.1593,0,0,0,0,100,0), +(@PATH,11,431.6479,-246.3646,105.1593,0,0,0,0,100,0), +(@PATH,12,424.6479,-246.8646,105.4093,0,0,0,0,100,0), +(@PATH,13,421.3979,-246.8646,105.1593,0,0,0,0,100,0), +(@PATH,14,417.3979,-247.1146,105.4093,0,0,0,0,100,0), +(@PATH,15,413.1479,-247.3646,105.4093,0,0,0,0,100,0), +(@PATH,16,408.6479,-247.8646,105.1593,0,6000,0,0,100,0); + +SET @NPC := 126083; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=281.2139,`position_y`=-383.5794,`position_z`=90.28523 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH, 10, 273.909, -398.059, 90.1069, 0, 10, 0, 0, 100, 0), +(@PATH, 9, 262.177, -400.701, 83.5446, 0, 10, 0, 0, 100, 0), +(@PATH, 8, 248.65, -398.957, 75.1077, 0, 10, 0, 0, 100, 0), +(@PATH, 7, 262.177, -400.701, 83.5446, 0, 10, 0, 0, 100, 0), +(@PATH, 6, 273.909, -398.059, 90.1069, 0, 10, 0, 0, 100, 0), +(@PATH, 5, 281.51, -396.934, 89.9561, 0, 10, 0, 0, 100, 0), +(@PATH, 4, 281.066, -384.517, 90.0477, 0, 10, 0, 0, 100, 0), +(@PATH, 3, 263.144, -381.767, 96.7176, 0, 10, 0, 0, 100, 0), +(@PATH, 2, 248.789, -383.987, 104.753, 0, 10, 0, 0, 100, 0), +(@PATH, 1, 263.144, -381.767, 96.7176, 0, 10, 0, 0, 100, 0); + +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=26670 AND `source_type`=0 AND `id`=0 AND `link`=1; + +DELETE FROM `creature_formations` WHERE `leaderGUID`=126083; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(126083, 126087, 3, 270, 2, 0, 0), +(126083, 126088, 3, 90, 2, 0, 0), +(126083, 126083, 0, 0, 2, 0, 0); + + +SET @NPC := 126086; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH, 8, 238.128, -450.66, 104.736, 0, 10, 0, 0, 100, 0), +(@PATH, 7, 236.583, -435.635, 104.736, 0, 10, 0, 0, 100, 0), +(@PATH, 6, 236.444, -449.692, 104.736, 0, 10, 0, 0, 100, 0), +(@PATH, 5, 238.128, -450.66, 104.736, 0, 10, 0, 0, 100, 0), +(@PATH, 4, 309.006, -451.589, 104.718, 0, 10, 0, 0, 100, 0), +(@PATH, 3, 310.79, -451.589, 104.718, 0, 10, 0, 0, 100, 0), +(@PATH, 2, 310.682, -467.433, 104.718, 0, 10, 0, 0, 100, 0), +(@PATH, 1, 310.79, -451.589, 104.718, 0, 10, 0, 0, 100, 0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=126086; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(126086, 126078, 5, 180, 2, 0, 0), +(126086, 126081, 5, 90, 2, 0, 0), +(126086, 126082, 5, 270, 2, 0, 0), +(126086, 126086, 0, 0, 2, 0, 0); + +SET @NPC := 126111; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH, 7, 368.053, -432.959, 75.1209, 0, 10, 0, 0, 100, 0), +(@PATH, 6, 402.875, -428.319, 75.1263, 0, 10, 0, 0, 100, 0), +(@PATH, 5, 407.49, -441.521, 75.0988, 0, 10, 0, 0, 100, 0), +(@PATH, 4, 429.311, -447.42, 75.1166, 0, 10, 0, 0, 100, 0), +(@PATH, 3, 428.506, -467.335, 75.1153, 0, 10, 0, 0, 100, 0), +(@PATH, 2, 400.957, -455.234, 75.1132, 0, 10, 0, 0, 100, 0), +(@PATH, 1, 372.02, -450.569, 75.1308, 0, 10, 0, 0, 100, 0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=126111; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(126111, 126110, 3, 280, 2, 0, 0), +(126111, 126111, 0, 0, 2, 0, 0); diff --git a/sql/updates/world/2015_07_01_08_world_2015_05_24_07.sql b/sql/updates/world/2015_07_01_08_world_2015_05_24_07.sql new file mode 100644 index 00000000000..9e9ef5e50e1 --- /dev/null +++ b/sql/updates/world/2015_07_01_08_world_2015_05_24_07.sql @@ -0,0 +1,30 @@ +-- Dragonflayer Fanatic +DELETE FROM `waypoints` WHERE `entry`=26553; +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`) VALUES +(26553,1,467.5089,-325.5417,104.0859), +(26553,2,483.179,-325.046,104.0471); + +-- Dragonflayer Fanatic SAI +SET @GUID := -126160; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=26553; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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 +(@GUID,0,0,0,25,0,100,0,0,0,0,0,53,0,26553,1,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Fanatic - On Reset - Start Waypoint"), +(@GUID,0,1,0,40,0,100,0,1,26553,0,0,80,12616000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Fanatic - On Waypoint 1 Reached - Run Script"), +(@GUID,0,2,0,40,0,100,0,2,26553,0,0,80,12616001,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Fanatic - On Waypoint 2 Reached - Run Script"), +(@GUID,0,3,0,1,1,100,0,2000,2000,2000,2000,10,274,25,5,22,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Fanatic - Out of Combat - Play Random Emote (274, 25, 5, 22)"); + +-- Actionlist SAI +SET @ENTRY := 12616000; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9; +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 +(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,54,35000,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Pause Waypoint"), +(@ENTRY,9,1,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Set Event Phase 1"), +(@ENTRY,9,2,0,0,0,100,0,35000,35000,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Set Event Phase 2"); + +-- Actionlist SAI +SET @ENTRY := 12616001; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9; +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 +(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,54,15000,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Pause Waypoint"), +(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,5.986479,"On Script - Set Orientation 5,986479"); diff --git a/sql/updates/world/2015_07_01_09_world_2015_05_24_06.sql b/sql/updates/world/2015_07_01_09_world_2015_05_24_06.sql new file mode 100644 index 00000000000..756b2d569cf --- /dev/null +++ b/sql/updates/world/2015_07_01_09_world_2015_05_24_06.sql @@ -0,0 +1,45 @@ +-- DB/Quest: Escape from the Staging Grounds +DELETE FROM `waypoints` WHERE `entry`=20763; +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`) VALUES +(20763, 1, 4081.3, 2296.6, 110.75), +(20763, 2, 4095.3, 2296.37, 108.392), +(20763, 3, 4123.42, 2297.51, 104.368), +(20763, 4, 4146.48, 2298.85, 102.475), +(20763, 5, 4169.75, 2301.11, 104.503), +(20763, 6, 4181.37, 2301.19, 108.692), +(20763, 7, 4195.51, 2301.28, 113.981), +(20763, 8, 4215.69, 2295.79, 122.162), +(20763, 9, 4229.79, 2295.09, 127.068), +(20763, 10, 4250.86, 2293.49, 128.848), +(20763, 11, 4271.72, 2290, 125.243), +(20763, 12, 4277.21, 2276.97, 125.337), +(20763, 13, 4269.13, 2262.97, 127.868), +(20763, 14, 4262.07, 2250.73, 131.257), +(20763, 15, 4253.95, 2236.66, 134.959), +(20763, 16, 4249.61, 2220.86, 137.445), +(20763, 17, 4251.74, 2186.12, 137.08), +(20763, 18, 4252, 2172.27, 137.678); + +-- Captured Protectorate Vanguard SAI +SET @ENTRY := 20763; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,1,19,0,100,0,10425,0,0,0,1,0,0,0,0,0,0,21,10,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Quest 'Escape from the Staging Grounds' Taken - Say Line 0"), +(@ENTRY,0,1,2,61,0,100,0,10425,0,0,0,53,0,20763,0,0,0,2,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Quest 'Escape from the Staging Grounds' Taken - Start Waypoint"), +(@ENTRY,0,2,14,61,0,100,0,10425,0,0,0,64,1,0,0,0,0,0,21,10,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Quest 'Escape from the Staging Grounds' Taken - Store Targetlist"), +(@ENTRY,0,7,0,40,0,100,0,16,20763,0,0,54,4000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 16 Reached - Pause Waypoint"), +(@ENTRY,0,8,10,40,0,100,0,17,20763,0,0,15,10425,0,0,0,0,0,12,1,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 17 Reached - Quest Credit 'Escape from the Staging Grounds'"), +(@ENTRY,0,9,0,6,0,100,0,0,0,0,0,6,10425,0,0,0,0,0,12,1,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Just Died - Fail Quest 'Escape from the Staging Grounds'"), +(@ENTRY,0,10,0,61,0,100,0,17,20763,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 17 Reached - Say Line 1"), +(@ENTRY,0,11,12,40,0,100,0,18,20763,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 18 Reached - Say Line 2"), +(@ENTRY,0,12,13,61,0,100,0,18,20763,0,0,11,35517,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 18 Reached - Cast 'Teleport'"), +(@ENTRY,0,13,0,61,0,100,0,18,20763,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 18 Reached - Despawn In 3000 ms"), +(@ENTRY,0,14,0,61,0,100,0,10425,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Quest 'Escape from the Staging Grounds' Taken - Set Npc Flag "), +(@ENTRY,0,15,0,11,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Respawn - Set Npc Flag Questgiver"); + +DELETE FROM `creature_text` WHERE `entry`=20763; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES +(20763, 0, 0, 'We''re not too far from the Protectorate Watch Post, $n. This way!', 12, 0, 100, 0, 0, 0, 18566, 'Captured Protectorate Vanguard to Player'), +(20763, 1, 0, 'Commander! This fleshling rescued me!', 12, 0, 100, 0, 0, 0, 18567, 'Captured Protectorate Vanguard to Player'), +(20763, 2, 0, '%s salutes Commander Ameer.', 16, 0, 100, 0, 0, 0, 18568, 'Captured Protectorate Vanguard to Player'); diff --git a/sql/updates/world/2015_07_01_10_world_2015_05_24_05.sql b/sql/updates/world/2015_07_01_10_world_2015_05_24_05.sql new file mode 100644 index 00000000000..2b3641b257c --- /dev/null +++ b/sql/updates/world/2015_07_01_10_world_2015_05_24_05.sql @@ -0,0 +1,10 @@ +-- Scarlet Hound +DELETE FROM `creature` WHERE `id` IN (10979); +DELETE FROM `creature_addon` WHERE `guid` IN (52633, 52634, 52635, 52637, 52641, 52662, 52664, 52665, 52666, 52667, 52668); +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=10979; +DELETE FROM `smart_scripts` WHERE `entryorguid`=10979 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=1831 AND `source_type`=0 AND `id`=2; +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 +(1831, 0, 2, 0, 25, 0, 100, 0, 0, 0, 0, 0, 11, 17164, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Scarlet Hunter - On Reset - Cast to summon Scarlet Hound'), +(10979, 0, 0, 0, 0, 0, 100, 0, 3000, 7000, 6000, 9000, 11, 17260, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0,0,'Scarlet Hound - IC - Cast Bite'), +(10979, 0, 1, 0, 0, 0, 100, 0, 5000, 10000, 22000, 25000, 11, 59274, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Scarlet Hound - IC - Furious Howl'); diff --git a/sql/updates/world/2015_07_01_11_world_2015_05_24_04.sql b/sql/updates/world/2015_07_01_11_world_2015_05_24_04.sql new file mode 100644 index 00000000000..c36e6a2cc55 --- /dev/null +++ b/sql/updates/world/2015_07_01_11_world_2015_05_24_04.sql @@ -0,0 +1,902 @@ +-- Complete Grizzlyhills Movement +DELETE FROM `creature_addon` WHERE `guid` IN (109382, 109390,109409,110794, 110792,110787,110793, 110791,110797,110796,110795,110799,110798, 110801,98066, 98056, 98060, 118835, 98047, 98059, 98053); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(118835,0,0,1,1,0, ''), +(98047,0,0,1,1,0, ''), +(98059,0,0,0,1,69, ''), +(98060,0,0,0,1,234, ''), +(98053,0,0,0,1,1, ''), +(98056,0,0,0,1,234, ''), +(98066,0,0,0,1,234, ''), +(110801,0,0,0,1,234, ''), +(110798,0,0,0,1,234, ''), +(110799,0,0,0,1,234, ''), +(110795,0,0,0,1,234, ''), +(110796,0,0,0,1,234, ''), +(110797,0,0,0,1,234, ''), +(110791,0,0,0,1,234, ''), +(110793,0,0,0,1,234, ''), +(110787,0,0,0,1,234, ''), +(110792,0,0,0,1,234, ''), +(110794,0,0,0,1,234, ''), +(109409,0,0,8,1,0, ''), +(109390,0,0,8,1,0, ''), +(109382,0,0,8,1,0, ''); + +SET @NPC := 109402; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4642.88,`position_y`=-5573.969,`position_z`=43.38401 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4642.88,-5573.969,43.38401,0,0,0,0,100,0), +(@PATH,2,4642.38,-5575.719,43.63401,0,0,0,0,100,0), +(@PATH,3,4639.13,-5580.469,42.88401,0,0,0,0,100,0), +(@PATH,4,4637.13,-5583.719,41.63401,0,0,0,0,100,0), +(@PATH,5,4635.38,-5586.219,40.38401,0,0,0,0,100,0), +(@PATH,6,4635.204,-5586.526,40.13166,0,0,0,0,100,0), +(@PATH,7,4634.204,-5587.776,39.63166,0,0,0,0,100,0), +(@PATH,8,4633.204,-5587.776,38.88166,0,0,0,0,100,0), +(@PATH,9,4632.204,-5588.026,38.13166,0,0,0,0,100,0), +(@PATH,10,4631.204,-5588.026,37.63166,0,0,0,0,100,0), +(@PATH,11,4630.204,-5588.026,36.88166,0,0,0,0,100,0), +(@PATH,12,4629.204,-5588.026,36.38166,0,0,0,0,100,0), +(@PATH,13,4628.204,-5588.026,35.63166,0,0,0,0,100,0), +(@PATH,14,4626.204,-5588.026,35.13166,0,0,0,0,100,0), +(@PATH,15,4625.204,-5588.026,34.38166,0,0,0,0,100,0), +(@PATH,16,4624.204,-5588.026,33.88166,0,0,0,0,100,0), +(@PATH,17,4623.454,-5588.026,33.38166,0,0,0,0,100,0), +(@PATH,18,4622.454,-5588.276,32.88166,0,0,0,0,100,0), +(@PATH,19,4621.454,-5588.276,32.13166,0,0,0,0,100,0), +(@PATH,20,4620.454,-5588.276,31.63166,0,0,0,0,100,0), +(@PATH,21,4618.454,-5588.276,30.38166,0,0,0,0,100,0), +(@PATH,22,4616.454,-5588.276,29.63166,0,0,0,0,100,0), +(@PATH,23,4615.454,-5588.276,28.88166,0,0,0,0,100,0), +(@PATH,24,4613.454,-5588.276,27.88166,0,0,0,0,100,0), +(@PATH,25,4615.112,-5588.271,28.6151,0,0,0,0,100,0), +(@PATH,26,4613.112,-5588.271,27.6151,0,0,0,0,100,0), +(@PATH,27,4612.612,-5588.271,27.3651,0,0,0,0,100,0), +(@PATH,28,4609.862,-5587.021,25.8651,0,0,0,0,100,0), +(@PATH,29,4608.112,-5586.021,24.8651,0,0,0,0,100,0), +(@PATH,30,4606.362,-5585.021,24.1151,0,0,0,0,100,0), +(@PATH,31,4604.612,-5584.021,22.8651,0,0,0,0,100,0), +(@PATH,32,4602.862,-5583.021,21.6151,0,0,0,0,100,0), +(@PATH,33,4601.112,-5582.021,20.8651,0,0,0,0,100,0), +(@PATH,34,4599.362,-5581.021,19.3651,0,0,0,0,100,0), +(@PATH,35,4597.612,-5580.021,18.3651,0,0,0,0,100,0), +(@PATH,36,4595.362,-5578.521,16.8651,0,0,0,0,100,0), +(@PATH,37,4593.612,-5577.771,15.6151,0,0,0,0,100,0), +(@PATH,38,4591.862,-5576.771,14.6151,0,0,0,0,100,0), +(@PATH,39,4590.112,-5575.771,13.8651,0,0,0,0,100,0), +(@PATH,40,4588.362,-5574.771,13.1151,0,0,0,0,100,0), +(@PATH,41,4586.612,-5573.771,12.1151,0,0,0,0,100,0), +(@PATH,42,4584.862,-5572.771,11.6151,0,0,0,0,100,0), +(@PATH,43,4583.112,-5571.771,10.8651,0,0,0,0,100,0), +(@PATH,44,4580.612,-5570.271,10.1151,0,0,0,0,100,0), +(@PATH,45,4578.862,-5569.271,9.365101,0,0,0,0,100,0), +(@PATH,46,4578.588,-5569.066,9.268532,0,0,0,0,100,0), +(@PATH,47,4577.088,-5568.316,8.768532,0,0,0,0,100,0), +(@PATH,48,4575.838,-5565.566,7.768532,0,0,0,0,100,0), +(@PATH,49,4575.338,-5563.816,7.018532,0,0,0,0,100,0), +(@PATH,50,4574.588,-5562.066,6.518532,0,0,0,0,100,0), +(@PATH,51,4573.588,-5560.316,5.768532,0,0,0,0,100,0), +(@PATH,52,4572.338,-5557.566,5.018532,0,0,0,0,100,0), +(@PATH,53,4572.302,-5557.273,4.829211,0,0,0,0,100,0), +(@PATH,54,4571.052,-5554.523,4.079211,0,0,0,0,100,0), +(@PATH,55,4570.302,-5551.523,3.579211,0,0,0,0,100,0), +(@PATH,56,4569.302,-5544.773,3.079211,0,0,0,0,100,0), +(@PATH,57,4565.425,-5523.652,2.546694,0,0,0,0,100,0), +(@PATH,58,4558.431,-5505.637,2.508454,0,0,0,0,100,0), +(@PATH,59,4558.492,-5505.963,2.279056,0,0,0,0,100,0), +(@PATH,60,4558.656,-5505.855,2.526844,0,0,0,0,100,0), +(@PATH,61,4565.748,-5523.84,2.603909,0,0,0,0,100,0), +(@PATH,62,4569.748,-5548.34,3.103909,0,0,0,0,100,0), +(@PATH,63,4570.498,-5552.09,3.603909,0,0,0,0,100,0), +(@PATH,64,4571.125,-5554.945,4.307666,0,0,0,0,100,0), +(@PATH,65,4572.375,-5557.695,5.057666,0,0,0,0,100,0), +(@PATH,66,4573.375,-5559.445,5.807666,0,0,0,0,100,0), +(@PATH,67,4574.375,-5561.945,6.307666,0,0,0,0,100,0), +(@PATH,68,4575.125,-5563.695,7.057666,0,0,0,0,100,0), +(@PATH,69,4575.875,-5565.445,7.807666,0,0,0,0,100,0), +(@PATH,70,4577.315,-5568.442,8.979671,0,0,0,0,100,0), +(@PATH,71,4580.065,-5569.942,9.979671,0,0,0,0,100,0), +(@PATH,72,4581.815,-5570.942,10.72967,0,0,0,0,100,0), +(@PATH,73,4584.315,-5572.442,11.47967,0,0,0,0,100,0), +(@PATH,74,4586.065,-5573.442,12.22967,0,0,0,0,100,0), +(@PATH,75,4587.815,-5574.442,12.97967,0,0,0,0,100,0), +(@PATH,76,4589.565,-5575.442,13.72967,0,0,0,0,100,0), +(@PATH,77,4591.315,-5576.442,14.72967,0,0,0,0,100,0), +(@PATH,78,4593.065,-5577.442,15.72967,0,0,0,0,100,0), +(@PATH,79,4594.565,-5578.192,16.47967,0,0,0,0,100,0), +(@PATH,80,4596.315,-5579.192,17.47967,0,0,0,0,100,0), +(@PATH,81,4598.065,-5580.192,18.72967,0,0,0,0,100,0), +(@PATH,82,4599.815,-5581.192,19.72967,0,0,0,0,100,0), +(@PATH,83,4601.565,-5582.192,20.97967,0,0,0,0,100,0), +(@PATH,84,4603.315,-5583.192,21.97967,0,0,0,0,100,0), +(@PATH,85,4605.065,-5583.942,22.72967,0,0,0,0,100,0), +(@PATH,86,4606.815,-5584.942,24.22967,0,0,0,0,100,0), +(@PATH,87,4609.315,-5586.442,25.47967,0,0,0,0,100,0), +(@PATH,88,4611.065,-5587.442,26.72967,0,0,0,0,100,0), +(@PATH,89,4611.174,-5587.652,26.94344,0,0,0,0,100,0), +(@PATH,90,4612.674,-5588.402,27.69344,0,0,0,0,100,0), +(@PATH,91,4615.674,-5588.402,28.94344,0,0,0,0,100,0), +(@PATH,92,4616.674,-5588.402,29.69344,0,0,0,0,100,0), +(@PATH,93,4618.674,-5588.152,30.44344,0,0,0,0,100,0), +(@PATH,94,4619.674,-5588.152,31.19344,0,0,0,0,100,0), +(@PATH,95,4621.674,-5588.152,32.19344,0,0,0,0,100,0), +(@PATH,96,4622.424,-5588.152,32.94344,0,0,0,0,100,0), +(@PATH,97,4623.424,-5588.152,33.19344,0,0,0,0,100,0), +(@PATH,98,4624.424,-5588.152,33.94344,0,0,0,0,100,0), +(@PATH,99,4625.424,-5588.152,34.44344,0,0,0,0,100,0), +(@PATH,100,4626.424,-5588.152,35.19344,0,0,0,0,100,0), +(@PATH,101,4627.424,-5588.152,35.69344,0,0,0,0,100,0), +(@PATH,102,4628.424,-5588.152,36.44344,0,0,0,0,100,0), +(@PATH,103,4629.424,-5587.902,36.94344,0,0,0,0,100,0), +(@PATH,104,4630.424,-5587.902,37.69344,0,0,0,0,100,0), +(@PATH,105,4631.424,-5587.902,38.19344,0,0,0,0,100,0), +(@PATH,106,4632.424,-5587.902,38.94344,0,0,0,0,100,0), +(@PATH,107,4633.424,-5587.902,39.44344,0,0,0,0,100,0), +(@PATH,108,4632.743,-5587.937,39.25474,0,0,0,0,100,0), +(@PATH,109,4633.743,-5587.937,39.75474,0,0,0,0,100,0), +(@PATH,110,4634.243,-5587.937,40.00474,0,0,0,0,100,0), +(@PATH,111,4635.993,-5585.437,40.75474,0,0,0,0,100,0), +(@PATH,112,4636.993,-5583.687,41.50474,0,0,0,0,100,0), +(@PATH,113,4638.493,-5581.437,42.25474,0,0,0,0,100,0), +(@PATH,114,4640.743,-5578.187,43.50474,0,0,0,0,100,0), +(@PATH,115,4641.032,-5577.918,43.48087,0,0,0,0,100,0), +(@PATH,116,4642.532,-5575.418,43.48087,0,0,0,0,100,0), +(@PATH,117,4643.532,-5572.418,42.98087,0,0,0,0,100,0), +(@PATH,118,4644.032,-5570.668,42.23087,0,0,0,0,100,0), +(@PATH,119,4644.532,-5567.668,41.23087,0,0,0,0,100,0), +(@PATH,120,4645.032,-5565.668,40.23087,0,0,0,0,100,0), +(@PATH,121,4645.532,-5564.168,38.98087,0,0,0,0,100,0), +(@PATH,122,4646.032,-5562.168,37.98087,0,0,0,0,100,0), +(@PATH,123,4646.532,-5560.168,36.98087,0,0,0,0,100,0), +(@PATH,124,4647.032,-5558.168,35.98087,0,0,0,0,100,0), +(@PATH,125,4647.782,-5555.418,35.23087,0,0,0,0,100,0), +(@PATH,126,4648.282,-5553.418,34.48087,0,0,0,0,100,0), +(@PATH,127,4648.611,-5553.267,34.28629,0,0,0,0,100,0), +(@PATH,128,4648.861,-5552.517,33.78629,0,0,0,0,100,0), +(@PATH,129,4649.361,-5550.767,33.03629,0,0,0,0,100,0), +(@PATH,130,4650.361,-5547.767,32.28629,0,0,0,0,100,0), +(@PATH,131,4651.111,-5546.017,31.78629,0,0,0,0,100,0), +(@PATH,132,4651.611,-5544.267,31.28629,0,0,0,0,100,0), +(@PATH,133,4652.111,-5542.517,30.78629,0,0,0,0,100,0), +(@PATH,134,4653.611,-5538.767,30.03629,0,0,0,0,100,0), +(@PATH,135,4654.861,-5534.767,29.53629,0,0,0,0,100,0), +(@PATH,136,4655.176,-5534.61,29.14608,0,0,0,0,100,0), +(@PATH,137,4655.426,-5533.86,29.14608,0,0,0,0,100,0), +(@PATH,138,4658.176,-5528.61,28.39608,0,0,0,0,100,0), +(@PATH,139,4661.176,-5522.61,28.14608,0,0,0,0,100,0), +(@PATH,140,4663.296,-5518.52,27.41638,0,0,0,0,100,0), +(@PATH,141,4666.796,-5515.52,26.66638,0,0,0,0,100,0), +(@PATH,142,4667.602,-5514.735,26.7351,0,0,0,0,100,0), +(@PATH,143,4664.102,-5517.985,27.2351,0,0,0,0,100,0), +(@PATH,144,4663.71,-5518.2,27.46549,0,0,0,0,100,0), +(@PATH,145,4663.21,-5518.7,27.71549,0,0,0,0,100,0), +(@PATH,146,4660.71,-5523.2,27.96549,0,0,0,0,100,0), +(@PATH,147,4657.71,-5529.2,28.71549,0,0,0,0,100,0), +(@PATH,148,4655.082,-5533.99,29.53152,0,0,0,0,100,0), +(@PATH,149,4653.332,-5538.74,30.03152,0,0,0,0,100,0), +(@PATH,150,4652.332,-5542.49,30.78152,0,0,0,0,100,0), +(@PATH,151,4651.832,-5544.24,31.28152,0,0,0,0,100,0), +(@PATH,152,4651.082,-5546.24,31.78152,0,0,0,0,100,0), +(@PATH,153,4650.332,-5547.99,32.28152,0,0,0,0,100,0), +(@PATH,154,4649.832,-5549.99,33.03152,0,0,0,0,100,0), +(@PATH,155,4648.461,-5552.834,34.08023,0,0,0,0,100,0), +(@PATH,156,4647.961,-5554.834,34.83023,0,0,0,0,100,0), +(@PATH,157,4647.461,-5556.584,35.58023,0,0,0,0,100,0), +(@PATH,158,4646.961,-5558.584,36.58023,0,0,0,0,100,0), +(@PATH,159,4646.461,-5560.584,37.58023,0,0,0,0,100,0), +(@PATH,160,4645.711,-5563.334,38.33023,0,0,0,0,100,0), +(@PATH,161,4645.461,-5565.084,39.58023,0,0,0,0,100,0), +(@PATH,162,4644.961,-5567.084,40.83023,0,0,0,0,100,0), +(@PATH,163,4644.461,-5569.084,41.83023,0,0,0,0,100,0), +(@PATH,164,4643.961,-5570.834,42.58023,0,0,0,0,100,0), +(@PATH,165,4642.961,-5573.834,43.33023,0,0,0,0,100,0), +(@PATH,166,4642.868,-5574.016,43.39613,0,0,0,0,100,0), +(@PATH,167,4642.368,-5575.766,43.64613,0,0,0,0,100,0), +(@PATH,168,4639.118,-5580.516,42.89613,0,0,0,0,100,0), +(@PATH,169,4637.118,-5583.766,41.64613,0,0,0,0,100,0), +(@PATH,170,4635.368,-5586.266,40.39613,0,0,0,0,100,0); + +SET @NPC := 110474; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4974.067,`position_y`=-4702.151,`position_z`=211.6858 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4974.067,-4702.151,211.6858,0,0,0,0,100,0), +(@PATH,2,4973.567,-4694.401,211.6858,0,0,0,0,100,0), +(@PATH,3,4972.317,-4684.151,211.6858,0,0,0,0,100,0), +(@PATH,4,4972.449,-4684.032,211.6815,0,0,0,0,100,0), +(@PATH,5,4972.199,-4683.032,211.6815,0,0,0,0,100,0), +(@PATH,6,4972.073,-4683.314,211.4305,0,0,0,0,100,0), +(@PATH,7,4972.434,-4683.377,211.6818,0,0,0,0,100,0), +(@PATH,8,4973.184,-4694.377,211.6818,0,0,0,0,100,0), +(@PATH,9,4974.222,-4702.475,211.6772,0,0,0,0,100,0), +(@PATH,10,4976.222,-4706.975,211.6772,0,0,0,0,100,0), +(@PATH,11,4979.872,-4716.739,211.652,0,0,0,0,100,0), +(@PATH,12,4979.707,-4716.649,211.4221,0,0,0,0,100,0), +(@PATH,13,4979.64,-4716.295,211.6743,0,0,0,0,100,0), +(@PATH,14,4976.14,-4707.045,211.6743,0,0,0,0,100,0); + +SET @NPC := 110473; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4971.524,`position_y`=-4651.398,`position_z`=211.6646 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4971.524,-4651.398,211.6646,0,0,0,0,100,0), +(@PATH,2,4971.524,-4650.148,211.6646,0,0,0,0,100,0), +(@PATH,3,4971.274,-4642.898,211.6646,0,0,0,0,100,0), +(@PATH,4,4971.195,-4642.912,211.4312,0,0,0,0,100,0), +(@PATH,5,4971.593,-4650.481,211.6812,0,0,0,0,100,0), +(@PATH,6,4971.843,-4651.481,211.6812,0,0,0,0,100,0), +(@PATH,7,4972.093,-4657.231,211.6812,0,0,0,0,100,0), +(@PATH,8,4972.093,-4659.231,211.6812,0,0,0,0,100,0), +(@PATH,9,4972.093,-4660.231,211.6812,0,0,0,0,100,0), +(@PATH,10,4972.593,-4665.231,211.6812,0,0,0,0,100,0), +(@PATH,11,4972.628,-4665.171,211.6984,0,0,0,0,100,0), +(@PATH,12,4972.378,-4661.171,211.6984,0,0,0,0,100,0), +(@PATH,13,4972.128,-4659.421,211.6984,0,0,0,0,100,0), +(@PATH,14,4972.128,-4657.421,211.6984,0,0,0,0,100,0), +(@PATH,15,4971.628,-4651.671,211.6984,0,0,0,0,100,0); + +SET @NPC := 110472; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5006.468,`position_y`=-4761.551,`position_z`=211.3855 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,5006.468,-4761.551,211.3855,0,0,0,0,100,0), +(@PATH,2,5005.218,-4760.301,211.3855,0,0,0,0,100,0), +(@PATH,3,5003.468,-4759.551,211.3855,0,0,0,0,100,0), +(@PATH,4,5001.968,-4758.551,211.6355,0,0,0,0,100,0), +(@PATH,5,4999.169,-4756.928,211.6723,0,0,0,0,100,0), +(@PATH,6,4999.078,-4756.74,211.6491,0,0,0,0,100,0), +(@PATH,7,4995.578,-4756.99,211.6491,0,0,0,0,100,0), +(@PATH,8,4994.328,-4755.24,211.6491,0,0,0,0,100,0), +(@PATH,9,4994.02,-4755.05,211.6453,0,0,0,0,100,0), +(@PATH,10,4994.472,-4755.252,211.6491,0,0,0,0,100,0), +(@PATH,11,4995.472,-4757.002,211.6491,0,0,0,0,100,0), +(@PATH,12,4999.36,-4757.021,211.6276,0,0,0,0,100,0), +(@PATH,13,5001.86,-4758.521,211.6276,0,0,0,0,100,0), +(@PATH,14,5003.61,-4759.271,211.3776,0,0,0,0,100,0), +(@PATH,15,5003.792,-4759.599,211.3631,0,0,0,0,100,0), +(@PATH,16,5005.542,-4760.349,211.6131,0,0,0,0,100,0), +(@PATH,17,5006.792,-4761.849,211.6131,0,0,0,0,100,0), +(@PATH,18,5011.292,-4766.849,211.6131,0,0,0,0,100,0), +(@PATH,19,5014.042,-4769.599,211.6131,0,0,0,0,100,0), +(@PATH,20,5014.364,-4769.94,211.6148,0,0,0,0,100,0), +(@PATH,21,5014.864,-4770.44,211.6148,0,0,0,0,100,0), +(@PATH,22,5018.389,-4774.991,211.6234,0,0,0,0,100,0), +(@PATH,23,5020.639,-4778.491,211.6234,0,0,0,0,100,0), +(@PATH,24,5021.389,-4779.741,211.3734,0,0,0,0,100,0), +(@PATH,25,5021.803,-4779.973,211.3778,0,0,0,0,100,0), +(@PATH,26,5023.303,-4782.723,211.6278,0,0,0,0,100,0), +(@PATH,27,5031.042,-4794.147,211.6393,0,0,0,0,100,0), +(@PATH,28,5032.792,-4795.897,211.6393,0,0,0,0,100,0), +(@PATH,29,5037.042,-4799.647,211.6393,0,0,0,0,100,0), +(@PATH,30,5023.104,-4782.475,211.6226,0,0,0,0,100,0), +(@PATH,31,5021.354,-4779.975,211.6226,0,0,0,0,100,0), +(@PATH,32,5020.854,-4778.725,211.6226,0,0,0,0,100,0), +(@PATH,33,5018.14,-4774.706,211.6087,0,0,0,0,100,0), +(@PATH,34,5014.669,-4770.225,211.5951,0,0,0,0,100,0), +(@PATH,35,5011.419,-4766.725,211.5951,0,0,0,0,100,0); + +DELETE FROM `creature_template_addon` WHERE `entry`=26268; +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(26268,0,0,0,1,27, ''); + +SET @NPC := 110556; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4970.492,`position_y`=-4715.575,`position_z`=219.7441 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4970.492,-4715.575,219.7441,0,0,0,0,100,0), +(@PATH,2,4971.992,-4715.325,220.4941,0,0,0,0,100,0), +(@PATH,3,4973.492,-4714.825,221.2441,0,0,0,0,100,0), +(@PATH,4,4975.742,-4714.325,221.7441,0,0,0,0,100,0), +(@PATH,5,4978.742,-4713.825,222.2441,0,0,0,0,100,0), +(@PATH,6,4980.742,-4713.575,221.9941,0,0,0,0,100,0), +(@PATH,7,4981.992,-4713.325,221.7441,0,0,0,0,100,0), +(@PATH,8,4983.742,-4712.825,221.2441,0,0,0,0,100,0), +(@PATH,9,4985.242,-4712.575,220.4941,0,0,0,0,100,0), +(@PATH,10,4986.242,-4712.325,219.7441,0,0,0,0,100,0), +(@PATH,11,4968.5,-4716.197,219.4686,0,0,0,0,100,0), +(@PATH,12,4968.5,-4716.197,219.4686,0.2173836,0,0,0,100,0), +(@PATH,13,4970.5,-4714.933,219.7303,0,0,0,0,100,0), +(@PATH,14,4971.75,-4714.433,220.4803,0,0,0,0,100,0), +(@PATH,15,4973,-4713.683,221.2303,0,0,0,0,100,0), +(@PATH,16,4975,-4712.683,221.7303,0,0,0,0,100,0), +(@PATH,17,4976,-4712.183,221.9803,0,0,0,0,100,0), +(@PATH,18,4978,-4711.183,222.2303,0,0,0,0,100,0), +(@PATH,19,4979.75,-4710.183,222.2303,0,0,0,0,100,0), +(@PATH,20,4982.5,-4708.683,221.4803,0,0,0,0,100,0), +(@PATH,21,4984,-4707.933,220.7303,0,0,0,0,100,0), +(@PATH,22,4985,-4707.433,219.7303,0,0,0,0,100,0), +(@PATH,23,4985.5,-4707.183,219.7303,0,0,0,0,100,0), +(@PATH,24,4987.75,-4704.183,219.7303,0,0,0,0,100,0), +(@PATH,25,4985.311,-4707.438,219.4958,0,0,0,0,100,0), +(@PATH,26,4985.311,-4707.438,219.4958,0.6189525,0,0,0,100,0), +(@PATH,27,4987.121,-4708.128,219.7317,0,0,0,0,100,0), +(@PATH,28,4996.999,-4712.775,219.6996,0,0,0,0,100,0), +(@PATH,29,4997.249,-4716.525,219.6996,0,0,0,0,100,0), +(@PATH,30,4996.261,-4712.509,219.4735,0,0,0,0,100,0), +(@PATH,31,4996.261,-4712.509,219.4735,5.849536,0,0,0,100,0), +(@PATH,32,4997.006,-4716.74,219.7261,0,0,0,0,100,0), +(@PATH,33,4997.506,-4720.74,219.4761,0,0,0,0,100,0), +(@PATH,34,4998.006,-4723.49,219.7261,0,0,0,0,100,0), +(@PATH,35,4998.103,-4723.636,219.7025,0,0,0,0,100,0), +(@PATH,36,4997.853,-4720.886,219.7025,0,0,0,0,100,0), +(@PATH,37,4997.595,-4720.635,219.7042,0,0,0,0,100,0), +(@PATH,38,4997.345,-4720.135,219.7042,0,0,0,0,100,0), +(@PATH,39,4997.345,-4716.885,219.4542,0,0,0,0,100,0), +(@PATH,40,4997.056,-4712.651,219.6972,0,0,0,0,100,0), +(@PATH,41,4991.556,-4700.401,219.6972,0,0,0,0,100,0), +(@PATH,42,4988.556,-4693.901,219.6972,0,0,0,0,100,0), +(@PATH,43,4986.112,-4688.446,219.7411,0,0,0,0,100,0), +(@PATH,44,4988.362,-4693.696,219.7411,0,0,0,0,100,0), +(@PATH,45,4989.805,-4696.215,219.7516,0,0,0,0,100,0), +(@PATH,46,4991.805,-4699.465,219.7516,0,0,0,0,100,0), +(@PATH,47,4988.768,-4694.563,219.4946,0,0,0,0,100,0), +(@PATH,48,4988.768,-4694.563,219.4946,5.140615,0,0,0,100,0), +(@PATH,49,4987.719,-4703.979,219.9336,0,0,0,0,100,0), +(@PATH,50,4985.469,-4706.229,219.9336,0,0,0,0,100,0), +(@PATH,51,4984.969,-4707.479,220.4336,0,0,0,0,100,0), +(@PATH,52,4984.469,-4708.479,220.4336,0,0,0,0,100,0), +(@PATH,53,4983.469,-4710.229,221.1836,0,0,0,0,100,0), +(@PATH,54,4982.217,-4712.462,221.5245,0,0,0,0,100,0), +(@PATH,55,4980.967,-4712.462,221.7745,0,0,0,0,100,0), +(@PATH,56,4978.467,-4712.962,222.0245,0,0,0,0,100,0), +(@PATH,57,4976.467,-4713.462,221.7745,0,0,0,0,100,0), +(@PATH,58,4976.035,-4713.909,221.9419,0,0,0,0,100,0), +(@PATH,59,4974.785,-4714.159,221.6919,0,0,0,0,100,0), +(@PATH,60,4973.035,-4714.659,221.1919,0,0,0,0,100,0), +(@PATH,61,4972.035,-4714.909,220.6919,0,0,0,0,100,0), +(@PATH,62,4970.535,-4715.409,219.9419,0,0,0,0,100,0), +(@PATH,63,4978.076,-4713.338,221.915,0,0,0,0,100,0), +(@PATH,64,4978.076,-4713.338,221.915,3.368376,0,0,0,100,0), +(@PATH,65,4976.91,-4713.574,221.9563,0,0,0,0,100,0), +(@PATH,66,4975.91,-4713.574,221.9563,0,0,0,0,100,0), +(@PATH,67,4972.91,-4713.824,221.2063,0,0,0,0,100,0), +(@PATH,68,4971.41,-4714.074,220.7063,0,0,0,0,100,0), +(@PATH,69,4970.16,-4714.324,219.9563,0,0,0,0,100,0), +(@PATH,70,4967.606,-4714.529,219.4961,0,0,0,0,100,0), +(@PATH,71,4967.606,-4714.529,219.4961,3.254826,0,0,0,100,0), +(@PATH,72,4965.34,-4710.163,219.7599,0,0,0,0,100,0), +(@PATH,73,4963.59,-4707.163,219.7599,0,0,0,0,100,0), +(@PATH,74,4959.034,-4705.619,219.5352,0,0,0,0,100,0), +(@PATH,75,4959.39,-4705.551,219.7635,0,0,0,0,100,0), +(@PATH,76,4959.64,-4707.801,219.7635,0,0,0,0,100,0), +(@PATH,77,4960.14,-4711.551,219.7635,0,0,0,0,100,0), +(@PATH,78,4960.938,-4715.122,219.7473,0,0,0,0,100,0), +(@PATH,79,4968.219,-4716.248,219.9708,0,0,0,0,100,0), +(@PATH,80,4970.219,-4715.498,219.9708,0,0,0,0,100,0), +(@PATH,81,4971.719,-4714.998,220.4708,0,0,0,0,100,0), +(@PATH,82,4972.969,-4714.748,221.2208,0,0,0,0,100,0), +(@PATH,83,4975.053,-4713.824,221.6586,0,0,0,0,100,0), +(@PATH,84,4976.303,-4713.574,221.9086,0,0,0,0,100,0), +(@PATH,85,4978.303,-4713.324,222.1586,0,0,0,0,100,0), +(@PATH,86,4980.553,-4712.824,221.9086,0,0,0,0,100,0), +(@PATH,87,4975.714,-4713.883,221.6543,0,0,0,0,100,0), +(@PATH,88,4975.714,-4713.883,221.6543,0.2268625,0,0,0,100,0), +(@PATH,89,4978.577,-4713.063,222.0859,0,0,0,0,100,0), +(@PATH,90,4980.827,-4712.813,221.8359,0,0,0,0,100,0), +(@PATH,91,4983.827,-4712.563,221.0859,0,0,0,0,100,0), +(@PATH,92,4985.077,-4712.313,220.5859,0,0,0,0,100,0), +(@PATH,93,4986.077,-4712.063,219.8359,0,0,0,0,100,0); + +SET @NPC := 118822; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3494.382,`position_y`=-4552.813,`position_z`=224.2461 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3494.382,-4552.813,224.2461,0,0,0,0,100,0), +(@PATH,2,3495.632,-4551.813,223.9961,0,0,0,0,100,0), +(@PATH,3,3497.382,-4550.813,222.9961,0,0,0,0,100,0), +(@PATH,4,3499.882,-4549.313,222.4961,0,0,0,0,100,0), +(@PATH,5,3501.382,-4548.313,221.9961,0,0,0,0,100,0), +(@PATH,6,3503.882,-4546.813,221.2461,0,0,0,0,100,0), +(@PATH,7,3506.382,-4545.313,220.4961,0,0,0,0,100,0), +(@PATH,8,3506.673,-4544.896,220.2739,0,0,0,0,100,0), +(@PATH,9,3507.423,-4544.646,220.2739,0,0,0,0,100,0), +(@PATH,10,3508.673,-4543.396,219.7739,0,0,0,0,100,0), +(@PATH,11,3511.423,-4540.896,219.2739,0,0,0,0,100,0), +(@PATH,12,3514.411,-4538.24,218.5021,0,0,0,0,100,0), +(@PATH,13,3515.411,-4534.24,217.7521,0,0,0,0,100,0), +(@PATH,14,3516.161,-4531.74,217.2521,0,0,0,0,100,0), +(@PATH,15,3517.161,-4528.74,216.7521,0,0,0,0,100,0), +(@PATH,16,3518.161,-4524.99,216.2521,0,0,0,0,100,0), +(@PATH,17,3518.383,-4524.767,216.0448,0,0,0,0,100,0), +(@PATH,18,3518.883,-4523.517,215.7948,0,0,0,0,100,0), +(@PATH,19,3521.883,-4521.517,215.2948,0,0,0,0,100,0), +(@PATH,20,3523.383,-4520.267,214.7948,0,0,0,0,100,0), +(@PATH,21,3524.552,-4519.662,214.4079,0,0,0,0,100,0), +(@PATH,22,3526.552,-4519.912,213.4079,0,0,0,0,100,0), +(@PATH,23,3528.552,-4519.912,212.6579,0,0,0,0,100,0), +(@PATH,24,3530.552,-4519.912,211.9079,0,0,0,0,100,0), +(@PATH,25,3533.302,-4520.162,211.4079,0,0,0,0,100,0), +(@PATH,26,3535.302,-4520.162,210.6579,0,0,0,0,100,0), +(@PATH,27,3537.302,-4520.412,209.9079,0,0,0,0,100,0), +(@PATH,28,3537.519,-4520.006,209.603,0,0,0,0,100,0), +(@PATH,29,3539.019,-4520.256,209.103,0,0,0,0,100,0), +(@PATH,30,3542.519,-4518.756,208.353,0,0,0,0,100,0), +(@PATH,31,3541.411,-4519.309,208.4283,0,0,0,0,100,0), +(@PATH,32,3538.654,-4520.119,209.2209,0,0,0,0,100,0), +(@PATH,33,3536.654,-4520.119,209.7209,0,0,0,0,100,0), +(@PATH,34,3534.654,-4519.869,210.4709,0,0,0,0,100,0), +(@PATH,35,3532.654,-4519.869,211.2209,0,0,0,0,100,0), +(@PATH,36,3530.904,-4519.869,211.9709,0,0,0,0,100,0), +(@PATH,37,3528.904,-4519.619,212.7209,0,0,0,0,100,0), +(@PATH,38,3526.904,-4519.619,213.4709,0,0,0,0,100,0), +(@PATH,39,3524.904,-4519.619,214.2209,0,0,0,0,100,0), +(@PATH,40,3524.787,-4519.809,214.4233,0,0,0,0,100,0), +(@PATH,41,3524.287,-4519.809,214.6733,0,0,0,0,100,0), +(@PATH,42,3522.537,-4520.809,214.9233,0,0,0,0,100,0), +(@PATH,43,3520.537,-4522.309,215.6733,0,0,0,0,100,0), +(@PATH,44,3520.155,-4522.621,215.7749,0,0,0,0,100,0), +(@PATH,45,3518.655,-4523.871,216.2749,0,0,0,0,100,0), +(@PATH,46,3517.655,-4527.621,216.7749,0,0,0,0,100,0), +(@PATH,47,3516.905,-4530.121,217.0249,0,0,0,0,100,0), +(@PATH,48,3515.655,-4534.121,217.7749,0,0,0,0,100,0), +(@PATH,49,3514.23,-4538.046,218.7422,0,0,0,0,100,0), +(@PATH,50,3511.48,-4540.546,219.2422,0,0,0,0,100,0), +(@PATH,51,3507.98,-4544.046,219.9922,0,0,0,0,100,0), +(@PATH,52,3507.672,-4544.28,220.189,0,0,0,0,100,0), +(@PATH,53,3507.172,-4544.78,220.439,0,0,0,0,100,0), +(@PATH,54,3503.672,-4547.03,221.439,0,0,0,0,100,0), +(@PATH,55,3501.922,-4547.78,221.939,0,0,0,0,100,0), +(@PATH,56,3499.672,-4549.28,222.439,0,0,0,0,100,0), +(@PATH,57,3497.922,-4550.28,223.189,0,0,0,0,100,0), +(@PATH,58,3495.37,-4551.927,224.1924,0,0,0,0,100,0), +(@PATH,59,3493.12,-4553.927,224.9424,0,0,0,0,100,0), +(@PATH,60,3491.37,-4555.177,225.4424,0,0,0,0,100,0), +(@PATH,61,3489.37,-4556.927,226.1924,0,0,0,0,100,0), +(@PATH,62,3487.12,-4558.677,226.9424,0,0,0,0,100,0), +(@PATH,63,3488.252,-4557.707,226.4908,0,0,0,0,100,0), +(@PATH,64,3490.502,-4555.957,225.7408,0,0,0,0,100,0), +(@PATH,65,3492.002,-4554.957,225.2408,0,0,0,0,100,0), +(@PATH,66,3494.252,-4552.957,224.4908,0,0,0,0,100,0), +(@PATH,67,3494.369,-4552.621,224.1573,0,0,0,0,100,0), +(@PATH,68,3495.619,-4551.871,223.9073,0,0,0,0,100,0), +(@PATH,69,3497.369,-4550.621,223.1573,0,0,0,0,100,0), +(@PATH,70,3499.869,-4549.121,222.4073,0,0,0,0,100,0), +(@PATH,71,3501.369,-4548.371,222.1573,0,0,0,0,100,0), +(@PATH,72,3503.869,-4546.871,221.4073,0,0,0,0,100,0), +(@PATH,73,3506.369,-4545.371,220.6573,0,0,0,0,100,0); +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=26356 AND `source_type`=0 AND `id`=0 AND `link`=1; + +SET @NPC := 98061; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4037.801,`position_y`=-4305.377,`position_z`=252.4434 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4037.801,-4305.377,252.4434,0,0,0,0,100,0), +(@PATH,2,4029.266,-4311.001,252.5234,0,0,0,0,100,0), +(@PATH,3,4029.175,-4310.955,252.2501,0,0,0,0,100,0), +(@PATH,4,4029.509,-4310.642,252.4412,0,0,0,0,100,0), +(@PATH,5,4037.943,-4305.163,252.2845,0,0,0,0,100,0), +(@PATH,6,4054.193,-4300.913,251.7845,0,0,0,0,100,0), +(@PATH,7,4062.19,-4298.607,251.5605,0,0,0,0,100,0), +(@PATH,8,4086.898,-4293.291,251.9268,0,0,0,0,100,0), +(@PATH,9,4086.576,-4293.453,251.7249,0,0,0,0,100,0), +(@PATH,10,4086.678,-4293.366,251.7816,0,0,0,0,100,0), +(@PATH,11,4062,-4298.887,251.8086,0,0,0,0,100,0), +(@PATH,12,4046.75,-4302.637,252.0586,0,0,0,0,100,0), +(@PATH,13,4037.769,-4305.386,252.4443,0,0,0,0,100,0), +(@PATH,14,4029.219,-4311.032,252.5237,0,0,0,0,100,0), +(@PATH,15,4029.175,-4310.955,252.2501,0,0,0,0,100,0); + +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=26389 AND `source_type`=0 AND `id`=0 AND `link`=1; +SET @NPC := 98054; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4043.963,`position_y`=-4430.786,`position_z`=261.5165 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4043.963,-4430.786,261.5165,0,0,0,0,100,0), +(@PATH,2,4044.963,-4432.786,262.0165,0,0,0,0,100,0), +(@PATH,3,4044.713,-4435.286,262.7665,0,0,0,0,100,0), +(@PATH,4,4045.213,-4436.286,263.0165,0,0,0,0,100,0), +(@PATH,5,4045.463,-4436.786,263.0165,0,0,0,0,100,0), +(@PATH,6,4047.463,-4438.786,262.7665,0,0,0,0,100,0), +(@PATH,7,4047.963,-4439.786,263.5165,0,0,0,0,100,0), +(@PATH,8,4047.949,-4440.013,263.7135,0,0,0,0,100,0), +(@PATH,9,4049.949,-4440.513,264.2135,0,0,0,0,100,0), +(@PATH,10,4048.949,-4441.763,264.7135,0,0,0,0,100,0), +(@PATH,11,4048.949,-4443.763,265.2135,0,0,0,0,100,0), +(@PATH,12,4047.699,-4445.763,266.2135,0,0,0,0,100,0), +(@PATH,13,4046.199,-4447.263,266.7135,0,0,0,0,100,0), +(@PATH,14,4043.449,-4446.763,267.4635,0,0,0,0,100,0), +(@PATH,15,4042.699,-4448.013,267.9635,0,0,0,0,100,0), +(@PATH,16,4041.949,-4448.513,267.9635,0,0,0,0,100,0), +(@PATH,17,4041.449,-4453.513,267.4635,0,0,0,0,100,0), +(@PATH,18,4041.242,-4453.717,267.8022,0,0,0,0,100,0), +(@PATH,19,4040.242,-4454.467,268.3022,0,0,0,0,100,0), +(@PATH,20,4040.242,-4456.467,268.8022,0,0,0,0,100,0), +(@PATH,21,4040.242,-4460.217,269.5522,0,0,0,0,100,0), +(@PATH,22,4040.489,-4464.713,269.6811,0,0,0,0,100,0), +(@PATH,23,4046.239,-4480.213,269.1811,0,0,0,0,100,0), +(@PATH,24,4046.276,-4479.878,269.3551,0,0,0,0,100,0), +(@PATH,25,4044.026,-4474.378,270.1051,0,0,0,0,100,0), +(@PATH,26,4040.298,-4464.532,269.725,0,0,0,0,100,0), +(@PATH,27,4040.298,-4459.782,269.225,0,0,0,0,100,0), +(@PATH,28,4040.298,-4455.782,268.475,0,0,0,0,100,0), +(@PATH,29,4040.299,-4455.474,268.2261,0,0,0,0,100,0), +(@PATH,30,4040.299,-4454.224,267.9761,0,0,0,0,100,0), +(@PATH,31,4042.799,-4453.224,267.7261,0,0,0,0,100,0), +(@PATH,32,4046.049,-4454.224,267.7261,0,0,0,0,100,0), +(@PATH,33,4047.799,-4452.974,267.2261,0,0,0,0,100,0), +(@PATH,34,4048.549,-4450.474,266.7261,0,0,0,0,100,0), +(@PATH,35,4049.049,-4444.724,265.7261,0,0,0,0,100,0), +(@PATH,36,4050.049,-4444.724,265.7261,0,0,0,0,100,0), +(@PATH,37,4050.549,-4442.974,264.9761,0,0,0,0,100,0), +(@PATH,38,4049.437,-4441.189,263.9388,0,0,0,0,100,0), +(@PATH,39,4047.937,-4438.439,262.9388,0,0,0,0,100,0), +(@PATH,40,4045.687,-4436.939,262.9388,0,0,0,0,100,0), +(@PATH,41,4044.687,-4436.189,262.9388,0,0,0,0,100,0), +(@PATH,42,4043.937,-4433.189,261.9388,0,0,0,0,100,0), +(@PATH,43,4043.437,-4430.439,261.4388,0,0,0,0,100,0), +(@PATH,44,4043.437,-4428.939,261.4388,0,0,0,0,100,0), +(@PATH,45,4038.512,-4412.942,261.4726,0,0,0,0,100,0), +(@PATH,46,4045.009,-4403.787,261.2599,0,0,0,0,100,0), +(@PATH,47,4050.509,-4398.787,260.7599,0,0,0,0,100,0), +(@PATH,48,4054.184,-4395.831,260.5081,0,0,0,0,100,0), +(@PATH,49,4060.914,-4401.005,260.7264,0,0,0,0,100,0), +(@PATH,50,4060.763,-4401.35,260.5203,0,0,0,0,100,0), +(@PATH,51,4060.835,-4401.013,260.7022,0,0,0,0,100,0); + +-- Earthen Warrior SAI +SET @ENTRY := 26282; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,1,0,100,0,5000,5000,10000,10000,49,0,0,0,0,0,0,19,26284,10,0,0,0,0,0,"Earthen Warrior - Out of Combat - Start Attacking"); + +SET @NPC := 112260; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4626.77,`position_y`=-4468.18,`position_z`=188.7218 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4626.77,-4468.18,188.7218,0,0,0,0,100,0), +(@PATH,2,4628.02,-4468.43,188.7218,0,0,0,0,100,0), +(@PATH,3,4633.77,-4469.43,189.2218,0,0,0,0,100,0), +(@PATH,4,4638.52,-4470.18,189.7218,0,0,0,0,100,0), +(@PATH,5,4642.52,-4470.93,190.4718,0,0,0,0,100,0), +(@PATH,6,4644.66,-4471.42,191.0322,0,0,0,0,100,0), +(@PATH,7,4647.66,-4471.42,191.5322,0,0,0,0,100,0), +(@PATH,8,4651.41,-4471.42,191.7822,0,0,0,0,100,0), +(@PATH,9,4655.41,-4471.42,192.5322,0,0,0,0,100,0), +(@PATH,10,4659.563,-4471.758,193.4037,0,0,0,0,100,0), +(@PATH,11,4667.063,-4474.758,193.9037,0,0,0,0,100,0), +(@PATH,12,4667.158,-4472.282,193.5602,0,0,0,0,100,0), +(@PATH,13,4659.328,-4471.715,193.0153,0,0,0,0,100,0), +(@PATH,14,4655.328,-4471.715,192.5153,0,0,0,0,100,0), +(@PATH,15,4651.578,-4471.465,191.7653,0,0,0,0,100,0), +(@PATH,16,4647.578,-4471.465,191.5153,0,0,0,0,100,0), +(@PATH,17,4644.492,-4471.189,190.7167,0,0,0,0,100,0), +(@PATH,18,4640.492,-4470.439,189.9667,0,0,0,0,100,0), +(@PATH,19,4635.742,-4469.689,189.7167,0,0,0,0,100,0), +(@PATH,20,4630.992,-4468.939,188.9667,0,0,0,0,100,0), +(@PATH,21,4627.861,-4468.194,188.4529,0,0,0,0,100,0), +(@PATH,22,4625.361,-4467.944,188.7029,0,0,0,0,100,0), +(@PATH,23,4619.689,-4466.896,187.1016,0,0,0,0,100,0), +(@PATH,24,4609.689,-4465.646,184.6016,0,0,0,0,100,0), +(@PATH,25,4608.689,-4465.646,184.6016,0,0,0,0,100,0), +(@PATH,26,4608.402,-4465.411,184.3824,0,0,0,0,100,0), +(@PATH,27,4605.652,-4465.161,184.3824,0,0,0,0,100,0), +(@PATH,28,4595.808,-4461.938,184.4014,0,0,0,0,100,0), +(@PATH,29,4595.772,-4462.198,184.1551,0,0,0,0,100,0), +(@PATH,30,4595.927,-4462.176,184.3824,0,0,0,0,100,0), +(@PATH,31,4605.99,-4465.424,184.4906,0,0,0,0,100,0), +(@PATH,32,4609.24,-4465.924,183.9906,0,0,0,0,100,0), +(@PATH,33,4619.987,-4467.194,187.3334,0,0,0,0,100,0), +(@PATH,34,4626.487,-4467.944,188.5834,0,0,0,0,100,0), +(@PATH,35,4626.743,-4468.349,188.8552,0,0,0,0,100,0), +(@PATH,36,4627.993,-4468.349,188.8552,0,0,0,0,100,0), +(@PATH,37,4633.993,-4469.349,189.1052,0,0,0,0,100,0), +(@PATH,38,4638.493,-4470.099,189.8552,0,0,0,0,100,0), +(@PATH,39,4642.493,-4470.849,190.3552,0,0,0,0,100,0); + +SET @NPC := 112265; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4740.915,`position_y`=-4506.604,`position_z`=199.756 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4740.915,-4506.604,199.756,0,0,0,0,100,0), +(@PATH,2,4739.165,-4508.604,200.256,0,0,0,0,100,0), +(@PATH,3,4736.571,-4511.472,200.7764,0,0,0,0,100,0), +(@PATH,4,4732.571,-4516.722,201.2764,0,0,0,0,100,0), +(@PATH,5,4729.089,-4521.665,201.4696,0,0,0,0,100,0), +(@PATH,6,4729.089,-4524.915,202.2196,0,0,0,0,100,0), +(@PATH,7,4727.339,-4528.165,202.7196,0,0,0,0,100,0), +(@PATH,8,4725.089,-4532.415,203.2196,0,0,0,0,100,0), +(@PATH,9,4720.262,-4531.4,203.6031,0,0,0,0,100,0), +(@PATH,10,4719.762,-4532.4,203.8531,0,0,0,0,100,0), +(@PATH,11,4719.762,-4533.4,204.1031,0,0,0,0,100,0), +(@PATH,12,4718.512,-4536.15,204.6031,0,0,0,0,100,0), +(@PATH,13,4715.762,-4538.4,205.1031,0,0,0,0,100,0), +(@PATH,14,4714.762,-4539.65,205.6031,0,0,0,0,100,0), +(@PATH,15,4715.869,-4538.347,205.2154,0,0,0,0,100,0), +(@PATH,16,4717.119,-4536.597,204.7154,0,0,0,0,100,0), +(@PATH,17,4718.119,-4535.847,204.4654,0,0,0,0,100,0), +(@PATH,18,4717.619,-4533.347,204.4654,0,0,0,0,100,0), +(@PATH,19,4719.119,-4530.597,203.4654,0,0,0,0,100,0), +(@PATH,20,4719.277,-4530.432,203.2003,0,0,0,0,100,0), +(@PATH,21,4720.527,-4531.182,203.4503,0,0,0,0,100,0), +(@PATH,22,4721.527,-4529.432,202.9503,0,0,0,0,100,0), +(@PATH,23,4723.027,-4525.432,202.4503,0,0,0,0,100,0), +(@PATH,24,4726.277,-4523.432,201.7003,0,0,0,0,100,0), +(@PATH,25,4729.367,-4521.513,201.2202,0,0,0,0,100,0), +(@PATH,26,4736.9,-4511.23,200.8284,0,0,0,0,100,0), +(@PATH,27,4739.9,-4507.73,199.8284,0,0,0,0,100,0), +(@PATH,28,4742.65,-4504.73,199.5784,0,0,0,0,100,0); + +SET @NPC := 112263; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4763.436,`position_y`=-4489.991,`position_z`=196.598 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4763.436,-4489.991,196.598,0,0,0,0,100,0), +(@PATH,2,4777.686,-4503.491,197.098,0,0,0,0,100,0), +(@PATH,3,4777.988,-4503.717,197.3403,0,0,0,0,100,0), +(@PATH,4,4779.238,-4504.967,197.3403,0,0,0,0,100,0), +(@PATH,5,4787.988,-4509.217,197.5903,0,0,0,0,100,0), +(@PATH,6,4797.488,-4514.217,198.3403,0,0,0,0,100,0), +(@PATH,7,4791.602,-4511.282,197.6792,0,0,0,0,100,0), +(@PATH,8,4781.352,-4506.032,197.4292,0,0,0,0,100,0), +(@PATH,9,4779.015,-4504.664,197.1621,0,0,0,0,100,0), +(@PATH,10,4764.765,-4491.164,196.6621,0,0,0,0,100,0), +(@PATH,11,4764.466,-4490.788,196.5181,0,0,0,0,100,0), +(@PATH,12,4763.216,-4489.788,196.5181,0,0,0,0,100,0), +(@PATH,13,4757.216,-4483.288,195.7681,0,0,0,0,100,0), +(@PATH,14,4751.675,-4477.44,195.3216,0,0,0,0,100,0), +(@PATH,15,4740.917,-4467.688,195.4378,0,0,0,0,100,0), +(@PATH,16,4733.417,-4458.938,194.9378,0,0,0,0,100,0), +(@PATH,17,4730.063,-4454.976,194.4022,0,0,0,0,100,0), +(@PATH,18,4726.313,-4450.476,193.9022,0,0,0,0,100,0), +(@PATH,19,4721.563,-4444.476,193.4022,0,0,0,0,100,0), +(@PATH,20,4721.331,-4444.313,193.3035,0,0,0,0,100,0), +(@PATH,21,4719.581,-4442.063,193.0535,0,0,0,0,100,0), +(@PATH,22,4712.081,-4433.313,192.5535,0,0,0,0,100,0), +(@PATH,23,4706.962,-4427.567,192.1902,0,0,0,0,100,0), +(@PATH,24,4700.712,-4420.317,191.6902,0,0,0,0,100,0), +(@PATH,25,4704.823,-4424.94,191.8282,0,0,0,0,100,0), +(@PATH,26,4705.068,-4425.129,192.0756,0,0,0,0,100,0), +(@PATH,27,4707.318,-4427.629,192.3256,0,0,0,0,100,0), +(@PATH,28,4714.318,-4435.879,192.8256,0,0,0,0,100,0), +(@PATH,29,4719.729,-4442.429,193.2542,0,0,0,0,100,0), +(@PATH,30,4725.229,-4449.179,193.7542,0,0,0,0,100,0), +(@PATH,31,4729.479,-4454.679,194.2542,0,0,0,0,100,0), +(@PATH,32,4729.81,-4454.901,194.5507,0,0,0,0,100,0), +(@PATH,33,4730.31,-4455.401,194.5507,0,0,0,0,100,0), +(@PATH,34,4734.56,-4460.401,195.0507,0,0,0,0,100,0), +(@PATH,35,4741.313,-4467.867,195.4152,0,0,0,0,100,0); + +-- correction +-- Grizzly Hills Giant SAI +SET @ENTRY := 26261; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,8,0,100,0,47394,0,0,0,33,26261,0,0,0,0,0,7,0,0,0,0,0,0,0,"Grizzly Hills Giant - On Spellhit 'Kurun's Blessing' - Quest Credit 'Rallying the Troops'"), +(@ENTRY,0,1,0,1,0,100,0,2000,5000,4000,6000,11,46815,0,0,0,0,0,19,26264,100,0,0,0,0,0,"Grizzly Hills Giant - Out of Combat - Cast 'Toss Boulder'"); + +SET @NPC := 110559; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4974.938,`position_y`=-4745.822,`position_z`=219.5011 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4974.938,-4745.822,219.5011,0,0,0,0,100,0), +(@PATH,2,4974.938,-4745.822,219.5011,2.057687,0,0,0,100,0), +(@PATH,3,4974.938,-4745.822,219.5011,0,0,0,0,100,0), +(@PATH,4,4974.938,-4745.822,219.5011,2.057687,0,0,0,100,0), +(@PATH,5,4970.268,-4736.388,219.75,0,0,0,0,100,0), +(@PATH,6,4969.018,-4734.138,219.75,0,0,0,0,100,0), +(@PATH,7,4968.648,-4734.162,219.7481,0,0,0,0,100,0), +(@PATH,8,4969.148,-4736.162,219.7481,0,0,0,0,100,0), +(@PATH,9,4970.325,-4738.761,219.7499,0,0,0,0,100,0), +(@PATH,10,4974.973,-4749.851,219.75,0,0,0,0,100,0), +(@PATH,11,4977.148,-4754.923,219.7599,0,0,0,0,100,0), +(@PATH,12,4977.898,-4756.173,219.7599,0,0,0,0,100,0), +(@PATH,13,4976.332,-4753.346,219.5004,0,0,0,0,100,0), +(@PATH,14,4976.332,-4753.346,219.5004,5.131248,0,0,0,100,0), +(@PATH,15,4978.357,-4755.924,219.7322,0,0,0,0,100,0), +(@PATH,16,4985.357,-4766.174,219.7322,0,0,0,0,100,0), +(@PATH,17,4988.607,-4770.424,219.7322,0,0,0,0,100,0), +(@PATH,18,4990.607,-4773.424,219.7322,0,0,0,0,100,0), +(@PATH,19,4978.615,-4756.599,219.5061,0,0,0,0,100,0), +(@PATH,20,4978.615,-4756.599,219.5061,5.324385,0,0,0,100,0), +(@PATH,21,4989.826,-4764.923,219.9392,0,0,0,0,100,0), +(@PATH,22,4992.076,-4766.923,220.9392,0,0,0,0,100,0), +(@PATH,23,4994.826,-4767.173,219.9392,0,0,0,0,100,0), +(@PATH,24,4997.076,-4766.923,220.9392,0,0,0,0,100,0), +(@PATH,25,4998.326,-4766.423,221.4392,0,0,0,0,100,0), +(@PATH,26,5002.076,-4765.673,221.9392,0,0,0,0,100,0), +(@PATH,27,5004.826,-4765.173,222.1892,0,0,0,0,100,0), +(@PATH,28,5005.213,-4765.373,222.2207,0,0,0,0,100,0), +(@PATH,29,5006.713,-4764.873,221.9707,0,0,0,0,100,0), +(@PATH,30,5008.463,-4763.873,221.7207,0,0,0,0,100,0), +(@PATH,31,5010.463,-4762.623,221.2207,0,0,0,0,100,0), +(@PATH,32,5011.713,-4762.123,220.7207,0,0,0,0,100,0), +(@PATH,33,5012.463,-4761.623,219.9707,0,0,0,0,100,0), +(@PATH,34,5014.963,-4760.373,219.9707,0,0,0,0,100,0), +(@PATH,35,5013.416,-4761.159,219.5162,0,0,0,0,100,0), +(@PATH,36,5013.416,-4761.159,219.5162,0.5364561,0,0,0,100,0), +(@PATH,37,5012.949,-4758.56,219.7025,0,0,0,0,100,0), +(@PATH,38,5011.449,-4752.56,219.7025,0,0,0,0,100,0), +(@PATH,39,5011.199,-4749.81,219.7025,0,0,0,0,100,0), +(@PATH,40,5010.699,-4747.81,219.7025,0,0,0,0,100,0), +(@PATH,41,5011.182,-4745.968,219.433,0,0,0,0,100,0), +(@PATH,42,5013.682,-4748.968,219.683,0,0,0,0,100,0), +(@PATH,43,5014.682,-4750.218,219.683,0,0,0,0,100,0), +(@PATH,44,5013.822,-4749.14,219.4679,0,0,0,0,100,0), +(@PATH,45,5015.072,-4750.64,219.7179,0,0,0,0,100,0), +(@PATH,46,5015.822,-4751.89,219.7179,0,0,0,0,100,0), +(@PATH,47,5016.797,-4758.994,219.9411,0,0,0,0,100,0), +(@PATH,48,5014.797,-4760.244,219.9411,0,0,0,0,100,0), +(@PATH,49,5013.047,-4760.994,219.9411,0,0,0,0,100,0), +(@PATH,50,5011.547,-4761.994,220.6911,0,0,0,0,100,0), +(@PATH,51,5010.547,-4762.744,221.1911,0,0,0,0,100,0), +(@PATH,52,5008.547,-4763.994,221.6911,0,0,0,0,100,0), +(@PATH,53,5007.547,-4764.494,221.9411,0,0,0,0,100,0), +(@PATH,54,5016.685,-4757.653,219.5163,0,0,0,0,100,0), +(@PATH,55,5016.685,-4757.653,219.5163,4.85295,0,0,0,100,0), +(@PATH,56,5014.053,-4759.563,219.7658,0,0,0,0,100,0), +(@PATH,57,5012.553,-4760.563,219.7658,0,0,0,0,100,0), +(@PATH,58,5011.053,-4761.563,220.5158,0,0,0,0,100,0), +(@PATH,59,5010.053,-4762.563,221.2658,0,0,0,0,100,0), +(@PATH,60,5007.553,-4764.063,221.7658,0,0,0,0,100,0), +(@PATH,61,5005.303,-4765.813,222.0158,0,0,0,0,100,0), +(@PATH,62,5003.553,-4767.063,222.0158,0,0,0,0,100,0), +(@PATH,63,5000.803,-4769.063,221.2658,0,0,0,0,100,0), +(@PATH,64,4999.553,-4769.813,220.5158,0,0,0,0,100,0), +(@PATH,65,4998.303,-4770.813,219.7658,0,0,0,0,100,0), +(@PATH,66,5015.091,-4758.8,219.5454,0,0,0,0,100,0), +(@PATH,67,5015.091,-4758.8,219.5454,3.765347,0,0,0,100,0), +(@PATH,68,5013.777,-4759.399,219.7824,0,0,0,0,100,0), +(@PATH,69,5012.027,-4760.149,219.5324,0,0,0,0,100,0), +(@PATH,70,5010.527,-4760.399,220.5324,0,0,0,0,100,0), +(@PATH,71,5009.027,-4761.149,221.2824,0,0,0,0,100,0), +(@PATH,72,5007.277,-4761.899,221.5324,0,0,0,0,100,0), +(@PATH,73,5005.277,-4761.899,222.0324,0,0,0,0,100,0), +(@PATH,74,5003.527,-4763.399,222.2824,0,0,0,0,100,0), +(@PATH,75,5001.527,-4764.899,222.2824,0,0,0,0,100,0), +(@PATH,76,4998.527,-4766.399,221.2824,0,0,0,0,100,0), +(@PATH,77,4997.527,-4767.149,220.7824,0,0,0,0,100,0), +(@PATH,78,4996.527,-4767.399,219.7824,0,0,0,0,100,0), +(@PATH,79,4995.777,-4767.649,219.7824,0,0,0,0,100,0), +(@PATH,80,4991.527,-4767.899,219.7824,0,0,0,0,100,0), +(@PATH,81,4987.777,-4765.649,219.7824,0,0,0,0,100,0), +(@PATH,82,4981.399,-4761.659,219.763,0,0,0,0,100,0), +(@PATH,83,4977.899,-4756.159,219.763,0,0,0,0,100,0), +(@PATH,84,4977.707,-4755.765,219.7526,0,0,0,0,100,0), +(@PATH,85,4976.957,-4754.515,219.7526,0,0,0,0,100,0), +(@PATH,86,4974.813,-4749.59,219.7486,0,0,0,0,100,0), +(@PATH,87,4975.045,-4750.456,219.4998,0,0,0,0,100,0), +(@PATH,88,4975.045,-4750.456,219.4998,1.989743,0,0,0,100,0), +(@PATH,89,4969.571,-4736.454,219.7493,0,0,0,0,100,0), +(@PATH,90,4968.821,-4734.204,219.7493,0,0,0,0,100,0), +(@PATH,91,4972.802,-4744.884,219.4986,0,0,0,0,100,0), +(@PATH,92,4972.802,-4744.884,219.4986,1.953552,0,0,0,100,0), +(@PATH,93,4969.699,-4736.418,219.7488,0,0,0,0,100,0), +(@PATH,94,4968.699,-4734.168,219.7488,0,0,0,0,100,0); + +-- Runed Giant SAI +SET @ENTRY := 26417; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=2; +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 +(@ENTRY,0,2,0,1,0,100,0,5000,5000,10000,10000,49,0,0,0,0,0,0,19,26261,15,0,0,0,0,0,"Runed Giant - Out of Combat - Start Attacking"); + +SET @NPC := 86438; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4795.183,`position_y`=-4858.25,`position_z`=25.82121 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4795.183,-4858.25,25.82121,0,0,0,0,100,0), +(@PATH,2,4793.933,-4857.25,25.82121,0,0,0,0,100,0), +(@PATH,3,4786.933,-4851,25.82121,0,0,0,0,100,0), +(@PATH,4,4783.933,-4848.5,25.57121,0,0,0,0,100,0), +(@PATH,5,4775.606,-4841.151,25.45528,0,0,0,0,100,0), +(@PATH,6,4775.606,-4841.151,25.45528,2.513274,0,0,0,100,0), +(@PATH,7,4783.6,-4848.556,25.60373,0,0,0,0,100,0), +(@PATH,8,4786.35,-4851.306,25.85373,0,0,0,0,100,0), +(@PATH,9,4793.35,-4858.056,25.85373,0,0,0,0,100,0), +(@PATH,10,4793.512,-4857.986,25.97804,0,0,0,0,100,0), +(@PATH,11,4794.762,-4859.236,25.97804,0,0,0,0,100,0), +(@PATH,12,4798.762,-4857.986,25.72804,0,0,0,0,100,0), +(@PATH,13,4800.262,-4857.736,25.72804,0,0,0,0,100,0), +(@PATH,14,4802.262,-4856.986,25.72804,0,0,0,0,100,0), +(@PATH,15,4810.12,-4854.692,25.79934,0,0,0,0,100,0), +(@PATH,16,4816.12,-4851.192,25.79934,0,0,0,0,100,0), +(@PATH,17,4818.37,-4850.192,25.54934,0,0,0,0,100,0), +(@PATH,18,4819.37,-4849.692,25.54934,0,0,0,0,100,0), +(@PATH,19,4821.12,-4848.942,25.79934,0,0,0,0,100,0), +(@PATH,20,4823.87,-4847.192,25.54934,0,0,0,0,100,0), +(@PATH,21,4825.23,-4846.544,25.45987,5.550147,0,0,0,100,0), +(@PATH,22,4823.903,-4847.049,25.59635,0,0,0,0,100,0), +(@PATH,23,4821.653,-4848.049,25.59635,0,0,0,0,100,0), +(@PATH,24,4820.403,-4848.549,25.59635,0,0,0,0,100,0), +(@PATH,25,4816.653,-4850.049,25.59635,0,0,0,0,100,0), +(@PATH,26,4814.903,-4850.549,25.59635,0,0,0,0,100,0), +(@PATH,27,4803.903,-4854.799,25.84635,0,0,0,0,100,0), +(@PATH,28,4800.153,-4856.299,25.84635,0,0,0,0,100,0), +(@PATH,29,4799.153,-4856.799,25.84635,0,0,0,0,100,0), +(@PATH,30,4795.174,-4858.254,25.82136,0,0,0,0,100,0), +(@PATH,31,4793.924,-4857.254,25.82136,0,0,0,0,100,0), +(@PATH,32,4786.924,-4851.004,25.82136,0,0,0,0,100,0), +(@PATH,33,4783.924,-4848.504,25.57136,0,0,0,0,100,0), +(@PATH,34,4775.606,-4841.151,25.45528,0,0,0,0,100,0), +(@PATH,35,4775.606,-4841.151,25.45528,2.513274,0,0,0,100,0); + +SET @NPC := 86437; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4766.285,`position_y`=-4851.221,`position_z`=25.88538 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4766.285,-4851.221,25.88538,0,0,0,0,100,0), +(@PATH,2,4764.035,-4852.971,25.63538,0,0,0,0,100,0), +(@PATH,3,4762.535,-4853.971,25.38538,0,0,0,0,100,0), +(@PATH,4,4761.535,-4853.971,25.38538,0,0,0,0,100,0), +(@PATH,5,4760.035,-4853.971,25.63538,0,0,0,0,100,0), +(@PATH,6,4758.785,-4853.971,26.13538,0,0,0,0,100,0), +(@PATH,7,4758.035,-4854.221,26.38538,0,0,0,0,100,0), +(@PATH,8,4756.035,-4854.471,26.38538,0,0,0,0,100,0), +(@PATH,9,4753.785,-4854.971,26.38538,0,0,0,0,100,0), +(@PATH,10,4752.035,-4855.221,26.38538,0,0,0,0,100,0), +(@PATH,11,4748.035,-4856.471,26.38538,0,0,0,0,100,0), +(@PATH,12,4745.785,-4856.721,26.38538,0,0,0,0,100,0), +(@PATH,13,4739.535,-4857.221,26.38538,0,0,0,0,100,0), +(@PATH,14,4733.245,-4857.637,26.4931,0,0,0,0,100,0), +(@PATH,15,4733.245,-4857.637,26.4931,2.617994,0,0,0,100,0), +(@PATH,16,4737.667,-4857.782,26.4303,0,0,0,0,100,0), +(@PATH,17,4739.417,-4857.782,26.4303,0,0,0,0,100,0), +(@PATH,18,4745.917,-4857.782,26.4303,0,0,0,0,100,0), +(@PATH,19,4747.667,-4857.782,26.1803,0,0,0,0,100,0), +(@PATH,20,4750.917,-4857.782,26.1803,0,0,0,0,100,0), +(@PATH,21,4752.667,-4857.782,26.1803,0,0,0,0,100,0), +(@PATH,22,4755.667,-4857.782,26.1803,0,0,0,0,100,0), +(@PATH,23,4755.755,-4857.606,26.16596,0,0,0,0,100,0), +(@PATH,24,4758.755,-4857.606,25.91596,0,0,0,0,100,0), +(@PATH,25,4761.005,-4855.856,25.66596,0,0,0,0,100,0), +(@PATH,26,4762.505,-4854.356,25.41596,0,0,0,0,100,0), +(@PATH,27,4764.255,-4853.106,25.66596,0,0,0,0,100,0), +(@PATH,28,4766.005,-4851.606,25.66596,0,0,0,0,100,0); + +-- Shade of Arugal SAI +SET @ENTRY := 27018; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,1,0,100,0,1000,1000,20000,20000,11,48185,0,0,0,0,0,19,27024,20,0,0,0,0,0,"Shade of Arugal - Out of Combat - Cast 'Arugal Channel'"), +(@ENTRY,0,1,0,0,0,100,0,2000,3000,2000,3000,11,53086,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shade of Arugal - In Combat - Cast 'Shadow Bolt'"); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=48185; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 48185, 0, 0, 31, 0, 3, 27024, 0, 0, 0, 0, '', 'Arugal Channel only target Cultists'); diff --git a/sql/updates/world/2015_07_01_12_world_2015_05_24_03.sql b/sql/updates/world/2015_07_01_12_world_2015_05_24_03.sql new file mode 100644 index 00000000000..ec8755146d4 --- /dev/null +++ b/sql/updates/world/2015_07_01_12_world_2015_05_24_03.sql @@ -0,0 +1,13 @@ +-- +-- Grizzly Hills Giant SAI +SET @ENTRY := 26261; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,1,8,0,100,0,47394,0,0,0,80,26261,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grizzly Hills Giant - On Spellhit 'Kurun's Blessing' - Run Script"), +(@ENTRY,0,1,0,61,0,100,0,47394,0,0,0,33,26261,0,0,0,0,0,7,0,0,0,0,0,0,0,"Grizzly Hills Giant - On Spellhit 'Kurun's Blessing' - Quest Credit 'Rallying the Troops'"), +(@ENTRY,0,2,0,1,0,100,0,2000,5000,4000,6000,11,46815,0,0,0,0,0,19,26264,500,0,0,0,0,0,"Grizzly Hills Giant - Out of Combat - Cast 'Toss Boulder'"); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=46815; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 46815, 0, 0, 31, 0, 3, 26264, 0, 0, 0, 0, '', 'Toss Boulder - only targets Dummy'); diff --git a/sql/updates/world/2015_07_01_13_world_2015_05_24_02.sql b/sql/updates/world/2015_07_01_13_world_2015_05_24_02.sql new file mode 100644 index 00000000000..42ec1ac0b3b --- /dev/null +++ b/sql/updates/world/2015_07_01_13_world_2015_05_24_02.sql @@ -0,0 +1,16 @@ +-- The Farstrider Lodge flavor texts +DELETE FROM `gossip_menu` WHERE `text_id` IN (3522, 3525, 3495); +INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES +(2831, 3522), +(2831, 3525), +(2801, 3495); + +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceEntry` IN (3522, 3525, 3495, 3523) AND `ConditionTypeOrReference` IN (8); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14, 2831, 3523, 0, 0, 8, 0, 258, 0, 0, 1, 0, 0, '', 'Show gossip text if player has quest 258 not completed'), +(14, 2831, 3522, 0, 0, 8, 0, 258, 0, 0, 0, 0, 0, '', 'Show gossip text if player has quest 258 completed'), +(14, 2831, 3525, 0, 0, 8, 0, 271, 0, 0, 0, 0, 0, '', 'Show gossip text if player has quest 271 completed'), +(14, 2801, 3495, 0, 0, 8, 0, 385, 0, 0, 0, 0, 0, '', 'Show gossip text if player has quest 385 completed'); + +UPDATE `npc_text` SET `BroadcastTextID0`=5854 WHERE `id`=3522; diff --git a/sql/updates/world/2015_07_01_14_world_2015_05_24_00.sql b/sql/updates/world/2015_07_01_14_world_2015_05_24_00.sql new file mode 100644 index 00000000000..946c20339cb --- /dev/null +++ b/sql/updates/world/2015_07_01_14_world_2015_05_24_00.sql @@ -0,0 +1,170 @@ +-- Gnomeregan Scripts +-- Irradiated Pillager SAI +SET @ENTRY := 6329; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,25,0,100,0,0,0,0,0,75,9798,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - On Reset - Add Aura 'Radiation'"), +(@ENTRY,0,1,0,0,0,100,0,3000,5000,10000,11000,11,9771,64,0,0,0,0,17,0,50,0,0,0,0,0,"Irradiated Pillager - In Combat CMC - Cast 'Radiation Bolt'"), +(@ENTRY,0,2,0,2,0,100,1,0,40,0,0,11,8269,2,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - Between 0-40% Health - Cast 'Frenzy' (No Repeat)"); + +-- Caverndeep Ambusher SAI +SET @ENTRY := 6207; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,3700,3700,3600,12400,11,2590,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Ambusher - In Combat - Cast 'Backstab'"); + +-- Caverndeep Burrower SAI +SET @ENTRY := 6206; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,3000,5000,9000,13000,11,1604,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Burrower - In Combat - Cast 'Dazed'"), +(@ENTRY,0,1,0,0,0,100,0,2000,4000,4000,6000,11,9770,64,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Burrower - In Combat CMC - Cast 'Radiation'"), +(@ENTRY,0,2,0,0,0,100,0,6000,7000,4000,8000,11,16145,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Burrower - In Combat - Cast 'Sunder Armor'"), +(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Caverndeep Burrower - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Irradiated Slime SAI +SET @ENTRY := 6218; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,1,1000,2000,0,0,75,10341,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Slime - In Combat - Add Aura 'Radiation Cloud'"), +(@ENTRY,0,1,0,0,0,100,0,2000,9000,11000,14000,11,9459,0,0,0,0,0,17,0,50,0,0,0,0,0,"Irradiated Slime - In Combat - Cast 'Corrosive Ooze'"), +(@ENTRY,0,2,0,0,0,100,0,4000,6000,8000,9000,11,1604,64,0,0,0,0,2,0,0,0,0,0,0,0,"Irradiated Slime - In Combat CMC - Cast 'Dazed'"); + +-- Irradiated Horror SAI +SET @ENTRY := 6220; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,1,1000,2000,0,0,75,10341,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Horror - In Combat - Add Aura 'Radiation Cloud' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,4000,5000,10000,12000,11,8211,0,0,0,0,0,2,0,0,0,0,0,0,0,"Irradiated Horror - In Combat - Cast 'Chain Burn'"), +(@ENTRY,0,2,0,0,0,100,0,2000,9000,11000,14000,11,9459,0,0,0,0,0,17,0,50,0,0,0,0,0,"Irradiated Horror - In Combat - Cast 'Corrosive Ooze'"), +(@ENTRY,0,3,0,0,0,100,0,4000,6000,8000,9000,11,1604,64,0,0,0,0,2,0,0,0,0,0,0,0,"Irradiated Horror - In Combat CMC - Cast 'Dazed'"); + +-- Corrosive Lurker SAI +SET @ENTRY := 6219; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,1,1000,2000,0,0,75,10341,0,0,0,0,0,1,0,0,0,0,0,0,0,"Corrosive Lurker - In Combat - Add Aura 'Radiation Cloud' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,2000,9000,11000,14000,11,9459,0,0,0,0,0,17,0,50,0,0,0,0,0,"Corrosive Lurker - In Combat - Cast 'Corrosive Ooze'"), +(@ENTRY,0,2,0,0,0,100,0,4000,6000,8000,9000,11,1604,64,0,0,0,0,2,0,0,0,0,0,0,0,"Corrosive Lurker - In Combat CMC - Cast 'Dazed'"); + +UPDATE `creature` SET `spawndist`=20, `MovementType`=1 WHERE `guid`=30137; + +-- Viscous Fallout SAI +SET @ENTRY := 7079; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,1,1000,2000,0,0,75,10341,2,0,0,0,0,1,0,0,0,0,0,0,0,"Viscous Fallout - In Combat - Add Aura 'Radiation Cloud'"), +(@ENTRY,0,1,0,0,0,100,0,2000,9000,11000,14000,11,9459,64,0,0,0,0,17,0,50,0,0,0,0,0,"Viscous Fallout - In Combat CMC - Cast 'Corrosive Ooze'"); + +-- Mechanized Sentry SAI +SET @ENTRY := 6233; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,3000,5000,8000,9000,11,1604,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mechanized Sentry - In Combat - Cast 'Dazed'"); + +-- Leprous Defender SAI +SET @ENTRY := 6223; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,1000,1500,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Leprous Defender - Combat CMC - Cast 'Shoot'"), +(@ENTRY,0,1,0,9,0,100,0,5,30,7000,9000,11,14443,0,0,0,0,0,2,0,0,0,0,0,0,0,"Leprous Defender - Within 5-30 Range - Cast 'Multi-Shot'"), +(@ENTRY,0,2,0,9,0,100,0,5,30,9000,11000,11,5116,0,0,0,0,0,2,0,0,0,0,0,0,0,"Leprous Defender - Within 5-30 Range - Cast 'Concussive Shot'"), +(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Defender - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Leprous Technician SAI +SET @ENTRY := 6222; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,0,0,0,0,0,11,12024,64,0,0,0,0,2,0,0,0,0,0,0,0,"Leprous Technician - On Aggro CMC - Cast 'Net'"), +(@ENTRY,0,1,0,0,0,100,0,2000,6000,8000,9000,11,1604,0,0,0,0,0,2,0,0,0,0,0,0,0,"Leprous Technician - In Combat - Cast 'Dazed'"), +(@ENTRY,0,2,0,0,0,100,0,2000,5000,6000,8000,11,13398,64,0,0,0,0,21,30,0,0,0,0,0,0,"Leprous Technician - In Combat CMC - Cast 'Throw Wrench'"); + +-- Mechano-Tank SAI +SET @ENTRY := 6225; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,5,30,2300,3900,11,1604,64,0,0,0,0,2,0,0,0,0,0,0,0,"Mechano-Tank - Combat CMC - Cast 'Dazed'"), +(@ENTRY,0,1,0,9,0,100,0,5,30,7000,9000,11,10346,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mechano-Tank - Within 5-30 Range - Cast 'Multi-Shot'"), +(@ENTRY,0,2,0,9,0,100,0,5,30,9000,11000,11,5116,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mechano-Tank - Within 5-30 Range - Cast 'Concussive Shot'"), +(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mechano-Tank - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Peacekeeper Security Suit SAI +SET @ENTRY := 6230; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,5000,6000,6000,8000,11,6533,64,0,0,0,0,2,0,0,0,0,0,0,0,"Peacekeeper Security Suit - In Combat CMC - Cast 'Net'"), +(@ENTRY,0,1,0,0,0,50,0,5000,6000,14000,16000,11,10730,0,0,0,0,0,2,0,0,0,0,0,0,0,"Peacekeeper Security Suit - In Combat - Cast 'Pacify'"); + +-- Mechanized Guardian SAI +SET @ENTRY := 6234; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,2000,5000,6000,7000,11,1604,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mechanized Guardian - In Combat - Cast 'Dazed'"), +(@ENTRY,0,1,0,0,0,100,0,3000,6000,6000,7000,11,11820,0,0,0,0,0,21,40,0,0,0,0,0,0,"Mechanized Guardian - In Combat - Cast 'Field'"); + +-- Mechano-Flamewalker SAI +SET @ENTRY := 6226; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,2000,6000,6000,10000,11,11306,64,0,0,0,0,1,0,0,0,0,0,0,0,"Mechano-Flamewalker - In Combat CMC - Cast 'Fire Nova'"), +(@ENTRY,0,1,0,0,0,100,0,3000,6000,10000,12000,11,10733,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mechano-Flamewalker - In Combat - Cast 'Flame Spray'"); + +-- Mechano-Frostwalker SAI +SET @ENTRY := 6227; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,2,0,100,1,0,40,0,0,11,22519,2,0,0,0,0,1,0,0,0,0,0,0,0,"Mechano-Frostwalker - Between 0-40% Health - Cast 'Ice Nova' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,2000,6000,8000,9000,11,11264,64,0,0,0,0,1,0,0,0,0,0,0,0,"Mechano-Frostwalker - In Combat CMC - Cast 'Ice Blast'"); + +-- Caverndeep Reaver SAI +SET @ENTRY := 6211; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,7366,2,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Reaver - On Aggro - Cast 'Berserker Stance' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,2000,6000,5000,8000,11,8374,2,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Reaver - In Combat - Cast 'Arcing Smash'"), +(@ENTRY,0,2,0,0,0,100,0,4000,4000,4000,4000,11,845,2,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Reaver - In Combat - Cast 'Cleave'"); + +-- Holdout Medic SAI +SET @ENTRY := 6392; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,2,0,100,1,0,60,0,0,11,22167,0,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Medic - Between 0-60% Health - Cast 'Heal' (No Repeat)"), +(@ENTRY,0,1,0,4,0,100,1,0,0,0,0,11,22168,64,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Medic - On Aggro CMC - Cast 'Renew' (No Repeat)"), +(@ENTRY,0,2,0,1,0,100,0,5000,5000,8000,10000,11,22167,0,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Medic - Out of Combat - Cast 'Heal'"), +(@ENTRY,0,3,0,1,0,100,0,4000,10000,15000,20000,11,22168,0,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Medic - Out of Combat - Cast 'Renew'"); + +-- Walking Bomb SAI +SET @ENTRY := 7915; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,3,0,0,15000,15000,11,11504,0,0,0,0,0,1,0,0,0,0,0,0,0,"Walking Bomb - In Combat - Cast 'Walking Bomb Effect' (No Repeat) (Normal Dungeon)"); + +UPDATE `creature` SET `spawndist`=20, `MovementType`=1 WHERE `guid`=30133; + +-- Leprous Machinesmith SAI +SET @ENTRY := 6224; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,4000,5000,20000,25000,11,10732,0,0,0,0,0,19,6224,50,0,0,0,0,0,"Leprous Machinesmith - In Combat - Cast 'Supercharge'"), +(@ENTRY,0,1,0,0,0,100,0,2000,5000,4000,6000,11,13398,64,0,0,0,0,21,30,0,0,0,0,0,0,"Leprous Machinesmith - In Combat CMC - Cast 'Throw Wrench'"), +(@ENTRY,0,2,0,2,0,100,1,0,90,0,0,11,10348,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Machinesmith - Between 0-90% Health - Cast 'Tune Up' (No Repeat)"); + diff --git a/sql/updates/world/2015_07_01_15_world_2015_05_23_01.sql b/sql/updates/world/2015_07_01_15_world_2015_05_23_01.sql new file mode 100644 index 00000000000..44c17b81f48 --- /dev/null +++ b/sql/updates/world/2015_07_01_15_world_2015_05_23_01.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `gossip_menu_id`=21212 WHERE `entry`=13000; diff --git a/sql/updates/world/2015_07_01_16_world_2015_05_23_00.sql b/sql/updates/world/2015_07_01_16_world_2015_05_23_00.sql new file mode 100644 index 00000000000..914b721b2ed --- /dev/null +++ b/sql/updates/world/2015_07_01_16_world_2015_05_23_00.sql @@ -0,0 +1,4 @@ +-- +UPDATE `creature_template` SET `npcflag`=3, `gossip_menu_id`=4047 WHERE `entry`=658; +DELETE FROM `gossip_menu` WHERE `entry`=4047; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4047, 4937); diff --git a/sql/updates/world/2015_07_01_17_world_2015_05_22_14.sql b/sql/updates/world/2015_07_01_17_world_2015_05_22_14.sql new file mode 100644 index 00000000000..43bbacd2d1a --- /dev/null +++ b/sql/updates/world/2015_07_01_17_world_2015_05_22_14.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceEntry`=6994; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`Scriptname`,`Comment`) VALUES +(1,641,6994,0,0,2,0,51315,1,1,1,0 ,'' , 'whitestone oak lumber drop only if the player doesn''t have it already'); diff --git a/sql/updates/world/2015_07_01_18_world_2015_05_22_13.sql b/sql/updates/world/2015_07_01_18_world_2015_05_22_13.sql new file mode 100644 index 00000000000..db90e99cf4d --- /dev/null +++ b/sql/updates/world/2015_07_01_18_world_2015_05_22_13.sql @@ -0,0 +1,51 @@ +-- +UPDATE `creature` SET `position_x`=-4435.777, `position_y`=-13684.191, `position_z`=44.03, `orientation`= 5.189 WHERE `guid`=57310; +UPDATE `creature` SET `MovementType`=2, `spawndist`=0 WHERE `guid` IN (57310, 57313); +DELETE FROM `creature_addon` WHERE `guid` IN (57310, 57313); +INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (57310, 573100), (57313, 573130); +DELETE FROM `waypoint_data` WHERE `id` IN (573100, 573130); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(573100, 1, -4443.440918, -13695.226563, 46.834724, 0, 0, 0, 0, 100, 0), +(573100, 2, -4451.548828, -13708.859375, 48.496380, 0, 0, 0, 0, 100, 0), +(573100, 3, -4431.984863, -13722.603516, 51.757404, 0, 0, 0, 0, 100, 0), +(573100, 4, -4385.404297, -13720.467773, 50.135044, 0, 0, 0, 0, 100, 0), +(573100, 5, -4380.465820, -13740.443359, 50.451973, 0, 0, 0, 0, 100, 0), +(573100, 6, -4392.348633, -13770.427734, 52.292049, 0, 0, 0, 0, 100, 0), +(573100, 7, -4391.951660, -13786.277344, 52.664742, 0, 0, 0, 0, 100, 0), +(573100, 8, -4396.321777, -13804.233398, 55.976879, 0, 0, 0, 0, 100, 0), +(573100, 9, -4404.731934, -13815.549805, 60.186996, 0, 0, 0, 0, 100, 0), +(573100, 10, -4409.673828, -13847.877930, 71.870178, 0, 0, 0, 0, 100, 0), +(573100, 11, -4419.165527, -13854.147461, 78.347191, 0, 0, 0, 0, 100, 0), +(573100, 12, -4432.236816, -13856.821289, 85.815552, 0, 0, 0, 0, 100, 0), +(573100, 13, -4453.323730, -13875.177734, 101.67051, 0, 0, 0, 0, 100, 0), +(573100, 14, -4432.236816, -13856.821289, 85.815552, 0, 0, 0, 0, 100, 0), +(573100, 15, -4419.165527, -13854.147461, 78.347191, 0, 0, 0, 0, 100, 0), +(573100, 16, -4409.673828, -13847.877930, 71.870178, 0, 0, 0, 0, 100, 0), +(573100, 17, -4404.731934, -13815.549805, 60.186996, 0, 0, 0, 0, 100, 0), +(573100, 18, -4396.321777, -13804.233398, 55.976879, 0, 0, 0, 0, 100, 0), +(573100, 19, -4391.951660, -13786.277344, 52.664742, 0, 0, 0, 0, 100, 0), +(573100, 20, -4392.348633, -13770.427734, 52.292049, 0, 0, 0, 0, 100, 0), +(573100, 21, -4380.465820, -13740.443359, 50.451973, 0, 0, 0, 0, 100, 0), +(573100, 22, -4385.404297, -13720.467773, 50.135044, 0, 0, 0, 0, 100, 0), +(573100, 23, -4431.984863, -13722.603516, 51.757404, 0, 0, 0, 0, 100, 0), +(573100, 24, -4451.548828, -13708.859375, 48.496380, 0, 0, 0, 0, 100, 0), +(573100, 25, -4443.440918, -13695.226563, 46.834724, 0, 0, 0, 0, 100, 0), +(573130, 1, -4393.079102, -13790.173828, 52.869942, 0, 0, 0, 0, 100, 0), +(573130, 2, -4392.134766, -13761.565430, 51.793087, 0, 0, 0, 0, 100, 0), +(573130, 3, -4412.633301, -13752.276367, 53.840073, 0, 0, 0, 0, 100, 0), +(573130, 4, -4429.812012, -13722.834961, 51.848553, 0, 0, 0, 0, 100, 0), +(573130, 5, -4389.571777, -13722.364258, 50.288551, 0, 0, 0, 0, 100, 0), +(573130, 6, -4380.811523, -13731.546875, 50.451256, 0, 0, 0, 0, 100, 0), +(573130, 7, -4385.900391, -13759.079102, 50.621365, 0, 0, 0, 0, 100, 0), +(573130, 8, -4391.487305, -13762.515625, 51.752522, 0, 0, 0, 0, 100, 0), +(573130, 9, -4403.406250, -13758.519531, 53.117504, 0, 0, 0, 0, 100, 0), +(573130, 10, -4432.480469, -13756.059570, 56.591385, 0, 0, 0, 0, 100, 0), +(573130, 11, -4403.406250, -13758.519531, 53.117504, 0, 0, 0, 0, 100, 0), +(573130, 12, -4391.487305, -13762.515625, 51.752522, 0, 0, 0, 0, 100, 0), +(573130, 13, -4385.900391, -13759.079102, 50.621365, 0, 0, 0, 0, 100, 0), +(573130, 14, -4380.811523, -13731.546875, 50.451256, 0, 0, 0, 0, 100, 0), +(573130, 15, -4389.571777, -13722.364258, 50.288551, 0, 0, 0, 0, 100, 0), +(573130, 16, -4429.812012, -13722.834961, 51.848553, 0, 0, 0, 0, 100, 0), +(573130, 17, -4412.633301, -13752.276367, 53.840073, 0, 0, 0, 0, 100, 0), +(573130, 18, -4392.134766, -13761.565430, 51.793087, 0, 0, 0, 0, 100, 0), +(573130, 19, -4393.079102, -13790.173828, 52.869942, 0, 0, 0, 0, 100, 0); diff --git a/sql/updates/world/2015_07_01_19_world_2015_05_22_12.sql b/sql/updates/world/2015_07_01_19_world_2015_05_22_12.sql new file mode 100644 index 00000000000..84b5918e7f4 --- /dev/null +++ b/sql/updates/world/2015_07_01_19_world_2015_05_22_12.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid`=16522 AND `id`=12; +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=16522 AND `id`=0; +UPDATE `smart_scripts` SET `event_phase_mask`=1 WHERE entryorguid=16522 AND `id`=5; +UPDATE `smart_scripts` SET `event_phase_mask`=0, `event_flags`=0 WHERE `entryorguid`=16522 AND `id`=6; +UPDATE `smart_scripts` SET `event_phase_mask`=0 WHERE `entryorguid`=16522 AND `id`=7; +UPDATE `smart_scripts` SET `event_phase_mask`=2 WHERE `entryorguid`=16522 AND `id`=11; +UPDATE `smart_scripts` SET `event_phase_mask`=1, `action_param1`=1 WHERE entryorguid=16522 AND `id`=9; +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=16522 AND `id`=2; +UPDATE `creature_template` SET `InhabitType`=4 WHERE `Entry`=17947; diff --git a/sql/updates/world/2015_07_01_20_world_2015_05_22_11.sql b/sql/updates/world/2015_07_01_20_world_2015_05_22_11.sql new file mode 100644 index 00000000000..01122a6bc57 --- /dev/null +++ b/sql/updates/world/2015_07_01_20_world_2015_05_22_11.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `gossip_menu` WHERE `entry`=6024 AND `text_id`=6935; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6024, 6935); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (14) AND `SourceGroup`=6024; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`, `NegativeCondition`) VALUES +(14, 6024, 7176, 0, 8, 7783, 0, 0, 0, '', 'Show gossip text if player get the quest The Lord of Blackrockreward', 0), +(14, 6024, 6935, 0, 8, 7783, 0, 0, 0, '', 'Show gossip text if te quest The Lord of Blackrock is not rewarded', 1); diff --git a/sql/updates/world/2015_07_01_21_world_2015_05_22_10.sql b/sql/updates/world/2015_07_01_21_world_2015_05_22_10.sql new file mode 100644 index 00000000000..751c2a164f2 --- /dev/null +++ b/sql/updates/world/2015_07_01_21_world_2015_05_22_10.sql @@ -0,0 +1,26 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3984) AND `source_type`=0 AND `id` IN (1, 2, 3) ; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (398400) AND `source_type`=9; +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 +(3984, 0, 1, 0, 1, 0, 100, 0, 20000, 20000, 180000, 180000, 80, 398400, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Nancy Vishas - ooc - Action list'), +(398400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Nancy Vishas - Action list - talk 1'), +(398400, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 3985, 15, 0, 0, 0, 0,0,'Nancy Vishas - Action list - talk 1'), +(398400, 9, 2, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Nancy Vishas - Action list - talk 2'), +(398400, 9, 3, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 3985, 15, 0, 0, 0, 0,0,'Nancy Vishas - Action list - talk 2'), +(398400, 9, 4, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Nancy Vishas - Action list - talk 3'), +(398400, 9, 5, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 53, 0, 3984, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Nancy Vishas - Action list - start wp'), +(3984, 0, 2, 0, 40, 0, 100, 0, 1, 3984, 0, 0, 54, 30000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Nancy Vishas - on WP1 - pause wp'), +(3984, 0, 3, 0, 40, 0, 100, 0, 2, 3984, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Nancy Vishas - on wp2- set home orientation'); + +DELETE FROM `waypoints` WHERE `entry`=3984; +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(3984, 1, 908.933, -90.985, 33.783, 'Nancy Vishas'), +(3984, 2, 888.142, -121.849, 38.388, 'Nancy Vishas'); + +DELETE FROM `creature_text` WHERE `entry` IN (3984, 3985); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES +(3984,0,0,'Sidney is late. I thought he would be home by now.',12,7,100,0,0,0,'Nancy Vishas', 1365), +(3985,0,0,'He''s your husband, woman. How am I to know where he is?',12,7,100,0,0,0,'Grandpa Vishas', 1366), +(3984,1,0,'He must be overwhelmed with work at the Monastery. But still, he should have returned by now.',12,7,100,0,0,0,'Nancy Vishas', 1367), +(3985,1,0,'Cleansing the world of impure scum isn''t an easy job, Nancy. Someone''s got to do it.',12,7,100,0,0,0,'Grandpa Vishas', 1368), +(3984,2,0,'Well, I''m going outside to check. Something is amiss.',12,7,100,0,0,0,'Nancy Vishas', 1369); diff --git a/sql/updates/world/2015_07_01_22_world_2015_05_22_09.sql b/sql/updates/world/2015_07_01_22_world_2015_05_22_09.sql new file mode 100644 index 00000000000..e24e207cd3c --- /dev/null +++ b/sql/updates/world/2015_07_01_22_world_2015_05_22_09.sql @@ -0,0 +1,18 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3946) AND `source_type`=0 AND `id` IN (4, 5) ; +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 +(3946, 0, 4, 0, 1, 0, 100, 1, 4000, 4000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Velinde Starsong - Out of Combat - Say Line 3'), +(3946, 0, 5, 0, 1, 0, 100, 1, 11000, 11000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Velinde Starsong - Out of Combat - Say Line 4'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup` IN (1, 2, 3, 4, 5, 6) AND `SourceEntry`=3946; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `ErrorTextId`,`ScriptName`,`Comment`, `NegativeCondition`, `ConditionTarget`) VALUES +(22,2,3946,0,23,2161,0,0,0,'','event require AREA 2161', 1, 1), +(22,3,3946,0,23,2161,0,0,0,'','event require AREA 2161', 1, 1), +(22,4,3946,0,23,2161,0,0,0,'','event require AREA 2161', 1, 1), +(22,5,3946,0,23,2161,0,0,0,'','event require AREA 2161', 0, 1), +(22,6,3946,0,23,2161,0,0,0,'','event require AREA 2161', 0, 1); + +DELETE FROM `creature_text` WHERE `entry` IN (3946) AND `groupid` IN (3, 4); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES +(3946,3,0,'I have failed... I have failed in my duty... failed my people... The worgen run rampant, and the Scythe of my goddess is lost.',12,7,100,0,0,0,'Velinde Starsong', 1359), +(3946,4,0,'This evil I have unleashed... In whose hand does the power my goddess granted to me now lie... By whose hand is it directed?',12,7,100,0,0,0,'Velinde Starsong', 1360); diff --git a/sql/updates/world/2015_07_01_23_world_2015_05_22_07.sql b/sql/updates/world/2015_07_01_23_world_2015_05_22_07.sql new file mode 100644 index 00000000000..fbc99492240 --- /dev/null +++ b/sql/updates/world/2015_07_01_23_world_2015_05_22_07.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `gossip_menu` WHERE `entry`=1483 AND `text_id`=2155; +INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (1483, 2155); +UPDATE `creature_template` SET `gossip_menu_id`=1483 WHERE `entry`=8767; diff --git a/sql/updates/world/2015_07_01_24_world_2015_05_22_06.sql b/sql/updates/world/2015_07_01_24_world_2015_05_22_06.sql new file mode 100644 index 00000000000..3b64b9f7677 --- /dev/null +++ b/sql/updates/world/2015_07_01_24_world_2015_05_22_06.sql @@ -0,0 +1,35 @@ +-- +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=8276; +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=20454; +UPDATE `creature` SET `position_x`=274.23, `position_y`=-2162.325, `position_z`=159.94, `orientation`= 3.227 WHERE `guid`=92880; +UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (92880, 92881); +DELETE FROM `creature_addon` WHERE `guid` IN (92881, 92880); +INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (92880, 928800), (92881, 928810); + +DELETE FROM `waypoint_data` WHERE `id` IN (928810, 928800); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(928810, 1, 87.198, -2237.385, 161.785, 0, 0, 1, 0, 100, 0), +(928810, 2, -7.544, -2549.668, 181.017, 0, 0, 1, 0, 100, 0), +(928810, 3, -237.996, -2624.749, 189.896, 0, 0, 1, 0, 100, 0), +(928810, 4, -217.604, -3346.965, 189.025, 0, 0, 1, 0, 100, 0), +(928810, 5, 63.265, -3628.146, 172.660, 0, 0, 1, 0, 100, 0), +(928810, 6, 354.298, -3663.979, 170.469, 0, 0, 1, 0, 100, 0), +(928810, 7, 438.654, -3378.017, 166.627, 0, 0, 1, 0, 100, 0), +(928810, 8, 198.273, -3037.064, 169.242, 0, 0, 1, 0, 100, 0), +(928810, 9, 61.098, -2856.964, 158.961, 0, 0, 1, 0, 100, 0), +(928810, 10, -48.316, -2553.932, 190.939, 0, 0, 1, 0, 100, 0), +(928810, 11, 139.328, -2296.988, 155.313, 0, 0, 1, 0, 100, 0), +(928810, 12, 272.772, -2096.04, 160.766, 0, 0, 1, 0, 100, 0), +(928800, 1, 160.229, -2189.599, 134.889, 0, 0, 1, 0, 100, 0), +(928800, 2, 92.713, -2488.815, 171.090, 0, 0, 1, 0, 100, 0), +(928800, 3, 34.246, -2612.019, 151.869, 0, 0, 1, 0, 100, 0), +(928800, 4, 66.592, -2894.712, 151.56, 0, 0, 1, 0, 100, 0), +(928800, 5, 242.969, -3067.849, 147.831, 0, 0, 1, 0, 100, 0), +(928800, 6, 340.322, -3286.022, 160.143, 0, 0, 1, 0, 100, 0), +(928800, 7, 383.039, -3522.556, 154.207, 0, 0, 1, 0, 100, 0), +(928800, 8, 111.62, -3633.633, 166.753, 0, 0, 1, 0, 100, 0), +(928800, 9, -156.406, -3358.144, 162.886, 0, 0, 1, 0, 100, 0), +(928800, 10, -34.626, -3047.4, 160.192, 0, 0, 1, 0, 100, 0), +(928800, 11, 171.691, -2338.09, 152.636, 0, 0, 1, 0, 100, 0), +(928800, 12, 197.218, -2249.241, 147.71, 0, 0, 1, 0, 100, 0), +(928800, 13, 274.237, -2162.325, 147.09, 0, 0, 1, 0, 100, 0); diff --git a/sql/updates/world/2015_07_01_25_world_2015_05_22_05.sql b/sql/updates/world/2015_07_01_25_world_2015_05_22_05.sql new file mode 100644 index 00000000000..076c8fe22de --- /dev/null +++ b/sql/updates/world/2015_07_01_25_world_2015_05_22_05.sql @@ -0,0 +1,5 @@ +-- +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (2261); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2261) 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 +(2261, 0, 0, 0, 0, 0, 100, 0, 2000, 7000, 20000, 30000, 11, 3582, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0,0,'Syndicate Watchman - IC - Cast Torch Burst'); diff --git a/sql/updates/world/2015_07_01_26_world_2015_05_22_04.sql b/sql/updates/world/2015_07_01_26_world_2015_05_22_04.sql new file mode 100644 index 00000000000..3adfb19e640 --- /dev/null +++ b/sql/updates/world/2015_07_01_26_world_2015_05_22_04.sql @@ -0,0 +1,3 @@ +-- +UPDATE `creature` SET `MovementType`=1, `spawndist`=10 WHERE `id`IN (10956); +UPDATE `creature_template` SET `InhabitType`=2 WHERE `entry`=10956; diff --git a/sql/updates/world/2015_07_01_27_world_2015_05_22_03.sql b/sql/updates/world/2015_07_01_27_world_2015_05_22_03.sql new file mode 100644 index 00000000000..31ba798f2da --- /dev/null +++ b/sql/updates/world/2015_07_01_27_world_2015_05_22_03.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature` SET `MovementType`=1, `spawndist`=8, `position_x`=-93.361, `position_y`=1246.15, `position_z`=-123.506 WHERE `guid`=48268; diff --git a/sql/updates/world/2015_07_01_28_world_2015_05_22_02.sql b/sql/updates/world/2015_07_01_28_world_2015_05_22_02.sql new file mode 100644 index 00000000000..34f4c0350ec --- /dev/null +++ b/sql/updates/world/2015_07_01_28_world_2015_05_22_02.sql @@ -0,0 +1,6 @@ +-- +UPDATE `creature_text` SET `text`='Sands consume you!', `BroadcastTextId`=6221, `sound`=5872 WHERE `entry`=7271 AND `GroupId`=1; +UPDATE `creature_text` SET `sound`=5872 WHERE `entry`=7271 AND `GroupId`=2 AND `id`=2; +UPDATE `creature_text` SET `sound`=5873 WHERE `entry`=7271 AND `GroupId`=2 AND `id`=3; +-- Fix faction for some Ethereum prisoners +UPDATE `creature_template` SET `faction`=1800 WHERE `entry`IN (20783, 20784, 20785, 20786, 20788, 20789, 20790); diff --git a/sql/updates/world/2015_07_01_29_world_2015_05_22_01.sql b/sql/updates/world/2015_07_01_29_world_2015_05_22_01.sql new file mode 100644 index 00000000000..5f107d8cc28 --- /dev/null +++ b/sql/updates/world/2015_07_01_29_world_2015_05_22_01.sql @@ -0,0 +1,65 @@ +-- +DELETE FROM `creature_formations` WHERE `leaderGUID`=15424; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES +(15424,15424,0,0,2),(15424,15423,3,0,2); +UPDATE `creature` SET `position_x`=-36.31, `position_y`=-916.366, `position_z`=55.075, `orientation`= 1.062 WHERE `guid`=15424; +UPDATE `creature` SET `position_x`=-37.248, `position_y`=-914.605, `position_z`=55.343, `orientation`= 0.826 WHERE `guid`=15423; +UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (15424); +UPDATE `creature_addon` SET `path_id`=154240 WHERE `guid` IN (15424); +DELETE FROM `waypoint_data` WHERE `id` IN (154240); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(154240, 1, -36.31, -916.366, 55.075, 1.062, 180000, 0, 0, 100, 0), +(154240, 2, -28.532600, -902.440735, 55.908634, 0, 0, 0, 0, 100, 0), +(154240, 3, -26.338741, -896.902466, 56.039452, 0, 0, 0, 0, 100, 0), +(154240, 4, -51.500923, -836.734619, 56.524872, 0, 0, 0, 0, 100, 0), +(154240, 5, -17.165236, -802.633240, 58.751846, 0, 0, 0, 0, 100, 0), +(154240, 6, -20.983173, -719.063965, 69.290993, 0, 0, 0, 0, 100, 0), +(154240, 7, -149.228104, -712.801025, 64.445107, 0, 0, 0, 0, 100, 0), +(154240, 8, -226.017303, -722.711487, 60.861263, 0, 0, 0, 0, 100, 0), +(154240, 9, -325.539337, -754.267334, 54.089657, 0, 0, 0, 0, 100, 0), +(154240, 10, -377.870178, -776.472351, 54.472977, 0, 0, 0, 0, 100, 0), +(154240, 11, -403.164459, -680.892700, 54.499004, 0, 0, 0, 0, 100, 0), +(154240, 12, -331.617737, -671.147278, 54.918808, 0, 0, 0, 0, 100, 0), +(154240, 13, -341.247772, -713.172363, 57.733025, 0, 0, 0, 0, 100, 0), +(154240, 14, -340.614716, -711.776184, 57.733025, 0, 120000, 0, 0, 100, 0), +(154240, 15, -325.247681, -677.673950, 54.596302, 0, 0, 0, 0, 100, 0), +(154240, 16, -339.869904, -673.187561, 55.012871, 0, 0, 0, 0, 100, 0), +(154240, 17, -385.749298, -685.196350, 54.387272, 0, 0, 0, 0, 100, 0), +(154240, 18, -413.708405, -656.887817, 54.488979, 0, 0, 0, 0, 100, 0), +(154240, 19, -440.757660, -585.658386, 53.424225, 0, 0, 0, 0, 100, 0), +(154240, 20, -520.923462, -558.851501, 39.920975, 0, 0, 0, 0, 100, 0), +(154240, 21, -569.159912, -567.547302, 32.809437, 0, 0, 0, 0, 100, 0), +(154240, 22, -594.511536, -575.940979, 31.982075, 0, 0, 0, 0, 100, 0), +(154240, 23, -650.699402, -560.431763, 26.120964, 0, 0, 0, 0, 100, 0), +(154240, 24, -691.624939, -568.642334, 24.540937, 0, 0, 0, 0, 100, 0), +(154240, 25, -707.109802, -562.611023, 22.809536, 0, 0, 0, 0, 100, 0), +(154240, 26, -724.787048, -549.384033, 20.291832, 0, 0, 0, 0, 100, 0), +(154240, 27, -811.109985, -542.174927, 15.771987, 0, 0, 0, 0, 100, 0), +(154240, 28, -817.549683, -533.020020, 15.160646, 0, 180000, 0, 0, 100, 0), +(154240, 29, -811.109985, -542.174927, 15.771987, 0, 0, 0, 0, 100, 0), +(154240, 30, -724.787048, -549.384033, 20.291832, 0, 0, 0, 0, 100, 0), +(154240, 31, -707.109802, -562.611023, 22.809536, 0, 0, 0, 0, 100, 0), +(154240, 32, -691.624939, -568.642334, 24.540937, 0, 0, 0, 0, 100, 0), +(154240, 33, -650.699402, -560.431763, 26.120964, 0, 0, 0, 0, 100, 0), +(154240, 34, -594.511536, -575.940979, 31.982075, 0, 0, 0, 0, 100, 0), +(154240, 35, -569.159912, -567.547302, 32.809437, 0, 0, 0, 0, 100, 0), +(154240, 36, -520.923462, -558.851501, 39.920975, 0, 0, 0, 0, 100, 0), +(154240, 37, -440.757660, -585.658386, 53.424225, 0, 0, 0, 0, 100, 0), +(154240, 38, -413.708405, -656.887817, 54.488979, 0, 0, 0, 0, 100, 0), +(154240, 39, -385.749298, -685.196350, 54.387272, 0, 0, 0, 0, 100, 0), +(154240, 40, -339.869904, -673.187561, 55.012871, 0, 0, 0, 0, 100, 0), +(154240, 41, -325.247681, -677.673950, 54.596302, 0, 0, 0, 0, 100, 0), +(154240, 42, -340.614716, -711.776184, 57.733025, 0, 120000, 0, 0, 100, 0), +(154240, 43, -341.247772, -713.172363, 57.733025, 0, 0, 0, 0, 100, 0), +(154240, 44, -331.617737, -671.147278, 54.918808, 0, 0, 0, 0, 100, 0), +(154240, 45, -403.164459, -680.892700, 54.499004, 0, 0, 0, 0, 100, 0), +(154240, 46, -377.870178, -776.472351, 54.472977, 0, 0, 0, 0, 100, 0), +(154240, 47, -325.539337, -754.267334, 54.089657, 0, 0, 0, 0, 100, 0), +(154240, 48, -226.017303, -722.711487, 60.861263, 0, 0, 0, 0, 100, 0), +(154240, 49, -149.228104, -712.801025, 64.445107, 0, 0, 0, 0, 100, 0), +(154240, 50, -20.983173, -719.063965, 69.290993, 0, 0, 0, 0, 100, 0), +(154240, 51, -17.165236, -802.633240, 58.751846, 0, 0, 0, 0, 100, 0), +(154240, 52, -51.500923, -836.734619, 56.524872, 0, 0, 0, 0, 100, 0), +(154240, 53, -26.338741, -896.902466, 56.039452, 0, 0, 0, 0, 100, 0), +(154240, 54, -28.532600, -902.440735, 55.908634, 0, 0, 0, 0, 100, 0), +(154240, 55, -38.973717, -917.010193, 55.065174, 1.062, 0, 0, 0, 100, 0); diff --git a/sql/updates/world/2015_07_01_30_world_2015_05_21_03.sql b/sql/updates/world/2015_07_01_30_world_2015_05_21_03.sql new file mode 100644 index 00000000000..bc4f73e45e3 --- /dev/null +++ b/sql/updates/world/2015_07_01_30_world_2015_05_21_03.sql @@ -0,0 +1,16 @@ +-- +-- Hellscream's Champion +DELETE FROM `gossip_menu_option` WHERE `menu_id`=9212; +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES +(9212, 0, 0, 'I am ready to leave, Durkot.', 25265, 1, 1, 0, 0, 0, 0, NULL, 25265); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9212 AND `SourceEntry`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 9212, 0, 0, 0, 28, 0, 11916, 0, 0, 0, 0, 0, '', 'Gossip Option requires quest completed'); + +-- Durkot Wolfbrother SAI +SET @ENTRY := 26044; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,62,0,100,0,9212,0,0,0,85,46621,0,0,0,0,0,7,0,0,0,0,0,0,0,"Durkot Wolfbrother - On Gossip Option 0 Selected - Invoker Cast 'Worg Taxi'"); |