Give myself admin priviledges in phpBB 3 [closed]

Question

I have inherited a broken phpBB installation. It has posts and forums, but the user table is a mess.

I need to know what columns I can change in which tables to give myself full administrator privileges so that I can start using the web interface to make appropriate changes to the user table.

So far I have tried

update
  phpbb_users
set
  user_permissions = 'a_'
where
  username LIKE 'administrator@mysite.com'

But when I log in I still cannot see any of the forums and there's no options on the phpBB web page to make changes.

How do I give myself full administrator privileges?phpBB

Answer 1

Okay I had to do the following:

update
  phpbb_users
set
  user_permissions = ''
  ,user_type = '3'
  ,group_id = '5'
where
  username LIKE 'administrator@mysite.com'

Now I have access to the administrator control panel.