Go Back   EQEmulator Home > EQEmulator Forums > General > General::Server Discussion
Reload this Page Sim Patches?

General::Server Discussion Discussion about emulator servers.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2015, 10:53 AM
rudeboy88's Avatar
rudeboy88
Sarnak
  
Join Date: Oct 2007
Location: West Freeport
Posts: 46
Default Sim Patches?
Hey all,

So in the past couple of years I had talked with a friend about the possibility of a progession server (we frequently bounce around servers and wanted our own). The conversation eventually lead me to a project that I began but wanted to check in about it with EQEmu because I wanted to leave whatever parts I finish here.

Basically here's the results so far: I have began "tagging" things using two columns (startera for things added in, endera for things nerfed or removed) that I have added in the db according to patches. The numbering convention for said changes goes up in 3's from the hundred level (ex. classic is 100, classic patch 1 would be 103.) I chose this largely because it would give server admins like myself a little leeway should they see additional changes to be added in between.

In recent weeks though I had noticed the way in which P99 has done their sim patches, and it made me wonder if a month-to-month sim patch would be more efficient, being that we don't have to do things like updating clients?

With all that said though I present you with the beginnings of said project, probably a couple faulty syntax flukes in here but nevertheless, this will add the columns to your tables, number your zones, "block out" the npcs in that zone, and (iirc) it will then number your soulbinders for their appropriate era in at least Freeport thereafter. I just had some time to sit back down with this starting this weekend and am hoping to get some more of the NPCs tagged.

With this in a more complete form I was hoping that it could potentially remove or add NPCs, (maybe?) objects, and loot based on era in a simplified, almost single-button press fashion, however I haven't gotten as far as figuring that out yet (besides maybe adding -u and -p to each line and making expansion based .sh files), just began numbering hehe.

*edit* This was made at a time when I was looking at Omens being a possible end era, so most changes here have ended within Titanium's expansions.

(thanks to Kingly Krab and Provocating for the idea http://www.eqemulator.org/forums/showthread.php?t=38771)

Code:
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 = 118 where short_name = 'soltemple';
update zone set startera = 136 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 = 1000 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 = 1000 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 = 342 where short_name = 'warrens';
update zone set startera = 394 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;

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 = 624 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 = 824 where id >= 182000 and id <= 182140;
update npc_types set startera = 624 where id >= 186000 and id <= 186165;
update npc_types set startera = 1024 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 = 851 where id >= 224000 and id <= 228122;
update npc_types set startera = 700 where id >= 229000 and id <= 276416;
update npc_types set startera = 642 where id >= 277000 and id <= 277121;
update npc_types set startera = 648 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 = 1003 where id >= 344000 and id <= 344014;
update npc_types set startera = 1003 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;

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 = 830 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;

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

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;

update npc_types set startera = 1000 where id = 2158;
update npc_types set startera = 600 where id = 10115;
__________________
Discord: 1augher | Dev, Darkonites
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 08:29 AM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3