// this function aims at generate pictures properties thanks to filename
// and Exif metadata.
// For each picture, it will:
// 1) Read the database
// 2) Adjust the name of the picture
// 3) Read Exit DateTime
// 4) Store these information in the database

include_once( './include/init.inc.php' );
include_once( './include/functions_exif.inc.php' );

// Retrieve auto_incremement
$query = 'SELECT max(id)';
$query.= ' FROM '.PREFIX_TABLE.'images';
$query.= ';';
$result = mysql_query( $query );
while ( $line = mysql_fetch_row( $result ) )
   { $id_max = $line[0]; }
//print($id_max);

for ($id = 1122; $id <= $id_max; $id++)
{
  $array_cat_directories = array();

  // Read the properties stored in database
  $query = 'SELECT file,date_creation,name,comment,author';
  $query.= ',storage_category_id';
  $query.= ' FROM '.PREFIX_TABLE.'images';
//  $query.= ' FROM '.PREFIX_TABLE.'images AS i';
//  $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic ON id=ic.image_id';
//  $query.= $page['where'];
//  $query.= $conf['order_by'];
//  $query.= ' LIMIT '.$page['start'].','.$page['nb_image_page'];
  $query.= ' WHERE id = ' .$id;
  $query.= ';';
  $result = mysql_query( $query );

  while ( $row = mysql_fetch_array( $result ) )
  {
    // retrieving the storage dir of the picture
    if ( $array_cat_directories[$row['storage_category_id']] == '' )
    {
      $array_cat_directories[$row['storage_category_id']] =
        get_complete_dir( $row['storage_category_id'] );
    }
    $cat_directory = $array_cat_directories[$row['storage_category_id']];
    $image_link = $cat_directory.$page['file'];
    $file = get_filename_wo_extension( $row['file'] );

    // Adjust the name of the picture by removing the '015 - ' and
    // replacing the underscores by spaces
    if ( $row['name'] != '' ) $update_name = 0;
    else {
        $name = ereg_replace('^[0-9]_-_', '', $file);
        $name = str_replace( '_', ' ', $name );
        $update_name = 1;
    }
    
    // Copy the name in comment if the filename is too long
    if( ( $row['comment'] != '' ) or (strlen($name) < 25) ) $update_comment = 0;
    else
        $comment = $name;
        $name = substr($name, 0, 25);
        $update_comment = 1;
    }

    // Read Exif DateTime
    if ( $row['date_creation'] != '') $update_date = 0;
    else {
        $date = exif_data( $image_link, array('DateTime'), $lang );
        $update_date = 1;
    }

    $id = $row['id'];
    
    // Update database to store the previous information
    if ( ($update_name == 1) or ($update_date == 1) or ($row['author'] == '') )
    {
        $query = 'UPDATE '.PREFIX_TABLE.'images';
        if ($update_name == 1) $query.= 'SET name = ' .$name;
        if ($update_date == 1) $query.= 'SET date_creation = ' .$date;
        if ($update_comment == 1) $query.= 'SET comment = ' .$comment;
        if ($row['author'] == '') $query.= 'SET author = \'Eric\' ';
        $query.= 'WHERE id = ' .$id;
        $query.= ';';
        mysql_query( $query );
    }
  }
}

mysql_close();