Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO `gameobject_questrelation` (`id`, `quest`) VALUES
- (189303,12286),
- (190034,12331),
- (190035,12332),
- (190036,12333),
- (190037,12334),
- (190038,12335),
- (190039,12336),
- (190040,12337),
- (190041,12338),
- (190042,12339),
- (190043,12340),
- (190044,12341),
- (190045,12342),
- (190046,12343),
- (190047,12344),
- (190048,12345),
- (190049,12346),
- (190050,12347),
- (190051,12348),
- (190052,12349),
- (190053,12350),
- (190054,12351),
- (190055,12352),
- (190057,12353),
- (190059,12354),
- (190061,12355),
- (190062,12356),
- (190063,12357),
- (190064,12358),
- (190065,12359),
- (190066,12360),
- (190067,12361),
- (190068,12362),
- (190069,12363),
- (190070,12364),
- (190071,12365),
- (190072,12366),
- (190073,12367),
- (190074,12368),
- (190075,12369),
- (190076,12370),
- (190077,12371),
- (190078,12373),
- (190079,12374),
- (190080,12375),
- (190081,12376),
- (190082,12377),
- (190083,12378),
- (190084,12379),
- (190085,12380),
- (190086,12381),
- (190087,12382),
- (190088,12383),
- (190089,12384),
- (190090,12385),
- (190091,12386),
- (190096,12387),
- (190097,12388),
- (190098,12389),
- (190099,12390),
- (190100,12391),
- (190101,12392),
- (190102,12393),
- (190103,12394),
- (190104,12395),
- (190105,12396),
- (190106,12397),
- (190107,12398),
- (190108,12399),
- (190109,12400),
- (190110,12401),
- (190111,12402),
- (190112,12403),
- (190113,12404),
- (190114,12405),
- (190115,12406),
- (190116,12407),
- (191878,12408),
- (191879,12409),
- (191880,12410),
- (191881,12940),
- (191882,12941),
- (191883,12944),
- (192018,12945),
- (194056,12946),
- (194057,12947),
- (194059,12950),
- (194060,13433),
- (194061,13434),
- (194062,13435),
- (194063,13436),
- (194066,13437),
- (194067,13438),
- (194068,13439),
- (194069,13448),
- (194070,13452),
- (194071,13456),
- (194072,13459),
- (194064,13460),
- (194081,13461),
- (194076,13462),
- (194077,13463),
- (194078,13464),
- (194079,13465),
- (194084,13466);
- INSERT INTO `gameobject_involvedrelation` (`id`, `quest`) VALUES
- (189303,12286),
- (190034,12331),
- (190035,12332),
- (190036,12333),
- (190037,12334),
- (190038,12335),
- (190039,12336),
- (190040,12337),
- (190041,12338),
- (190042,12339),
- (190043,12340),
- (190044,12341),
- (190045,12342),
- (190046,12343),
- (190047,12344),
- (190048,12345),
- (190049,12346),
- (190050,12347),
- (190051,12348),
- (190052,12349),
- (190053,12350),
- (190054,12351),
- (190055,12352),
- (190057,12353),
- (190059,12354),
- (190061,12355),
- (190062,12356),
- (190063,12357),
- (190064,12358),
- (190065,12359),
- (190066,12360),
- (190067,12361),
- (190068,12362),
- (190069,12363),
- (190070,12364),
- (190071,12365),
- (190072,12366),
- (190073,12367),
- (190074,12368),
- (190075,12369),
- (190076,12370),
- (190077,12371),
- (190078,12373),
- (190079,12374),
- (190080,12375),
- (190081,12376),
- (190082,12377),
- (190083,12378),
- (190084,12379),
- (190085,12380),
- (190086,12381),
- (190087,12382),
- (190088,12383),
- (190089,12384),
- (190090,12385),
- (190091,12386),
- (190096,12387),
- (190097,12388),
- (190098,12389),
- (190099,12390),
- (190100,12391),
- (190101,12392),
- (190102,12393),
- (190103,12394),
- (190104,12395),
- (190105,12396),
- (190106,12397),
- (190107,12398),
- (190108,12399),
- (190109,12400),
- (190110,12401),
- (190111,12402),
- (190112,12403),
- (190113,12404),
- (190114,12405),
- (190115,12406),
- (190116,12407),
- (191878,12408),
- (191879,12409),
- (191880,12410),
- (191881,12940),
- (191882,12941),
- (191883,12944),
- (192018,12945),
- (194056,12946),
- (194057,12947),
- (194059,12950),
- (194060,13433),
- (194061,13434),
- (194062,13435),
- (194063,13436),
- (194066,13437),
- (194067,13438),
- (194068,13439),
- (194069,13448),
- (194070,13452),
- (194071,13456),
- (194072,13459),
- (194064,13460),
- (194081,13461),
- (194076,13462),
- (194077,13463),
- (194078,13464),
- (194079,13465),
- (194084,13466);
- PHP CODE
- function generateHalloweenQuests()
- {
- $Gsql = "SELECT `entry` FROM `gameobject_template` WHERE `name`='Candy Bucket' ORDER BY `data1` ASC;";
- $Qsql = "SELECT `entry` FROM `quest_template` WHERE `title` = 'Candy Bucket' ORDER BY `entry` ASC;";
- $Gresult = mysql_query($Gsql) or die(mysql_error());
- $Qresult = mysql_query($Qsql) or die(mysql_error());
- // Put them in array
- for($i = 0; $quests[$i] = mysql_fetch_assoc($Qresult); $i++) ;
- for($i = 0; $gos[$i] = mysql_fetch_assoc($Gresult); $i++) ;
- // Delete last empty one
- array_pop($quests);
- array_pop($gos);
- echo "INSERT INTO `gameobject_questrelation` (`id`, `quest`) VALUES <br/>\n";
- for($i = 0; $i < sizeof($gos); $i++)
- {
- echo "(".$gos[$i]['entry'].",".$quests[$i]['entry']."),<br/>\n";
- }
- echo "INSERT INTO `gameobject_involvedrelation` (`id`, `quest`) VALUES <br/>\n";
- for($i = 0; $i < sizeof($gos); $i++)
- {
- echo "(".$gos[$i]['entry'].",".$quests[$i]['entry']."),<br/>\n";
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement