Code: Select all
mysql > update [phpbb_]sessions set session_admin = 1 where session_user_id = [your_user_id];
Code: Select all
+----------------------------------+-----------------+---------------+
| session_id | session_user_id | session_admin |
+----------------------------------+-----------------+---------------+
| 7a29df126154e4e8ab0918f917c1dd04 | 2 | 0 |
+----------------------------------+-----------------+---------------+
Code: Select all
+----------------------------------+-----------------+---------------+
| session_id | session_user_id | session_admin |
+----------------------------------+-----------------+---------------+
| 7a29df126154e4e8ab0918f917c1dd04 | 2 | 1 |
+----------------------------------+-----------------+---------------+
SQL query:
mysql > UPDATE [phpbb_]sessions SET session_admin =1 WHERE session_user_id = [NBJF]
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql > update [phpbb_]sessions set session_admin = 1 where session_user_id = [N' at line 1
Error
SQL query:
UPDATE phpbb_sessions SET session_admin =1 WHERE session_user_id = NBJF
MySQL said: Documentation
#1054 - Unknown column 'NBJF' in 'where clause'
Access to the Administration Control Panel is not allowed as you do not have administrative permissions.
Code: Select all
select session_id, session_user_id, session_admin from [phpbb_]sessions;
Code: Select all
delete from [phpbb_]sessions where session_user_id = 2;
Code: Select all
select session_id, session_user_id, session_admin from [phpbb_]sessions;