Discord: eqemu/project-peq-expansions

[rudeboy88]

Hey all,

After being referred to the project-peq-expansions channel I wanted to make a post to turn over any progression-based research that I had from past attempts/projects at progression. Anyone can use this post if you have snippets you'd like to add, but I figured it might help in the name of consolidating efforts if we had somewhere to compliment the Discord's dialogue if needed.

I acknowledge that the point of project-peq-expansions is to provide a snapshot per each expansion, and what is posted here is currently in my old format (hundred for xpac, last two digits for patch), but I'd be happy to help convert any of this to a format that'd fit into the expansion snapshots (ex. using spawn ids instead of npc id, etc.)

With that said, here's a basic sql doc that mostly documents the eras that certain town NPCs were added, as well as stopping defiant from dropping and PoK guard race/class reverts (pathing and spawn points for those aren't in here currently.) I have a few more town's worth of NPCs on paper and will add those here later.

/* Zones */

alter table zone add `startera` int(11) NOT NULL default 0;
alter table zone add `endera` int(11) NOT NULL default 0;

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

update zone set startera = 106 where short_name = 'soltemple';
update zone set startera = 111 where short_name = 'airplane';

update zone set startera = 100 where short_name = 'fearplane';
update zone set startera = 100 where short_name = 'hateplane';
                
update zone set startera = 1000 where short_name = 'fhalls';
update zone set startera = 1000 where short_name = 'tutoriala';
update zone set startera = 1000 where short_name = 'tutorialb';
update zone set startera = 428 where short_name = 'jaggedpine';
update zone set startera = 800 where short_name = 'nedaria';
update zone set startera = 1000 where short_name = 'arena2';
update zone set startera = 809 where short_name = 'shadowrest';
                
update zone set startera = 200 where short_name = 'fieldofbone';
update zone set startera = 200 where short_name = 'warslikswood';
update zone set startera = 200 where short_name = 'droga';
update zone set startera = 200 where short_name = 'cabwest';
update zone set startera = 200 where short_name = 'swampofnohope';
update zone set startera = 200 where short_name = 'firiona';
update zone set startera = 200 where short_name = 'lakeofillomen';
update zone set startera = 200 where short_name = 'dreadlands';
update zone set startera = 200 where short_name = 'burningwood';
update zone set startera = 200 where short_name = 'kaesora';
update zone set startera = 200 where short_name = 'sebilis';
update zone set startera = 200 where short_name = 'citymist';
update zone set startera = 200 where short_name = 'skyfire';
update zone set startera = 200 where short_name = 'frontiermtns';
update zone set startera = 200 where short_name = 'overthere';
update zone set startera = 200 where short_name = 'emeraldjungle';
update zone set startera = 200 where short_name = 'trakanon';
update zone set startera = 200 where short_name = 'timorous';
update zone set startera = 200 where short_name = 'kurn';
update zone set startera = 200 where short_name = 'erudsxing';
update zone set startera = 200 where short_name = 'karnor';
update zone set startera = 200 where short_name = 'chardok';
update zone set startera = 200 where short_name = 'dalnir';
update zone set startera = 200 where short_name = 'charasis';
update zone set startera = 200 where short_name = 'cabeast';
update zone set startera = 200 where short_name = 'nurga';
update zone set startera = 200 where short_name = 'veeshan';
                
update zone set startera = 300 where short_name = 'iceclad';
update zone set startera = 300 where short_name = 'frozenshadow';
update zone set startera = 300 where short_name = 'velketor';
update zone set startera = 300 where short_name = 'kael';
update zone set startera = 300 where short_name = 'skyshrine';
update zone set startera = 300 where short_name = 'thurgadina';
update zone set startera = 300 where short_name = 'eastwastes';
update zone set startera = 300 where short_name = 'cobaltscar';
update zone set startera = 300 where short_name = 'greatdivide';
update zone set startera = 300 where short_name = 'wakening';
update zone set startera = 300 where short_name = 'westwastes';
update zone set startera = 300 where short_name = 'crystal';
update zone set startera = 300 where short_name = 'necropolis';
update zone set startera = 300 where short_name = 'templeveeshan';
update zone set startera = 300 where short_name = 'sirens';
update zone set startera = 300 where short_name = 'mischiefplane';
update zone set startera = 300 where short_name = 'growthplane';
update zone set startera = 300 where short_name = 'sleeper';
update zone set startera = 300 where short_name = 'thurgadinb';
update zone set startera = 314 where short_name = 'warrens';
update zone set startera = 331 where short_name = 'stonebrunt';
                
update zone set startera = 400 where short_name = 'shadowhaven';
update zone set startera = 400 where short_name = 'bazaar';
update zone set startera = 400 where short_name = 'nexus';
update zone set startera = 400 where short_name = 'echo';
update zone set startera = 400 where short_name = 'acrylia';
update zone set startera = 400 where short_name = 'sharvahl';
update zone set startera = 400 where short_name = 'paludal';
update zone set startera = 400 where short_name = 'fungusgrove';
update zone set startera = 400 where short_name = 'vexthal';
update zone set startera = 400 where short_name = 'sseru';
update zone set startera = 400 where short_name = 'katta';
update zone set startera = 400 where short_name = 'netherbian';
update zone set startera = 400 where short_name = 'ssratemple';
update zone set startera = 400 where short_name = 'griegsend';
update zone set startera = 400 where short_name = 'thedeep';
update zone set startera = 400 where short_name = 'shadeweaver';
update zone set startera = 400 where short_name = 'hollowshade';
update zone set startera = 400 where short_name = 'grimling';
update zone set startera = 400 where short_name = 'mseru';
update zone set startera = 400 where short_name = 'letalis';
update zone set startera = 400 where short_name = 'twilight';
update zone set startera = 400 where short_name = 'thegrey';
update zone set startera = 400 where short_name = 'tenebrous';
update zone set startera = 400 where short_name = 'maiden';
update zone set startera = 400 where short_name = 'dawnshroud';
update zone set startera = 400 where short_name = 'scarlet';
update zone set startera = 400 where short_name = 'umbral';
update zone set startera = 400 where short_name = 'akheva';
                
update zone set startera = 500 where short_name = 'codecay';
update zone set startera = 500 where short_name = 'pojustice';
update zone set startera = 500 where short_name = 'poknowledge';
update zone set startera = 500 where short_name = 'potranquility';
update zone set startera = 500 where short_name = 'ponightmare';
update zone set startera = 500 where short_name = 'podisease';
update zone set startera = 500 where short_name = 'poinnovation';
update zone set startera = 500 where short_name = 'potorment';
update zone set startera = 500 where short_name = 'povalor';
update zone set startera = 500 where short_name = 'bothunder';
update zone set startera = 500 where short_name = 'postorms';
update zone set startera = 500 where short_name = 'hohonora';
update zone set startera = 500 where short_name = 'solrotower';
update zone set startera = 500 where short_name = 'powar';
update zone set startera = 500 where short_name = 'potactics';
update zone set startera = 500 where short_name = 'poair';
update zone set startera = 500 where short_name = 'powater';
update zone set startera = 500 where short_name = 'pofire';
update zone set startera = 500 where short_name = 'poeartha';
update zone set startera = 500 where short_name = 'potimea';
update zone set startera = 500 where short_name = 'hohonorb';
update zone set startera = 500 where short_name = 'nightmareb';
update zone set startera = 500 where short_name = 'poearthb';
update zone set startera = 500 where short_name = 'potimeb';
                
update zone set startera = 600 where short_name = 'gunthak';
update zone set startera = 600 where short_name = 'dulak';
update zone set startera = 600 where short_name = 'torgiran';
update zone set startera = 600 where short_name = 'nadox';
update zone set startera = 600 where short_name = 'hatesfury';
update zone set startera = 624 where short_name = 'hateplaneb';
update zone set startera = 630 where short_name = 'veksar';
update zone set startera = 642 where short_name = 'chardokb';
update zone set startera = 648 where short_name = 'soldungc';
                
update zone set startera = 700 where short_name = 'guka';
update zone set startera = 700 where short_name = 'ruja';
update zone set startera = 700 where short_name = 'taka';
update zone set startera = 700 where short_name = 'mira';
update zone set startera = 700 where short_name = 'mmca';
update zone set startera = 700 where short_name = 'gukb';
update zone set startera = 700 where short_name = 'rujb';
update zone set startera = 700 where short_name = 'takb';
update zone set startera = 700 where short_name = 'mirb';
update zone set startera = 700 where short_name = 'mmcb';
update zone set startera = 700 where short_name = 'gukc';
update zone set startera = 700 where short_name = 'rujc';
update zone set startera = 700 where short_name = 'takc';
update zone set startera = 700 where short_name = 'mirc';
update zone set startera = 700 where short_name = 'mmcc';
update zone set startera = 700 where short_name = 'gukd';
update zone set startera = 700 where short_name = 'rujd';
update zone set startera = 700 where short_name = 'takd';
update zone set startera = 700 where short_name = 'mird';
update zone set startera = 700 where short_name = 'mmcd';
update zone set startera = 700 where short_name = 'guke';
update zone set startera = 700 where short_name = 'ruje';
update zone set startera = 700 where short_name = 'take';
update zone set startera = 700 where short_name = 'mire';
update zone set startera = 700 where short_name = 'mmce';
update zone set startera = 700 where short_name = 'gukf';
update zone set startera = 700 where short_name = 'rujf';
update zone set startera = 700 where short_name = 'takf';
update zone set startera = 700 where short_name = 'mirf';
update zone set startera = 700 where short_name = 'mmcf';
update zone set startera = 700 where short_name = 'gukg';
update zone set startera = 700 where short_name = 'rujg';
update zone set startera = 700 where short_name = 'takg';
update zone set startera = 700 where short_name = 'mirg';
update zone set startera = 700 where short_name = 'mmcg';
update zone set startera = 700 where short_name = 'gukh';
update zone set startera = 700 where short_name = 'rujh';
update zone set startera = 700 where short_name = 'takh';
update zone set startera = 700 where short_name = 'mirh';
update zone set startera = 700 where short_name = 'mmch';
update zone set startera = 700 where short_name = 'ruji';
update zone set startera = 700 where short_name = 'taki';
update zone set startera = 700 where short_name = 'miri';
update zone set startera = 700 where short_name = 'mmci';
update zone set startera = 700 where short_name = 'rujj';
update zone set startera = 700 where short_name = 'takj';
update zone set startera = 700 where short_name = 'mirj';
update zone set startera = 700 where short_name = 'mmcj';
                
update zone set startera = 800 where short_name = 'abysmal';
update zone set startera = 800 where short_name = 'natimbi';
update zone set startera = 800 where short_name = 'qinimi';
update zone set startera = 800 where short_name = 'riwwi';
update zone set startera = 800 where short_name = 'barindu';
update zone set startera = 800 where short_name = 'ferubi';
update zone set startera = 800 where short_name = 'snpool';
update zone set startera = 800 where short_name = 'snlair';
update zone set startera = 800 where short_name = 'snplant';
update zone set startera = 800 where short_name = 'sncrematory';
update zone set startera = 800 where short_name = 'tipt';
update zone set startera = 800 where short_name = 'vxed';
update zone set startera = 800 where short_name = 'yxtta';
update zone set startera = 800 where short_name = 'uqua';
update zone set startera = 800 where short_name = 'kodtaz';
update zone set startera = 800 where short_name = 'ikkinz';
update zone set startera = 800 where short_name = 'qvic';
update zone set startera = 800 where short_name = 'inktuta';
update zone set startera = 800 where short_name = 'txevu';
update zone set startera = 800 where short_name = 'tacvi';
update zone set startera = 800 where short_name = 'qvicb';
                
