[Help]help with code L2J 

Newbie Spellweaver
Joined
Sep 18, 2006
Messages
79
Reaction score
0
Location
Latvia
Hello!
There is a code. Block in CMS system. Shows server status and players online. I need to add how many acconts and sharacters are at server. Can you help please?

Code:
<?php

////Server Status//////

error_reporting(0);
$IP = array(
"Login Server: " => "127.0.0.1:2106",
" Game Server: " => "127.0.0.1:7777",
); while(list($ServerName,$Host)=each($IP)) {
list($IPAddress,$Port)=explode(":",$Host);
$content .=($ServerName);
if($fp=fsockopen($IPAddress,$Port,$ERROR_NO,$ERROR_STR,(float)0.5)) {
$content .=("<font color='green'>On-line </font><br>");
fclose($fp);
}
else {
$content .= ("<font color='red'>Off-line </font><br>");
}
}

////Players online//////

$dbhost="localhost"; ////Mysql Server
$dbname="l2jdb";  //// Base name
$dbuser="root";   //// Base user
$dbpass="password";       //// Base pass

$msc=MYSQL_CONNECT($dbhost,$dbuser,$dbpass) or die ("Ошибка БД");
MYSQL_SELECT_DB($dbname) or die ("BD Error");

$get_config_data="SELECT online FROM characters WHERE online>0";
$config_data=MYSQL_QUERY($get_config_data);
$config['num_online']=mysql_num_rows($config_data);
$content .= " Игроков онлайн ";  
$content .= ("<font color='green'>".$config['num_online']."</font>");

MYSQL_CLOSE($msc);
?>
 
Use this :

PHP:
<?php
error_reporting(0);

$db_user = "YOUR MySQL LOGINNAME"; 
$db_pass = "YOUR MySQL PASSOWRD"; 
$db_name = "YOUR L2 GAME SERVER DB"; 
$db_serv = "YOUR MySQL SERVER ADRESS"; 

$res = mysql_connect ( $db_serv, $db_user, $db_pass );
mysql_select_db($db_name, $res);
      
$online = mysql_query("SELECT * FROM characters WHERE online=1");
$naccounts = mysql_num_rows($online);
print("<table border=0><tr><td colspan=2 align=center>".$naccounts." Players are Online on our Server.</td></tr>");

mysql_close($res);

$flogin = fsockopen ("YOUR LOGINSERVER IP",2106, $errno, $errstr,1);
$fgame = fsockopen ("YOUR GAMESERVER IP",7777, $errno, $errstr,1);
   
if ( $flogin )
    $FORM1 .= "<tr><td align=center>Login Server : <font color='#00FF00'><b>ONLINE</b></font></td></tr>"; 
else 
    $FORM1 .= "<tr><td align=center>Login Server : <font color='#FF0000'><b>OFFLINE<b></font></td></tr>";  
    
echo $FORM1;

if ( $fgame )
    $FORM2 .= "<tr><td align=center>GameServer Server : <font color='#00FF00'><b>ONLINE</b></font></td></tr>"; 
else 
    $FORM2 .= "<tr><td align=center>GameServer Server : <font color='#FF0000'><b>OFFLINE<b></font></td></tr>";  
    
echo $FORM2;    
?>
 
Upvote 0
Back