Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- else if(preg_match("/^order[=|:](comments)[_]?(desc|asc)?$/i", $event->term, $matches)){
- $ord = strtolower($matches[1]);
- $default_order_for_column = "ASC";
- $sort = isset($matches[2]) ? strtoupper($matches[2]) : $default_order_for_column;
- $cmt_query = "SELECT image_id, COUNT(*) AS cnt FROM comments GROUP BY image_id ORDER BY cnt $sort, image_id DESC";
- $cached_order = implode(",", $database->get_col($database->scoreql_to_sql($cmt_query)));;
- Image::$order_sql = "FIELD(images.id, $cached_order) DESC";
- $event->add_querylet(new Querylet("images.id IN ($cached_order)"));
- $event->add_querylet(new Querylet("1=1")); //small hack to avoid metatag being treated as normal tag
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement