Jump to content

Recommended Posts

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.

  • 1 month later...
  • 1 year later...
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?

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

  • 3 months later...
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.

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.



  • Posts

    • hello everyone! I am wanting to save the files (Ini. - Data - ) of the EP5 Client: Salvation... But they generate the error "corrupt files"... I tried several versions of L2FileEditor without good results. I need help! Thank you!
    • Opening December 6th at 19:00 (GMT +3)! Open Beta Test from November 30th!   https://l2soe.com/   🌟 Introducing L2 Saga of Eternia: A Revolution in Lineage 2 High Five! 🌟   Dear Lineage 2 enthusiasts, Prepare to witness the future of private servers! L2 Saga of Eternia is not just another High Five project—it’s a game-changing experience designed to compete with the giants of the Lineage 2 private server scene. Built for the community, by the community, we’re here to raise the bar in quality, innovation, and longevity. What Sets Us Apart? 💎 No Wipes, Ever Say goodbye to the fear of losing your progress. Our server is built to last and will never close. Stability and consistency are our promises to you. ⚔️ Weekly New Content Our dedicated development team ensures fresh challenges, events, and updates every week. From custom quests to exclusive features, there will always be something exciting to explore. 💰 No Pay-to-Win Skill and strategy matter most here. Enjoy a balanced gameplay environment where your achievements come from effort, not your wallet. 🌍 A Massive Community With 2000+ players expected, join a vibrant and active community of like-minded adventurers ready to conquer the world of Aden. 🏆 Fair and Competitive Gameplay Our systems are designed to promote healthy competition while avoiding abusive mechanics and exploits. 🔧 Professional Development From advanced bug fixes to carefully curated content, we pride ourselves on smooth performance, no lag, and unparalleled server quality. Key Features Chronicle: High Five with unique interface Rate: Dynamic x10 rates Class Balance: Carefully fine-tuned for a fair experience PvP Focused: PvP Ranking & aura display effect for 3 Top PvPers every week Custom Events: Seasonal and permanent events to keep you engaged Additional Features:   Custom Endgame Content: Introduce unique dungeons, raids, or zones unavailable in other servers. Player-Driven Economy: Implement a strong market system and avoid overinflated drops or rewards. Epic Siege Battles: Announce special large-scale sieges and PvP events. Incentives for Streamers and Clans: Attract influencers and big clans to boost server publicity. Roadmap Transparency: Share a public roadmap of planned updates to build trust and excitemen   Here you can read all the features: https://l2soe.com/features   Video preview: Join the Revolution! This is your chance to be part of something legendary. L2 Saga of Eternia is not just a server; it’s a movement to redefine what Lineage 2 can be. Whether you’re a seasoned veteran or a newcomer to the world of Aden, we invite you to experience Lineage 2 at its finest.   Official Launch Date: December 6th 2024 Website: https://l2soe.com/ Facebook: https://www.facebook.com/l2soe Discord: https://discord.com/invite/l2eternia   Let’s build the ultimate Lineage 2 experience together. See you in-game! 🎮
    • That's like a tutorial on how to run l2 on MacOS Xd but good job for the investigation. 
    • small update: dc robe set sold   wts adena 1kk = 1.5$ 
    • DISCORD : utchiha_market telegram : https://t.me/utchiha_market SELLIX STORE : https://utchihamkt.mysellix.io/ Join our server for more products : https://discord.gg/hood-services https://campsite.bio/utchihaamkt
  • Topics

×
×
  • Create New...