<?php 
   //-------------------------------------- 
   // s'inspirer du fichier include/mysql.inc.php pour les 5 premiers paramètres 
   $cfgBase='z0rglub_database'; 
   $cfgUser='user'; 
   $cfgPassword='pipo'; 
   $cfgHote='localhost'; 
   $prefixeTable='phpwebgallery_'; 
    
   $prefixe_thumbnail = 'TN-'; 
   $url_diapo = "http://localhost/demo/"; 
   //-------------------------------------- 
    
   // variables : 
  // $cat['comment'] 
  // $cat['dir'] 
  // $cat['last_dir'] 
  // $cat['name'] is an array : 
  //      - $cat['name'][0] is the lowest cat name 
  //      and 
  //      - $cat['name'][n] is the most uppercat name findable 
  // $cat['nb_images'] 
  // $cat['id_uppercat'] 
  // $cat['site_id'] 
  function get_cat_info( $id ) 
  { 
    global $prefixeTable; 
     
    $cat = array(); 
    $cat['name'] = array(); 
     
    $query = "select nb_images,id_uppercat,comment,site_id,galleries_url,dir "; 
    $query.= "from $prefixeTable"."categories as a, $prefixeTable"."sites as b "; 
    $query.= "where a.id = $id "; 
    $query.= "and a.site_id = b.id;"; 
    $row = mysql_fetch_array( mysql_query( $query ) ); 
    $cat['site_id'] = $row['site_id']; 
    $cat['id_uppercat'] = $row['id_uppercat']; 
    $cat['comment'] = nl2br( $row['comment'] ); 
    $cat['nb_images'] = $row['nb_images']; 
    $cat['last_dir'] = $row['dir']; 
    $galleries_url = $row['galleries_url']; 
     
    $cat['dir'] = ""; 
    $i = 0; 
    $is_root = false; 
    $row['id_uppercat'] = $id; 
    while ( !$is_root ) 
    { 
      $query = "select name,dir,id_uppercat "; 
      $query.= "from $prefixeTable"."categories "; 
      $query.= "where id = ".$row['id_uppercat'].";"; 
      $row = mysql_fetch_array( mysql_query( $query ) ); 
      $cat['dir'] = $row['dir']."/".$cat['dir']; 
      if ( $row['name'] == "" ) 
      { 
        $cat['name'][$i] = str_replace( "_", " ", $row['dir'] ); 
      } 
      else 
      { 
        $cat['name'][$i] = $row['name']; 
      } 
      if ( $row['id_uppercat'] == "" ) 
      { 
        $is_root = true; 
      } 
      $i++; 
    } 
    $cat['local_dir'] = substr( $cat['dir'], 0 , strlen( $cat['dir'] ) - 1 ); 
    $cat['dir'] = $galleries_url.$cat['dir']; 
    $cat['galleries_url'] = $galleries_url; 
     
    return $cat; 
  } 
    
   mysql_connect( $cfgHote, $cfgUser, $cfgPassword ) or die ( "Can't connect to server" ); 
   mysql_select_db( $cfgBase ) or die ( "Can't connect to database" ); 
    
   $query = "select id,cat_id,tn_ext,file from $prefixeTable"."images order by rand() limit 0,1;"; 
   $result = mysql_query( $query ); 
   $row = mysql_fetch_array( $result ); 
   $resultat = get_cat_info( $row['cat_id'] ); 
   $file = substr ( $row['file'], 0, strrpos ( $row['file'], ".") ); 
   if ( $resultat['site_id'] != 1 ) 
   { 
     $url = $resultat['galleries_url']; 
  } 
  else 
  { 
    $url.= "galleries/"; 
  } 
   $lien_thumbnail .= $url.$resultat['local_dir']."/thumbnail/".$prefixe_thumbnail.$file.".".$row['tn_ext']; 
    
   // trouver le numéro dans la liste des images de la catégorie 
   $query = "select id from $prefixeTable"."images where cat_id = ".$row['cat_id']; 
   $query.= " order by date_available desc, file asc;"; 
   $result = mysql_query( $query ); 
   $i = -1; 
   $is_found = false; 
   while ( ( $row2 = mysql_fetch_array( $result ) ) && !$is_found ) 
   { 
      $i++; 
      if ( $row2['id'] == $row['id'] ) 
      { 
         $is_found = true; 
      } 
   } 
    
   echo "<a href="".$url_diapo."photo.php?cat=".$row['cat_id']."&num=$i">"; 
   echo "<img src="$lien_thumbnail" alt="" />"; 
   echo "</a>"; 
?>