Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord
--> Place your ad text here <--
  • 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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing


×
×
  • Create New...