update zone set startera = 900 where short_name = 'wallofslaughter';
update zone set startera = 900 where short_name = 'bloodfields';
update zone set startera = 900 where short_name = 'draniksscar';
update zone set startera = 900 where short_name = 'causeway';
update zone set startera = 900 where short_name = 'chambersa';
update zone set startera = 900 where short_name = 'chambersb';
update zone set startera = 900 where short_name = 'chambersc';
update zone set startera = 900 where short_name = 'chambersd';
update zone set startera = 900 where short_name = 'chamberse';
update zone set startera = 900 where short_name = 'chambersf';
update zone set startera = 900 where short_name = 'provinggrounds';
update zone set startera = 900 where short_name = 'anguish';
update zone set startera = 900 where short_name = 'dranikhollowsa';
update zone set startera = 900 where short_name = 'dranikhollowsb';
update zone set startera = 900 where short_name = 'dranikhollowsc';
update zone set startera = 900 where short_name = 'dranikcatacombsa';
update zone set startera = 900 where short_name = 'dranikcatacombsb';
update zone set startera = 900 where short_name = 'dranikcatacombsc';
update zone set startera = 900 where short_name = 'draniksewersa';
update zone set startera = 900 where short_name = 'draniksewersb';
update zone set startera = 900 where short_name = 'draniksewersc';
update zone set startera = 900 where short_name = 'riftseekers';
update zone set startera = 900 where short_name = 'harbingers';
update zone set startera = 900 where short_name = 'dranik';
                
update zone set startera = 1000 where short_name = 'broodlands';
update zone set startera = 1000 where short_name = 'stillmoona';
update zone set startera = 1000 where short_name = 'stillmoonb';
update zone set startera = 1000 where short_name = 'thundercrest';
update zone set startera = 1000 where short_name = 'delvea';
update zone set startera = 1000 where short_name = 'delveb';
update zone set startera = 1000 where short_name = 'thenest';
update zone set startera = 1000 where short_name = 'guildlobby';
update zone set startera = 1000 where short_name = 'guildhall';
update zone set startera = 1000 where short_name = 'barter';
                
update zone set startera = 1100 where short_name = 'illsalin';
update zone set startera = 1100 where short_name = 'illsalina';
update zone set startera = 1100 where short_name = 'illsalinb';
update zone set startera = 1100 where short_name = 'illsalinc';
update zone set startera = 1100 where short_name = 'dreadspire';
update zone set startera = 1100 where short_name = 'drachnidhive';
update zone set startera = 1100 where short_name = 'drachnidhivea';
update zone set startera = 1100 where short_name = 'drachnidhiveb';
update zone set startera = 1100 where short_name = 'drachnidhivec';
update zone set startera = 1100 where short_name = 'westkorlach';
update zone set startera = 1100 where short_name = 'westkorlacha';
update zone set startera = 1100 where short_name = 'westkorlachb';
update zone set startera = 1100 where short_name = 'westkorlachc';
update zone set startera = 1100 where short_name = 'eastkorlach';
update zone set startera = 1100 where short_name = 'eastkorlacha';
update zone set startera = 1100 where short_name = 'shadowspine';
update zone set startera = 1100 where short_name = 'corathus';
update zone set startera = 1100 where short_name = 'corathusa';
update zone set startera = 1100 where short_name = 'corathusb';
update zone set startera = 1100 where short_name = 'nektulosa';
                
update zone set startera = 1200 where short_name = 'arcstone';
update zone set startera = 1200 where short_name = 'relic';
update zone set startera = 1200 where short_name = 'skylance';
update zone set startera = 1200 where short_name = 'devastation';
update zone set startera = 1200 where short_name = 'devastationa';
update zone set startera = 1200 where short_name = 'rage';
update zone set startera = 1200 where short_name = 'ragea';
update zone set startera = 1200 where short_name = 'takishruins';
update zone set startera = 1200 where short_name = 'takishruinsa';
update zone set startera = 1200 where short_name = 'elddar';
update zone set startera = 1200 where short_name = 'elddara';
update zone set startera = 1200 where short_name = 'theater';
update zone set startera = 1200 where short_name = 'theatera';
update zone set startera = 1200 where short_name = 'freeporteast';
update zone set startera = 1200 where short_name = 'freeportwest';
update zone set startera = 1200 where short_name = 'freeportsewers';
update zone set startera = 1200 where short_name = 'freeportacademy';
update zone set startera = 1200 where short_name = 'freeporttemple';
update zone set startera = 1200 where short_name = 'freeportmilitia';
update zone set startera = 1200 where short_name = 'freeportarena';
update zone set startera = 1200 where short_name = 'freeportcityhall';
update zone set startera = 1200 where short_name = 'freeporttheater';
update zone set startera = 1200 where short_name = 'freeporthall';
update zone set startera = 1200 where short_name = 'northro';
update zone set startera = 1200 where short_name = 'southro';
                
update zone set startera = 1300 where short_name = 'crescent';
update zone set startera = 1300 where short_name = 'moors';
update zone set startera = 1300 where short_name = 'stonehive';
update zone set startera = 1300 where short_name = 'mesa';
update zone set startera = 1300 where short_name = 'roost';
update zone set startera = 1300 where short_name = 'steppes';
update zone set startera = 1300 where short_name = 'icefall';
update zone set startera = 1300 where short_name = 'valdeholm';
update zone set startera = 1300 where short_name = 'frostcrypt';
update zone set startera = 1300 where short_name = 'sunderock';
update zone set startera = 1300 where short_name = 'vergalid';
update zone set startera = 1300 where short_name = 'direwind';
update zone set startera = 1300 where short_name = 'ashengate';
update zone set startera = 1300 where short_name = 'highpasshold';
update zone set startera = 1300 where short_name = 'commonlands';
update zone set startera = 1300 where short_name = 'oceanoftears';
update zone set startera = 1300 where short_name = 'innothuleb';
update zone set startera = 1300 where short_name = 'toxxulia';
update zone set startera = 1300 where short_name = 'mistythicket';
                
update zone set startera = 1400 where short_name = 'kattacastrum';
update zone set startera = 1400 where short_name = 'thalassius';
update zone set startera = 1400 where short_name = 'atiiki';
update zone set startera = 1400 where short_name = 'zhisza';
update zone set startera = 1400 where short_name = 'silyssar';
update zone set startera = 1400 where short_name = 'solteris';
update zone set startera = 1400 where short_name = 'barren';
update zone set startera = 1400 where short_name = 'buriedsea';
update zone set startera = 1400 where short_name = 'jardelshook';
update zone set startera = 1400 where short_name = 'monkeyrock';
update zone set startera = 1400 where short_name = 'suncrest';
update zone set startera = 1400 where short_name = 'deadbone';
update zone set startera = 1400 where short_name = 'blacksail';
update zone set startera = 1400 where short_name = 'maidensgrave';
update zone set startera = 1400 where short_name = 'redfeather';
update zone set startera = 1400 where short_name = 'shipmvp';
update zone set startera = 1400 where short_name = 'shipmvu';
update zone set startera = 1400 where short_name = 'shippvu';
update zone set startera = 1400 where short_name = 'shipuvu';
update zone set startera = 1400 where short_name = 'shipmvm';
                
update zone set startera = 1500 where short_name = 'mechanotus';
update zone set startera = 1500 where short_name = 'mansion';
update zone set startera = 1500 where short_name = 'steamfactory';
update zone set startera = 1500 where short_name = 'shipworkshop';
update zone set startera = 1500 where short_name = 'gyrospireb';
update zone set startera = 1500 where short_name = 'gyrospirez';
update zone set startera = 1500 where short_name = 'dragonscale';
update zone set startera = 1500 where short_name = 'lopingplains';
update zone set startera = 1500 where short_name = 'hillsofshade';
update zone set startera = 1500 where short_name = 'bloodmoon';
update zone set startera = 1500 where short_name = 'crystallos';
update zone set startera = 1500 where short_name = 'guardian';
update zone set startera = 1500 where short_name = 'steamfontmts';
update zone set startera = 1500 where short_name = 'cryptofshade';
update zone set startera = 1500 where short_name = 'dragonscaleb';
                
update zone set startera = 1600 where short_name = 'oldfieldofbone';
update zone set startera = 1600 where short_name = 'oldkaesoraa';
update zone set startera = 1600 where short_name = 'oldkaesorab';
update zone set startera = 1600 where short_name = 'oldkurn';
update zone set startera = 1600 where short_name = 'oldkithicor';
update zone set startera = 1600 where short_name = 'oldcommons';
update zone set startera = 1600 where short_name = 'oldhighpass';
update zone set startera = 1600 where short_name = 'thevoida';
update zone set startera = 1600 where short_name = 'thevoidb';
update zone set startera = 1600 where short_name = 'thevoidc';
update zone set startera = 1600 where short_name = 'thevoidd';
update zone set startera = 1600 where short_name = 'thevoide';
update zone set startera = 1600 where short_name = 'thevoidf';
update zone set startera = 1600 where short_name = 'thevoidg';
update zone set startera = 1600 where short_name = 'oceangreenhills';
update zone set startera = 1600 where short_name = 'oceangreenvillag';
update zone set startera = 1600 where short_name = 'oldblackburrow';
update zone set startera = 1600 where short_name = 'bertoxtemple';
update zone set startera = 1600 where short_name = 'discord';
update zone set startera = 1600 where short_name = 'discordtower';
update zone set startera = 1600 where short_name = 'oldbloodfield';
update zone set startera = 1600 where short_name = 'precipiceofwar';
update zone set startera = 1600 where short_name = 'olddranik';
update zone set startera = 1600 where short_name = 'toskirakk';
update zone set startera = 1600 where short_name = 'korascian';
update zone set startera = 1600 where short_name = 'rathechamber';
                
update zone set startera = 9900 where short_name = 'tutorial';
update zone set startera = 9900 where short_name = 'load';
update zone set startera = 9900 where short_name = 'load2';
update zone set startera = 9900 where short_name = 'clz';
update zone set startera = 9900 where short_name = 'apprentice';
update zone set startera = 9900 where short_name = 'arttest';
update zone set startera = 9900 where short_name = 'aviak';
update zone set startera = 9900 where short_name = 'befallenb';
update zone set startera = 9900 where short_name = 'erudsxing2';
update zone set startera = 9900 where short_name = 'highpasskeep';
update zone set startera = 9900 where short_name = 'kithforest';
update zone set startera = 9900 where short_name = 'nektropos';
update zone set startera = 9900 where short_name = 'neriakd';

alter table npc_types add `startera` int(11) NOT NULL default 0;
alter table npc_types add `endera` int(11) NOT NULL default 0;

/* Generalized NPC DB Blocking */

update npc_types set startera = 300 where id >= 110000 and id <= 129096;
update npc_types set startera = 100 where id >= 1000 and id <= 76062;
update npc_types set startera = 200 where id >= 78000 and id <= 108517;
update npc_types set startera = 608 where id >= 109000 and id <= 109904;
update npc_types set startera = 300 where id >= 110000 and id <= 129096;
update npc_types set startera = 400 where id >= 150000 and id <= 179183;
update npc_types set startera = 400 where id >= 181000 and id <= 181218;
update npc_types set startera = 808 where id >= 182000 and id <= 182140;
update npc_types set startera = 608 where id >= 186000 and id <= 186165;
update npc_types set startera = 1008 where id >= 188000 and id <= 189481;
update npc_types set startera = 500 where id >= 200000 and id <= 223201;
update npc_types set startera = 600 where id >= 224000 and id <= 228122;
update npc_types set startera = 817 where id >= 224000 and id <= 228122;
update npc_types set startera = 700 where id >= 229000 and id <= 276416;
update npc_types set startera = 614 where id >= 277000 and id <= 277121;
update npc_types set startera = 618 where id >= 278000 and id <= 278129;
update npc_types set startera = 800 where id >= 279000 and id <= 298057;
update npc_types set startera = 900 where id >= 300000 and id <= 336226;
update npc_types set startera = 1000 where id >= 337000 and id <= 343096;
update npc_types set startera = 1001 where id >= 344000 and id <= 344014;
update npc_types set startera = 1001 where id >= 345000 and id <= 345006;
update npc_types set startera = 1100 where id >= 347000 and id <= 369099;
update npc_types set startera = 1200 where id >= 370000 and id <= 393157;
update npc_types set startera = 1300 where id >= 394001 and id <= 418113;
update npc_types set startera = 1400 where id >= 422000 and id <= 448194;

/* Begin NPC Specifics: Early npc_type Numbers and LoY Rat Exterminator Quest NPCs */

update npc_types set startera = 400 where id >= 515 and id <= 535;
update npc_types set startera = 100 where id = 541;
update npc_types set startera = 300 where id >= 542 and id <= 543;
update npc_types set startera = 800 where id = 544;
update npc_types set startera = 100 where id >= 545 and id <= 548;
update npc_types set startera = 200 where id = 549;
update npc_types set startera = 500 where id = 550;
update npc_types set startera = 900 where id = 551;
update npc_types set startera = 100 where id >= 552 and id <= 560;
update npc_types set startera = 900 where id = 556;
update npc_types set startera = 100 where id >= 567 and id <= 577;
update npc_types set startera = 200 where id = 578;
update npc_types set startera = 200 where id = 579;
update npc_types set startera = 500 where id = 580;
update npc_types set startera = 900 where id = 581;
update npc_types set startera = 100 where id >= 582 and id <= 592;
update npc_types set startera = 200 where id = 593;
update npc_types set startera = 200 where id = 594;
update npc_types set startera = 500 where id = 595;
update npc_types set startera = 900 where id = 596;
update npc_types set startera = 200 where id = 597;
update npc_types set startera = 100 where id >= 599 and id <= 609;
update npc_types set startera = 200 where id = 610;
update npc_types set startera = 200 where id = 611;
update npc_types set startera = 500 where id = 612;
update npc_types set startera = 900 where id = 613;
update npc_types set startera = 100 where id >= 614 and id <= 625;
update npc_types set startera = 200 where id >= 626 and id <= 628;
update npc_types set startera = 500 where id >= 629 and id <= 630;
update npc_types set startera = 900 where id >= 632 and id <= 634;
update npc_types set startera = 200 where id = 635;
update npc_types set startera = 800 where id >= 650 and id <= 684;
update npc_types set startera = 800 where id = 1025;
update npc_types set startera = 600 where id = 635;
update npc_types set startera = 200 where id = 1033;
update npc_types set startera = 810 where id = 1135;
update npc_types set startera = 600 where id = 1141;
update npc_types set startera = 600 where id = 1144;
update npc_types set startera = 600 where id = 2010;
update npc_types set startera = 600 where id = 9009;
update npc_types set startera = 400 where id = 9150;

update npc_types set startera = 600 where id = 10013;
update npc_types set startera = 600 where id = 19016;
update npc_types set startera = 600 where id = 40000;
update npc_types set startera = 600 where id = 41001;
update npc_types set startera = 600 where id = 42001;
update npc_types set startera = 600 where id = 61000;
update npc_types set startera = 600 where id = 67001;
update npc_types set startera = 600 where id = 383017;
update npc_types set startera = 600 where id = 392010;
update npc_types set startera = 600 where id = 2099;
update npc_types set startera = 600 where id = 9128;
update npc_types set startera = 600 where id = 10133;
update npc_types set startera = 600 where id = 19019;
update npc_types set startera = 600 where id = 40004;
update npc_types set startera = 600 where id = 41005;
update npc_types set startera = 600 where id = 42021;
update npc_types set startera = 600 where id = 49021;
update npc_types set startera = 600 where id = 49103;
update npc_types set startera = 600 where id = 49115;
update npc_types set startera = 600 where id = 50111;
update npc_types set startera = 600 where id = 55016;
update npc_types set startera = 600 where id = 55175;
update npc_types set startera = 600 where id = 61014;
update npc_types set startera = 600 where id = 67006;
update npc_types set startera = 600 where id = 82000;
update npc_types set startera = 600 where id = 106009;
update npc_types set startera = 600 where id = 382157;

/* Emissaries of Shadowrest */

update npc_types set startera = 809 where id = 4070;
update npc_types set startera = 809 where id = 22104;
update npc_types set startera = 809 where id = 33095;
update npc_types set startera = 809 where id = 38078;
update npc_types set startera = 809 where id = 47153;
update npc_types set startera = 809 where id = 68123;
update npc_types set startera = 809 where id = 78101;
update npc_types set startera = 809 where id = 165165;
update npc_types set startera = 809 where id = 202274;

/* Dock Translocators */

update npc_types set startera = 830 where id = 1135;
update npc_types set startera = 830 where id = 10155;
update npc_types set startera = 830 where id = 24101;
update npc_types set startera = 830 where id = 34066;
update npc_types set startera = 830 where id = 37066;
update npc_types set startera = 830 where id = 68134;
update npc_types set startera = 830 where id = 68135;
update npc_types set startera = 830 where id = 69088;
update npc_types set startera = 830 where id = 84208;
update npc_types set startera = 830 where id = 93157;
update npc_types set startera = 830 where id = 96070;
update npc_types set startera = 830 where id = 96071;
update npc_types set startera = 830 where id = 98045;
update npc_types set startera = 830 where id = 110073;

/* Soulbinders */

update npc_types set startera = 410 where id = 1033;
update npc_types set startera = 410 where id = 24035;
update npc_types set startera = 410 where id = 96070;
update npc_types set startera = 410 where id = 11072;
update npc_types set startera = 410 where id = 61067;
update npc_types set startera = 410 where id = 30089;
update npc_types set startera = 410 where id = 155090;
update npc_types set startera = 410 where id = 10191;
update npc_types set startera = 410 where id = 19032;
update npc_types set startera = 410 where id = 29076;
update npc_types set startera = 410 where id = 93156;
update npc_types set startera = 410 where id = 150310;
update npc_types set startera = 410 where id = 40007;
update npc_types set startera = 410 where id = 1033;
update npc_types set startera = 410 where id = 54179;
update npc_types set startera = 410 where id = 34125;
update npc_types set startera = 410 where id = 106117;
update npc_types set startera = 410 where id = 1033;
update npc_types set startera = 410 where id = 35068;
update npc_types set startera = 410 where id = 68136;
update npc_types set startera = 410 where id = 84206;
update npc_types set startera = 410 where id = 55152;
update npc_types set startera = 410 where id = 75115;
update npc_types set startera = 410 where id = 60047;
update npc_types set startera = 410 where id = 49082;

/* Tribute Masters */

