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,