Jump to content
MaxCheaters Official Group on Discord
-> Place your ad text here <-
LINEAGE2.GOLD INTERLUDE SERVER ON ESSENCE CLIENT
  • 0

[Request] I need Online Players / Top Clans web scripts

Captivator

Asked by Captivator,

 Share

Question

2 answers to this question

Recommended Posts

  • 0
Matim Newbie

Matim

Posted
Posted

Server status and stats:

 

<?php

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

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

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

#MySQL Server Host
$mySQLserver="127.0.0.1";
$mySQLuser="root";
$mySQLpassword="root";
$mySQLdefaultdb="l2jdb";

#Ventrilo
$ventriloip="warnet.hu";
$ventriloport="3784";

#TeamSpeak 2
$teamspeakip="warnet.hu";
$teamspeakport="8767";

?>

<?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>"; 

$ventrilo = @fsockopen ($ventriloip,$ventriloport, $errno, $errstr, 1);
if ( $ventrilo ) 
   $ventrilo = "<font color=#00FF00><b>Online</b></font>"; 
else 
   $ventrilo = "<font color=red><b>Offline</b></font>"; 

$teamspeak = @fsockopen ($teamspeakip,$teamspeakport, $errno, $errstr, 1);
if ( $teamspeak ) 
   $teamspeak = "<font color=#00FF00><b>Online</b></font>"; 
else 
   $teamspeak = "<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 access_level>=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);

//Acc-Char bans

$query = ("SELECT * FROM accounts WHERE access_level<0");

$result = mysql_query($query) or die(mysql_error());

$accban=mysql_numrows($result);

$query = ("SELECT * FROM characters WHERE accesslevel<0");

$result = mysql_query($query) or die(mysql_error());

$charban=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><b><span>Ventrilo:</span></b> <font color=#00FF00><?php print ("$ventrilo"); ?></li>
<li><b><span>TeamSpeak 2:</span></b> <font color=#00FF00><?php print ("$teamspeak"); ?></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>Banned Characters:</span> <font color=#00FF00><?php print ("$charban"); ?></li>
<li><span>Banned Account:</span> <font color=#00FF00><?php print ("$accban"); ?></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>

 

Note: not tested.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing


×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock