if (strtolower($order) != "user_name" && strtolower($order) != "id") {
$order = "id";
}
if (!$start || !is_numeric($start)) {
$start = 0;
}
if (!$show || !is_numeric($show)) {
$show = 20;
}
$LIMIT = " LIMIT {$start},{$show}";
$userquery = $db->query_str("SELECT * FROM {$tab['user']} WHERE activated='1' AND blocked='0' AND id<>'1' ORDER BY {$order} {$sort}{$LIMIT}");
while ($user = $db->fetch_array($userquery)) {
eval("\$inc[users] .= \"" . gettemplate("user.admin.list.user.bit") . "\";");
}
list($count) = $db->query("SELECT COUNT(*) FROM {$tab['user']} WHERE activated='1' AND blocked='0' AND id<>'1'");
$pages = mkpages($count, $show, "user.admin.list.user.pages.bit");
eval("\$inc[action] = \"" . gettemplate("user.admin.list.user") . "\";");
}
#######################################
if ($adminaction == "blockinactiv" || $block_fail) {
$fail = $block_fail;
$aquery = $db->query_str("SELECT * FROM {$tab['user']} WHERE activated='0' OR blocked='1' ORDER BY activated DESC");
if (!mysql_num_rows($aquery)) {
eval("\$inc[users] = \"" . gettemplate("user.admin.list.blockinacitvate.nowaiting") . "\";");
} else {
while ($user = $db->fetch_array($aquery)) {
if (!$user[activated]) {
$step = "Anmeldung <b>nicht</b> abgeschlossen";
} else {
$step = "Anmeldung abgeschlossen";
}
}
$LIMIT = " LIMIT {$start},{$show}";
$errorsq = $db->query_str("SELECT * FROM {$tab['error']} ORDER BY id ASC{$LIMIT}");
if (!mysql_num_rows($errorsq)) {
eval("\$errorbits = \"" . gettemplate("admin.sworaconfig.errors.non") . "\";");
} else {
while ($error = $db->fetch_array($errorsq)) {
if (strlen($error[text]) > 90) {
eval("\$textplus = \"" . gettemplate("admin.sworaconfig.errors.morelink") . "\";");
$error[text] = substr($error[text], 0, 90) . $textplus;
}
$error[request_uri] = mk2url($error[request_uri]);
eval("\$errorbits .= \"" . gettemplate("admin.sworaconfig.errors.errorbit") . "\";");
}
list($count) = $db->query("SELECT COUNT(*) FROM {$tab['error']}");
$page = mkpages($count, $show, "admin.sworaconfig.errors.pagebit");
}
eval("\$inc[action] = \"" . gettemplate("admin.sworaconfig.errors.main") . "\";");
}
###########################
if ($adminaction == "showerror") {
if ($error = $db->query("SELECT * FROM {$tab['error']} WHERE id='{$eid}'")) {
$name = basename($error[scriptname]);
$error[text] = str_replace("\n", "<br>", $error[text]);
eval("\$inc[action] = \"" . gettemplate("admin.sworaconfig.errors.show") . "\";");
} else {
header("LOCATION: index.php?section=admin&adminaction=errors");
}
}
#####################
if ($adminaction == "points") {
###
$userq = $db->query_str("SELECT * FROM {$tab['user']} WHERE activated='1' AND blocked='0' AND id<>1 ORDER BY {$order_like_this} {$sort_like_this} LIMIT {$start},{$show}");
while ($userf = $db->fetch_array($userq)) {
$user = getuser($userf[id]);
$user_name = mkuser("user_name", 0, $user);
#$user_pm = mkuser("user_pm",0,$user);
$user_email = mkuser("user_email", 0, $user);
$user_hp = mkuser("user_hp", 0, $user);
$user_icq = mkuser("user_icq", 0, $user);
$user_aim = mkuser("user_aim", 0, $user);
$user_yim = mkuser("user_yim", 0, $user);
eval("\$userlist .= \"" . gettemplate("user.listusers.userbit") . "\";");
}
list($count) = $db->query("SELECT COUNT(*) FROM {$tab['user']} WHERE activated='1' AND blocked='0' AND id<>1");
$param["s{$show}"] = " selected";
$param[$order] = " selected";
$param[$sort] = " selected";
$links = mkpages($count, $show, "user.listusers.pagebit");
eval("\$pages = \"" . gettemplate("user.listusers.pages") . "\";");
if ($sort == "DESC") {
unset($sort);
$sort[$order] = "ASC";
}
if ($sort == "ASC") {
unset($sort);
$sort[$order] = "DESC";
}
eval("\$inc[action] = \"" . gettemplate("user.listusers.main") . "\";");
}
#####
}
########
if ($adminaction == "loader_main" || $fail_loader) {
$fail = $fail_loader;
if (!$order && strtolower($order) != "title" && strtolower($order) != "file" && strtolower($order) != "loads" && strtolower($order) != "mode") {
$order = "id";
}
if (!$sort || strtolower($sort) != "asc" && strtolower($sort) != "desc") {
$sort = "desc";
}
if (!$start || !is_numeric($start)) {
$start = 0;
}
if (!$show || !is_numeric($show)) {
$show = 10;
}
$LIMIT = " LIMIT {$start},{$show}";
$loadsq = $db->query_str("SELECT * FROM {$tab['loader']} ORDER BY {$order} {$sort} {$LIMIT}");
while ($load = $db->fetch_array($loadsq)) {
if ($load[mode] == 1) {
$fungi = "Weiterleitung";
}
if ($load[mode] == 2 || !$load[mode]) {
$fungi = "Einbindung";
}
eval("\$loadbits .= \"" . gettemplate("loader.admin.loadbit") . "\";");
}
list($count) = $db->query("SELECT COUNT(*) FROM {$tab['loader']}");
$pages = mkpages($count, $show, "loader.admin.pages.bit");
eval("\$inc[action] = \"" . gettemplate("loader.admin.main") . "\";");
}
########
