PDA

View Full Version : Dumpeditems.sql Question


Driggz
01-24-2005, 07:07 AM
I have read through the forums but can not find much recent info on this. I am trying to update my items table with the latest dumpeditems.sql. (http://www.eqemulator.net/dumpeditems.sql.gz) There are some additional field names (like distiller and collected_inst_id) that are not in the general PEQ release. It appears as it they were mapped to some of the unknown### fields, but it is not clear which ones. Does anyone know where I can get the correct cross-mapping schema so I can modify the import script? Or, do you know if there is a compatable items update (that refreshes regularly) online anywhere? I am running the latest PEQ release and 6.0 DR2.

I am already having some instances of new item effects showing as unknown, and this may only make this more common. However, if at all possible, I want to write a quick program to pull the new item dump, change it from an INSERT to an UPDATE, and source the data. Any help on the field data would be appreciated.

Thanks,