'sha1', 'conf' => array( 'select-user' => ' SELECT id AS uid, username AS user, username AS name, password AS hash, email AS mail FROM fluy_users WHERE username = :user ', 'select-user-groups' => ' SELECT g_title AS `group` FROM fluy_groups G, fluy_users U WHERE U.id = :uid AND U.group_id = G.g_id ', 'select-groups' => ' SELECT g_id AS gid, g_title AS `group` FROM fluy_groups ', 'insert-user' => ' INSERT INTO fluy_users (group_id, username, password, email) VALUES (0, :user, :hash, :mail) ', 'delete-user' => ' DELETE FROM fluy_users WHERE id = :uid ', 'list-users' => ' SELECT DISTINCT username AS user FROM fluy_users U, fluy_groups G WHERE U.id = G.g_id AND G.g_title LIKE :group AND U.username LIKE :user AND U.username LIKE :name AND U.email LIKE :mail ORDER BY username LIMIT :limit OFFSET :start ', 'count-users' => ' SELECT COUNT(DISTINCT username) AS `count` FROM fluy_users U, fluy_groups G WHERE U.id = G.g_id AND G.g_title LIKE :group AND U.username LIKE :user AND U.username LIKE :name AND U.email LIKE :mail ', 'update-user-info' => '', // we can't do this because username = displayname 'update-user-login' => ' UPDATE fluy_users SET username = :newlogin WHERE id = :uid ', 'update-user-pass' => ' UPDATE fluy_users SET password = :hash WHERE id = :uid ', 'insert-group' => ' INSERT INTO fluy_groups (g_title) VALUES (:group) ', 'join-group' => ' UPDATE fluy_users SET group_id = :gid WHERE id = :uid ', 'leave-group' => ' SELECT 1 ', // we do a no-op for this ), 'users' => array( array( 'user' => 'admin', 'pass' => 'pass', 'name' => 'admin', 'mail' => 'admin@example.com', 'grps' => array( 0 => 'Administrators', ), ), array( 'user' => 'test1', 'pass' => 'password', 'name' => 'test1', 'mail' => 'test1@example.com', 'grps' => array( 0 => 'test', ), ), ), );