}
}
// Server Key clause
$server_key_clause = 'serverKey IN (' . $helpers->keyToServerKeys($access_keys, $_GET['key']) . ') OR LENGTH(serverKey) < 1';
$fetchresult = $dbi->query("SELECT \n\t\t\t\t\t\t\tcallID, serverIP, serverPort, CONCAT(serverIP, ':', serverPort) as fullIP, serverName, targetName, targetID, targetReason, clientName, clientID, reportedAt, callHandled\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t`{$table}`\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t({$from_query}) AND {$server_key_clause}\n\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\treportedAt {$sort}\n\t\t\t\t\t\tLIMIT 0, {$limit}");
// Retrieval failed
if ($fetchresult === FALSE) {
$dbi->close();
$helpers->printXmlError("DB_RETRIEVE_FAILURE", "CallAdmin_Notice");
}
// Save this tracker if key is set, key was given, we have an valid remote address and the client sends an store (save him as available)
if (isset($_SERVER['REMOTE_ADDR']) && isset($_GET['store'])) {
$trackerIP = $dbi->escape_string($helpers->AnonymizeIP($_SERVER['REMOTE_ADDR']));
$trackerID = "";
// Steamid was submitted, this must have come from the client
if (isset($_GET['steamid']) && $helpers->IsValidSteamID($_GET['steamid'])) {
$trackerID = $dbi->escape_string($_GET['steamid']);
}
// Access query
$access_query = '(SELECT SUM(`accessBit`) FROM `' . $table . '_Access` WHERE serverKey IN (' . $helpers->keyToServerKeys($access_keys, $_GET['key']) . '))';
$insertresult = $dbi->query("INSERT IGNORE INTO `" . $table . "_Trackers`\n\t\t\t\t\t\t(trackerIP, trackerID, lastView, accessID)\n\t\t\t\t\tVALUES\n\t\t\t\t\t\t('{$trackerIP}', '{$trackerID}', UNIX_TIMESTAMP(), {$access_query})\n\t\t\t\t\tON DUPLICATE KEY\n\t\t\t\t\t\tUPDATE lastView = UNIX_TIMESTAMP(), trackerID = '{$trackerID}', accessID = {$access_query}");
// Insert failed
if ($insertresult === FALSE) {
$dbi->close();
$helpers->printXmlError("DB_UPDATE_FAILURE", "CallAdmin_Notice");
}
}
$dbi->close();
$xml = new SimpleXMLElement("<CallAdmin/>");
$counter = 0;
while ($row = $fetchresult->fetch_assoc()) {
if (!isset($_GET['key']) || !$helpers->keyToServerKeys($access_keys, $_GET['key'])) {
$helpers->printXmlError("APP_AUTH_FAILURE", "CallAdmin_Ts3");
}
if (!isset($_GET['targetid']) || !isset($_GET['targetname']) || !isset($_GET['targetreason']) || !isset($_GET['clientid']) || !isset($_GET['clientname']) || !isset($_GET['servername']) || !isset($_GET['serverip'])) {
$helpers->printXmlError("APP_INPUT_FAILURE", "CallAdmin_Ts3");
}
//Variables
$targetID = $_GET['targetid'];
$targetName = $_GET['targetname'];
$targetReason = $_GET['targetreason'];
$clientID = $_GET['clientid'];
$clientName = $_GET['clientname'];
$serverName = $_GET['servername'];
$serverIP = $_GET['serverip'];
$targetCommBB = "Invalid";
if ($helpers->IsValidSteamID($targetID)) {
$targetCommID = $helpers->SteamIDToComm($targetID);
$targetCommBB = "[url=http://steamcommunity.com/profiles/" . $targetCommID . "]{$targetID}" . "[/url]";
}
$clientCommBB = "Invalid";
if ($helpers->IsValidSteamID($clientID)) {
$clientCommID = $helpers->SteamIDToComm($clientID);
$clientCommBB = "[url=http://steamcommunity.com/profiles/" . $clientCommID . "]{$clientID}" . "[/url]";
}
$connect = "[url=steam://connect/" . $serverIP . "]connect now[/url]";
require_once "include/TeamSpeak3/TeamSpeak3.php";
$ts3 = new TeamSpeak3();
try {
$ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $user . ":" . $password . "@" . $host . ":" . $queryport . "/?server_port=" . $port);
$uid = "";
//$name = "";
}
}
// Server Key clause
$server_key_clause = 'serverKey IN (' . $helpers->keyToServerKeys($access_keys, $_GET['key']) . ') OR LENGTH(serverKey) < 1';
$fetchresult = $dbi->query("SELECT \n\t\t\t\t\t\t\tcallID, CONCAT(serverIP, ':', serverPort) as fullIP, serverName, targetName, targetID, targetReason, clientName, clientID, reportedAt, callHandled\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t`{$table}`\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t({$from_query}) AND {$server_key_clause}\n\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\treportedAt {$sort}\n\t\t\t\t\t\tLIMIT 0, {$limit}");
// Retrieval failed
if ($fetchresult === FALSE) {
$dbi->close();
$helpers->printXmlError("DB_RETRIEVE_FAILURE", "CallAdmin_Notice");
}
// Save this tracker if key is set, key was given, we have an valid remote address and the client sends an store (save him as available)
if (isset($_SERVER['REMOTE_ADDR']) && isset($_GET['store'])) {
$trackerIP = $dbi->escape_string($helpers->AnonymizeIP($_SERVER['REMOTE_ADDR']));
$trackerID = "";
// Steamid was submitted, this must have come from the client
if (isset($_GET['steamid']) && $helpers->IsValidSteamID($_GET['steamid'])) {
$trackerID = $dbi->escape_string($_GET['steamid']);
}
// Access query
$access_query = '(SELECT SUM(`accessBit`) FROM `' . $table . '_Access` WHERE serverKey IN (' . $helpers->keyToServerKeys($access_keys, $_GET['key']) . '))';
$insertresult = $dbi->query("INSERT IGNORE INTO `" . $table . "_Trackers`\n\t\t\t\t\t\t(trackerIP, trackerID, lastView, accessID)\n\t\t\t\t\tVALUES\n\t\t\t\t\t\t('{$trackerIP}', '{$trackerID}', UNIX_TIMESTAMP(), {$access_query})\n\t\t\t\t\tON DUPLICATE KEY\n\t\t\t\t\t\tUPDATE lastView = UNIX_TIMESTAMP(), trackerID = '{$trackerID}', accessID = {$access_query}");
// Insert failed
if ($insertresult === FALSE) {
$dbi->close();
$helpers->printXmlError("DB_UPDATE_FAILURE", "CallAdmin_Notice");
}
}
$dbi->close();
$rss->setTitle("CallAdmin RSS Feed");
$rss->setLink("https://github.com/Impact123/CallAdmin");
$rss->setSelfLink(sprintf("%s://%s%s", !empty($_SERVER['HTTPS']) ? "https" : "http", $_SERVER['HTTP_HOST'], $_SERVER['REQUEST_URI']));
