[SHARE] General PHP Server Status

GoDofAdeN · October 31, 2009

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 = "Online";

else

$ls = "Offline";

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

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

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

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

if ( $gs )

$gs = "Online";

else

$gs = "Offline";

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

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

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

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

if ( $ve )

$ve = "Online";

else

$ve = "Offline";

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

////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 .= "$gmnam->char_name, ";

}

print "

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

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

<tr><td width='80%'>Bartz Server:</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^ · October 31, 2009

Indeed it is..

+1 from me !!

HardstyleMxc · October 31, 2009

Usefull Script Thanks!!!

GoDofAdeN · October 31, 2009

thanks :)

ic3cub3 · November 3, 2009

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

GoDofAdeN · November 3, 2009

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

Dresik · November 5, 2009

Thx dude

Street-Gamer · December 12, 2009

thanks a lot. keep it updated.

Drasius · December 12, 2009

Very usefull, thanks. :)

c0britsa · January 23, 2011

Is this works for HTML site?

I have make my own website.

Shyque · January 23, 2011

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

DrachaVonDrachen · January 23, 2011

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 · January 23, 2011

what its do?

DrachaVonDrachen · January 23, 2011

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 · April 25, 2011

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.

[SHARE] General PHP Server Status

Recommended Posts

GoDofAdeN

RєVєnGeR^

HardstyleMxc

GoDofAdeN

ic3cub3

GoDofAdeN

Dresik

Street-Gamer

Drasius

c0britsa

Shyque

DrachaVonDrachen

ment2008

DrachaVonDrachen

sirsoyer

Join the conversation

Posts

Topics

Browse

Activity

Store