}
$PlayerCount = intval($con->real_escape_string($_REQUEST["playercount"]));
$TTL = max(min(intval($con->real_escape_string($_REQUEST["ttl"])), $MAX_TTL), 1);
$Rev = $con->real_escape_string($_REQUEST["rev"]);
if (!CheckVersion($Rev)) {
$con->close();
die("Invalid revision");
}
$Coderev = $con->real_escape_string($_REQUEST["coderev"]);
$IsDedicated = intval($con->real_escape_string($_REQUEST["dedicated"]));
$OS = $con->real_escape_string($_REQUEST["os"]);
if ($Name === "" || $IP === "" || $Port === "" || $TTL === "" || $PlayerCount === "") {
error_log("Incorrect parameters " . $Name . " " . $IP . " " . $Port . " " . $TTL . " " . $PlayerCount . " ");
$con->close();
die("Incorrect parameters");
}
//Don't allow buggy Linux server versions, Windows server (ICS) is ok
if (($Coderev == "r4179" || $Coderev == "r4185") && $_SERVER['HTTP_USER_AGENT'] != "Mozilla/4.0 (compatible; ICS)") {
$con->close();
die("Please download the server update");
}
$Pingable = intval(TestConnection($IP, $Port));
db_init($con);
Remove_Old_Servers($con);
$Expiry = date("Y-m-d H:i:s", time() + $TTL);
$query = "REPLACE INTO Servers (IP, Port, Name, Players, Pingable, Dedicated, OS, Rev, CodeRev, Expiry) VALUES ('{$IP}', {$Port}, '{$Name}', {$PlayerCount}, {$Pingable}, {$IsDedicated}, '{$OS}', '{$Rev}', '{$Coderev}', '{$Expiry}')";
if (!$con->query($query)) {
error_log("Error adding server: " . mysqli_error($con));
}
$con->close();
die('success');
function ServerQuery($format, $rev)
{
if ($format == "ajaxupdate") {
/*
* the requester expects to receive a json object
* some browsers withdraw the standard text/html that php returns by default
*/
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
//expired in the past to prevent caching
header('Content-type: application/json');
}
global $MAIN_VERSION, $TABLE_REFRESH, $BASE_URL;
if ($rev == "") {
$rev = $MAIN_VERSION;
}
$con = db_connect();
$format = $con->real_escape_string($format);
$rev = $con->real_escape_string($rev);
if (!isset($format) && !CheckVersion($rev)) {
$con->close();
die("Invalid revision");
}
if ($rev == "") {
$rev = $MAIN_VERSION;
}
$Result = "";
$server_count = 0;
/////////////////////////////////////////
// HEADER //
/////////////////////////////////////////
switch ($format) {
case "ajaxupdate":
$Result = array();
break;
case "refresh":
$Result = '<script type="text/javascript">' . "\n" . 'function srvlsttim(dat){var x="<tr><td><strong>Name</strong></td><td><strong>Address</strong></td><td style=\\"text-align: center\\"><strong>Players</strong></td></tr>";for(var n=0;n<dat.cnt;n++){x+="<tr><td><img src=\\"' . $BASE_URL . 'flags/"+dat.srvs[n].c+".gif\\" alt=\\""+dat.srvs[n].c+"\\" /> "+dat.srvs[n].n+"</td><td>"+(dat.srvs[n].a=="0"?" <img src=\\"' . $BASE_URL . 'error.png\\" alt=\\"Server unreachable\\" style=\\"vertical-align:middle\\" />":"")+dat.srvs[n].i+"</td><td style=\\"text-align: center\\">"+dat.srvs[n].p+"</td></tr>";jQuery("#ajxtbl").empty().append(x);}}' . "\n" . 'function updsr(){setTimeout(function (){jQuery.ajax({dataType: "jsonp",jsonp: "jsonp_callback",url: "' . $BASE_URL . 'serverquery.php?format=ajaxupdate&rev=' . $rev . '",success: function (data){srvlsttim(data);updsr();}});}, ' . 1000 * $TABLE_REFRESH . ');}' . "\n" . 'jQuery(document).ready(function($){updsr();});</script>' . "\n";
case "table":
$Result .= '<table border="1" width="100%" id="ajxtbl"><tr><td><strong>Name</strong></td><td><strong>Address</strong></td><td style="text-align: center"><strong>Players</strong></td></tr>';
break;
case "kamclub":
$Result .= '<table border="1" width="100%" id="ajxtbl" style="font-size:11px; font-family:Arial,Tahoma"><tr><td><strong>Название сервера</strong></td><td><strong>Адрес</strong></td><td style="text-align: center"><strong>Кол-во игроков</strong></td></tr>';
break;
case "kamclubeng":
$Result .= '<table border="1" width="100%" id="ajxtbl" style="font-size:11px; font-family:Arial,Tahoma"><tr><td><strong>Server name</strong></td><td><strong>Address</strong></td><td style="text-align: center"><strong>Players</strong></td></tr>';
default:
}
/////////////////////////////////////////
// BODY //
/////////////////////////////////////////
Remove_Old_Servers($con);
$data = $con->query("SELECT IP, Port, Name, Players, Dedicated, OS, Pingable FROM Servers WHERE Rev='{$rev}' ORDER BY Players DESC, Name ASC");
while ($row = $data->fetch_array()) {
$Name = $row['Name'];
$IP = $row['IP'];
$Port = $row['Port'];
$PlayerCount = $row['Players'];
$IsDedicated = $row['Dedicated'];
$OS = $row['OS'];
$Alive = $row['Pingable'];
$server_count++;
switch ($format) {
case "refresh":
case "kamclub":
case "kamclubeng":
case "table":
//Clean color codes matching [$xxxxxx] or []
$Name = preg_replace('/\\[\\$[0-9a-fA-F]{6}\\]|\\[\\]|\\[\\]/', "", $Name);
//WTF regex
$Country = IPToCountry($IP);
$Warning = '';
if (!$Alive) {
$Warning = ' <IMG src="' . $BASE_URL . 'error.png" alt="Server unreachable" style="vertical-align:middle">';
}
$Result .= "<TR class=\"no_translate\"><TD><IMG src=\"" . $BASE_URL . "flags/" . strtolower($Country) . ".gif\" alt=\"" . GetCountryName($Country) . "\"> {$Name}</TD><TD>{$Warning}{$IP}</TD><TD style=\"text-align: center\">{$PlayerCount}</TD></TR>\n";
break;
case "ajaxupdate":
//Clean color codes matching [$xxxxxx] or []
$Name = preg_replace('/\\[\\$[0-9a-fA-F]{6}\\]|\\[\\]|\\[\\]/', "", $Name);
//WTF regex
$srvsgl = array();
$srvsgl['c'] = strtolower(IPToCountry($IP));
$srvsgl['n'] = $Name;
if (!$Alive) {
$srvsgl['a'] = "0";
} else {
$srvsgl['a'] = "1";
}
$srvsgl['i'] = $IP;
//$Result['o'] = $Port; // not used yet
$srvsgl['p'] = $PlayerCount;
$Result[] = $srvsgl;
break;
default:
if (substr($rev, 1) >= 4878) {
//New server releases expect more parameters
$Result .= "{$Name},{$IP},{$Port},{$IsDedicated},{$OS}\n";
} else {
$Result .= "{$Name},{$IP},{$Port}\n";
}
}
}
/////////////////////////////////////////
// FOOTER //
/////////////////////////////////////////
switch ($format) {
case "ajaxupdate":
$Result = json_encode(array("cnt" => $server_count, "srvs" => $Result));
$Result = $_GET['jsonp_callback'] . "(" . $Result . ")";
break;
case "kamclub":
case "kamclubeng":
case "refresh":
case "table":
$Result .= '</table>';
default:
}
echo $Result;
$con->close();
}