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

(-)a/installer/data/mysql/updatedatabase.pl (-17 / +20 lines)
Lines 6439-6462 if ( CheckVersion($DBversion) ) { Link Here
6439
6439
6440
$DBversion = "3.11.00.XXX";
6440
$DBversion = "3.11.00.XXX";
6441
if ( CheckVersion($DBversion) ) {
6441
if ( CheckVersion($DBversion) ) {
6442
    $dbh->do("CREATE TABLE linktracker (
6442
    $dbh->do(
6443
	  id int(11) NOT NULL AUTO_INCREMENT,
6443
        "CREATE TABLE linktracker (
6444
	  biblionumber int(11) DEFAULT NULL,
6444
  id int(11) NOT NULL AUTO_INCREMENT,
6445
	  itemnumber int(11) DEFAULT NULL,
6445
  biblionumber int(11) DEFAULT NULL,
6446
	  borrowernumber int(11) DEFAULT NULL,
6446
  itemnumber int(11) DEFAULT NULL,
6447
	  url text,
6447
  borrowernumber int(11) DEFAULT NULL,
6448
	  timeclicked datetime DEFAULT NULL,
6448
  url text,
6449
	  PRIMARY KEY (id),
6449
  timeclicked datetime DEFAULT NULL,
6450
	  KEY bibidx (biblionumber),
6450
  PRIMARY KEY (id),
6451
	  KEY itemidx (itemnumber),
6451
  KEY bibidx (biblionumber),
6452
	  KEY borridx (borrowernumber),
6452
  KEY itemidx (itemnumber),
6453
	  KEY dateidx (timeclicked)
6453
  KEY borridx (borrowernumber),
6454
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
6454
  KEY dateidx (timeclicked)
6455
    $dbh->do("
6455
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
6456
    );
6457
    $dbh->do( "
6456
  INSERT INTO systempreferences (variable,value,explanation,options,type)
6458
  INSERT INTO systempreferences (variable,value,explanation,options,type)
6457
  VALUES('TrackClicks','0','Track links clicked',NULL,'Integer')");
6459
  VALUES('TrackClicks','0','Track links clicked',NULL,'Integer')" );
6458
    print "Upgrade to $DBversion done (Adds feature Bug 8917, the ability to track links clicked)";
6460
    print
6459
    SetVersion ($DBversion);
6461
"Upgrade to $DBversion done (Adds feature Bug 8917, the ability to track links clicked)";
6462
    SetVersion($DBversion);
6460
}
6463
}
6461
6464
6462
=head1 FUNCTIONS
6465
=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