Advertisement
Rushor

Untitled

Aug 17th, 2014
333
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.34 KB | None | 0 0
  1. DELETE FROM `npc_text` WHERE `ID`=1999;
  2. 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
  3. (1999, 'You would like to learn some of my recipes?', '', 0, 1, 0, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0);
  4.  
  5. DELETE FROM `gossip_menu` WHERE `entry`=1999;
  6. INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES
  7. (1999, 1999, 0, 0);
  8.  
  9. UPDATE `creature_template` SET `NpcFlags`=1, `GossipMenuId`=1999 WHERE `Entry`=16365;
  10.  
  11. DELETE FROM `gossip_menu_option` WHERE `menu_id`=1999;
  12. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `condition_id`) VALUES
  13. (1999, 0, 0, 'I would like to learn \'Glacial Wrists\'.', 1, 1, 1501, 0, 199900, 0, 0, '', 0),
  14. (1999, 1, 0, 'I would like to learn \'Glacial Cloak\'.', 1, 1, 1501, 0, 199901, 0, 0, '', 0),
  15. (1999, 2, 0, 'I would like to learn \'Glacial Vest\'.', 1, 1, 1501, 0, 199902, 0, 0, '', 0),
  16. (1999, 3, 0, 'I would like to learn \'Glacial Gloves\'.', 1, 1, 1501, 0, 199903, 0, 0, '', 0),
  17. --
  18. (1999, 4, 0, 'I would like to learn \'Polar Tunic\'.', 1, 1, 1501, 0, 199904, 0, 0, '', 0),
  19. (1999, 5, 0, 'I would like to learn \'Icy Scale Bracers\'.', 1, 1, 1501, 0, 199905, 0, 0, '', 0),
  20. (1999, 6, 0, 'I would like to learn \'Icy Scale Breastplate\'.', 1, 1, 1501, 0, 199906, 0, 0, '', 0),
  21. (1999, 7, 0, 'I would like to learn \'Icy Scale Gauntlets\'.', 1, 1, 1501, 0, 199907, 0, 0, '', 0),
  22. (1999, 8, 0, 'I would like to learn \'Polar Bracers\'.', 1, 1, 1501, 0, 199908, 0, 0, '', 0),
  23. (1999, 9, 0, 'I would like to learn \'Polar Gloves\'.', 1, 1, 1501, 0, 199909, 0, 0, '', 0),
  24. --
  25. (1999, 10, 0, 'I would like to learn \'Icebane Bracers\'.', 1, 1, 1501, 0, 199910, 0, 0, '', 0),
  26. (1999, 11, 0, 'I would like to learn \'Icebane Gauntlets\'.', 1, 1, 1501, 0, 199911, 0, 0, '', 0),
  27. (1999, 12, 0, 'I would like to learn \'Icebane Breastplate\'.', 1, 1, 1501, 0, 199912, 0, 0, '', 0);
  28.  
  29. DELETE FROM `dbscripts_on_gossip` WHERE `id` IN (199900,199901,199902,199903,199904,199905,199906,199907,199908,199909,199910,199911,199912);
  30. INSERT INTO `dbscripts_on_gossip` (`id`, `delay`, `command`, `datalong`, `datalong2`, `buddy_entry`, `search_radius`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES
  31. (199900, 1, 15, 28262, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Glacial Wrists'),
  32. (199901, 1, 15, 28263, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Glacial Cloak'),
  33. (199902, 1, 15, 28260, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Glacial Vest'),
  34. (199903, 1, 15, 28260, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Glacial Gloves'),
  35. --
  36. (199904, 1, 15, 28254, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Polar Tunic'),
  37. (199905, 1, 15, 28259, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Icy Scale Bracers'),
  38. (199906, 1, 15, 28257, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Icy Scale Breastplate'),
  39. (199907, 1, 15, 28258, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Icy Scale Gauntlets'),
  40. (199908, 1, 15, 28256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Polar Bracers'),
  41. (199909, 1, 15, 28255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Polar Gloves'),
  42. --
  43. (199910, 1, 15, 28252, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Icebane Bracers'),
  44. (199911, 1, 15, 28253, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Icebane Gauntlets'),
  45. (199912, 1, 15, 28251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'learn Icebane Breastplate');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement