Lost my admin status!

[4thdesign]

Guys,

I made a boo boo.

In my admin panel, i changed my status to member by accident (doing things too quickly and not reading properly)

I am guessing that i wont be able to undo what i have done or give myself admin access unless i go into phpmyadmin. So my question is this, where or what on phpmyadmin do i need to do to make myself an admin again?

Thanks for your help in advance :)

[Dave]

Go into PHPMyAdmin and run this command >

[mysql]UPDATE users SET user_level=2 WHERE userid=1;[/mysql]

Replace the userid if your not ID 1 :)

[4thdesign]

Brilliant....dead easy when you know how. I even looked at the table and was expecting to see an admin field....FAIL !

Thanks again ;)

[Redex]

For future reference, you could just go into the phpmyadmin and go into the users table and click browse. Look for your name and then click it too edit and edit user_level to 2 i think.

[Jordan Palmer]

When I first started coding I made this mistake 6-7x a day LOL; Easy enough fixed though :)

[Guest cablebox]

Haha! Not really that difficult to fix without putting in a command :P Just do what Redex said

[Jordan Palmer]

Or simply

 

In header.php

$db->query("UPDATE users SET user_level=2 WHERE userid=1");

 

Not too hard now xD

[shedh]

Or simply

 

In header.php

$db->query("UPDATE users SET user_level=2 WHERE userid=1");

 

Not too hard now xD

I wouldn't do that, it's pointless! Why would you run a query every page load that updates one specific field over and over again?

[Zero-Affect]

Or simply

 

In header.php

$db->query("UPDATE users SET user_level=2 WHERE userid=1");

 

Not too hard now xD

I wouldn't do that, it's pointless! Why would you run a query every page load that updates one specific field over and over again?

simply goto myphpadmin and input the following into the SQL

[mysql]

UPDATE `users` SET `user_level` = 2 WHERE `userid` = 1

[/mysql]

David did say this on like the 2nd post...

[Jordan Palmer]

Yes shedh, I know but it was one of many examples, When I first started coding I'm pretty sure I did something like that ^_^...