aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-08-05 17:35:43 +0000
committerz0rglub <z0rglub@piwigo.org>2004-08-05 17:35:43 +0000
commit74bc00f9f70bb3a00059b712acd5a8196f17a1fb (patch)
treedde79df9b4d877fcedca781228abc20124448587
parented5aeef0e8c94a6d65678fab6376d43a87d3ad4c (diff)
- non picture files management
- refactoring - function delete_category and delete_element now runs with an array of ids in parameters instead of a single id. git-svn-id: http://piwigo.org/svn/trunk@467 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--admin/include/functions.php215
1 files changed, 128 insertions, 87 deletions
diff --git a/admin/include/functions.php b/admin/include/functions.php
index 7bc3e52eb..2d3965f85 100644
--- a/admin/include/functions.php
+++ b/admin/include/functions.php
@@ -63,23 +63,23 @@ function is_image( $filename, $create_thumbnail = false )
}
/**
- * returns an array with all picture files according to $conf['picture_ext']
+ * returns an array with all picture files according to $conf['file_ext']
*
* @param string $dir
* @return array
*/
-function get_picture_files( $dir )
+function get_pwg_files($dir)
{
global $conf;
$pictures = array();
- if ( $opendir = opendir( $dir ) )
+ if ($opendir = opendir($dir))
{
- while ( $file = readdir( $opendir ) )
+ while ($file = readdir($opendir))
{
- if ( in_array( get_extension( $file ), $conf['picture_ext'] ) )
+ if (in_array(get_extension($file), $conf['file_ext']))
{
- array_push( $pictures, $file );
+ array_push($pictures, $file);
}
}
}
@@ -93,27 +93,52 @@ function get_picture_files( $dir )
* @param string $dir
* @return array
*/
-function get_thumb_files( $dir )
+function get_thumb_files($dir)
{
global $conf;
- $prefix_length = strlen( $conf['prefix_thumbnail'] );
+ $prefix_length = strlen($conf['prefix_thumbnail']);
$thumbnails = array();
- if ( $opendir = @opendir( $dir ) )
+ if ($opendir = @opendir($dir.'/thumbnail'))
{
- while ( $file = readdir( $opendir ) )
+ while ($file = readdir($opendir))
{
- if ( in_array( get_extension( $file ), $conf['picture_ext'] )
- and substr($file,0,$prefix_length) == $conf['prefix_thumbnail'] )
+ if (in_array(get_extension($file), $conf['picture_ext'])
+ and substr($file, 0, $prefix_length) == $conf['prefix_thumbnail'])
{
- array_push( $thumbnails, $file );
+ array_push($thumbnails, $file);
}
}
}
return $thumbnails;
}
+/**
+ * returns an array with representative picture files of a directory
+ * according to $conf['picture_ext']
+ *
+ * @param string $dir
+ * @return array
+ */
+function get_representative_files($dir)
+{
+ global $conf;
+
+ $pictures = array();
+ if ($opendir = @opendir($dir.'/representative'))
+ {
+ while ($file = readdir($opendir))
+ {
+ if (in_array(get_extension($file), $conf['picture_ext']))
+ {
+ array_push($pictures, $file);
+ }
+ }
+ }
+ return $pictures;
+}
+
function TN_exists( $dir, $file )
{
global $conf;
@@ -130,116 +155,132 @@ function TN_exists( $dir, $file )
}
-// The function delete_site deletes a site
-// and call the function delete_category for each primary category of the site
+// The function delete_site deletes a site and call the function
+// delete_categories for each primary category of the site
function delete_site( $id )
{
// destruction of the categories of the site
- $query = 'SELECT id';
- $query.= ' FROM '.CATEGORIES_TABLE;
- $query.= ' WHERE site_id = '.$id;
- $query.= ';';
- $result = mysql_query( $query );
- while ( $row = mysql_fetch_array( $result ) )
+ $query = '
+SELECT id
+ FROM '.CATEGORIES_TABLE.'
+ WHERE site_id = '.$id.'
+;';
+ $result = mysql_query($query);
+ $category_ids = array();
+ while ($row = mysql_fetch_array($result))
{
- delete_category( $row['id'] );
+ array_push($category_ids, $row['id']);
}
+ delete_categories($category_ids);
// destruction of the site
- $query = 'DELETE FROM '.PREFIX_TABLE.'sites';
- $query.= ' WHERE id = '.$id;
- $query.= ';';
- mysql_query( $query );
+ $query = '
+DELETE FROM '.SITES_TABLE.'
+ WHERE id = '.$id.'
+;';
+ mysql_query($query);
}
-// The function delete_category deletes the category identified by the $id
-// It also deletes (in the database) :
-// - all the images of the images (thanks to delete_image, see further)
-// - all the links between images and this category
+// The function delete_categories deletes the categories identified by the
+// (numeric) key of the array $ids. It also deletes (in the database) :
+// - all the elements of the category (delete_elements, see further)
+// - all the links between elements and this category
// - all the restrictions linked to the category
// The function works recursively.
-function delete_category( $id )
+function delete_categories($ids)
{
- // destruction of all the related images
- $query = 'SELECT id';
- $query.= ' FROM '.PREFIX_TABLE.'images';
- $query.= ' WHERE storage_category_id = '.$id;
- $query.= ';';
- $result = mysql_query( $query );
- while ( $row = mysql_fetch_array( $result ) )
+ // destruction of all the related elements
+ $query = '
+SELECT id
+ FROM '.IMAGES_TABLE.'
+ WHERE storage_category_id IN ('.implode(',', $ids).')
+;';
+ $result = mysql_query($query);
+ $element_ids = array();
+ while ($row = mysql_fetch_array($result))
{
- delete_image( $row['id'] );
+ array_push($element_ids, $row['id']);
}
+ delete_elements($element_ids);
// destruction of the links between images and this category
- $query = 'DELETE FROM '.PREFIX_TABLE.'image_category';
- $query.= ' WHERE category_id = '.$id;
- $query.= ';';
- mysql_query( $query );
+ $query = '
+DELETE FROM '.IMAGE_CATEGORY_TABLE.'
+ WHERE category_id IN ('.implode(',', $ids).')
+;';
+ mysql_query($query);
// destruction of the access linked to the category
- $query = 'DELETE FROM '.PREFIX_TABLE.'user_access';
- $query.= ' WHERE cat_id = '.$id;
- $query.= ';';
- mysql_query( $query );
- $query = 'DELETE FROM '.PREFIX_TABLE.'group_access';
- $query.= ' WHERE cat_id = '.$id;
- $query.= ';';
- mysql_query( $query );
+ $query = '
+DELETE FROM '.USER_ACCESS_TABLE.'
+ WHERE cat_id IN ('.implode(',', $ids).')
+;';
+ mysql_query($query);
+ $query = '
+DELETE FROM '.GROUP_ACCESS_TABLE.'
+ WHERE cat_id IN ('.implode(',', $ids).')
+;';
+ mysql_query($query);
// destruction of the sub-categories
- $query = 'SELECT id';
- $query.= ' FROM '.CATEGORIES_TABLE;
- $query.= ' WHERE id_uppercat = '.$id;
- $query.= ';';
- $result = mysql_query( $query );
- while( $row = mysql_fetch_array( $result ) )
+ $query = '
+SELECT id
+ FROM '.CATEGORIES_TABLE.'
+ WHERE id_uppercat IN ('.implode(',', $ids).')
+;';
+ $result = mysql_query($query);
+ $subcat_ids = array();
+ while($row = mysql_fetch_array($result))
{
- delete_category( $row['id'] );
+ array_push($subcat_ids, $row['id']);
}
+ delete_categories($subcat_ids);
// destruction of the category
- $query = 'DELETE FROM '.CATEGORIES_TABLE;
- $query.= ' WHERE id = '.$id;
- $query.= ';';
- mysql_query( $query );
+ $query = '
+DELETE FROM '.CATEGORIES_TABLE.'
+ WHERE id IN ('.implode(',', $ids).')
+;';
+ mysql_query($query);
}
-// The function delete_image deletes the image identified by the $id
-// It also deletes (in the database) :
-// - all the comments related to the image
-// - all the links between categories and this image
-// - all the favorites associated to the image
-function delete_image( $id )
+// The function delete_elements deletes the elements identified by the
+// (numeric) values of the array $ids. It also deletes (in the database) :
+// - all the comments related to elements
+// - all the links between categories and elements
+// - all the favorites associated to elements
+function delete_elements($ids)
{
- global $count_deleted;
-
// destruction of the comments on the image
- $query = 'DELETE FROM '.PREFIX_TABLE.'comments';
- $query.= ' WHERE image_id = '.$id;
- $query.= ';';
- mysql_query( $query );
+ $query = '
+DELETE FROM '.COMMENTS_TABLE.'
+ WHERE image_id IN ('.implode(',', $ids).')
+;';
+ echo '<pre>'.$query.'</pre>';
+ mysql_query($query);
// destruction of the links between images and this category
- $query = 'DELETE FROM '.PREFIX_TABLE.'image_category';
- $query.= ' WHERE image_id = '.$id;
- $query.= ';';
- mysql_query( $query );
+ $query = '
+DELETE FROM '.IMAGE_CATEGORY_TABLE.'
+ WHERE image_id IN ('.implode(',', $ids).')
+;';
+ mysql_query($query);
// destruction of the favorites associated with the picture
- $query = 'DELETE FROM '.PREFIX_TABLE.'favorites';
- $query.= ' WHERE image_id = '.$id;
- $query.= ';';
- mysql_query( $query );
+ $query = '
+DELETE FROM '.FAVORITES_TABLE.'
+ WHERE image_id IN ('.implode(',', $ids).')
+;';
+ mysql_query($query);
// destruction of the image
- $query = 'DELETE FROM '.PREFIX_TABLE.'images';
- $query.= ' WHERE id = '.$id;
- $query.= ';';
- mysql_query( $query );
- $count_deleted++;
+ $query = '
+DELETE FROM '.IMAGES_TABLE.'
+ WHERE id IN ('.implode(',', $ids).')
+;';
+ mysql_query($query);
}
// The delete_user function delete a user identified by the $user_id