Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Preparations for War
- SET @ENTRY_MOUNT_H := 30585; -- 121
- SET @ENTRY_MOUNT_A := 30470;
- SET @Klum:= 31085;
- SET @Rossem:=31081;
- UPDATE `creature_template` SET `npcflag`= 16777216,`VehicleId`=220, `HealthModifier`=2.344, `minlevel`=79, `maxlevel`=79, `InhabitType`=4, `AIName`='SmartAI', MovementType=1 WHERE `entry` IN (@ENTRY_MOUNT_H);
- UPDATE `creature_template` SET `npcflag`= 16777216,`VehicleId`=220, `HealthModifier`=2.344, `minlevel`=79, `maxlevel`=79, `InhabitType`=4, `AIName`='SmartAI', MovementType=1 WHERE `entry` IN (@ENTRY_MOUNT_A);
- UPDATE `creature_template` set `AIName`='SmartAI' where entry in (@Klum, @Rossem);
- DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` in (@ENTRY_MOUNT_H, @ENTRY_MOUNT_A);
- INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
- (@ENTRY_MOUNT_H, 46598, 1, 0),
- (@ENTRY_MOUNT_A, 46598, 1, 0);
- DELETE FROM `gossip_menu_option` WHERE `menu_id` in (10026,10025);
- INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`, `OptionBroadcastTextID`) VALUES
- (10026,1,0,'Take me to the ship.',1,1,0,0,0,0,'',31625),
- (10026,0,0,'Take me to the ship.',1,1,0,0,0,0,'',31625),
- (10025,1,0,'Take me to the ship.',1,1,0,0,0,0,'',31625),
- (10025,0,0,'Take me to the ship.',1,1,0,0,0,0,'',31625);
- DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (10026,10025);
- INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
- (15,10026,1,0,0,28,0,13419,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player has taken quest Preparations for War'), -- Horde
- (15,10025,1,0,0,28,0,13418,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player has taken quest Preparations for War'), -- Allianz
- (15,10026,0,0,0,8,0,13419,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player finish the quest Preparations for War'), -- Horde
- (15,10025,0,0,0,8,0,13418,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player finish the quest Preparations for War'); -- Allianz
- DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_H AND `source_type` = 0;
- DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_H*100 AND `source_type` = 9;
- DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_A AND `source_type` = 0;
- DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_A*100 AND `source_type` = 9;
- DELETE FROM `smart_scripts` WHERE `entryorguid` = @Klum AND `source_type` = 0;
- DELETE FROM `smart_scripts` WHERE `entryorguid` = @Klum*100 AND `source_type` = 9;
- DELETE FROM `smart_scripts` WHERE `entryorguid` = @Klum*100+1 AND `source_type` = 9;
- DELETE FROM `smart_scripts` WHERE `entryorguid` = @Rossem AND `source_type` = 0;
- DELETE FROM `smart_scripts` WHERE `entryorguid` = @Rossem*100 AND `source_type` = 9;
- DELETE FROM `smart_scripts` WHERE `entryorguid` = @Rossem*100+1 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
- (@Klum,0,0,0,62,0,100,0,10026,1,0,0,80,@Klum*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sky-Reaver Klum - On gossip select - Action list'),
- (@Klum*100,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action listt - Close Gossip'),
- (@Klum*100,9,1,0,0,0,100,0,0,0,0,0,11,58352,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action list - Cast 58352'),
- (@Klum,0,1,0,62,0,100,0,10026,0,0,0,80,@Klum*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sky-Reaver Klum - On gossip select - Action list'),
- (@Klum*100+1,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action listt - Close Gossip'),
- (@Klum*100+1,9,1,0,0,0,100,0,0,0,0,0,11,58352,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action list - Cast 58352'),
- (@Rossem,0,0,0,62,0,100,0,10025,1,0,0,80,@Rossem*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Officer Van Rossem - On gossip select - Action list'),
- (@Rossem*100,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action listt - Close Gossip'),
- (@Rossem*100,9,1,0,0,0,100,0,0,0,0,0,11,58349,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action list - Cast 58349'),
- (@Rossem,0,1,0,62,0,100,0,10025,0,0,0,80,@Rossem*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Officer Van Rossem - On gossip select - Action list'),
- (@Rossem*100+1,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action listt - Close Gossip'),
- (@Rossem*100+1,9,1,0,0,0,100,0,0,0,0,0,11,58349,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action list - Cast 58349'),
- (@ENTRY_MOUNT_H, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, @ENTRY_MOUNT_H*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - On summon - Action List'),
- (@ENTRY_MOUNT_H*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - Action List - Set Fly ON'),
- (@ENTRY_MOUNT_H*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 46598, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - Action List - InvokerCast'),
- (@ENTRY_MOUNT_H*100, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 53, 1, @ENTRY_MOUNT_H, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - Action List - Start wp'),
- (@ENTRY_MOUNT_H, 0, 1, 0, 40, 0, 100, 0, 23, 0, 0, 0, 62, 571, 0, 0, 0, 0, 0, 10, 9963, 32301, 0, 0, 0, 0, 0, 'HordeV - on wp end - Go To Pos'), -- non fonctionnel
- -- to be continued: despawn when position reached
- (@ENTRY_MOUNT_A, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, @ENTRY_MOUNT_A*100, 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'AllyV - On summon - Action List'),
- (@ENTRY_MOUNT_A*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'AllyV - Action List - Set Fly ON'),
- (@ENTRY_MOUNT_A*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 46598, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'AllyV - Action List - InvokerCast'),
- (@ENTRY_MOUNT_A*100, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 53, 1, @ENTRY_MOUNT_A, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'AllyV - Action List - Start wp'),
- (@ENTRY_MOUNT_A, 0, 1, 0, 40, 0, 100, 0, 23, 0, 0, 0, 62, 571, 0, 0, 0, 0, 0, 10, 9985, 30352, 0, 0, 0, 0, 0, 'AllyV - on wp end - Go To Pos'); -- non fonctionnel
- -- to be continued: despawn when position reached
- -- Waypoints
- DELETE FROM `waypoints` WHERE `entry` IN(@ENTRY_MOUNT_H,@ENTRY_MOUNT_A);
- INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
- (@ENTRY_MOUNT_H, 1, 5837.79, 477.5764, 658.5851, 'ship'),
- (@ENTRY_MOUNT_H, 2, 5837.367, 478.4823, 658.5851, 'ship'),
- (@ENTRY_MOUNT_H, 3, 5836.953, 475.4076, 660.1669, 'ship'),
- (@ENTRY_MOUNT_H, 4, 5835.361, 490.0929, 669.2502, 'ship'),
- (@ENTRY_MOUNT_H, 5, 5845.597, 505.7655, 677.8998, 'ship'),
- (@ENTRY_MOUNT_H, 6, 5865.832, 544.756, 689.6674, 'ship'),
- (@ENTRY_MOUNT_H, 7, 5897.429, 586.1177, 689.6674, 'ship'),
- (@ENTRY_MOUNT_H, 8, 5936.385, 642.625, 682.4179, 'ship'),
- (@ENTRY_MOUNT_H, 9, 5954.68, 688.5653, 678.1407, 'ship'),
- (@ENTRY_MOUNT_H, 10, 5987.017, 725.1281, 673.5298, 'ship'),
- (@ENTRY_MOUNT_H, 11, 6055.089, 766.5753, 663.0575, 'ship'),
- (@ENTRY_MOUNT_H, 12, 6077.21, 796.1387, 663.0575, 'ship'),
- (@ENTRY_MOUNT_H, 13, 6089.871, 824.1841, 663.0575, 'ship'),
- (@ENTRY_MOUNT_H, 14, 6133.36, 911.2333, 642.3085, 'ship'),
- (@ENTRY_MOUNT_H, 15, 6187.39, 959.5966, 625.03, 'ship'),
- (@ENTRY_MOUNT_H, 16, 6346.116, 1060.051, 631.3358, 'ship'),
- (@ENTRY_MOUNT_H, 17, 6466.611, 1107.176, 640.8912, 'ship'),
- (@ENTRY_MOUNT_H, 18, 6626.671, 1136.814, 639.6691, 'ship'),
- (@ENTRY_MOUNT_H, 19, 6733.844, 1153.338, 637.0303, 'ship'),
- (@ENTRY_MOUNT_H, 20, 6835.574, 1203.639, 642.9744, 'ship'),
- (@ENTRY_MOUNT_H, 21, 6981.921, 1218.922, 646.2798, 'ship'),
- (@ENTRY_MOUNT_H, 22, 7059.858, 1220.732, 663.0575, 'ship'),
- (@ENTRY_MOUNT_H, 23, 7204.823, 1261.922, 719.5843, 'ship'),
- (@ENTRY_MOUNT_A, 1, 5837.79, 477.5764, 658.5851, 'ship'),
- (@ENTRY_MOUNT_A, 2, 5837.367, 478.4823, 658.5851, 'ship'),
- (@ENTRY_MOUNT_A, 3, 5836.953, 475.4076, 660.1669, 'ship'),
- (@ENTRY_MOUNT_A, 4, 5835.361, 490.0929, 669.2502, 'ship'),
- (@ENTRY_MOUNT_A, 5, 5845.597, 505.7655, 677.8998, 'ship'),
- (@ENTRY_MOUNT_A, 6, 5865.832, 544.756, 689.6674, 'ship'),
- (@ENTRY_MOUNT_A, 7, 5897.429, 586.1177, 689.6674, 'ship'),
- (@ENTRY_MOUNT_A, 8, 5936.385, 642.625, 682.4179, 'ship'),
- (@ENTRY_MOUNT_A, 9, 5954.68, 688.5653, 678.1407, 'ship'),
- (@ENTRY_MOUNT_A, 10, 5987.017, 725.1281, 673.5298, 'ship'),
- (@ENTRY_MOUNT_A, 11, 6055.089, 766.5753, 663.0575, 'ship'),
- (@ENTRY_MOUNT_A, 12, 6077.21, 796.1387, 663.0575, 'ship'),
- (@ENTRY_MOUNT_A, 13, 6089.871, 824.1841, 663.0575, 'ship'),
- (@ENTRY_MOUNT_A, 14, 6133.36, 911.2333, 642.3085, 'ship'),
- (@ENTRY_MOUNT_A, 15, 6187.39, 959.5966, 625.03, 'ship'),
- (@ENTRY_MOUNT_A, 16, 6346.116, 1060.051, 631.3358, 'ship'),
- (@ENTRY_MOUNT_A, 17, 6466.611, 1107.176, 640.8912, 'ship'),
- (@ENTRY_MOUNT_A, 18, 6626.671, 1136.814, 639.6691, 'ship'),
- (@ENTRY_MOUNT_A, 19, 6733.844, 1153.338, 637.0303, 'ship'),
- (@ENTRY_MOUNT_A, 20, 6835.574, 1203.639, 642.9744, 'ship'),
- (@ENTRY_MOUNT_A, 21, 6981.921, 1218.922, 646.2798, 'ship'),
- (@ENTRY_MOUNT_A, 22, 7059.858, 1220.732, 663.0575, 'ship'),
- (@ENTRY_MOUNT_A, 23, 7204.823, 1261.922, 719.5843, 'ship');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement