auth:mysql_vbulletin
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
auth:mysql_vbulletin [2013-01-16 23:37] – 89.15.117.188 | auth: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: | ||
- | |||
- | If your vBulletin install is using table prefix such as " | ||
- | |||
- | Note that all user/group management, registration, | ||
- | |||
- | |||
- | <code php> | ||
- | <?php | ||
- | $conf[' | ||
- | |||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | |||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | FROM user | ||
- | WHERE LOWER(username)= LOWER(' | ||
- | AND MD5(CONCAT(MD5(' | ||
- | |||
- | |||
- | |||
- | |||
- | $conf[' | ||
- | FROM user | ||
- | WHERE LOWER(username)=' | ||
- | $conf[' | ||
- | FROM usergroup g, user u | ||
- | WHERE u.username = LOWER(' | ||
- | AND ((g.usergroupid = u.usergroupid) | ||
- | OR FIND_IN_SET(g.usergroupid, | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | FROM user | ||
- | WHERE LOWER(username) =' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | $conf[' | ||
- | FROM usergroup | ||
- | WHERE title=' | ||
- | </ | ||
- | |||