Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

[Share] Online players script for website

Shadowalker
 Share

Recommended Posts

  • 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...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..