[geeklog-cvs] geeklog: Minor optimization - only check topics that the current...

[geeklog-cvs at lists.geeklog.net]

changeset 7785:9ebcb963dd75
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/9ebcb963dd75
user: Dirk Haun <dirk at haun-online.de>
date: Sat Mar 13 23:06:12 2010 +0100
description:
Minor optimization - only check topics that the current user can see

diffstat:

 public_html/lib-common.php |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 14c5cfafed82 -r 9ebcb963dd75 public_html/lib-common.php
--- a/public_html/lib-common.php	Fri Mar 12 20:12:08 2010 +0100
+++ b/public_html/lib-common.php	Sat Mar 13 23:06:12 2010 +0100
@@ -1954,7 +1954,7 @@
     $curdate = date( "Y-m-d H:i:s", time() );
 
     // Loop through each topic
-    $sql = "SELECT tid FROM {$_TABLES['topics']}";
+    $sql = "SELECT tid FROM {$_TABLES['topics']}" . COM_getPermSQL();
     $result = DB_query( $sql );
     $num = DB_numRows( $result );
     for( $i = 0; $i < $num; $i++)