Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.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.  
  108. /* PHP CODE
  109. function generateHalloweenQuests()
  110.     {
  111.         $Gsql = "SELECT `entry` FROM `gameobject_template` WHERE `name`='Candy Bucket' ORDER BY `data1` ASC;";
  112.         $Qsql = "SELECT `entry` FROM `quest_template` WHERE `title` = 'Candy Bucket' ORDER BY `entry` ASC;";
  113.        
  114.         $Gresult = mysql_query($Gsql) or die(mysql_error());
  115.         $Qresult = mysql_query($Qsql) or die(mysql_error());
  116.        
  117.         // Put them in array
  118.         for($i = 0; $quests[$i] = mysql_fetch_assoc($Qresult); $i++) ;    
  119.         for($i = 0; $gos[$i] = mysql_fetch_assoc($Gresult); $i++) ;    
  120.            
  121.         // Delete last empty one
  122.         array_pop($quests);
  123.         array_pop($gos);
  124.         echo "INSERT INTO `gameobject_questrelation` (`id`, `quest`) VALUES <br/>\n";
  125.         for($i = 0; $i < sizeof($gos); $i++)
  126.         {
  127.             echo "(".$gos[$i]['entry'].",".$quests[$i]['entry']."),<br/>\n";
  128.         }
  129.     }
  130. */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement