I want users to have option to reset their experience and other stats with a click of button from their user options in RPG Integration hack, I already know the SQL command for it, but have no idea how I would get it working directly from the board...
Just tried it in phpMyAdmin and it worked nicely.
It would be this one:
PHP Code:
UPDATE user SET maxhp=0, hp=0, maxpp=0, pp=0, maxma=0, ma=0, ap=0, xp=0, alignment=0, rpgrace=0, element=0, rpgclass=0, rpggender=0, rpgtype=0, inbattle=0 WHERE userid='$bbuserinfo[userid]'
But I need a way to get it to the update profile page so they just need to click a button and it resets their character.
Sorry for being stupid. :/