Class Folks_Driver_sql

Folks storage implementation for PHP's PEAR database abstraction layer.

Required values for $params:

'phptype'       The database type (e.g. 'pgsql', 'mysql', etc.).
     'table'         The name of the foo table in 'database'.
     'charset'       The database's internal charset.

Required by some database implementations:

'database'      The name of the database.
     'hostspec'      The hostname of the database server.
     'protocol'      The communication protocol ('tcp', 'unix', etc.).
     'username'      The username with which to connect to the database.
     'password'      The password associated with 'username'.
     'options'       Additional options to pass to the database.
     'tty'           The TTY on which to connect to the database.
     'port'          The port on which to connect to the database.

The table structure can be created by the scripts/sql/folks_foo.sql script.

See the enclosed file COPYING for license information (GPL). If you did not receive this file, see http://www.horde.org/licenses/gpl.

Folks_Driver

Folks_Driver_sql

Package: Folks
Author: Duck duck@obala.net
Located at Driver/sql.php

Methods summary
`public`	# `__construct( array $params = array() )` Constructs a new SQL storage object. Constructs a new SQL storage object. Parameters `$params` A hash containing connection parameters.
`public`	# `deleteOnlineUser( mixed $user )` Remove user if is online Remove user if is online
`public`	# `getUsers( mixed $criteria = array(), mixed $from = 0, mixed $count = 0 )` Get users by attributes Get users by attributes
`public`	# `countUsers( mixed $criteria = array() )` Count users by attributes Count users by attributes
`public`	# `updateComments( string $user, mixed $reset = false )` Update user comments count Update user comments count Parameters `$user` Username `$reset`
`public`	# `getViews( )` Get user groups Get user groups
`public boolean`	# `userExists( string $user )` Check if user exist Check if user exist Parameters `$user` Username Returns `boolean`
`public boolean`	# `addUser( string $user, array $credentials )` Adds a set of authentication credentials. Adds a set of authentication credentials. Parameters `$user` $userId The userId to add. `$credentials` The credentials to use. Returns `boolean` true\|PEAR_Error

Methods inherited from Folks_Driver
`changePassword(), comparePassword(), deleteActivity(), deleteImage(), deleteSavedSearch(), deleteUser(), factory(), getActivity(), getAttributes(), getConfirmationCode(), getCookie(), getNewUsers(), getOnlineUsers(), getProfile(), getRandomUsers(), getRawProfile(), getRecentVisitors(), getSavedSearch(), getSearchCriteria(), isOnline(), logActivity(), logView(), resetOnlineUsers(), saveAttributes(), saveProfile(), saveSearch(), updateOnlineStatus()`

Packages

Classes

Class Folks_Driver_sql

Parameters

Parameters

Parameters

Returns

Parameters

Returns