I need SQL Queries.

[elite pl0x]

Could someone whip me up SQL queries for the following:


Making somebody a ROOT administrator. I need to make a friend a ROOT administrator. I lost my FTP information, and I cant wait 2 days. Im leaving soon.
Making somebody an administrator. I know I can do this via Usermanager, but I am looking to do this for multiple users, in one query.


Thanks.

[Dismounted]

1) I'm guessing root admin means super admin? If so, you cannot do that via any type of SQL query, the changes must be done to config.php.

2) You will find a field called "usergroupid" in the user table. ;)

[Marco van Herwaarden]

Don't try to do it with a manual query, you are very likely to cause problems. Just do it from the AdminCP.