X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=web%2FObj%2Fdbase_pgsql.phh;h=d5b277021b7298f98626be31e10b9e71162be922;hb=42fe80f6f6e6d31736eb2a76420ce4c2015b39c6;hp=e7444255819cb1267ec354400ff35e39ca774fcf;hpb=d805fe6d9173d5de9a5a0e09e1a466f865b66017;p=brisk.git

diff --git a/web/Obj/dbase_pgsql.phh b/web/Obj/dbase_pgsql.phh
index e744425..d5b2770 100644
--- a/web/Obj/dbase_pgsql.phh
+++ b/web/Obj/dbase_pgsql.phh
@@ -157,6 +157,21 @@ class BriskDB
         return ($user_obj);
     }
 
+    function getrecord_bycode($code) {
+        GLOBAL $G_dbpfx;
+
+        $user_sql = sprintf("SELECT * FROM %susers WHERE code = %d;",  $G_dbpfx, $code);
+        if (($user_pg  = $this->query($user_sql)) == FALSE) {
+            return FALSE;
+        }
+        if (pg_numrows($user_pg) != 1)
+            return FALSE;
+
+        $user_obj = pg_fetch_object($user_pg, 0);
+
+        return ($user_obj);
+    }
+
     function user_update_login_time($code, $lintm)
     {
         GLOBAL $G_dbpfx;
@@ -205,7 +220,7 @@ class BriskDB
         GLOBAL $G_dbpfx;
 
         $user_sql = sprintf("UPDATE %susers SET (tos_vers) = ('%s') WHERE code = %d;",
-                            $G_dbpfx, escsql($toss_vers), $code);
+                            $G_dbpfx, escsql($tos_vers), $code);
         fprintf(STDERR, "REQUEST [%s]\n", $user_sql);
         if ( ! (($user_pg  = $this->query($user_sql)) != FALSE && pg_affected_rows($user_pg) == 1) ) {
              return FALSE;
@@ -282,6 +297,17 @@ class BriskDB
         return (LoginDBItem::LoginDBItemFromRecord($user_obj));
     }
 
+    function getitem_bycode($code) {
+        $ret = FALSE;
+
+        log_main("getitem_bycode: ".$code);
+
+        if (($user_obj = $this->getrecord_bycode($code)) == FALSE)
+            return $ret;
+
+        return (LoginDBItem::LoginDBItemFromRecord($user_obj));
+    }
+
     // TODO FOR DB
     function getmail($login)
     {