[VeoMorphine]

Originally posted by Riddel
Oh, another thing to ask: I don't know if this might help any in pinpointing the problems/errors I'm getting (item shop not working), but even though there are members with 1000+ posts, the itemshop only allows them to purchase level 0 item. However, when I tried to purchase a level 0 item, I received a databse error:


Database error in vBulletin 2.2.9:

Invalid SQL: SELECT userpostcount,levelfield,exprate FROM battle_options
mysql error: Unknown column 'userpostcount' in 'field list'

mysql error number: 1054

Date: Tuesday 28th of January 2003 08:54:20 AM
Script: /metropolis/itemshop.php?action=buy&cat=1&item=Javelin&itemtyp e=0
Referer: http://www.zanarkand.net/metropolis/...l=1&itemtype=0


I think this error might be contained only to the itemshop since members' stats are looking normal, so I'm guessing that I probably messed up the code somewhere. Would uploading a fresh copy of itemshop.php help, or are there other files I will need to upload?

Btw, thanks a lot for helping us out! This hack is really awesome.

It looks to me like one of the querys did not run on the install. Try re-running the install script and make it recreate the battle_options table. Make sure it creates it with the userpostcount, levelfield, and exprate collums.