<?
require("connexion.php") ;
require("libfonction.php") ;

$arg = explode("/",substr($_SERVER['PATH_INFO'],1)) ;

$result = mysql_query("select refban,lienimage from bfa.bannierepub where refban='".$arg[0]."' ",$myconnect) ;
$row = mysql_fetch_array($result) ;

// stats clic de pub
	$testinsertupdate = "select count(*) as nombre from bfa.statsbannieres where depot={d'".date("Y-m-d")."'} and refbanniere='".$row["refban"]."'" ;
	$resultatcomptage = mysql_query($testinsertupdate,$myconnect);
	$rowcomptage = mysql_fetch_array($resultatcomptage) ;
	if ($rowcomptage["nombre"]>0) {$requetecomptage = "update bfa.statsbannieres set nombreclicBIG=nombreclicBIG+1 where depot={d'".date("Y-m-d")."'} and refbanniere='".$row["refban"]."'" ;}
	else {$requetecomptage = "insert into bfa.statsbannieres (depot,refbanniere,nombreaffichageBIG,nombreclicBIG) values ({d'".date("Y-m-d")."'},'".$row["refban"]."',0,1)" ;}
	mysql_query($requetecomptage,$myconnect);

header("Location: ".$row['lienimage']);

?>