From 26847773312887a4a982e4afd457b3da5fced384 Mon Sep 17 00:00:00 2001 From: brettp Date: Sat, 12 Feb 2011 23:08:00 +0000 Subject: Fixes #2906. Added elgg_sql_reverse_order_by() and wired it up to ege() and ega(). Pass 'reverse_order_by' => true in option arrays. git-svn-id: http://code.elgg.org/elgg/trunk@8184 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/lib/elgglib.php | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) (limited to 'engine/lib/elgglib.php') diff --git a/engine/lib/elgglib.php b/engine/lib/elgglib.php index 12560308e..7ebf918b7 100644 --- a/engine/lib/elgglib.php +++ b/engine/lib/elgglib.php @@ -1658,6 +1658,30 @@ function css_page_handler($page) { echo $return; } +/** + * Reverses the ordering in an ORDER BY clause. This is achived by replacing + * asc with desc, or appending desc to the end of the clause. + * + * This is used mostly for elgg_get_entities() and other similar functions. + * + * @access private + * @param string $order_by An order by clause + */ +function elgg_sql_reverse_order_by_clause($order_by) { + $order_by = strtolower($order_by); + + if (strpos($order_by, ' asc') !== false) { + $return = str_replace(' asc', ' desc', $order_by); + } elseif (strpos($order_by, ' desc') !== false) { + $return = str_replace(' desc', ' asc', $order_by); + } else { + // no order specified, so default to desc since mysql defaults to asc + $return = $order_by . ' desc'; + } + + return $return; +} + /** * Intercepts the index page when Walled Garden mode is enabled. * -- cgit v1.2.3