while ($fieldtemp = $data->fetch_array($sql)) {
$fieldtemp['options'] = unserialize($fieldtemp['options']);
$fields[] = $fieldtemp;
}
$row = array();
if (pageauth("users", "limit") == 1) {
$usergroups = user_groups_id_array($check['id']);
$userquery = '';
$first2 = true;
for ($i = 0; $i < count($usergroups); $i++) {
if ($first2 == false) {
$userquery .= " OR ";
} else {
$first2 = false;
}
$group_ids = group_users_id_array($usergroups[$i]);
$first = true;
for ($j = 0; $j < count($group_ids); $j++) {
if ($first == false) {
$userquery .= " OR ";
} else {
$first = false;
}
$userquery .= "id=" . $group_ids[$j];
}
}
$sql = $data->select_query("users", "WHERE {$userquery} ORDER BY uname ASC");
} else {
$sql = $data->select_query("users", "ORDER BY uname ASC");
}
$numusers = $data->num_rows($sql);
function group_users_sql_list($field, $connector, $type = false)
{
global $data, $check;
if ($type = false) {
$userpatrols = user_patrol_array($check['id']);
} elseif ($type = true) {
$userpatrols = user_groups_id_array($check['id']);
}
if (count($userpatrols) > 0) {
for ($i = 0; $i < count($userpatrols); $i++) {
$userlist = group_users_id_array($userpatrols[$i]);
for ($j = 0; $j < count($userlist); $j++) {
$uname = $data->select_fetch_one_row("users", "WHERE id={$userlist[$j]}", "uname");
$patrols .= "{$field} = " . safesql($uname['uname'], "text");
if (!($i == count($userpatrols) - 1 && $j == count($userlist) - 1)) {
$patrols .= " {$connector} ";
}
}
}
} else {
return "0=1";
}
return $patrols;
}
