<? $c=17; $lg="en"; $pg=1; $ch=4; $e=10; ?><?php
require_once('../requires/php/PDO-vK6wGvN0XdN1PRxkZOV2BplwUS4D8s.php');
require_once('../requires/php/ip.php');
require_once('../requires/php/fonctions.php');
$descendre = '../';

try {
	$reponse = $bdd->prepare('SELECT en, hors_cat, groupe, nbsite, popularite, en_abs FROM categories WHERE id = :categorie');
	$reponse->execute(array('categorie' => $c));
} catch (PDOException $e) {
	  require($real.'/requires/php/PDOerror.php');
}
while ($donnees = $reponse->fetch()) {
	$ifr    = $donnees['en'];
	$hors   = $donnees['hors_cat'];
	$groupe = $donnees['groupe'];
	$nbsc   = $donnees['nbsite'];
	$popula = $donnees['popularite'];
	$nom_abs= $donnees['en_abs'];
}

$popula++;

try {
$reponse = $bdd->prepare('UPDATE categories SET  popularite = :popularite WHERE id = :categorie');
$reponse->execute(array('popularite' => $popula,	
						'categorie' => $c
					   ));
} catch (PDOException $e) {
	  require($real.'/requires/php/PDOerror.php');
}


$ce_jour = date("j");
if ($ce_jour<6){ 
	$ordre_affichage = 'cotation DESC'; 
}else{
	$ordre_affichage = 'popularite DESC, cotation DESC'; 
}

switch($hors) {
	case "members": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND members='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "blog": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND blog='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "webcam": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND webcam='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "forums": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND forums='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "shop_vet": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND shop_vet='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "shop_shoe": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND shop_shoe='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "shop_shoep": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND shop_shoep='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "dvd": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND dvd='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "chat": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND chat='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "story": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND story='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "close": 
		$req_where = "etat='F' ORDER BY url ASC, titre ASC"; 
		break;
	
	case "validation": 
		$req_where = "etat='T' ORDER BY url ASC, titre ASC"; 
		break;
	
	case "francais": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND lg_fr='y' ORDER BY ".$ordre_affichage.", titre ASC";
		break;
	
	case "italien": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND lg_it='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "espagnol": 
		$req_where = "etat='A' AND date_ajout <= '$tnow' AND lg_sp='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "allemand": 
		$req_where = "etat='A' and date_ajout <= '$tnow' and lg_de='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "chinois": 
		$req_where = "etat='A' and date_ajout <= '$tnow' and lg_jp='y' ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;
	
	case "ppv": 
		$req_where = "etat='A' and date_ajout <= '$tnow' and (ppv='1' or ppv='2') ORDER BY ".$ordre_affichage.", titre ASC"; 
		break;

	default:
	//categorie classique
	$req_where = "etat='A' AND date_ajout <= '$tnow' AND (c1=$c or c2=$c or c3=$c) ORDER BY ".$ordre_affichage.", titre ASC ";
}

$req_sqlx = "SELECT id_site, titre, date_ajout, date_upd, etat, url, url_pub, c1, c2, c3, description_en, url_www, plus1 FROM sites WHERE ".$req_where;

try {
$reponse = $bdd->query('SELECT COUNT(id_site) FROM sites WHERE '.$req_where);
} catch (PDOException $e) {
	  require($real.'/requires/php/PDOerror.php');
}
while ($donnees = $reponse->fetch()) {
	$nbpic    = $donnees[0];
}   

$b=20; //bas
$h=21; //haut
$e=20; //page
$ch=1;

          $h=$h+$e; if ($nbpic>$b){ $ch=2; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=3; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=4; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=5; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=6; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=7; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=8; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=9; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=10; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=11; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=12; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=13; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=14; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=15; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=16; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=17; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=18; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=19; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=20; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=21; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=22; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=23; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=24; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=25; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=26; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=27; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=28; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=29; }
