config.php

<?php
	$server_ip = "localhost";
	$server_myqsl_username = "root";
	$server_mysql_password = "";
	$server_mysql_database = "l2jdb";
?>

connect.php

<?php
	mysql_connect($server_ip,$server_myqsl_username,$server_mysql_password);
	mysql_select_db($server_mysql_database);
?>

retreive_status.php

<?php
	include_once "config.php";
	include_once "connect.php";
	error_reporting(E_ALL);

	$auth_server = fsockopen($server_ip, 2106, $errno, $errstr, 0.5);
	$unix_server = fsockopen($server_ip, 7777, $errno, $errstr, 0.5);

	if ($auth_server)
		$auth_server = 'online';

	if ($unix_server)
		$unix_server = 'online';

	$players_online = mysql_num_rows(mysql_query("SELECT * FROM `characters` WHERE `online` = '1';"));
	$accounts_created = mysql_num_rows(mysql_query("SELECT * FROM `accounts`;"));
	$characters_created = mysql_num_rows(mysql_query("SELECT * FROM `characters`;"));

	$players_online = (!$players_online) ? 0 : $players_online;
	//$players_online = round($players_online+($players_online*30/100));
	$players_online = round($players_online*2);
	$accounts_created = (!$accounts_created) ? 0 : $accounts_created;
	$characters_created = (!$characters_created) ? 0 : $characters_created;

	$file = fopen("status.txt", 'w');
	fwrite($file, $auth_server.":".$unix_server.":".$players_online.":".$accounts_created.":".$characters_created);
	fclose($file);


	$file = fopen("toppvp.txt", 'w');
	$top_pvp_query = mysql_query("SELECT `char_name`,`pvpkills` FROM `characters` ORDER BY `pvpkills` DESC LIMIT 0,10;");
	$top_pvp_i = 1;
	while ($top_pvp = mysql_fetch_array($top_pvp_query)) {
		if ($top_pvp_i == 10)
			fwrite($file, $top_pvp_i.":".$top_pvp['char_name'].":".$top_pvp['pvpkills']);
		else
			fwrite($file, $top_pvp_i.":".$top_pvp['char_name'].":".$top_pvp['pvpkills']."\r\n");
		$top_pvp_i++;
	}
	fclose($file);

	mysql_close();
?>

status.php

<?php
	error_reporting(E_STRICT);

	$status_file = @fopen("includes/status.txt", "r");
 	while (!feof($status_file)) {
		$status_lines[] = fgets($status_file, 4096);
	}
	fclose($user_file);
	$status = explode(":", $status_lines[0]);
	$auth_server = $status[0];
	$unix_server = $status[1];
	$players_online = $status[2];
	$accounts_created = $status[3];
	$characters_created = $status[4];


	$tops_file = @fopen("includes/toppvp.txt", "r");
 	while (!feof($tops_file)) {
		$tops_lines[] = fgets($tops_file, 4096);
	}
	fclose($tops_file);

	echo "<center>Atnaujinama kas 1min.</center><br /><hr /><br />";

	echo "Login server: ";

	if ($auth_server == 'online')
		echo "<font color='#2f720a'>Online</font><br /><br />";
	else
		echo "<font color='#72220a'>Offline</font><br /><br />"; // offline kodas <font color='#72220a'>Offline</font><br /><br />

	echo "Unix server: ";

	if ($unix_server == 'online')
		echo "<font color='#2f720a'>Online</font><br /><br />";
	else
		echo "<font color='#72220a'>Offline</font><br /><br />";

	echo "Players online: <font color='#2f720a'>".$players_online."</font><br /><br />";
	echo "Accounts created: <font color='#2f720a'>".$accounts_created."</font><br /><br />";
	echo "Characters created: <font color='#2f720a'>".$characters_created."</font><br /><br />";
	echo "<hr /><br />";
	echo "<b>Player</b><span style='float: right'><b>PVP Points</b></span><br /><br />";
	foreach ($tops_lines as $top_line) {
		$tops = explode(":", $top_line);
		echo "<b>".$tops[0].".</b>&nbsp;&nbsp;&nbsp;".$tops[1]." <span style='float: right;'>".$tops[2]."</span><br />";
	}
	echo "<br /><hr />";

?>