search improved

git-svn-id: http://piwigo.org/svn/trunk@17 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 0 insertions, 531 deletions

diff --git a/admin/miseajour.php b/admin/miseajour.php
deleted file mode 100644
index 53ce3371d..000000000
--- a/admin/miseajour.php
+++ /dev/null
@@ -1,531 +0,0 @@
-<?
-/***************************************************************************
- *                  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=\"&gt;\" /><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=\"&gt;\" /><a href=\"".add_session_id_to_url( "./admin.php?page=miseajour&amp;update=cats" )."\">".$lang['update_only_cat']."</a>
-				<br /><img src=\"".$conf['lien_puce']."\" alt=\"&gt;\" /><a href=\"".add_session_id_to_url( "./admin.php?page=miseajour&amp;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