[SHARE] General PHP Server Status

[GoDofAdeN]

I tought is Usefull =>

 

PHP Server Status for all datapack!

Created by Darkmentor.

 

<?php

 

$login_ip = "127.0.0.1";

$login_port = "2106";

$game_ip = "127.0.0.1";

$game_port = "7777";

$ventrilo_ip = "127.0.0.1";

$ventrilo_port = "3784";

 

$mysql_host = "127.0.0.1";

$mysql_user = "root";

$mysql_passwd = "root";

$mysql_db = "l2jdb";

 

///////////////////////////

////////Login Server///////

///////////////////////////

$ls = @fsockopen ($login_ip, $login_port, $errno, $errstr, 1);

if ( $ls )

   $ls = "<font color=green>Online</font>";

else

   $ls = "<font color=red>Offline</font>";

 

///////////////////////////

////////Game Server ///////

///////////////////////////

$gs = @fsockopen ($game_ip, $game_port, $errno, $errstr, 1);

if ( $gs )

   $gs = "<font color=green>Online</font>";

else

   $gs = "<font color=red>Offline</font>";

   

///////////////////////////

////////Vent Server ///////

///////////////////////////

$ve = @fsockopen ($ventrilo_ip, $ventrilo_port, $errno, $errstr, 1);

if ( $ve )

   $ve = "<font color=green>Online</font>";

else

   $ve = "<font color=red>Offline</font>";

 

 

/////////////////////////////

////MySQL Login Server///////

/////////////////////////////

 

mysql_connect($mysql_host, $mysql_user, $mysql_passwd) or die ("Nem sikerült csatlakozni a MySQL szerverhez!");

mysql_select_db($mysql_db) or die("Nincs ilyen adatbázis: ".$mysql_db);

 

// All Accounts

$accounts=mysql_numrows(mysql_query("SELECT * FROM accounts"));

 

// Online Players Num

$num=mysql_numrows(mysql_query("SELECT * FROM characters WHERE online=1 and accesslevel=0"));

 

// Online GMs Num

$gmnum=mysql_numrows(mysql_query("SELECT * FROM characters WHERE online=1 and accesslevel>0"));

 

// All Alliance Num

$alliance=mysql_numrows(mysql_query("SELECT * FROM clan_data WHERE ally_name!=\'\'"));

 

// All Characters

$char=mysql_numrows(mysql_query("SELECT * FROM characters WHERE accesslevel=0"));

 

// All GM Characters

$gmchar=mysql_numrows(mysql_query("SELECT * FROM characters Where accesslevel > 0"));

 

// All Clan

$clan=mysql_numrows(mysql_query("SELECT * FROM clan_data"));

 

$gmnamesql = mysql_query("SELECT char_name FROM characters WHERE accesslevel>=1 AND online=1 ORDER BY char_name ASC");    

while ($gmnam = mysql_fetch_object($gmnamesql)) {  

$gmname .= "<font color=green>$gmnam->char_name</font>, ";  

}

 

 

print "

<table width='100%' border='0'>

<tr><td width='80%'><b>Auth Server:</b></td><td>".$ls."</td></tr>

<tr><td width='80%'><b>Bartz Server:</b></td><td>".$gs."</td></tr>

<tr><td width='80%'>Accounts:</td><td>".$accounts."</td></tr>

<tr><td width='80%'>Online Players:</td><td>".$num."</td></tr>

<tr><td width='80%'>Online GM:</td><td>".$gmnum."</td></tr>

<tr><td width='80%'>Characters:</td><td>".$char."</td></tr>

<tr><td width='80%'>GM Characters:</td><td>".$gmchar."</td></tr>

<tr><td width='80%'>Clans:</td><td>".$clan."</td></tr>

<tr><td width='80%'>Alliances:</td><td>".$alliance."</td></tr>

<tr><td>Online GM: ".$gmname."</td></tr>

</table>

";

 

 

Have Fun.

[RєVєnGeR^]

Indeed it is..

 

+1 from me !!

 

 

 

[HardstyleMxc]

Usefull Script Thanks!!!

[GoDofAdeN]

thanks :)

[ic3cub3]

for me dont work... you mistake something... look again and edit ;)

[GoDofAdeN]

depends on what db are you using, then you must edit it.

[Dresik]

Thx dude

[eX-Core]

thanks a lot. keep it updated.

[Drasius]

Very usefull, thanks. :)

[c0britsa]

Is this works for HTML site?

I have make my own website.

[Shyque]

Nice ! I'm tested , no problem , 100% work ,

[DrachaVonDrachen]

Working but i have this warning..

 

Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\config\stats.php on line 60
Auth Server:	Online
Bartz Server:	Online
Accounts:	1
Online Players:	0
Online GM:	0
Characters:	0
GM Characters:	0
Clans:	0
Alliances:	
Online GM:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\templates\l2\bars\server_statistic.php on line 4

 

Any Idea how to fix it?

[ment2008]

what its do?

 

[DrachaVonDrachen]

 

any ideas how to fix it?

 

 

I change the 1 problem and now it says me Unknown column 'access_level' in 'where clause'

 

Check the screens

 

 

 

*Sry For Edit My Post, just to avoid double posting

[sirsoyer]

I use script:

<?php

$login_ip = "127.0.0.1";
$login_port = "2106";
$game_ip = "127.0.0.1";
$game_port = "7777";
$ventrilo_ip = "127.0.0.1";
$ventrilo_port = "3784";

$mysql_host = "127.0.0.1";
$mysql_user = "r";
$mysql_passwd = "r";
$mysql_db = "r";

///////////////////////////
////////Login Server///////
///////////////////////////
$ls = @fsockopen ($login_ip, $login_port, $errno, $errstr, 1);
if ( $ls )
    $ls = "<font color=green>Online</font>";
else
    $ls = "<font color=red>Offline</font>";

///////////////////////////
////////Game Server ///////
///////////////////////////
$gs = @fsockopen ($game_ip, $game_port, $errno, $errstr, 1);
if ( $gs )
    $gs = "<font color=green>Online</font>";
else
    $gs = "<font color=red>Offline</font>";
    
///////////////////////////
////////Vent Server ///////
///////////////////////////
$ve = @fsockopen ($ventrilo_ip, $ventrilo_port, $errno, $errstr, 1);
if ( $ve )
    $ve = "<font color=green>Online</font>";
else
    $ve = "<font color=red>Offline</font>";


/////////////////////////////
////MySQL Login Server///////
/////////////////////////////

mysql_connect($mysql_host, $mysql_user, $mysql_passwd) or die ("Nem sikerült csatlakozni a MySQL szerverhez!");
mysql_select_db($mysql_db) or die("Nincs ilyen adatbázis: ".$mysql_db);

// All Accounts
$accounts=mysql_numrows(mysql_query("SELECT * FROM accounts"));

// Online Players Num
$num=mysql_numrows(mysql_query("SELECT * FROM characters WHERE online=1 and accesslevel=0"));

// Online GMs Num
$gmnum=mysql_numrows(mysql_query("SELECT * FROM characters WHERE online=1 and accesslevel>0"));

// All Alliance Num
$alliance=mysql_numrows(mysql_query("SELECT * FROM clan_data WHERE ally_name!=''"));

// All Characters
$char=mysql_numrows(mysql_query("SELECT * FROM characters WHERE accesslevel=0"));

// All GM Characters
$gmchar=mysql_numrows(mysql_query("SELECT * FROM characters Where accesslevel > 0"));

// All Clan
$clan=mysql_numrows(mysql_query("SELECT * FROM clan_data"));

$gmnamesql = mysql_query("SELECT char_name FROM characters WHERE accesslevel>=1 AND online=1 ORDER BY char_name ASC");    
while ($gmname = mysql_fetch_object($gmnamesql)) {  
$gmname = "<font color=green>$gmname->char_name</font>, ";  
}


print "
<table width='100%' border='0'>
<tr><td width='80%'><b>Auth Server:</b></td><td>".$ls."</td></tr>
<tr><td width='80%'><b>Bartz Server:</b></td><td>".$gs."</td></tr>
<tr><td width='80%'>Accounts:</td><td>".$accounts."</td></tr>
<tr><td width='80%'>Online Players:</td><td>".$num."</td></tr>
<tr><td width='80%'>Online GM:</td><td>".$gmnum."</td></tr>
<tr><td width='80%'>Characters:</td><td>".$char."</td></tr>
<tr><td width='80%'>GM Characters:</td><td>".$gmchar."</td></tr>
<tr><td width='80%'>Clans:</td><td>".$clan."</td></tr>
<tr><td width='80%'>Alliances:</td><td>".$alliance."</td></tr>
<tr><td>Online GM: ".$gmname."</td></tr>
</table>
";
?>

on my localhost server and work 100% but if i change ip and user to my server online then i see:

( ! ) Warning: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:554) in C:\wamp\www\index.php on line 47
Call Stack
#	Time	Memory	Function	Location
1	0.0028	385192	{main}( )	..\index.php:0
2	1.1297	387552	mysql_connect ( )	..\index.php:47

( ! ) Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected in C:\wamp\www\index.php on line 47
Call Stack
#	Time	Memory	Function	Location
1	0.0028	385192	{main}( )	..\index.php:0
2	1.1297	387552	mysql_connect ( )	..\index.php:47

( ! ) Warning: mysql_connect() [function.mysql-connect]: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file in C:\wamp\www\index.php on line 47
Call Stack
#	Time	Memory	Function	Location
1	0.0028	385192	{main}( )	..\index.php:0
2	1.1297	387552	mysql_connect ( )	..\index.php:47
Nem sikerült csatlakozni a MySQL szerverhez!

what i doing wrong??

Server is l2j.