<?php
include("header.php");
?>

<h3><b>Registered users</b></h3>
<br>
<br>
<?php
	if (!isset($_POST['Submit']))
	{
	echo '<form id="users-stats" name="users-stats" method="post" action="users.php">
		<font face="arial" size="4">
                <h3> Please fill in a username </h3>
              <br>
              <br>
		Username<br>
		<input name="Username" type="text" class="textfield" id="Username" />
		<br>
		<br>
		</font>
		<input name="Submit" type="Submit" value="Search"/>
		</form>';
	}
	else
	{
		echo '<META HTTP-EQUIV=Refresh CONTENT="0; URL=users.php?q='.$_POST['Username'].'">';
	}

require_once('sex');

$i=1;


if (!isset($_GET['q']) && isset($_POST['Submit']))
{
		echo $_SESSION['Test'];
	if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }
	$_SESSION['Test'] = 0;
	$start_from = ($page-1) * 100;

	$result = mysql_query("SELECT * FROM `Users` ORDER BY `Users`.`Username` Asc LIMIT ".$start_from.", 100");
	echo mysql_num_rows($result);
	if (mysql_num_rows($result) == 0)
	{
		echo '<table width="100%" bgcolor="white" border="1" cellspacing="0">';
		echo '<tr>';
		echo '	<td><font style="color:black";><b>No users found</b></font></td>';
		echo '</tr>';
	}
	else
	{
		echo '<table width="100%" bgcolor="white" border="1" cellspacing="0">';
		echo '<tr>';
		echo '	<td><font style="color:black";><b>Username</b></font></td>';
		echo '</tr>';
		while ($x = mysql_fetch_assoc($result))
		{
			echo '<tr>
					<td><b><a style="color:#666;;" href="users-stats.php?name='.$x['Username'].'">'.$x['Username'].'</a></b></td>
			</tr>';
			$i++;
		}
		$rs_result = mysql_query("SELECT COUNT(Acc_ID) FROM `Users`");
		$row1 = mysql_fetch_row($rs_result);
		$total_records = $row1[0];
		$total_pages = ceil($total_records / 100);

		echo "Page: ";
		for ($i=1; $i<=$total_pages; $i++) {
				if ($i != $page)
				{
					echo "<a href='users.php?page=".$i."'>[".$i."]</a> ";
				}
				else
				{
					echo '<a style="color: black;text-decoration:none">['.$i.']</a> ';
				}
		}
		echo '</table>';
	}
}
else
{
	if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }
	$start_from = ($page-1) * 100;
	echo '<table width="100%" bgcolor="white" border="1" cellspacing="0">';
	echo '<tr>';
	echo '	<td><font style="color:black";><b>Username</b></font></td>';
	echo '</tr>';

	$result = mysql_query("SELECT * FROM `Users` WHERE `Username` LIKE '%".$_GET['q']."%' ORDER BY `Users`.`Username` Asc LIMIT ".$start_from.", 100");
	while ($x = mysql_fetch_assoc($result))
	{
		echo '<tr>
		        <td><b><a style="color:#666;;" href="users-stats.php?name='.$x['Username'].'">'.$x['Username'].'</a></b></td>';
		$i++;
	}
	$rs_result = mysql_query("SELECT COUNT(Acc_ID) FROM `Users` WHERE `Username` LIKE '%".$_GET['q']."%'");
	$row1 = mysql_fetch_row($rs_result);
	$total_records = $row1[0];
	$total_pages = ceil($total_records / 100);

	echo "Page: ";
	for ($i=1; $i<=$total_pages; $i++) {
			if ($i != $page)
			{
				echo "<a href='users.php?q=".$_GET['q']."&page=".$i."'>[".$i."]</a> ";
			}
			else
			{
				echo '<a style="color: black;text-decoration:none">['.$i.']</a> ';
			}
	}
	echo '</table>';
}
include("footer.php");
?>