OMG im stupid, please help!! Locked out of admin cp

[Eikinskjaldi]

Originally Posted by rip9001

Hello,

Oh man, I am so stupid....i am the superadmin of my site and the only person with access to the admin cp and i went ahead and tested my paid subscriptions through the site and it downgraded me to a premier club member and now wont give me any access to the admincp

How in the heck do i resolve this issue? Im going crazy right now

Just how superadminy were you? It's alsway been my understanding that if you drop your userid into config.php

PHP Code:

$config['SpecialUsers']['undeleteableusers'] = 1; //or whatever your userid is 


Then you cannot accidentally do this to your self. I could be wrong though.

Anyway, assuming you have some kind of database access either from the commandline or some crutch like phpmyadmin,

select usergroupid, title from usergroup;

Find out which usergroup is the admin group (lets assume 6), and then continuing to assume your userid =1...

update user set usergroupid=6 where userid=1;