Advertisement
bucur35

Untitled

Jan 5th, 2013
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.88 KB | None | 0 0
  1. --Traitors Among Us
  2.  
  3. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=23602;
  4. UPDATE `creature_template` SET `gossip_menu_id`=23602 WHERE  `entry`=23602;
  5. UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`=23602;
  6.          
  7. DELETE FROM `npc_text` WHERE `ID`=23602;
  8. 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`, `WDBVerified`) VALUES
  9. (23602, '', 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, 1);
  10.          
  11. DELETE FROM `gossip_menu_option` WHERE `menu_id`=4979;
  12. 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
  13. (23602, 0, 0, 'Challenge me!', 1, 1, 0, 0, 0, 0, NULL);
  14.          
  15.    
  16. DELETE FROM `gossip_menu` WHERE `entry`=23602 AND `text_id`=23602;
  17. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  18. (23602, 23602);
  19.          
  20. DELETE FROM `smart_scripts` WHERE  `entryorguid`=23602;
  21. 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
  22. (23602, 0, 0, 0, 62, 0, 100, 0, 23602, 0, 0, 0, 2, 16, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - Give credit');
  23.    
  24. DELETE FROM `conditions` WHERE `SourceGroup`=37174;
  25. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  26. (15, 23602, 0, 0, 0, 9, 0, 27210, 0, 0, 0, 0, '', 'show gossip if player has quest');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement