From 7b4f21b997358eda567de6a944776d43961da93c Mon Sep 17 00:00:00 2001 From: Gotcha 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 @@

+