World data 0.95, 0.3.2 compatible

[Drawde]

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

[flipper]

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==

[_OZZY_]

Great work Drawde! And fast too :)

[flipper]

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==

[stormgod]

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 )

[Sh1nj1]

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!

[_OZZY_]

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.

[Lurker_005]

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

[_OZZY_]

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.

[Arcalyn]

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.

[Lurker_005]

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.

[Arcalyn]

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

[astemus]

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

[kachime]

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

[Ariak]

Woot, Drawde.

[Strikingbeast]

Does sourcing in this database overwrite any items you have made? I'd like to know because I made a full set of uber items, and I don't want them to get erased ;)

[Ariak]

Keep up the good work.

[wurmslayer2k]

That is a very nice DB. All the /ooc Any mobs???? Have finally left my server :p

[Drawde]

My DB addon won't overwrite any custom items, as it doesn't have any item data in it. However it will overwrite all NPC, merchant, loot and tradeskill data (rebuilddb.sql deletes the old data before sourcing in the new data) so back these up if there's any custom data you want to keep.

[Shawn319]

0.3.2 npc_types did have a problem (coded problem). its fixed in 0.3.3.

[Phantom]

hmm.. i tried every which way ... best I get is all mobs at 0,0 :(

Any db out there compatible with 331 that has zones like sleeper, tov, vp, etc spawned?

Thanks :)

[bot403]

This looks like an awesome database...but when will it be 3.3.1 compatible?:confused:

[Lurker_005]

Source the file in this zip into your 3.2 DB and it will work with 3.3.1

*edit* !@#$!@$ typos the , at the end of each line should be ;

The attached file is fixed.

[MDK]

Source the file in this zip into your 3.2 DB and it will work with 3.3.1

ERROR 1064: You have an error in your SQL syntax near 'table spawn2 add column d
_meele_texture1 int(10) unsigned NOT NULL default '0',
' at line 2

[bot403]

but it doesnt work. THere i said it, now let me be more descriptive. I am using Linux and MySQL 3.23.47 and i get errors that are rampant and they go like this
ERROR 1062 at line 3812 in file: 'merchantlist.txt': Duplicate entry '246-29' fo
r key 1

I assume something is wrong with the way the tables are defined? i dont know enough to fix it. The faction list also had lots of errors and i tried removing the unique tag on the name key and that SEEMED to work, i have yet to find a database that will fully import. Are you all using MS Sql or what? cause i have yet to find a database file that is compatible with my mysql database. If you give me some pointers on whats wrong maybe i can be of assistance for correcting these databases.

*EDIT*
P.S. some of it seems to be tpyos, like this

INSERT INTO merchantlist VALUES (244,24,1318); # bone gloves
INSERT INTO merchantlist VALUES (244,25,4317); # dark scale greaves
INSERT INTO merchantlist VALUES (244,26,6404); # staff of writhing
INSERT INTO merchantlist VALUES (244,27,1355); # robe of enshroudment
INSERT INTO merchantlist VALUES (244,28,11666); # bone girdle
INSERT INTO merchantlist VALUES (246,29,10357); # ring of shadows

I assume that last 246 meant to be a 244 because they all seem to be grouped like that

also some appear like this

INSERT INTO merchantlist VALUES (252,12,2703); # griffon wing spaulders
INSERT INTO merchantlist VALUES (252,13,29063); # ring of the chameleon
INSERT INTO merchantlist VALUES (252,14,10336); # platinum armband
INSERT INTO merchantlist VALUES (252,13,19818); # symbol of Rodcet
INSERT INTO merchantlist VALUES (252,14,5366); # Kilij

where that second identifier is repeated(13 in this case) ive been trying to shift the whole group down to look like this

INSERT INTO merchantlist VALUES (252,12,2703); # griffon wing spaulders
INSERT INTO merchantlist VALUES (252,13,29063); # ring of the chameleon
INSERT INTO merchantlist VALUES (252,14,10336); # platinum armband
INSERT INTO merchantlist VALUES (252,15,19818); # symbol of Rodcet
INSERT INTO merchantlist VALUES (252,16,5366); # Kilij

etc. etc...
can anyone tell me if this will break some sort of identifier dependency somewhere else in the database. I am only 7 hours new to eqemu and dont quite know how the database tables are supposed to relate to one another.

[Phantom]

I used the 3.2 original "clean" db and then I sourced the go.sql. After that I sued Lurker "converter" and it works fine.

However, most zones are not spawned :( I wish he would make a 311 to 331 converted :)

[bot403]

what database program are you using? i am doing the same thing, with a clean DB everytime and slowly *trying* :( to correct errors. I completely drop the eq database then i source the go.sql so it can source all the other files at once.

maybe those errors i described above are caused by the program automagically generating the code?

bugs in the progam?

i think somehow the program used to generate these databases isnt aware of all the differences bewtween different databases and how the keys are used and such, maybe if we figured this out it could mean leaps and bounds for the database portablility and ease of use.

just a hypothesis

[Lurker_005]

The 3.2 to 3.2 converter is fixed, see the post above....

Bot403,
The DB I posted is a compaliation from others. they have the typo's and duplicate entries in them also. Import with the continue on errors option. Also you just need to run go.sql from an empty DB, it does all the rest.

Phantom see the attached for a 3.1 to 3.3 converter

I didn't put it in the 3.1 to 3.3 converter, But I am pretty sure you will have to delete any current characters...

[bot403]

:rolleyes: this may sound dumb....but whats the mysql syntax for continuing on errors, im not sureif i know what you;re talking about.

Oh yea, i deleted duplicate entries, re-worded some stuff, deleted primary keys fromtable definitions, and now the DB i was works. BTW i was smart enough to correct your typos in your conversion file. I feel dumb now seeing how simple the conversion was. I havent tried your continue on error method but its probably safer then removing primary keys from table definitions ;)

On a side note, do boats work?
Antoher side note... does anyone have a database where i will zone into and out of the proper spots, i seems to be put in the center of the zone all the time.

[O6scured]

ok the 3.1 to 3.3 converter.... I just need to sourse the .sql with that .zip? or do I need to dl the 3.2 world then run the converter? or am I completely off?

[Halflink_playa]

I got problem: I create a clean Db named EQ.

mysql> use eq
mysql> source db.sql
mysql> source rebuilddb.sql

and I get error 1136 : Column count doesn't match value count at row 1

I have no idea what this means, can anyone help me out?

[Lurker_005]

O6scured,
If you have an old 3.1 DB you want to use with the 3.3 emu, unzip the sql file and source it into the 3.1 DB to make it 3.3 compliant.

Halflink_playa,
0.95 was made for the 3.2 DB format. You can use the default 3.2 DB.sql that came with eqemu 3.2. Do what you posted, then source the 3.2 to 3.2 sql I posted earlier in this thread.

Bot,
When sourcing file inside mysql it continues on errors by default (windows version...) or from the command line mysql -f [database] < file.sql And you may feel dumb for how easy it was to correct, imagine how I feel for posting it that way :p and boats do not work (no moving spawns work for that matter)