[Revan]

Originally Posted by Ganon

When I try to edit options for the itemshop, I get this error:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE rpg_items_options SET refund='.75',onofforder='0',minstock='4',maxstock= '7',stockreset='604800',pcost='',padd='',hidelevel ='0'
mysql error: Unknown column 'pcost' in 'field list'

mysql error number: 1054

Date: Thursday 26th of August 2004 09:58:41 PM
Script: http://www.ganonstower.com/forums/admincp/itemadmin.php
Referer:
Username: Ganon
IP Address: xx.x.xxx.xxx

There is also nothing on the board that lets you buy items or anything like that. I'm guessing there's probably another query I missed, or something like that?

This is a bug in the itemadmin.php, summit I left out when I was cleaning out the installer and forgot to check for files actually using those fields...
New itemadmin.php attached, and zip updated.
This itemadmin.php also fixes the "Items doesnt show for edit" bug (which automatically solved the "each()" bug).

Originally Posted by fade

getting this problem as well. had a look around and also found problems with joining a clan. you can send an "invite" to users to join clans and that user will receive a pm, the link to accept the invitation doesn't appear to have the full url, it starts as "http://clancp.php....." also, when i actually go to play a battle, it simply times out (for me and the other player) reporting a time out error message

any ideas would be great

The clancp stuff was a small mishap on my side, just open clancp.php and find [php][URL=clancp.php[/php]
change to
[php][URL=http://your.forum/url/clancp.php[/php]
zip updated with this, also readme updated.

About the timeout errors (both of them), that is impossible to determine and fix. I have just tried the battle AND update rpg info, reinstalled with the newest installer. I assure you I made no hotfixes to my files, and I used all the php files in the current zip.
This is a server side problem, Im sure of it... sorry...
My friend DeMiNe0 suggests that you could try putting turk MM cache on your server or php accell.
Just dont ask me what any of that means

Originally Posted by Ganon

A member on my board is trying to get into the "edit RPG info" link in her User CP. It goes incredibly slow and eventually times out. She gave me permission to log into her account, to see if it's a problem with her account or her computer, and I had the same problem. It works fine for me under my name, and a couple test names I have set up on the board. Any suggestions?

You should try running the DB Fix. Her id might not show in the record and for some reason this times the script/browser out.
If its not that, then theres no solution.



To summarize for those reading this, the changes in the zip now is:
itemadmin.php errors fix
chancp.php bug fix
readme updated (added recommended values for Modifiers in the Edit Options of the Battle category)