<?
//fichier de sortie qui fait office de compteur de clics

$shop = (strtolower($_GET['shop'])) ;
$id = intval($_GET['id']);

require_once("forum/config.php"); //variables de l'annuaire
include("inc/biblio/biblio-functions.php"); //fonctions de l'annuaire
require_once(PATH."/lib/bdd.class.php"); 
$conn = new bdd($db_name, $db_user_login,$db_user_pass, $db_host); 

if ($shop == 'amazon') {
	$shop_clic = ", amazon_tot = amazon_tot+1, amazon_encours = amazon_encours+1";
}
//else if ($shop == 'fnac')
//	$shop_clic = ", fnac_tot = fnac_tot+1, fnac_encours = fnac_encours+1";

//creation des requetes pour l'annuaire
$sql_upd = "UPDATE $T_sites SET clic_tot = clic_tot+1, clic_encours = clic_encours+1 :shop_clic WHERE id = :id ";
$value_upd = Array(":shop_clic" => $shop_clic, ":id" => $id);
$sql_sel = "SELECT isbn FROM $T_sites WHERE id = :id ";
$value_sel = Array(":id" => $id);

//envoi des requetes
$sel = $conn->exec_prep_sql($sql_sel, $value_sel);
//envoi de la requete pour comptabiliser le clic
$upd = $conn->exec_prep_sql($sql_upd, $value_upd);

$isbn = $sel[0]["isbn"];

if ($shop == 'amazon') {
	$url = "https://www.amazon.fr/exec/obidos/ASIN/".$isbn."/leportailgeom-21";
}

Header("Location: $url");
//exit;

?>