$b=$b+$e; $h=$h+$e; if ($nbpic>$b){ $ch=30; }

if ($pg!=''){
	$lim = ($pg-1)*$e;
	$limite = "limit $lim,$e";
}else{
	$pg=1;
	$limite = "limit 0,$e";
}

$req_sqlx .= " $limite";


?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<!--[if lt IE 9]>
    <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
<meta name="viewport" content="initial-scale=1.0, width=device-width">
<title>Category - <?php echo "$ifr - page $pg"; ?> - Ducks Feet Links</title>
<link rel="stylesheet" href="<?php echo $descendre ?>css/reset.css">
<link rel="stylesheet" href="<?php echo $descendre ?>css/design.css">
<link rel="stylesheet" href="<?php echo $descendre ?>css/site.css">
</head>
<body>
<?php require_once('../requires/php/google-stats.php'); ?>
<div id="wrapper">
<header>
<?php require_once($descendre.'requires/php/top.php'); ?>
</header>
<div id="whiteFrame">

<div id="left">
<?php require_once( $descendre.'requires/php/left.php'); ?>
</div>

<div id="centre">

<h1>Category - <?php echo "$ifr - page $pg"; ?></h1>

<section class="sites">

<div class="num_all">
<?php
if ($pg!=1){
  $bas = $pg-1;
?>
<a href="<?php echo "$nom_abs$bas.$www_ext"; ?>">&laquo;</a>
<?php
}
$i=1;
while($i<=$ch){

if ($i==$pg){
?>          
<span class="blueBold"><?php echo "$i" ?></span>
<?php
}else{
?>
<a href="<?php echo "$nom_abs$i.$www_ext"; ?>"><?php echo "$i" ?></a>
<?php
}
if ($i!=$ch){ echo ' - '; };
$i++;
}
if ($pg!=$ch){
$haut = $pg+1;
?>
<a href="<?php echo "$nom_abs$haut.$www_ext"; ?>">next page &raquo;</a>
<?php
}
?>
</div>


<?php
try {
$reponse = $bdd->query($req_sqlx);
} catch (PDOException $e) {
	  require($real.'/requires/php/PDOerror.php');
}
while ($donnees = $reponse->fetch()) {
$id_site         = $donnees['id_site'];
$sname           = $donnees['titre'];
$date_ajout      = $donnees['date_ajout'];
$date_upd        = $donnees['date_upd'];
$etat            = $donnees['etat'];
$url             = $donnees['url'];
$url_pub         = $donnees['url_pub'];
$c1              = $donnees['c1'];
$c2              = $donnees['c2'];
$c3              = $donnees['c3'];
$des_en          = $donnees['description_en'];
$url_www         = $donnees['url_www'];
$plus1           = $donnees['plus1'];

/*
if ($url_pub != '') { 
	$iurl = $url_pub; 
	$iurl = str_replace('&','&amp;',$iurl);
}else{ 
	$iurl = $url; 
}
*/

$new_img = '';
if ($date_ajout >= $new_date){ $new_img = ' <img src="../img/new.gif" alt="new">'; }
if ($date_upd >= $new_date){ $new_img = ' <img src="../img/new.gif" alt="new">'; }
if ($plus1 == 'y'){ $new_img = ' <img src="../img/new.gif" alt="new">'; }

$url_image = $url;
//retirer le http://
$nbc = strlen($url_image);
$url_image = substr($url_image,7,$nbc);

//retirer le www.
$nbc = strlen($url_image);
$www = substr($url_image,0,4);
if ($www=='www.') { $url_image = substr($url_image,4,$nbc); }

$url_image = str_replace('.','-',"$url_image");
$url_image = str_replace('/','-',"$url_image");
$url_image = str_replace('~','-',"$url_image");
?>

<div class="siteOne">
<div class="siteOneLeft"><p><a href="<?php echo $descendre ?>sites/<?php echo $url_www ?>.<?php echo $www_ext ?>"><img src="<?php echo $descendre ?><?php if (file_exists("$descendre"."images/www/_$id_site"."-"."$url_image.jpg")) { ?>images/www/_<?php echo "$id_site"."-"."$url_image"; ?><?php }else{ ?>img/empty<?php } ?>.jpg" alt="<?php echo strtolower($sname) ?> image"></a></p></div>
<div class="siteOneRight">
<h3><a href="<?php echo $descendre ?>go/<?php echo $url_www ?>.<?php echo $www_ext ?>" target="_blank"><?php echo strtolower($sname) ?></a></h3>
<h4><a href="<?php echo $descendre ?>go/<?php echo $url_www ?>.<?php echo $www_ext ?>" target="_blank"><?php echo $url ?></a><?php echo $new_img ?></h4>
<p class="siteOneRightDesc"><?php echo ucfirst(strtolower($des_en)) ?></p>
</div>
<div class="clear"></div>
<div class="siteOneLeft">&nbsp;</div>
<div class="siteOneRight"><p class="SiteOneBottom"><a href="<?php echo $descendre ?>sites/<?php echo $url_www ?>.<?php echo $www_ext ?>">See more</a><?php if ($ip == $ipAdmin) { echo '&nbsp;&nbsp;&nbsp;<a href="http://www.ducksfeetlinks.com/1H7457Admin4/site-modifier.php?site='.$id_site.'" target="_blank">.</a>'; } ?></p></div>
<div class="clear"></div>
</div>
<?php
}
?>

