For God sakes help

[So_1337]

### These queries lock down the zones for the sake of progression ###
UPDATE zone SET min_status = 255 WHERE short_name = 'abysmal';
UPDATE zone SET min_status = 255 WHERE short_name = 'acrylia';
UPDATE zone SET min_status = 255 WHERE short_name = 'akheva';
UPDATE zone SET min_status = 255 WHERE short_name = 'anguish';
UPDATE zone SET min_status = 255 WHERE short_name = 'apprentice';
UPDATE zone SET min_status = 255 WHERE short_name = 'arcstone';
UPDATE zone SET min_status = 255 WHERE short_name = 'arena2';
UPDATE zone SET min_status = 255 WHERE short_name = 'arttest';
UPDATE zone SET min_status = 255 WHERE short_name = 'ashengate';
UPDATE zone SET min_status = 255 WHERE short_name = 'atiiki';
UPDATE zone SET min_status = 255 WHERE short_name = 'aviak';
UPDATE zone SET min_status = 255 WHERE short_name = 'barindu';
UPDATE zone SET min_status = 255 WHERE short_name = 'barren';
UPDATE zone SET min_status = 255 WHERE short_name = 'barter';
UPDATE zone SET min_status = 255 WHERE short_name = 'bazaar';
UPDATE zone SET min_status = 255 WHERE short_name = 'befallenb';
UPDATE zone SET min_status = 255 WHERE short_name = 'blacksail';
UPDATE zone SET min_status = 255 WHERE short_name = 'bloodfields';
UPDATE zone SET min_status = 255 WHERE short_name = 'bothunder';
UPDATE zone SET min_status = 255 WHERE short_name = 'broodlands';
UPDATE zone SET min_status = 255 WHERE short_name = 'buriedsea';
UPDATE zone SET min_status = 255 WHERE short_name = 'causeway';
UPDATE zone SET min_status = 255 WHERE short_name = 'cazicthule';
UPDATE zone SET min_status = 255 WHERE short_name = 'chambersa';
UPDATE zone SET min_status = 255 WHERE short_name = 'chambersb';
UPDATE zone SET min_status = 255 WHERE short_name = 'chambersc';
UPDATE zone SET min_status = 255 WHERE short_name = 'chambersd';
UPDATE zone SET min_status = 255 WHERE short_name = 'chamberse';
UPDATE zone SET min_status = 255 WHERE short_name = 'chambersf';
UPDATE zone SET min_status = 255 WHERE short_name = 'chardokb';
UPDATE zone SET min_status = 255 WHERE short_name = 'clz';
UPDATE zone SET min_status = 255 WHERE short_name = 'codecay';
UPDATE zone SET min_status = 255 WHERE short_name = 'commonlands';
UPDATE zone SET min_status = 255 WHERE short_name = 'corathus';
UPDATE zone SET min_status = 255 WHERE short_name = 'corathusa';
UPDATE zone SET min_status = 255 WHERE short_name = 'corathusb';
UPDATE zone SET min_status = 255 WHERE short_name = 'crescent';
UPDATE zone SET min_status = 255 WHERE short_name = 'cshome';
UPDATE zone SET min_status = 255 WHERE short_name = 'dawnshroud';
UPDATE zone SET min_status = 255 WHERE short_name = 'deadbone';
UPDATE zone SET min_status = 255 WHERE short_name = 'delvea';
UPDATE zone SET min_status = 255 WHERE short_name = 'delveb';
UPDATE zone SET min_status = 255 WHERE short_name = 'devastationa';
UPDATE zone SET min_status = 255 WHERE short_name = 'devastion';
UPDATE zone SET min_status = 255 WHERE short_name = 'direwind';
UPDATE zone SET min_status = 255 WHERE short_name = 'drachnidhive';
UPDATE zone SET min_status = 255 WHERE short_name = 'drachnidhivea';
UPDATE zone SET min_status = 255 WHERE short_name = 'drachnidhiveb';
UPDATE zone SET min_status = 255 WHERE short_name = 'drachnidhivec';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranik';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikcatacombsa';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikcatacombsb';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikcatacombsc';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikhollowsa';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikhollowsb';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikhollowsc';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikhollowsd';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikhollowse';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikhollowsf';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikhollowsg';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikhollowsh';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikhollowsi';
UPDATE zone SET min_status = 255 WHERE short_name = 'dranikhollowsj';
UPDATE zone SET min_status = 255 WHERE short_name = 'draniksewersa';
UPDATE zone SET min_status = 255 WHERE short_name = 'draniksewersb';
UPDATE zone SET min_status = 255 WHERE short_name = 'draniksewersc';
UPDATE zone SET min_status = 255 WHERE short_name = 'draniksscar';
UPDATE zone SET min_status = 255 WHERE short_name = 'dreadspire';
UPDATE zone SET min_status = 255 WHERE short_name = 'dulak';
UPDATE zone SET min_status = 255 WHERE short_name = 'eastkorlach';
UPDATE zone SET min_status = 255 WHERE short_name = 'eastkorlacha';
UPDATE zone SET min_status = 255 WHERE short_name = 'echo';
UPDATE zone SET min_status = 255 WHERE short_name = 'elddar';
UPDATE zone SET min_status = 255 WHERE short_name = 'elddara';
UPDATE zone SET min_status = 255 WHERE short_name = 'erudsxing2';
UPDATE zone SET min_status = 255 WHERE short_name = 'ferubi';
UPDATE zone SET min_status = 255 WHERE short_name = 'fhalls';
UPDATE zone SET min_status = 255 WHERE short_name = 'freeportacademy';
UPDATE zone SET min_status = 255 WHERE short_name = 'freeportarena';
UPDATE zone SET min_status = 255 WHERE short_name = 'freeportcityhall';
UPDATE zone SET min_status = 255 WHERE short_name = 'freeporteast';
UPDATE zone SET min_status = 255 WHERE short_name = 'freeporthall';
UPDATE zone SET min_status = 255 WHERE short_name = 'freeportmilitia';
UPDATE zone SET min_status = 255 WHERE short_name = 'freeportsewers';
UPDATE zone SET min_status = 255 WHERE short_name = 'freeporttemple';
UPDATE zone SET min_status = 255 WHERE short_name = 'freeporttheater';
UPDATE zone SET min_status = 255 WHERE short_name = 'freeportwest';
UPDATE zone SET min_status = 255 WHERE short_name = 'frostcrypt';
UPDATE zone SET min_status = 255 WHERE short_name = 'fungusgrove';
UPDATE zone SET min_status = 255 WHERE short_name = 'griegsend';
UPDATE zone SET min_status = 255 WHERE short_name = 'grimling';
UPDATE zone SET min_status = 255 WHERE short_name = 'guildhall';
UPDATE zone SET min_status = 255 WHERE short_name = 'guildlobby';
UPDATE zone SET min_status = 255 WHERE short_name = 'guka';
UPDATE zone SET min_status = 255 WHERE short_name = 'gukb';
UPDATE zone SET min_status = 255 WHERE short_name = 'gukc';
UPDATE zone SET min_status = 255 WHERE short_name = 'gukd';
UPDATE zone SET min_status = 255 WHERE short_name = 'guke';
UPDATE zone SET min_status = 255 WHERE short_name = 'gukf';
UPDATE zone SET min_status = 255 WHERE short_name = 'gukg';
UPDATE zone SET min_status = 255 WHERE short_name = 'gukh';
UPDATE zone SET min_status = 255 WHERE short_name = 'gunthak';
UPDATE zone SET min_status = 255 WHERE short_name = 'harbingers';
UPDATE zone SET min_status = 0 WHERE short_name = 'hateplane';
UPDATE zone SET min_status = 255 WHERE short_name = 'hateplaneb';
UPDATE zone SET min_status = 255 WHERE short_name = 'hatesfury';
UPDATE zone SET min_status = 255 WHERE short_name = 'highpasshold';
UPDATE zone SET min_status = 255 WHERE short_name = 'highpasskeep';
UPDATE zone SET min_status = 255 WHERE short_name = 'hohonora';
UPDATE zone SET min_status = 255 WHERE short_name = 'hohonorb';
UPDATE zone SET min_status = 255 WHERE short_name = 'hollowshade';
UPDATE zone SET min_status = 255 WHERE short_name = 'icefall';
UPDATE zone SET min_status = 255 WHERE short_name = 'ikkinz';
UPDATE zone SET min_status = 255 WHERE short_name = 'illsalin';
UPDATE zone SET min_status = 255 WHERE short_name = 'illsalina';
UPDATE zone SET min_status = 255 WHERE short_name = 'illsalinb';
UPDATE zone SET min_status = 255 WHERE short_name = 'illsalinc';
UPDATE zone SET min_status = 255 WHERE short_name = 'inktuta';
UPDATE zone SET min_status = 255 WHERE short_name = 'innothuleb';
UPDATE zone SET min_status = 255 WHERE short_name = 'jaggedpine';
UPDATE zone SET min_status = 255 WHERE short_name = 'jardelshook';
UPDATE zone SET min_status = 255 WHERE short_name = 'katta';
UPDATE zone SET min_status = 255 WHERE short_name = 'kattacastrum';
UPDATE zone SET min_status = 255 WHERE short_name = 'kithforest';
UPDATE zone SET min_status = 255 WHERE short_name = 'kodtaz';
UPDATE zone SET min_status = 255 WHERE short_name = 'letalis';
UPDATE zone SET min_status = 255 WHERE short_name = 'load';
UPDATE zone SET min_status = 255 WHERE short_name = 'load2';
UPDATE zone SET min_status = 255 WHERE short_name = 'maiden';
UPDATE zone SET min_status = 255 WHERE short_name = 'maidensgrave';
UPDATE zone SET min_status = 255 WHERE short_name = 'mesa';
UPDATE zone SET min_status = 255 WHERE short_name = 'mira';
UPDATE zone SET min_status = 255 WHERE short_name = 'mirb';
UPDATE zone SET min_status = 255 WHERE short_name = 'mirc';
UPDATE zone SET min_status = 255 WHERE short_name = 'mird';
UPDATE zone SET min_status = 255 WHERE short_name = 'mire';
UPDATE zone SET min_status = 255 WHERE short_name = 'mirf';
UPDATE zone SET min_status = 255 WHERE short_name = 'mirg';
UPDATE zone SET min_status = 255 WHERE short_name = 'mirh';
UPDATE zone SET min_status = 255 WHERE short_name = 'miri';
UPDATE zone SET min_status = 255 WHERE short_name = 'mirj';
UPDATE zone SET min_status = 255 WHERE short_name = 'mischiefplane';
UPDATE zone SET min_status = 255 WHERE short_name = 'mistythicket';
UPDATE zone SET min_status = 255 WHERE short_name = 'mmca';
UPDATE zone SET min_status = 255 WHERE short_name = 'mmcb';
UPDATE zone SET min_status = 255 WHERE short_name = 'mmcc';
UPDATE zone SET min_status = 255 WHERE short_name = 'mmcd';
UPDATE zone SET min_status = 255 WHERE short_name = 'mmce';
UPDATE zone SET min_status = 255 WHERE short_name = 'mmcf';
UPDATE zone SET min_status = 255 WHERE short_name = 'mmcg';
UPDATE zone SET min_status = 255 WHERE short_name = 'mmch';
UPDATE zone SET min_status = 255 WHERE short_name = 'mmci';
UPDATE zone SET min_status = 255 WHERE short_name = 'mmcj';
UPDATE zone SET min_status = 255 WHERE short_name = 'monkeyrock';
UPDATE zone SET min_status = 255 WHERE short_name = 'moors';
UPDATE zone SET min_status = 255 WHERE short_name = 'mseru';
UPDATE zone SET min_status = 255 WHERE short_name = 'nadox';
UPDATE zone SET min_status = 255 WHERE short_name = 'natimbi';
UPDATE zone SET min_status = 255 WHERE short_name = 'nedaria';
UPDATE zone SET min_status = 255 WHERE short_name = 'nektropos';
UPDATE zone SET min_status = 255 WHERE short_name = 'nektulosa';
UPDATE zone SET min_status = 255 WHERE short_name = 'neriakd';
UPDATE zone SET min_status = 255 WHERE short_name = 'netherbian';
UPDATE zone SET min_status = 255 WHERE short_name = 'nexus';
UPDATE zone SET min_status = 255 WHERE short_name = 'nightmareb';
UPDATE zone SET min_status = 255 WHERE short_name = 'northro';
UPDATE zone SET min_status = 255 WHERE short_name = 'oceanoftears';
UPDATE zone SET min_status = 255 WHERE short_name = 'paludal';
UPDATE zone SET min_status = 255 WHERE short_name = 'paw';
UPDATE zone SET min_status = 255 WHERE short_name = 'poair';
UPDATE zone SET min_status = 255 WHERE short_name = 'podisease';
UPDATE zone SET min_status = 255 WHERE short_name = 'poeartha';
UPDATE zone SET min_status = 255 WHERE short_name = 'poearthb';
UPDATE zone SET min_status = 255 WHERE short_name = 'pofire';
UPDATE zone SET min_status = 255 WHERE short_name = 'poinnovation';
UPDATE zone SET min_status = 255 WHERE short_name = 'pojustice';
UPDATE zone SET min_status = 255 WHERE short_name = 'ponightmare';
UPDATE zone SET min_status = 255 WHERE short_name = 'postorms';
UPDATE zone SET min_status = 255 WHERE short_name = 'potactics';
UPDATE zone SET min_status = 255 WHERE short_name = 'potimea';
UPDATE zone SET min_status = 255 WHERE short_name = 'potimeb';
UPDATE zone SET min_status = 255 WHERE short_name = 'potorment';
UPDATE zone SET min_status = 255 WHERE short_name = 'potranquility';
UPDATE zone SET min_status = 255 WHERE short_name = 'povalor';
UPDATE zone SET min_status = 255 WHERE short_name = 'powar';
UPDATE zone SET min_status = 255 WHERE short_name = 'powater';
UPDATE zone SET min_status = 255 WHERE short_name = 'provinggrounds';
UPDATE zone SET min_status = 255 WHERE short_name = 'qinimi';
UPDATE zone SET min_status = 255 WHERE short_name = 'qvic';
UPDATE zone SET min_status = 255 WHERE short_name = 'qvicb';
UPDATE zone SET min_status = 255 WHERE short_name = 'rage';
UPDATE zone SET min_status = 255 WHERE short_name = 'ragea';
UPDATE zone SET min_status = 255 WHERE short_name = 'redfeather';
UPDATE zone SET min_status = 255 WHERE short_name = 'relic';
UPDATE zone SET min_status = 255 WHERE short_name = 'riftseekers';
UPDATE zone SET min_status = 255 WHERE short_name = 'riwwi';
UPDATE zone SET min_status = 255 WHERE short_name = 'roost';
UPDATE zone SET min_status = 255 WHERE short_name = 'ruja';
UPDATE zone SET min_status = 255 WHERE short_name = 'rujb';
UPDATE zone SET min_status = 255 WHERE short_name = 'rujc';
UPDATE zone SET min_status = 255 WHERE short_name = 'rujd';
UPDATE zone SET min_status = 255 WHERE short_name = 'ruje';
UPDATE zone SET min_status = 255 WHERE short_name = 'rujf';
UPDATE zone SET min_status = 255 WHERE short_name = 'rujg';
UPDATE zone SET min_status = 255 WHERE short_name = 'rujh';
UPDATE zone SET min_status = 255 WHERE short_name = 'ruji';
UPDATE zone SET min_status = 255 WHERE short_name = 'rujj';
UPDATE zone SET min_status = 255 WHERE short_name = 'scarlet';
UPDATE zone SET min_status = 255 WHERE short_name = 'shadeweaver';
UPDATE zone SET min_status = 255 WHERE short_name = 'shadowhaven';
UPDATE zone SET min_status = 255 WHERE short_name = 'shadowspine';
UPDATE zone SET min_status = 255 WHERE short_name = 'shipmvm';
UPDATE zone SET min_status = 255 WHERE short_name = 'shipmvp';
UPDATE zone SET min_status = 255 WHERE short_name = 'shipmvu';
UPDATE zone SET min_status = 255 WHERE short_name = 'shippvu';
UPDATE zone SET min_status = 255 WHERE short_name = 'shipuvu';
UPDATE zone SET min_status = 255 WHERE short_name = 'silyssar';
UPDATE zone SET min_status = 255 WHERE short_name = 'skylance';
UPDATE zone SET min_status = 0 WHERE short_name = 'sleeper';
UPDATE zone SET min_status = 255 WHERE short_name = 'sncrematory';
UPDATE zone SET min_status = 255 WHERE short_name = 'snlair';
UPDATE zone SET min_status = 255 WHERE short_name = 'snplant';
UPDATE zone SET min_status = 255 WHERE short_name = 'snpool';
UPDATE zone SET min_status = 255 WHERE short_name = 'soldungc';
UPDATE zone SET min_status = 255 WHERE short_name = 'solrotower';
UPDATE zone SET min_status = 255 WHERE short_name = 'solteris';
UPDATE zone SET min_status = 255 WHERE short_name = 'southro';
UPDATE zone SET min_status = 255 WHERE short_name = 'sseru';
UPDATE zone SET min_status = 255 WHERE short_name = 'ssratemple';
UPDATE zone SET min_status = 255 WHERE short_name = 'steppes';
UPDATE zone SET min_status = 255 WHERE short_name = 'stillmoona';
UPDATE zone SET min_status = 255 WHERE short_name = 'stillmoonb';
UPDATE zone SET min_status = 255 WHERE short_name = 'stonehive';
UPDATE zone SET min_status = 255 WHERE short_name = 'suncrest';
UPDATE zone SET min_status = 255 WHERE short_name = 'sunderock';
UPDATE zone SET min_status = 255 WHERE short_name = 'tacvi';
UPDATE zone SET min_status = 255 WHERE short_name = 'taka';
UPDATE zone SET min_status = 255 WHERE short_name = 'takb';
UPDATE zone SET min_status = 255 WHERE short_name = 'takc';
UPDATE zone SET min_status = 255 WHERE short_name = 'takd';
UPDATE zone SET min_status = 255 WHERE short_name = 'take';
UPDATE zone SET min_status = 255 WHERE short_name = 'takf';
UPDATE zone SET min_status = 255 WHERE short_name = 'takg';
UPDATE zone SET min_status = 255 WHERE short_name = 'takh';
UPDATE zone SET min_status = 255 WHERE short_name = 'taki';
UPDATE zone SET min_status = 255 WHERE short_name = 'takishruins';
UPDATE zone SET min_status = 255 WHERE short_name = 'takishruinsa';
UPDATE zone SET min_status = 255 WHERE short_name = 'takj';
UPDATE zone SET min_status = 255 WHERE short_name = 'tenebrous';
UPDATE zone SET min_status = 255 WHERE short_name = 'thalassius';
UPDATE zone SET min_status = 255 WHERE short_name = 'theater';
UPDATE zone SET min_status = 255 WHERE short_name = 'theatera';
UPDATE zone SET min_status = 255 WHERE short_name = 'thedeep';
UPDATE zone SET min_status = 255 WHERE short_name = 'thegrey';
UPDATE zone SET min_status = 255 WHERE short_name = 'thenest';
UPDATE zone SET min_status = 255 WHERE short_name = 'thundercrest';
UPDATE zone SET min_status = 255 WHERE short_name = 'tipt';
UPDATE zone SET min_status = 255 WHERE short_name = 'torgiran';
UPDATE zone SET min_status = 255 WHERE short_name = 'toxxulia';
UPDATE zone SET min_status = 255 WHERE short_name = 'tutorial';
UPDATE zone SET min_status = 255 WHERE short_name = 'tutoriala';
UPDATE zone SET min_status = 255 WHERE short_name = 'twilight';
UPDATE zone SET min_status = 255 WHERE short_name = 'txevu';
UPDATE zone SET min_status = 255 WHERE short_name = 'umbral';
UPDATE zone SET min_status = 255 WHERE short_name = 'uqua';
UPDATE zone SET min_status = 255 WHERE short_name = 'valdeholm';
UPDATE zone SET min_status = 255 WHERE short_name = 'veksar';
UPDATE zone SET min_status = 255 WHERE short_name = 'vergalid';
UPDATE zone SET min_status = 255 WHERE short_name = 'vexthal';
UPDATE zone SET min_status = 255 WHERE short_name = 'vxed';
UPDATE zone SET min_status = 255 WHERE short_name = 'wallofslaughter';
UPDATE zone SET min_status = 255 WHERE short_name = 'westkorlach';
UPDATE zone SET min_status = 255 WHERE short_name = 'westkorlacha';
UPDATE zone SET min_status = 255 WHERE short_name = 'westkorlachb';
UPDATE zone SET min_status = 255 WHERE short_name = 'westkorlachc';
UPDATE zone SET min_status = 255 WHERE short_name = 'yxtta';
UPDATE zone SET min_status = 255 WHERE short_name = 'zhisza';

That will lock down your zones. Just drop this into a .sql file and source it in every time you update. Not as painful as you probably thought.

As for the PVP code, I can't help you there. Sorry.

(These queries also open the old Hate and lock the new one.)

[Producer_BMW]

thank you i needed that but its never goin to happen unless i get server to work