diff options
author | Lukas Fleischer <lfleischer@archlinux.org> | 2016-03-13 11:37:48 +0100 |
---|---|---|
committer | Lukas Fleischer <lfleischer@archlinux.org> | 2016-03-13 11:47:30 +0100 |
commit | 32c8d0c3f837950518f886ed9baef00e98740049 (patch) | |
tree | 59200bcb746be355d649915f28626e24fecf998f /upgrading | |
parent | 761952d424ded8848335116beef962c39c551bc4 (diff) | |
download | aurweb-32c8d0c3f837950518f886ed9baef00e98740049.tar.xz |
Store last login address as plain text
Directly store the information contained in $_SERVER['REMOTE_ADDR']
instead of using ip2long() which does not support IPv6 addresses. Note
that the LastLoginIPAddress field is designed to be used by the
administrator on rare occasions only (e.g. to fight spam) and is not
displayed anywhere.
Fixes FS#48557.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'upgrading')
-rw-r--r-- | upgrading/4.2.1.txt | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/upgrading/4.2.1.txt b/upgrading/4.2.1.txt new file mode 100644 index 0000000..83c8d46 --- /dev/null +++ b/upgrading/4.2.1.txt @@ -0,0 +1,5 @@ +1. Convert the LastLoginIPAddress column to VARCHAR(40): + +---- +ALTER TABLE Users MODIFY LastLoginIPAddress VARCHAR(40) NULL DEFAULT NULL; +---- |