<article class="sidebox">
<h1 class="top"><center><p>Server Status</p></h1>
<section class="body">
<?php
$status = @fsockopen("127.0.0.1", 2106, $errno, $errstr, 1);
if($status >= 1)
{
echo '<center>LoginServer: <font color=green size=2>Online</font>';
}
else
{
echo '<center>LoginServer: <font color=red size=2>Offline</font>';
}
?>
<?php
$status = @fsockopen("127.0.0.1", 7777, $errno, $errstr, 1);
if($status >= 1)
{
echo '<center>GameServer: <font color=green size=2>Online</font>';
}
else
{
echo '<center>GameServer: <font color=red size=2>Offline</font>';
}
echo '<center>Community Board: <font color=red size=2>Desactivada</font>';
echo '<center>Proteccion Ddos: <font color=green size=2>Activado</font>';
echo '<center>Anti SQL Inject: <font color=green size=2>Activado</font>';
?></br>
<?php
$server_ip = "localhost";
$mysql_user = "l2jcris48";
$mysql_pass = "19951997";
$database = "l2jcris48";
$connect = mysql_connect("$server_ip", "$mysql_user", "$mysql_pass") or die(mysql_error());
$db_select = mysql_select_db("$database", $connect) or die(mysql_error());
$query = mysql_query("SELECT online FROM characters WHERE online =0") or die(mysql_error()) ;
$online_chars = mysql_num_rows($query);
{
echo 'Personajes Online: '.$online_chars;
}
mysql_close($connect);
?></br>
<?php
$server_ip = "localhost";
$mysql_user = "l2jcris48";
$mysql_pass = "19951997";
$database = "l2jcris48";
$connect = mysql_connect("$server_ip", "$mysql_user", "$mysql_pass") or die(mysql_error());
$db_select = mysql_select_db("$database", $connect) or die(mysql_error());
$characters = mysql_query("SELECT * FROM characters") or die(mysql_error()) ;
$accounts = mysql_query("SELECT * FROM accounts") or die(mysql_error()) ;
$total_char = mysql_num_rows($characters);
$total_acc = mysql_num_rows($accounts);
echo 'Personajes Creados: '.$total_char.'</br>';
echo 'Cuentas Creadas: '.$total_acc;
mysql_close($connect);
?>
<article class="sidebox">
<h1 class="top"><p><center>Top 10 PVP List</p></h1>
<section class="body">
<table width="250px;">
<?php
$connection = mysql_connect("localhost", "l2jcris48", "19951997") or die("La conexi�n no est� disponible!");
mysql_select_db("l2jcris48", $connection) or die("Base de datos no est� disponible!");
$q = mysql_query("SELECT * FROM characters WHERE pvpkills > 0 AND accesslevel = 0 ORDER BY pvpkills DESC LIMIT 10");
$i = 1;
if ($q) {
while ($char = mysql_fetch_array($q))
{
echo "<tr>";
echo "<td style='width:11px;color:#FFFFFF;'>" . $i . ".</td>";
echo "<td style='width:20px;color:#FFFFFF;'>" . $char['char_name'] . "</td>";
echo "<td style='width:20px;text-align:right;padding-left:22px;color:#FF0000;'>" . $char['pvpkills'] . "</td>";
echo "</tr>";
$i++;
}
}
?></table>
</section>
</article>
<article class="sidebox">
<h1 class="top"><p><center>Top 10 PK List</p></h1>
<section class="body">
<table width="250px;">
<?php
$connection = mysql_connect("localhost", "l2jcris48", "19951997") or die("La conexi�n no est� disponible!");
mysql_select_db("l2jcris48", $connection) or die("Base de datos no est� disponible!");
$q = mysql_query("SELECT * FROM characters WHERE pvpkills > 0 AND accesslevel = 0 ORDER BY pkkills DESC LIMIT 10");
$i = 1;
if ($q) {
while ($char = mysql_fetch_array($q))
{
echo "<tr>";
echo "<td style='width:11px;color:#FFFFFF;'>" . $i . ".</td>";
echo "<td style='width:20px;color:#FFFFFF;'>" . $char['char_name'] . "</td>";
echo "<td style='width:20px;text-align:right;padding-left:22px;color:#FF0000;'>" . $char['pkkills'] . "</td>";
echo "</tr>";
$i++;
}
}
?></table>