update npc_types set startera = 600 where id = 61023;
update npc_types set startera = 600 where id = 24031;
update npc_types set startera = 600 where id = 1025;
update npc_types set startera = 600 where id = 19030;
update npc_types set startera = 600 where id = 2049;
update npc_types set startera = 600 where id = 8028;
update npc_types set startera = 600 where id = 49034;
update npc_types set startera = 600 where id = 60025;
update npc_types set startera = 600 where id = 54084;
update npc_types set startera = 600 where id = 106113;
update npc_types set startera = 600 where id = 8027;
update npc_types set startera = 600 where id = 54083;
update npc_types set startera = 600 where id = 3012;
update npc_types set startera = 600 where id = 155087;
update npc_types set startera = 600 where id = 40006;
update npc_types set startera = 600 where id = 50119;
update npc_types set startera = 600 where id = 55019;
update npc_types set startera = 600 where id = 3019;
update npc_types set startera = 600 where id = 29007;
update npc_types set startera = 600 where id = 10037;
update npc_types set startera = 600 where id = 52101;

/* Town Criers - www.eqclerics.org/forums/showthread.php?t=8942 */

update npc_types set startera = 319 where id = 40070;
update npc_types set startera = 319 where id = 75113;
update npc_types set startera = 319 where id = 49073;
update npc_types set startera = 319 where id = 29008;
update npc_types set startera = 319 where id = 106115;
update npc_types set startera = 319 where id = 61065;
update npc_types set startera = 319 where id = 9053;
update npc_types set startera = 319 where id = 41021;
update npc_types set startera = 319 where id = 67058;
update npc_types set startera = 319 where id = 54067;
update npc_types set startera = 319 where id = 1032;
update npc_types set startera = 319 where id = 23017;
update npc_types set startera = 319 where id = 55150;
update npc_types set startera = 319 where id = 50140;

/* Realm of Heroes Quest Event - everquest.allakhazam.com/db/quest.html?quest=1222 */

update npc_types set startera = 310 where id = 1027;
update npc_types set startera = 310 where id = 2053;
update npc_types set startera = 310 where id = 9054;
update npc_types set startera = 310 where id = 49074;
update npc_types set startera = 310 where id = 55151;
update npc_types set startera = 310 where id = 61066;
update npc_types set startera = 310 where id = 82046;

/* South Qeynos */

update npc_types set startera = 428 where id = 1029;
update npc_types set startera = 500 where id = 1031;
update npc_types set startera = 600 where id = 1034;
update npc_types set startera = 326 where id = 1084;
update npc_types set startera = 700 where id = 1133;
update npc_types set startera = 900 where id = 1312;
update npc_types set startera = 1000 where id = 1313;
update npc_types set startera = 600 where id = 1034;

/* North Qeynos */

update npc_types set startera = 600 where id = 2037;
update npc_types set startera = 600 where id = 2050;
update npc_types set startera = 700 where id = 2150;
update npc_types set startera = 1600 where id = 2156;
update npc_types set startera = 1000 where id = 2157;
update npc_types set startera = 1000 where id = 2158;
update npc_types set startera = 1600 where id = 2159;
update npc_types set startera = 335 where id = 2160;

/* Ak'Anon */

update npc_types set startera = 700 where id = 55156;
update npc_types set startera = 800 where id = 55159;
update npc_types set startera = 600 where id = 55153;
update npc_types set startera = 200 where id = 55006;
update npc_types set startera = 200 where id = 55017;
update npc_types set startera = 600 where id = 55025;
update npc_types set startera = 600 where id = 55022;
update npc_types set startera = 600 where id = 55023;
update npc_types set startera = 600 where id = 55024;

/* East Freeport */

update npc_types set startera = 600 where id = 10115;

/* remove defiant from the loot tables, but keep the chance values */

UPDATE lootdrop_entries SET disabled_chance = chance WHERE item_id >=50005 AND item_id <=60561;
UPDATE lootdrop_entries SET chance = 0 WHERE item_id >=50005 AND item_id <=60561;

/* PoK early 2000s revert */

UPDATE spawnentry SET  disabled_chance =  100 WHERE  npcID = 202388;
UPDATE spawnentry SET  disabled_chance =  100 WHERE  npcID = 202458;
UPDATE spawnentry SET  disabled_chance =  100 WHERE  npcID = 202425;
UPDATE spawnentry SET  disabled_chance =  100 WHERE  npcID = 202449;
UPDATE spawnentry SET  chance =  0 WHERE  npcID = 202388;
UPDATE spawnentry SET  chance =  0 WHERE  npcID = 202458;
UPDATE spawnentry SET  chance =  0 WHERE  npcID = 202425;
UPDATE spawnentry SET  chance =  0 WHERE  npcID = 202449;
UPDATE npc_types SET  gender =  0 WHERE  id = 202115;
UPDATE npc_types SET race = 2 WHERE id =202114;
UPDATE npc_types SET race = 1 WHERE id =202053;
UPDATE npc_types SET texture = 2 WHERE id =202053;
UPDATE npc_types SET gender = 0 WHERE id =202053;
UPDATE npc_types SET gender = 1 WHERE id =202113;
UPDATE npc_types SET gender = 0 WHERE id =202097;
UPDATE npc_types SET race = 128 WHERE id =202028;
UPDATE npc_types SET texture = 2 WHERE id =202028;
UPDATE npc_types SET gender = 0 WHERE id =202052;
UPDATE npc_types SET texture = 2 WHERE id =202052;
UPDATE npc_types SET gender = 1 WHERE id =202107;
UPDATE npc_types SET gender = 0 WHERE id =202116;
UPDATE npc_types SET gender = 0 WHERE id =202118;
UPDATE npc_types SET gender = 0 WHERE id =202101;
UPDATE npc_types SET race = 11 WHERE id =202102;
UPDATE npc_types SET gender = 1 WHERE id =202102;
UPDATE npc_types SET gender = 0 WHERE id =202111;
UPDATE npc_types SET texture = 2 WHERE id =202032;
UPDATE npc_types SET gender = 1 WHERE id =202109;
UPDATE npc_types SET gender = 0 WHERE id =202035;
UPDATE npc_types SET texture = 2 WHERE id =202035;
UPDATE npc_types SET texture = 2 WHERE id =202027;
UPDATE npc_types SET gender = 0 WHERE id =202117;
UPDATE npc_types SET gender = 0 WHERE id =202031;
UPDATE npc_types SET texture = 2 WHERE id =202030;
UPDATE npc_types SET texture = 2 WHERE id =202030;
UPDATE npc_types SET gender = 1 WHERE id =202031;
UPDATE npc_types SET texture = 2 WHERE id =202031;
UPDATE  npc_types SET  race =  5 WHERE id =202112;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202112;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202031;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202098;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202097;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202111;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202113;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202030;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202102;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202118;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202115;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202053;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202116;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202103;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202052;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202100;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202107;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202027;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202104;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202114;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202099;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202119;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202108;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202032;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202106;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202101;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202035;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202110;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202117;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202096;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202028;
UPDATE  npc_types SET  lastname =  '' WHERE  id =202105;
UPDATE  npc_types SET  level =  60 WHERE  id =202112;
UPDATE  npc_types SET  level =  60 WHERE  id =202031;
UPDATE  npc_types SET  level =  60 WHERE  id =202098;
UPDATE  npc_types SET  level =  60 WHERE  id =202097;
UPDATE  npc_types SET  level =  60 WHERE  id =202111;
UPDATE  npc_types SET  level =  60 WHERE  id =202113;
UPDATE  npc_types SET  level =  60 WHERE  id =202030;
UPDATE  npc_types SET  level =  60 WHERE  id =202102;
UPDATE  npc_types SET  level =  60 WHERE  id =202118;
UPDATE  npc_types SET  level =  60 WHERE  id =202115;
UPDATE  npc_types SET  level =  60 WHERE  id =202053;
UPDATE  npc_types SET  level =  60 WHERE  id =202116;
UPDATE  npc_types SET  level =  60 WHERE  id =202103;
UPDATE  npc_types SET  level =  60 WHERE  id =202052;
UPDATE  npc_types SET  level =  60 WHERE  id =202100;
UPDATE  npc_types SET  level =  60 WHERE  id =202107;
UPDATE  npc_types SET  level =  60 WHERE  id =202027;
UPDATE  npc_types SET  level =  60 WHERE  id =202104;
UPDATE  npc_types SET  level =  60 WHERE  id =202114;
UPDATE  npc_types SET  level =  60 WHERE  id =202099;
UPDATE  npc_types SET  level =  60 WHERE  id =202119;
UPDATE  npc_types SET  level =  60 WHERE  id =202108;
UPDATE  npc_types SET  level =  60 WHERE  id =202032;
UPDATE  npc_types SET  level =  60 WHERE  id =202106;
UPDATE  npc_types SET  level =  60 WHERE  id =202101;
UPDATE  npc_types SET  level =  60 WHERE  id =202035;
UPDATE  npc_types SET  level =  60 WHERE  id =202110;
UPDATE  npc_types SET  level =  60 WHERE  id =202117;
UPDATE  npc_types SET  level =  60 WHERE  id =202096;
UPDATE  npc_types SET  level =  60 WHERE  id =202028;
UPDATE  npc_types SET  level =  60 WHERE  id =202105;
UPDATE  npc_types SET  race =  3 WHERE  id =202295;
UPDATE  npc_types SET  texture =  4 WHERE  id =202295;

[rudeboy88]

These ones aren't numbered as they were from about last year, and pertain to NPCs that aren't Classic. Cross referenced between P99 ingame/Wiki, Allakabor, and Allakhazam these NPCs I believe were added after Classic. This does include kilns, ovens, etc. as a formality.

*edit* still missing: Grobb, Halas, and possibly a portion of Erudin Palace.

Neriak Third Gate

Belyea K`Jartan’s Last name changed from Belyea KJartan sometime between Velious and Kunark.
(Also true with other Kjartans noted on alla/alla in neriakb/c.)
http://everquest.allakhazam.com/db/npc.html?id=9949
http://everquest.allakhazam.com/db/npc.html?id=2342
Guard V`Retta
Poison Master Oskar
Tayla Ironforge
Oven 1

North Kaladim

a spell research merchant #1 (male, North Kaladim) [Research Supplies]
a spell research merchant #2 (North Kaladim) [Research Supplies]
a spell research merchant #3 (North Kaladim) [Research Supplies]
a spell research merchant #4 (North Kaladim) [Research Supplies]
Forge #1 (North Kaladim)
Forge #1 (South Kaladim)
Guard Kanuf [Noble Exchange]
Kiln #1 (North Kaladim)
Pottery Wheel #1 (North Kaladim)
Usbak the Old

South Kaladim

Artisan Yar Shiverbrow
Brewing Barrel #1 (South Kaladim)
Dwantin Cassilla
Gemcrafter Donum
Gloribo Hammerbreaker
Guard Kathur
Helga Steelsmith [Mercenary Liaison]
Kiln #1 (South Kaladim)
Maltar Steelsmith [Mercenary Liaison]
Myra Denghop
Pottery Wheel #1 (South Kaladim)
Stormguard Forge (South Kaladim)
Tsann Wilbus

Northern Felwithe

Ann Oma [Tribute Master]
Artisan Elistar Vorann [Tradeskill Quests]
Brewing Barrel #1 (North Felwithe)
Emissary Faylien
Exterminator Valern
Fireworks Engineer Fabdabus [Frostfell Fireworks]
Forge #1 (North Felwithe)
Galrun Starforge
Gemcrafter Helum [Melee Augments]
Hargar the Velium Chef [Frostfell Cook]
Herve Silverstar [Mercenary Liaison]
High Guard Ivyleaf
Kiln #1 (North Felwithe)
Kirilin
Koada`Dal Forge (North Felwithe)
Lady Carolline of Thex [Epic Memories]
Laernian Caelael [Town Crier]
Oven #1 (North Felwithe)
Pottery Wheel #1 (North Felwithe)
Quartermaster Entag
Rinys Konjin [Anniversary Quest]
Santug Claugg [Northern Felwithe]
Tolon Nurbyte

Southern Felwithe

Community Loom #1 (South Felwithe)
Eoando Kelu
Lalanis

North Freeport

(Feb 21, 2006; pre-revamp listing changes https://web.archive.org/web/20060221...h.shtml?zone=3)

Alchemist Bauer
Gayle Seesill
Gubbly Gippledo
Venox Tarkog

West Freeport

(Dec 25, 2004 https://web.archive.org/web/20050114....html?zstrat=2)
A Sewer Rat
A Wolf
Knight of Truth
Taxonomist Darwin Grisk

East Freeport

(Dec. 23, 2005 https://web.archive.org/web/20051223...h.shtml?zone=1)
a myotis bat (vs. just “a bat”, allakabor)


Oggok

Bordag [Beastlord Guildmaster]
Artisan Garth Okken [Trade Skill Quests]
Baddi Waca
Bardopa
Bordag [Beastlord Guildmaster]
Brewing Barrel #1 (Oggok)
Community Loom (Oggok)
Forge #1 (Oggok)
Garakpor [Alchemy Supplies]
Garu Nokel [Noble Exchange]
Gemcrafter Onup
Grenda
Greska [Mercenary Liaison]
Kiln #1 (Oggok)
Korff
Ogre Forge (Oggok)
Pottery Wheel #1 (Oggok)
Runkuk [Mercenary Liaison]
Santug Claugg [Oggok]
Sheerie Oglarum [Berserker Tomes]
Snogge

Paineel

a cliknar invader
a kobold runt
A Necromancer Initiate
Accure Nedorn
Agent of Change (Paineel) [The Hole Expedition]
Artisan Korzan Virimove
avatar of dread
Avatar of Fright
avatar of terror
Gemcrafter Emod
Guard Lixstip
Guard Queztlor
Jerith
Medorla Nedorn

Erudin

a diseased shark
a piranha
a spell research merchant #1 (male, Erudin) [Research Supplies]
a spell research merchant #2 (female, Erudin) [Research Supplies]
a spell research merchant #3 (male, Erudin) [Research Supplies]
a spell research merchant #4 (Erudin) [Research Supplies]
Artisan Gorion Telld`Mare
Brewing Barrel #1 (Erudin)
Brewing Barrel #2 (Erudin)
Buzzlin Bornahm
Cassia Spartinkle
Community Loom (Erudin)
Erudite Forge (Erudin)
Ellisa Starlight
Forge #1 (Erudin)
Forge #2 (Erudin)
Forge #3 (Erudin)
Gemcrafter Emod
Golden Maiden
Ierene Seldon
Kiln #1 (Erudin)
Nathen Starr
Oven #1 (Erudin)
Oven #2 (Erudin)
Pottery Wheel #1 (Erudin)
Santug Claugg [Erudin]
Sea King
Senina Jolik
Silva Tonk
Timon Starlight

Erudin Palace
a water elemental

[rudeboy88]

NeriakA

a Troll Raider
Basher Mashmush
Basher Torga
Brewing Barrel
Community Loom 1
Forge 1, 2
Gralok
Grordoz
Guard Din`a
Guard Quexill
Guard Zexus
Kiln 1
Oven 1, 2
Pottery Wheel
Razeela Miloch
Rolynn Bdoph
Santa Claugg
Warlord Borter
Warlord Ykesha

NeriakB

a fish
a spell research merchant 1-4
Artistan Dosan Vis`Moor
Brewing Barrel 1
Encan V`Dal
Forge 1
Guard V`Lask
Gemcrafter Disel
Guard Din`a
Guard T`Kix
Oven 1
Sylnyk T`Vok

Surefall

Hue Arborleaf
Jimothy the Delicious
Maghee Thunderwood
Rentila the Bonecollector
A Bloodsaber Defiler (possible addition at time of JaggedPine)

Rivervale

a sage apprentice (possible Kunark addition)
a halfling acolyte
a halfling grandma
a halfling grandpa
a halfling mother
a halfling father (on allakabor not kazam)
a spell research assistant 1-4
Brewing Barrel 1, 2
Community Loom
Forge
Gemcrafter Hamm
Oven 1, 2
Poison Master Elmn
Pottery Wheel 1, 2
Quatermaster Mirten Santa Claugg
Smarta Bragglethin
Vale Forge

[rudeboy88]

GM Events:

Some of these are probably known, and I had a better list of these somewhere, but in the meantime will also post stuff about those here too.

Cros Treewind's death sometime in late Kunark was at times followed by a GM event (Oct 17, 2000) post here http://everquest.allakhazam.com/db/npc.html?id=2988

[rudeboy88]

The Realm of Heroes NPCs were used to tell about something irl that happened at an SOE Fan Faire I think from Dallas around 2002 iirc, but also were used for distributing various items in exchange for coins dropped during GM events. GM events usually included slaying some diety that was GM-popped, and recieving the coin as loot.

March 25 2005 post and Oct 31 2001 post

http://everquest.allakhazam.com/db/npc.html?id=6613

[rudeboy88]

Recently been looking into how the release of Paineel made changes to Odus - Paineel looks to have been released ~2 months before the end of Classic, and while erudites weren't able to be shadowknights until then from what I read they were able to be Necromancers.

Thanks to a post from here by ChaosslayerZ and according to the p99 wiki map Erudite necromancers had a hut near the druid ring, I was able to find a page from March of 2000 that listed at least 1 of the NPCs that used to hang out there.

http://www.thecomputershow.com/compu...everquests.htm
https://web.archive.org/web/20010106.../toxxulia.html

Originally Posted by ChaosSlayerZ

Erudite Necros existed from day one. Their class trainers were in a small hut in Tox near druid ring

[rudeboy88]

Not really a GM event, but for EQ's 5th anniversary (and I guess Halloween 2004) at night a skeleton army would spawn in Butcherblock Mountains, East Commonlands, The Feerrott, Qeynos Hills, Steamfont Mountains, and Toxxulia Forest. The commanders dropped some decent stuff for lower levels.

http://everquest.allakhazam.com/db/item.html?item=27344
http://everquest.allakhazam.com/db/npc.html?id=14811

[rudeboy88]

Any further updates can be found at the project's github page: www.github.com/xackery/peq-expansions.

[Huppy]

Originally Posted by rudeboy88

at night a skeleton army would spawn

Back when I started on live, years ago, there was a red skelly army that spawned in Kithicor every night (game time). It was a pita running through that zone. We had to hug the wall a lot, but that was fun stuff for us. :P

[Akkadius]

http://www.projecteq.net/forums/inde...89/#post-79075