Advertisement
bucur35

Untitled

Nov 8th, 2012
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.88 KB | None | 0 0
  1. SET @ENTRY:= 27359;
  2.      
  3. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  4. UPDATE `creature_template` SET `gossip_menu_id`=@ENTRY WHERE  `entry`=@ENTRY LIMIT 1;
  5. UPDATE `creature_template` SET `npcflag`=1 WHERE  `entry`=@ENTRY LIMIT 1;
  6.      
  7. DELETE FROM `npc_text` WHERE `ID`=@ENTRY;
  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. (@ENTRY, 'Im am trapped here..Please help me', 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`=@ENTRY;
  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. (@ENTRY, 0, 0, 'Please help me to get out of here!', 1, 1, 0, 0, 0, 0, NULL);
  14.      
  15. DELETE FROM `gossip_menu` WHERE `entry`=@ENTRY;
  16. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  17. (@ENTRY, @ENTRY);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement