Classic DB

[Digitala]

Hey guys!

Been a while but back at it again!

My question is about classic database.
Me and a friend are starting a new server and we want a classic/trilogy database to work with.
I know P99 has the only legit classic DB but beside that.
What should be go for? PEQ or AX?
Looking for hate 1.0 fear 1.0 and so on.
Thx!

[Digitala]

Think i posted in the wrong thread. Sorry!

[Kingly_Krab]

Some stuff may have to be done on your own, meaning your best bet is to read this (http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide&frm=Main) (assuming you're on Windows) and learn how to set up the server. People aren't handing out Classic databases, sadly enough, so you may have to do a lot of what you're wanting to do on your own, as the database from the PEQ Daily Dump isn't Classic only. I hope I helped some.

[Digitala]

Thx!
Yeah i am aware of the work involved.
Just trying to limit the amount by starting with the best database for it.
I guess PEQ is the way to go anyway you look at it =P

[Kingly_Krab]

Yeah, the database is pretty nice. You'll have to source all the files from 2014_07_10_npc_spells.sql up when you grab the source, as the current database hasn't been updated it a while, unless this has been changed in the last day or so.

[Tyen05]

I see you made some posts in 2011 about the same thing.

Anyway, the "conundrum" is that the eqemu databases have changed a lot over time. For example tables/columns have been added/removed/merged/etc. So stock emu server source doesnt play nice with older versions of a database.

So people who have done tons of database work in the past to "classicize" a database most likely wont be compatible with the new source therefore people default to the "out of the box" peq database and spend 3-4 years removing content out of the database that they dont want.

Basically people dont hand out classic DBs because things change so often in the server source on how it handles the data tossed around in the database.

Going forward, peq could make a column to designate expansions in certain tables to make it easier to restrict expansion related content, but I have no idea on their motivation to do so. Its kind of a big job in itself but its basically offloaded to whoever runs their own server and what content they want to allow/disallow.

[Kingly_Krab]

There's actually a SQL file that comes with the PEQ Database Editor that adds an expansion column to the zone table which would help you to keep track of what zones should be locked and what zones shouldn't be, SQL below. Also, expansion 99 indicates non-player and/or GM zones.
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';

[Digitala]

Hey Tyen05!

Didn't you work with the vztz database a while back?
Maybe i am thinking of someone else.

[Tyen05]

Yes, Digitala, I'm running it right now just for the sole purpose of the Classic Database, but the server source which you have to run with is god awful and I wouldn't recommend running it. The only reason I'm not running stock EQEmu is because Id rather be working on my eqbrowser client development than classicizing an entire server zone-by-zone.

It has some pretty devastating Zone crashing problems all over, as one example. Daxum posted the database/source, I linked it below. I got my copy from Searyx though, under the table.


@KinglyKrab, it is nice that you can lock certain zones by expansion, but that is only one table out of many that need to be "classicized." Spawns for example.

Also, unrelated to the database, but many stock PEQ Quests need to be looked over and edited to have many things cut out that allow players to obtain later expansion items which is extremely time consuming doing it zone-by-zone. (If you are going for classic and cutting off your server by certain expansions)


EDIT: here is the source/database for VZTZ http://www.eqemulator.org/forums/showthread.php?t=29168


So you pretty much have an uphill road when it comes to running a classic server. Either you can run shitty source and not have to deal with spending years getting a classic database & quest scripts playable, or you can run the most recent and updated source, while spending many years going zone-by-zone making it classically playable in the databse and also in the quest scripts.

[Digitala]

So you pretty much have an uphill road when it comes to running a classic server. Either you can run shitty source and not have to deal with spending years getting a classic database & quest scripts playable, or you can run the most recent and updated source, while spending many years going zone-by-zone making it classically playable in the databse and also in the quest scripts.

Ill go with option number 2.

The idea that is behind the server we are gonna run with is not "classic" 100%.
So it doesn't need to be pure classic. But at the same time we dont want it to be the new EQ.
I think with the help of that PEQ editor tool, the overview and editing of the database will be doable and not too time consuming.
Thx for the help and input ;)

Also have a question about the new zones in classic. Like Lavastorm and Nek Forest. Are there classic spawn sets available in PEQ for does zones?