diff options
Diffstat (limited to '')
| -rw-r--r-- | admin/miseajour.php | 531 |
1 files changed, 531 insertions, 0 deletions
diff --git a/admin/miseajour.php b/admin/miseajour.php new file mode 100644 index 000000000..53ce3371d --- /dev/null +++ b/admin/miseajour.php @@ -0,0 +1,531 @@ +<? +/*************************************************************************** + * miseajour.php is a part of PhpWebGallery * + * ------------------- * + * last update : Tuesday, July 16, 2002 * + * email : pierrick@z0rglub.com * + * * + ***************************************************************************/ + +/*************************************************************************** + * * + * This program is free software; you can redistribute it and/or modify * + * it under the terms of the GNU General Public License as published by * + * the Free Software Foundation; * + * * + ***************************************************************************/ + include_once( "./include/isadmin.inc.php" ); + + function insert_local_category( $cat_id ) + { + global $prefixeTable,$conf,$page,$HTTP_GET_VARS; + + $site_id = 1; + + // 0. retrieving informations on the category to display + $cat_directory = "../galleries"; + + if ( is_numeric( $cat_id ) ) + { + $result = get_cat_info( $cat_id ); + $cat_directory.= "/".$result['local_dir']; + // 1. display the category name to update + echo " + <img src=\"".$conf['lien_puce']."\" alt=\">\" /><span style=\"font-weight:bold;\">".$result['name'][0]."</span> [ dir : ".$result['last_dir']." ] + <div class=\"retrait\">"; + + // 2. we search pictures of the category only if the update is for all or a cat_id is specified + if ( isset( $page['cat'] ) || $HTTP_GET_VARS['update'] == 'all' ) + { + insert_local_image( $cat_directory, $cat_id ); + update_cat_info( $cat_id ); + } + } + + // 3. we have to remove the categories of the database not present anymore + $query = "select id from $prefixeTable"."categories"; + $query.= " where site_id = $site_id"; + if ( !is_numeric( $cat_id ) ) + { + $query.= " and id_uppercat is NULL;"; + } + else + { + $query.= " and id_uppercat = $cat_id;"; + } + $result = mysql_query( $query ); + while ( $row = mysql_fetch_array( $result ) ) + { + // retrieving the directory + $rep = "../galleries"; + $resultat = get_cat_info( $row['id'] ); + $rep.= "/".$resultat['local_dir']; + + // is the directory present ? + if ( !is_dir( $rep ) ) + { + delete_category( $row['id'] ); + } + } + + // 4. retrieving the sub-directories + $sub_rep = array(); + $i = 0; + $dirs = ""; + if ( $opendir = opendir ( $cat_directory ) ) + { + while ( $file = readdir ( $opendir ) ) + { + if ( $file != "." && $file != ".." && is_dir ( $cat_directory."/".$file ) && $file != "thumbnail" ) + { + $sub_rep[$i++] = $file; + } + } + } + + for ( $i = 0; $i < sizeof( $sub_rep ); $i++ ) + { + // 5. is the category already existing ? we create a subcat if not existing + $category_id = ""; + $query = "select id from $prefixeTable"."categories"; + $query.= " where site_id = $site_id"; + $query.= " and dir = '".$sub_rep[$i]."'"; + if ( !is_numeric( $cat_id ) ) + { + $query.= " and id_uppercat is NULL;"; + } + else + { + $query.= " and id_uppercat = $cat_id;"; + } + $result = mysql_query( $query ); + if ( mysql_num_rows( $result ) == 0 ) + { + // we have to create the category + $query = "insert into $prefixeTable"."categories (dir,site_id,id_uppercat) values ('".$sub_rep[$i]."','$site_id'"; + if ( !is_numeric( $cat_id ) ) + { + $query.= ",NULL"; + } + else + { + $query.= ",'$cat_id'"; + } + $query.= ");"; + mysql_query( $query ); + $category_id = mysql_insert_id(); + } + else + { + // we get the already registered id + $row = mysql_fetch_array( $result ); + $category_id = $row['id']; + } + // 6. recursive call + insert_local_category( $category_id ); + } + + if ( is_numeric( $cat_id ) ) + { + echo " + </div>"; + } + } + + function insert_local_image( $rep, $category_id ) + { + global $prefixeTable,$lang,$conf,$count_new; + + // we have to delete all the images from the database that : + // - are not in the directory anymore + // - don't have the associated thumbnail available anymore + $query = "select id,file,tn_ext from $prefixeTable"."images"; + $query.= " where cat_id = $category_id;"; + $result = mysql_query( $query ); + while ( $row = mysql_fetch_array( $result ) ) + { + $lien_image = $rep."/".$row['file']; + $lien_thumbnail = $rep."/"."thumbnail/".$conf['prefixe_thumbnail'].substr( $row['file'], 0, strrpos( $row['file'], "." ) ).".".$row['tn_ext']; + + if ( !is_file ( $lien_image ) || !is_file ( $lien_thumbnail ) ) + { + if ( !is_file ( $lien_image ) ) + { + echo $row['file']." <span style=\"font-weight:bold;\">".$lang['update_disappeared']."</span><br />"; + } + if ( !is_file ( $lien_thumbnail ) ) + { + echo $row['file']." : <span style=\"font-weight:bold;\">".$lang['update_disappeared_tn']."</span><br />"; + } + // suppression de la base : + delete_image( $row['id'] ); + } + } + + // searching the new images in the directory + $pictures = array(); + $i = 0; + $tn_ext = ""; + $root = ""; + if ( $opendir = opendir ( $rep ) ) + { + while ( $file = readdir ( $opendir ) ) + { + if ( is_file( $rep."/".$file ) && is_image( $rep."/".$file ) ) + { + // is the picture waiting for validation by an administrator ? + $query = "select id from $prefixeTable"."waiting"; + $query.= " where cat_id = $category_id"; + $query.= " and file = '$file';"; + $result = mysql_query( $query ); + if ( mysql_num_rows( $result ) == 0 ) + { + if ( $tn_ext = TN_exist( $rep, $file ) ) + { + // is the picture already in the database ? + $query = "select id from $prefixeTable"."images"; + $query.= " where cat_id = $category_id"; + $query.= " and file = '$file';"; + $result = mysql_query( $query ); + if ( mysql_num_rows( $result ) == 0 ) + { + $pictures[$i] = array(); + $pictures[$i]['file'] = $file; + $pictures[$i]['tn_ext'] = $tn_ext; + $pictures[$i]['date'] = date( "Y-m-d", filemtime ( $rep."/".$file ) ); + $pictures[$i]['filesize'] = floor ( filesize( $rep."/".$file ) / 1024 ); + $image_size = @getimagesize( $rep."/".$file ); + $pictures[$i]['width'] = $image_size[0]; + $pictures[$i]['height'] = $image_size[1]; + $i++; + } + } + else + { + echo "<span style=\"color:red;\">".$lang['update_missing_tn']." : $file (<span style=\"font-weight:bold;\">".$conf['prefixe_thumbnail'].substr( $file, 0, strrpos( $file, "." ) ).".XXX</span>, XXX = gif, png or jpg)</span><br />"; + } + } + } + } + } + // inserting the pictures found in the directory + $root.= "\n".$indent."<root>"; + if ( sizeof( $pictures ) > 0 ) + { + for( $i = 0; $i < sizeof( $pictures ); $i++ ) + { + $query = "insert into $prefixeTable"."images (file,cat_id,date_available,tn_ext,filesize,width,height) values ('".$pictures[$i]['file']."','".$category_id."','".$pictures[$i]['date']."','".$pictures[$i]['tn_ext']."','".$pictures[$i]['filesize']."','".$pictures[$i]['width']."','".$pictures[$i]['height']."');"; + echo" + ".$pictures[$i]['file']." <span style=\"font-weight:bold;\">".$lang['update_research_added']."</span> (".$lang['update_research_tn_ext']." ".$pictures[$i]['tn_ext'].")<br />"; + $count_new++; + mysql_query( $query ); + } + } + } + + // The function "update_cat_info" updates the information about the last online image + // and the number of images in the category + function update_cat_info( $category_id ) + { + global $prefixeTable; + + $query = "select date_available from $prefixeTable"."images"; + $query.= " where cat_id = $category_id"; + $query.= " order by date_available desc limit 0,1;"; + $result = mysql_query( $query ); + $row = mysql_fetch_array( $result ); + $date_last = $row['date_available']; + + $query = "select count(*) as nb_images from $prefixeTable"."images"; + $query.= " where cat_id = $category_id"; + $result = mysql_query( $query ); + $row = mysql_fetch_array( $result ); + $nb_images = $row['nb_images']; + + $query = "update $prefixeTable"."categories"; + $query.= " set date_dernier = '$date_last'"; + $query.= ", nb_images = $nb_images"; + $query.= " where id = $category_id;"; + mysql_query( $query ); + } + + function getContent( $element, $node ) + { + $content = str_replace( "<".$node.">", "", $element ); + $content = str_replace( "</".$node.">", "", $content ); + return $content; + } + + function getChild( $document, $node ) + { + preg_match("/\<".$node.">.*\<\/".$node."\>/U", $document, $retour); + return $retour[0]; + } + + function getChildren( $document, $node ) + { + preg_match_all("/\<".$node.">.*\<\/".$node."\>/U", $document, $retour); + return $retour[0]; + } + + function remote_images() + { + global $conf, $prefixeTable, $lang; + + // 1.is there a file listing.xml ? + $filename = "listing.xml"; + $xml_content = ""; + if ( $fp = @fopen ( $filename, "r" ) ) + { + while ( !feof ( $fp ) ) + { + $xml_content .= fgets ( $fp, 1024 ); + } + @fclose( $file ); + $xml_content = str_replace("\n","",$xml_content); + $xml_content = str_replace("\t","",$xml_content); + } + else + { + return false; + } + $url = getContent( getChild( $xml_content, "url" ), "url" ); + echo "<span style=\"font-weight:bold;color:navy;\">$url</span><br /><br />"; + + // 2. is the site already existing ? + $site_id = ""; + $result = mysql_query( "select id from $prefixeTable"."sites where galleries_url = '$url';" ); + if ( mysql_num_rows($result ) == 0 ) + { + // we have to register this site in the database + mysql_query( "insert into $prefixeTable"."sites (galleries_url) values ('$url');" ); + $site_id = mysql_insert_id(); + } + else + { + // we get the already registered id + $row = mysql_fetch_array( $result ); + $site_id = $row['id']; + } + + // 3. available dirs in the file + insert_remote_category( $xml_content, $site_id, "NULL", 0 ); + } + + // insert_remote_category search the "dir" node of the xml_dir given + // and insert the contained categories if the are not in the database yet. + // The function also delete the categories that are in the database + // and not in the xml_file + function insert_remote_category( $xml_dir, $site_id, $id_uppercat, $level ) + { + global $prefixeTable,$conf;; + + $categories = array(); + $list_dirs = getChildren( $xml_dir, "dir".$level ); + for ( $i = 0; $i < sizeof( $list_dirs ); $i++ ) + { + // is the category already existing ? + $category_id = ""; + $name = getContent( getChild( $list_dirs[$i], "name" ), "name" ); + $categories[$i] = $name; + echo " + <img src=\"".$conf['lien_puce']."\"><span style=\"font-weight:bold;\">$name</span> + <div class=\"retrait\">"; + $query = "select id from $prefixeTable"."categories"; + $query.= " where site_id = '$site_id'"; + $query.= " and dir = '$name'"; + if ( $id_uppercat == "NULL" ) + { + $query.= " and id_uppercat is NULL;"; + } + else + { + $query.= " and id_uppercat = '$id_uppercat';"; + } + //echo "<br />".$query; + $result = mysql_query( $query ); + if ( mysql_num_rows( $result ) == 0 ) + { + // we have to create the category + $query = "insert into $prefixeTable"."categories (dir,site_id,id_uppercat) values ('$name','$site_id'"; + if ( $id_uppercat == "NULL" ) + { + $query.= ",NULL"; + } + else + { + $query.= ",'$id_uppercat'"; + } + $query.= ");"; + //echo "<br />".$query; + mysql_query( $query ); + $category_id = mysql_insert_id(); + } + else + { + // we get the already registered id + $row = mysql_fetch_array( $result ); + $category_id = $row['id']; + } + insert_remote_image( $list_dirs[$i], $category_id ); + update_cat_info( $category_id ); + insert_remote_category( $list_dirs[$i], $site_id, $category_id, $level + 1 ); + echo " + </div>"; + } + // we have to remove the categories of the database not present in the xml file + // (ie deleted from the picture storage server) + $query = "select dir,id from $prefixeTable"."categories"; + $query.= " where site_id = '$site_id'"; + if ( $id_uppercat == "NULL" ) + { + $query.= " and id_uppercat is NULL;"; + } + else + { + $query.= " and id_uppercat = '$id_uppercat';"; + } + $result = mysql_query( $query ); + while ( $row = mysql_fetch_array( $result ) ) + { + // is the category in the xml file ? + if ( !in_array( $row['dir'], $categories ) ) + { + delete_category( $row['id'] ); + } + } + } + + // insert_remote_image search the "root" node of the xml_dir given + // and insert the contained pictures if the are not in the database yet + function insert_remote_image( $xml_dir, $category_id ) + { + global $prefixeTable,$count_new,$lang; + + $root = getChild( $xml_dir, "root" ); + $pictures = array(); + $xml_pictures = getChildren( $root, "picture" ); + for ( $j = 0; $j < sizeof( $xml_pictures ); $j++ ) + { + //<picture> + // <file>albatros.jpg</file> + // <tn_ext>png</tn_ext> + // <date>2002-04-14</date> + // <filesize>35</filesize> + // <width>640</width> + // <height>480</height> + //</picture> + $file = getContent( getChild( $xml_pictures[$j], "file" ), "file" ); + $tn_ext = getContent( getChild( $xml_pictures[$j], "tn_ext" ), "tn_ext" ); + $date = getContent( getChild( $xml_pictures[$j], "date" ), "date" ); + $filesize = getContent( getChild( $xml_pictures[$j], "filesize" ), "filesize" ); + $width = getContent( getChild( $xml_pictures[$j], "width" ), "width" ); + $height = getContent( getChild( $xml_pictures[$j], "height" ), "height" ); + + $pictures[$j] = $file; + + // is the picture already existing in the database ? + $query = "select id,tn_ext from $prefixeTable"."images where cat_id = '$category_id' and file = '$file';"; + $result = mysql_query( $query ); + $query = ""; + if ( mysql_num_rows( $result ) == 0 ) + { + $query = "insert into $prefixeTable"."images (file,cat_id,date_available,tn_ext,filesize,width,height) values ('$file','$category_id','$date','$tn_ext','$filesize','$width','$height');"; + echo" + $file <span style=\"font-weight:bold;\">".$lang['update_research_added']."</span> (".$lang['update_research_tn_ext']." $tn_ext)<br />"; + $count_new++; + } + else + { + // is the tn_ext the same in the xml file and in the database ? + $row = mysql_fetch_array( $result ); + if ( $row['tn_ext'] != $tn_ext ) + { + $query = "update $prefixeTable"."images set tn_ext = '$tn_ext' where cat_id = '$category_id' and file = '$file';"; + } + } + // execution of the query + if ( $query != "" ) + { + mysql_query( $query ); + } + } + // we have to remove the pictures of the database not present in the xml file + // (ie deleted from the picture storage server) + $query = "select id,file from $prefixeTable"."images where cat_id = '$category_id';"; + $result = mysql_query( $query ); + while ( $row = mysql_fetch_array( $result ) ) + { + // is the file in the xml file ? + if ( !in_array( $row['file'], $pictures ) ) + { + delete_image( $row['id'] ); + } + } + } + //------------------------------------------------------------------------------ + echo "<table style=\"width:100%;\">"; + //------------------------------------------------------------------------------ + // Display choice if "update" var is not specified + check_cat_id( $HTTP_GET_VARS['update'] ); + if ( !isset( $HTTP_GET_VARS['update'] ) && !( isset( $page['cat'] ) || $HTTP_GET_VARS['update'] == 'cats' || $HTTP_GET_VARS['update'] == 'all' ) ) + { + echo" + <tr><th>".$lang['update_default_title']."</th></tr> + <tr> + <td> + <div class=\"retrait\"> + <img src=\"".$conf['lien_puce']."\" alt=\">\" /><a href=\"".add_session_id_to_url( "./admin.php?page=miseajour&update=cats" )."\">".$lang['update_only_cat']."</a> + <br /><img src=\"".$conf['lien_puce']."\" alt=\">\" /><a href=\"".add_session_id_to_url( "./admin.php?page=miseajour&update=all" )."\">".$lang['update_all']."</a> + </div> + </td> + </tr>"; + } + //------------------------------------------------------------------------------ + // Recherche des nouvelles images dans les repertoires + else + { + $count_new = 0; + $count_deleted = 0; + echo" + <tr><th>".$lang['update_part_research']."</th></tr> + <tr> + <td> + <div class=\"retrait\">"; + if ( isset( $page['cat'] ) ) + { + insert_local_category( $page['cat'] ); + } + else + { + insert_local_category( "NULL" ); + } + echo "<br /><span style=\"color:blue;\">$count_new ".$lang['update_research_conclusion']."</span>"; + echo "<br /><span style=\"color:red;\">$count_deleted ".$lang['update_deletion_conclusion']."</span>"; + echo " + </div> + </td> + </tr>"; + } + //------------------------------------------------------------------------------ + // Searching new pictures in the file listing.xml from a remote storage server + if ( @is_file( "./listing.xml" ) ) + { + $count_new = 0; + $count_deleted = 0; + echo" + <tr><th>Site distant</th></tr> + <tr> + <td> + <div class=\"retrait\">"; + remote_images(); + echo "<br /><span style=\"color:blue;\">$count_new ".$lang['update_research_conclusion']."</span>"; + echo "<br /><span style=\"color:red;\">$count_deleted ".$lang['update_deletion_conclusion']."</span>"; + echo " + </div> + </td> + </tr>"; + } + //------------------------------------------------------------------------------ + echo "</table>"; +?>
\ No newline at end of file |