auth:mysql_phpbb
« 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