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 'email@example.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