try that script
<?php include "config/stats.php" ?>
<?php
mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error());
mysql_select_db($db_name) or die(mysql_error());
//Online Players
$query = ("SELECT * FROM characters WHERE online=1 and accesslevel>=0");
$result = mysql_query($query) or die(mysql_error());
$num2=mysql_numrows($result);
$sum=$num2;
mysql_close();
mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error());
mysql_select_db($db_name) or die(mysql_error());
?>
then add to your web:
<?php print ("$sum"); ?>
create new folder named config in the main directory of the host
and create new file named stats.php
place there:
<?php
$db_user = "root";
$db_pass = "db pass";
$db_name = "l2jdb";
$db_serv = "db ip";
$res = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]");
$resdb = mysql_select_db ( "$db_name",$res );
return $res;
?>
I hope to work