[[mysql|« MySQL Authentification Backend]]

====== phpBB Board ======

Updated for DokuWiki 2006-03-09  --- //[[andrea@gualano.net|Andrea]] 2006-03-14 13:52//

MySQL code is for Version 2 of phpBB and up.
<code php>
$conf['auth']['mysql']['forwardClearPass'] = 1;
$conf['auth']['mysql']['checkPass'] =
       "SELECT user_password AS pass
        FROM phpbb_users
        WHERE username='%{user}'
        AND user_password=MD5('%{pass}')";
$conf['auth']['mysql']['getUserInfo'] =
       "SELECT user_password AS pass, username AS name, user_email AS mail
        FROM phpbb_users
        WHERE username='%{user}'";
$conf['auth']['mysql']['getGroups'] =
       "SELECT group_name AS `group`
        FROM phpbb_groups g, phpbb_users u, phpbb_user_group ug
        WHERE u.user_id = ug.user_id
        AND g.group_id = ug.group_id
        AND u.username='%{user}'";
</code>

Remember however, that users also can't register via the wiki. So you may want to change the register link to the phpBB registration page.

See: [[tips:integrate_with_phpbb]]