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));