DokuWiki

It's better when it's simple

User Tools

Site Tools


auth:mysql_invision

This is an old revision of the document!


« MySQL Authentification Backend

InvisionBoard

:!: Untested with new MySQL backend

If you want to hook-up DokuWiki to authenticate with an InvisionBoard forum (MySQL code is for Version 2 of InvisionBoard and up) (for users) then you can use the following:

$conf['auth']['mysql']['passcheck']= "SELECT name AS 'login'
                                        FROM ibf_members, ibf_members_converge
                                       WHERE ibf_members.id=ibf_members_converge.converge_id
                                         AND name='%u'
                                         AND converge_pass_hash = MD5(CONCAT(MD5(converge_pass_salt),MD5('%p')))";
$conf['auth']['mysql']['userinfo'] = "SELECT name, email AS mail
                                        FROM ibf_members
                                       WHERE name='%u'";
$conf['auth']['mysql']['groups']   = "SELECT ibf_groups.g_title as `group`
                                        FROM ibf_members, ibf_groups
                                       WHERE ibf_members.mgroup=ibf_groups.g_id
                                         AND ibf_members.name='%u'";

Remember however, that users can't register via the wiki. So you may want to change the register link to the InvisionBoard registration page.

Does anyone know how to get the integration with the new MySQL backend?

New MySQL backend

The following queries seems to work with Invision Board 2 and the new MySQL backend. Remember to replace table names with the good prefix (ipb_ or ibf_) :

$conf['auth']['mysql']['checkPass']= "SELECT name AS 'login'
                                        FROM ipb_members m LEFT JOIN ipb_members_converge c ON c.converge_id=m.id
                                       WHERE name='%{user}'
                                         AND converge_pass_hash = MD5(CONCAT(MD5(converge_pass_salt),MD5('%{pass}')))";
$conf['auth']['mysql']['getUserInfo'] = "SELECT name, email AS mail
                                        FROM ipb_members
                                       WHERE name='%{user}'";
$conf['auth']['mysql']['getGroups']   = "SELECT mgroup as `group`
                                        FROM ipb_members
                                       WHERE ipb_members.name='%{user}'";
auth/mysql_invision.1300811185.txt.gz · Last modified: 2011-03-22 17:26 by Aleksandr

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