} else { $user_access_level = $misc->GenDropMenuWSelectedLevels($lvls, $user_access_level, 'user_access_level'); } // Generate a list of user groups to select from (limit by group) if ($group === "admin") { $grp = "SELECT `group` FROM `auth_groups` ORDER BY `group` ASC"; } else { $grp = "SELECT `group` FROM `auth_groups` WHERE `group` = \"" . $group . "\" ORDER BY `group` ASC"; } if (($return = $db->dbQuery($val->ValidateSQL($grp, $dbconn), $dbconn)) !== -1) { $grps = $db->dbArrayResultsAssoc($return); } if (count($grps) === 0) { $user_group = "No Groups defined"; } else { $user_group = $misc->GenDropMenuWSelectedGroups($grps, $user_group, 'user_group'); } // assign our data to the template $tpl->assign('message', $message, NULL, NULL); $tpl->assign('user_id', $val->ValidateXSS($user_id), NULL, NULL); $tpl->assign('user_group', $user_group, NULL, NULL); $tpl->assign('user_list', $user_list, NULL, NULL); $tpl->assign('user_pw_list', $user_pw_list, NULL, NULL); $tpl->assign('user_access_level', $user_access_level, NULL, NULL); $tpl->assign('user_username', $val->ValidateXSS($user_username), NULL, NULL); $tpl->assign('user_fname', $val->ValidateXSS($user_fname), NULL, NULL); $tpl->assign('user_lname', $val->ValidateXSS($user_lname), NULL, NULL); $tpl->assign('user_department', $val->ValidateXSS($user_department), NULL, NULL); $tpl->assign('user_contact', $val->ValidateXSS($user_contact), NULL, NULL); $tpl->assign('user_address', $val->ValidateXSS($user_address), NULL, NULL); $tpl->assign('user_phone', $val->ValidateXSS($user_phone), NULL, NULL);