Jump to content
MaxCheaters Official Group at Discord
--> Place your ad text here <--

[SHARE] General PHP Server Status

GoDofAdeN

By GoDofAdeN
in Server Shares & Files [L2J]

 Share

Recommended Posts

GoDofAdeN Newbie

GoDofAdeN

Posted
Posted

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

DrachaVonDrachen

Posted
Posted

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
DrachaVonDrachen Newbie

DrachaVonDrachen

Posted
Posted

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

sirsoyer

Posted
Posted

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.
Note: Your post will require moderator approval before it will be visible.

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.

×
 Share
Go to topic listing


  • Posts

    • Exdeathy
      How to avoid one of the main critical errors 2047MB ram

      By Exdeathy · Posted

      Customs being added to systextures/animation/texture influences the increase in virtual ram by a very small amount, which means you won't have a headache in the future with critical error issues, unless it's a dubious custom, there are 2 custom weapon packs available for H5 that are "compromised", they didn't make a very good adaptation, one of the packages is the weapons from the goddess of destruction for H5, another is the hero weapons from the goddess of destruction for H5, avoid these customs for your H5 server if you see it on any forum.   Now coming back to your question; one thing that the NCSoft developers never did was add files to their system, probably because they were aware of what could happen when doing that, now think about one thing: the game's system retail itself is no more than 70MB, every time there was an update made by NCSoft they always added the equipment/items/cloaks etc. in their folders intended for that, so why do we do this? I still have my client containing a system with almost 1GB, 1-2h online is the time I can stay online before the ram memory limit, but I have already redone my entire client with customs being destined for textures/systexture/animations, almost all the customs that I had on that client containing a 1GB system I have on my current server, with the difference that I removed everything from the system and critical error is now nothing more than legends, my current server has a total of 220MB in the system folder And theoretically speaking, based on what I've seen, especially on many forums, I believe that the heavier the system folder is, the faster we accelerate the consumption of the client's virtual ram memory, causing countless different types of critical error in one short period of time, in many forums that I've seen on topics involving critical, the solution that stands out the most is about downloading a new clean "system"
    • xdem
      How to avoid one of the main critical errors 2047MB ram

      By xdem · Posted

      Do you think that everything on the system is loaded regardless if you use it or not ? or even worst, are they loaded even if they exist as textures/meshes but not defined on the DAT files ?
    • UTCHIHAmkt
      DISCORD TOKEN 1.99$ 7 YEARS AGED | FULL VERIFIED

      By UTCHIHAmkt · Posted

      DISCORD : utchiha_market telegram : https://t.me/utchiha_market SELLIX STORE : https://utchihamkt.mysellix.io/ Join our server for more products : https://discord.gg/hoodservices https://campsite.bio/utchihaamkt
    • 911reg
      L2 Interlude Edit Animations

      By 911reg · Posted

      Yes, it is, it's not hard to do (if you know what you're doing); just time consuming.   To make some things clear: 1. You can not create .ukx files with animated skeletalmeshes inside, by using any of the freeshared L2Editors (basically, no support for .psa files) 2. You need a patched UT2003/UT2004. You can either get your own ut2004 and download Gildor's patch from his web, or use any of these: When you use these, you should be able to import both .psk and .psa animations > link the skeletalmesh to the psa > save as .ukx > use ut2down to convert the file to l2 format > encrypt the .ukx with standard l2 encryption (you can use mxc encdec, you can find it in the folder of the l2editor i shared). Your best bet is to use pawnviewer (aka dev mode) to test that. If you have troubles with that process then leave a reply here, otherwise, if it works correctly, you can move on to adding missing animnotify classes to you unrealed, then proper animnotifies, sounds, effects or w/e is missing from your .ukx files. Keep in mind that this is overall not difficult but a huge amount of work (unless you're good at scripting/macros) since you'd need to manually re-create every single animnotify, by hand. If you have doubts or i wasn't clear enough let me know here. (in case you don't know what an animnotify is: UDN - Two - AnimNotifies (unrealengine.com) )  
    • Constellation
      JewStor Service ➤ Verified Accounts, Drop Service etc.

      By Constellation · Posted

      Welcome to JewStor Service!!!   ❖Ready-made verified wallets, exchanges, business banks and to order accounts. ❖EU/UK/US/DE Stuff: 100% Verified! Reliable financial tools for your business. ❖Popular items available include: Stripe business + Payoneer, Deutshce Bank, BBVA ES, Xapo Bank, Revolut business / personal, Santander Bank, Wallester business, Bitsa EU, Binance EU, Qonto Business, Blackcatcard EU, Shopify Payments, ICard EU, N26 EU, Naga Pay EU, Paysera EU, Mistertango Business and many others.

  • Topics

×
×
  • Create New...