FUDforum

This assumes that all user accounts will be created and maintained through FUDforum.
Newer FUDforum Versions uses fud26 as table prefix.

<?php/**
* Options to configure for a FUDforum database
* http://fudforum.org/
*//**
* Turn off registration on DokuWiki
*/$conf['openregister']=0;/**
* Set the signature for all users
*
* This signature will link to the user's FUDforum profile. To make this work
* correctly, add the following line to the conf/interwiki.conf file. Be sure
* to replace "forum.example.org" with the hostname for your FUDforum
* installation. You may need to modify the path to index.php if you installed
* FUDforum in a directory other than root. This also assumes you have
* PATH_INFO style URLs turned on in FUDforum.
*
* user http://forum.example.org/index.php/u/{PATH}/
*
* If you are not using PATH_INFO style URLs in FUDforum, use the following
* format in interwiki.conf:
*
* user http://forum.example.org/index.php?t=usrinfo&id={URL}
*
* Note that this relies on the getUserInfo query below that stores the user
* id in the `mail` field instead of the actual e-mail address.
*/$conf['signature']='//[[user>@MAIL@|@NAME@]] @DATE@//';/**
* Database connection parameters; change these for your environment
*/$conf['auth']['mysql']['server']='';$conf['auth']['mysql']['user']='';$conf['auth']['mysql']['password']='';$conf['auth']['mysql']['database']='';/**
* Send password in clear text to database
*/$conf['auth']['mysql']['forwardClearPass']=1;/**
* Authenticate user by checking password
*/$conf['auth']['mysql']['checkPass']="SELECT passwd as `pass`
FROM fud_users
WHERE login='%{user}'
AND passwd=MD5('%{pass}')";/**
* Get user info
*
* Note the use of "id AS `mail`". Instead of retrieving the user's email
* address, I'm getting the ID for use with the user's DokuWiki signature
* (see note on $conf['signature'] above). If you do not wish to use this
* signature and would rather get the e-mail address, use "email" instead of
* "id" in the query below.
*/$conf['auth']['mysql']['getUserInfo']="SELECT passwd AS `pass`, login AS `name`, id AS `mail`
FROM fud_users
WHERE login='%{user}'";/**
* Get groups to which user belongs
*
* Note the use of the UNION. This allows all registered users to be a member
* of the default group (as defined in $conf['defaultgroup']) without the
* need to create a new group in FUDforum. Other groups may be created in
* FUDforum for "admin," etc.
*/$conf['auth']['mysql']['getGroups']="SELECT fud_groups.name AS 'group'
FROM fud_groups, fud_users, fud_group_members
WHERE fud_users.id = fud_group_members.user_id
AND fud_groups.id = fud_group_members.group_id
AND fud_users.login='%{user}'
UNION
SELECT '".$conf['defaultgroup']."' as `group`";?>