Jump to content

Recommended Posts

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


  • Posts

    • Good day! Due to the increasing number of questions, "Do you provide services for the client?" - I decided to answer with a separate topic. I provide services for editing/modifying the client and individual files, namely: 1. Transfer/Creation/Editing locations, geodata.   2. All kinds of work with NPCs, including transfer, animation, adding effects to them and logos.   3. Actually, Transfer/Creation/Edit any EFFECTS, including Abnormal Effects.   4. Any work with weapons, armor, accessories and everything related to it.   5. Create or edit textures, including dynamic textures.   6. Creating a Lobby Screen, Lobby Char Selection (character selection window) and Lobby Char Creation (character creation window). What I don't do: 1. Coding in any form (except for CB).   I started publishing my work recently, here - YouTube And here - RuTube If required, I respect confidentiality. Any other questions? Welcome to Telegram or PM.
    • 🎮https://discord.gg/yyVRtna9RB 🌎https://l2-forever.com L2 Forever was the best mid rates PvP server back in C4 and C5 and we want to give players the same experience with Interlude!   # L2-Forever * EXP: 50x * Adena: 200x * Spoil: 5x * Drops: 5x   # ENCHANTS *Safe Enchant : 3 *Max. Enchant : 20 *Normal Scroll chance : 65% *Blessed Scroll chance : 70%   # NEW PLAYERS * Start with Coupons allowing you to get free top D-grade * Start at level 20 * Main Town Giran Harbor   # BOOSTED AREA'S * Execution Grounds [ 20 - 40] * Cruma Tower [40-52] * Antharas Lair [52-61] * Antharas Heart [61-80] * Giran Harbor - Shopping Area   # END GAME FARMING AREAS * Monastery of Silence and Primeval Island customized for group farm # PLATINUM ARMORS * Platinum Armors get dropped by raids, allowing everyone to obtain a set and not only donators * Many Raids all over the L2 world drop parts of the Platinum Armors   # BUFFS * Buff duration is set at 1 hour for normal buffs (Buffs and Songs / Dances) * Town Buffers in all main towns with all available buffs Giran Harbor (GH) is the place to be for all your trades and item needs! Platinum Armors   # FOREVER ITEMS * Unique Forever weapons & armors # UNIQUE L2 FOREVER AUGMENTATION SYSTEM * We don't use retail augmentations, we use our own unique system and glows!   # OTHER CUSTOM FEATURES * Global Gatekeeper * NPC Class Changer * Auction House * Unique Augmenter * Subclass with Adena or from Cabrio * Nobless - Barakiel * Useless S weapon Special abilities like (Cheap shot) are changed
    • 🎮https://discord.gg/yyVRtna9RB 🌎https://l2-forever.com L2 Forever was the best mid rates PvP server back in C4 and C5 and we want to give players the same experience with Interlude!   # L2-Forever * EXP: 50x * Adena: 200x * Spoil: 5x * Drops: 5x   # ENCHANTS *Safe Enchant : 3 *Max. Enchant : 20 *Normal Scroll chance : 65% *Blessed Scroll chance : 70%   # NEW PLAYERS * Start with Coupons allowing you to get free top D-grade * Start at level 20 * Main Town Giran Harbor   # BOOSTED AREA'S * Execution Grounds [ 20 - 40] * Cruma Tower [40-52] * Antharas Lair [52-61] * Antharas Heart [61-80] * Giran Harbor - Shopping Area   # END GAME FARMING AREAS * Monastery of Silence and Primeval Island customized for group farm # PLATINUM ARMORS * Platinum Armors get dropped by raids, allowing everyone to obtain a set and not only donators * Many Raids all over the L2 world drop parts of the Platinum Armors   # BUFFS * Buff duration is set at 1 hour for normal buffs (Buffs and Songs / Dances) * Town Buffers in all main towns with all available buffs Giran Harbor (GH) is the place to be for all your trades and item needs! Platinum Armors   # FOREVER ITEMS * Unique Forever weapons & armors # UNIQUE L2 FOREVER AUGMENTATION SYSTEM * We don't use retail augmentations, we use our own unique system and glows!   # OTHER CUSTOM FEATURES * Global Gatekeeper * NPC Class Changer * Auction House * Unique Augmenter * Subclass with Adena or from Cabrio * Nobless - Barakiel * Useless S weapon Special abilities like (Cheap shot) are changed
    • DISCORD : utchiha_market telegram : https://t.me/utchiha_market SELLIX STORE : https://utchihamkt.mysellix.io/ Join our server for more products : https://discord.gg/uthciha-services https://campsite.bio/utchihaamkt
  • Topics

×
×
  • Create New...