mssql

<?php
if (preg_match("/^[a-z0-9]+$/i",$_GET['page']))
{
if (isset($_GET['page'])) {
	$page = $_GET['page']; // Bonne page
} else {
	$page = 1; // Hack man :)
}
}
if(!isset($_SESSION['account']))
{
	require ('Includes/error_connect.php');
}
else
{
?>
<link rel="stylesheet" type="text/css" media="screen" href="Content/Css/shop.css" />
<div class="cbox-ui cbox-title"><h2><a href="index.php?p=shop">Boutique</a></h2></div>
<div class="cbox-ui cbox-content">
	<div class="clearfix"></div>
		<p>
			<p style="text-align: center;">
			<FONT COLOR=#FF0000 >ATTENTION, VEUILLEZ NE PAS ACHETER UN ITEM LORSQUE VOUS ETES CONNECTEZ EN JEU OU VOUS NE POURREZ PAS RECEVOIR L'ITEM. </FONT><br/>
				Tu as <b><?php echo $cashC=DataFromAID('ACCOUNT_TBL','cash',$_SESSION['account']); mssql_query($cashC);     if(empty($cashC)) {echo '0';} ?> <span style="color: #00BFFF;">Liberty</span></b> Point(s) et <b><?php echo $voteC=DataFromAID('ACCOUNT_TBL','vote',$_SESSION['account']); mssql_query($voteC);     if(empty($voteC)) {echo '0';} ?><span style="color: #FFBF00"> Vote</span></b> Point(s).<br/>
				<a href="?p=shop&category=1&page=1">Fonctionels</a>
				- <a href="?p=shop&category=2&page=1">Fashion</a>
				- <a href="?p=shop&category=3&page=1">Armes/Armures</a>
				- <a href="?p=shop&category=4&page=1">Familliers</a>
				- <a href="?p=shop&category=5&page=1">Capes</a>
				- <a href="?p=shop&category=6&page=1">Bijoux</a>
				- <a href="?p=shop&category=7&page=1">Vote</a>
				- <a href="?p=shop&category=8&page=1">HoverBike</a>
				- <a href="?p=shop&category=9&page=1">Masque & Cie</a>
			</p>
			<div class="items">
<?php
	$category = $_GET['category'];

	if (preg_match("/^[a-z0-9]+$/i",$category))
	{
		$nbreitemParPage 		= 4;
		if($page == 1)
		{
		$num_debut 			= 4;
		}
		elseif($page == 2)
		{
		$num_debut 			= 8;
		}
		else
		{
		$num_debut 			= ($page - 1) * $nbreitemParPage;
		}
		//$lol      = mssql_query("Select * FROM Boutique WHERE category = ".$category." ORDER BY id");
		//$anncountPage 	  = mssql_num_rows($annquery);
		$annquery = mssql_query("select * FROM (select top ".$nbreitemParPage." * from (select top ".$num_debut." * from Boutique WHERE category = ".$category."  order by id) as t1 order by id DESC) as t2 order by id");
		$anncount = mssql_num_rows($annquery);
	}

	if($anncount == 0)
	{
?>
				<fieldset id="homeshop">
					<center>
						<h3>Bienvenue a la boutique de Liberty Flyff<br /></h3>
						Vous Pouvez acheter ici des objets avec vos :<br />
						-<span style="color: #00BFFF;">Liberty(PL)</span> Point(s)<br />
						-<span style="color: #FFBF00">Vote(VP)</span> Point(s)
					</center>
				</fieldset>
<?php
	}
	else
	{
		while($annrow = mssql_fetch_array($annquery))
		{

			if (preg_match("/^[a-z0-9]+$/i",$id) || empty($id))
			{
?>
				<a class="item tooltip" href="<?php echo "?p=buy&id=".$annrow['id']; ?>" title="<?php echo $annrow['info'] ?>">
					<span class="name"><?php echo $annrow['name'] ?></span>
					<span class="thumbnail"><img src="<?php echo $annrow['format']; ?>" alt="" /></span>
					<span class="price"><span class="points"><?php echo Payement_Liberty($annrow['id']); ?></span>/<span class="gold"><?php echo Payement_Vote($annrow['id']); ?></span></span>
				</a>
<?php
			}
		}
	}
?>
				<div class="clear"></div>
				<div class="pages">
<?php
	$nombrePages = 6;

	for ($i = 1 ; $i <= $nombrePages ; $i++)
	{
	echo '';
		if ($i == $page) { echo ' <span>Page '.$i.'</span>-'; }
		else { echo ' <a class="current" href="?p=shop&category='.$category.'&page='.$i.'" alt="page '.$i.'">'.$i.'</a> -'; }
	}
?>
				</div>
			</div>
		</p>
		<div class="clearfix"></div>
</div>
<div class="cbox-ui cbox-end"></div>
<?php
}
?>