Jump to content

[SHARE] General PHP Server Status


Recommended Posts

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.

Link to comment
Share on other sites

  • 1 month later...
  • 1 year later...

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?

Link to comment
Share on other sites

65864080.th.png

 

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

 

26059882.th.png

 

 

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

Link to comment
Share on other sites

  • 3 months later...

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

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



  • Posts

    • 📞 Verified Ex-Love Back Specialist ( 973_ 384_3997) Best Love spells  The most authentic love spells are the most reliable source you can rely on. The most authentic of all these spells is cast in a variety of ways. Love can be mended or broken and so anyone can choose how you want to use the spells. You might want to bring back your ex-girlfriend or boyfriend or divorce her. There are A lot of differences in the world of love. First of all, we need to know that there is a special spiritual being around us. A real man that follows us up and finds what lucks in our life and hence finds a better solution to help us. Most of us are naïve and ignorant about this and hence less of us believe in all this. Contact me right now so that we begin the rituals right away. Authentic love spells (973) 384-3997! Get Back your Ex / lost lover Permanently! The most authentic love spells are spread the universal over e to those who apply to get them. They have helped mend broken hearts that have no hope all over. My most efficient and authentic love spells contain the most meditated magical powers. The powers take a bit of time to work. My physical powers are so strong that I have come through meditation and concentration to work for you. Most Powerful love spells (973) 384-3997! Get Back your Ex / lost lover Permanently. The authentic love spells have a package for married people and so they will also grant you the love you deserve and happiness in marriage. Many marriages are breaking and facing hardships, but you have failed to get ways to make it out. Contact me so that your marriage life is helped not to fall and restore the happiness that you once shared. My love spells are easily made through marriage portions and oils that you can easily perform on your own. Call: (973)384-3997
    • ⋐⋑Atlanta, GA witchcraft & Love spells +1(973) 384-3997 ❤️ The most authentic love spells are the most reliable source you can rely on. The most authentic of all these spells is cast in a variety of ways. Love can be mended or broken and so anyone can choose how you want to use the spells. You might want to bring back your ex-girlfriend or boyfriend or divorce her. There are A lot of differences in the world of love. First of all, we need to know that there is a special spiritual being around us. A real man that follows us up and finds what lucks in our life and hence finds a better solution to help us. Most of us are naïve and ignorant about this and hence less of us believe in all this. Contact me right now so that we begin the rituals right away. Authentic love spells (973) 384-3997! Get Back your Ex / lost lover Permanently! The most authentic love spells are spread the universal over e to those who apply to get them. They have helped mend broken hearts that have no hope all over. My most efficient and authentic love spells contain the most meditated magical powers. The powers take a bit of time to work. My physical powers are so strong that I have come through meditation and concentration to work for you. Most Powerful love spells (973) 384-3997! Get Back your Ex / lost lover Permanently. The authentic love spells have a package for married people and so they will also grant you the love you deserve and happiness in marriage. Many marriages are breaking and facing hardships, but you have failed to get ways to make it out. Contact me so that your marriage life is helped not to fall and restore the happiness that you once shared. My love spells are easily made through marriage portions and oils that you can easily perform on your own. Call: (973)384-3997
    • Surprise, AZ LOVE Spells 📱 +1 (973_384_3997 in Best Love Spells   You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back. Get back your Ex-lover This service has been the reason of so many happy endings that you should consider it as a serious solution. Let us show you our method with zero chances of rejection. Don’t waste your precious time; get your lover back When you work with an expert, this spell works toward dissipating the negative energies that were kicked up between you and your ex so that reconciliation becomes a possibility. When you break up with someone, especially if things ended badly, it’s like having a thick fog between the two of you that prevents you from seeing the truth of each other. Anger, hurt, and resentment linger in the air and it’s difficult to remember the reasons you fell in love in the first place With this spell, you can restore your broken relationship. The fog will clear, and the sun will shine on both your hearts, warming you up and preparing you for a reunion. You love someone but this isn’t mutual? Don’t wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. Your husband or you wife is thinking about divorce but you don’t want this to happen? Order this service now to reinforce the bonds of your relationship and save your marriage. Get back your Ex-lover This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. The perfect service to break up a relationship you don’t think legitimate. Your lover has gone with someone else? You love someone but this person is already involved in a relationship? Don’t hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only  
    • Columbia, SC voodoo Spells  📱 (973_384_3997 Best love spells You are a few clicks away from a prompt resolution of your problem: We will our spiritual powers to bring him/her back. Get back your Ex-lover This service has been the reason of so many happy endings that you should consider it as a serious solution. Let us show you our method with zero chances of rejection. Don’t waste your precious time; get your lover back When you work with an expert, this spell works toward dissipating the negative energies that were kicked up between you and your ex so that reconciliation becomes a possibility. When you break up with someone, especially if things ended badly, it’s like having a thick fog between the two of you that prevents you from seeing the truth of each other. Anger, hurt, and resentment linger in the air and it’s difficult to remember the reasons you fell in love in the first place With this spell, you can restore your broken relationship. The fog will clear, and the sun will shine on both your hearts, warming you up and preparing you for a reunion. You love someone but this isn’t mutual? Don’t wait for the deluge and make him or her love you now. This service will create a great alchemy between this person and you. In just a few weeks, you can make the person you dream of falling in love with you. We recommend you to combine this service with a Marriage ritual if you want this person to commit you. Your husband or you wife is thinking about divorce but you don’t want this to happen? Order this service now to reinforce the bonds of your relationship and save your marriage. Get back your Ex-lover This service will make him/her realize that a divorce would be a mistake and will strengthen love and passion. With permanent results, this service will guarantee a long lasting marriage and will make you happy. The perfect service to break up a relationship you don’t think legitimate. Your lover has gone with someone else? You love someone but this person is already involved in a relationship? Don’t hesitate to break them up as this ritual and prayer is very powerful and will give very good results in a few weeks only  
  • Topics

×
×
  • Create New...