# authsqlite
Authentication mechanism for DokuWiki that uses an SQLite database for
its data store.

This is heavily plagiarismed from authpgsql, because the two database
engines support a similar SQL syntax.

Configuration is similar to PostgreSQL.  In addition to the configuration
options for PostgreSQL, authsqlite allows the %{animal} parameter in all
sql statements.  %{animal} is the animal component of a wiki farm setup,
and corresponds to the folder where the animal's configuration and data
files live.

This is the configuration for a farm, where a single authentication
database contains all of the user information, but group membership is
different for each animal.

	$conf['plugin']['authsqlite']['checkPass'] =
		'SELECT pass FROM usergroup AS ug
		JOIN user AS u ON u.uid=ug.uid
		JOIN groups AS g ON g.gid=ug.gid
		WHERE u.login=\'%{user}\'
			AND g.name=\'%{dgroup}\'';
	$conf['plugin']['authsqlite']['getUserInfo'] =
		'SELECT pass, fullname AS name, email AS mail
		FROM user WHERE login=\'%{user}\'';
	$conf['plugin']['authsqlite']['getGroups'] =
		'SELECT g.name AS \'group\' FROM groups g, user u,
		usergroup ug WHERE u.uid = ug.uid
			AND ug.animal=\'%{animal}\'
			AND g.gid = ug.gid AND u.login=\'%{user}\'';
	$conf['plugin']['authsqlite']['getUsers'] =
		'SELECT DISTINCT u.login AS user FROM user AS u
		LEFT JOIN usergroup AS ug ON u.uid=ug.uid AND ug.animal=\'%{animal}\'
		LEFT JOIN groups AS g ON ug.gid=g.gid';
	$conf['plugin']['authsqlite']['FilterLogin'] = 'u.login LIKE \'%{user}\'';
	$conf['plugin']['authsqlite']['FilterName'] = 'u.fullname LIKE \'%{name}\'';
	$conf['plugin']['authsqlite']['FilterEmail'] = 'u.email LIKE \'%{email}\'';
	$conf['plugin']['authsqlite']['FilterGroup'] = 'g.name LIKE \'%{group}\'';
	$conf['plugin']['authsqlite']['SortOrder'] = 'ORDER BY u.login';
	$conf['plugin']['authsqlite']['addUser'] =
		'INSERT INTO user (login, pass, email, fullname)
		VALUES (\'%{user}\', \'%{pass}\', \'%{email}\', \'%{name}\')';
	$conf['plugin']['authsqlite']['addGroup'] =
		'INSERT INTO groups (name) VALUES (\'%{group}\')';
	$conf['plugin']['authsqlite']['addUserGroup'] =
		'INSERT INTO usergroup (uid, gid, animal) VALUES (%{uid}, %{gid}, \'%{animal}\')';
	$conf['plugin']['authsqlite']['delGroup'] = 'DELETE FROM groups WHERE gid=%{gid}';
	$conf['plugin']['authsqlite']['getUserID'] =
		'SELECT uid AS id FROM user WHERE login=\'%{user}\'';
	$conf['plugin']['authsqlite']['delUser'] = 'DELETE FROM user WHERE uid=%{uid}';
	$conf['plugin']['authsqlite']['delUserRefs'] = 'DELETE FROM usergroup WHERE uid=%{uid}';
	$conf['plugin']['authsqlite']['updateUser'] = 'UPDATE user SET';
	$conf['plugin']['authsqlite']['UpdateLogin'] = 'login=\'%{user}\'';
	$conf['plugin']['authsqlite']['UpdatePass'] = 'pass=\'%{pass}\'';
	$conf['plugin']['authsqlite']['UpdateEmail'] = 'email=\'%{email}\'';
	$conf['plugin']['authsqlite']['UpdateName'] = 'fullname=\'%{name}\'';
	$conf['plugin']['authsqlite']['UpdateTarget'] = 'WHERE uid=%{uid}';
	$conf['plugin']['authsqlite']['delUserGroup'] =
		'DELETE from usergroup WHERE uid=%{uid} AND gid=%{gid} AND animal=\'%{animal}\'';