diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2021_11_06_00_world_335.sql | 75 |
1 files changed, 75 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_11_06_00_world_335.sql b/sql/updates/world/3.3.5/2021_11_06_00_world_335.sql new file mode 100644 index 00000000000..08dd249073a --- /dev/null +++ b/sql/updates/world/3.3.5/2021_11_06_00_world_335.sql @@ -0,0 +1,75 @@ +-- https://youtu.be/_zc32l8RVhs?t=17 https://youtu.be/vN5khJCqxCw?t=226 +DELETE FROM `smart_scripts` WHERE `entryorguid` = 9623 AND `source_type` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN 962300 AND 962303 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(9623,0,0,0,11,0,100,0,0,0,0,0,0,90,7,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Respawn - Set Flag Standstate Dead"), +(9623,0,1,0,4,0,50,0,0,0,0,0,0,1,3,0,1,0,0,0,7,0,0,0,0,0,0,0,0,"A-Me 01 - On Aggro - Say Line 3"), +(9623,0,2,0,0,0,100,256,5800,11800,14500,35600,0,11,13730,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - In Combat - Cast 'Demoralizing Shout' (No Reset)"), +(9623,0,3,0,19,0,100,0,4245,0,0,0,0,80,962300,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Quest 'Chasing A-Me 01' Taken - Run Script"), +(9623,0,4,0,58,0,100,0,0,962300,0,0,0,80,962301,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Waypoint Finished - Run Script"), +(9623,0,5,0,58,0,100,0,0,962301,0,0,0,80,962302,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Waypoint Finished - Run Script"), +(9623,0,6,0,58,0,100,0,0,962302,0,0,0,80,962303,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Waypoint Finished - Run Script"), +(9623,0,7,0,6,0,100,0,0,0,0,0,0,6,4245,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"A-Me 01 - On Death - Fail Quest 'Chasing A-Me 01'"), + +(962300,9,0,0,0,0,100,0,0,0,0,0,0,64,1,0,0,0,0,0,16,0,0,0,0,0,0,0,0,"A-Me 01 - On Script - Store Targetlist"), +(962300,9,1,0,0,0,100,0,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Script - Remove NPC Flag Questgiver"), +(962300,9,2,0,0,0,100,0,3000,3000,0,0,0,145,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Script - Set ImmuneNPC Off"), +(962300,9,3,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Script - Set Faction 113"), +(962300,9,4,0,0,0,100,0,0,0,0,0,0,91,7,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Script - Remove Flag Standstate Dead"), +(962300,9,5,0,0,0,100,0,1000,1000,0,0,0,1,0,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"A-Me 01 - On Script - Say Line 0"), +(962300,9,6,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"A-Me 01 - On Script - Set Orientation Stored Target 1"), +(962300,9,7,0,0,0,100,0,5000,5000,0,0,0,53,0,962300,0,0,0,3,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Script - Start Waypoint"), + +(962301,9,0,0,0,0,100,0,1000,1000,0,0,0,1,1,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"A-Me 01 - On Script - Say Line 1"), +(962301,9,1,0,0,0,100,0,3000,3000,0,0,0,53,0,962301,0,0,0,3,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Script - Start Waypoint"), + +(962302,9,0,0,0,0,100,0,1000,1000,0,0,0,1,2,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"A-Me 01 - On Script - Say Line 2"), +(962302,9,1,0,0,0,100,0,0,0,0,0,0,15,4245,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"A-Me 01 - On Script - Quest Credit 'Chasing A-Me 01'"), +(962302,9,2,0,0,0,100,0,0,0,0,0,0,53,0,962302,0,0,0,3,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Script - Start Waypoint"), + +(962303,9,0,0,0,0,100,0,10000,10000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"A-Me 01 - On Script - Despawn"); + +DELETE FROM `waypoints` WHERE `entry` IN (9623,962300,962301,962302); +INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES +(962300,1,-6383.07,-1964.37,-258.709,"A-Me 01"), +(962300,2,-6393.65,-1949.57,-261.449,"A-Me 01"), +(962300,3,-6397.85,-1931.1,-263.366,"A-Me 01"), +(962300,4,-6397.5,-1921.47,-263.876,"A-Me 01"), +(962300,5,-6389.63,-1910,-259.601,"A-Me 01"), +(962300,6,-6380.07,-1905.45,-255.858,"A-Me 01"), +(962300,7,-6373.44,-1900.28,-254.774,"A-Me 01"), +(962300,8,-6372.87,-1893.5,-255.678,"A-Me 01"), +(962300,9,-6379.73,-1877.63,-259.654,"A-Me 01"), +(962300,10,-6380.26,-1871.14,-260.617,"A-Me 01"), +(962300,11,-6373.83,-1855.62,-259.566,"A-Me 01"), +(962300,12,-6368.82,-1847.77,-259.246,"A-Me 01"), +(962300,13,-6370.9,-1835.04,-260.212,"A-Me 01"), +(962300,14,-6376.59,-1821.59,-260.856,"A-Me 01"), +(962300,15,-6381.93,-1810.43,-266.18,"A-Me 01"), +(962300,16,-6396.71,-1807.12,-269.329,"A-Me 01"), +(962300,17,-6400.27,-1795.05,-269.744,"A-Me 01"), +(962300,18,-6402.68,-1747.51,-272.961,"A-Me 01"), +(962300,19,-6397,-1710.05,-273.719,"A-Me 01"), +(962300,20,-6388.11,-1676.33,-272.133,"A-Me 01"), + +(962301,1,-6370.71,-1638.64,-272.031,"A-Me 01"), +(962301,2,-6366.71,-1592.65,-272.201,"A-Me 01"), +(962301,3,-6333.87,-1534.6,-270.493,"A-Me 01"), +(962301,4,-6305.36,-1477.91,-269.518,"A-Me 01"), +(962301,5,-6311.59,-1419.02,-267.622,"A-Me 01"), +(962301,6,-6330.01,-1400.06,-266.425,"A-Me 01"), +(962301,7,-6356.02,-1392.61,-267.123,"A-Me 01"), +(962301,8,-6370.86,-1386.18,-270.218,"A-Me 01"), +(962301,9,-6381.53,-1369.78,-272.11,"A-Me 01"), +(962301,10,-6405.38,-1321.52,-271.699,"A-Me 01"), +(962301,11,-6406.58,-1307.57,-271.802,"A-Me 01"), +(962301,12,-6386.33,-1286.85,-272.074,"A-Me 01"), +(962301,13,-6364.25,-1264.71,-269.075,"A-Me 01"), +(962301,14,-6343.64,-1239.84,-268.364,"A-Me 01"), +(962301,15,-6335.57,-1202.45,-271.515,"A-Me 01"), +(962301,16,-6325.62,-1184.46,-270.461,"A-Me 01"), +(962301,17,-6317.8,-1177.67,-269.792,"A-Me 01"), +(962301,18,-6303.02,-1180.25,-269.332,"A-Me 01"), + +(962302,1,-6301.98,-1184.79,-269.371,"A-Me 01"), +(962302,2,-6297.58,-1186.41,-268.962,"A-Me 01"); |