PDA

View Full Version : World data 0.95, 0.3.2 compatible


Drawde
05-23-2002, 06:13 AM
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
05-23-2002, 06:30 AM
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_
05-23-2002, 06:32 AM
Great work Drawde! And fast too :)

flipper
05-23-2002, 06:37 AM
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
05-23-2002, 06:58 AM
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
05-23-2002, 08:35 AM
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_
05-23-2002, 09:01 AM
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
05-23-2002, 09:02 AM
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_
05-23-2002, 10:37 AM
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
05-23-2002, 12:29 PM
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
05-23-2002, 12:40 PM
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
05-23-2002, 05:15 PM
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
05-23-2002, 05:30 PM
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
05-23-2002, 11:03 PM
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
05-26-2002, 02:17 AM
Woot, Drawde.

Strikingbeast
05-26-2002, 06:12 AM
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
05-26-2002, 01:20 PM
Keep up the good work.

wurmslayer2k
05-26-2002, 01:32 PM
That is a very nice DB. All the /ooc Any mobs???? Have finally left my server :p

Drawde
05-27-2002, 01:34 AM
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
05-27-2002, 01:58 AM
0.3.2 npc_types did have a problem (coded problem). its fixed in 0.3.3.

Phantom
05-27-2002, 10:37 AM
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
05-27-2002, 12:29 PM
This looks like an awesome database...but when will it be 3.3.1 compatible?:confused:

Lurker_005
05-27-2002, 01:23 PM
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
05-27-2002, 01:57 PM
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
05-27-2002, 02:33 PM
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
05-27-2002, 02:54 PM
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
05-27-2002, 03:01 PM
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
05-27-2002, 05:23 PM
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
05-27-2002, 06:24 PM
: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
05-27-2002, 06:26 PM
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
05-27-2002, 09:19 PM
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
05-28-2002, 01:29 AM
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)