Can someone link me a newer DB then peq has on its website?

[WarDave522]

The issue I'm having with the one from the website is I'm stuck in every zone, cant move. Someone else said I need to grab the latest db from the svn here http://code.google.com/p/projecteqemu/source/browse/#svn/trunk/EQEmuServer/utils/sql/svn%3Fstate%3Dclosed

But I thought the db was just one big file not all of those? So do I just source every sql file in or does someone have a link to them all in one sql file?

Thanks in advance

[Jaekob]

Here is the latest version. If you want changes past that point you will have to source them in.

http://code.google.com/p/projecteqdb/downloads/list

[WarDave522]

Yea that appears the be one I used when I did the server install the other day. So thats the one thats giving me issues already. Thanks for trying to help.

[blackdragonsdg]

Revision 1589 is an older database. Revision 1667 is the newest one. You can download it here: http://projecteqdb.googlecode.com/svn/trunk/

A character that is stuck in the game world...meaning you can not run around at all as soon as you enter the game. That problem is a missing update between your database revision and your emulator revision.

Make a mental note of your database revision number then go here: http://projecteqemu.googlecode.com/svn/trunk/EQEmuServer/utils/sql/svn/

Download and source in all updates with a number higher than your database revision but less than or equal to your emulator revision.

[WarDave522]

Ok so I tried to find something that would let me source in all sql files in one folder and someone pointed me to this

http://stackoverflow.com/questions/2458571/run-multiple-sql-files-in-mysql-batch

But on my windows machine it doesnt work for some reason

I tried

for %S in (*.sql) do mysql -u user_name database_name < %S

and

mysql -u user_name -p password database_name < file.sql

with the correct info in the username, and db and all of that


What I'm trying to do is have mysql souce in all the sql files with one command so I don't have to do it 139 times from the svn folder. Also yes I changed over to the correct folder in a dos box before trying this and did,

mysql -u root -p
(did password)
use peq;

then tried those lines

[lerxst2112]

Just source load_player.sql from the correct directory and it will source all the rest of the necessary files. It does this by relative directory, so you need to be in the right place when you start, and you need to have unzipped the file with the directories intact.

Open it in a text editor and you'll see how it works.

[WarDave522]

Nevermind I think I have figured it out, thanks for the help