Class: LiveUser_Admin_Auth_Container_DB

The second parameters expects an array containing the parameters for the given container.

Say you have a conf array like that

 'authContainers' => array(

     array(
         'type'          => 'DB',
         'loginTimeout'  => 0,
         'expireTime'    => 3600,
         'idleTime'      => 1800,
         'allowDuplicateHandles' => 0,
         'authTable'     => 'users',
         'authTableCols' => array(
             'user_id'       => 'auth_user_id',
             'handle'       => 'handle',
             'passwd'     => 'passwd',
             'lastlogin'    => 'lastlogin',
             'is_active'     => 'is_active',
             'owner_user_id'     => 'owner_user_id',
             'owner_group_id'     => 'owner_group_id'
         )
     )
 ),

This class expects only the array containing configuration options of the auth container you wish to administrate. This is done in case you have several DB based auth containers.

See PEAR::DB documentation for DSN specifications.

 $conf =

     array(
         'type'          => 'DB',
         'loginTimeout'  => 0,
         'expireTime'    => 3600,
         'idleTime'      => 1800,
         'passwordEncryptionMode' => 'MD5',
         'allowDuplicateHandles' => 0,
         'authTable'     => 'users',
         'dsn'           => 'type://user:pass@host/database',
         'authTableCols' => array(
             'user_id'    => 'auth_user_id',
             'handle'     => 'handle',
             'passwd'     => 'passwd',
             'lastlogin'  => 'lastlogin',
             'is_active'  => 'is_active',
             'owner_user_id'  => 'owner_user_id',
             'owner_group_id' => 'owner_group_id'
         )
     );
 
 $obj = new LiveUser_Admin_Auth_Container_DB($conf);

Parameters:

Parameters:

The array will look like this:

 $userData[0]['auth_user_id'] = 'wujha433gawefawfwfiuj2ou9823r98h';

             ['handle']       = 'myLogin';
             ['passwd']       = 'd346gs2gwaeiuhaeiuuweijfjuwaefhj';
             ['lastlogin']    = 1254801292; (Unix timestamp)
             ['is_active']    = 1; (1 = yes, 0 = no)
             ['owner_user_id']    = 1;
             ['owner_group_id']   = 1;

Filters can be either complex or simple.

In their simple form you just need to pass an associative array with key/value, the key will be the table field name and value the value you are searching. It will consider that you want an do to do a field=value comparison, every additional filter will be appended with AND

The complicated form of filters is to pass an array such as

array( 'fieldname' => array('op' => '>', 'value' => 'dummy', 'cond' => ''), 'fieldname' => array('op' => '<', 'value' => 'dummy2', 'cond' => 'OR'), );

It can then build relatively complex queries. If you need joins or more complicated queries than that please consider using an alternative solution such as PEAR::DB_DataObject

Any aditional field will be returned. The array key will be of the same case it is given.

$cols = array('myField');

e.g.: getUsers(null, $cols) will return

 $userData[0]['auth_user_id'] = 'wujha433gawefawfwfiuj2ou9823r98h';

             ['handle']       = 'myLogin';
             ['passwd']       = 'd346gs2gwaeiuhaeiuuweijfjuwaefhj';
             ['myField']      = 'value';

Parameters:

Parameters:

Parameters: