diff options
| author | Dan McGee <dan@archlinux.org> | 2011-10-21 23:03:41 +0200 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-10-24 17:57:53 +0200 |
| commit | a21739aae5daece7098652a0f7f8b7fd36b8fcc6 (patch) | |
| tree | 76f0e08d8316008f60d9b4179f5fa09ae51f0666 | |
| parent | e6ecdcc835e9a612e5c5842867c01f0efdceb789 (diff) | |
| download | aur-a21739aae5daece7098652a0f7f8b7fd36b8fcc6.tar.gz aur-a21739aae5daece7098652a0f7f8b7fd36b8fcc6.tar.xz | |
Add LastLogin column to Users table
Signed-off-by: Dan McGee <dan@archlinux.org>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
| -rw-r--r-- | UPGRADING | 7 | ||||
| -rw-r--r-- | support/schema/aur-schema.sql | 1 | ||||
| -rw-r--r-- | web/lib/acctfuncs.inc.php | 5 |
3 files changed, 12 insertions, 1 deletions
@@ -1,6 +1,13 @@ Upgrading ========= +From 1.9.0 to 1.9.X +------------------- + +1. Add new "Users" table login date column: + +ALTER TABLE Users ADD COLUMN LastLogin BIGINT NOT NULL DEFAULT 0; + From 1.8.2 to 1.9.0 ------------------- diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 544ed941..6c8feca8 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -32,6 +32,7 @@ CREATE TABLE Users ( LangPreference VARCHAR(5) NOT NULL DEFAULT 'en', IRCNick VARCHAR(32) NOT NULL DEFAULT '', LastVoted BIGINT UNSIGNED NOT NULL DEFAULT 0, + LastLogin BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (ID), UNIQUE (Username), UNIQUE (Email), diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php index 087aea3b..969fb60f 100644 --- a/web/lib/acctfuncs.inc.php +++ b/web/lib/acctfuncs.inc.php @@ -637,8 +637,11 @@ function try_login() { } if ($logged_in) { - # set our SID cookie + $q = "UPDATE Users SET LastLogin = UNIX_TIMESTAMP() "; + $q.= "WHERE ID = '$userID'"; + db_query($q, $dbh); + # set our SID cookie if (isset($_POST['remember_me']) && $_POST['remember_me'] == "on") { # Set cookies for 30 days. |