Advertisement
bucur35

Untitled

Oct 8th, 2014
252
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.99 KB | None | 0 0
  1. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=48159;
  2. UPDATE `creature_template` SET `gossip_menu_id`=48159 WHERE  `entry`=48159;
  3. UPDATE `creature_template` SET `npcflag`=1 WHERE  `entry`=48159;
  4.    
  5. DELETE FROM `npc_text` WHERE `ID`=48159;
  6. INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) VALUES
  7. (48159, 'Are you ready to challenge the elemental, hero?', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0);
  8.    
  9. DELETE FROM `gossip_menu_option` WHERE `menu_id`=48159;
  10. 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`) VALUES
  11. (48159, 0, 0, 'I\'m ready !Unleash Him', 1, 1, 0, 0, 0, 0, NULL);
  12.          
  13. DELETE FROM `gossip_menu` WHERE `entry`=48159;
  14. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  15. (48159, 48159);
  16.    
  17. -- Wyrtle Spreelthonket SAI
  18. SET @ENTRY := 48159;
  19. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  20. 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
  21. (@ENTRY,0,0,0,62,0,100,0,48159,0,0,0,12,48156,1,60000000,0,0,0,8,0,0,0,-7699.730957,-1444.298462,13978801,1.095048,'Wyrtle Spreelthonket - On Gossip Option 48159 Selected - Summon Creature Magma Lord Kolob');
  22.          
  23. DELETE FROM `conditions` WHERE `SourceGroup`=48159;
  24. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  25. (15, 48159, 0, 0, 0, 9, 0, 28438, 0, 0, 0, 0, '', 'show gossip if player has quest');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement