[Gforge-commits] gforge/common/include User.class,1.25,1.26

[tom]

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

Modified Files:
        User.class 
Log Message:
Replaced a 'select *' with a 'select count(*)'

Index: User.class
===================================================================
RCS file: /cvsroot/gforge/gforge/common/include/User.class,v
retrieving revision 1.25
retrieving revision 1.26
diff -u -d -r1.25 -r1.26
--- User.class  8 Mar 2004 20:09:54 -0000       1.25
+++ User.class  12 Mar 2004 18:40:39 -0000      1.26
@@ -1145,8 +1145,9 @@
        function getThemeID() {
                global $sys_theme;
                if (!$this->theme_id) {
-                       $res=db_query("SELECT * FROM theme_prefs WHERE 
user_id='".$this->getID()."'");
-                       if (!$res || db_numrows($res) < 1) {
+                       $res=db_query("SELECT count(*) FROM theme_prefs WHERE 
user_id='".$this->getID()."'");
+                       $row_count = db_fetch_array($res);
+                       if (!$res || $row_count['count'] < 1) {
                                $res=db_query("SELECT theme_id FROM themes 
WHERE dirname='$sys_theme'");
                                $this->theme_id=db_result($res,0,'theme_id');
                        } else {