From 73282f9789724e30f45c89b80bd26fc8e618e8b0 Mon Sep 17 00:00:00 2001 From: click Date: Sat, 10 Mar 2012 15:10:36 +0100 Subject: SQL: Fix one of the filenames from commit 0ad6238a96 --- .../world/2012_03_10_00_world_smart_scripts | 129 --------------------- .../world/2012_03_10_00_world_smart_scripts.sql | 129 +++++++++++++++++++++ 2 files changed, 129 insertions(+), 129 deletions(-) delete mode 100644 sql/updates/world/2012_03_10_00_world_smart_scripts create mode 100644 sql/updates/world/2012_03_10_00_world_smart_scripts.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_03_10_00_world_smart_scripts b/sql/updates/world/2012_03_10_00_world_smart_scripts deleted file mode 100644 index aaa02c2e3df..00000000000 --- a/sql/updates/world/2012_03_10_00_world_smart_scripts +++ /dev/null @@ -1,129 +0,0 @@ --- SAI for Champion Vranesh -SET @ENTRY=18146; -UPDATE `creature` SET `position_x`=9834.044,`position_y`=-7480.845,`position_z`=14.93467 WHERE `id`=@ENTRY; -UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY; -UPDATE `creature_template_addon` SET `mount`=0 WHERE `entry`=@ENTRY; -- 19085 -DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; -DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` IN (@ENTRY*100,@ENTRY*100+1,@ENTRY*100+2,@ENTRY*100+3,@ENTRY*100+4); -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 --- AI -(@ENTRY,0,0,0,11,0,100,1,0,0,0,0,53,0,@ENTRY,1,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On respawn - load path'), -(@ENTRY,0,1,2,40,0,100,0,7,@ENTRY,0,0,54,6000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), -(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Run Script'), -(@ENTRY,0,3,4,40,0,100,0,11,@ENTRY,0,0,54,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), -(@ENTRY,0,4,0,61,0,100,0,0,0,0,0,80,@ENTRY*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Run Script'), -(@ENTRY,0,5,6,40,0,100,0,25,@ENTRY,0,0,54,8000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), -(@ENTRY,0,6,0,61,0,100,0,0,0,0,0,80,@ENTRY*100+2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Run Script'), -(@ENTRY,0,7,8,40,0,100,0,34,@ENTRY,0,0,54,8000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), -(@ENTRY,0,8,0,61,0,100,0,0,0,0,0,80,@ENTRY*100+3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Run Script'), -(@ENTRY,0,9,10,40,0,100,0,50,@ENTRY,0,0,54,7000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), -(@ENTRY,0,10,0,61,0,100,0,0,0,0,0,80,@ENTRY*100+4,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Run Script'), -(@ENTRY,0,11,0,40,0,100,0,57,@ENTRY,0,0,54,600000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), --- Script 0 -(@ENTRY*100,9,0,0,0,0,100,0,3500,3500,3500,3500,5,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 0 - emote bow'), --- Script 1 -(@ENTRY*100+1,9,0,0,0,0,100,0,100,100,100,100,43,0,19085,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 1 - mount horse'), -(@ENTRY*100+1,9,1,0,0,0,100,0,100,100,100,100,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 1 - say 0'), -(@ENTRY*100+1,9,2,0,0,0,100,0,100,100,100,100,5,16,0,0,0,0,0,11,16222,10,0,0,0,0,0,'Champion Vranesh - Script 1 - Silvermoon City Guardian emote bow'), -(@ENTRY*100+1,9,3,0,0,0,100,0,100,100,100,100,1,0,0,0,0,0,0,19,16222,10,0,0,0,0,0,'Champion Vranesh - Script 1 - Silvermoon City Guardian say 0'), --- Script 2 -(@ENTRY*100+2,9,0,0,0,0,100,0,3000,3000,3000,3000,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 2 - say 1'), -(@ENTRY*100+2,9,1,0,0,0,100,0,100,100,100,100,5,16,0,0,0,0,0,11,16222,18,0,0,0,0,0,'Champion Vranesh - Script 2 - Silvermoon City Guardian emote bow'), -(@ENTRY*100+2,9,2,0,0,0,100,0,100,100,100,100,1,1,0,0,0,0,0,19,16222,18,0,0,0,0,0,'Champion Vranesh - Script 2 - Silvermoon City Guardian say 1'), --- Script 3 -(@ENTRY*100+3,9,0,0,0,0,100,0,3000,3000,3000,3000,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 3 - say 2'), -(@ENTRY*100+3,9,1,0,0,0,100,0,100,100,100,100,5,16,0,0,0,0,0,11,16222,30,0,0,0,0,0,'Champion Vranesh - Script 3 - Silvermoon City Guardian emote bow'), --- Script 4 -(@ENTRY*100+4,9,0,0,0,0,100,0,1000,1000,1000,1000,43,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 4 - dismount horse'), -(@ENTRY*100+4,9,1,0,0,0,100,0,1000,1000,1000,1000,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 3 - say 3'); - --- NPC talk text for Champion Vranesh and Silvermoon City Guardian -DELETE FROM `creature_text` WHERE `entry` IN (@ENTRY,16222); -INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES -(@ENTRY,0,0, 'Champion Vranesh inclines his head slightly to the pair of guardians in greeting.',16,1,100,0,0,0, 'Champion Vranesh'), -(@ENTRY,1,0, 'Champion Vranesh arches a scrulpled brow at the guards. a disapproving scowl on his face',16,1,100,0,0,0, 'Champion Vranesh'), -(@ENTRY,2,0, 'Champion Vranesh glances from guard to guard.',16,1,100,0,0,0, 'Champion Vranesh'), -(@ENTRY,3,0, 'Champion Vranesh surveys the small ranger practice ground with a condescending smirk.',16,1,100,0,0,0, 'Champion Vranesh'), -(16222,0,0, 'Glory to the Sun K-- ah... Silvermoon!',12,1,100,0,0,0, 'Silvermoon City Guardian'), -(16222,1,0, 'Our lives are yours, Blood Knight.',12,1,100,0,0,0, 'Silvermoon City Guardian'); - --- Pathing for Champion Vranesh -DELETE FROM `waypoints` WHERE `entry`=@ENTRY; -INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES -(@ENTRY,1,9834.044,-7480.845,14.93467, 'Champion Vranesh'), -(@ENTRY,2,9829.106,-7493.609,14.93653, 'Champion Vranesh'), -(@ENTRY,3,9826.172,-7516.15,19.73714, 'Champion Vranesh'), -(@ENTRY,4,9841.332,-7518.849,19.70547, 'Champion Vranesh'), -(@ENTRY,5,9845.063,-7512.885,19.68096, 'Champion Vranesh'), -(@ENTRY,6,9850.942,-7512.470,19.71548, 'Champion Vranesh'), -(@ENTRY,7,9850.934,-7513.604,19.71813, 'Champion Vranesh'), -- pause 6000 -(@ENTRY,8,9872.733,-7517.256,19.75283, 'Champion Vranesh'), -(@ENTRY,9,9872.419,-7489.979,14.91272, 'Champion Vranesh'), -(@ENTRY,10,9851.401,-7490.209,14.93464, 'Champion Vranesh'), -(@ENTRY,11,9850.948,-7470.096,14.91403, 'Champion Vranesh'), -- pause 1000 -(@ENTRY,12,9851.16,-7469.154,14.91319, 'Champion Vranesh'), -(@ENTRY,13,9849.688,-7442.579,13.50931, 'Champion Vranesh'), -(@ENTRY,14,9848.726,-7423.561,13.31949, 'Champion Vranesh'), -(@ENTRY,15,9816.583,-7423.817,13.30332, 'Champion Vranesh'), -(@ENTRY,16,9794.673,-7424.877,13.50989, 'Champion Vranesh'), -(@ENTRY,17,9794.48,-7442.293,14.40225, 'Champion Vranesh'), -(@ENTRY,18,9767.989,-7442.611,14.39258, 'Champion Vranesh'), -(@ENTRY,19,9767.406,-7422.982,13.35852, 'Champion Vranesh'), -(@ENTRY,20,9739.563,-7422.83,13.28878, 'Champion Vranesh'), -(@ENTRY,21,9736.46,-7440.873,13.53963, 'Champion Vranesh'), -(@ENTRY,22,9740.345,-7464.682,13.57483, 'Champion Vranesh'), -(@ENTRY,23,9746.739,-7482.594,13.55744, 'Champion Vranesh'), -(@ENTRY,24,9748.767,-7486.576,13.54981, 'Champion Vranesh'), -(@ENTRY,25,9753.25,-7486.52,13.5461, 'Champion Vranesh'), -- pause 8000 -(@ENTRY,26,9720.037,-7486.478,13.52865, 'Champion Vranesh'), -(@ENTRY,27,9681.502,-7475.868,13.52783, 'Champion Vranesh'), -(@ENTRY,28,9666.59,-7479.547,13.53783, 'Champion Vranesh'), -(@ENTRY,29,9638.033,-7492.629,13.50889, 'Champion Vranesh'), -(@ENTRY,30,9620.123,-7488.486,13.53853, 'Champion Vranesh'), -(@ENTRY,31,9605.795,-7475.276,13.55774, 'Champion Vranesh'), -(@ENTRY,32,9597.921,-7460.307,13.54336, 'Champion Vranesh'), -(@ENTRY,33,9594.605,-7450.369,13.5353, 'Champion Vranesh'), -(@ENTRY,34,9592.944,-7450.381,13.53116, 'Champion Vranesh'), -- pause 8000 -(@ENTRY,35,9594.605,-7450.369,13.5353, 'Champion Vranesh'), -(@ENTRY,36,9615.793,-7419.515,13.30549, 'Champion Vranesh'), -(@ENTRY,37,9654.939,-7420.383,13.29342, 'Champion Vranesh'), -(@ENTRY,38,9673.072,-7429.818,13.2933, 'Champion Vranesh'), -(@ENTRY,39,9689.373,-7431.429,13.2933, 'Champion Vranesh'), -(@ENTRY,40,9709.577,-7422.25,13.2933, 'Champion Vranesh'), -(@ENTRY,41,9722.3,-7415.217,13.39988, 'Champion Vranesh'), -(@ENTRY,42,9748.049,-7414.597,13.32135, 'Champion Vranesh'), -(@ENTRY,43,9766.792,-7413.542,13.38617, 'Champion Vranesh'), -(@ENTRY,44,9767.26,-7396.828,14.43101, 'Champion Vranesh'), -(@ENTRY,45,9793.145,-7395.393,14.3936, 'Champion Vranesh'), -(@ENTRY,46,9794.217,-7415.122,13.48684, 'Champion Vranesh'), -(@ENTRY,47,9817.575,-7415.299,13.30596, 'Champion Vranesh'), -(@ENTRY,48,9837.021,-7414.861,13.30863, 'Champion Vranesh'), -(@ENTRY,49,9848.048,-7414.794,13.31137, 'Champion Vranesh'), -(@ENTRY,50,9848.199,-7414.07,13.31068, 'Champion Vranesh'), -- pause 7000 -(@ENTRY,51,9847.695,-7415.903,13.31243, 'Champion Vranesh'), -(@ENTRY,52,9848.259,-7428.576,13.33225, 'Champion Vranesh'), -(@ENTRY,53,9846.748,-7446.964,13.56501, 'Champion Vranesh'), -(@ENTRY,54,9850.373,-7465.03,14.9097, 'Champion Vranesh'), -(@ENTRY,55,9850.84,-7480.409,14.93768, 'Champion Vranesh'), -(@ENTRY,56,9840.165,-7480.267,14.92917, 'Champion Vranesh'), -(@ENTRY,57,9843.284,-7480.133,14.92655, 'Champion Vranesh'); -- pause 60000 - --- SAI for Silvermoon Farstrider -SET @ENTRY=18507; -UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY; -DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; -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,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Farstrider - Reset - Set Phase 1'), -(@ENTRY,0,1,2,1,1,100,0,3000,3000,5000,5000,11,36802,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Farstrider - OOC - Cast Spell (Phase 1)'), -(@ENTRY,0,2,0,61,1,100,0,0,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Farstrider - OOC - Set Phase 2 (Phase 1)'), -(@ENTRY,0,3,4,1,2,100,0,3000,3000,5000,5000,11,36803,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Farstrider - OOC - Cast Spell (Phase 2)'), -(@ENTRY,0,4,0,61,2,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Farstrider - OOC - Set Phase 1 (Phase 2)'); --- SAI for Silvermoon Ranger -SET @ENTRY=18147; -UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY; -DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (-64950,-64951,-64952,-64953); -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 -(-64950,0,0,0,1,0,100,0,18000,22000,18000,22000,11,29121,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Ranger - OOC - Cast Spell'), -(-64951,0,0,0,1,0,100,0,18000,22000,18000,22000,11,29121,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Ranger - OOC - Cast Spell'), -(-64952,0,0,0,1,0,100,0,18000,22000,18000,22000,11,29120,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Ranger - OOC - Cast Spell'), -(-64953,0,0,0,1,0,100,0,18000,22000,18000,22000,11,29122,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Ranger - OOC - Cast Spell'); diff --git a/sql/updates/world/2012_03_10_00_world_smart_scripts.sql b/sql/updates/world/2012_03_10_00_world_smart_scripts.sql new file mode 100644 index 00000000000..aaa02c2e3df --- /dev/null +++ b/sql/updates/world/2012_03_10_00_world_smart_scripts.sql @@ -0,0 +1,129 @@ +-- SAI for Champion Vranesh +SET @ENTRY=18146; +UPDATE `creature` SET `position_x`=9834.044,`position_y`=-7480.845,`position_z`=14.93467 WHERE `id`=@ENTRY; +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY; +UPDATE `creature_template_addon` SET `mount`=0 WHERE `entry`=@ENTRY; -- 19085 +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` IN (@ENTRY*100,@ENTRY*100+1,@ENTRY*100+2,@ENTRY*100+3,@ENTRY*100+4); +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 +-- AI +(@ENTRY,0,0,0,11,0,100,1,0,0,0,0,53,0,@ENTRY,1,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On respawn - load path'), +(@ENTRY,0,1,2,40,0,100,0,7,@ENTRY,0,0,54,6000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Run Script'), +(@ENTRY,0,3,4,40,0,100,0,11,@ENTRY,0,0,54,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), +(@ENTRY,0,4,0,61,0,100,0,0,0,0,0,80,@ENTRY*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Run Script'), +(@ENTRY,0,5,6,40,0,100,0,25,@ENTRY,0,0,54,8000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), +(@ENTRY,0,6,0,61,0,100,0,0,0,0,0,80,@ENTRY*100+2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Run Script'), +(@ENTRY,0,7,8,40,0,100,0,34,@ENTRY,0,0,54,8000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), +(@ENTRY,0,8,0,61,0,100,0,0,0,0,0,80,@ENTRY*100+3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Run Script'), +(@ENTRY,0,9,10,40,0,100,0,50,@ENTRY,0,0,54,7000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), +(@ENTRY,0,10,0,61,0,100,0,0,0,0,0,80,@ENTRY*100+4,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Run Script'), +(@ENTRY,0,11,0,40,0,100,0,57,@ENTRY,0,0,54,600000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - On waypoint reached - Pause Path'), +-- Script 0 +(@ENTRY*100,9,0,0,0,0,100,0,3500,3500,3500,3500,5,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 0 - emote bow'), +-- Script 1 +(@ENTRY*100+1,9,0,0,0,0,100,0,100,100,100,100,43,0,19085,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 1 - mount horse'), +(@ENTRY*100+1,9,1,0,0,0,100,0,100,100,100,100,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 1 - say 0'), +(@ENTRY*100+1,9,2,0,0,0,100,0,100,100,100,100,5,16,0,0,0,0,0,11,16222,10,0,0,0,0,0,'Champion Vranesh - Script 1 - Silvermoon City Guardian emote bow'), +(@ENTRY*100+1,9,3,0,0,0,100,0,100,100,100,100,1,0,0,0,0,0,0,19,16222,10,0,0,0,0,0,'Champion Vranesh - Script 1 - Silvermoon City Guardian say 0'), +-- Script 2 +(@ENTRY*100+2,9,0,0,0,0,100,0,3000,3000,3000,3000,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 2 - say 1'), +(@ENTRY*100+2,9,1,0,0,0,100,0,100,100,100,100,5,16,0,0,0,0,0,11,16222,18,0,0,0,0,0,'Champion Vranesh - Script 2 - Silvermoon City Guardian emote bow'), +(@ENTRY*100+2,9,2,0,0,0,100,0,100,100,100,100,1,1,0,0,0,0,0,19,16222,18,0,0,0,0,0,'Champion Vranesh - Script 2 - Silvermoon City Guardian say 1'), +-- Script 3 +(@ENTRY*100+3,9,0,0,0,0,100,0,3000,3000,3000,3000,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 3 - say 2'), +(@ENTRY*100+3,9,1,0,0,0,100,0,100,100,100,100,5,16,0,0,0,0,0,11,16222,30,0,0,0,0,0,'Champion Vranesh - Script 3 - Silvermoon City Guardian emote bow'), +-- Script 4 +(@ENTRY*100+4,9,0,0,0,0,100,0,1000,1000,1000,1000,43,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 4 - dismount horse'), +(@ENTRY*100+4,9,1,0,0,0,100,0,1000,1000,1000,1000,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Champion Vranesh - Script 3 - say 3'); + +-- NPC talk text for Champion Vranesh and Silvermoon City Guardian +DELETE FROM `creature_text` WHERE `entry` IN (@ENTRY,16222); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(@ENTRY,0,0, 'Champion Vranesh inclines his head slightly to the pair of guardians in greeting.',16,1,100,0,0,0, 'Champion Vranesh'), +(@ENTRY,1,0, 'Champion Vranesh arches a scrulpled brow at the guards. a disapproving scowl on his face',16,1,100,0,0,0, 'Champion Vranesh'), +(@ENTRY,2,0, 'Champion Vranesh glances from guard to guard.',16,1,100,0,0,0, 'Champion Vranesh'), +(@ENTRY,3,0, 'Champion Vranesh surveys the small ranger practice ground with a condescending smirk.',16,1,100,0,0,0, 'Champion Vranesh'), +(16222,0,0, 'Glory to the Sun K-- ah... Silvermoon!',12,1,100,0,0,0, 'Silvermoon City Guardian'), +(16222,1,0, 'Our lives are yours, Blood Knight.',12,1,100,0,0,0, 'Silvermoon City Guardian'); + +-- Pathing for Champion Vranesh +DELETE FROM `waypoints` WHERE `entry`=@ENTRY; +INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES +(@ENTRY,1,9834.044,-7480.845,14.93467, 'Champion Vranesh'), +(@ENTRY,2,9829.106,-7493.609,14.93653, 'Champion Vranesh'), +(@ENTRY,3,9826.172,-7516.15,19.73714, 'Champion Vranesh'), +(@ENTRY,4,9841.332,-7518.849,19.70547, 'Champion Vranesh'), +(@ENTRY,5,9845.063,-7512.885,19.68096, 'Champion Vranesh'), +(@ENTRY,6,9850.942,-7512.470,19.71548, 'Champion Vranesh'), +(@ENTRY,7,9850.934,-7513.604,19.71813, 'Champion Vranesh'), -- pause 6000 +(@ENTRY,8,9872.733,-7517.256,19.75283, 'Champion Vranesh'), +(@ENTRY,9,9872.419,-7489.979,14.91272, 'Champion Vranesh'), +(@ENTRY,10,9851.401,-7490.209,14.93464, 'Champion Vranesh'), +(@ENTRY,11,9850.948,-7470.096,14.91403, 'Champion Vranesh'), -- pause 1000 +(@ENTRY,12,9851.16,-7469.154,14.91319, 'Champion Vranesh'), +(@ENTRY,13,9849.688,-7442.579,13.50931, 'Champion Vranesh'), +(@ENTRY,14,9848.726,-7423.561,13.31949, 'Champion Vranesh'), +(@ENTRY,15,9816.583,-7423.817,13.30332, 'Champion Vranesh'), +(@ENTRY,16,9794.673,-7424.877,13.50989, 'Champion Vranesh'), +(@ENTRY,17,9794.48,-7442.293,14.40225, 'Champion Vranesh'), +(@ENTRY,18,9767.989,-7442.611,14.39258, 'Champion Vranesh'), +(@ENTRY,19,9767.406,-7422.982,13.35852, 'Champion Vranesh'), +(@ENTRY,20,9739.563,-7422.83,13.28878, 'Champion Vranesh'), +(@ENTRY,21,9736.46,-7440.873,13.53963, 'Champion Vranesh'), +(@ENTRY,22,9740.345,-7464.682,13.57483, 'Champion Vranesh'), +(@ENTRY,23,9746.739,-7482.594,13.55744, 'Champion Vranesh'), +(@ENTRY,24,9748.767,-7486.576,13.54981, 'Champion Vranesh'), +(@ENTRY,25,9753.25,-7486.52,13.5461, 'Champion Vranesh'), -- pause 8000 +(@ENTRY,26,9720.037,-7486.478,13.52865, 'Champion Vranesh'), +(@ENTRY,27,9681.502,-7475.868,13.52783, 'Champion Vranesh'), +(@ENTRY,28,9666.59,-7479.547,13.53783, 'Champion Vranesh'), +(@ENTRY,29,9638.033,-7492.629,13.50889, 'Champion Vranesh'), +(@ENTRY,30,9620.123,-7488.486,13.53853, 'Champion Vranesh'), +(@ENTRY,31,9605.795,-7475.276,13.55774, 'Champion Vranesh'), +(@ENTRY,32,9597.921,-7460.307,13.54336, 'Champion Vranesh'), +(@ENTRY,33,9594.605,-7450.369,13.5353, 'Champion Vranesh'), +(@ENTRY,34,9592.944,-7450.381,13.53116, 'Champion Vranesh'), -- pause 8000 +(@ENTRY,35,9594.605,-7450.369,13.5353, 'Champion Vranesh'), +(@ENTRY,36,9615.793,-7419.515,13.30549, 'Champion Vranesh'), +(@ENTRY,37,9654.939,-7420.383,13.29342, 'Champion Vranesh'), +(@ENTRY,38,9673.072,-7429.818,13.2933, 'Champion Vranesh'), +(@ENTRY,39,9689.373,-7431.429,13.2933, 'Champion Vranesh'), +(@ENTRY,40,9709.577,-7422.25,13.2933, 'Champion Vranesh'), +(@ENTRY,41,9722.3,-7415.217,13.39988, 'Champion Vranesh'), +(@ENTRY,42,9748.049,-7414.597,13.32135, 'Champion Vranesh'), +(@ENTRY,43,9766.792,-7413.542,13.38617, 'Champion Vranesh'), +(@ENTRY,44,9767.26,-7396.828,14.43101, 'Champion Vranesh'), +(@ENTRY,45,9793.145,-7395.393,14.3936, 'Champion Vranesh'), +(@ENTRY,46,9794.217,-7415.122,13.48684, 'Champion Vranesh'), +(@ENTRY,47,9817.575,-7415.299,13.30596, 'Champion Vranesh'), +(@ENTRY,48,9837.021,-7414.861,13.30863, 'Champion Vranesh'), +(@ENTRY,49,9848.048,-7414.794,13.31137, 'Champion Vranesh'), +(@ENTRY,50,9848.199,-7414.07,13.31068, 'Champion Vranesh'), -- pause 7000 +(@ENTRY,51,9847.695,-7415.903,13.31243, 'Champion Vranesh'), +(@ENTRY,52,9848.259,-7428.576,13.33225, 'Champion Vranesh'), +(@ENTRY,53,9846.748,-7446.964,13.56501, 'Champion Vranesh'), +(@ENTRY,54,9850.373,-7465.03,14.9097, 'Champion Vranesh'), +(@ENTRY,55,9850.84,-7480.409,14.93768, 'Champion Vranesh'), +(@ENTRY,56,9840.165,-7480.267,14.92917, 'Champion Vranesh'), +(@ENTRY,57,9843.284,-7480.133,14.92655, 'Champion Vranesh'); -- pause 60000 + +-- SAI for Silvermoon Farstrider +SET @ENTRY=18507; +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +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,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Farstrider - Reset - Set Phase 1'), +(@ENTRY,0,1,2,1,1,100,0,3000,3000,5000,5000,11,36802,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Farstrider - OOC - Cast Spell (Phase 1)'), +(@ENTRY,0,2,0,61,1,100,0,0,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Farstrider - OOC - Set Phase 2 (Phase 1)'), +(@ENTRY,0,3,4,1,2,100,0,3000,3000,5000,5000,11,36803,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Farstrider - OOC - Cast Spell (Phase 2)'), +(@ENTRY,0,4,0,61,2,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Farstrider - OOC - Set Phase 1 (Phase 2)'); +-- SAI for Silvermoon Ranger +SET @ENTRY=18147; +UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (-64950,-64951,-64952,-64953); +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 +(-64950,0,0,0,1,0,100,0,18000,22000,18000,22000,11,29121,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Ranger - OOC - Cast Spell'), +(-64951,0,0,0,1,0,100,0,18000,22000,18000,22000,11,29121,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Ranger - OOC - Cast Spell'), +(-64952,0,0,0,1,0,100,0,18000,22000,18000,22000,11,29120,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Ranger - OOC - Cast Spell'), +(-64953,0,0,0,1,0,100,0,18000,22000,18000,22000,11,29122,0,0,0,0,0,1,0,0,0,0,0,0,0,'Silvermoon Ranger - OOC - Cast Spell'); -- cgit v1.2.3