The SQL-MOD is the ideal way to execute SQL code right from your ACP.
No need to open phpMyAdmin, no need to run any files. Just copy the code, and hit enter! But because in the wrong hands access to SQL can be a bad thing, the SQL-MOD is password protected, and only those with the password can access the SQL query page.
Instructions: Upon use for the first time, go to the ACP and type in the default password. After doing this, submit the following SQL code. First though, replace PWHASH with a real md5 hash (you can use a site like
this to convert text to md5 strings).
INSERT INTO phpbb_config (config_name, config_value) VALUES ('SQL_MOD_password', 'PWHASH');
Doing this will password protect your SQL-MOD page.
Download this MOD.