$tableHeader_inner = $tableHeader_original;
}
$table_inner = "\n <table class='row-border hover table-reports'>\n <thead>\n <tr>" . $tableHeader_inner . "</tr>\n </thead>\n <tbody id='table-body'>";
$onlyNew = True;
foreach ($result as $row) {
$table_inner .= sprintf("<tr report_id='%d'>\n" . ($isAdminForReport || $isMainAdmin ? "<td><input class='chb-report' type='checkbox' /></td>" : "") . "<td><a href='http://ezpz.cz/page/report-system?report_ids=%d'>%s</a></td>\n\n <td status_id='%d' " . (($row["status_id"] == 3 or $row["status_id"] == 4 or $row["status_id"] == 5) ? "time_finish='" . $row["time_finish"] . "' " . (!is_null($row["sourcebans_link"]) ? "sourcebans_link='" . $row["sourcebans_link"] . "'" : "sourcebans_link=''") . "><bubble class='bubble-status'>%s</bubble>" : ">%s") . "\n </td>\n\n <td class='cell-reporter'\n rep_sid='%s'\n rep_ip='%s'\n rep_hlstats_link='%s'\n rep_chatlog_link='%s'\n rep_connectlog_link='%s'>\n <bubble class='bubble-reporter'>%s</bubble>\n </td>\n\n <td server_id='%d'>%s</td>\n\n <td map_id='%d'><a href='%s'>%s/%d</a></td>\n\n <td>" . $row['reasons'] . ($row['reason_custom'] != '' ? ' + ' . htmlspecialchars($row['reason_custom']) : '') . "</td>\n" . ($row["note"] != "" ? "<td note='%s'><bubble class='bubble-note'>Show</bubble></td>\n" : "<td></td>") . "</tr>", $row["report_id"], $row["report_id"], $row["time_create"], $row["status_id"], $row["status"], $row["rep_sid"], $row["rep_ip"], "http://stats.ezpz.cz/hlstats.php?mode=playerinfo&player=" . $row["rep_hlstats_id"], "http://ezpz.cz/page/utilities-chatlog?steamid=" . $row["rep_sid"], "http://ezpz.cz/page/utilities-connectlog?steamid=" . $row["rep_sid"], htmlspecialchars($row["rep_nick"]), $row["server_id"], htmlspecialchars($row["server_name"]), $row["map_id"], sprintf("http://ezpz.cz/ext/phpbb/pages/styles/pbtech/template/utils-gotv/download.php?server_id=%d&file=%s%s", $row["server_id"], $row["path"] != "" ? $row["path"] . "/" : "", $row["demo_file"]), $row["map"], $row["round"], htmlspecialchars($row["note"]));
if ($row["status_id"] != "1") {
$onlyNew = False;
}
}
$table_inner .= "</tbody></table>";
//echo $table_inner . "<br /><br />";
if ($isAdminForReport || $isMainAdmin) {
// <button class='button-note' >" . $lang["buttons"]["note"] . "</button>
$table_inner .= "\n <div class='div-admin-actions'>\n <button class='button-progress'>" . $lang["buttons"]["progress"] . "</button>\n <button class='button-reject'>" . $lang["buttons"]["reject"] . "</button>\n <button class='button-accept'>" . $lang["buttons"]["accept"] . "</button>\n <button class='button-ban' group_id='{$group_id}'>" . $lang["buttons"]["ban"] . "</button>";
if ($isMainAdmin && !$isAdminForReport && $onlyNew) {
$table_inner .= sprintf("<button class='button-take' date_create='%s' trg_sid='%s'>" . $lang["buttons"]["take_over"] . "</button>", $row_group["time_create_date"], $row_group["sid"]);
}
$table_inner .= "</div>";
}
if (checkAdminBySession() && $onlyNew && !$isAdminForReport && !$isMainAdmin) {
$table_inner .= sprintf("\n <div class='div-admin-actions'>\n <button class='button-take' date_create='%s' trg_sid='%s'>" . $lang["buttons"]["take_over"] . "</button>\n </div>", $row_group["time_create_date"], $row_group["sid"]);
}
//echo $table_inner;
header('Content-Type: application/json');
echo json_encode(array("success" => true, "data" => $table_inner));
} catch (Exception $ex) {
header('Content-Type: application/json');
echo json_encode(array("success" => false, "data" => $ex->getMessage()));
//echo $ex->getMessage();
}
}
if (!isset($_POST["nickname"])) {
die("nickname is not set!");
}
if (!isset($_POST["reason"])) {
die("reason is not set!");
}
if (!isset($_POST["length"])) {
die("length is not set!");
}
if (!isset($_POST["report_ids"])) {
die("report_ids is not set!");
}
include_once dirname(__FILE__) . "/../../scripts-generic/getPDO.php";
include_once dirname(__FILE__) . "/../../scripts-generic/PDOQuery.php";
include_once dirname(__FILE__) . "/../../scripts-generic/checkAdmin.php";
session_start();
if (!checkAdminBySession()) {
die("You are not admin!");
}
$pdo = getPDOConnection();
$query = "INSERT INTO `soe-csgo`.`sb_bans` (\n `type`,\n `steam`,\n `ip`,\n `name`,\n `reason`,\n `length`,\n `admin_id`,\n `admin_ip`,\n `create_time`)\n VALUES (\n '0',\n :steamid,\n :ip,\n :nickname,\n :reason,\n :length,\n :admin_id,\n '88.86.107.243',\n UNIX_TIMESTAMP(NOW()))";
//echo $query;
$reason = $_POST['reason'] . " | http://ezpz.cz/page/report-system?report_ids=" . $_POST["report_ids"];
$parameters = array(":steamid" => $_POST['steamid'], ":ip" => $_POST['ip'], ":nickname" => $_POST['nickname'], ":reason" => $reason, ":length" => intval($_POST['length']), ":admin_id" => intval($_SESSION['ezpz_sb_admin_id']));
// http://ezpz.cz/ext/phpbb/pages/styles/pbtech/template/report-g/report_actions/addban_report.php?steamid=1:0012646&ip=88.45.21.47&nickname=test&reason=test&length=50
if (PDOExecParametrizedQuery($pdo, $query, $parameters, __FILE__, __LINE__)) {
echo json_encode(array('success' => true, 'ban_id' => $pdo->lastInsertId()));
} else {
echo json_encode(array('success' => false));
}
