$recup = "SELECT * FROM "."$prefixe_mysql"."vrgpub WHERE datedebut != '' AND datefin != ''";
$envoi = mysql_query($recup);
while($tableau = mysql_fetch_array($envoi))
{
$gdate_nom = $tableau['nompub'];
$gdate_actif = $tableau['actif'];
$gdate_datedebut = $tableau['datedebut'];
$gdate_datefin = $tableau['datefin'];
// Format de la date jj/mm/aaaa (ex:23/03/1991)
$gdate_today_d = date("d");
$gdate_today_m = date("m");
$gdate_today_Y = date("Y");
// Activer la pub si la date de début est passé
if($gdate_actif==0)
{
$gdate_datedebut_d = substr($gdate_datedebut, 0, 2);
$gdate_datedebut_m = substr($gdate_datedebut, 3, 2);
$gdate_datedebut_Y = substr($gdate_datedebut, 6, 4);
if($gdate_today_Y>$gdate_datedebut_Y)
{
$activer_debut = $gdate_nom;
}
if($gdate_today_Y==$gdate_datedebut_Y)
{
if($gdate_today_m>$gdate_datedebut_m)
{
$activer_debut = $gdate_nom;
}
if($gdate_today_m==$gdate_datedebut_m)
{
if($gdate_today_d==$gdate_datedebut_d)
{
$activer_debut = $gdate_nom;
}
if($gdate_today_d>$gdate_datedebut_d)
{
$activer_debut = $gdate_nom;
}
}
}
}
// Activation ...
if(isset($activer_debut))
{
$requete = "UPDATE "."$prefixe_mysql"."vrgpub SET actif = 1 WHERE nompub IN ('$activer_debut')";
mysql_query($requete);
}
// Désactiver la pub si la de de fin est passé
if($gdate_actif==1)
{
$gdate_datefin_d = substr($gdate_datefin, 0, 2);
$gdate_datefin_m = substr($gdate_datefin, 3, 2);
$gdate_datefin_Y = substr($gdate_datefin, 6, 4);
if($gdate_today_Y>$gdate_datefin_Y)
{
$desactiver_debut = $gdate_nom;
}
if($gdate_today_Y==$gdate_datefin_Y)
{
if($gdate_today_m>$gdate_datefin_m)
{
$desactiver_debut = $gdate_nom;
}
if($gdate_today_m==$gdate_datefin_m)
{
if($gdate_today_d==$gdate_datefin_d)
{
$desactiver_debut = $gdate_nom;
}
if($gdate_today_d>$gdate_datefin_d)
{
$desactiver_debut = $gdate_nom;
}
}
}
}
}
// désactivation ...
if(isset($desactiver_debut))
{
$requete = "UPDATE "."$prefixe_mysql"."vrgpub SET actif = 0, affires='', clicres='', datedebut = '', datefin = '' WHERE nompub IN ('$desactiver_debut')";
mysql_query($requete);
}
// <------------------- Fin de Date début et fin ----------------->
$recup = "SELECT * FROM "."$prefixe_mysql"."vrgpub_options WHERE rang IN ('1')";
$envoi = mysql_query($recup);
while($tableau = mysql_fetch_array($envoi))
{
$nomli = $tableau['nomli'];
}
$vrgpubemp=$_GET['vrgpubemp'];
$requete = "SELECT COUNT(nompub) AS Cpt FROM "."$prefixe_mysql"."vrgpub WHERE emplacement IN ('$vrgpubemp') AND actif IN ('1')";
$query = mysql_query($requete);
$array = mysql_fetch_array($query);
$nbpub=$array['Cpt'];
$nbpub=$nbpub-1;
$banaffi=rand(0,$nbpub);
$recup = "SELECT * FROM "."$prefixe_mysql"."vrgpub WHERE emplacement IN ('$vrgpubemp') AND actif IN ('1') LIMIT $banaffi,1";
$envoi = mysql_query($recup);
while($tableau = mysql_fetch_array($envoi))
{
$nompub = $tableau['nompub'];
$vrgpub_emplacement = $tableau['emplacement'];
$code = $tableau['code'];
$affires = $tableau['affires'];
}
// + 1 affichages
$requete = "UPDATE "."$prefixe_mysql"."vrgpub SET affi = affi + 1 WHERE nompub IN ('$nompub')";
mysql_query($requete);
// Affichages restants
if($affires!=0)
{
$requete = "UPDATE "."$prefixe_mysql"."vrgpub SET affires = affires - 1 WHERE nompub IN ('$nompub')";
mysql_query($requete);
}
if($affires==1)
{
$requete = "UPDATE "."$prefixe_mysql"."vrgpub SET actif = 0, affires='', clicres='', datedebut = '', datefin = '' WHERE nompub IN ('$nompub')";
mysql_query($requete);
}
// Affichage de la publicité
if($nomli=="") echo""._ESPACE_GERE_PUB."','white', 100)\" onMouseout=\"hideddrivetip()\">$code
";
else echo"$code";
// Statistiques ---------------------------->
$vrgpub_date_stats = date("d/m");
$vrgpub_jour_stats = date("z");
$recup = "SELECT * FROM "."$prefixe_mysql"."vrgpub_stats WHERE date IN ('$vrgpub_date_stats') AND emplacement IN ('$vrgpub_emplacement')";
$envoi = mysql_query($recup);
while($tableau = mysql_fetch_array($envoi))
{
$verif_emplacement = $tableau['emplacement'];
}
if(isset($verif_emplacement))
{
// Stats déja entrer aujourd'hui pour cet emplacement
$requete = "UPDATE "."$prefixe_mysql"."vrgpub_stats SET affi = affi + 1 WHERE date IN ('$vrgpub_date_stats') AND emplacement IN ('$vrgpub_emplacement')";
mysql_query($requete);
}
else
{
// Stats pas entrer ... Nouvelle données
$requete = "INSERT INTO "."$prefixe_mysql"."vrgpub_stats VALUES ('$vrgpub_emplacement','$vrgpub_jour_stats','$vrgpub_date_stats','0','1')";
mysql_query($requete);
}
// Delete OLD stats (plus vieilles que 101 jours)
$vrgpub_old_delete_stats = date('z', time() - 8726400);
if($vrgpub_old_delete_stats>$vrgpub_jour_stats)
{
$requete = "DELETE FROM "."$prefixe_mysql"."vrgpub_stats WHERE jour < ('$vrgpub_old_delete_stats') AND jour > ('$vrgpub_jour_stats')";
mysql_query($requete);
}
else
{
$requete = "DELETE FROM "."$prefixe_mysql"."vrgpub_stats WHERE jour < ('$vrgpub_old_delete_stats') OR jour > ('$vrgpub_jour_stats')";
mysql_query($requete);
}
?>