Items by Era

[provocating]

Is there any way to filter items by Era/expansion? I am thinking not, but I was wondering.

[Kingly_Krab]

I assume you could filter using JOINs on the loot and zone tables to pull only stuff from certain expansions based on the expansion column in the zone table. Keep in mind, this query is huge, so it takes forever to run, especially since it's pulling based on EVERY zone in an expansion.

SELECT DISTINCT i.* FROM items i
INNER JOIN lootdrop_entries lde ON i.`id` = lde.`item_id`
INNER JOIN loottable_entries lte ON lde.`lootdrop_id` = lte.`lootdrop_id`
INNER JOIN loottable lt ON lt.`id` = lte.`loottable_id`
INNER JOIN npc_types n ON n.`loottable_id` = lt.`id`
INNER JOIN spawnentry se ON n.`id` = se.`npcID`
INNER JOIN spawn2 s2 ON se.`spawngroupID` = s2.`spawngroupID`
INNER JOIN zone z ON s2.`zone` = z.`short_name`
WHERE z.`expansion` = '#'
ORDER BY lde.`item_id` ASC LIMIT 1000;

[Shendare]

I would imagine item ID ranges would more or less line up with expansions, so you may be able to use a query like that to figure out the lowest and highest item id for each expansion, which would make for much faster queries once you've got the list.

[provocating]

I might go with Kingly Crabs suggestion but I even think that would not work. Since some items are quest only summoned, you could not get anything accurate that way. I may post something on PEQ and see if those guys know. I could definitely add an expansion column to my own database and keep track of it, if I could find an accurate way of doing this.

[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

[Kingly_Krab]

Haha, glad to be of assistance. I'd like to check out your server if it's open to the public.