zone.exe preforms an illeagal op. when user exits the zone

[izagod]

Heres and odd problem
zone.exe preforms an illeagal op. when user exits the zone,
so say that your in crushbone and you Type #zone hateplane
the zone exe file running the crushbone zone will crash and the one running hate plane will crash, they will all crash after someny people log in and try to zone. im running 4.4dr1 , i cant seem to find any errors other than the tings i saw commonly like error inflate packet some thing bla bla and unknown oppcodes, but i did see that i was missing a few tables ie unkowntable item charges, any way any ideas on this? man i feel like i am full of problems this week

[tcsmyworld]

This is an updated DB using Drawdes DB info.
I added in the items I missed B-4, and turned on the magery for all the spell casting NPC's, the new aggro system is working great.
To use it- from DOS prompt go to MySql\Bin, then
mysqldump yourDB > yourDB.sql
then cut and paste your accounts, characters, character backups, corpses, corpse backups, and faction_values into a file.
then create a fresh DB, source in the included .sql file, then your player info.
I'm including the EXEs I'm using with it on my LAN, virtually trouble free.
Hope it helps.
Note- this is a complete DB just add player info, items are already included.

[Xizz]

All i have to say is THANX for the stuff and i can tell you have alot in the DB thanx man its a good DB helped me out on some issues befor i had to ask hehe

[curtisjm]

perhaps you could assist me...
I am having trouble loading account info into the mysql db.
I follow the command as in the documentation and get the following error:
error: 1057 unknown column `(accountname)` in `field list`

any suggestions on proper syntax on adding this info to the DB?

Many thanx
Curtis

[tcsmyworld]

I just use the Admin tool to add accounts.
make sure you put sequencial ID #'s.
if it's for local play, I start the ID #'s at 1 and the loginserver ID #'s at 0.

[bpogue99]

Very nice DB enhancements tcs... I love the pathing pieces!!!

[loudent2]

edit: misposted

[a_Guest03]

We're still working out the bugs in the databases. The world isn't populated fully or correctly yet.