gforge-commits
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gforge-commits] gforge/common/forum Forum.class,1.11,1.12


From: tom
Subject: [Gforge-commits] gforge/common/forum Forum.class,1.11,1.12
Date: Thu, 11 Mar 2004 15:22:10 -0600

Update of /cvsroot/gforge/gforge/common/forum
In directory db.perdue.net:/tmp/cvs-serv13494/common/forum

Modified Files:
        Forum.class 
Log Message:
Replaced a 'select *' with a 'select count(*)' in forum monitoring SQL query

Index: Forum.class
===================================================================
RCS file: /cvsroot/gforge/gforge/common/forum/Forum.class,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- Forum.class 12 Feb 2003 17:23:47 -0000      1.11
+++ Forum.class 11 Mar 2004 21:22:07 -0000      1.12
@@ -408,16 +408,10 @@
                if (!session_loggedin()) {
                        return false;
                }
-               $sql="SELECT * FROM forum_monitored_forums
-                       WHERE user_id='".user_getid()."' AND 
forum_id='".$this->getID()."';";
-
+               $sql="SELECT count(*) FROM forum_monitored_forums WHERE 
user_id='".user_getid()."' AND forum_id='".$this->getID()."';";
                $result = db_query($sql);
-
-               if (!$result || db_numrows($result) < 1) {
-                       return false;
-               } else {
-                       return true;
-               }
+    $row_count = db_fetch_array($result);
+               return $result && $row_count['count'] > 0;
        }
 
        /**





reply via email to

[Prev in Thread] Current Thread [Next in Thread]