- update_global_rank new function : far more intelligent update. Take into

  account the possiblity to have category tree not in category id ascending
  order

- update global_rank when moving categories among the same parent

- new function mass_updates : depending on MySQL version, create a temporary
  table, make one big insert and one big update by joining 2 tables (4.0.4
  or above) or make 1 update per primary key

- function update_category improved for representative_picture_id check :
  only one useful query (equivalent to NOT EXISTS) instead of N (N = number
  of categories) queries


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

1 files changed, 2 insertions, 0 deletions

diff --git a/admin/cat_list.php b/admin/cat_list.php
index eac3869b3..b5404ea0c 100644
--- a/admin/cat_list.php
+++ b/admin/cat_list.php
@@ -208,6 +208,7 @@ UPDATE '.CATEGORIES_TABLE.'
     array_push($categories, $current);
     array_shift($categories);
   }
+  update_global_rank($_GET['parent_id']);
 }
 else if (isset($_GET['down']) and is_numeric($_GET['down']))
 {
@@ -267,6 +268,7 @@ UPDATE '.CATEGORIES_TABLE.'
     array_unshift($categories, $current);
     array_pop($categories);
   }
+  update_global_rank($_GET['parent_id']);
 }
 reset($categories);
 // +-----------------------------------------------------------------------+