<?php
/**
 * e107 configuration for MySQL Auth Plugin
 * See https://www.dokuwiki.org/plugin:authmysql:e107 for details and explanation
 */

// Activate MySQL auth plugin
$conf['authtype'] = "mysql";    // Set authentication backend to MySQL
$conf['passcrypt'] = "my411";   // password encryption my411 or mysql 
//$conf['passcrypt'] = "mysql"; //   (depending on the version of your MySQL DB)

$conf['plugin']['authmysql']['TablesToLock']= 
      array("e107_user", "e107_user AS u", "e107_userclass_classes");

$conf['plugin']['authmysql']['checkPass']   = 
     "SELECT user_password AS pass
      FROM e107_user
      WHERE user_loginname='%{user}'";

$conf['plugin']['authmysql']['getUserInfo'] = 
     "SELECT user_password AS pass, user_name AS name, user_email AS mail
      FROM e107_user
      WHERE user_loginname='%{user}'";

$conf['plugin']['authmysql']['getGroups']   = 
     "SELECT userclass_name as `group`
      FROM e107_user, e107_userclass_classes
      WHERE FIND_IN_SET(e107_userclass_classes.userclass_id, e107_user.user_class) <> 0
      AND e107_user.user_loginname='%{user}'
      UNION
      SELECT 'admin' AS  `group`
      FROM e107_user AS u
      WHERE user_admin <> 0
      AND user_loginname='%{user}'
      UNION
      SELECT 'user' AS `group`";