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; }