[Top][All Lists]
[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;
}
/**
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gforge-commits] gforge/common/forum Forum.class,1.11,1.12,
tom <=
- Prev by Date:
[Gforge-commits] gforge/www/snippet browse.php, 1.9, 1.10 detail.php, 1.8, 1.9
- Next by Date:
[Gforge-commits] gforge ChangeLog,1.322,1.323
- Previous by thread:
[Gforge-commits] gforge/www/snippet browse.php, 1.9, 1.10 detail.php, 1.8, 1.9
- Next by thread:
[Gforge-commits] gforge ChangeLog,1.322,1.323
- Index(es):