<?

//require "ad_inc.php";
 //Host Name. Usually "localhost".
$hostname = "localhost";
 //Location of ad_click.php relative to the web root.
$redirect = "/bandeau/ad_click.php";
//Database Name
$dbName = "fluvialnet";
//mySQL Database User Name
$username = "patrice";
//mySQL Database Password
$password = "HWjvYLJEmfTBYsdL";
 //mySQL table name
$table = "bandeau";
 //Admin Password for the interface
$admin_pass = "fluvial";


include(dirname(__FILE__).'/cnx.php');


/*Déclaration des variables*/
$pagename = "$PHP_SELF";
$req_id = $QUERY_STRING;
/* Connexion à la base de données */
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Impossible d'ouvrir la base de données");
mysql_select_db( "$dbName") or die( "Impossible d'ouvrir la base de données");
//Get number of ads in the database
$query = "SELECT * FROM $table WHERE id = '$req_id'";
$result = MYSQL_QUERY($query);
$number = MYSQL_NUMROWS($result);
 if($number > 1):
 print "Erreur !";
 endif;
$url    = mysql_result($result,$randomnumber,"url");
$clicks_life  = mysql_result($result,$randomnumber,"clicks_life");
$clicks_day  = mysql_result($result,$randomnumber,"clicks_day");

 //Record the click. 
++$clicks_life;
++$clicks_day;
 //Update the DB with the hit
$update_query = "UPDATE $table SET clicks_life = '$clicks_life' WHERE id = '$req_id'";
$update_result = MYSQL_QUERY($update_query);
$update_query = "UPDATE $table SET clicks_day = '$clicks_day' WHERE id = '$req_id'";
$update_result = MYSQL_QUERY($update_query);

$table="bandeau_stat";
$annee=date("Y");
$mois=date("m");
$insert_query = "INSERT INTO $table (id,annee,mois,type) VALUES ('$req_id','$annee','$mois',2)";
$update_result = MYSQL_QUERY($insert_query);

MYSQL_CLOSE();
header("Location: $url");
?>