From 7b4f21b997358eda567de6a944776d43961da93c Mon Sep 17 00:00:00 2001
From: Gotcha <gotcha@piwigo.org>
Date: Sun, 7 Mar 2010 21:09:26 +0000
Subject: Trunk merge r5076 from bug:1119 bug:1119

git-svn-id: http://piwigo.org/svn/trunk@5079 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 admin/cat_list.php               | 23 +++++++++++++++++++++++
 admin/template/goto/cat_list.tpl |  2 ++
 2 files changed, 25 insertions(+)

(limited to 'admin')

diff --git a/admin/cat_list.php b/admin/cat_list.php
index 45eee0732..57abe3f85 100644
--- a/admin/cat_list.php
+++ b/admin/cat_list.php
@@ -132,6 +132,29 @@ SELECT id, name
     l10n('Categories ordered alphanumerically')
     );
 }
+// sort categories alpha-numerically reverse
+else if (isset($_POST['submitOrderAlphaNumReverse']))
+{
+  $query = '
+SELECT id, name
+  FROM '.CATEGORIES_TABLE.'
+  WHERE id_uppercat '.
+    (!isset($_GET['parent_id']) ? 'IS NULL' : '= '.$_GET['parent_id']).'
+;';
+  $result = pwg_query($query);
+  while ($row = pwg_db_fetch_assoc($result))
+  {
+    $categories[ $row['id'] ] = strtolower($row['name']);
+  }
+
+  arsort($categories, SORT_REGULAR);
+  save_categories_order(array_keys($categories));
+
+  array_push(
+    $page['infos'],
+    l10n('Categories ordered alphanumerically reverse')
+    );
+}
 
 // +-----------------------------------------------------------------------+
 // |                            Navigation path                            |
diff --git a/admin/template/goto/cat_list.tpl b/admin/template/goto/cat_list.tpl
index 020e5cff1..379306592 100644
--- a/admin/template/goto/cat_list.tpl
+++ b/admin/template/goto/cat_list.tpl
@@ -41,6 +41,7 @@
   <p>
     <input class="submit" name="submitOrder" type="submit" value="{'Save order'|@translate}" {$TAG_INPUT_ENABLED}>
     <input class="submit" name="submitOrderAlphaNum" type="submit" value="{'Order alphanumerically'|@translate}" {$TAG_INPUT_ENABLED}>
+	<input class="submit" name="submitOrderAlphaNumReverse" type="submit" value="{'Order alphanumerically reverse'|@translate}" {$TAG_INPUT_ENABLED}>
   </p>
   <ul class="categoryUl">
 
@@ -85,6 +86,7 @@
   <p>
     <input class="submit" name="submitOrder" type="submit" value="{'Save order'|@translate}" {$TAG_INPUT_ENABLED}>
     <input class="submit" name="submitOrderAlphaNum" type="submit" value="{'Order alphanumerically'|@translate}" {$TAG_INPUT_ENABLED}>
+	<input class="submit" name="submitOrderAlphaNumReverse" type="submit" value="{'Order alphanumerically reverse'|@translate}" {$TAG_INPUT_ENABLED}>
   </p>
 
 </form>
-- 
cgit v1.2.3