Yeah, definitely dont plan on hard coding that crap, aiming to move all that crap out of SQL into lua, just didnt want to have to deal with all the extra crap from that version
For example, all the extra items for ninja/pirates that appear in the tq database. Another thing that was quickly relevant with the cq_itemtype table when comparing it to the itemtype.dat of the 4300~ client around 2.0 was that all the armor/hats have an item id for each of the dye colours, where the cq_itemtype table does not, so a lot of the items, for armors/hats, dont match up.