db->queryOneRecord("SELECT client.limit_client FROM sys_user, client WHERE sys_user.userid = $userid AND sys_user.client_id = client.client_id"); if($client['limit_client'] > 0) { return true; } else { return false; } } //** This function adds a given group id to a given user. public function add_group_to_user($userid,$groupid) { global $app; $userid = intval($userid); $groupid = intval($groupid); if($userid > 0 && $groupid > 0) { $user = $app->db->queryOneRecord("SELECT * FROM sys_user WHERE userid = $userid"); $groups = explode(',',$user['groups']); if(!in_array($groupid,$groups)) $groups[] = $groupid; $groups_string = implode(',',$groups); $sql = "UPDATE sys_user SET groups = '$groups_string' WHERE userid = $userid"; $app->db->query($sql); return true; } else { return false; } } //** This function removes a given group id from a given user. public function remove_group_from_user($userid,$groupid) { global $app; $userid = intval($userid); $groupid = intval($groupid); if($userid > 0 && $groupid > 0) { $user = $app->db->queryOneRecord("SELECT * FROM sys_user WHERE userid = $userid"); $groups = explode(',',$user['groups']); $key = array_search($groupid,$groups); unset($groups[$key]); $groups_string = implode(',',$groups); $sql = "UPDATE sys_user SET groups = '$groups_string' WHERE userid = $userid"; $app->db->query($sql); return true; } else { return false; } } } ?>