====== Phorum ======

User authentication with [[http://phorum.org/|Phorum]].

Tested on Phorum version 5.1.24b and Dokuwiki version 2007-06-26b.

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 prfix in the queries below (here it is **phorum5**).

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

</code>

 --- //[[yann@cactuspro.com|Yann Cochard]] 2007-11-22 22:22//