Admin permissions via db?

[GrendelKhan{TSU]

one of my well-intentioned but poorly executed admins messed up everyone's admin status and messed up some configurations and opened up our private area. no, we weren't hacked. lol.

now I'm a moderator status access only and can't get into admin to fix things. I can access our host, ftp and db... .I just don't know what to do about once I do.

How I do change my admin status via the db or files ?

I'm sure there is a way, but I'm not a programmer so...
HELP!!

[afullcup]

Looking at my database, I can tell you some things I would try to do, but I don't know if I'd be going about it in the correct way or not...

Are you familiar with getting around your database? queries and such?

[GrendelKhan{TSU]

nope. I can look at it via phpmyAdmin...

but no idea what to do from there. :/

[afullcup]

ok... I'll do my best to help in case noone else gets to you tonight...

in phpmyadmin, get to an SQL tab so that you can enter a query and type this:

SELECT usergroupid, title FROM usergroup

then hit Go - that will give you a list of the usergroups and you should find the Administrator group in the list. Get the usergroupid of Administrator and Moderator.

then, run another query (change the 'you' in the query to YOUR username):

SELECT usergroupid, userid FROM user WHERE username = 'you'

that will tell you what usergroup you are currently in. If it shows you as a moderator, then to update it to Administrator, run this query (be sure to change the 1 to the Administrator usergroupid you found in the first query):

UPDATE user SET usergroupid = 1 where username = 'you'

then check to see if that fixed your problem or not.... sure hope it does

[Adrian Schneider]

update user
set usergroupid = 6
where userid = X

Be sure to add yourself to the untouchable admins thinger in config.php from now on to prevent this from happening.

[baronvonwalz]

Agreed.

[GrendelKhan{TSU]

thanks! ..

<< goes to try and proceeds with cautioun. :/

[afullcup]

Originally Posted by SirAdrian

Be sure to add yourself to the untouchable admins thinger in config.php from now on to prevent this from happening.

since you said you are not a coder, thought I'd explain just how to do that...

in your config.php file (which for me is in my includes directory) look for the following:

        //      ****** UNDELETABLE / UNALTERABLE USERS ******
        //      The users specified here will not be deletable or alterable from the control panel by any users.
        //      To specify more than one user, separate userids with commas.
$config['SpecialUsers']['undeletableusers'] = '1,2';

if you don't have that last line in there, add it and make sure your userid is in the list (in this case 1 and 2 are both in the list).

hth

[GrendelKhan{TSU]

Originally Posted by SirAdrian

update user
set usergroupid = 6
where userid = X

Be sure to add yourself to the untouchable admins thinger in config.php from now on to prevent this from happening.

good point. funny thing is.. I thought I did. hmmm...

man heads are gunna roll!! :dead: irate:

Originally Posted by afullcup

ok... I'll do my best to help in case noone else gets to you tonight...

in phpmyadmin, get to an SQL tab so that you can enter a query and type this:

SELECT usergroupid, title FROM usergroup

then hit Go - that will give you a list of the usergroups and you should find the Administrator group in the list. Get the usergroupid of Administrator and Moderator.

then, run another query (change the 'you' in the query to YOUR username):

SELECT usergroupid, userid FROM user WHERE username = 'you'

that will tell you what usergroup you are currently in. If it shows you as a moderator, then to update it to Administrator, run this query (be sure to change the 1 to the Administrator usergroupid you found in the first query):

UPDATE user SET usergroupid = 1 where username = 'you'

then check to see if that fixed your problem or not.... sure hope it does

awesome!! that did it!! THANK YOU!! you are a god among men!!