It's better when it's simple

User Tools

Site Tools


« MySQL Authentification Backend

phpBB Board

Updated for DokuWiki 2006-03-09 — Andrea 2006-03-14 13:52

MySQL code is for Version 2 of phpBB and up.

$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}'";

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: integrate_with_phpbb

auth/mysql_phpbb.txt · Last modified: 2011-03-22 17:26 by Aleksandr

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki