For God sakes help

[Producer_BMW]

Yeah well someone was helping me get my server the way I wanted it
(DID A bad ass job)



I had to drop the loot tables and ad his

we jimmy rig'ed it a little bit ....
but I thnk i got it


any who heres the problem

when start.bat file Dynamic zone(1) starts and stops like 40 times

and zones WILL not LOAD ...

WHAT THE WORLD is THE problem I had it PERFECT !!

and now I turned it to SHIT



The only other thing I can think of was he wrote some script or something so the PVP range would of 8 levels :( but I dont know what happened

[Producer_BMW]

he did give me some zone files of his to load and eqmem.dll's and world

but I ran thoses but POK Wouldnt work

I asked him to close off all the zones but Kunark and velious



and I cant even sign in :(

[Producer_BMW]

[Producer_BMW]

.bump.........

[Theeper]

I'm guessing your lootdrop_entries table doesn't exist. Check your zone logs for errors.

[trevius]

Or, you have loot tables assigned to NPCs that don't exist. Using individual customized tables from someone else with an existing database is a fairly complex thing to do if you don't know exactly what you are doing. And, it can be time consuming. You need to ALWAYS backup your database before you make any risky changes like that. Then, if something goes wrong, you can revert back easily.

I don't have any good advice for you on this one, other than backing up regularly. The best thing I can think of is for you to create another database and source the normal PEQ loot tables into it fresh, and then copy those loot tables over to your server database. It will revert any loot tables back, but at least it will get everything running again most likely, and you should still have everything else you changed in the other tables.

[So_1337]

If you have a working database backup, then I'd do a restore. If not, the best I can advocate would be to start back with a fresh install of the PEQ database and work from there. To do this without losing your player data:

Download the latest PEQ database release from CVS.

Unzip it. Put drop_system.sql and peqdb_1119a.sql on your desktop.

Go to your Start Menu, Run, then type "cmd" and press enter. Then change directory from there to your desktop: "cd desktop", press enter.

Start MySQL ("mysql -u root -p", hit enter, enter your password, hit enter, "\u peq", hit enter).

"source drop_system.sql", hit enter.

Once that's finished, "source peqdb_1119a.sql", hit enter.

Once that's finished, you should be good to go. See if your server starts from there. If it does, make a backup immediately. If you're unsure how to do this, post back.

One thing I recommend is that instead of splitting too far off from a normal database, that you make sure you can re-do all of your changes every time. If you can't do it by running a few .sql files, then it's going to be very difficult for you to stay updated with future database releases.

I recommend that you start from a fresh PEQ database, and go from there. Things like your server rules and variables won't change, as those tables stay the same. However, if you're careful and make sure you do everything with a query, you can save that query and run it next time. Here's an example of some of the things I run after every time that I update to PEQ's latest push:

### This allows the rogue epic to be equipped in the range slot ###
UPDATE items SET slots = 26624 WHERE name = 'Ragebringer';

### This gives the Robe of Living Fungus regen like in the old days ###
UPDATE items SET regen = 15 WHERE name = 'Robe of Living Fungus';

### Change Circlet of Shadows to Circlet of Shadow ###
UPDATE lootdrop_entries SET item_id = 14730 WHERE item_id = 29400 and lootdrop_id = 3628;
UPDATE lootdrop_entries SET item_id = 14730 WHERE item_id = 29400 and lootdrop_id = 23287;

### Change Fungi Covered Great Staff to Fungus Covered Great Staff ###
UPDATE lootdrop_entries SET item_id = 10895 WHERE item_id = 11058 and lootdrop_id = 410;

### This sets the Evil Eye in Guk to drop the Bag of Sewn Evil Eye 75% and Manastone 25% ###
UPDATE lootdrop_entries SET chance = 75 WHERE lootdrop_id = 18855 and item_id = 17354;
INSERT INTO lootdrop_entries VALUES (18855,13401,1,0,25);

### This removes the NO DROP tag from all items ###
UPDATE items SET nodrop = 1 WHERE nodrop = 0;

### This makes the Ghoul Assassin drop the Guise of the Deceiver rather than the Mask of Deception ###
UPDATE lootdrop_entries SET item_id = 2469 WHERE item_id = 2472;

By doing things that way and with regular backups, you'll make sure that you always have something to go back to. It's a lot more tedious than using GUI interfaces and tools, but you wind up being able to keep current because of it.

Of course, I'm kind of biased towards doing it that way, since it's how I do it =P

[Producer_BMW]

I made a NAvi cat back up when I first put it together

[Producer_BMW]

Thats just it only thing I wanted was ....


8 levels can kill each other up and down
and
Kunark Velious and Pok

thats it

becaus i knew UPdates would be a pain in the dick

[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