accidently promoted all users to writer...including myself

I accidently promoted all users to writers, including the admin account. How can I fix this?


THANKS!
-Pat

Originally Posted by oates151

I accidently promoted all users to writers, including the admin account. How can I fix this?


THANKS!
-Pat

lol phpmyadmin ftw

Where though? Like where is all the user info kept and how would I go about editing it specifically?

Originally Posted by oates151

Where though? Like where is all the user info kept and how would I go about editing it specifically?

If you don't know how, I wouldn't make any changes to the database directly using phpmyadmin then. You can hose your database and wreck your install I honestly couldn't tell you a fast way to fix your problem, other than going in by hand and tagging groups of people and changing them through the admin panel.

:P All I want to do is change one user back to admin - the rest can stay writers, that was my original intent.

Originally Posted by oates151

:P All I want to do is change one user back to admin - the rest can stay writers, that was my original intent.

***Backup your database FIRST**** ****DO THIS AT YOUR OWN RISK****
*** I AM NOT RESPONSIBLE*** *** I HAVE NO IDEA WHAT I AM DOING ***
*** PROCEED AT YOUR OWN RISK AND PERIL!!****
Ok now that we have the "legal" portion out of the way.

install phpmyadmin (in ubuntu it's easy it's like sudo apt-get install phpmyadmin) then you go to the ip address of that box for instance: http://192.168.1.5/phpmyadmin/ in a web browser. Login at root and the password (whatever you made the root password for) if you are on a hosted solution somewhere they will probably need to install phpmyadmin or may already have it installed (it's very common). Login with the info they gave you.



go into phpmyadmin and and browse the user database (called users) and find the user ID of your admin account.

once you get that number

Now go to the Group table.
browse it and you will see all your levels of privileges. Find the one that says Admin (unless you renamed it something else, then find what you renamed it to) Next to it there is an ID number. On mine it is 2.

Go into the GroupUser table and browse that.
Find the user_id that matches your admin's user_id. Click on the pencil to EDIT that GroupUser with that user_id.

Now change the GROUP_ID field from whatever number it is to the ID number that was in the Group Table (mine was 2).

then click go.

restart mysql and apache2 (If you are running linux) just to make sure nothing is cached (I don't think this is necessary but I'm throwing it in there for shits and giggles).

Hope that helps you out bud.

P.S. I've never done this before, this is just what I would do if I had access to the database and wanted to hack admin priveleges. I have no idea if it will work. But I'm about 90% sure it will. Please msg back and tell me how it worked.