Changeset 467 for trunk/admin/include/functions.php

Timestamp:

Aug 5, 2004, 7:35:43 PM (20 years ago)

Author:

z0rglub

Message:

• 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.

File:

• trunk/admin/include/functions.php (modified) (3 diffs)

trunk/admin/include/functions.php

@@ -64 +64 @@
 
 /**
- * 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 ) )
-  {
-    while ( $file = readdir( $opendir ) )
-    {
-      if ( in_array( get_extension( $file ), $conf['picture_ext'] ) )
+  if ($opendir = opendir($dir))
+  {
+    while ($file = readdir($opendir))
+    {
+      if (in_array(get_extension($file), $conf['file_ext']))
       {
-        array_push( $pictures, $file );
+        array_push($pictures, $file);
       }
     }
@@ -94 +94 @@
  * @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 ) )
-  {
-    while ( $file = readdir( $opendir ) )
-    {
-      if ( in_array( get_extension( $file ), $conf['picture_ext'] )
-           and substr($file,0,$prefix_length) == $conf['prefix_thumbnail'] )
+  if ($opendir = @opendir($dir.'/thumbnail'))
+  {
+    while ($file = readdir($opendir))
+    {
+      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;
 }
 
@@ -131 +156 @@
         
 
-// 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 ) )
-  {
-    delete_category( $row['id'] );
-  }
+  $query = '
+SELECT id
+  FROM '.CATEGORIES_TABLE.'
+  WHERE site_id = '.$id.'
+;';
+  $result = mysql_query($query);
+  $category_ids = array();
+  while ($row = mysql_fetch_array($result))
+  {
+    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 )
-{
-  // 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 ) )
-  {
-    delete_image( $row['id'] );
-  }
+function delete_categories($ids)
+{
+  // 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))
+  {
+    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 ) )
-  {
-    delete_category( $row['id'] );
-  }
+  $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))
+  {
+    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 )
-{
-  global $count_deleted;
-                
+// 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)
+{
   // 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);
 }