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()) {
$child = $xml->addChild("singleReport");
foreach ($row as $key => $value) {
$key = $helpers->_xmlentities($key);
$value = $helpers->_xmlentities($value);
// This shouldn't happen, but is used for the client
if (strlen($value) < 1) {
$value = "NULL";
}
$child->addChild($key, $value);
}
$counter++;
}
$child = $xml->addChild("foundRows", $counter);
echo $xml->asXML();
// End of file: notice.php
require_once "include/TeamSpeak3/TeamSpeak3.php";
$helpers = new CallAdmin_Helpers();
// Key set and no key given or key is wrong
if (!isset($_GET['key']) || !$helpers->keyToServerKeys($access_keys, $_GET['key'])) {
$helpers->printXmlError("APP_AUTH_FAILURE", "CallAdmin_Ts3");
}
$ts3 = new TeamSpeak3();
$xml = new SimpleXMLElement("<CallAdmin_Ts3/>");
try {
$ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $user . ":" . $password . "@" . $host . ":" . $queryport . "/?server_port=" . $port);
$usersChild = $xml->addChild("userList");
$count = 0;
$uid = "";
$name = "";
foreach ($ts3_VirtualServer->clientList() as $ts3_Client) {
$uid = $helpers->_xmlentities((string) $ts3_Client['client_unique_identifier']);
$name = $helpers->_xmlentities((string) $ts3_Client['client_nickname']);
if ($uid == "ServerQuery") {
continue;
}
$child = $usersChild->addChild("singleUser");
$child->addChild("name", $name);
$child->addChild("uid", $uid);
}
} catch (TeamSpeak3_Adapter_ServerQuery_Exception $e) {
// Nope
$helpers->printXmlError($e->getMessage(), "CallAdmin_Ts3");
}
$xml->addChild("success", "true");
echo $xml->asXML();
// End of file: ts3call.php
