[deathemperor]

I tested and found two errors:


1st is database error:
you said that you cant make the posting results, so I wonder what is this for

".TABLE_PREFIX."rpg_battle_options.postresults,".TABLE_PREFIX."rpg_battle_options.battleforum,

it should be removed or when opening rpg.php it will show db error.
one more thing with this script

LEFT JOIN ".TABLE_PREFIX."user ON ".TABLE_PREFIX."user.userid=$userid

it doesn't understand $userid, if I replace it with 1, it's fine of course, I think the solution is replace $userid with $bbuserinfo['userid'], didn't test yet

and:

when I came to clans.php, it show a blank page, came to clans.php?action=view it show a database error ( cant remember, I'm away from my PC).

and the templates as far as I've seen they weren't well-made, this could be easy changed. The manner things should be verify is the code since I'm not sure what to do when errors occurs.

The spells, apart from causing HP/MP, is it possible to causes status ?

I think you should have made it a beta testing board, problems occurs this way it's hard for you to verify --> fix all