EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   World data 0.95, 0.3.2 compatible (https://www.eqemulator.org/forums/showthread.php?t=1912)

Strikingbeast 05-26-2002 06:12 AM

item overwriting?
 
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

3.3.1 compatible?
 
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

Quote:

Originally Posted by Lurker_005
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

not to bash your hard work....
 
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

converters
 
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?


All times are GMT -4. The time now is 07:00 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.