World data 0.95, 0.3.2 compatible
 

http://www.innersystems.com/~drawde/worlddata0.95.zip
Since EQEmu 0.3.2 has a different npc_types structure (some values such as walkspeed and fixed_z have been removed), making my old DB incompatible, I thought I'd release a new one ASAP (just needed to delete a few lines in the EQNPC code)
As well as working with the latest EQEmu version, this release has some Velious spawns, with many of the outdoor zones nearly complete and Kael and Thurgadin partially done. It also has tradeskill data for jewellery, smithing, tailoring, pottery, baking and brewing, though many of the racial recipes are missing (due to missing items in the DB).
These things are all "work in progress" though so are probably fairly buggy.

To install it you just need to unzip the file into your mysql/bin directory, run mysql.exe, type "use eq" then "source rebuilddb.sql". This will delete any data for NPCs, loot etc that's already in the DB, so if you're using any other data you'd need to source the files seperately.
If anyone wants me to also make a full db.sql with my data in, I will, but I thought that this method would reduce the file size and make merging with other DBs easier.

I also updated my EQNPC program as usual - http://www.innersystems.com/~drawde/eqnpc.zip

Heya Drawde,

I think your link above should be...

http://www.innersystems.com/~drawde/worlddata0.95.zip

instead of

http://www.innersystems.com/~drawde/worlddata0.9.zip


==Flipper==

Great work Drawde! And fast too :)

You can say that again Oz. I think I suffered whiplash on that release :D

Thanks Drawde. Despite what the other eqmu board dwellers say... you're an all around good guy.

==Flipper==

dunno if its from the db or the emu but when using your db drawde I have this error when loading :
Error #1054: Unknown column 'd_meele_texture1' in 'field list'
(zone server error)

Edit : (seems to work fine though )

Drawde, i for one would want the full database with your work in it, if its not too much to ask for, hehe, thanks in advance!

I would also like that full db.sql. I iuse it as a base and tweak it to my own liking. It's just easier.

Installing this is really not that hard!

Replace the database names eq31 and eq32 with what ever you use.

copy db.sql from eqemu 3.2 zip to c:\mysql\bin directory
copy all files from drawde's 0.95 zip to c:\mysql\bin directory

run mysql

Optionally drop an old database
mysql>drop database eq31;

mysql>create database eq32;
mysql>use eq32;
mysql>source db.sql;
mysql>source rebuilddb.sql;
mysql>exit

your done!

You can delete the files you copied into c:\mysql\bin, or just leave them there till you install a newer DB

The only differance is that you have to source 2 files instead of 1

Previously you had to drop tables and a few other things to get Drawde's to work. Apparently, now, that is no longer the case. Previously, it was easier to just source Drawde's db.sql rather than fight the individual files. Now, it doesn't make a difference. It's just as easy either way.

Clarification
 

Lemme get this hammered out properly.......

With his DL'ed files I can go in and modify the .txt files to create a more PERSONALIZED npc spawn db.sql to source into mysql?

Huge file and it looks kinda ugly to do but thats not the point.

All the DB's are just text files, so if you know enough about the DB structure you can edit anything at all with just a text editor.

So in other words yes it is easy to edit it, but no it isn't easy to do more than a few small things without using tools like the admin tool, search and replace functions, ect.

Zone server crashing????
 

This is the error message I get when I click Enter World:

1st Attempt:
2002/05/24 04:35:38 GMT: Zone 7996 crashed. Errorcode: 4/3. Current zone loaded:freportw. Current clients:1. Caused by: Joffin_Sinclay00

2nd Attempt:
2002/05/24 04:59:58 GMT: Zone 7996 crashed. Errorcode: 4/3. Current zone loaded:freportw. Current clients:1. Caused by: Palon_Deskeb00

Checklist:

Publiclogin setup --------------- OK
Standard DB setup ------------- OK
EQW Login & Play --------------- OK

sourcing drawde's .95 db ----- OK ****
(hafta return with the few error messages)
EQW Login & Play --------------- Zoneserver crashes & Closes
IP maybe?
start zoneNT . 127.0.0.1 7995 127.0.0.1
start zoneNT . 127.0.0.1 7996 127.0.0.1
start zoneNT . 127.0.0.1 7997 127.0.0.1
start zoneNT . 127.0.0.1 7998 127.0.0.1
start zoneNT . 127.0.0.1 7999 127.0.0.1

sourcing lurker's db ------------ OK ****
(hafta return with the few error messages)
EQW Login & Play --------------- Zoneserver crashes & Closes
IP maybe?
start zoneNT . localhost 7995 127.0.0.1
start zoneNT . localhost 7996 127.0.0.1
start zoneNT . localhost 7997 127.0.0.1
start zoneNT . localhost 7998 127.0.0.1
start zoneNT . localhost 7999 127.0.0.1

Gonna try and log into login.eqemu.net and ask someone with a populated world how they got it to work. **No luck**
But......
eqlogin.eqemu.net --------------- OK
sourcing lurker's db -------------- OK (few error messages)
World.exe -------------------------- OK
Zones ------------------------------- OK
Login & Play through eqlogin.eqemu.net on my worldserver & zones ---- OK

Maybe its just publiclogin?

But if anyone has a clue WTF I'm doin wrong I'd appreciate any help/tips.

ps. Running WindowsXP Pro

I got a database working kind of, i started with a fresh database and sourced the included db first, then loaded the db lurker just gave us that was edited to work for now. It works except the starting items are messed up, but you can snip that out if you know how, out of the sql file before sourcing. The old db's don't work because of the mentioned reasons... zones are id'd by numbers now, and a couple other table changes. if you have these columns and try to run the server, you can't get a zone server running. Just lettin everyone know. D/L Lurker's db he posted yesterday for now until people come out with a more complete DB. Hope that helps

(edit)

Hehe, realized i posted this under the wrong db ;) But i like lurker's db more, altho drawde has better spawn info. This db is great tho, i just sourced the original db.sql, then sourced in lurker's release(with the starting items errors and all), and then sourced this in. it replaces only what i wanted. spawn info, starting item(heh), and misc other stuff that wasn't complete in lurker's edition. You world builders are doing a great job, i like the file releases, because you can source in the table or tables you want only, and mix and match. very very good work guys, keep the releases coming

once more i say
*NEWBIE ALERT!*

heh
how do i use the EQNPC stuff? the readme doesn't exactly state that...

and when i run the exe it just crashes (the program that loads does, not my comp :p thankfully, thats already in need of repair..)

Edit: got it running (the DB, the NPC thing i still don't get) :) minus a few NPC's with the wrong skins (easy fix from within game) it runs great.
although, some NPC's are spawning in odd spots..

question, will Horses ever work? :p

Woot, Drawde.