The following config can be used with the MySQL backend to authenticate users against a VBulletin forum.

If your vBulletin install is using table prefix such as “vb_” then you need to modify the sql queries and prepend the prefix to table names.

Note that all user/group management, registration, and removal sql values are set to empty string “” or commented out. Use vBulletin to manage users/groups/etc.

<?php
$conf['authtype']    = 'mysql';
 
$conf['auth']['mysql']['server']   = 'localhost';
$conf['auth']['mysql']['user']     = 'forum';
$conf['auth']['mysql']['password'] = 'forumpass';
$conf['auth']['mysql']['database'] = 'forum';
 
$conf['auth']['mysql']['debug'] = 0;
$conf['auth']['mysql']['forwardClearPass'] = 1;
$conf['auth']['mysql']['TablesToLock']= array();
$conf['auth']['mysql']['checkPass']   = "SELECT username AS login
                                           FROM user
                                          WHERE LOWER(username)= LOWER('%{user}')
                                            AND MD5(CONCAT(MD5('%{pass}'),salt)) = password";
 
 
 
 
$conf['auth']['mysql']['getUserInfo'] = "SELECT username AS name, email AS mail
                                           FROM user
                                          WHERE LOWER(username)='%{user}'";
$conf['auth']['mysql']['getGroups']   = "SELECT g.title AS `group` 
                                           FROM usergroup g, user u
                                          WHERE u.username = LOWER('%{user}')
                                            AND ((g.usergroupid =  u.usergroupid)
                                             OR FIND_IN_SET(g.usergroupid, u.membergroupids))";
$conf['auth']['mysql']['getUsers']    = "";
$conf['auth']['mysql']['FilterLogin'] = "";
$conf['auth']['mysql']['FilterName']  = "";
$conf['auth']['mysql']['FilterEmail'] = "";
$conf['auth']['mysql']['FilterGroup'] = "";
$conf['auth']['mysql']['SortOrder']   = "";
$conf['auth']['mysql']['addUser']     = "";
$conf['auth']['mysql']['addGroup']    = "";
$conf['auth']['mysql']['addUserGroup']= "";
$conf['auth']['mysql']['delGroup']    = "";
$conf['auth']['mysql']['getUserID']   = "SELECT userid AS id
                                         FROM user
                                         WHERE LOWER(username) ='%{user}'";
$conf['auth']['mysql']['delUser']     = "";
$conf['auth']['mysql']['delUserRefs'] = "";
$conf['auth']['mysql']['updateUser']  = "";
$conf['auth']['mysql']['UpdateLogin'] = "";
$conf['auth']['mysql']['UpdatePass']  = "";
$conf['auth']['mysql']['UpdateEmail'] = "";
$conf['auth']['mysql']['UpdateName']  = "";
$conf['auth']['mysql']['UpdateTarget']= "";
$conf['auth']['mysql']['delUserGroup']= "";
$conf['auth']['mysql']['getGroupID']  = "SELECT usergroupid AS id
                                         FROM usergroup
                                         WHERE title='%{group}'";