[Release]Gameserver and Player Status

[blitztech]

Release Server and Player Online Status.

//Player ONline
<?php

// Database conf.
$db_host = 'MSSQL HOST';
$db_user = 'sa';
$db_pass = 'Sa_password';
$db_account = "RZ_ACCOUNTDB";

$conn = @mssql_connect($db_host,$db_user,$db_pass) or die('Failed to connect to MSSQL Server.');
$db = @mssql_select_db('RZ_GAMEDB',$conn) or die('Failed to select database.');
$ip=$_SERVER['REMOTE_ADDR'];

$side_info1 = mssql_query("SELECT * FROM RZ_SERVER_STATUS WHERE SERVER_ID ='1'");
			while ($gsi = mssql_fetch_array($side_info1))
	{
		$gotten_info[10] = $gsi['SERVER_ID'];
		$gotten_info[20] = $gsi['PLAYER_COUNT'];
	}

$side_info2 = mssql_query("SELECT * FROM RZ_SERVER_STATUS WHERE SERVER_ID ='2'");
			while ($gsi = mssql_fetch_array($side_info2))
	{
		$gotten_info[30] = $gsi['SERVER_ID'];
		$gotten_info[40] = $gsi['PLAYER_COUNT'];
	}
	
print'<div style="margin-left:30%;">
CHANNEL 1: '.$gotten_info[20].' ONLINE<br/>
CHANNEL 2: '.$gotten_info[40].' ONLINE<br/>

</div>';


?>

//Server Status
<?php

$dbhost = "ServerIp";	
$GS_Port1 = "7201";
$GS_Port2 = "7202";
$LS_Port = "7501";
{
if ($fp=@fsockopen($dbhost,$LS_Port,$ERROR_NO,$ERROR_STR,(float)0.5)) 
	{ 
	fclose($fp); 
	echo "<div style='margin-left:30%;'>LOGIN SERVER :<img src=images/server_1.gif align=absmiddle></img></div>"; 
	}
else 
	{ 
	echo "<div style='margin-left:30%;'>LOGIN SERVER :<img src=images/server_0.gif align=absmiddle></img></div>"; 
	}

	if ($fp=@fsockopen($dbhost,$GS_Port1,$ERROR_NO,$ERROR_STR,(float)0.5)) 
	{ 
	fclose($fp); 
	echo "<div style='margin-left:30%;'>CHANNEL 1 :<img src=images/server_1.gif align=absmiddle></img></div>"; 
	}
else 
	{ 
	echo "<div style='margin-left:30%'>CHANNEL 1 :<img src=images/server_0.gif align=absmiddle></img></div>"; 
	}
	
	if ($fp=@fsockopen($dbhost,$GS_Port2,$ERROR_NO,$ERROR_STR,(float)0.5)) 
	{ 
	fclose($fp); 
	echo "<div style='margin-left:30%'>CHANNEL 2 :<img src=images/server_1.gif align=absmiddle></img></div>"; 
	}
else 
	{ 
	echo "<div style='margin-left:30%'>CHANNEL 2 :<img src=images/server_0.gif align=absmiddle></img></div>"; 
	}
	
echo "<div style='width:'.$total_number.'%; background:#351a0b; height:5px;border-right:1px solid #351a0b;'></div>";
	}

?>

[MentaL]

[wesman2232]

Thanks for the share.

[SviT]

Thank you