From c574afadae34bbaf21e065eb398ca7ca964aad26 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sat, 29 Aug 2009 10:46:41 +0000 Subject: - Patch #394182 by chx, Berdir: converted search module to the new database abstraction layer. Rest in peace old database layer. --- modules/comment/comment.module | 11 ++++++++--- 1 file changed, 8 insertions(+), 3 deletions(-) (limited to 'modules/comment/comment.module') diff --git a/modules/comment/comment.module b/modules/comment/comment.module index 883f8036a..4d5dcd0e3 100644 --- a/modules/comment/comment.module +++ b/modules/comment/comment.module @@ -2408,10 +2408,15 @@ function comment_ranking() { return array( 'comments' => array( 'title' => t('Number of comments'), - 'join' => 'LEFT JOIN {node_comment_statistics} node_comment_statistics ON node_comment_statistics.nid = i.sid', + 'join' => array( + 'type' => 'LEFT', + 'table' => 'node_comment_statistics', + 'alias' => 'node_comment_statistics', + 'on' => 'node_comment_statistics.nid = i.sid', + ), // Inverse law that maps the highest reply count on the site to 1 and 0 to 0. - 'score' => '2.0 - 2.0 / (1.0 + node_comment_statistics.comment_count * CAST(%f AS DECIMAL))', - 'arguments' => array(variable_get('node_cron_comments_scale', 0)), + 'score' => '2.0 - 2.0 / (1.0 + node_comment_statistics.comment_count * CAST(:scale AS DECIMAL))', + 'arguments' => array(':scale' => variable_get('node_cron_comments_scale', 0)), ), ); } -- cgit v1.2.3