return ($user_obj);
}
+ function user_update_login_time($code, $lintm)
+ {
+ GLOBAL $G_dbpfx;
+
+ $user_sql = sprintf("UPDATE %susers SET (lintm) = (date 'epoch' + %d * INTERVAL '1 second') WHERE code = %d;", $G_dbpfx, $lintm, $code);
+
+ // $user_pg = $this->query($user_sql);
+ // $row_n = pg_affected_rows($user_pg);
+ // fprintf(STDERR, "query: %s NUM: %d\n", ($user_pg == FALSE ? "FALSE" : "TRUE"), $row_n);
+ if ( ! (($user_pg = $this->query($user_sql)) != FALSE && pg_affected_rows($user_pg) == 1) ) {
+ return FALSE;
+ }
+
+ return TRUE;
+ }
+ function user_prefs_update($code, $flags, $supp_comp)
+ {
+ GLOBAL $G_dbpfx;
+
+ $user_sql = sprintf("UPDATE %susers SET (type, supp_comp) = (%d, '%s') WHERE code = %d;",
+ $G_dbpfx, $flags, $supp_comp, $code);
+ fprintf(STDERR, "REQUEST [%s]\n", $user_sql);
+ if ( ! (($user_pg = $this->query($user_sql)) != FALSE && pg_affected_rows($user_pg) == 1) ) {
+ return FALSE;
+ }
+ fprintf(STDERR, "REQUEST GOOD [%s]\n", $user_sql);
+
+ return TRUE;
+ }
function login_verify($login, $pass)
{
log_main("login_verify SUCCESS for ".$login);
$chals->rem($login);
+ $this->user_update_login_time($user_obj->code, time());
$ret = LoginDBItem::LoginDBItemFromRecord($user_obj);
break;
}
$user_sql = sprintf("INSERT INTO %susers ( login, pass, email, type) VALUES ('%s', '%s', '%s', %d);",
$G_dbpfx, escsql(strtolower($olddb->item[$i]->login)), escsql($olddb->item[$i]->pass),
escsql($olddb->item[$i]->email), $olddb->item[$i]->type & USER_FLAG_TY_ALL);
-
- // if ( ! (($user_pg = pg_exec($dbconn,$order_add_sql)) != FALSE && pg_affected_rows($order_pg) == 1) ) {
if ( ! (($user_pg = $this->query($user_sql)) != FALSE && pg_affected_rows($user_pg) == 1) ) {
$cont .= sprintf("ERROR IN LINE: %s\n", eschtml($user_sql));