Changeset 5076 for branches/2.0/admin/cat_list.php

Timestamp:

Mar 7, 2010, 5:53:53 PM (14 years ago)

Author:

Gotcha

Message:

Choose the sorting of the categories management
bug:1119

File:

• branches/2.0/admin/cat_list.php (modified) (1 diff)

branches/2.0/admin/cat_list.php

@@ -140 +140 @@
     );
 }
+// 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 = mysql_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')
+    );
+}
 
 // +-----------------------------------------------------------------------+