Frostfang Sea Holiday Spawns
Posted: Wed Apr 24, 2013 8:37 pm
Making some queries for folks to enable/disable holiday spawns as they wish, will add queries as I make them. Simply change spawn percentage to 100 or 0 in the queries.
-Frostfell Objects-
-Frostfell Sign (entrance)-
-Nights of the Dead Objects-
-City Festival Objects-
-Erollisi Day Objects-
-Frostfell Objects-
Code: Select all
update spawn_location_entry set spawnpercentage=0 where spawn_id IN (4701633,4701588,4701560,4701614,4701587,4701669,4701613,4701612,4701611,4701670,4701671,4701679,4701615,
4701652,4701664,4701619,4701598,4701608,4701609,4701597,4701558,4701626,4701605,4701640,4701586,4701604,4701668,4701595,4701666,4701561,4701635,4701634,4701650,4701592,
4701617,4701680,4701601,4701676,4701596,4701658,4701610,4701599,4701665,4701559,4701594,4701591,4701607,4701585,4701629,4701593,4701590,4701583,4701584,4701603,4701625,4701663);Code: Select all
update spawn_location_entry set spawnpercentage=0 where spawn_id=4701780;Code: Select all
update spawn_location_entry set spawnpercentage=0 where spawn_id IN (4701627,4701759,4701726,4701718,4701717,4701715,4701716,4701724,4701639,4701645,4701638,4701621,4701606,
4701711,4701714,4701712,4701713,4701729,4701719);
update spawn_location_entry set spawnpercentage=0 where spawn_location_id IN (442261,442260,442256,442257,442255,442254,442258,442259);Code: Select all
update spawn_location_entry set spawnpercentage=0 where spawn_id IN (4701692,4701709,4701707,4701698,4701708,4701706,4701693,4701696,4701694,4701701,4701695,4701703,
4701700,4701704,4701705,4701702,4701763,4701697,4701699);-Erollisi Day Objects-
Code: Select all
update spawn_location_entry set spawnpercentage=0 where spawn_id IN (4701683,4701616,4701725,4701669,4701611,4701679);