Getting the newest CVS 6.1 to work with your database!

[Sarepean]

(This is a guide for people upgrading from 6.0DR2 to 6.1DR1)

First of all, you will need to have a compiled 6.1DR1 from the CVS. (Sunday, May 08, 2005)

Projecteq.net is down currently, but you will need their Velious database release.

EDIT:: There are some incompatibilities column wise with the kunark database. Until I figure out exactly what they are and how to resolve them, you will have to go with the velious database. Sorry.


1. In the mysql command line, type source load_system.sql and wait for that to finish.

2. Now source load_empty_users.sql and wait for that.

Okay, now most of the hard stuff is done. Here is where it gets a little strange because this is what I did and it may not exactly be right.

Now, get these files:
http://cvs.sourceforge.net/viewcvs.p...rt.sql?rev=1.2
http://cvs.sourceforge.net/viewcvs.p...ems.pl?rev=1.2
http://cvs.sourceforge.net/viewcvs.p...ql?rev=1.1.2.1
http://cvs.sourceforge.net/viewcvs.p...FG.SQL?rev=1.2
http://eqitems.13th-floor.org/download/items.zip

type these exactly:
source items-0.6.0-DR2-0.6.1-DR1-convert.sql;
source 0.6.1-upgrade.sql
source ZONECFG.SQL
delete from items;


This is where it gets a little weird. I did this for Windows XP and the way I did it is a little hazy.

Go to Start -> Run --- ppm

install dbi
install dbd-mysql

Now, from command prompt in the same directory as the loading script from earlier (should also have the item.txt file unzipped in the directory)

perl load_13thfloor_items.pl -d db -u user -p password <items.txt

And that should do it.

If there are any problems, drop a message.

[Belfedia]

Very good guide

[steelrat]

The install itself went perfectly..but, on loading world.exe it reports too many items.. says to increase the max in items.. C++ is an alien language to me :(( so if anyone could help here it would be nice

SR

[Belfedia]

Are you sure, you don't forget the delete from items; before use perl script ?

[rmcgraw1]

from what i can tell you are changeing the items from mysql to perl

what directory does the load_13thfloor_items.pl have to be in for it to work???

[steelrat]

Originally Posted by rmcgraw1

from what i can tell you are changeing the items from mysql to perl

what directory does the load_13thfloor_items.pl have to be in for it to work???

I put it into the Perl directory, it worked from there..

SR

[steelrat]

Originally Posted by Belfedia

Are you sure, you don't forget the delete from items; before use perl script ?

No, Bel.. I did the delete from items; thing.
and once I ran the items.txt it unpacked fine, it's just on running world.exe I get the "too many items" crash

SR

[Belfedia]

Strange i follow the guide and i have no problem :(
Perhaps same thing than DR3, bug are random ?
Hopping a Stable release for few time (go go go Devs :p)

[mikeGreen]

ok i got everything write except for the last line....

i am presuming on

perl load_13thfloor_items.pl -d db -u user -p password <items.txt


where it says db and user and password i put mine in there, Right? so i do and i get a mysql syntax error"check your manuel blah blah"
I am puting this in the mysql cmd.

if i put in
perl load_13thfloor_items.pl -d db -u user -p password <items.txt
as is i get alittle arrow thingie so i add a ;
then i get error. If i am doing something wrong please tell me

[steelrat]

Originally Posted by mikeGreen

ok i got everything write except for the last line....

i am presuming on

perl load_13thfloor_items.pl -d db -u user -p password <items.txt


where it says db and user and password i put mine in there, Right? so i do and i get a mysql syntax error"check your manuel blah blah"
I am puting this in the mysql cmd.

if i put in
perl load_13thfloor_items.pl -d db -u user -p password <items.txt
as is i get alittle arrow thingie so i add a ;
then i get error. If i am doing something wrong please tell me

open a cmd.. cd to your perl dir.. then run command

[rmcgraw1]

thanks i got it missed a step started over with a backup works fine now

[mikeGreen]

yep going right now thanks somehow i forgot to save that file and was thinking item.txt was that file.......

[mikeGreen]

ok well it worked except now world crashes everytime it starts loading items....

anyone else have this problem or now how to fix it?

[mikeGreen]

ok just got my problem......Item editor messed it up

[Belfedia]

Don't forget than many program may be, not working with the last DB release and last EQEMU release. If you aren't skilled in EQEMU, wait for the Stable release who come in few time i hope
If you follow (and understanding) step by step instruction of this thread for make your DB that work !
If don't work, search your error