summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
author3dB <3db@3decibels.net>2009-07-29 16:45:59 -0400
committer3dB <3db@3decibels.net>2009-07-29 16:45:59 -0400
commita04360aa66453809395a09a66ccd63e46a4cf519 (patch)
tree6be0c93ebc01a0e1a1ae432782d65d61ed1a90c5 /lib
parentf713f21acfba72a9a5567592389fad8bcddbebc8 (diff)
Changed sessions.expiration column to timestamp
-- Updated SQL files to reflect column type change. -- Subroutine dbSessionAdd rewritten to accept an expiration timestap as an optional third argument.
Diffstat (limited to 'lib')
-rw-r--r--lib/VNDB/DB/Users.pm13
-rw-r--r--lib/VNDB/Util/Auth.pm2
2 files changed, 11 insertions, 4 deletions
diff --git a/lib/VNDB/DB/Users.pm b/lib/VNDB/DB/Users.pm
index 07ccaf1e..eaed1234 100644
--- a/lib/VNDB/DB/Users.pm
+++ b/lib/VNDB/DB/Users.pm
@@ -112,11 +112,18 @@ sub dbUserDel {
}
-# uid, 40 character session token, expiration time (int)
+# Adds a session to the database
+# If no expiration is supplied the database default is used
+# uid, 40 character session token, expiration time (timestamp)
sub dbSessionAdd {
my($s, @o) = @_;
- $s->dbExec(q|INSERT INTO sessions (uid, token, expiration) VALUES(?, ?, ?)|,
- @o[0..2]);
+ if (defined $o[2]) {
+ $s->dbExec(q|INSERT INTO sessions (uid, token, expiration) VALUES(?, ?, ?)|,
+ @o);
+ } else {
+ $s->dbExec(q|INSERT INTO sessions (uid, token) VALUES(?, ?)|,
+ @o);
+ }
}
diff --git a/lib/VNDB/Util/Auth.pm b/lib/VNDB/Util/Auth.pm
index 3b7b052a..9d14c5ae 100644
--- a/lib/VNDB/Util/Auth.pm
+++ b/lib/VNDB/Util/Auth.pm
@@ -39,7 +39,7 @@ sub authLogin {
my $token = sha1_hex(join('', Time::HiRes::gettimeofday()) . join('', map chr(rand(93)+33), 1..9));
my $expiration = time + 31536000; # 1yr
my $cookie = $token . $self->{_auth}{id};
- $self->dbSessionAdd($self->{_auth}{id}, $token, $expiration);
+ $self->dbSessionAdd($self->{_auth}{id}, $token);
my $expstr = strftime("%a, %d %b %Y %H:%M:%S GMT", gmtime($expiration));
$self->resRedirect($to, 'post');