View | Details | Raw Unified | Return to bug 8917
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-17 / +20 lines)
Lines 6446-6469 if ( CheckVersion($DBversion) ) { Link Here
6446
6446
6447
$DBversion = "3.11.00.XXX";
6447
$DBversion = "3.11.00.XXX";
6448
if ( CheckVersion($DBversion) ) {
6448
if ( CheckVersion($DBversion) ) {
6449
    $dbh->do("CREATE TABLE linktracker (
6449
    $dbh->do(
6450
	  id int(11) NOT NULL AUTO_INCREMENT,
6450
        "CREATE TABLE linktracker (
6451
	  biblionumber int(11) DEFAULT NULL,
6451
  id int(11) NOT NULL AUTO_INCREMENT,
6452
	  itemnumber int(11) DEFAULT NULL,
6452
  biblionumber int(11) DEFAULT NULL,
6453
	  borrowernumber int(11) DEFAULT NULL,
6453
  itemnumber int(11) DEFAULT NULL,
6454
	  url text,
6454
  borrowernumber int(11) DEFAULT NULL,
6455
	  timeclicked datetime DEFAULT NULL,
6455
  url text,
6456
	  PRIMARY KEY (id),
6456
  timeclicked datetime DEFAULT NULL,
6457
	  KEY bibidx (biblionumber),
6457
  PRIMARY KEY (id),
6458
	  KEY itemidx (itemnumber),
6458
  KEY bibidx (biblionumber),
6459
	  KEY borridx (borrowernumber),
6459
  KEY itemidx (itemnumber),
6460
	  KEY dateidx (timeclicked)
6460
  KEY borridx (borrowernumber),
6461
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
6461
  KEY dateidx (timeclicked)
6462
    $dbh->do("
6462
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
6463
    );
6464
    $dbh->do( "
6463
  INSERT INTO systempreferences (variable,value,explanation,options,type)
6465
  INSERT INTO systempreferences (variable,value,explanation,options,type)
6464
  VALUES('TrackClicks','0','Track links clicked',NULL,'Integer')");
6466
  VALUES('TrackClicks','0','Track links clicked',NULL,'Integer')" );
6465
    print "Upgrade to $DBversion done (Adds feature Bug 8917, the ability to track links clicked)";
6467
    print
6466
    SetVersion ($DBversion);
6468
"Upgrade to $DBversion done (Adds feature Bug 8917, the ability to track links clicked)";
6469
    SetVersion($DBversion);
6467
}
6470
}
6468
6471
6469
=head1 FUNCTIONS
6472
=head1 FUNCTIONS
(-)a/opac/tracklinks.pl (-2 / +1 lines)
Lines 35-41 if ($uri) { Link Here
35
        # we have a uri and we want to track
35
        # we have a uri and we want to track
36
        if ( $trackinglinks eq 'track' ) {
36
        if ( $trackinglinks eq 'track' ) {
37
            my ( $user, $cookie, $sessionID, $flags ) =
37
            my ( $user, $cookie, $sessionID, $flags ) =
38
              checkauth( $cgi, 1, '', 'opac' );
38
              checkauth( $cgi, 1, {}, 'opac' );
39
            my $userenv = C4::Context->userenv;
39
            my $userenv = C4::Context->userenv;
40
40
41
            if (   defined($userenv)
41
            if (   defined($userenv)
42
- 

Return to bug 8917