search

xackery / eqcleanup

Cleans up PEQ database to go to certain progressions
GNU General Public License v3.0
6 stars 3 forks source link

Delete zones after velious #32

Open minijag opened 6 years ago

minijag commented 6 years ago

-- Delete zones from expansions after Velious DELETE FROM zone WHERE zoneidnumber NOT IN ( 1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20, 21,22,23,24,25,25,27,29,30,31,32,33,34,35,36,37,38,39,40, 41,42,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60, 61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80, 81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100, 101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120, 121,123,124,125,126,127,128,129); -- Delete zone_points to zones from expansions after Velious DELETE FROM zone_points WHERE target_zone_id NOT IN ( 1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20, 21,22,23,24,25,25,27,29,30,31,32,33,34,35,36,37,38,39,40, 41,42,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60, 61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80, 81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100, 101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120, 121,123,124,125,126,127,128,129); -- Delete the remaining zone_points that originate from post Velious expansions that point to old world, kunark, and Velious DELETE FROM zone_points where zone IN ('eastwastesshard','breedinggrounds','feerrott2','brellsrest', 'oldfieldofbone','oldblackburrow','oldkithicor','oldcommons','oceangreenhills', 'steamfontmts','innothuleb','toxxulia','corathus','poknowledge','highpasshold', 'commonlands','mistythicket','delvea','broodlands','potimeb','potranquility', 'veksar','jaggedpine','potactics','chardokb','soldungc','nexus','gunthak','commons'); -- Deleting extra zones complete

-- Might need to remove traps as well.

-- Delete starting_zones data for everything after Velious DELETE FROM start_zones WHERE start_zone > 129;

-- Delete ground_spawns data for everything after Velious DELETE FROM ground_spawns WHERE zoneid NOT IN ( 1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20, 21,22,23,24,25,25,27,29,30,31,32,33,34,35,36,37,38,39,40, 41,42,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60, 61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80, 81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100, 101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120, 121,123,124,125,126,127,128,129);

-- Delete forage data for all zones after Velious DELETE FROM forage WHERE zoneid NOT IN ( 1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20, 21,22,23,24,25,25,27,29,30,31,32,33,34,35,36,37,38,39,40, 41,42,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60, 61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80, 81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100, 101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120, 121,123,124,125,126,127,128,129);

-- Delete fishing data for all zones after Velious DELETE FROM fishing WHERE zoneid NOT IN ( 1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20, 21,22,23,24,25,25,27,29,30,31,32,33,34,35,36,37,38,39,40, 41,42,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60, 61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80, 81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100, 101,102,103,104,105,106,107,108,110,111,112,113,114,115,116,117,118,119,120, 121,123,124,125,126,127,128,129);