ArkiwiAPI/arav_up_users/sqliteusers.php

<?php

$db = sqlite_open("arav_up_users/arav_users.sqlite");
$query = "SELECT users.username AS user,
	   users.password AS password,
	   users.email AS email,
	   groups.dir AS DIR,
	   groups.usergroup AS groupname
	   FROM users, groups
	   WHERE groups.usergroup = users.usergroup";

$result = sqlite_query($db, $query);

while ($row = sqlite_fetch_array($result)) {
    $user = $row['user'];
    $ft['users'][$user]= array(
			       'password' => $row['password'],
			       'group' => $row['groupname'],
			       'email' => $row['email']
			       );
    $ft['groups'][$row['groupname']] = array(
					     'DIR' => $row['DIR'],
					     );   
    //    print_r($ft);
}
sqlite_close($db);
?>