![](\"http://www.gralon.net/plogo-gralon.gif\")
');
";
}else
{
if(!$type){$type=1;}
$TAB=array();
$ZONETAB=ARRAY();
$j=0;
$request="CLT_PUB=\"$ID\" and TYPE_PUB=$type";
$phrase=$argv[0];
$phrase=eregi_replace("ID=[0-9]{1,3}&","",$phrase);
$TABZ=explode("&",$phrase);
while(list($key,$valeur) = each($TABZ))
{
$valeur=rawurldecode($valeur);
eregi("ZONE([0-9]{1,2})=([a-zA-Z0-9./_~+éèàïêîöô :-]*)",$valeur,$TAB2);
$nz=$TAB2[1];
$tz=$TAB2[2];
//echo"$nz --> $tz
";
$ZONETAB[$nz]="$tz";
}
while(list($nzone,$vzone) = each ($ZONETAB))
{
if($vzone!="")
{
//$vzone= rawurldecode($vzone);
$request .=" and ZONE".$nzone."_PUB like \"%$vzone%\"";
//echo"$request
";
}else{
$request .=" and SPEC_PUB=0";
}
}
$request .= " and DATED_PUB <= NOW() and DATEF_PUB >= NOW() and MAXAFF_PUB >= AFFI_PUB and MAXCLI_PUB >= CLICK_PUB and TYPE_PUB=$type;";
//$sql="select ID_PUB,SRC_PUB,AFFI_PUB,POIDS_PUB,TYPE_PUB,SORT_PUB,HTML_PUB from PUB where $request";
$sql="select ID_PUB,SRC_PUB,AFFI_PUB,POIDS_PUB,TYPE_PUB,SORT_PUB,HTML_PUB from PUB where CLT_PUB=\"$ID\" and TYPE_PUB=$type";
//echo $sql;
//echo"$sql";
$result=mysql_query($sql,$conn);
$numero=mysql_num_rows($result);
######################################################################################
################ cas pas de reponse aux criteres #####################################
######################################################################################
if ($numero=="0")
{
$sql2="select ID_PUB,SRC_PUB,POIDS_PUB,SORT_PUB,HTML_PUB from PUB where CLT_PUB=\"$ID\" and TYPE_PUB=$type and DATED_PUB <= NOW() and DATEF_PUB >= NOW() and MAXAFF_PUB >= AFFI_PUB and MAXCLI_PUB >= CLICK_PUB and SPEC_PUB=0";
$result2=mysql_query($sql2,$conn);
while(list($ID_PUB,$SRC_PUB,$POIDS_PUB,$SORT_PUB,$HTML_PUB) = mysql_fetch_row($result2))
{
for ($k=1; $k <= $POIDS_PUB; $k++)
{
$TAB[$j++]="$ID_PUB|$SRC_PUB|$SORT_PUB|$HTML_PUB";
}
}
$count=count($TAB);
srand((double)microtime()*1000000);
if ($count=="1"){$rand=0;}else{$rand=rand(0,$count-1);}
$infos=split("\|","$TAB[$rand]",4);
$ID_PUB="$infos[0]";
$SRC_PUB="$infos[1]";
$SORT_PUB="$infos[2]";
$HTML_PUB="$infos[3]";
srand((double)microtime()*1000000);
$random=rand(0,1000000);
if($SORT_PUB==1)
{
echo"
document.write('![](\"$SRC_PUB\")
');
";
}else{
$HTML_PUB=eregi_replace("\n","","$HTML_PUB");
$HTML_PUB=stripslashes("$HTML_PUB");
echo"
document.write('$HTML_PUB');
";
}
//mysql_query("update PUB set AFFI_PUB=AFFI_PUB+1 where ID_PUB=$ID_PUB",$conn);
if ($HTTP_X_FORWARDED_FOR !="" && $HTTP_X_FORWARDED_FOR !="unknown")
{
$TABIP=split(",",$HTTP_X_FORWARDED_FOR,2);
$IP=$TABIP[0];
}else{
$IP=$REMOTE_ADDR;
}
//mysql_query("insert into AFFICHAGE(IP_AFFI,DATE_AFFI,IDBAN_AFFI,CLT_AFFI) values (\"$IP\",NOW(),\"$ID_PUB\",\"$ID\")",$conn);
}else{
#####################################################################################
################## reponses aux criteres ############################################
#####################################################################################
while(list($ID_PUB,$SRC_PUB,$AFFI_PUB,$POIDS_PUB,$TYPE_PUB,$SORT_PUB,$HTML_PUB) = mysql_fetch_row($result))
{
for ($k=1; $k <= $POIDS_PUB; $k++)
{
$TAB[$j++]="$ID_PUB|$SRC_PUB|$SORT_PUB|$HTML_PUB";
}
}
$count=count($TAB);
srand((double)microtime()*1000000);
if ($count=="1"){$rand=0;}else{$rand=rand(0,$count-1);}
$infos=split("\|","$TAB[$rand]",4);
$ID_PUB="$infos[0]";
$SRC_PUB="$infos[1]";
$SORT_PUB="$infos[2]";
$HTML_PUB="$infos[3]";
srand((double)microtime()*1000000);
$random=rand(0,1000000);
if($SORT_PUB == 1)
{
echo"
document.write('');
";
}else{
echo"
document.write('$HTML_PUB');
";
}
//mysql_query("update PUB set AFFI_PUB=AFFI_PUB+1 where ID_PUB=$ID_PUB",$conn);
if ($HTTP_X_FORWARDED_FOR !="" && $HTTP_X_FORWARDED_FOR !="unknown")
{
$TABIP=split(",",$HTTP_X_FORWARDED_FOR,2);
$IP=$TABIP[0];
}else{
$IP=$REMOTE_ADDR;
}
//mysql_query("insert into AFFICHAGE(IP_AFFI,DATE_AFFI,IDBAN_AFFI,CLT_AFFI) values (\"$IP\",NOW(),\"$ID_PUB\",\"$ID\")",$conn);
}
}
?>