HashPassword($password); $userid = dbInsert(array('username' => $username, 'password' => $encrypted, 'level' => $level, 'email' => $email, 'realname' => $realname, 'can_modify_passwd' => $can_modify_passwd, 'descr' => $description), 'users'); if ($userid == false) { return false; } else { foreach (dbFetchRows('select notifications.* from notifications where not exists( select 1 from notifications_attribs where notifications.notifications_id = notifications_attribs.notifications_id and notifications_attribs.user_id = ?) order by notifications.notifications_id desc', array($userid)) as $notif) { dbInsert(array('notifications_id'=>$notif['notifications_id'],'user_id'=>$userid,'key'=>'read','value'=>1), 'notifications_attribs'); } } return $userid; } else { return false; } } function user_exists($username) { global $config; $query = 'SELECT COUNT(*) FROM `users` WHERE `username`=?'; $params = array($username); if (isset($config['http_auth_guest'])) { $query .= ' OR `username`=?'; $params[] = $config['http_auth_guest']; } return dbFetchCell($query, $params) > 0; } function get_userlevel($username) { global $config; $user_level = dbFetchCell('SELECT `level` FROM `users` WHERE `username`=?', array($username)); if ($user_level) { return $user_level; } if (isset($config['http_auth_guest'])) { return dbFetchCell('SELECT `level` FROM `users` WHERE `username`=?', array($config['http_auth_guest'])); } return 0; } function get_userid($username) { global $config; $user_id = dbFetchCell('SELECT `user_id` FROM `users` WHERE `username`=?', array($username)); if ($user_id) { return $user_id; } if (isset($config['http_auth_guest'])) { return dbFetchCell('SELECT `user_id` FROM `users` WHERE `username`=?', array($config['http_auth_guest'])); } return -1; } function deluser($username) { // Not supported return 0; } function get_userlist() { return dbFetchRows('SELECT * FROM `users`'); } function can_update_users() { // supported so return 1 return 1; } function get_user($user_id) { return dbFetchRow('SELECT * FROM `users` WHERE `user_id` = ?', array($user_id)); } function update_user($user_id, $realname, $level, $can_modify_passwd, $email) { dbUpdate(array('realname' => $realname, 'level' => $level, 'can_modify_passwd' => $can_modify_passwd, 'email' => $email), 'users', '`user_id` = ?', array($user_id)); }