0.3.3.1 database

[Sh1nj1]

Does anyone know of any 0.3.3.1 compatable database with spawned mobs and loot, etc. like drawde's or anything along those lines?

-Sh1nj1

[Lurker_005]

eqemu3.2_DB_test.zip (http://home.earthlink.net/~dpuch/misc/eqemu3.2_DB_test.zip) should work fine.

Also you can use drawdes 0.95 on a 3.2 DB then run the file I just posted at the end of the post to convert it to 3.3.1 compatable.

Drawde's 0.95 DB thread (http://forums.eqemu.net/showthread.php?s=&threadid=2094)

Load the default 3.2 eqemu DB source in drawde's DB data, then source the 3.2_to_3.2.sql file I posted.

[stormgod]

lurker can you convert a full database and email it to me ? I will host the file on my site (would be great if you can do this , and even more great if you could do it like drawdes do for 0.95 ie without destroying accounts ;) ) I actually have a 100megs website with 2.1Gbds of bandwith so I am wasting it for the moment lol

pm me if you need some info

[Phantom]

hmmm... error 1064 when running the "converter" .sql :(

[Phantom]

btw, on your eqemu3.2_DB_test.zip, should we source db.sql, and go.sql, or db, go and msh? What's the correct sequence? ;)

... nm that, I run db.sql and then go.sql and I got some zones correctly spawned.

on others, like ToV, i pop on a "box" :(

[rollain]

yeah, same here.

"error 1064: you have an error in your sql syntax naer table spawn2 add column d at line 2"

[bot403]

see my post here... im having some troubles

http://forums.eqemu.net/showthread.php?s=&postid=12172#post12172

[Lurker_005]

Ahh smack me.

the typos in the 3.2 to 3.3 converter are fixed.

Phantom,
you just need to source go.sql

Stormgod,
The test DB I posted is a full 3.3 compatable DB just not in 1 file. But you only have to source go.sql Also if I get my DB updated and cleaned up the way I want... we shall see.

Bot, see the other thread

[Sh1nj1]

here is what i did:

drop database eq33;
create database eq33;
source db.sql;
source rebuilddb.sql;
source 3.2_to_3.3.sql;

the db.sql that i used was from db 3.2, on another note i had to open 3.2_to_3.3.sql in a text editor and fix all the "," and replace them with ";" so that mysql can source it.

it all goes well until it comes to logging into the server, when i log in i crash back to desktop.

here is a screenshot of it:

[bot403]

i've noticed strange crashes too. The way i (strangely) fixed it was that the first character i created on a server NEVER EVER worked...then i simply created a second and used him. Puzzled me for hours, i thought my server was bad.

[Sh1nj1]

rofl, thats funny as hell, but that still means something IS wrong, imagine the other guy on the other side of the server trying to connect, if he connects and drops to desktop you think he'll wanna come back and log into your server? maybe he'll go for a diff one, so that means that its not in no way a fix :mad:, but i am gonna go try it now hehe

edit: tried it, and it still isnt working heh, oh well, gonna keep on playing around with it till i get it working :D