diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_06_03_01_world.sql | 162 |
1 files changed, 162 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_06_03_01_world.sql b/sql/updates/world/3.3.5/2019_06_03_01_world.sql new file mode 100644 index 00000000000..3c8c1dbee8b --- /dev/null +++ b/sql/updates/world/3.3.5/2019_06_03_01_world.sql @@ -0,0 +1,162 @@ +-- +DELETE FROM `creature` WHERE `id` IN (23153,23154) AND `guid` IN (109148, 109149, 109150, 109151, 109152, 109223, 109498, 109499, 109504, 109626, 109631, 109643); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(109148, 23153, 530, 1, 1, 1, 4117.67, 5379.04, 266.612, 2.49582, 1800, 0, 2), +(109149, 23153, 530, 1, 1, 1, 3971.33, 5668.72, 267.517, 3.35698, 1800, 0, 2), +(109150, 23153, 530, 1, 1, 1, 3914.38, 4913.13, 268.249, 1.44054, 1800, 0, 2), +(109151, 23153, 530, 1, 1, 1, 4078.18, 5123.28, 266.949, 2.26103, 1800, 0, 2), +(109152, 23154, 530, 1, 1, 1, 4110.278 ,5381.844, 266.1487, 5.727434, 1800, 0, 0), +(109223, 23154, 530, 1, 1, 1, 4114.102 ,5368.567, 267.6211, 1.418258, 1800, 0, 0), +(109498, 23154, 530, 1, 1, 1, 3967.494 ,5675.388, 267.7566, 4.963231, 1800, 0, 0), +(109499, 23154, 530, 1, 1, 1, 3967.432 ,5660.811, 268.5316, 1.414797, 1800, 0, 0), +(109504, 23154, 530, 1, 1, 1, 3920.013 ,4910.366, 267.7971, 2.549393, 1800, 0, 0), +(109626, 23154, 530, 1, 1, 1, 3915.637 ,4918.675, 268.0701, 4.993489, 1800, 0, 0), +(109631, 23154, 530, 1, 1, 1, 4070.757 ,5127.342, 267.5959, 5.573686, 1800, 0, 0), +(109643, 23154, 530, 1, 1, 1, 4076.135 ,5114.612, 267.8706, 1.363137, 1800, 0, 0); + +DELETE FROM `creature_addon` WHERE `guid` IN (109148, 109149, 109150, 109151); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(109148,1091480,0,1,'40306'), +(109149,1091490,0,1,'40306'), +(109150,1091500,0,1,'40306'), +(109151,1091510,0,1,'40306'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (13,17) AND `SourceEntry`=40307; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition` ,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,3,40307,0,0,31,0,3,22175,0,0,0,'','Stasis Field'), +(13,3,40307,0,0,1,0,40307,0,0,1,0,'','Stasis Field'), +(13,3,40307,0,1,31,0,3,22255,0,0,0,'','Stasis Field'), +(13,3,40307,0,1,1,0,40307,0,0,1,0,'','Stasis Field'), +(13,3,40307,0,2,31,0,3,22181,0,0,0,'','Stasis Field'), +(13,3,40307,0,2,1,0,40307,0,0,1,0,'','Stasis Field'), +(13,3,40307,0,3,31,0,3,22180,0,0,0,'','Stasis Field'), +(13,3,40307,0,3,1,0,40307,0,0,1,0,'','Stasis Field'); + +DELETE FROM `creature_text` WHERE `CreatureID`=23153; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(23153, 0, 0, 'Check those crystals over there!', 12,0,100,1,0,0,21004,0, 'Bash''ir Surveyor (Entry: 23153)'), +(23153, 0, 1, 'Find what I am looking for and you may have a treat.', 12,0,100,1,0,0,21007,0, 'Bash''ir Surveyor (Entry: 23153)'), +(23153, 0, 2, 'That grouping looks promising.', 12,0,100,1,0,0,21006,0, 'Bash''ir Surveyor (Entry: 23153)'), +(23153, 1, 0, 'I am beginning to suspect you are worthless. Do not disappoint me further.', 12,0,100,1,0,0,21008,0, 'Bash''ir Surveyor (Entry: 23153)'), +(23153, 1, 1, 'Yes, that''s it. These will do nicely.', 12,0,100,1,0,0,21009,0, 'Bash''ir Surveyor (Entry: 23153)'), +(23153, 1, 2, 'You''ve found nothing? Very well. Over there next.', 12,0,100,1,0,0,21005,0, 'Bash''ir Surveyor (Entry: 23153)'); + +DELETE FROM `pool_template` WHERE `entry` IN (645,646,647,648,649); +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(645, 3, 'Bash''ir - Bash''ir Surveyor (23153) and Mana-debt Slave (23154) 1'), +(646, 3, 'Bash''ir - Bash''ir Surveyor (23153) and Mana-debt Slave (23154) 2'), +(647, 3, 'Bash''ir - Bash''ir Surveyor (23153) and Mana-debt Slave (23154) 3'), +(648, 3, 'Bash''ir - Bash''ir Surveyor (23153) and Mana-debt Slave (23154) 4'), +(649, 1, 'Bash''ir - Bash''ir Surveyor (23153) and Mana-debt Slave (23154) Mother Pool'); + +DELETE FROM `pool_creature` WHERE `pool_entry` IN (645,646,647,648); +INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES +(109148,645, 0, 'Bash''ir Surveyor (23153)'), +(109152,645, 0, 'Mana-debt Slave (23154)'), +(109223,645, 0, 'Mana-debt Slave (23154)'), +(109149,646, 0, 'Bash''ir Surveyor (23153)'), +(109498,646, 0, 'Mana-debt Slave (23154)'), +(109499,646, 0, 'Mana-debt Slave (23154)'), +(109150,647, 0, 'Bash''ir Surveyor (23153)'), +(109504,647, 0, 'Mana-debt Slave (23154)'), +(109626,647, 0, 'Mana-debt Slave (23154)'), +(109151,648, 0, 'Bash''ir Surveyor (23153)'), +(109631,648, 0, 'Mana-debt Slave (23154)'), +(109643,648, 0, 'Mana-debt Slave (23154)'); + +DELETE FROM `pool_pool` WHERE `mother_pool`=649; +INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`) VALUES +(645, 649, 0, 'Bash''ir Surveyor (23153) and Mana-debt Slave (23154)'), +(646, 649, 0, 'Bash''ir Surveyor (23153) and Mana-debt Slave (23154)'), +(647, 649, 0, 'Bash''ir Surveyor (23153) and Mana-debt Slave (23154)'), +(648, 649, 0, 'Bash''ir Surveyor (23153) and Mana-debt Slave (23154)'); + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (109148,109149,109150,109151); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(109148, 109148, 0, 0, 515, 0, 0), +(109148, 109152, 5, 70, 515, 0, 0), +(109148, 109223, 5, 290, 515, 0, 0), +(109149, 109149, 0, 0, 515, 0, 0), +(109149, 109498, 5, 70, 515, 0, 0), +(109149, 109499, 5, 290, 515, 0, 0), +(109150, 109150, 0, 0, 515, 0, 0), +(109150, 109504, 5, 70, 515, 0, 0), +(109150, 109626, 5, 290, 515, 0, 0), +(109151, 109151, 0, 0, 515, 0, 0), +(109151, 109631, 5, 70, 515, 0, 0), +(109151, 109643, 5, 290, 515, 0, 0); + +DELETE FROM `waypoint_data` WHERE `id` IN (1091480, 1091490, 1091500, 1091510); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`,`action`, `orientation`, `action_chance`, `move_type`, `wpguid`) VALUES +(1091480,1,4088.924,5360.324,266.8262,0,0,100, 100, 0, 0), +(1091480,2,4086.19,5334.616,272.1114,30000,0,100, 100, 0, 0), +(1091480,3,4055.083,5388.747,268.2536,0,0,100, 100, 0, 0), +(1091480,4,4018.438,5403.46,266.9296,30000,0,100, 100, 0, 0), +(1091480,5,4041.49,5440.908,266.7763,0,0,100, 100, 0, 0), +(1091480,6,4061.738,5470.963,267.3727,30000,0,100, 100, 0, 0), +(1091480,7,4081.422,5433.799,266.9398,0,0,100, 100, 0, 0), +(1091480,8,4088.155,5399.219,264.8799,0,0,100, 100, 0, 0), +(1091480,9,4099.717,5375.085,265.682,0,2315301,100, 100, 0, 0), +(1091490,1,3950.579,5664.166,267.8868,0,0,100, 100, 0, 0), +(1091490,2,3949.695,5648.014,267.833,30000,0,100, 100, 0, 0), +(1091490,3,3939.836,5699.776,267.8054,0,0,100, 100, 0, 0), +(1091490,4,3917.208,5714.594,267.5573,30000,0,100, 100, 0, 0), +(1091490,5,3953.256,5680.032,268.8732,0,0,100, 100, 0, 0), +(1091490,6,3983.988,5671.252,266.8484,0,0,100, 100, 0, 0), +(1091490,7,4018.189,5675.339,266.136,0,0,100, 100, 0, 0), +(1091490,8,4045.02,5677.407,267.089,30000,0,100, 100, 0, 0), +(1091490,9,4001.402,5668.4,267.5134,0,0,100, 100, 0, 0), +(1091490,10,3974.07,5668.724,267.664,0,2315301,100, 100, 0, 0), +(1091500,1,3921.228,4965.274,266.4946,0,0,100, 100, 0, 0), +(1091500,2,3910.742,4992.671,267.6488,30000,0,100, 100, 0, 0), +(1091500,3,3954.662,4958.776,266.2497,0,0,100, 100, 0, 0), +(1091500,4,3990.942,4941.342,268.8905,0,0,100, 100, 0, 0), +(1091500,5,4003.885,4918.704,266.4579,0,0,100, 100, 0, 0), +(1091500,6,4019.997,4916.955,265.7477,30000,0,100, 100, 0, 0), +(1091500,7,4001.091,4867.379,267.7419,0,0,100, 100, 0, 0), +(1091500,8,3966.167,4855.453,267.1823,0,0,100, 100, 0, 0), +(1091500,9,3938.668,4864.629,266.8073,0,0,100, 100, 0, 0), +(1091500,10,3917.792,4875.084,266.7963,30000,0,100, 100, 0, 0), +(1091500,11,3930.731,4901.205,267.671,0,0,100, 100, 0, 0), +(1091500,12,3917.535,4918.631,267.874,0,2315301,100, 100, 0, 0), +(1091510,1,4049.228,5158.38,265.8159,0,0,100, 100, 0, 0), +(1091510,2,4049.228,5158.38,265.8159,30000,0,100, 100, 0, 0), +(1091510,3,4013.033,5126.243,267.2072,0,0,100, 100, 0, 0), +(1091510,4,3994.749,5096.724,266.9342,0,0,100, 100, 0, 0), +(1091510,5,3972.481,5072.851,268.5905,30000,0,100, 100, 0, 0), +(1091510,6,4017.094,5033.253,268.2528,0,0,100, 100, 0, 0), +(1091510,7,4029.895,5002.403,267.9489,0,0,100, 100, 0, 0), +(1091510,8,4054.003,4995.914,267.5135,30000,0,100, 100, 0, 0), +(1091510,9,4058.921,5066.56,268.2322,0,0,100, 100, 0, 0), +(1091510,10,4066.631,5099.14,267.5258,0,0,100, 100, 0, 0), +(1091510,11,4069.543,5118.533,267.2003,0,0,100, 100, 0, 0); + +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (23153,23154); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-109148,-109149,-109150,-109151,23153,23154) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2315300,2315301) 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 +(-109148,0,0,0,34,0,100,0,2,1,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109148,0,1,0,34,0,100,0,2,3,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109148,0,2,0,34,0,100,0,2,5,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109148,0,3,0,34,0,100,0,2,8,0,0,80,2315301,2,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109149,0,0,0,34,0,100,0,2,1,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109149,0,1,0,34,0,100,0,2,3,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109149,0,2,0,34,0,100,0,2,7,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109149,0,3,0,34,0,100,0,2,9,0,0,80,2315301,2,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109150,0,0,0,34,0,100,0,2,1,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109150,0,1,0,34,0,100,0,2,5,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109150,0,2,0,34,0,100,0,2,9,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109150,0,3,0,34,0,100,0,2,11,0,0,80,2315301,2,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109151,0,0,0,34,0,100,0,2,1,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109151,0,1,0,34,0,100,0,2,4,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109151,0,2,0,34,0,100,0,2,7,0,0,80,2315300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(-109151,0,3,0,34,0,100,0,2,10,0,0,80,2315301,2,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On movement informer - Run Script"), +(2315300,9,0,0,0,0,100,0,2000,2000,0,0,1,0,0,1,0,0,0,19,23154,20,0,0,0,0,0,"Bash'ir Surveyor - On Script - Run Script"), +(2315300,9,1,0,0,0,100,0,2000,2000,0,0,45,1,1,0,0,0,0,11,23154,20,0,0,0,0,0,"Bash'ir Surveyor - On Script - Despawn"), +(2315300,9,2,0,0,0,100,0,24000,24000,0,0,1,1,0,1,0,0,0,19,23154,20,0,0,0,0,0,"Bash'ir Surveyor - On Script - Despawn"), +(2315300,9,3,0,0,0,100,0,2000,2000,0,0,45,2,2,0,0,0,0,11,23154,20,0,0,0,0,0,"Bash'ir Surveyor - On Script - Despawn"), +(2315301,9,0,0,0,0,100,0,0,0,0,0,1,0,0,1,0,0,0,19,23154,20,0,0,0,0,0,"Bash'ir Surveyor - On Script - Run Script"), +(2315301,9,1,0,0,0,100,0,1000,1000,0,0,41,0,0,0,0,0,0,11,23154,40,0,0,0,0,0,"Bash'ir Surveyor - On Script - Despawn"), +(2315301,9,2,0,0,0,100,0,1000,1000,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bash'ir Surveyor - On Script - Despawn"), +(23154,0,0,0,38,0,100,0,1,1,0,0,17,233,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mana-debt Slave - On data set - Emote state work"), +(23154,0,1,0,38,0,100,0,2,2,0,0,17,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mana-debt Slave - On data set - Emote state none"); |