$parameters_report_id[":report_id{$i}"] = $id;
$i++;
}
} else {
$where_report_id = "r.id = :report_id ";
$parameters_report_id[":report_id"] = $by_report_ids[0];
}
$tableHeader_original = "<th>" . $lang["table_headers"]["time"] . "</th>\n <th>" . $lang["table_headers"]["status"] . "</th>\n <th>" . $lang["table_headers"]["reporter"] . "</th>\n <th>" . $lang["table_headers"]["server"] . "</th>\n <th>" . $lang["table_headers"]["map"] . "/" . $lang["table_headers"]["round"] . "</th>\n <th>" . $lang["table_headers"]["reason"] . "</th>\n <th>" . $lang["table_headers"]["note"] . "</th>";
$query = "\n SELECT\n r.id AS report_id,\n r.reason_custom,\n r.demo_file,\n r.note,\n TIME_FORMAT(r.time_create, '%H:%i:%s') AS time_create,\n r.time_finish,\n r.round,\n r.sourcebans_link,\n r.map_id,\n r.target_id,\n rep.nick AS rep_nick,\n rep.sid AS rep_sid,\n rep.ip AS rep_ip,\n rep.hlstats_id AS rep_hlstats_id,\n trg.nick AS trg_nick,\n trg.sid AS trg_sid,\n trg.ip AS trg_ip,\n trg.hlstats_id AS trg_hlstats_id,\n GROUP_CONCAT(rs.reason_" . $lang["db"]["suffix"] . " SEPARATOR ', ') AS reasons,\n s.name AS server_name,\n s.server_id,\n s.path,\n m.map,\n m.id,\n st.status_" . $lang["db"]["suffix"] . " AS status,\n st.id AS status_id,\n a.id AS admin_id\n FROM\n `ezpz-report-g`.report_report AS r\n LEFT JOIN `ezpz-report-g`.report_report_reason AS rs_join ON rs_join.report_id = r.id\n LEFT JOIN `ezpz-report-g`.report_reason AS rs ON rs.id = rs_join.reason_id\n LEFT JOIN `ezpz-report-g`.report_players AS rep ON rep.id = r.reporter_id\n LEFT JOIN `ezpz-report-g`.report_players AS trg ON trg.id = r.target_id\n LEFT JOIN `soe-csgo`.utils_servers AS s ON s.server_id = r.server_id\n LEFT JOIN `ezpz-report-g`.report_status AS st ON st.id = r.status_id\n LEFT JOIN `ezpz-report-g`.report_map AS m ON m.id = r.map_id\n LEFT JOIN `soe-csgo`.sb_admins AS a ON a.id = r.admin_id\n WHERE " . $where_report_id . "GROUP BY\n r.id;";
//echo $query . "<br /><br />";
$result = getPDOParametrizedQueryResult($pdo, $query, $parameters_report_id, __FILE__, __LINE__);
if (!$result and !empty($result)) {
throw new Exception("Cannot get the query result!");
}
foreach ($by_report_ids as $id) {
$isAdminForReport = checkAdminForReportByReportId($id);
}
if ($isAdminForReport || $isMainAdmin) {
$tableHeader_inner = "<th class='no-sort'><input type='checkbox' class='chb-select-all'/><a class='a-select-all'>" . $lang["table_headers"]["all"] . "</a></th>" . $tableHeader_original;
} else {
$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>";
<?php
if (!isset($_POST["report_id"])) {
die("report_id 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();
$report_id = intval($_POST["report_id"]);
if (checkAdminForReportByReportId($report_id) || checkMainAdmin()) {
$pdo = getPDOConnection();
$query = "UPDATE `ezpz-report-g`.`report_report` SET status_id = 5, time_finish = TIMESTAMP(NOW()) WHERE id = :id";
header('Content-Type: application/json');
if (PDOExecParametrizedQuery($pdo, $query, array("id" => $report_id), __FILE__, __LINE__)) {
echo json_encode(array('success' => true));
} else {
echo json_encode(array('success' => false));
}
}
