User authentication with Phorum.

Tested on Phorum version 5.1.24b and DokuWiki version 2007-06-26b.
Update on 2008/12/07: works fine with Phorum 5.2.8 and DokuWiki 2008-05-05.

This assumes that all user accounts will be created and maintained through Phorum.

Do not forget to either create a “user” group in Phorum, or to add the name of the Phorum user group in the conf/acl.auth.php file.

Eventually, change the table prefix in the queries below (here it is phorum5).

$conf['auth']['mysql']['checkPass'] =
    "SELECT password AS pass
    FROM phorum5_users
    WHERE username='%{user}'
    AND password=MD5('%{pass}')";
 
$conf['auth']['mysql']['getUserInfo'] =
    "SELECT password AS pass, username AS name, email AS mail
    FROM phorum5_users
    WHERE username='%{user}'";
 
$conf['auth']['mysql']['getGroups'] =
    "SELECT name AS `group`
    FROM phorum5_groups g, phorum5_users u, phorum5_user_group_xref ug
    WHERE u.user_id = ug.user_id
    AND g.group_id = ug.group_id
    AND u.username='%{user}'
    AND ug.status='1'";

— Yann Cochard 2007-11-22 22:22