1<?php
2/**
3 * Default settings for the authdrupal7 plugin
4 *
5 * @author Matthias Jung <matzekuh@web.de>
6 */
7
8$conf['charset']          = 'utf8';
9$conf['server']           = 'localhost';
10$conf['user']             = '';
11$conf['password']         = '';
12$conf['database']         = '';
13$conf['debug']            = 0;
14$conf['drupalPrefix']     = '';
15$conf['drupalRoot']       = '../';
16
17$conf['TablesToLock']     = array();
18
19$conf['checkPass']        = 'SELECT pass FROM %{drupal_prefix}users WHERE name=\'%{user}\'';
20$conf['getUserInfo']      = 'SELECT name, mail FROM %{drupal_prefix}users WHERE name=\'%{user}\'';
21$conf['getGroups']        = 'SELECT roles.name FROM %{drupal_prefix}users users INNER JOIN %{drupal_prefix}users_roles userroles INNER JOIN %{drupal_prefix}role roles WHERE users.uid = userroles.uid AND roles.rid = userroles.rid AND users.name = \'%{user}\'';
22$conf['getUserCount']     = 'SELECT COUNT(*) AS num FROM %{drupal_prefix}users WHERE status = 1';
23