Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.62 KB | None | 0 0
  1. INSERT INTO `gameobject_questrelation` (`id`, `quest`) VALUES
  2. (189303,12286),
  3. (190034,12331),
  4. (190035,12332),
  5. (190036,12333),
  6. (190037,12334),
  7. (190038,12335),
  8. (190039,12336),
  9. (190040,12337),
  10. (190041,12338),
  11. (190042,12339),
  12. (190043,12340),
  13. (190044,12341),
  14. (190045,12342),
  15. (190046,12343),
  16. (190047,12344),
  17. (190048,12345),
  18. (190049,12346),
  19. (190050,12347),
  20. (190051,12348),
  21. (190052,12349),
  22. (190053,12350),
  23. (190054,12351),
  24. (190055,12352),
  25. (190057,12353),
  26. (190059,12354),
  27. (190061,12355),
  28. (190062,12356),
  29. (190063,12357),
  30. (190064,12358),
  31. (190065,12359),
  32. (190066,12360),
  33. (190067,12361),
  34. (190068,12362),
  35. (190069,12363),
  36. (190070,12364),
  37. (190071,12365),
  38. (190072,12366),
  39. (190073,12367),
  40. (190074,12368),
  41. (190075,12369),
  42. (190076,12370),
  43. (190077,12371),
  44. (190078,12373),
  45. (190079,12374),
  46. (190080,12375),
  47. (190081,12376),
  48. (190082,12377),
  49. (190083,12378),
  50. (190084,12379),
  51. (190085,12380),
  52. (190086,12381),
  53. (190087,12382),
  54. (190088,12383),
  55. (190089,12384),
  56. (190090,12385),
  57. (190091,12386),
  58. (190096,12387),
  59. (190097,12388),
  60. (190098,12389),
  61. (190099,12390),
  62. (190100,12391),
  63. (190101,12392),
  64. (190102,12393),
  65. (190103,12394),
  66. (190104,12395),
  67. (190105,12396),
  68. (190106,12397),
  69. (190107,12398),
  70. (190108,12399),
  71. (190109,12400),
  72. (190110,12401),
  73. (190111,12402),
  74. (190112,12403),
  75. (190113,12404),
  76. (190114,12405),
  77. (190115,12406),
  78. (190116,12407),
  79. (191878,12408),
  80. (191879,12409),
  81. (191880,12410),
  82. (191881,12940),
  83. (191882,12941),
  84. (191883,12944),
  85. (192018,12945),
  86. (194056,12946),
  87. (194057,12947),
  88. (194059,12950),
  89. (194060,13433),
  90. (194061,13434),
  91. (194062,13435),
  92. (194063,13436),
  93. (194066,13437),
  94. (194067,13438),
  95. (194068,13439),
  96. (194069,13448),
  97. (194070,13452),
  98. (194071,13456),
  99. (194072,13459),
  100. (194064,13460),
  101. (194081,13461),
  102. (194076,13462),
  103. (194077,13463),
  104. (194078,13464),
  105. (194079,13465),
  106. (194084,13466);
  107. INSERT INTO `gameobject_involvedrelation` (`id`, `quest`) VALUES
  108. (189303,12286),
  109. (190034,12331),
  110. (190035,12332),
  111. (190036,12333),
  112. (190037,12334),
  113. (190038,12335),
  114. (190039,12336),
  115. (190040,12337),
  116. (190041,12338),
  117. (190042,12339),
  118. (190043,12340),
  119. (190044,12341),
  120. (190045,12342),
  121. (190046,12343),
  122. (190047,12344),
  123. (190048,12345),
  124. (190049,12346),
  125. (190050,12347),
  126. (190051,12348),
  127. (190052,12349),
  128. (190053,12350),
  129. (190054,12351),
  130. (190055,12352),
  131. (190057,12353),
  132. (190059,12354),
  133. (190061,12355),
  134. (190062,12356),
  135. (190063,12357),
  136. (190064,12358),
  137. (190065,12359),
  138. (190066,12360),
  139. (190067,12361),
  140. (190068,12362),
  141. (190069,12363),
  142. (190070,12364),
  143. (190071,12365),
  144. (190072,12366),
  145. (190073,12367),
  146. (190074,12368),
  147. (190075,12369),
  148. (190076,12370),
  149. (190077,12371),
  150. (190078,12373),
  151. (190079,12374),
  152. (190080,12375),
  153. (190081,12376),
  154. (190082,12377),
  155. (190083,12378),
  156. (190084,12379),
  157. (190085,12380),
  158. (190086,12381),
  159. (190087,12382),
  160. (190088,12383),
  161. (190089,12384),
  162. (190090,12385),
  163. (190091,12386),
  164. (190096,12387),
  165. (190097,12388),
  166. (190098,12389),
  167. (190099,12390),
  168. (190100,12391),
  169. (190101,12392),
  170. (190102,12393),
  171. (190103,12394),
  172. (190104,12395),
  173. (190105,12396),
  174. (190106,12397),
  175. (190107,12398),
  176. (190108,12399),
  177. (190109,12400),
  178. (190110,12401),
  179. (190111,12402),
  180. (190112,12403),
  181. (190113,12404),
  182. (190114,12405),
  183. (190115,12406),
  184. (190116,12407),
  185. (191878,12408),
  186. (191879,12409),
  187. (191880,12410),
  188. (191881,12940),
  189. (191882,12941),
  190. (191883,12944),
  191. (192018,12945),
  192. (194056,12946),
  193. (194057,12947),
  194. (194059,12950),
  195. (194060,13433),
  196. (194061,13434),
  197. (194062,13435),
  198. (194063,13436),
  199. (194066,13437),
  200. (194067,13438),
  201. (194068,13439),
  202. (194069,13448),
  203. (194070,13452),
  204. (194071,13456),
  205. (194072,13459),
  206. (194064,13460),
  207. (194081,13461),
  208. (194076,13462),
  209. (194077,13463),
  210. (194078,13464),
  211. (194079,13465),
  212. (194084,13466);
  213.  
  214. PHP CODE
  215. function generateHalloweenQuests()
  216.     {
  217.         $Gsql = "SELECT `entry` FROM `gameobject_template` WHERE `name`='Candy Bucket' ORDER BY `data1` ASC;";
  218.         $Qsql = "SELECT `entry` FROM `quest_template` WHERE `title` = 'Candy Bucket' ORDER BY `entry` ASC;";
  219.        
  220.         $Gresult = mysql_query($Gsql) or die(mysql_error());
  221.         $Qresult = mysql_query($Qsql) or die(mysql_error());
  222.        
  223.         // Put them in array
  224.         for($i = 0; $quests[$i] = mysql_fetch_assoc($Qresult); $i++) ;    
  225.         for($i = 0; $gos[$i] = mysql_fetch_assoc($Gresult); $i++) ;    
  226.            
  227.         // Delete last empty one
  228.         array_pop($quests);
  229.         array_pop($gos);
  230.         echo "INSERT INTO `gameobject_questrelation` (`id`, `quest`) VALUES <br/>\n";
  231.         for($i = 0; $i < sizeof($gos); $i++)
  232.         {
  233.             echo "(".$gos[$i]['entry'].",".$quests[$i]['entry']."),<br/>\n";
  234.         }
  235.        
  236.         echo "INSERT INTO `gameobject_involvedrelation` (`id`, `quest`) VALUES <br/>\n";
  237.         for($i = 0; $i < sizeof($gos); $i++)
  238.         {
  239.             echo "(".$gos[$i]['entry'].",".$quests[$i]['entry']."),<br/>\n";
  240.         }
  241.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement