API tools faq
paste
Advertisement
julienanid

[Remove all Location from the Teleports]

julienanid
Aug 25th, 2012
350
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 74.88 KB | None | 0 0
raw download clone embed print report
  1. SET
  2. @Entry = 190000, -- NPC entry of the teleporter
  3. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  4. @id = 0; -- ID of the option from gossip_menu_option
  5.  
  6. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  7. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  8. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  9.  
  10. SET
  11. @Entry = 190000, -- NPC entry of the teleporter
  12. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  13. @id = 1; -- ID of the option from gossip_menu_option
  14.  
  15. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  16. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  17. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  18.  
  19. SET
  20. @Entry = 190000, -- NPC entry of the teleporter
  21. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  22. @id = 2; -- ID of the option from gossip_menu_option
  23.  
  24. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  25. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  26. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  27.  
  28. SET
  29. @Entry = 190000, -- NPC entry of the teleporter
  30. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  31. @id = 3; -- ID of the option from gossip_menu_option
  32.  
  33. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  34. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  35. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  36.  
  37. SET
  38. @Entry = 190000, -- NPC entry of the teleporter
  39. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  40. @id = 4; -- ID of the option from gossip_menu_option
  41.  
  42. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  43. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  44. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  45.  
  46. SET
  47. @Entry = 190000, -- NPC entry of the teleporter
  48. @menu_id = 50002, -- menu_id of the menu from gossip_menu_option
  49. @id = 5; -- ID of the option from gossip_menu_option
  50.  
  51. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  52. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  53. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  54.  
  55. SET
  56. @Entry = 190000, -- NPC entry of the teleporter
  57. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  58. @id = 6; -- ID of the option from gossip_menu_option
  59.  
  60. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  61. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  62. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  63.  
  64. SET
  65. @Entry = 190000, -- NPC entry of the teleporter
  66. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  67. @id = 7; -- ID of the option from gossip_menu_option
  68.  
  69. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  70. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  71. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  72.  
  73. SET
  74. @Entry = 190000, -- NPC entry of the teleporter
  75. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  76. @id = 8; -- ID of the option from gossip_menu_option
  77.  
  78. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  79. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  80. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  81.  
  82. SET
  83. @Entry = 190000, -- NPC entry of the teleporter
  84. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  85. @id = 9; -- ID of the option from gossip_menu_option
  86.  
  87. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  88. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  89. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  90.  
  91. SET
  92. @Entry = 190000, -- NPC entry of the teleporter
  93. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  94. @id = 10; -- ID of the option from gossip_menu_option
  95.  
  96. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  97. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  98. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  99.  
  100. SET
  101. @Entry = 190000, -- NPC entry of the teleporter
  102. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  103. @id = 11; -- ID of the option from gossip_menu_option
  104.  
  105. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  106. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  107. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  108.  
  109. SET
  110. @Entry = 190000, -- NPC entry of the teleporter
  111. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  112. @id = 12; -- ID of the option from gossip_menu_option
  113.  
  114. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  115. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  116. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  117.  
  118.  
  119. SET
  120. @Entry = 190000, -- NPC entry of the teleporter
  121. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  122. @id = 0; -- ID of the option from gossip_menu_option
  123.  
  124. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  125. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  126. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  127.  
  128. SET
  129. @Entry = 190000, -- NPC entry of the teleporter
  130. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  131. @id = 1; -- ID of the option from gossip_menu_option
  132.  
  133. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  134. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  135. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  136.  
  137. SET
  138. @Entry = 190000, -- NPC entry of the teleporter
  139. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  140. @id = 2; -- ID of the option from gossip_menu_option
  141.  
  142. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  143. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  144. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  145.  
  146. SET
  147. @Entry = 190000, -- NPC entry of the teleporter
  148. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  149. @id = 3; -- ID of the option from gossip_menu_option
  150.  
  151. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  152. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  153. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  154.  
  155. SET
  156. @Entry = 190000, -- NPC entry of the teleporter
  157. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  158. @id = 4; -- ID of the option from gossip_menu_option
  159.  
  160. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  161. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  162. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  163.  
  164. SET
  165. @Entry = 190000, -- NPC entry of the teleporter
  166. @menu_id = 50002, -- menu_id of the menu from gossip_menu_option
  167. @id = 5; -- ID of the option from gossip_menu_option
  168.  
  169. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  170. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  171. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  172.  
  173. SET
  174. @Entry = 190000, -- NPC entry of the teleporter
  175. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  176. @id = 6; -- ID of the option from gossip_menu_option
  177.  
  178. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  179. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  180. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  181.  
  182. SET
  183. @Entry = 190000, -- NPC entry of the teleporter
  184. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  185. @id = 7; -- ID of the option from gossip_menu_option
  186.  
  187. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  188. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  189. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  190.  
  191. SET
  192. @Entry = 190000, -- NPC entry of the teleporter
  193. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  194. @id = 8; -- ID of the option from gossip_menu_option
  195.  
  196. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  197. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  198. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  199.  
  200. SET
  201. @Entry = 190000, -- NPC entry of the teleporter
  202. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  203. @id = 9; -- ID of the option from gossip_menu_option
  204.  
  205. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  206. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  207. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  208.  
  209. SET
  210. @Entry = 190000, -- NPC entry of the teleporter
  211. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  212. @id = 10; -- ID of the option from gossip_menu_option
  213.  
  214. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  215. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  216. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  217.  
  218. SET
  219. @Entry = 190000, -- NPC entry of the teleporter
  220. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  221. @id = 11; -- ID of the option from gossip_menu_option
  222.  
  223. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  224. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  225. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  226.  
  227. SET
  228. @Entry = 190000, -- NPC entry of the teleporter
  229. @menu_id = 500034, -- menu_id of the menu from gossip_menu_option
  230. @id = 12; -- ID of the option from gossip_menu_option
  231.  
  232. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  233. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  234. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  235.  
  236. SET
  237. @Entry = 190000, -- NPC entry of the teleporter
  238. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  239. @id = 13; -- ID of the option from gossip_menu_option
  240.  
  241. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  242. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  243. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  244.  
  245. SET
  246. @Entry = 190000, -- NPC entry of the teleporter
  247. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  248. @id = 14; -- ID of the option from gossip_menu_option
  249.  
  250. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  251. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  252. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  253.  
  254. SET
  255. @Entry = 190000, -- NPC entry of the teleporter
  256. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  257. @id = 15; -- ID of the option from gossip_menu_option
  258.  
  259. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  260. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  261. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  262.  
  263. SET
  264. @Entry = 190000, -- NPC entry of the teleporter
  265. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  266. @id = 16; -- ID of the option from gossip_menu_option
  267.  
  268. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  269. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  270. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  271.  
  272. SET
  273. @Entry = 190000, -- NPC entry of the teleporter
  274. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  275. @id = 17; -- ID of the option from gossip_menu_option
  276.  
  277. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  278. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  279. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  280.  
  281. SET
  282. @Entry = 190000, -- NPC entry of the teleporter
  283. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  284. @id = 18; -- ID of the option from gossip_menu_option
  285.  
  286. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  287. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  288. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  289.  
  290. SET
  291. @Entry = 190000, -- NPC entry of the teleporter
  292. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  293. @id = 19; -- ID of the option from gossip_menu_option
  294.  
  295. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  296. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  297. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  298.  
  299. SET
  300. @Entry = 190000, -- NPC entry of the teleporter
  301. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  302. @id = 20; -- ID of the option from gossip_menu_option
  303.  
  304. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  305. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  306. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  307.  
  308. SET
  309. @Entry = 190000, -- NPC entry of the teleporter
  310. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  311. @id = 21; -- ID of the option from gossip_menu_option
  312.  
  313. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  314. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  315. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  316.  
  317.  
  318. SET
  319. @Entry = 190000, -- NPC entry of the teleporter
  320. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  321. @id = 22; -- ID of the option from gossip_menu_option
  322.  
  323. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  324. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  325. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  326.  
  327. SET
  328. @Entry = 190000, -- NPC entry of the teleporter
  329. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  330. @id = 23; -- ID of the option from gossip_menu_option
  331.  
  332. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  333. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  334. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  335.  
  336. SET
  337. @Entry = 190000, -- NPC entry of the teleporter
  338. @menu_id = 50007, -- menu_id of the menu from gossip_menu_option
  339. @id = 0; -- ID of the option from gossip_menu_option
  340.  
  341. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  342. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  343. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  344.  
  345. SET
  346. @Entry = 190000, -- NPC entry of the teleporter
  347. @menu_id = 50007, -- menu_id of the menu from gossip_menu_option
  348. @id = 1; -- ID of the option from gossip_menu_option
  349.  
  350. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  351. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  352. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  353.  
  354. SET
  355. @Entry = 190000, -- NPC entry of the teleporter
  356. @menu_id = 50007, -- menu_id of the menu from gossip_menu_option
  357. @id = 2; -- ID of the option from gossip_menu_option
  358.  
  359. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  360. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  361. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  362.  
  363. SET
  364. @Entry = 190000, -- NPC entry of the teleporter
  365. @menu_id = 50007, -- menu_id of the menu from gossip_menu_option
  366. @id = 3; -- ID of the option from gossip_menu_option
  367.  
  368. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  369. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  370. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  371.  
  372. SET
  373. @Entry = 190000, -- NPC entry of the teleporter
  374. @menu_id = 50007, -- menu_id of the menu from gossip_menu_option
  375. @id = 4; -- ID of the option from gossip_menu_option
  376.  
  377. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  378. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  379. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  380.  
  381. SET
  382. @Entry = 190000, -- NPC entry of the teleporter
  383. @menu_id = 50007, -- menu_id of the menu from gossip_menu_option
  384. @id = 5; -- ID of the option from gossip_menu_option
  385.  
  386. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  387. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  388. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  389.  
  390. SET
  391. @Entry = 190000, -- NPC entry of the teleporter
  392. @menu_id = 50007, -- menu_id of the menu from gossip_menu_option
  393. @id = 6; -- ID of the option from gossip_menu_option
  394.  
  395. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  396. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  397. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  398.  
  399. SET
  400. @Entry = 190000, -- NPC entry of the teleporter
  401. @menu_id = 50007, -- menu_id of the menu from gossip_menu_option
  402. @id = 7; -- ID of the option from gossip_menu_option
  403.  
  404. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  405. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  406. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  407.  
  408. SET
  409. @Entry = 190000, -- NPC entry of the teleporter
  410. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  411. @id = 0; -- ID of the option from gossip_menu_option
  412.  
  413. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  414. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  415. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  416.  
  417. SET
  418. @Entry = 190000, -- NPC entry of the teleporter
  419. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  420. @id = 1; -- ID of the option from gossip_menu_option
  421.  
  422. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  423. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  424. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  425.  
  426. SET
  427. @Entry = 190000, -- NPC entry of the teleporter
  428. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  429. @id = 2; -- ID of the option from gossip_menu_option
  430.  
  431. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  432. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  433. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  434.  
  435. SET
  436. @Entry = 190000, -- NPC entry of the teleporter
  437. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  438. @id = 3; -- ID of the option from gossip_menu_option
  439.  
  440. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  441. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  442. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  443.  
  444. SET
  445. @Entry = 190000, -- NPC entry of the teleporter
  446. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  447. @id = 4; -- ID of the option from gossip_menu_option
  448.  
  449. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  450. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  451. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  452.  
  453. SET
  454. @Entry = 190000, -- NPC entry of the teleporter
  455. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  456. @id = 5; -- ID of the option from gossip_menu_option
  457.  
  458. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  459. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  460. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  461.  
  462. SET
  463. @Entry = 190000, -- NPC entry of the teleporter
  464. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  465. @id = 6; -- ID of the option from gossip_menu_option
  466.  
  467. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  468. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  469. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  470.  
  471. SET
  472. @Entry = 190000, -- NPC entry of the teleporter
  473. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  474. @id = 7; -- ID of the option from gossip_menu_option
  475.  
  476. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  477. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  478. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  479.  
  480. SET
  481. @Entry = 190000, -- NPC entry of the teleporter
  482. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  483. @id = 8; -- ID of the option from gossip_menu_option
  484.  
  485. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  486. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  487. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  488.  
  489. SET
  490. @Entry = 190000, -- NPC entry of the teleporter
  491. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  492. @id = 9; -- ID of the option from gossip_menu_option
  493.  
  494. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  495. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  496. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  497.  
  498. SET
  499. @Entry = 190000, -- NPC entry of the teleporter
  500. @menu_id = 50008, -- menu_id of the menu from gossip_menu_option
  501. @id = 10; -- ID of the option from gossip_menu_option
  502.  
  503. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  504. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  505. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  506.  
  507. SET
  508. @Entry = 190000, -- NPC entry of the teleporter
  509. @menu_id = 50003, -- menu_id of the menu from gossip_menu_option
  510. @id = 5; -- ID of the option from gossip_menu_option
  511.  
  512. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  513. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  514. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  515.  
  516. SET
  517. @Entry = 190000, -- NPC entry of the teleporter
  518. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  519. @id = 5; -- ID of the option from gossip_menu_option
  520.  
  521. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  522. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  523. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  524.  
  525. SET
  526. @Entry = 190000, -- NPC entry of the teleporter
  527. @menu_id = 50004, -- menu_id of the menu from gossip_menu_option
  528. @id = 12; -- ID of the option from gossip_menu_option
  529.  
  530. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  531. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  532. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  533.  
  534. SET
  535. @Entry = 190000, -- NPC entry of the teleporter
  536. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  537. @id = 0; -- ID of the option from gossip_menu_option
  538.  
  539. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  540. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  541. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  542.  
  543. SET
  544. @Entry = 190000, -- NPC entry of the teleporter
  545. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  546. @id = 1; -- ID of the option from gossip_menu_option
  547.  
  548. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  549. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  550. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  551.  
  552. SET
  553. @Entry = 190000, -- NPC entry of the teleporter
  554. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  555. @id = 2; -- ID of the option from gossip_menu_option
  556.  
  557. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  558. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  559. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  560.  
  561. SET
  562. @Entry = 190000, -- NPC entry of the teleporter
  563. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  564. @id = 3; -- ID of the option from gossip_menu_option
  565.  
  566. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  567. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  568. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  569.  
  570. SET
  571. @Entry = 190000, -- NPC entry of the teleporter
  572. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  573. @id = 4; -- ID of the option from gossip_menu_option
  574.  
  575. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  576. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  577. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  578.  
  579. SET
  580. @Entry = 190000, -- NPC entry of the teleporter
  581. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  582. @id = 5; -- ID of the option from gossip_menu_option
  583.  
  584. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  585. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  586. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  587.  
  588. SET
  589. @Entry = 190000, -- NPC entry of the teleporter
  590. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  591. @id = 6; -- ID of the option from gossip_menu_option
  592.  
  593. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  594. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  595. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  596.  
  597. SET
  598. @Entry = 190000, -- NPC entry of the teleporter
  599. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  600. @id = 7; -- ID of the option from gossip_menu_option
  601.  
  602. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  603. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  604. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  605.  
  606. SET
  607. @Entry = 190000, -- NPC entry of the teleporter
  608. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  609. @id = 8; -- ID of the option from gossip_menu_option
  610.  
  611. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  612. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  613. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  614.  
  615. SET
  616. @Entry = 190000, -- NPC entry of the teleporter
  617. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  618. @id = 9; -- ID of the option from gossip_menu_option
  619.  
  620. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  621. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  622. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  623.  
  624. SET
  625. @Entry = 190000, -- NPC entry of the teleporter
  626. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  627. @id = 10; -- ID of the option from gossip_menu_option
  628.  
  629. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  630. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  631. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  632.  
  633. SET
  634. @Entry = 190000, -- NPC entry of the teleporter
  635. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  636. @id = 11; -- ID of the option from gossip_menu_option
  637.  
  638. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  639. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  640. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  641.  
  642. SET
  643. @Entry = 190000, -- NPC entry of the teleporter
  644. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  645. @id = 12; -- ID of the option from gossip_menu_option
  646.  
  647. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  648. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  649. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  650.  
  651. SET
  652. @Entry = 190000, -- NPC entry of the teleporter
  653. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  654. @id = 13; -- ID of the option from gossip_menu_option
  655.  
  656. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  657. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  658. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  659.  
  660. SET
  661. @Entry = 190000, -- NPC entry of the teleporter
  662. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  663. @id = 14; -- ID of the option from gossip_menu_option
  664.  
  665. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  666. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  667. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  668.  
  669. SET
  670. @Entry = 190000, -- NPC entry of the teleporter
  671. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  672. @id = 15; -- ID of the option from gossip_menu_option
  673.  
  674. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  675. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  676. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  677.  
  678. SET
  679. @Entry = 190000, -- NPC entry of the teleporter
  680. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  681. @id = 16; -- ID of the option from gossip_menu_option
  682.  
  683. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  684. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  685. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  686.  
  687. SET
  688. @Entry = 190000, -- NPC entry of the teleporter
  689. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  690. @id = 17; -- ID of the option from gossip_menu_option
  691.  
  692. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  693. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  694. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  695.  
  696. SET
  697. @Entry = 190000, -- NPC entry of the teleporter
  698. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  699. @id = 18; -- ID of the option from gossip_menu_option
  700.  
  701. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  702. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  703. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  704.  
  705. SET
  706. @Entry = 190000, -- NPC entry of the teleporter
  707. @menu_id = 50006, -- menu_id of the menu from gossip_menu_option
  708. @id = 19; -- ID of the option from gossip_menu_option
  709.  
  710. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  711. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  712. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  713.  
  714. SET
  715. @Entry = 190000, -- NPC entry of the teleporter
  716. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  717. @id = 0; -- ID of the option from gossip_menu_option
  718.  
  719. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  720. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  721. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  722.  
  723. SET
  724. @Entry = 190000, -- NPC entry of the teleporter
  725. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  726. @id = 1; -- ID of the option from gossip_menu_option
  727.  
  728. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  729. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  730. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  731.  
  732. SET
  733. @Entry = 190000, -- NPC entry of the teleporter
  734. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  735. @id = 2; -- ID of the option from gossip_menu_option
  736.  
  737. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  738. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  739. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  740.  
  741. SET
  742. @Entry = 190000, -- NPC entry of the teleporter
  743. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  744. @id = 3; -- ID of the option from gossip_menu_option
  745.  
  746. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  747. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  748. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  749.  
  750. SET
  751. @Entry = 190000, -- NPC entry of the teleporter
  752. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  753. @id = 4; -- ID of the option from gossip_menu_option
  754.  
  755. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  756. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  757. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  758.  
  759. SET
  760. @Entry = 190000, -- NPC entry of the teleporter
  761. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  762. @id = 5; -- ID of the option from gossip_menu_option
  763.  
  764. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  765. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  766. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  767.  
  768. SET
  769. @Entry = 190000, -- NPC entry of the teleporter
  770. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  771. @id = 6; -- ID of the option from gossip_menu_option
  772.  
  773. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  774. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  775. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  776.  
  777. SET
  778. @Entry = 190000, -- NPC entry of the teleporter
  779. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  780. @id = 7; -- ID of the option from gossip_menu_option
  781.  
  782. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  783. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  784. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  785.  
  786. SET
  787. @Entry = 190000, -- NPC entry of the teleporter
  788. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  789. @id = 8; -- ID of the option from gossip_menu_option
  790.  
  791. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  792. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  793. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  794.  
  795. SET
  796. @Entry = 190000, -- NPC entry of the teleporter
  797. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  798. @id = 9; -- ID of the option from gossip_menu_option
  799.  
  800. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  801. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  802. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  803.  
  804. SET
  805. @Entry = 190000, -- NPC entry of the teleporter
  806. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  807. @id = 10; -- ID of the option from gossip_menu_option
  808.  
  809. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  810. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  811. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  812.  
  813. SET
  814. @Entry = 190000, -- NPC entry of the teleporter
  815. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  816. @id = 11; -- ID of the option from gossip_menu_option
  817.  
  818. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  819. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  820. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  821.  
  822. SET
  823. @Entry = 190000, -- NPC entry of the teleporter
  824. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  825. @id = 12; -- ID of the option from gossip_menu_option
  826.  
  827. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  828. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  829. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  830.  
  831. SET
  832. @Entry = 190000, -- NPC entry of the teleporter
  833. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  834. @id = 13; -- ID of the option from gossip_menu_option
  835.  
  836. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  837. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  838. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  839.  
  840. SET
  841. @Entry = 190000, -- NPC entry of the teleporter
  842. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  843. @id = 14; -- ID of the option from gossip_menu_option
  844.  
  845. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  846. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  847. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  848.  
  849. SET
  850. @Entry = 190000, -- NPC entry of the teleporter
  851. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  852. @id = 15; -- ID of the option from gossip_menu_option
  853.  
  854. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  855. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  856. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  857.  
  858. SET
  859. @Entry = 190000, -- NPC entry of the teleporter
  860. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  861. @id = 16; -- ID of the option from gossip_menu_option
  862.  
  863. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  864. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  865. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  866.  
  867. SET
  868. @Entry = 190000, -- NPC entry of the teleporter
  869. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  870. @id = 17; -- ID of the option from gossip_menu_option
  871.  
  872. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  873. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  874. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  875.  
  876. SET
  877. @Entry = 190000, -- NPC entry of the teleporter
  878. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  879. @id = 18; -- ID of the option from gossip_menu_option
  880.  
  881. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  882. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  883. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  884.  
  885. SET
  886. @Entry = 190000, -- NPC entry of the teleporter
  887. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  888. @id = 19; -- ID of the option from gossip_menu_option
  889.  
  890. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  891. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  892. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  893.  
  894. SET
  895. @Entry = 190000, -- NPC entry of the teleporter
  896. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  897. @id = 20; -- ID of the option from gossip_menu_option
  898.  
  899. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  900. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  901. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  902.  
  903. SET
  904. @Entry = 190000, -- NPC entry of the teleporter
  905. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  906. @id = 21; -- ID of the option from gossip_menu_option
  907.  
  908. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  909. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  910. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  911.  
  912.  
  913. SET
  914. @Entry = 190000, -- NPC entry of the teleporter
  915. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  916. @id = 22; -- ID of the option from gossip_menu_option
  917.  
  918. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  919. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  920. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  921.  
  922. SET
  923. @Entry = 190000, -- NPC entry of the teleporter
  924. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  925. @id = 23; -- ID of the option from gossip_menu_option
  926.  
  927. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  928. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  929. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  930.  
  931. SET
  932. @Entry = 190000, -- NPC entry of the teleporter
  933. @menu_id = 50005, -- menu_id of the menu from gossip_menu_option
  934. @id = 24; -- ID of the option from gossip_menu_option
  935.  
  936. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  937. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  938. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  939.  
  940.  
  941. SET
  942. @Entry = 190000, -- NPC entry of the teleporter
  943. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  944. @id = 0; -- ID of the option from gossip_menu_option
  945.  
  946. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  947. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  948. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  949.  
  950. SET
  951. @Entry = 190000, -- NPC entry of the teleporter
  952. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  953. @id = 1; -- ID of the option from gossip_menu_option
  954.  
  955. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  956. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  957. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  958.  
  959. SET
  960. @Entry = 190000, -- NPC entry of the teleporter
  961. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  962. @id = 2; -- ID of the option from gossip_menu_option
  963.  
  964. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  965. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  966. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  967.  
  968. SET
  969. @Entry = 190000, -- NPC entry of the teleporter
  970. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  971. @id = 3; -- ID of the option from gossip_menu_option
  972.  
  973. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  974. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  975. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  976.  
  977. SET
  978. @Entry = 190000, -- NPC entry of the teleporter
  979. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  980. @id = 4; -- ID of the option from gossip_menu_option
  981.  
  982. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  983. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  984. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  985.  
  986. SET
  987. @Entry = 190000, -- NPC entry of the teleporter
  988. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  989. @id = 5; -- ID of the option from gossip_menu_option
  990.  
  991. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  992. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  993. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  994.  
  995. SET
  996. @Entry = 190000, -- NPC entry of the teleporter
  997. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  998. @id = 6; -- ID of the option from gossip_menu_option
  999.  
  1000. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1001. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1002. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1003.  
  1004. SET
  1005. @Entry = 190000, -- NPC entry of the teleporter
  1006. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1007. @id = 7; -- ID of the option from gossip_menu_option
  1008.  
  1009. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1010. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1011. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1012.  
  1013. SET
  1014. @Entry = 190000, -- NPC entry of the teleporter
  1015. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1016. @id = 8; -- ID of the option from gossip_menu_option
  1017.  
  1018. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1019. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1020. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1021.  
  1022. SET
  1023. @Entry = 190000, -- NPC entry of the teleporter
  1024. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1025. @id = 9; -- ID of the option from gossip_menu_option
  1026.  
  1027. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1028. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1029. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1030.  
  1031. SET
  1032. @Entry = 190000, -- NPC entry of the teleporter
  1033. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1034. @id = 10; -- ID of the option from gossip_menu_option
  1035.  
  1036. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1037. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1038. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1039.  
  1040. SET
  1041. @Entry = 190000, -- NPC entry of the teleporter
  1042. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1043. @id = 11; -- ID of the option from gossip_menu_option
  1044.  
  1045. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1046. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1047. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1048.  
  1049. SET
  1050. @Entry = 190000, -- NPC entry of the teleporter
  1051. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1052. @id = 12; -- ID of the option from gossip_menu_option
  1053.  
  1054. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1055. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1056. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1057.  
  1058. SET
  1059. @Entry = 190000, -- NPC entry of the teleporter
  1060. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1061. @id = 13; -- ID of the option from gossip_menu_option
  1062.  
  1063. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1064. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1065. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1066.  
  1067. SET
  1068. @Entry = 190000, -- NPC entry of the teleporter
  1069. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1070. @id = 14; -- ID of the option from gossip_menu_option
  1071.  
  1072. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1073. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1074. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1075.  
  1076. SET
  1077. @Entry = 190000, -- NPC entry of the teleporter
  1078. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1079. @id = 15; -- ID of the option from gossip_menu_option
  1080.  
  1081. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1082. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1083. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1084.  
  1085. SET
  1086. @Entry = 190000, -- NPC entry of the teleporter
  1087. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1088. @id = 16; -- ID of the option from gossip_menu_option
  1089.  
  1090. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1091. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1092. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1093.  
  1094. SET
  1095. @Entry = 190000, -- NPC entry of the teleporter
  1096. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1097. @id = 17; -- ID of the option from gossip_menu_option
  1098.  
  1099. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1100. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1101. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1102.  
  1103. SET
  1104. @Entry = 190000, -- NPC entry of the teleporter
  1105. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1106. @id = 18; -- ID of the option from gossip_menu_option
  1107.  
  1108. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1109. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1110. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1111.  
  1112. SET
  1113. @Entry = 190000, -- NPC entry of the teleporter
  1114. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1115. @id = 19; -- ID of the option from gossip_menu_option
  1116.  
  1117. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1118. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1119. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1120.  
  1121. SET
  1122. @Entry = 190000, -- NPC entry of the teleporter
  1123. @menu_id = 50000, -- menu_id of the menu from gossip_menu_option
  1124. @id = 20; -- ID of the option from gossip_menu_option
  1125.  
  1126. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1127. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1128. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1129.  
  1130. SET
  1131. @Entry = 190000, -- NPC entry of the teleporter
  1132. @menu_id = 50002, -- menu_id of the menu from gossip_menu_option
  1133. @id = 0; -- ID of the option from gossip_menu_option
  1134.  
  1135. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1136. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1137. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1138.  
  1139. SET
  1140. @Entry = 190000, -- NPC entry of the teleporter
  1141. @menu_id = 50002, -- menu_id of the menu from gossip_menu_option
  1142. @id = 1; -- ID of the option from gossip_menu_option
  1143.  
  1144. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1145. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1146. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1147.  
  1148. SET
  1149. @Entry = 190000, -- NPC entry of the teleporter
  1150. @menu_id = 50002, -- menu_id of the menu from gossip_menu_option
  1151. @id = 2; -- ID of the option from gossip_menu_option
  1152.  
  1153. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1154. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1155. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1156.  
  1157. SET
  1158. @Entry = 190000, -- NPC entry of the teleporter
  1159. @menu_id = 50002, -- menu_id of the menu from gossip_menu_option
  1160. @id = 3; -- ID of the option from gossip_menu_option
  1161.  
  1162. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1163. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1164. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1165.  
  1166. SET
  1167. @Entry = 190000, -- NPC entry of the teleporter
  1168. @menu_id = 50002, -- menu_id of the menu from gossip_menu_option
  1169. @id = 4; -- ID of the option from gossip_menu_option
  1170.  
  1171. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1172. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1173. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1174.  
  1175. SET
  1176. @Entry = 190000, -- NPC entry of the teleporter
  1177. @menu_id = 50002, -- menu_id of the menu from gossip_menu_option
  1178. @id = 5; -- ID of the option from gossip_menu_option
  1179.  
  1180. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1181. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1182. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1183.  
  1184. SET
  1185. @Entry = 190000, -- NPC entry of the teleporter
  1186. @menu_id = 50002, -- menu_id of the menu from gossip_menu_option
  1187. @id = 6; -- ID of the option from gossip_menu_option
  1188.  
  1189. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1190. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1191. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1192.  
  1193. SET
  1194. @Entry = 190000, -- NPC entry of the teleporter
  1195. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1196. @id = 0; -- ID of the option from gossip_menu_option
  1197.  
  1198. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1199. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1200. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1201.  
  1202. SET
  1203. @Entry = 190000, -- NPC entry of the teleporter
  1204. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1205. @id = 1; -- ID of the option from gossip_menu_option
  1206.  
  1207. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1208. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1209. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1210.  
  1211. SET
  1212. @Entry = 190000, -- NPC entry of the teleporter
  1213. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1214. @id = 2; -- ID of the option from gossip_menu_option
  1215.  
  1216. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1217. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1218. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1219.  
  1220. SET
  1221. @Entry = 190000, -- NPC entry of the teleporter
  1222. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1223. @id = 3; -- ID of the option from gossip_menu_option
  1224.  
  1225. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1226. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1227. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1228.  
  1229. SET
  1230. @Entry = 190000, -- NPC entry of the teleporter
  1231. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1232. @id = 4; -- ID of the option from gossip_menu_option
  1233.  
  1234. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1235. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1236. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1237.  
  1238. SET
  1239. @Entry = 190000, -- NPC entry of the teleporter
  1240. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1241. @id = 5; -- ID of the option from gossip_menu_option
  1242.  
  1243. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1244. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1245. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1246.  
  1247. SET
  1248. @Entry = 190000, -- NPC entry of the teleporter
  1249. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1250. @id = 6; -- ID of the option from gossip_menu_option
  1251.  
  1252. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1253. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1254. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1255.  
  1256. SET
  1257. @Entry = 190000, -- NPC entry of the teleporter
  1258. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1259. @id = 7; -- ID of the option from gossip_menu_option
  1260.  
  1261. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1262. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1263. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1264.  
  1265. SET
  1266. @Entry = 190000, -- NPC entry of the teleporter
  1267. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1268. @id = 8; -- ID of the option from gossip_menu_option
  1269.  
  1270. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1271. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1272. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1273.  
  1274. SET
  1275. @Entry = 190000, -- NPC entry of the teleporter
  1276. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1277. @id = 9; -- ID of the option from gossip_menu_option
  1278.  
  1279. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1280. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1281. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1282.  
  1283. SET
  1284. @Entry = 190000, -- NPC entry of the teleporter
  1285. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1286. @id = 10; -- ID of the option from gossip_menu_option
  1287.  
  1288. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1289. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1290. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1291.  
  1292. SET
  1293. @Entry = 190000, -- NPC entry of the teleporter
  1294. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1295. @id = 11; -- ID of the option from gossip_menu_option
  1296.  
  1297. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1298. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1299. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1300.  
  1301. SET
  1302. @Entry = 190000, -- NPC entry of the teleporter
  1303. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1304. @id = 12; -- ID of the option from gossip_menu_option
  1305.  
  1306. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1307. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1308. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1309.  
  1310. SET
  1311. @Entry = 190000, -- NPC entry of the teleporter
  1312. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1313. @id = 13; -- ID of the option from gossip_menu_option
  1314.  
  1315. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1316. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1317. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1318.  
  1319. SET
  1320. @Entry = 190000, -- NPC entry of the teleporter
  1321. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1322. @id = 14; -- ID of the option from gossip_menu_option
  1323.  
  1324. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1325. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1326. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1327.  
  1328. SET
  1329. @Entry = 190000, -- NPC entry of the teleporter
  1330. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1331. @id = 15; -- ID of the option from gossip_menu_option
  1332.  
  1333. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1334. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1335. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1336.  
  1337. SET
  1338. @Entry = 190000, -- NPC entry of the teleporter
  1339. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1340. @id = 16; -- ID of the option from gossip_menu_option
  1341.  
  1342. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1343. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1344. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1345.  
  1346. SET
  1347. @Entry = 190000, -- NPC entry of the teleporter
  1348. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1349. @id = 17; -- ID of the option from gossip_menu_option
  1350.  
  1351. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1352. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1353. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1354.  
  1355. SET
  1356. @Entry = 190000, -- NPC entry of the teleporter
  1357. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1358. @id = 18; -- ID of the option from gossip_menu_option
  1359.  
  1360. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1361. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1362. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
  1363.  
  1364. SET
  1365. @Entry = 190000, -- NPC entry of the teleporter
  1366. @menu_id = 50001, -- menu_id of the menu from gossip_menu_option
  1367. @id = 19; -- ID of the option from gossip_menu_option
  1368.  
  1369. DELETE FROM conditions WHERE sourcetypeorreferenceid = 15 AND sourcegroup = @menu_id AND sourceentry = @id;
  1370. DELETE FROM gossip_menu_option WHERE menu_id = @menu_id AND id = @id;
  1371. DELETE FROM smart_scripts WHERE entryorguid = @Entry AND source_type = 0 AND event_type = 62 AND event_param1 = @menu_id AND event_param2 = @id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!