RPG Integration Hack - Old Support Thread

Nice conversion there mate, lot of work has gone into it so well done and thanks for sharing it

[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?

[Rahzel_hx]

lol the pictures show up for the background images but there is writing in the top right of the screen that is all... ( everything is in the right place.. soo i dunno but it don't affect anything so it ok)

hmm i will try in IE.... right now i use myie2 and i don't get sound =(

[fade]

Originally Posted by Valr the Slain

When in "Edit Items", the items seem to not show up for me to edit. There isn't any errors listed, but when I click "Update Items", I receive this error:

Warning: Variable passed to each() is not an array or object in /home/initial/public_html/forums/admincp/itemadmin.php on line 292

The line 292 contains the following:

PHP Code:

while (list($key,$val) = each($name) AND list($key,$val2) = each($cat) 


What could be the problem?

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

Fatal error: Maximum execution time of 30 seconds exceeded in /home/sites/site93/web/forum/battlefight.php on line 706

any ideas would be great

[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?

[Valr the Slain]

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?

This is also a situation that I have been wondering what the problem was. I took the same actions as Ganon and came up with the same results. She once had an error similar to fades, but it was a fatal error to the db_mysql.php file. Unfortunately, I don't have the line anymore.

[ogetbilo]

I reinstalled RPG and I did all the changes that I have to do in the service pack for the showthread.php , profile.php etc...

The only thing that is not working is admncp/itemadmin.php
When I go to admincp and try to edit items I cannot see any item so I cannot edit items.
Also when I try to update Itemshop settings I get the following error.

Database error in vBulletin 3.0.3:

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

mysql error number: 1054

Date: Friday 27th of August 2004 01:06:04 PM
Script: http://forum.*****.com/admincp/itemadmin.php
Referer: http://forum.*****.com/admincp/itema...action=options
Username: ****
IP Address: *******

I hope this will be the latest bug in this mod.Cause it is one of the best.

[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)

[oldfan]

How stable is this addon?
I wanna install it, but I'm reading about alot of errors.
Or is that user end errors?
Thanks, lookin good

[Revan]

AFAIK theres no more bugs left.
IF you should discover any new bugs, I can 99 % guarantee it will be fixed/explained within 24 hours, usually as soon as I check back on this thread and read the error report (depending on the details of your report of course).

Actually the only trivial "bug" left is this warning notice that seems to appear on the adding of midi's, but it works 100 % so dont worry about that


If you do install it now, then please click the install button

[designstylez]

Having some problems with itemshop.php...

When I click on Expand All Generic Items, it works. But when I click on Expand for Available Weapons or Available Accessories, nothing happens. It does not expand.

But anyways, this RPG thing is tite!!! I Love it!