[AppDB] Fix up user preferences so it shows the proper wine version

[tony_lambregts at telusplanet.net]

Jeremy put my other changes in already but I dicovered that I did not have the 
preferences screen quite right.

Change log: Fix up user preferences so it shows the proper wine version.

Files Changed: preferences.php include/user.php
-------------- next part --------------
Index: preferences.php
===================================================================
RCS file: /home/wine/appdb/preferences.php,v
retrieving revision 1.9
diff -u -r1.9 preferences.php
--- preferences.php	4 Jan 2005 19:36:03 -0000	1.9
+++ preferences.php	4 Jan 2005 19:58:44 -0000
@@ -54,6 +54,7 @@
         $ext_username = $_SESSION['current']->username;
         $ext_realname = $user->lookup_realname($_SESSION['current']->userid);
         $ext_email = $user->lookup_email($_SESSION['current']->userid);
+        $CVSrelease = $user->lookup_CVSrelease($_SESSION['current']->userid);
         
         include(BASE."include/"."form_edit.php");
 
Index: include/user.php
===================================================================
RCS file: /home/wine/appdb/include/user.php,v
retrieving revision 1.18
diff -u -r1.18 user.php
--- include/user.php	4 Jan 2005 19:36:03 -0000	1.18
+++ include/user.php	4 Jan 2005 19:58:45 -0000
@@ -66,6 +66,14 @@
         return lookupEmail($userid);
     }
 
+    function lookup_CVSrelease($userId)
+    {
+        $result = mysql_query("SELECT CVSrelease FROM user_list WHERE userId = '$userId'");
+        if(!$result || mysql_num_rows($result) != 1)
+            return null;
+        $ob = mysql_fetch_object($result);
+        return $ob->CVSrelease;
+    }
 
     /**
      * restore a user from the database