For God sakes help
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 |
how ever
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 :( |
here
|
.
.bump.........
|
I'm guessing your lootdrop_entries table doesn't exist. Check your zone logs for errors.
|
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. |
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: Code:
### This allows the rogue epic to be equipped in the range slot ### Of course, I'm kind of biased towards doing it that way, since it's how I do it =P |
I backed up
I made a NAvi cat back up when I first put it together
|
Uh huh
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 |
Code:
### These queries lock down the zones for the sake of progression ### As for the PVP code, I can't help you there. Sorry. (These queries also open the old Hate and lock the new one.) |
ya
thank you i needed that but its never goin to happen unless i get server to work
|
All times are GMT -4. The time now is 07:39 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.