function checkAdminByUsername($username)
{
$pdo = getPDOConnection();
$query = "SELECT id FROM `soe-csgo`.`sb_admins` WHERE name = :username";
$num_rows = getPDOParametrizedQueryResult($pdo, $query, array(":username" => $username), __FILE__, __LINE__, True);
if ($num_rows > 0) {
return TRUE;
} else {
return FALSE;
}
}
}
}
}
if (count($conditions) > 1) {
$where = implode(' AND ', $conditions);
$where = " WHERE " . $where;
} elseif (count($conditions) == 1) {
$where = " WHERE " . $conditions[0];
} elseif (count($conditions) == 0) {
$where = "";
}
$query = "\n SELECT\n DATE(time_create) AS time_create_date,\n GROUP_CONCAT(r.id SEPARATOR ',') AS report_ids,\n a.name AS admin_name, a.id AS admin_id,\n trg.nick AS trg_nick,\n trg.ip AS trg_ip,\n trg.sid AS trg_sid,\n trg.hlstats_id\n FROM\n `ezpz-report-g`.report_report AS r\n LEFT JOIN\n `ezpz-report-g`.report_report_reason AS rs_join ON rs_join.report_id = r.id\n LEFT JOIN\n `ezpz-report-g`.report_reason AS rs ON rs.id = rs_join.reason_id\n LEFT JOIN\n `ezpz-report-g`.report_players AS rep ON rep.id = r.reporter_id\n LEFT JOIN\n `ezpz-report-g`.report_players AS trg ON trg.id = r.target_id\n LEFT JOIN\n `soe-csgo`.utils_servers AS s ON s.server_id = r.server_id\n LEFT JOIN\n `ezpz-report-g`.report_status AS st ON st.id = r.status_id\n LEFT JOIN\n `ezpz-report-g`.report_map AS m ON m.id = r.map_id\n LEFT JOIN\n `soe-csgo`.sb_admins AS a ON a.id = r.admin_id" . $where . "\n GROUP BY\n DAY(time_create_date), target_id\n ORDER BY\n time_create_date DESC";
//echo $query;
//print_r($parameters);
//echo "$query <br /><br />";
$result = getPDOParametrizedQueryResult($pdo, $query, $parameters, __FILE__, __LINE__);
if (!$result and !empty($result)) {
throw new Exception("Cannot get the query result!");
}
$table_header = "\n <th>" . $lang["table_headers"]["date"] . "</th>\n <th>" . $lang["table_headers"]["target"] . "</th>\n <th>" . $lang["table_headers"]["admin"] . "</th>";
$table = '
<table id="table-reports-group" class="row-border hover">
<thead>
<tr>' . $table_header . '</tr>
</thead>
<tbody>';
$i = 0;
foreach ($result as $row) {
$report_ids = join(array_unique(explode(",", $row["report_ids"])), ",");
$table .= sprintf('
<tr group_id="%d" report_ids="%s">
$query = "INSERT INTO `ezpz-report-g`.report_report_reason(report_id, reason_id) VALUES (:report_id, :reason_id)";
$parameters = array(":report_id" => $report_id, ":reason_id" => $reason_id);
PDOExecParametrizedQuery($pdo, $query, $parameters, __FILE__, __LINE__);
}
}
header('Content-Type: application/json');
echo json_encode(array("success" => True, "data" => sprintf($translation["texts"]["report_add_success"], $max_allowed_report_count - $report_count_day - 1, $report_id, $report_id)));
//send email to admin
$query = "SELECT a.language, a.email FROM `soe-csgo`.`sb_admins` AS a WHERE id = :admin_id";
$result = getPDOParametrizedQueryResult($pdo, $query, array(":admin_id" => $admin_id), __FILE__, __LINE__);
foreach ($result as $row) {
$translation = getEmailTranslation($row["language"]);
$email = $row["email"];
}
$query = "SELECT r.id, r.time_create, s.status_" . $translation["db"]["suffix"] . " AS status FROM `ezpz-report-g`.`report_report` AS r\n JOIN `ezpz-report-g`.`report_status` AS s ON s.id = r.status_id\n WHERE r.admin_id = :admin_id AND s.id IN (1, 2)";
$result = getPDOParametrizedQueryResult($pdo, $query, array(":admin_id" => $admin_id), __FILE__, __LINE__);
$rs_url = "http://ezpz.cz/page/report-system?report_ids=%d";
$message_other = "";
if ($result) {
$message_other = "<div style='font-size: large;'><b>" . $translation["message_other"] . ":</b></div><br /><br />";
foreach ($result as $row) {
$message_other .= sprintf("<a href='{$rs_url}'><b>" . $row["status"] . "</b> | <i>" . $row["time_create"] . "</i></a><br />", $row["id"]);
}
}
$message = "<div style='font-size: large;'><b>" . $translation["message_new"] . ": </b>" . sprintf("<a href='{$rs_url}'>{$rs_url}</a>", $report_id, $report_id) . "</div><br /> <br />" . $message_other;
$headers = "From: admin@ezpz.cz\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=cp1250\r\n";
mail($email, $translation["subject"], $message, $headers);
} else {
print_r($admins);
/**
*
* @return True when SQL query returns empty result set. False otherwise.
*/
function PDOcheckEmptyQuery($pdo, $query, $file, $line_number, $parameters = NULL)
{
try {
if (empty($parameters) || $parameters === NULL) {
$result = getPDOQueryResult($pdo, $query, $file, $line_number);
} else {
$result = getPDOParametrizedQueryResult($pdo, $query, $parameters, $file, $line_number);
}
if (count($result) == 0) {
return True;
} else {
return False;
}
} catch (Exception $ex) {
echo getErrorDescription($ex->getMessage(), $query, $file, $line_number);
return False;
}
}
<?php
if (!isset($_GET["playerid"])) {
die("playerid is not set!");
} else {
$playerId = $_GET["playerid"];
}
include_once dirname(__FILE__) . "/getPDO.php";
include_once dirname(__FILE__) . "/PDOQuery.php";
$pdo = getPDOConnection();
$query = "\n SELECT oldName, newName, eventTime\n FROM `soe-hlstats`.hlstats_Events_ChangeName\n WHERE playerId = :playerId";
$result = getPDOParametrizedQueryResult($pdo, $query, array(":playerId" => $playerId), __FILE__, __LINE__);
if (!$result or empty($result)) {
echo "Žádná změna nicků / No nickname changes";
} else {
$nicknames = "";
foreach ($result as $row) {
$nicknames .= "<br /><i>" . $row["eventTime"] . "</i><br />" . $row["oldName"] . " <b>→</b> " . $row["newName"] . "<br />";
}
echo $nicknames;
}
die("pw not set!");
}
include_once dirname(__FILE__) . "/../scripts-generic/getPDO.php";
include_once dirname(__FILE__) . "/../scripts-generic/PDOQuery.php";
$pdo = getPDOConnection();
$query = "SELECT a.name, a.id AS admin_id FROM `soe-csgo`.`sb_admins` AS a WHERE a.active = 1";
$result = getPDOQueryResult($pdo, $query, __FILE__, __LINE__);
$table_active = "<table>\n<thead>\n <tr>\n <th>admin</th>\n <th>nové</th>\n <th>řeší se</th>\n <th>hotové</th>\n <th>hotové – přijato</th>\n <th>hotové – přijato, ban</th>\n <th>hotové – zamítnuto</th>\n </tr>\n</thead>\n<tbody>";
for ($i = 0; $i < count($result); $i++) {
$table_active .= "<tr>\n <td>" . $row["name"] . "</td>\n <td>new_" . $row["admin_id"] . "</td>\n <td>progress_" . $row["admin_id"] . "</td>\n <td>finished_" . $row["admin_id"] . "</td>\n <td>finished_accept" . $row["admin_id"] . "</td>\n <td>finished_ban" . $row["admin_id"] . "</td>\n <td>finished_rejected" . $row["admin_id"] . "</td>";
}
print_r($result);
foreach ($result as $row) {
$table_active .= "<tr><td>" . $row["name"] . "</td>";
$query = "SELECT s.id, COUNT(r.id) AS s_count FROM `ezpz-report-g`.`report_report` AS r\n JOIN `ezpz-report-g`.`report_status` as s ON s.id = r.status_id\n WHERE r.admin_id = :admin_id\n GROUP BY status_id, admin_id\n ORDER BY s.id ASC";
$result_count = getPDOParametrizedQueryResult($pdo, $query, array(":admin_id" => $row["admin_id"]), __FILE__, __LINE__);
echo "admin: " . $row["name"] . "<br />";
print_r($result_count);
echo "<br />";
for ($i = 1; $i <= 5; $i++) {
echo $i;
if (array_key_exists(strval($i), $result_count)) {
$table_active .= "<td>" . $result_count[$i]["s_count"] . "</td>";
} else {
$table_active .= "<td>0</td>";
}
}
$table_active .= "</tr>";
}
$table_active .= "</tbody></table>";
/*$query = "SELECT a.name, a.id FROM `soe-csgo`.`sb_admins` AS a WHERE a.active = 0 AND a.name <> 'test-admin'";
