<?php
set_time_limit(1000000000000000);
include $_SERVER['DOCUMENT_ROOT'].'/putanja_do_fajla';
mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db("baza") or die(mysql_error());
$cssservers = mysql_query("SELECT * FROM igrice WHERE game_id = '2'") or die(mysql_error());
while($servers[] = mysql_fetch_assoc($cssservers)){
}
$array = $servers;
if(is_array($array)){
foreach ($array as $serversall) {
$serverexplodee = explode(":", $serversall['ip']);
$serverIP = $serverexplodee[0];
$serverPort = $serverexplodee[1];
$Timer = MicroTime( true );
$Query = new SourceQuery( );
$Info = Array( );
$Rules = Array( );
$Players = Array( );
try
{
$Query->Connect( $serverIP, $serverPort, 1, SourceQuery :: SOURCE );
$Info = $Query->GetInfo( );
$Players = $Query->GetPlayers( );
$Rules = $Query->GetRules( );
}
catch( Exception $e )
{
// - ako je offline uzimace podatke koji su zabiljezeni kada je bio online ( i ako je off vise od 15 dana ukinuce se to trebam dodati ali prvo ovo uraditi)
$ipserveracj = $serversall['ip'];
$servernamecj = $serversall['imeservera'];
$servermodcj = $serversall['servermod'];
$playerscj = "Offline";
$maxplayerscj = "";
$botscj = "0";
$mapcj = $serversall['servermap'];
$infoplayerscj = "";
$arraycj = $infoplayerscj;
}
$Timer = Number_Format( MicroTime( true ) - $Timer, 4, '.', '' );
if($Info["ModDir"] != 'cstrike'){
// - Ako bude nesto pa ucita neki drugi server koji nije cs:s
$ipserveracj = $serversall['ip'];
$servernamecj = $serversall['imeservera'];
$servermodcj = $serversall['servermod'];
$playerscj = "0";
$maxplayerscj = $serversall['maxplayers'];
$botscj = "0";
$mapcj = $serversall['servermap'];
$infoplayerscj = "";
$arraycj = $infoplayerscj;
}else{
// - ako je sve u redu onda uzme podatke sa servera
$ipserveracj = $serversall['ip'];
$servernamecj = mysql_real_escape_string(htmlentities($Info["HostName"]));
$servermodcj = $serversall['servermod'];
$playerscj = $Info["Players"];
$maxplayerscj = $Info["MaxPlayers"];
$botscj = $Info["Bots"];
$mapcj = $Info["Map"];
$infoplayerscj = mysql_real_escape_string(json_encode($Players));
$arraycj = $infoplayerscj;
}
/*$ubacipodatkenove = mysql_query("UPDATE igrice SET ip='$ipserveracj', imeservera='$servernamecj', servermod='$servermodcj', igraci='$playerscj', maxplayers='$maxplayerscj', bots='$botscj', servermap='$mapcj', infoplayers='$arraycj' WHERE game_id='2' AND ip='$ipserveracj'") or die(mysql_error());
foreach ($Players as $Player) {
$igracevoime = mysql_real_escape_string($Player['Name']);
$lastseen = date("D.m.Y G:i");
$firstseen = date("D.m.Y G:i");
$vidijelzabiljezen = mysql_query("SELECT * FROM allplayers WHERE playername='$igracevoime' AND ipserverwhereplayerplay='$ipserveracj' AND game_id = '$servers[game_id]'") or die(mysql_error());
if(mysql_num_rows($vidijelzabiljezen) == 0){
$ubaciga = mysql_query("INSERT INTO allplayers (id, playername, ipserverwhereplayerplay, firstseen, lastseen, game_id, profileid) VALUES ('', '$igracevoime', '$ipserveracj', '', '$lastseen', '2', '0')") or die(mysql_error());
}else{
$updatega = mysql_query("UPDATE allplayers SET firstseen = '$firstseen' WHERE firstseen = ''") or die(mysql_error());
$updategaa = mysql_query("UPDATE allplayers SET lastseen = '$lastseen'") or die(mysql_error());
}
}*/
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8'>
</head>
<body>
</body>
</html>
Hvala svima koji pomognu...