From b2afdd6b02c34b138236128722a4cc28f33f87e1 Mon Sep 17 00:00:00 2001 From: Amit Gupta Date: Tue, 8 Oct 2013 09:36:59 +0530 Subject: [PATCH] [PASSED QA] Bug -5511- Added new system preference: SessionRestrictionByIP Signed-off-by: Martin Renvoize Signed-off-by: Katrin Fischer --- installer/data/mysql/sysprefs.sql | 3 ++- installer/data/mysql/updatedatabase.pl | 6 ++++++ 2 files changed, 8 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index db9fd84..36fa5ac 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -472,5 +472,6 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('XSLTDetailsDisplay','default','','Enable XSL stylesheet control over details page display on intranet','Free'), ('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'), ('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'), -('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo') +('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'), +('SessionRestrictionByIP','0','Check for Change in Remote IP address for Session Security . Disable when remote ip address changes frequently.','','YesNo'); ; diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index b06142c..0b5c390 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9576,6 +9576,12 @@ if ( CheckVersion($DBversion) ) { $DBversion = "3.18.00.000"; if ( CheckVersion($DBversion) ) { print "Upgrade to $DBversion done (3.18.0 release)\n"; +} + +$DBversion = "3.18.00.001"; +if ( CheckVersion($DBversion) ) { + $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SessionRestrictionByIP','0','Check for Change in Remote IP address for Session Security. Disable when remote ip address changes frequently.','','YesNo')"); + print "Upgrade to $DBversion done (Bug 5511 - SessionRestrictionByIP)"; SetVersion ($DBversion); } -- 1.9.1