MyBB Community Forums

It's been one of those days...

I was trying to promote a secondary account of mine to super mod... The name is Jcey, my admin is Jcay lol... Guess what i did...

Yea i done it on my admin account *sigh* worst part is i haven't backed up the database in a few days *slap my hands* yea i know...

Soooo how do i go about fixing this? I'm looking in the database to find where i can change my admin permissions but i can't seem to find it...

Any help is greatly appreciated!

If you save the contents of the code below as a .php file (fix.php for example) and upload it to your forums, it will set the user 'Jcay' as an Administrator.

<?php
define("IN_MYBB", 1);
require "./global.php";
$db->query("UPDATE ".TABLE_PREFIX."users SET usergroup='4' WHERE LOWER(username)='jcay' LIMIT 1");
echo "Done";
?>

Regards,
Chris

Thanks Chris Will this give me full permissions also??

Oooh it looks like it did... You're awesome... You saved me lol... Thanks so much Chris