Advertisement
Guest User

Untitled

a guest
Apr 18th, 2015
209
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.67 KB | None | 0 0
  1. ------- MOP Q START
  2.  
  3. DELETE FROM `creature_queststarter` WHERE `id`=67880;
  4. DELETE FROM `creature_queststarter` WHERE `id`=67402;
  5. DELETE FROM `creature_queststarter` WHERE `id`=67628;
  6. DELETE FROM `creature_queststarter` WHERE `id`=67767;
  7. DELETE FROM `creature_queststarter` WHERE `id`=67618;
  8. DELETE FROM `creature_queststarter` WHERE `id`=67608;
  9. DELETE FROM `creature_queststarter` WHERE `id`=67535;
  10. DELETE FROM `creature_queststarter` WHERE `id`=67533;
  11. DELETE FROM `creature_queststarter` WHERE `id`=67534;
  12. DELETE FROM `creature_queststarter` WHERE `id`=67554;
  13. DELETE FROM `creature_queststarter` WHERE `id`=67537;
  14. DELETE FROM `creature_queststarter` WHERE `id`=68274;
  15. DELETE FROM `creature_queststarter` WHERE `id`=67553;
  16.  
  17. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  18. (67880, 32128),
  19. (67880, 32235),
  20. (67880, 32449),
  21. (67880, 32450);
  22.  
  23. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  24. (67402, 32130),
  25. (67402, 32134),
  26. (67402, 32131);
  27.  
  28.  
  29. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  30. (67628, 32135),
  31. (67628, 32133),
  32. (67628, 32132);
  33.  
  34.  
  35.  
  36. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  37. (67767, 32127),
  38. (67767, 32126);
  39.  
  40. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  41. (67618, 32222),
  42. (67618, 32223),
  43. (67618, 32123);
  44.  
  45. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  46. (67608, 32214),
  47. (67608, 32221);
  48.  
  49. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  50. (67535, 32136),
  51. (67535, 32140),
  52. (67535, 32138);
  53.  
  54.  
  55. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  56. (67533, 32238),
  57. (67533, 32236);
  58.  
  59.  
  60.  
  61. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  62. (67534, 32139);
  63.  
  64. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  65. (67554, 32236);
  66.  
  67.  
  68.  
  69. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  70. (67553, 32237);
  71.  
  72.  
  73.  
  74. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  75. (67537, 32141),
  76. (67537, 32166);
  77.  
  78.  
  79.  
  80. INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
  81. (68274, 32344),
  82. (68274, 32348),
  83. (68274, 32120),
  84. (68274, 32343),
  85. (68274, 32342),
  86. (68274, 32345);
  87.  
  88.  
  89.  
  90. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67880;
  91. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67402;
  92. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67628;
  93. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67767;
  94. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67618;
  95. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67608;
  96.  
  97. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67535;
  98. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67533;
  99. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67534;
  100. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67554;
  101. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67553;
  102.  
  103. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =67537;
  104. UPDATE `creature_template` SET `npcflag` = '3' WHERE `creature_template`.`entry` =68274;
  105.  
  106.  
  107.  
  108.  
  109.  
  110.  
  111.  
  112. ------- MOP Q ENDER
  113.  
  114.  
  115.  
  116. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  117. (67880, 32128),
  118. (67880, 32235),
  119. (67880, 32449),
  120. (67880, 32450);
  121.  
  122. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  123. (67402, 32130),
  124. (67402, 32134),
  125. (67402, 32131);
  126.  
  127.  
  128. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  129. (67628, 32135),
  130. (67628, 32133),
  131. (67628, 32132);
  132.  
  133.  
  134.  
  135. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  136. (67767, 32127),
  137. (67767, 32126);
  138.  
  139. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  140. (67618, 32222),
  141. (67618, 32223),
  142. (67618, 32123);
  143.  
  144. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  145. (67608, 32214),
  146. (67608, 32221);
  147.  
  148. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  149. (67535, 32136),
  150. (67535, 32140),
  151. (67535, 32138);
  152.  
  153.  
  154. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  155. (67533, 32238),
  156. (67533, 32236);
  157.  
  158.  
  159. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  160. (67534, 32139);
  161.  
  162. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  163. (67554, 32236);
  164.  
  165.  
  166.  
  167. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  168. (67553, 32237);
  169.  
  170.  
  171.  
  172. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  173. (67537, 32141),
  174. (67537, 32166);
  175.  
  176.  
  177.  
  178. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  179. (68274, 32344),
  180. (68274, 32118),
  181. (68274, 32348),
  182. (68274, 32120),
  183. (68274, 32343),
  184. (68274, 32342),
  185. (68274, 32345);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement