Items by Era

[Kingly_Krab]

There's a .sql that comes with the PHP Editor (expansions.sql):

alter table zone add `expansion` tinyint(3) NOT NULL default 0;

update zone set expansion = 1 where short_name = 'qeynos';
update zone set expansion = 1 where short_name = 'qeynos2';
update zone set expansion = 1 where short_name = 'qrg';
update zone set expansion = 1 where short_name = 'qeytoqrg';
update zone set expansion = 1 where short_name = 'highpass';
update zone set expansion = 1 where short_name = 'highkeep';
update zone set expansion = 1 where short_name = 'freportn';
update zone set expansion = 1 where short_name = 'freportw';
update zone set expansion = 1 where short_name = 'freporte';
update zone set expansion = 1 where short_name = 'runnyeye';
update zone set expansion = 1 where short_name = 'qey2hh1';
update zone set expansion = 1 where short_name = 'northkarana';
update zone set expansion = 1 where short_name = 'southkarana';
update zone set expansion = 1 where short_name = 'eastkarana';
update zone set expansion = 1 where short_name = 'beholder';
update zone set expansion = 1 where short_name = 'blackburrow';
update zone set expansion = 1 where short_name = 'paw';
update zone set expansion = 1 where short_name = 'rivervale';
update zone set expansion = 1 where short_name = 'kithicor';
update zone set expansion = 1 where short_name = 'commons';
update zone set expansion = 1 where short_name = 'ecommons';
update zone set expansion = 1 where short_name = 'erudnint';
update zone set expansion = 1 where short_name = 'erudnext';
update zone set expansion = 1 where short_name = 'nektulos';
update zone set expansion = 1 where short_name = 'nektulos';
update zone set expansion = 1 where short_name = 'cshome';
update zone set expansion = 1 where short_name = 'lavastorm';
update zone set expansion = 1 where short_name = 'halas';
update zone set expansion = 1 where short_name = 'everfrost';
update zone set expansion = 1 where short_name = 'soldunga';
update zone set expansion = 1 where short_name = 'soldungb';
update zone set expansion = 1 where short_name = 'misty';
update zone set expansion = 1 where short_name = 'nro';
update zone set expansion = 1 where short_name = 'sro';
update zone set expansion = 1 where short_name = 'befallen';
update zone set expansion = 1 where short_name = 'oasis';
update zone set expansion = 1 where short_name = 'tox';
update zone set expansion = 1 where short_name = 'hole';
update zone set expansion = 1 where short_name = 'neriaka';
update zone set expansion = 1 where short_name = 'neriakb';
update zone set expansion = 1 where short_name = 'neriakc';
update zone set expansion = 1 where short_name = 'najena';
update zone set expansion = 1 where short_name = 'qcat';
update zone set expansion = 1 where short_name = 'innothule';
update zone set expansion = 1 where short_name = 'feerrott';
update zone set expansion = 1 where short_name = 'cazicthule';
update zone set expansion = 1 where short_name = 'oggok';
update zone set expansion = 1 where short_name = 'rathemtn';
update zone set expansion = 1 where short_name = 'lakerathe';
update zone set expansion = 1 where short_name = 'grobb';
update zone set expansion = 1 where short_name = 'gfaydark';
update zone set expansion = 1 where short_name = 'akanon';
update zone set expansion = 1 where short_name = 'steamfont';
update zone set expansion = 1 where short_name = 'lfaydark';
update zone set expansion = 1 where short_name = 'crushbone';
update zone set expansion = 1 where short_name = 'mistmoore';
update zone set expansion = 1 where short_name = 'kaladima';
update zone set expansion = 1 where short_name = 'felwithea';
update zone set expansion = 1 where short_name = 'felwitheb';
update zone set expansion = 1 where short_name = 'unrest';
update zone set expansion = 1 where short_name = 'kedge';
update zone set expansion = 1 where short_name = 'guktop';
update zone set expansion = 1 where short_name = 'gukbottom';
update zone set expansion = 1 where short_name = 'kaladimb';
update zone set expansion = 1 where short_name = 'butcher';
update zone set expansion = 1 where short_name = 'oot';
update zone set expansion = 1 where short_name = 'cauldron';
update zone set expansion = 1 where short_name = 'airplane';
update zone set expansion = 1 where short_name = 'fearplane';
update zone set expansion = 1 where short_name = 'permafrost';
update zone set expansion = 1 where short_name = 'kerraridge';
update zone set expansion = 1 where short_name = 'paineel';
update zone set expansion = 1 where short_name = 'hateplane';
update zone set expansion = 1 where short_name = 'arena';
update zone set expansion = 1 where short_name = 'hateplaneb';

update zone set expansion = 1 where short_name = 'fhalls';
update zone set expansion = 1 where short_name = 'tutoriala';
update zone set expansion = 1 where short_name = 'tutorialb';
update zone set expansion = 1 where short_name = 'jaggedpine';
update zone set expansion = 1 where short_name = 'nedaria';
update zone set expansion = 1 where short_name = 'arena2';
update zone set expansion = 1 where short_name = 'shadowrest';

update zone set expansion = 2 where short_name = 'fieldofbone';
update zone set expansion = 2 where short_name = 'warslikswood';
update zone set expansion = 2 where short_name = 'soltemple';
update zone set expansion = 2 where short_name = 'droga';
update zone set expansion = 2 where short_name = 'cabwest';
update zone set expansion = 2 where short_name = 'swampofnohope';
update zone set expansion = 2 where short_name = 'firiona';
update zone set expansion = 2 where short_name = 'lakeofillomen';
update zone set expansion = 2 where short_name = 'dreadlands';
update zone set expansion = 2 where short_name = 'burningwood';
update zone set expansion = 2 where short_name = 'kaesora';
update zone set expansion = 2 where short_name = 'sebilis';
update zone set expansion = 2 where short_name = 'citymist';
update zone set expansion = 2 where short_name = 'skyfire';
update zone set expansion = 2 where short_name = 'frontiermtns';
update zone set expansion = 2 where short_name = 'overthere';
update zone set expansion = 2 where short_name = 'emeraldjungle';
update zone set expansion = 2 where short_name = 'trakanon';
update zone set expansion = 2 where short_name = 'timorous';
update zone set expansion = 2 where short_name = 'kurn';
update zone set expansion = 2 where short_name = 'erudsxing';
update zone set expansion = 2 where short_name = 'stonebrunt';
update zone set expansion = 2 where short_name = 'warrens';
update zone set expansion = 2 where short_name = 'karnor';
update zone set expansion = 2 where short_name = 'chardok';
update zone set expansion = 2 where short_name = 'dalnir';
update zone set expansion = 2 where short_name = 'charasis';
update zone set expansion = 2 where short_name = 'cabeast';
update zone set expansion = 2 where short_name = 'nurga';
update zone set expansion = 2 where short_name = 'veeshan';
update zone set expansion = 2 where short_name = 'veksar';

update zone set expansion = 3 where short_name = 'iceclad';
update zone set expansion = 3 where short_name = 'frozenshadow';
update zone set expansion = 3 where short_name = 'velketor';
update zone set expansion = 3 where short_name = 'kael';
update zone set expansion = 3 where short_name = 'skyshrine';
update zone set expansion = 3 where short_name = 'thurgadina';
update zone set expansion = 3 where short_name = 'eastwastes';
update zone set expansion = 3 where short_name = 'cobaltscar';
update zone set expansion = 3 where short_name = 'greatdivide';
update zone set expansion = 3 where short_name = 'wakening';
update zone set expansion = 3 where short_name = 'westwastes';
update zone set expansion = 3 where short_name = 'crystal';
update zone set expansion = 3 where short_name = 'necropolis';
update zone set expansion = 3 where short_name = 'templeveeshan';
update zone set expansion = 3 where short_name = 'sirens';
update zone set expansion = 3 where short_name = 'mischiefplane';
update zone set expansion = 3 where short_name = 'growthplane';
update zone set expansion = 3 where short_name = 'sleeper';
update zone set expansion = 3 where short_name = 'thurgadinb';

update zone set expansion = 4 where short_name = 'shadowhaven';
update zone set expansion = 4 where short_name = 'bazaar';
update zone set expansion = 4 where short_name = 'nexus';
update zone set expansion = 4 where short_name = 'echo';
update zone set expansion = 4 where short_name = 'acrylia';
update zone set expansion = 4 where short_name = 'sharvahl';
update zone set expansion = 4 where short_name = 'paludal';
update zone set expansion = 4 where short_name = 'fungusgrove';
update zone set expansion = 4 where short_name = 'vexthal';
update zone set expansion = 4 where short_name = 'sseru';
update zone set expansion = 4 where short_name = 'katta';
update zone set expansion = 4 where short_name = 'netherbian';
update zone set expansion = 4 where short_name = 'ssratemple';
update zone set expansion = 4 where short_name = 'griegsend';
update zone set expansion = 4 where short_name = 'thedeep';
update zone set expansion = 4 where short_name = 'shadeweaver';
update zone set expansion = 4 where short_name = 'hollowshade';
update zone set expansion = 4 where short_name = 'grimling';
update zone set expansion = 4 where short_name = 'mseru';
update zone set expansion = 4 where short_name = 'letalis';
update zone set expansion = 4 where short_name = 'twilight';
update zone set expansion = 4 where short_name = 'thegrey';
update zone set expansion = 4 where short_name = 'tenebrous';
update zone set expansion = 4 where short_name = 'maiden';
update zone set expansion = 4 where short_name = 'dawnshroud';
update zone set expansion = 4 where short_name = 'scarlet';
update zone set expansion = 4 where short_name = 'umbral';
update zone set expansion = 4 where short_name = 'akheva';

update zone set expansion = 5 where short_name = 'codecay';
update zone set expansion = 5 where short_name = 'pojustice';
update zone set expansion = 5 where short_name = 'poknowledge';
update zone set expansion = 5 where short_name = 'potranquility';
update zone set expansion = 5 where short_name = 'ponightmare';
update zone set expansion = 5 where short_name = 'podisease';
update zone set expansion = 5 where short_name = 'poinnovation';
update zone set expansion = 5 where short_name = 'potorment';
update zone set expansion = 5 where short_name = 'povalor';
update zone set expansion = 5 where short_name = 'bothunder';
update zone set expansion = 5 where short_name = 'postorms';
update zone set expansion = 5 where short_name = 'hohonora';
update zone set expansion = 5 where short_name = 'solrotower';
update zone set expansion = 5 where short_name = 'powar';
update zone set expansion = 5 where short_name = 'potactics';
update zone set expansion = 5 where short_name = 'poair';
update zone set expansion = 5 where short_name = 'powater';
update zone set expansion = 5 where short_name = 'pofire';
update zone set expansion = 5 where short_name = 'poeartha';
update zone set expansion = 5 where short_name = 'potimea';
update zone set expansion = 5 where short_name = 'hohonorb';
update zone set expansion = 5 where short_name = 'nightmareb';
update zone set expansion = 5 where short_name = 'poearthb';
update zone set expansion = 5 where short_name = 'potimeb';

update zone set expansion = 6 where short_name = 'gunthak';
update zone set expansion = 6 where short_name = 'dulak';
update zone set expansion = 6 where short_name = 'torgiran';
update zone set expansion = 6 where short_name = 'nadox';
update zone set expansion = 6 where short_name = 'hatesfury';
update zone set expansion = 6 where short_name = 'chardokb';
update zone set expansion = 6 where short_name = 'soldungc';

update zone set expansion = 7 where short_name = 'guka';
update zone set expansion = 7 where short_name = 'ruja';
update zone set expansion = 7 where short_name = 'taka';
update zone set expansion = 7 where short_name = 'mira';
update zone set expansion = 7 where short_name = 'mmca';
update zone set expansion = 7 where short_name = 'gukb';
update zone set expansion = 7 where short_name = 'rujb';
update zone set expansion = 7 where short_name = 'takb';
update zone set expansion = 7 where short_name = 'mirb';
update zone set expansion = 7 where short_name = 'mmcb';
update zone set expansion = 7 where short_name = 'gukc';
update zone set expansion = 7 where short_name = 'rujc';
update zone set expansion = 7 where short_name = 'takc';
update zone set expansion = 7 where short_name = 'mirc';
update zone set expansion = 7 where short_name = 'mmcc';
update zone set expansion = 7 where short_name = 'gukd';
update zone set expansion = 7 where short_name = 'rujd';
update zone set expansion = 7 where short_name = 'takd';
update zone set expansion = 7 where short_name = 'mird';
update zone set expansion = 7 where short_name = 'mmcd';
update zone set expansion = 7 where short_name = 'guke';
update zone set expansion = 7 where short_name = 'ruje';
update zone set expansion = 7 where short_name = 'take';
update zone set expansion = 7 where short_name = 'mire';
update zone set expansion = 7 where short_name = 'mmce';
update zone set expansion = 7 where short_name = 'gukf';
update zone set expansion = 7 where short_name = 'rujf';
update zone set expansion = 7 where short_name = 'takf';
update zone set expansion = 7 where short_name = 'mirf';
update zone set expansion = 7 where short_name = 'mmcf';
update zone set expansion = 7 where short_name = 'gukg';
update zone set expansion = 7 where short_name = 'rujg';
update zone set expansion = 7 where short_name = 'takg';
update zone set expansion = 7 where short_name = 'mirg';
update zone set expansion = 7 where short_name = 'mmcg';
update zone set expansion = 7 where short_name = 'gukh';
update zone set expansion = 7 where short_name = 'rujh';
update zone set expansion = 7 where short_name = 'takh';
update zone set expansion = 7 where short_name = 'mirh';
update zone set expansion = 7 where short_name = 'mmch';
update zone set expansion = 7 where short_name = 'ruji';
update zone set expansion = 7 where short_name = 'taki';
update zone set expansion = 7 where short_name = 'miri';
update zone set expansion = 7 where short_name = 'mmci';
update zone set expansion = 7 where short_name = 'rujj';
update zone set expansion = 7 where short_name = 'takj';
update zone set expansion = 7 where short_name = 'mirj';
update zone set expansion = 7 where short_name = 'mmcj';

update zone set expansion = 8 where short_name = 'abysmal';
update zone set expansion = 8 where short_name = 'natimbi';
update zone set expansion = 8 where short_name = 'qinimi';
update zone set expansion = 8 where short_name = 'riwwi';
update zone set expansion = 8 where short_name = 'barindu';
update zone set expansion = 8 where short_name = 'ferubi';
update zone set expansion = 8 where short_name = 'snpool';
update zone set expansion = 8 where short_name = 'snlair';
update zone set expansion = 8 where short_name = 'snplant';
update zone set expansion = 8 where short_name = 'sncrematory';
update zone set expansion = 8 where short_name = 'tipt';
update zone set expansion = 8 where short_name = 'vxed';
update zone set expansion = 8 where short_name = 'yxtta';
update zone set expansion = 8 where short_name = 'uqua';
update zone set expansion = 8 where short_name = 'kodtaz';
update zone set expansion = 8 where short_name = 'ikkinz';
update zone set expansion = 8 where short_name = 'qvic';
update zone set expansion = 8 where short_name = 'inktuta';
update zone set expansion = 8 where short_name = 'txevu';
update zone set expansion = 8 where short_name = 'tacvi';
update zone set expansion = 8 where short_name = 'qvicb';

update zone set expansion = 9 where short_name = 'wallofslaughter';
update zone set expansion = 9 where short_name = 'bloodfields';
update zone set expansion = 9 where short_name = 'draniksscar';
update zone set expansion = 9 where short_name = 'causeway';
update zone set expansion = 9 where short_name = 'chambersa';
update zone set expansion = 9 where short_name = 'chambersb';
update zone set expansion = 9 where short_name = 'chambersc';
update zone set expansion = 9 where short_name = 'chambersd';
update zone set expansion = 9 where short_name = 'chamberse';
update zone set expansion = 9 where short_name = 'chambersf';
update zone set expansion = 9 where short_name = 'provinggrounds';
update zone set expansion = 9 where short_name = 'anguish';
update zone set expansion = 9 where short_name = 'dranikhollowsa';
update zone set expansion = 9 where short_name = 'dranikhollowsb';
update zone set expansion = 9 where short_name = 'dranikhollowsc';
update zone set expansion = 9 where short_name = 'dranikcatacombsa';
update zone set expansion = 9 where short_name = 'dranikcatacombsb';
update zone set expansion = 9 where short_name = 'dranikcatacombsc';
update zone set expansion = 9 where short_name = 'draniksewersa';
update zone set expansion = 9 where short_name = 'draniksewersb';
update zone set expansion = 9 where short_name = 'draniksewersc';
update zone set expansion = 9 where short_name = 'riftseekers';
update zone set expansion = 9 where short_name = 'harbingers';
update zone set expansion = 9 where short_name = 'dranik';

update zone set expansion = 10 where short_name = 'broodlands';
update zone set expansion = 10 where short_name = 'stillmoona';
update zone set expansion = 10 where short_name = 'stillmoonb';
update zone set expansion = 10 where short_name = 'thundercrest';
update zone set expansion = 10 where short_name = 'delvea';
update zone set expansion = 10 where short_name = 'delveb';
update zone set expansion = 10 where short_name = 'thenest';
update zone set expansion = 10 where short_name = 'guildlobby';
update zone set expansion = 10 where short_name = 'guildhall';
update zone set expansion = 10 where short_name = 'barter';

update zone set expansion = 11 where short_name = 'illsalin';
update zone set expansion = 11 where short_name = 'illsalina';
update zone set expansion = 11 where short_name = 'illsalinb';
update zone set expansion = 11 where short_name = 'illsalinc';
update zone set expansion = 11 where short_name = 'dreadspire';
update zone set expansion = 11 where short_name = 'drachnidhive';
update zone set expansion = 11 where short_name = 'drachnidhivea';
update zone set expansion = 11 where short_name = 'drachnidhiveb';
update zone set expansion = 11 where short_name = 'drachnidhivec';
update zone set expansion = 11 where short_name = 'westkorlach';
update zone set expansion = 11 where short_name = 'westkorlacha';
update zone set expansion = 11 where short_name = 'westkorlachb';
update zone set expansion = 11 where short_name = 'westkorlachc';
update zone set expansion = 11 where short_name = 'eastkorlach';
update zone set expansion = 11 where short_name = 'eastkorlacha';
update zone set expansion = 11 where short_name = 'shadowspine';
update zone set expansion = 11 where short_name = 'corathus';
update zone set expansion = 11 where short_name = 'corathusa';
update zone set expansion = 11 where short_name = 'corathusb';
update zone set expansion = 11 where short_name = 'nektulosa';

update zone set expansion = 12 where short_name = 'arcstone';
update zone set expansion = 12 where short_name = 'relic';
update zone set expansion = 12 where short_name = 'skylance';
update zone set expansion = 12 where short_name = 'devastation';
update zone set expansion = 12 where short_name = 'devastationa';
update zone set expansion = 12 where short_name = 'rage';
update zone set expansion = 12 where short_name = 'ragea';
update zone set expansion = 12 where short_name = 'takishruins';
update zone set expansion = 12 where short_name = 'takishruinsa';
update zone set expansion = 12 where short_name = 'elddar';
update zone set expansion = 12 where short_name = 'elddara';
update zone set expansion = 12 where short_name = 'theater';
update zone set expansion = 12 where short_name = 'theatera';
update zone set expansion = 12 where short_name = 'freeporteast';
update zone set expansion = 12 where short_name = 'freeportwest';
update zone set expansion = 12 where short_name = 'freeportsewers';
update zone set expansion = 12 where short_name = 'freeportacademy';
update zone set expansion = 12 where short_name = 'freeporttemple';
update zone set expansion = 12 where short_name = 'freeportmilitia';
update zone set expansion = 12 where short_name = 'freeportarena';
update zone set expansion = 12 where short_name = 'freeportcityhall';
update zone set expansion = 12 where short_name = 'freeporttheater';
update zone set expansion = 12 where short_name = 'freeporthall';
update zone set expansion = 12 where short_name = 'northro';
update zone set expansion = 12 where short_name = 'southro';

update zone set expansion = 13 where short_name = 'crescent';
update zone set expansion = 13 where short_name = 'moors';
update zone set expansion = 13 where short_name = 'stonehive';
update zone set expansion = 13 where short_name = 'mesa';
update zone set expansion = 13 where short_name = 'roost';
update zone set expansion = 13 where short_name = 'steppes';
update zone set expansion = 13 where short_name = 'icefall';
update zone set expansion = 13 where short_name = 'valdeholm';
update zone set expansion = 13 where short_name = 'frostcrypt';
update zone set expansion = 13 where short_name = 'sunderock';
update zone set expansion = 13 where short_name = 'vergalid';
update zone set expansion = 13 where short_name = 'direwind';
update zone set expansion = 13 where short_name = 'ashengate';
update zone set expansion = 13 where short_name = 'highpasshold';
update zone set expansion = 13 where short_name = 'commonlands';
update zone set expansion = 13 where short_name = 'oceanoftears';
update zone set expansion = 13 where short_name = 'innothuleb';
update zone set expansion = 13 where short_name = 'toxxulia';
update zone set expansion = 13 where short_name = 'mistythicket';

update zone set expansion = 14 where short_name = 'kattacastrum';
update zone set expansion = 14 where short_name = 'thalassius';
update zone set expansion = 14 where short_name = 'atiiki';
update zone set expansion = 14 where short_name = 'zhisza';
update zone set expansion = 14 where short_name = 'silyssar';
update zone set expansion = 14 where short_name = 'solteris';
update zone set expansion = 14 where short_name = 'barren';
update zone set expansion = 14 where short_name = 'buriedsea';
update zone set expansion = 14 where short_name = 'jardelshook';
update zone set expansion = 14 where short_name = 'monkeyrock';
update zone set expansion = 14 where short_name = 'suncrest';
update zone set expansion = 14 where short_name = 'deadbone';
update zone set expansion = 14 where short_name = 'blacksail';
update zone set expansion = 14 where short_name = 'maidensgrave';
update zone set expansion = 14 where short_name = 'redfeather';
update zone set expansion = 14 where short_name = 'shipmvp';
update zone set expansion = 14 where short_name = 'shipmvu';
update zone set expansion = 14 where short_name = 'shippvu';
update zone set expansion = 14 where short_name = 'shipuvu';
update zone set expansion = 14 where short_name = 'shipmvm';

update zone set expansion = 15 where short_name = 'mechanotus';
update zone set expansion = 15 where short_name = 'mansion';
update zone set expansion = 15 where short_name = 'steamfactory';
update zone set expansion = 15 where short_name = 'shipworkshop';
update zone set expansion = 15 where short_name = 'gyrospireb';
update zone set expansion = 15 where short_name = 'gyrospirez';
update zone set expansion = 15 where short_name = 'dragonscale';
update zone set expansion = 15 where short_name = 'lopingplains';
update zone set expansion = 15 where short_name = 'hillsofshade';
update zone set expansion = 15 where short_name = 'bloodmoon';
update zone set expansion = 15 where short_name = 'crystallos';
update zone set expansion = 15 where short_name = 'guardian';
update zone set expansion = 15 where short_name = 'steamfontmts';
update zone set expansion = 15 where short_name = 'cryptofshade';
update zone set expansion = 15 where short_name = 'dragonscaleb';

update zone set expansion = 16 where short_name = 'oldfieldofbone';
update zone set expansion = 16 where short_name = 'oldkaesoraa';
update zone set expansion = 16 where short_name = 'oldkaesorab';
update zone set expansion = 16 where short_name = 'oldkurn';
update zone set expansion = 16 where short_name = 'oldkithicor';
update zone set expansion = 16 where short_name = 'oldcommons';
update zone set expansion = 16 where short_name = 'oldhighpass';
update zone set expansion = 16 where short_name = 'thevoida';
update zone set expansion = 16 where short_name = 'thevoidb';
update zone set expansion = 16 where short_name = 'thevoidc';
update zone set expansion = 16 where short_name = 'thevoidd';
update zone set expansion = 16 where short_name = 'thevoide';
update zone set expansion = 16 where short_name = 'thevoidf';
update zone set expansion = 16 where short_name = 'thevoidg';
update zone set expansion = 16 where short_name = 'oceangreenhills';
update zone set expansion = 16 where short_name = 'oceangreenvillag';
update zone set expansion = 16 where short_name = 'oldblackburrow';
update zone set expansion = 16 where short_name = 'bertoxtemple';
update zone set expansion = 16 where short_name = 'discord';
update zone set expansion = 16 where short_name = 'discordtower';
update zone set expansion = 16 where short_name = 'oldbloodfield';
update zone set expansion = 16 where short_name = 'precipiceofwar';
update zone set expansion = 16 where short_name = 'olddranik';
update zone set expansion = 16 where short_name = 'toskirakk';
update zone set expansion = 16 where short_name = 'korascian';
update zone set expansion = 16 where short_name = 'rathechamber';

update zone set expansion = 99 where short_name = 'tutorial';
update zone set expansion = 99 where short_name = 'load';
update zone set expansion = 99 where short_name = 'load2';
update zone set expansion = 99 where short_name = 'clz';
update zone set expansion = 99 where short_name = 'apprentice';
update zone set expansion = 99 where short_name = 'arttest';
update zone set expansion = 99 where short_name = 'aviak';
update zone set expansion = 99 where short_name = 'befallenb';
update zone set expansion = 99 where short_name = 'erudsxing2';
update zone set expansion = 99 where short_name = 'highpasskeep';
update zone set expansion = 99 where short_name = 'kithforest';
update zone set expansion = 99 where short_name = 'nektropos';
update zone set expansion = 99 where short_name = 'neriakd';

[rudeboy88]

First off just wanted to say sorry for bumping an old thread with a newb question, but..

I have put my box back up and had been considering for a while the idea of adding an expansion column to my db; would this cause any issues ingame, or is there a particular spot I should put it?

*edit* I had considered doing this with both npcs and items

Thanks in advance

*edit edit* figured it out, re-reading Kingly_Krab's post above answered all the questions I'd have about this, thanks for this post