[Koha-bugs] [Bug 15504] Track Patron's Last Activity

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Sun Oct 22 09:33:46 CEST 2023


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15504

--- Comment #188 from Andrii Nugged <nugged at gmail.com> ---
btw, that atomic update quoting is very inconsistent:

        my ($tracklastactivity) = $dbh->selectrow_array(
            q|
            SELECT value FROM systempreferences WHERE
variable='TrackLastPatronActivity';
        |
        );

vs

        $dbh->do(
            qq{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 performs a selected action','multiple') },
            undef, $triggers,
        );

vs

        $dbh->do(
            q{
            DELETE FROM systempreferences WHERE
variable='TrackLastPatronActivity'
        }
        );

why so?

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list