summaryrefslogtreecommitdiffstats
path: root/upgrading
diff options
context:
space:
mode:
authorLukas Fleischer <lfleischer@archlinux.org>2016-03-13 11:37:48 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2016-03-13 11:47:30 +0100
commit32c8d0c3f837950518f886ed9baef00e98740049 (patch)
tree59200bcb746be355d649915f28626e24fecf998f /upgrading
parent761952d424ded8848335116beef962c39c551bc4 (diff)
downloadaur-32c8d0c3f837950518f886ed9baef00e98740049.tar.gz
aur-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.txt5
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 00000000..83c8d46a
--- /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;
+----