<?php


session_start();
error_reporting(0);

/*****************************************************************************************
                          Artiphp Velocity 3 - la base
               copyright : Ronald Guérin - webmaster@artiloo.com
                            http://www.artiloo.com
                      Dernière mise à jour : 20 octobre 2004
******************************************************************************************/

include("adminheader.php");


// affichage des categories

$requete="select id_annucategorie from ".$extension."annucat";
$result=mysql_query($requete, $link);
while ($dossier=mysql_fetch_object($result)) {
  $nom_cat="$dossier->id_annucategorie";

  /*verification de dossier dans la categorie*/
  $requete2="select id_annulien from ".$extension."annulien where id_annucat='$nom_cat' and (pubLien='1' or pubLien='3')";
  $result2=mysql_query($requete2, $link);
  $combien=mysql_numrows($result2);
  $verif=mysql_fetch_object($result2);

	if (! $verif->id_annulien) {
	 $requete="update ".$extension."annucat set nbsitecat ='0' where id_annucategorie='$nom_cat'";
	 $results=mysql_query($requete, $link);
	} else {
	 $requete="update ".$extension."annucat set nbsitecat ='$combien' where id_annucategorie='$nom_cat'";
	 $results=mysql_query($requete, $link);
	}
}


//---------------------------------------------------

// affichage des categories

$requete="select id_annucategorie from ".$extension."annucat where id_annuparentcat='0'";
$result=mysql_query($requete, $link);
while ($dossier=mysql_fetch_object($result)) {

  /*verification de souscat*/
  $requete3="select id_annucategorie from ".$extension."annucat where id_annuparentcat='$dossier->id_annucategorie'";
  $result3=mysql_query($requete3, $link);
  $idsscat=mysql_fetch_object($result3);

	if (! $idsscat->id_annucategorie) {
	 $requete="update ".$extension."annucat set verifansscat='1' where id_annucategorie='$dossier->id_annucategorie'";
	 $results=mysql_query($requete, $link);
	} else {
	 $requete="update ".$extension."annucat set verifansscat='2' where id_annucategorie='$dossier->id_annucategorie'";
	 $results=mysql_query($requete, $link);
	}
}





//mysql_free_result($result);
//-------------------------------------




mysql_close();

?>