@@ -, +, @@ TrackLastPatronActivity --- .../bug_15504-add-tracklastpatronactivityoptions.pl | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) --- a/installer/data/mysql/atomicupdate/bug_15504-add-tracklastpatronactivityoptions.pl +++ a/installer/data/mysql/atomicupdate/bug_15504-add-tracklastpatronactivityoptions.pl @@ -7,8 +7,14 @@ return { my ($args) = @_; my ( $dbh, $out ) = @$args{qw(dbh out)}; + # Get existing value from the TrackLastPatronActivity system preference + my ($tracklastactivity) = $dbh->selectrow_array( q| + SELECT value FROM systempreferences WHERE variable='TrackLastPatronActivity'; + |); + + my $triggers = $tracklastactivity ? 'check_out,connection,login' : ''; $dbh->do( - q{INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('TrackLastPatronActivityTriggers','',NULL,'If set, the field borrowers.lastseen will be updated every time a patron is does a selected option','multiple') } + qq{INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('TrackLastPatronActivityTriggers',$triggers,NULL,'If set, the field borrowers.lastseen will be updated every time a patron is does a selected option','multiple') } ); say $out "Added system preference 'TrackLastPatronActivityTriggers'"; --