function ServerPulse()
{
$server = new Server();
//Get server address
$server->setAddress($_SERVER['REMOTE_ADDR']);
//Grab input
$server->setPort($_REQUEST["port"]);
$server->setName($_REQUEST["name"]);
$server->setVersion($_REQUEST["version"]);
$server->setPrivateKey($_REQUEST["fingerprint"]);
$server->setMaxClients($_REQUEST["max"]);
$server->setPublic($_REQUEST["public"]);
$server->setPasswordProtected($_REQUEST["passwordProtected"]);
$server->setAllowGuests($_REQUEST["allowGuests"]);
$server->setUserCount($_REQUEST["users"]);
$server->setUserList($_REQUEST["players"]);
$server->setMotd($_REQUEST["motd"]);
$server->setGameMode($_REQUEST["gamemode"]);
//Update (or create) server record
return Server::updateServer($server);
}
public static function getServerList()
{
//Grab connection object
$mysqli = Utility::getSQLConnection();
$sql = "SELECT server_id, address, port, version, name, private_key, key_hash, ";
$sql .= "max_clients, public, password_protected, allow_guests, user_count, ";
$sql .= "user_list, motd, game_mode, last_heartbeat_date, created_date ";
$sql .= "FROM servers ";
$sql .= "WHERE last_heartbeat_date > (NOW() - INTERVAL 8 HOUR) ";
$sql .= "ORDER BY last_heartbeat_date DESC";
//Prepare query to find server
$stmt = $mysqli->prepare($sql);
if ($mysqli->errno) {
trigger_error($mysqli->error, E_USER_ERROR);
}
//Run query
$stmt->execute();
if ($mysqli->errno) {
$stmt->close();
unset($stmt);
trigger_error($mysqli->error, E_USER_ERROR);
}
$stmt->bind_result($serverId, $address, $port, $version, $name, $privateKey, $keyHash, $maxClients, $public, $passwordProtected, $allowGuests, $userCount, $userList, $motd, $gameMode, $lastHeartbeatDate, $createdDate);
$serverList = array();
while ($stmt->fetch()) {
$server = new Server();
//Fill server object
$server->setServerId($serverId);
$server->setAddress($address);
$server->setPort($port);
$server->setVersion($version);
$server->setName($name);
$server->setPrivateKey($privateKey);
$server->setPublicKey($keyHash);
$server->setMaxClients($maxClients);
$server->setPublic($public);
$server->setPasswordProtected($passwordProtected);
$server->setAllowGuests($allowGuests);
$server->setUserCount($userCount);
$server->setUserList($userList);
$server->setMotd($motd);
$server->setGameMode($gameMode);
$server->setLastHeartbeatDate($lastHeartbeatDate);
$server->setCreatedDate($createdDate);
$serverList[] = $server;
}
$stmt->close();
unset($stmt);
return $serverList;
}
