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

[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

[Eikinskjaldi]

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

$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;

[Dismounted]

Or upload tools.php from your do_not_upload folder.