From a4a2d16dbde531444bd5ed8166c4203b4e590d90 Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Wed, 27 Feb 2013 09:32:24 +1300 Subject: [PATCH] [SIGNED-OFF] Bug 8917 : Fixing a bug bgkriegel spotted and removing tabs Signed-off-by: Bernardo Gonzalez Kriegel --- installer/data/mysql/updatedatabase.pl | 37 +++++++++++++++++--------------- opac/tracklinks.pl | 2 +- 2 files changed, 21 insertions(+), 18 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index c92778a..04a4f6f 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/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 diff --git a/opac/tracklinks.pl b/opac/tracklinks.pl index cc1d5e3..5c07cdd 100755 --- a/opac/tracklinks.pl +++ b/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) -- 1.7.9.5