Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord
--> Place your ad text here <--

[Share] Online players script for website

Shadowalker
 Share

Recommended Posts

FFs Newbie

FFs

Posted
Posted

Hello!

 

Here's a simple script that display players online. In case server is offline, or an error occured it will display 0 players.

 

You can download it here.

 

Credits: Me

 

Enjoy :)

 

Thanx for share, i'll test it.

  • 1 month later...
  • 4 weeks later...
cutitarii Newbie

cutitarii

Posted
Posted

full stats;

<?php

#Login Server
$serverLip="127.0.0.1";
$serverLport="9014";

#GameServer
$serverGip="127.0.0.1";
$serverGPort="7777";

#Database Host
$databaseHost="localhost";
$databaseLogin="root";
$databasePassword="pass";
$databaseName="l2jdb";

#MySQL Server Host
$mySQLserver="localhost";
$mySQLuser="root";
$mySQLpassword="pass";
$mySQLdefaultdb="l2jdb";
?>

<?php

$flogin = @fsockopen ($serverLip,$serverLport, $errno, $errstr, 1);
if ( $flogin ) 
    $lstat = "<font color=#00FF00><b>Online</b></font>"; 
else 
    $lstat = "<font color=red><b>Offline</b></font>";

$fgame = @fsockopen ($serverGip,$serverGPort, $errno, $errstr, 1);
if ( $fgame ) 
    $gstat = "<font color=#00FF00><b>Online</b></font>"; 
else 
    $gstat = "<font color=red><b>Offline</b></font>"; 

mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die (mysql_error());
mysql_select_db($databaseName) or die(mysql_error());  

//online kari
$query = ("SELECT * FROM characters WHERE online=1");
$result = mysql_query($query) or die(mysql_error());
$num=mysql_numrows($result);

//all accounts
$query = ("SELECT * FROM accounts WHERE accessLevel>=0");
$result = mysql_query($query) or die(mysql_error());
$acc=mysql_numrows($result);

//Alliance
$query = ("SELECT * FROM clan_data WHERE ally_name!=\"\"");
$result = mysql_query($query) or die(mysql_error());
$alliance=mysql_numrows($result);

//all characters
$query = ("SELECT * FROM characters WHERE accesslevel>=0");
$result = mysql_query($query) or die(mysql_error());
$char=mysql_numrows($result);

//Clan
$get_config_data="SELECT clan_id FROM clan_data";
$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");
$result = mysql_query($query) or die(mysql_error());
$clan=mysql_numrows($result);

//GM
$query = ("SELECT * FROM characters WHERE accesslevel=200 AND online=1");
$result = mysql_query($query) or die(mysql_error());
$gm=mysql_numrows($result);



//Titan
$query = ("SELECT * FROM characters WHERE accesslevel=75 AND online=1");
$result = mysql_query($query) or die(mysql_error());
$titan=mysql_numrows($result);

mysql_close();
mysql_connect($mySQLserver,$mySQLuser,$mySQLpassword) or die(mysql_error());
mysql_select_db($mySQLdefaultdb) or die(mysql_error());
?>
<html>
<head>
<title>Server Status - By Mentor</title>
<link rel="stylesheet" type="text/css" href="img/style.css" />
</head>
<body>
<div id="sidebar">
<h2><center><span>Server</span>Status</center></h2>
<ul>
<li><b><span>LoginServer:</span></b> <font color=#00FF00><?php print ("$lstat"); ?></li>
<li><b><span>GameServer:</span></b> <font color=#00FF00><?php print ("$gstat"); ?></li>
<li><span>Online Players:</span> <font color=#00FF00><?php print ("$num"); ?></li>
<li><span>GM online:</span> <font color=#00FF00><?php print ("$gm"); ?></li>
<li><span>Titan online:</span> <font color=#00FF00><?php print ("$titan"); ?></li>
<li><span>Characters:</span> <font color=#00FF00><?php print ("$char"); ?></li>
<li><span>Account.:</span> <font color=#00FF00><?php print ("$acc"); ?></li>
<li><span>Clans:</span> <font color=#00FF00><?php print ("$clan"); ?></li>
<li><span>Alliances:</span> <font color=#00FF00><?php print ("$alliance"); ?></li>
</ul>
</div>
</body>
</html>

  • 2 weeks later...
Guest
This topic is now closed to further replies.
 Share
Go to topic listing
×
×
  • Create New...