aboutsummaryrefslogtreecommitdiffstats
path: root/admin/include
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2003-09-19 21:40:52 +0000
committerz0rglub <z0rglub@piwigo.org>2003-09-19 21:40:52 +0000
commit26452aed650f879803d9211968457696970d44d0 (patch)
tree55a210cc1f6ac25f9ca79bb5ed9e290bdfd62e2d /admin/include
parentb7a5a44944fcf0f20a8e4ab26143962ec8d0a86e (diff)
A category can have its representative picture
git-svn-id: http://piwigo.org/svn/trunk@133 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'admin/include')
-rw-r--r--admin/include/functions.php29
1 files changed, 28 insertions, 1 deletions
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 );
+ }
+ }
}
}