I need SQL Queries.
 

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.

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. ;)

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