DokuWiki

It's better when it's simple

User Tools

Site Tools


auth:mysql_vbulletin

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
auth:mysql_vbulletin [2013-01-16 23:37] 89.15.117.188auth:mysql_vbulletin [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
Line 1: Line 1:
-[[mysql|« MySQL Authentification Backend]] 
- 
-====== vBulletin 3.5+ ====== 
- 
-The following config can be used with the [[auth: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. 
- 
- 
-<code php> 
-<?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}'"; 
-</code> 
- 
  

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki