well i got Drawde's db and i think im going about wrong on installing it into the game but heres what i did, and see if anyone can spot out where i went wrong.
1) i backedup the old db.sql and deleted it from the eqemu folder and mysql folder
2) i opened sql and deleted the database "eq"
3) i put in Drawde's new db into the eqemu folder and the mysql/bin foler and opened mysql again, created a new databast named "eq" and then closed it again
4) i opened mysql.exe and typed: use eq
source db.sql
(everything went fine, no beeps throughout the process, totally smooth)
5) i opened up the server again and got this:
Using database 'eq' at localhost
Loading items & NPC's...DB Query Error
Error #1054: Unknown column 'banish' in 'field list'
Error in LoadNPCTypes query 'SELECT id, name, level, race, class, hp, gender, texture, helemtexture, size, loottable_id, merchant_id, banish, mindmg, maxdmg, npcspecialattks FROM npc_types' #1054: Unknown column 'banish' in 'field list'
done.
after all that it still connected like normal
but when i go onto my server and create a char, it beeps a couple times and just kinda freezes and have to exit
anyone see something im doing wrong?
|