<div class="num_all">
<?php
if ($pg!=1){
  $bas = $pg-1;
?>
<a href="<?php echo "$nom_abs$bas.$www_ext"; ?>">&laquo;</a>
<?php
}
$i=1;
while($i<=$ch){

if ($i==$pg){
?>          
<span class="blueBold"><?php echo "$i" ?></span>
<?php
}else{
?>
<a href="<?php echo "$nom_abs$i.$www_ext"; ?>"><?php echo "$i" ?></a>
<?php
}
if ($i!=$ch){ echo ' - '; };
$i++;
}
if ($pg!=$ch){
$haut = $pg+1;
?>
<a href="<?php echo "$nom_abs$haut.$www_ext"; ?>">next page &raquo;</a>
<?php
}
?>
</div>

<nav>
<div class="related">
<h2>Related category</h2>
<?php
$cpt = 0;
try {
$reponse = $bdd->prepare('SELECT id, en, nbsite, en_abs FROM categories WHERE groupe = :groupe AND id != :catEnCours ORDER BY popularite DESC');
$reponse->execute(array('groupe' => $groupe, 'catEnCours' => $c));
} catch (PDOException $e) {
	  require($real.'/requires/php/PDOerror.php');
}
while ($donnees = $reponse->fetch()) {
	$idd      = $donnees['id'];
	$en       = $donnees['en'];
	$nbsc     = $donnees['nbsite'];
	$n_abs    = $donnees['en_abs'];

	$s=''; 
	if ($nbsc > 1) { $s = 's'; } 
	if ($cpt >= 0 ) { $en = ucfirst($en); } 
	if ($cpt != 0) { $ccc .= ', ';  }
	
	$ccc .= "<a href=\"$n_abs"."1.$www_ext\">".$en.'</a> <span class="cnbsi">('.$nbsc.' '.'site'.$s.')</span>';
	
	$cpt++; 
}

echo $ccc; 
?>
</div>
</nav>
</section>

</div>
<div id="right">
<?php $descendre_contri_dossier='../'; $en_contri_dossier = 'contributions/'; require_once($descendre.'requires/php/right.php'); ?>
</div>
<div class="clear"></div>
</div>

<?php require_once($descendre.'requires/php/footer.php'); ?>

</div>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script src="../requires/js/menu.js"></script>
</body>
</html>
<?php
$page = '[en] catégorie - '.$ifr.' - ('.$pg.')';
require_once($descendre.'requires/php/stats.php');
?>