<?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_categorie from ".$extension."categorie";
$result=mysql_query($requete, $link);
while ($dossier=mysql_fetch_object($result)) {
  $nom_cat="$dossier->id_categorie";

  /*verification de dossier dans la categorie*/
  $requete2="select id_dossier from ".$extension."dossier where id_cat='$nom_cat' and id_parentdos='0' and pubDossier='1'";
  $result2=mysql_query($requete2, $link);
  $combien=mysql_numrows($result2);
  $verif=mysql_fetch_object($result2);

	if (! $verif->id_dossier) {
	 $requete="update ".$extension."categorie set nbdoscat ='0' where id_categorie='$nom_cat'";
	 $results=mysql_query($requete, $link);
	} else {
	 $requete="update ".$extension."categorie set nbdoscat ='$combien' where id_categorie='$nom_cat'";
	 $results=mysql_query($requete, $link);
	}

}


//---------------------------------------------------

// affichage des categories

$requete="select id_categorie from ".$extension."categorie where id_parentcat='0'";
$result=mysql_query($requete, $link);
while ($dossier=mysql_fetch_object($result)) {

  /*verification de souscat*/
  $requete3="select id_categorie from ".$extension."categorie where id_parentcat='$dossier->id_categorie'";
  $result3=mysql_query($requete3, $link);
  $idsscat=mysql_fetch_object($result3);

	if (! $idsscat->id_categorie) {
	 $requete="update ".$extension."categorie set verifsscat='1' where id_categorie='$dossier->id_categorie'";
	 $results=mysql_query($requete, $link);
	} else {
	 $requete="update ".$extension."categorie set verifsscat='2' where id_categorie='$dossier->id_categorie'";
	 $results=mysql_query($requete, $link);
	}
}

//---------------------------------------------------

// affichage des dossiers

$requete="select id_dossier from ".$extension."dossier where pubDossier='1'";
$result=mysql_query($requete, $link);
while ($dossier=mysql_fetch_object($result)) {

  /*verification de suite de dossier*/
  $requete3="select id_dossier from ".$extension."dossier where id_parentdos='$dossier->id_dossier' and pubDossier='1'";
  $result3=mysql_query($requete3, $link);
  $idsuite=mysql_fetch_object($result3);

	if (! $idsuite->id_dossier) {
	 $requete="update ".$extension."dossier set suitedoss='1' where id_dossier='$dossier->id_dossier'";
	 $results=mysql_query($requete, $link);
	} else {
	 $requete="update ".$extension."dossier set suitedoss='2' where id_dossier='$dossier->id_dossier'";
	 $results=mysql_query($requete, $link);
	}
}





//mysql_free_result($result);
//-------------------------------------




mysql_close();

?>