die;
}
if ($req == "tickets" && $id) {
$info["ticket"] = Db::query("SELECT * FROM zz_tickets WHERE id = :id", array(":id" => $id), 0);
$info["replies"] = Db::query("SELECT * FROM zz_tickets_replies WHERE belongsTo = :id", array(":id" => $id), 0);
} elseif ($req == "tickets") {
$limit = 30;
$offset = ($page - 1) * $limit;
$info = Db::query("SELECT * FROM zz_tickets WHERE killID = 0 ORDER BY status DESC, datePosted DESC LIMIT {$offset}, {$limit}", array(), 0);
foreach ($info as $key => $val) {
if ($val["tags"]) {
$info[$key]["tags"] = explode(",", $val["tags"]);
}
}
} elseif ($req == "users") {
$info = Moderator::getUsers($page);
}
if ($req == "reportedkills" && $id) {
$info["ticket"] = Db::query("SELECT * FROM zz_tickets WHERE id = :id", array(":id" => $id), 0);
$info["replies"] = Db::query("SELECT * FROM zz_tickets_replies WHERE belongsTo = :id", array(":id" => $id), 0);
} elseif ($req == "reportedkills") {
$limit = 30;
$offset = ($page - 1) * $limit;
$info = Db::query("SELECT * FROM zz_tickets WHERE killID != 0 ORDER BY status DESC LIMIT {$offset}, {$limit}", array(), 0);
foreach ($info as $key => $val) {
if ($val["tags"]) {
$info[$key]["tags"] = explode(",", $val["tags"]);
}
}
}
$app->render("moderator/moderator.html", array("id" => $id, "info" => $info, "key" => $req, "url" => "moderator", "message" => $message, "page" => $page));
