From 26452aed650f879803d9211968457696970d44d0 Mon Sep 17 00:00:00 2001
From: z0rglub <z0rglub@piwigo.org>
Date: Fri, 19 Sep 2003 21:40:52 +0000
Subject: A category can have its representative picture

git-svn-id: http://piwigo.org/svn/trunk@133 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 admin/include/functions.php | 29 ++++++++++++++++++++++++++++-
 1 file changed, 28 insertions(+), 1 deletion(-)

(limited to 'admin/include')

diff --git a/admin/include/functions.php b/admin/include/functions.php
index 2763c890e..0f35c2798 100644
--- a/admin/include/functions.php
+++ b/admin/include/functions.php
@@ -291,7 +291,8 @@ function check_favorites( $user_id )
 }
 
 // update_category updates calculated informations about a category :
-// date_last and nb_images
+// date_last and nb_images. It also verifies that the representative picture
+// is really linked to the category.
 function update_category( $id = 'all' )
 {
   if ( $id == 'all' )
@@ -333,6 +334,32 @@ function update_category( $id = 'all' )
     $query.= ' WHERE id = '.$id;
     $query.= ';';
     mysql_query( $query );
+    // updating the representative_picture_id : if the representative
+    // picture of the category is not any more linked to the category, we
+    // have to set representative_picture_id to NULL
+    $query = 'SELECT representative_picture_id';
+    $query.= ' FROM '.PREFIX_TABLE.'categories';
+    $query.= ' WHERE id = '.$id;
+    $row = mysql_fetch_array( mysql_query( $query ) );
+    // if the category has no representative picture (ie
+    // representative_picture_id == NULL) we don't update anything
+    if ( $row['representative_picture_id'] != '' )
+    {
+      $query = 'SELECT image_id';
+      $query.= ' FROM '.PREFIX_TABLE.'image_category';
+      $query.= ' WHERE category_id = '.$id;
+      $query.= ' AND image_id = '.$row['representative_picture_id'];
+      $query.= ';';
+      $result = mysql_query( $query );
+      if ( mysql_num_rows( $result ) == 0 )
+      {
+        $query = 'UPDATE '.PREFIX_TABLE.'categories';
+        $query.= ' SET representative_picture_id = NULL';
+        $query.= ' WHERE id = '.$id;
+        $query.= ';';
+        mysql_query( $query );
+      }
+    }
   }
 }
 
-- 
cgit v1.2.3