@@ -, +, @@ removing tabs --- installer/data/mysql/updatedatabase.pl | 37 +++++++++++++++++--------------- opac/tracklinks.pl | 2 +- 2 files changed, 21 insertions(+), 18 deletions(-) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -6439,24 +6439,27 @@ if ( CheckVersion($DBversion) ) { $DBversion = "3.11.00.XXX"; if ( CheckVersion($DBversion) ) { - $dbh->do("CREATE TABLE linktracker ( - id int(11) NOT NULL AUTO_INCREMENT, - biblionumber int(11) DEFAULT NULL, - itemnumber int(11) DEFAULT NULL, - borrowernumber int(11) DEFAULT NULL, - url text, - timeclicked datetime DEFAULT NULL, - PRIMARY KEY (id), - KEY bibidx (biblionumber), - KEY itemidx (itemnumber), - KEY borridx (borrowernumber), - KEY dateidx (timeclicked) - ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"); - $dbh->do(" + $dbh->do( + "CREATE TABLE linktracker ( + id int(11) NOT NULL AUTO_INCREMENT, + biblionumber int(11) DEFAULT NULL, + itemnumber int(11) DEFAULT NULL, + borrowernumber int(11) DEFAULT NULL, + url text, + timeclicked datetime DEFAULT NULL, + PRIMARY KEY (id), + KEY bibidx (biblionumber), + KEY itemidx (itemnumber), + KEY borridx (borrowernumber), + KEY dateidx (timeclicked) + ) ENGINE=InnoDB DEFAULT CHARSET=utf8;" + ); + $dbh->do( " INSERT INTO systempreferences (variable,value,explanation,options,type) - VALUES('TrackClicks','0','Track links clicked',NULL,'Integer')"); - print "Upgrade to $DBversion done (Adds feature Bug 8917, the ability to track links clicked)"; - SetVersion ($DBversion); + VALUES('TrackClicks','0','Track links clicked',NULL,'Integer')" ); + print +"Upgrade to $DBversion done (Adds feature Bug 8917, the ability to track links clicked)"; + SetVersion($DBversion); } =head1 FUNCTIONS --- a/opac/tracklinks.pl +++ a/opac/tracklinks.pl @@ -35,7 +35,7 @@ if ($uri) { # we have a uri and we want to track if ( $trackinglinks eq 'track' ) { my ( $user, $cookie, $sessionID, $flags ) = - checkauth( $cgi, 1, '', 'opac' ); + checkauth( $cgi, 1, {}, 'opac' ); my $userenv = C4::Context->userenv; if ( defined($userenv) --