[pLog-svn] r1756 - plog/branches/plog-1.0.1/class/summary/dao

oscar at devel.plogworld.net oscar at devel.plogworld.net
Tue Apr 5 19:43:56 GMT 2005


Author: oscar
Date: 2005-04-05 19:43:55 +0000 (Tue, 05 Apr 2005)
New Revision: 1756

Modified:
   plog/branches/plog-1.0.1/class/summary/dao/summarystats.class.php
Log:
same optimizations to the summary, hope this will help...

Modified: plog/branches/plog-1.0.1/class/summary/dao/summarystats.class.php
===================================================================
--- plog/branches/plog-1.0.1/class/summary/dao/summarystats.class.php	2005-04-05 19:43:24 UTC (rev 1755)
+++ plog/branches/plog-1.0.1/class/summary/dao/summarystats.class.php	2005-04-05 19:43:55 UTC (rev 1756)
@@ -99,11 +99,7 @@
                                    a.num_reads as num_reads,
                                    a.slug as slug,
                                    t.article_id as article_id,
-                                   t.text as text,
-                                   t.topic as topic,
-                                   t.normalized_text as normalized_text,
-                                   t.normalized_topic as normalized_topic,
-                                   t.mangled_topic as mangled_topic
+                                   t.text as text
                                FROM {$prefix}articles a, {$prefix}articles_text t, {$prefix}blogs b
                                WHERE a.id = t.article_id 
                                    AND a.status = ".POST_STATUS_PUBLISHED."
@@ -114,8 +110,8 @@
 			if( $ignoreTopic != "" )
 				$query .= " AND t.topic NOT LIKE '".Db::qstr( $ignoreTopic )."' ";
 
-			if( $ignoreText != "" )
-				$query .= " AND t.text NOT LIKE '".Db::qstr( $ignoreText )."' ";
+			/*if( $ignoreText != "" )
+				$query .= " AND t.text NOT LIKE '".Db::qstr( $ignoreText )."' ";*/
 
 			$query .= " ORDER BY a.num_reads DESC ";
 




More information about the pLog-svn mailing list