Discord: eqemu/project-peq-expansions

rudeboy88 · #1 04-01-2019, 03:33 PM

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.

Code:

/* 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;