API tools faq
paste
image

Dalaran Indicators

image
Nov 4th, 2011
225
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 29.53 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. POINTS OF INTERESTS
  3. */
  4. DELETE FROM points_of_interest WHERE entry IN (1534, 1535, 1536, 1537, 1538, 1544, 1548, 1549, 1551, 1561, 1562, 1564, 1566, 1571, 1573, 1574, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1587, 1588, 1589, 1590, 1591, 1592, 1593, 1594, 1596, 1597, 1598, 1602, 1616, 1617, 1618, 1619, 1620, 1621, 1622, 1623, 1624, 1625, 1626, 1627, 1628, 1629, 1630, 1631, 1633, 1634, 1635, 1636, 1637, 1638, 1640, 1642, 1644, 1646, 1648, 1650, 1652, 1654, 1658, 1660, 1662, 1664, 1665, 1666, 1667, 1708, 1709, 1710, 1711, 1712);
  5. INSERT INTO points_of_interest (`entry`, `x`, `y`, `icon`, `flags`, `data`, `icon_name`)
  6. VALUES
  7. ('1534', '5802.76', '552.28', '7', '99', '0', 'Dalaran: Eastern Sewer Entrance'),
  8. ('1535', '5816.39', '760.085', '7', '99', '0', 'Dalaran: Western Sewer Entrance'),
  9. ('1536', '5879.9', '652.782', '7', '99', '0', 'Dalaran: Well'),
  10. ('1537', '5758.11', '715.641', '7', '99', '0', 'Dalaran: Silver Enclave'),
  11. ('1538', '5857.26', '595.421', '7', '99', '0', 'Dalaran: Sunreaver\'s Sanctuary'),
  12. ('1544', '5889.37', '622.227', '7', '99', '0', 'Dalaran: Barber'),
  13. ('1548', '5857.26', '595.421', '7', '99', '0', 'Dalaran: Sunreaver\'s Sanctuary'),
  14. ('1549', '5813.97', '449.107', '7', '99', '0', 'Dalaran: Flight Master'),
  15. ('1551', '5756.87', '620.785', '7', '99', '0', 'Dalaran: Visitor Center'),
  16. ('1561', '5731.46', '678.199', '7', '99', '0', 'Dalaran: Alliance Inn'),
  17. ('1562', '5848.26', '636.675', '7', '99', '0', 'Dalaran: Inn'),
  18. ('1564', '5934.05', '575.626', '7', '99', '0', 'Dalaran: Locksmith'),
  19. ('1566', '5885.62', '521.776', '7', '99', '0', 'Dalaran: Horde Inn'),
  20. ('1571', '5848.26', '636.675', '7', '99', '0', 'Dalaran: Inn'),
  21. ('1573', '5966.82', '613.917', '7', '99', '0', 'Dalaran: Northern Bank'),
  22. ('1574', '5640.99', '687.532', '7', '99', '0', 'Dalaran: Southern Bank'),
  23. ('1578', '5831.51', '508.617', '7', '99', '0', 'Dalaran: Krasus\' Landing'),
  24. ('1579', '5758.11', '715.641', '7', '99', '0', 'Dalaran: Silver Enclave'),
  25. ('1580', '5857.26', '595.421', '7', '99', '0', 'Dalaran: Sunreaver\'s Sanctuary'),
  26. ('1581', '5797.48', '794.906', '7', '99', '0', 'Dalaran: Violet Citadel'),
  27. ('1582', '5691.49', '500.56', '7', '99', '0', 'Dalaran: Violet Hold'),
  28. ('1583', '5802.76', '552.28', '7', '99', '0', 'Dalaran: Eastern Sewer Entrance'),
  29. ('1584', '5816.39', '760.085', '7', '99', '0', 'Dalaran: Western Sewer Entrance'),
  30. ('1585', '5879.9', '652.782', '7', '99', '0', 'Dalaran: Well'),
  31. ('1587', '5899.21', '728.851', '7', '99', '0', 'Dalaran: Trade District'),
  32. ('1588', '5831.51', '508.617', '7', '99', '0', 'Dalaran: Krasus\' Landing'),
  33. ('1589', '5952.15', '674.611', '7', '99', '0', 'Dalaran: Antonidas Memorial'),
  34. ('1590', '5804.6', '639.554', '7', '99', '0', 'Dalaran: Runeweaver Square'),
  35. ('1591', '5710.33', '645.397', '7', '99', '0', 'Dalaran: Eventide'),
  36. ('1592', '5851.66', '766.287', '7', '99', '0', 'Dalaran: Cemetary'),
  37. ('1593', '5859.73', '557.745', '7', '99', '0', 'Dalaran: Stable Master'),
  38. ('1594', '5860.68', '702.517', '7', '99', '0', 'Dalaran: Inscription Trainer'),
  39. ('1596', '5808.53', '581.308', '7', '99', '0', 'Dalaran: Mage Trainer'),
  40. ('1597', '5831.51', '508.617', '7', '99', '0', 'Dalaran: Krasus\' Landing'),
  41. ('1598', '5808.53', '581.308', '7', '99', '0', 'Dalaran: Mage Trainer'),
  42. ('1602', '5885.62', '521.776', '7', '99', '0', 'Dalaran: Horde Inn'),
  43. ('1616', '5790.16', '689.124', '7', '99', '0', 'Dalaran: Cloth Armor & Clothing'),
  44. ('1617', '5671.76', '629.458', '7', '99', '0', 'Dalaran: Mail & Leather Armor'),
  45. ('1618', '5671.76', '629.458', '7', '99', '0', 'Dalaran: Mail & Leather Armor'),
  46. ('1619', '5912.78', '665.419', '7', '99', '0', 'Dalaran: Plate & Shields'),
  47. ('1620', '5912.78', '665.419', '7', '99', '0', 'Dalaran: Plate & Shields'),
  48. ('1621', '5790.16', '689.124', '7', '99', '0', 'Dalaran: Cloth Armor & Clothing'),
  49. ('1622', '5758.11', '715.641', '7', '99', '0', 'Dalaran: Silver Enclave'),
  50. ('1623', '5857.26', '595.421', '7', '99', '0', 'Dalaran: Sunreaver\'s Sanctuary'),
  51. ('1624', '5773.1', '576.271', '7', '99', '0', 'Dalaran: Flowers'),
  52. ('1625', '5750.41', '695.409', '7', '99', '0', 'Dalaran: Fruit Vendor'),
  53. ('1626', '5684.03', '617.319', '7', '99', '0', 'Dalaran: General & Trade Store'),
  54. ('1627', '5873.86', '721.729', '7', '99', '0', 'Dalaran: Jewelcrafting Trainer'),
  55. ('1628', '5847.11', '567.15', '7', '99', '0', 'Dalaran: Pet Store'),
  56. ('1629', '5906.35', '628.194', '7', '99', '0', 'Dalaran: Pie, Pastry & Cake'),
  57. ('1630', '5765.6', '734.329', '7', '99', '0', 'Dalaran: Reagents'),
  58. ('1631', '5814.42', '690.78', '7', '99', '0', 'Dalaran: Toy Store'),
  59. ('1633', '5890.97', '704.071', '7', '99', '0', 'Dalaran: Alchemy Trainer'),
  60. ('1634', '5752.08', '645.427', '7', '99', '0', 'Dalaran: Trinkets'),
  61. ('1635', '5727.33', '603.694', '7', '99', '0', 'Dalaran: Melee Weapons'),
  62. ('1636', '5780.4', '558.349', '7', '99', '0', 'Dalaran: Ranged Weapons'),
  63. ('1637', '5667.76', '645.391', '7', '99', '0', 'Dalaran: Staves & Wands'),
  64. ('1638', '5884.7', '608.281', '7', '99', '0', 'Dalaran: Wine & Cheese'),
  65. ('1640', '5904.31', '680.889', '7', '99', '0', 'Dalaran: Blacksmithing Trainer'),
  66. ('1642', '5731.46', '678.199', '7', '99', '0', 'Dalaran: Alliance Inn'),
  67. ('1644', '5837.26', '722.8', '7', '99', '0', 'Dalaran: Enchanting Trainer'),
  68. ('1646', '5920.67', '728.168', '7', '99', '0', 'Dalaran: Engineering Trainer'),
  69. ('1648', '5862.84', '743.351', '7', '99', '0', 'Dalaran: First Aid Trainer'),
  70. ('1650', '5704.84', '613.969', '7', '99', '0', 'Dalaran: Fishing Fountain'),
  71. ('1652', '5875.57', '691.28', '7', '99', '0', 'Dalaran: Herbalism Trainer'),
  72. ('1654', '5860.68', '702.517', '7', '99', '0', 'Dalaran: Inscription Trainer'),
  73. ('1658', '5873.86', '721.729', '7', '99', '0', 'Dalaran: Jewelcrafting Trainer'),
  74. ('1660', '5903.03', '750.206', '7', '99', '0', 'Dalaran: Leatherworking Trainer'),
  75. ('1662', '5919.47', '709.664', '7', '99', '0', 'Dalaran: Mining Trainer'),
  76. ('1664', '5903.01', '750.314', '7', '99', '0', 'Dalaran: Skinning Trainer'),
  77. ('1665', '5684.03', '617.319', '7', '99', '0', 'Dalaran: General & Trade Store'),
  78. ('1666', '5882.51', '745.847', '7', '99', '0', 'Dalaran: Tailoring Trainer'),
  79. ('1667', '5758.11', '715.641', '7', '99', '0', 'Dalaran: Silver Enclave'),
  80. ('1708', '5777.99', '607.481', '7', '99', '0', 'Dalaran: Sewer Arena'),
  81. ('1709', '5765.75', '731.147', '7', '99', '0', 'Dalaran: Sewer Bank'),
  82. ('1710', '5761.09', '714.637', '7', '99', '0', 'Dalaran: Sewer Inn'),
  83. ('1711', '5777.54', '743.632', '7', '99', '0', 'Dalaran: Sewer Tunnel'),
  84. ('1712', '5924.84', '565.286', '7', '99', '0', 'Dalaran: Sewer Vendors');
  85.  
  86.  
  87. /*
  88. TEXTS
  89. */
  90. DELETE FROM `gossip_menu` WHERE `entry` IN (10100, 10101, 10102, 10103, 10104, 10105, 10098, 10099);
  91. INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
  92. VALUES
  93. ('10098', '14019', '0', '0', '0', '0', '0', '0'),
  94. ('10099', '14020', '0', '0', '0', '0', '0', '0'),
  95. ('10100', '14021', '0', '0', '0', '0', '0', '0'),
  96. ('10101', '14022', '0', '0', '0', '0', '0', '0'),
  97. ('10102', '14023', '0', '0', '0', '0', '0', '0'),
  98. ('10103', '14024', '0', '0', '0', '0', '0', '0'),
  99. ('10104', '14025', '0', '0', '0', '0', '0', '0'),
  100. ('10105', '14026', '0', '0', '0', '0', '0', '0');
  101.  
  102. DELETE FROM `npc_text` WHERE `id` IN (14019, 14020, 14021, 14022, 14023, 14024, 14025, 14026);
  103. 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`)
  104. VALUES
  105. ('14019', 'There is a black market of sorts in the northeastern portion of the sewers.', 'There is a black market of sorts in the northeastern portion of the sewers.', '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'),
  106. ('14020', 'A tunnel leads out to the bottom of the city in the western sewers, just north of the Cantrips and Crows Tavern.$B$BSome of the more adventurous sorts use it to fly in and out of Dalaran.', 'A tunnel leads out to the bottom of the city in the western sewers, just north of the Cantrips and Crows Tavern.$B$BSome of the more adventurous sorts use it to fly in and out of Dalaran.', '0', '1', '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', '0'),
  107. ('14021', 'You\'re looking for the Cantrips and Crows Tavern in the western sewers.', 'You\'re looking for the Cantrips and Crows Tavern in the western sewers.', '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'),
  108. ('14022', 'There is a goblin-run bank down here, just north of the Cantrips and Crows Tavern in the western sewers.', 'There is a goblin-run bank down here, just north of the Cantrips and Crows Tavern in the western sewers.', '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'),
  109. ('14023', 'The Steamwheedle Cartel hosts an entire arena circuit in the central sewers of Dalaran.$B$BYou\'ll find dueling rings there, too, at the Circle of Wills.', 'The Steamwheedle Cartel hosts an entire arena circuit in the central sewers of Dalaran.$B$BYou\'ll find dueling rings there, too, at the Circle of Wills.', '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'),
  110. ('14024', 'A ramp leads up to just outside Krasus\' Landing in the eastern sewers.', 'A ramp leads up to just outside Krasus\' Landing in the eastern sewers.', '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'),
  111. ('14025', 'A ramp leads up to near the Violet Citadel in the western sewers.', 'A ramp leads up to near the Violet Citadel in the western sewers.', '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'),
  112. ('14026', 'There are three ways out of the Underbelly: Ramps leading up to the east and west, and the tunnel that drops out of the bottom of Dalaran.$B$BBe certain you can fly before you take that tunnel, of course.', 'There are three ways out of the Underbelly: Ramps leading up to the east and west, and the tunnel that drops out of the bottom of Dalaran.$B$BBe certain you can fly before you take that tunnel, of course.', '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');
  113.  
  114.  
  115. /*
  116. Dalaran
  117. */
  118. DELETE FROM `gossip_menu` WHERE `entry`='10043';
  119. INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
  120. VALUES
  121. ('10043', '14013', '0', '0', '0', '0', '0', '0'),
  122. ('10043', '14014', '0', '0', '0', '0', '0', '0');
  123.  
  124. DELETE FROM `gossip_menu_option` WHERE `menu_id`='10043';
  125. 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`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  126. VALUES
  127. ('10043', '0', '0', 'Arena', '1', '1', '10057', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  128. ('10043', '1', '0', 'The auction house', '1', '1', '10092', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  129. ('10043', '2', '0', 'The bank', '1', '1', '10089', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  130. ('10043', '3', '0', 'Barber', '1', '1', '10085', '1544', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  131. ('10043', '4', '0', 'Battlemasters', '1', '1', '10058', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  132. ('10043', '5', '0', 'Portals to capital cities', '1', '1', '10058', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  133. ('10043', '6', '0', 'The flight master', '1', '1', '10086', '1549', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  134. ('10043', '7', '0', 'The guild master', '1', '1', '10095', '1551', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  135. ('10043', '8', '0', 'The inn', '1', '1', '10084', '1562', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  136. ('10043', '9', '0', 'Locksmith', '1', '1', '10262', '1564', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  137. ('10043', '10', '0', 'The mailbox', '1', '1', '10090', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  138. ('10043', '11', '0', 'Important places', '1', '1', '10056', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  139. ('10043', '12', '0', 'The stable master', '1', '1', '10083', '1593', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  140. ('10043', '13', '0', 'Trainers', '1', '1', '10082', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  141. ('10043', '14', '0', 'Merchants', '1', '1', '10173', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  142.  
  143. DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (10057,10092,10089,10085,10058,10058,10086,10095,10084,10262,10090,10056,10083,10082,10173);
  144. 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`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  145. VALUES
  146. ('10056', '0', '0', 'Silver Enclave', '1', '1', '10054', '1579', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  147. ('10056', '1', '0', 'Sunreaver\'s Sanctuary', '1', '1', '10053', '1580', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  148. ('10056', '2', '0', 'Violet Hold', '1', '1', '10052', '1581', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  149. ('10056', '3', '0', 'Violet Citadel', '1', '1', '10051', '1582', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  150. ('10056', '4', '0', 'Drains', '1', '1', '10055', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  151. ('10056', '5', '0', 'Trade District', '1', '1', '10062', '1587', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  152. ('10056', '6', '0', 'Krasus\' Landing', '1', '1', '10091', '1588', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  153. ('10056', '7', '0', 'Antonidas Memorial', '1', '1', '10049', '1589', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  154. ('10056', '8', '0', 'Runeweaver Square', '1', '1', '10048', '1590', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  155. ('10056', '9', '0', 'Eventide', '1', '1', '10047', '1591', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  156. ('10056', '10', '0', 'Cemetary', '1', '1', '10046', '1592', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  157. ('10056', '11', '0', 'Lexicon of Power', '1', '1', '10205', '1594', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  158. ('10057', '0', '0', 'Dalaran Eastern Sewer Entrance', '1', '1', '10045', '1534', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  159. ('10057', '1', '0', 'Dalaran Western Sewer Entrance', '1', '1', '10044', '1535', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  160. ('10057', '2', '0', 'Well', '1', '1', '10050', '1536', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  161. ('10058', '0', '0', 'Silver Enclave', '1', '1', '10054', '1667', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  162. ('10058', '1', '0', 'Sunreaver\'s Sanctuary', '1', '1', '10053', '1548', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  163. ('10082', '0', '0', 'Class Trainer', '1', '1', '10081', '1596', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  164. ('10082', '1', '0', 'Class Trainer', '1', '1', '10097', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  165. ('10082', '2', '0', 'Krasus\' Landing', '1', '1', '10080', '1597', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  166. ('10082', '3', '0', 'Mage Trainer', '1', '1', '10081', '1598', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  167. ('10082', '4', '0', 'Profession Trainer', '1', '1', '10078', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  168. ('10084', '0', '0', 'Alliance Inn', '1', '1', '10074', '1561', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  169. ('10084', '1', '0', 'Horde Inn', '1', '1', '10075', '1566', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  170. ('10084', '2', '0', 'Drains', '1', '1', '10055', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  171. ('10089', '0', '0', 'Northern Bank', '1', '1', '10087', '1573', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  172. ('10089', '1', '0', 'Southern Bank', '1', '1', '10088', '1574', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  173. ('10089', '2', '0', 'Drains', '1', '1', '10055', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  174. ('10090', '0', '0', 'The inn', '1', '1', '10084', '1571', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  175. ('10090', '1', '0', 'The bank', '1', '1', '10089', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  176. ('10090', '2', '0', 'Krasus\' Landing', '1', '1', '10091', '1578', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  177. ('10092', '0', '0', 'Silver Enclave', '1', '1', '10054', '1537', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  178. ('10092', '1', '0', 'Sunreaver\'s Sanctuary', '1', '1', '10053', '1538', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  179. ('10173', '0', '0', 'Armour', '1', '1', '10170', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  180. ('10173', '1', '0', 'Cloth Armor & Clothing', '1', '1', '10167', '1621', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  181. ('10173', '2', '0', 'Important places', '1', '1', '10160', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  182. ('10173', '3', '0', 'Flowers', '1', '1', '10159', '1624', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  183. ('10173', '4', '0', 'Fruit', '1', '1', '10158', '1625', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  184. ('10173', '5', '0', 'General & Trade Store', '1', '1', '10157', '1626', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  185. ('10173', '6', '0', 'Jewelcrafting Trainer', '1', '1', '10169', '1627', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  186. ('10173', '7', '0', 'Pet Store', '1', '1', '10155', '1628', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  187. ('10173', '8', '0', 'Pie, Pastry & Cake', '1', '1', '10154', '1629', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  188. ('10173', '9', '0', 'Reagents', '1', '1', '10156', '1630', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  189. ('10173', '10', '0', 'Toy Store', '1', '1', '10152', '1631', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  190. ('10173', '11', '0', 'General & Trade Store', '1', '1', '10153', '1665', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  191. ('10173', '12', '0', 'Trinkets', '1', '1', '10162', '1634', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  192. ('10173', '13', '0', 'Weapons', '1', '1', '10168', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  193. ('10173', '14', '0', 'Wine & Cheese', '1', '1', '10148', '1638', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  194.  
  195. DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (10054, 10053, 10052, 10051, 10055, 10062, 10091, 10049, 10048, 10047, 10046, 10205, 10045, 10044, 10050, 10054, 10053, 10081, 10097, 10080, 10081, 10078, 10074, 10075, 10055, 10087, 10088, 10055, 10084, 10089, 10091, 10054, 10053, 10170, 10167, 10160, 10159, 10158, 10157, 10169, 10155, 10154, 10156, 10152, 10153, 10162, 10168, 10148);
  196. 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`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  197. VALUES
  198. ('10055', '0', '0', 'Dalaran Eastern Sewer Entrance', '1', '1', '10045', '1583', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  199. ('10055', '1', '0', 'Dalaran Western Sewer Entrance', '1', '1', '10044', '1584', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  200. ('10055', '2', '0', 'Well', '1', '1', '10050', '1585', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  201. ('10078', '0', '0', 'Alchemy', '1', '1', '10077', '1633', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  202. ('10078', '1', '0', 'Blacksmithing', '1', '1', '10076', '1640', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  203. ('10078', '2', '0', 'Cooking', '1', '1', '10073', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  204. ('10078', '3', '0', 'Enchanting', '1', '1', '10072', '1644', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  205. ('10078', '4', '0', 'Engineering', '1', '1', '10071', '1646', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  206. ('10078', '5', '0', 'First Aid', '1', '1', '10070', '1648', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  207. ('10078', '6', '0', 'Fishing', '1', '1', '10069', '1650', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  208. ('10078', '7', '0', 'Herbalism', '1', '1', '10068', '1652', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  209. ('10078', '8', '0', 'Inscription', '1', '1', '10067', '1654', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  210. ('10078', '9', '0', 'Jewelcrafting', '1', '1', '10066', '1658', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  211. ('10078', '10', '0', 'Leatherworking', '1', '1', '10064', '1660', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  212. ('10078', '11', '0', 'Mining', '1', '1', '10065', '1662', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  213. ('10078', '12', '0', 'Skinning', '1', '1', '10064', '1664', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  214. ('10078', '13', '0', 'Tailoring', '1', '1', '10063', '1666', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  215. ('10084', '0', '0', 'Alliance Inn', '1', '1', '10074', '1561', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  216. ('10084', '1', '0', 'Horde Inn', '1', '1', '10075', '1566', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  217. ('10084', '2', '0', 'Drains', '1', '1', '10055', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  218. ('10089', '0', '0', 'Northern Bank', '1', '1', '10087', '1573', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  219. ('10089', '1', '0', 'Southern Bank', '1', '1', '10088', '1574', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  220. ('10089', '2', '0', 'Drains', '1', '1', '10055', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  221. ('10097', '0', '0', 'The Alliance Quarter', '1', '1', '10054', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  222. ('10097', '1', '0', 'The Horde Quarter', '1', '1', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  223. ('10153', '0', '0', 'Profession Trainer', '1', '1', '10078', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  224. ('10160', '0', '0', 'Silver Enclave', '1', '1', '10054', '1622', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  225. ('10160', '1', '0', 'Sunreaver\'s Sanctuary', '1', '1', '10053', '1623', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  226. ('10168', '0', '0', 'Melee Weapons', '1', '1', '10151', '1635', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  227. ('10168', '1', '0', 'Ranged Weapons', '1', '1', '10150', '1636', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  228. ('10168', '2', '0', 'Staves & Wands', '1', '1', '10149', '1637', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  229. ('10170', '0', '0', 'Cloth Armor & Clothing', '1', '1', '10166', '1616', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  230. ('10170', '1', '0', 'Leather Armor', '1', '1', '10165', '1617', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  231. ('10170', '2', '0', 'Mail Armor', '1', '1', '10164', '1618', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  232. ('10170', '3', '0', 'Plate Armor', '1', '1', '10163', '1619', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  233. ('10170', '4', '0', 'Shields', '1', '1', '10161', '1620', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  234.  
  235.  
  236.  
  237. /*
  238. Dalaran Sewers
  239. */
  240. UPDATE creature_template SET `modelid3` = "0", `IconName` = "Directions", `gossip_menu_id` = "10106", `npcflag` = "1" WHERE entry IN (32728, 32733, 32729, 32731, 32727, 32726, 32732, 32730);
  241. DELETE FROM `gossip_menu` WHERE `entry`='10106';
  242. INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
  243. VALUES
  244. ('10106', '14027', '0', '0', '0', '0', '0', '0');
  245.  
  246. DELETE FROM `gossip_menu_option` WHERE `menu_id`='10106';
  247. 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`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  248. VALUES
  249. ('10106', '0', '0', 'Arena', '1', '1', '10102', '1708', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  250. ('10106', '1', '0', 'Bank', '1', '1', '10101', '1709', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  251. ('10106', '2', '0', 'Inn', '1', '1', '10100', '1710', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  252. ('10106', '3', '0', 'Sewer Exits', '1', '1', '10105', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  253. ('10106', '4', '0', 'Vendors', '1', '1', '10098', '1712', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  254.  
  255.  
  256. DELETE FROM `gossip_menu_option` WHERE `menu_id`='10105';
  257. 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`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  258. VALUES
  259. ('10105', '0', '0', 'Eastern Sewer Entrance', '1', '1', '10103', '1583', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  260. ('10105', '1', '0', 'Western Sewer Entrance', '1', '1', '10104', '1584', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  261. ('10105', '2', '0', 'Sewer Tunnel', '1', '1', '10099', '1711', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!