trying to update items

sesmar · #1 12-07-2006, 08:46 AM

The problem with the 13th floor items, at least from pre-DoN to post-DoN was that some of the field mappings had changed. Also the perl script used to read the file did not know how to insert all the fields into the database correctly because of this. Another issue that may arise is using the perl script to insert the 13th floor items into a server using MySql 5. I do not know if this problem has been fixed but the load items script would not work with MySql 5 when I last tried but it would load them into MySql 4 with out a problem.

John Adams · #2 12-09-2006, 06:27 PM

Sesmar, could your mySQL 5 problem related to "strict mode"? Just a thought.

...and I forgot the 13th floor stuff is loaded via perl script. That script would have to be edited to match columns, then. Sounds like it isn't written that way currently.

wraithlord98 · #3 12-10-2006, 01:58 PM

The script wasn't coded to write in the columns because:

1.) Quite a few of the columns from the packet collecting from EQLive are unknowns (they keep changing the data fields ingame)

2.) The emulator dbase schema was incompatible with 13th Floor dbase schema for reason #1.

Keep in mind - both projects are a work in progress - so this may or may not have changed as both projects "evolve".

Also - as stated - the really isn't any need to try and source in the items as ax_peq's dbase already has the most up to date item info in it.