| |
|
|
| |
|
|
|
query("SELECT * FROM annonces A INNER JOIN annonces_compte C
ON A.ID_P = C.ID_P
AND (A.Type_Ad='bouton carré')
AND (A.Langue_cible_Ad='" . $sLang . "'
OR A.Langue_cible_Ad='tous')
WHERE A.Etat_Ad='ok'
AND C.Etat='ok'
ORDER BY RAND()");
if ($rs_ad) {
while ($continue==1 && $row_ad=$DB_site->fetch_array($rs_ad)) {
if (!date_valide($row_ad['Date_initiale'])) {
$DB_site->query("UPDATE annonces_compte SET Etat='date' WHERE ID_P=" . $row_ad['ID_P']);
}
else if ($row_ad['Solde']<=0) {
$DB_site->query("UPDATE annonces_compte SET Etat='nounit' WHERE ID_P=" . $row_ad['ID_P']);
}
else {
// augmente le nombre de compteurs
$DB_site->query("UPDATE annonces SET Nb_vues_Ad=Nb_vues_Ad+1 WHERE ID_Ad=" . $row_ad['ID_Ad']);
afficher_pub($row_ad['ID_Ad'], $row_ad['Ext_Ad'], $row_ad['Type_Ad'], $row_ad['Codehtml_Ad'], $row_ad['Url_Ad']);
$continue = 0;
}
}
}
?>
|
|
fetch_array($rs_ad)) {
if (!date_valide($row_ad['Date_initiale'])) {
$DB_site->query("UPDATE annonces_compte SET Etat='date' WHERE ID_P=" . $row_ad['ID_P']);
}
else if ($row_ad['Solde']<=0) {
$DB_site->query("UPDATE annonces_compte SET Etat='nounit' WHERE ID_P=" . $row_ad['ID_P']);
}
else {
// augmente le nombre de compteurs
$DB_site->query("UPDATE annonces SET Nb_vues_Ad=Nb_vues_Ad+1 WHERE ID_Ad=" . $row_ad['ID_Ad']);
afficher_pub($row_ad['ID_Ad'], $row_ad['Ext_Ad'], $row_ad['Type_Ad'], $row_ad['Codehtml_Ad'], $row_ad['Url_Ad']);
$continue = 0;
}
}
?>
|
|
fetch_array($rs_ad)) {
if (!date_valide($row_ad['Date_initiale'])) {
$DB_site->query("UPDATE annonces_compte SET Etat='date' WHERE ID_P=" . $row_ad['ID_P']);
}
else if ($row_ad['Solde']<=0) {
$DB_site->query("UPDATE annonces_compte SET Etat='nounit' WHERE ID_P=" . $row_ad['ID_P']);
}
else {
// augmente le nombre de compteurs
$DB_site->query("UPDATE annonces SET Nb_vues_Ad=Nb_vues_Ad+1 WHERE ID_Ad=" . $row_ad['ID_Ad']);
afficher_pub($row_ad['ID_Ad'], $row_ad['Ext_Ad'], $row_ad['Type_Ad'], $row_ad['Codehtml_Ad'], $row_ad['Url_Ad']);
$continue = 0;
}
}
?>
|
|
fetch_array($rs_ad)) {
if (!date_valide($row_ad['Date_initiale'])) {
$DB_site->query("UPDATE annonces_compte SET Etat='date' WHERE ID_P=" . $row_ad['ID_P']);
}
else if ($row_ad['Solde']<=0) {
$DB_site->query("UPDATE annonces_compte SET Etat='nounit' WHERE ID_P=" . $row_ad['ID_P']);
}
else {
// augmente le nombre de compteurs
$DB_site->query("UPDATE annonces SET Nb_vues_Ad=Nb_vues_Ad+1 WHERE ID_Ad=" . $row_ad['ID_Ad']);
afficher_pub($row_ad['ID_Ad'], $row_ad['Ext_Ad'], $row_ad['Type_Ad'], $row_ad['Codehtml_Ad'], $row_ad['Url_Ad']);
$continue = 0;
}
}
?>
|
|
|
| |
|
|
