<?php
include("include/_mysql.php");
$db = mysql_connect($host,$username,$password);
mysql_select_db($database,$db) or die ("Unable to select database");
session_start();
if(!session_is_registered(myusername))
{
$query=" Select * from DatabaseCuentas where key=$myusername";
$result=mysql_query($query);
echo mysql_error();
$lol = $this1;
$lol = $lol - 19;
$tabelle = "DatabaseCuentas";
if ($_POST["suchbegriff"])
{

	$sql = "SELECT * FROM ".$tabelle." WHERE key=$myusername LIKE ('%".mysql_real_escape_string(utf8_decode($_POST["suchbegriff"]))."%')";


	$result = mysql_query($sql);

while($row = mysql_fetch_object($result))
	{

		$lastname = stripslashes($row->key);
		$data = $row->data;
		//echo "$lastname - $data";
		//echo utf8_encode($row->key);
		list($pass,$ammopacks,$exp,$level,$null,$status2,) = split(" ",$data,6);

		if($status > 1)
		{
			$status = 1;
		}
		if($XP < 0)
		{
			$XP = 0;
		}
		$TeamPower = substr($data,-3,-1);
		$Awarnes = substr($data,-5,-3);
		$gravity = substr($data,-8,-5);
	}
}
else
{
	while($row = mysql_fetch_array($result))
	{

		$player = gg_get_player('rank',$lol++);
		if($player === false) break;
		$i = $lol -1 ;
		$lastname = stripslashes($player['key']);
		$data = $player['data'];

		list($pass,$ammopacks,$exp,$level,$null,$status2,) = split(" ",$data,6);

		if($status > 9999)
		{
			$status = 9999;
		}
		if($XP < 0)
		{
			$XP = 0;
		}
	}
}

	//echo "<p>&nbsp;</p>";
	echo "<table align='center' cellpadding='0' cellspacing='1'>";
	echo "<tr>";
	echo "<form name='form1' method='post' action='checklogin.php'>";
	echo "<td>";
	echo "<table width='20%' border='0' cellpadding='0' cellspacing='0'>";
	echo "<tr>";
	//echo "<td colspan='3'><strong><font color='#FF0000'>Member Login</strong></font></td>";
	echo "</tr>";
	echo "<tr>";
	echo "<td width='20'><font color='#FF0000'><b>Usuario</b></font></td>";
	echo "<td width='6'>:&nbsp;</td>";
	echo "<td width='294'>";
	echo "<input name='myusername' type='text' id='myusername' size='20' value='Username'></td>";
	echo "<td><font color='#FF0000'><b>&nbsp;Contraseña</b></font></td>";
	echo "<td>:&nbsp;</td>";
	echo "<td>";
	echo "<input name='mypassword' type='text' id='mypassword' size='20' value='******'></td>";
	echo "<td><input type='submit' name='Submit' value='Login'></td>";
	echo "</tr>";
	echo "</table>";
	echo "</td>";
	echo "</form>";
	echo "</tr>";
	echo "</table>";

	//echo "<div align='center'>";
	//echo "<table style='border-collapse: collapse; border-top-width: 0px' border='0' cellpadding='6' cellspacing='0' width='500' bordercolor='#111111'>";
	//echo " <tr align='left'>";
	//echo "<td class='vbmenu_control' width='125'>";
	//echo " <a href='index.php'><font color='#000000'>Home</a></font></td>";
	//echo " <td class='vbmenu_control' width='150'>";
	//echo " <a href='index.php'><font color='#000000'>User List</a></font></td>";
	//echo " <td style='cursor: pointer;' id='navbar_search' class='vbmenu_control' width='75'>";
	//echo " <a accesskey='4' rel='nofollow' href='search.php'><font color='#000000'>Search</font></a> ";
	//echo " <td style='cursor: pointer;' id='navbar_search' class='vbmenu_control' width='105'>";
	//echo "  <a href='login.php'><font color='#000000'>Login</font></a> ";
	//echo "  </td>";
	//echo " </tr>";
	//echo "</table>";
	//echo "</div>";


}
else
{
	//echo "<p>&nbsp;</p>";
	echo "<p align='center'><font color='#FF0000' font size='1'><b>Logueado como <font color='#360000' font size='1'>$myusername&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></b><font color='#000000' font size='1'>Ammopacks: $ammopacks - Experiencia: $exp - Nivel: $level - Estado: $status2</font></p>";
	echo "<div align='center'>";
	//echo "<table style='border-collapse: collapse; border-top-width: 0px' border='0' cellpadding='6' cellspacing='0' width='500' bordercolor='#111111'>";
	//echo " <tr align='left'>";
	//echo "<td class='vbmenu_control' width='125'>";
	//echo " <a href='index.php'><font color='#000000'>Home</a></font></td>";
	//echo "<td class='vbmenu_control' width='125'>";
	//echo " <a href='edit_skills.php'><font color='#000000'>My Skills</a></font></td>";
	//echo " <td class='vbmenu_control' width='75'>";
	//echo " <a href='settings.php'><font color='#000000'>Settings</a></font></td>";
	//echo " <td class='vbmenu_control' width='150'>";
	//echo " <a href='index.php'><font color='#000000'>User List</a></font></td>";
	//echo " <td style='cursor: pointer;' id='navbar_search' class='vbmenu_control' width='75'>";
	//echo " <a accesskey='4' rel='nofollow' href='search.php'><font color='#000000'>Search</font></a> ";
	//echo " <td style='cursor: pointer;' id='navbar_search' class='vbmenu_control' width='105'>";
	//echo "  <a href='logout.php'><font color='#000000'>Log Out</font></a> ";
	//echo "  </td>";
	//echo " </tr>";
	//echo "</table>";
	//echo "</div>";

}
$page_name="index.php?site=stats";
$page=$_GET['page'];
if(strlen($page) > 0 and !is_numeric($page))
{
	echo "Data Error";
	exit;
}

$eu = ($page - 0);
$limit = 30;                                 // No of records to be shown per page.
$this1 = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;

$query2=" SELECT * FROM DatabaseCuentas";
$result2=mysql_query($query2);
echo mysql_error();
$nume=mysql_num_rows($result2);


echo ("<title>MonsterMod stats by One</title>");
?>