[Bitsys]

Originally posted by Darkwaltz4
hmm...bitsys, one of the things i was wanting to do was be able to display the 'enlarged' summon pic in a postbit variable....so..how would i select the itemtype along with all the items in that large query in showthread.php?

I've tried it before and it is nearly impossible to combine it into one query due to the variability of the columns in the items_user table.

Ideally, you would want to left join the item id in the items_user table with the item id in the items table and then left join the item's cat id with the cat id in the items_cats table. Once that is done, you could pull the battletype of the item category. However, since there isn't an easy way of knowing the column names in the items_user table before querying the database, then it makes it rather difficult. I know of a way, combining the SELECT COUNT(*) query just before the huge query, but that would increase the server load a littl emore, and I don't know if it is worht it.

If that didn't make sense, then let me know.