Bugzilla – Attachment 12831 Details for
Bug 8917
Track clicks to links external to Koha
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 8917 : Creating tables and system pref, no functional changes at all
Bug-8917--Creating-tables-and-system-pref-no-funct.patch (text/plain), 4.81 KB, created by
Chris Cormack
on 2012-10-15 19:28:39 UTC
(
hide
)
Description:
Bug 8917 : Creating tables and system pref, no functional changes at all
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2012-10-15 19:28:39 UTC
Size:
4.81 KB
patch
obsolete
>From 9ef2c4a2ebf6351e506e2d74c21337439368f16c Mon Sep 17 00:00:00 2001 >From: Chris Cormack <chrisc@catalyst.net.nz> >Date: Mon, 15 Oct 2012 11:29:55 +1300 >Subject: [PATCH] Bug 8917 : Creating tables and system pref, no functional > changes at all > >--- > installer/data/mysql/kohastructure.sql | 20 ++++++++++++++++++ > installer/data/mysql/sysprefs.sql | 1 + > installer/data/mysql/updatedatabase.pl | 22 ++++++++++++++++++++ > .../prog/en/modules/admin/preferences/opac.pref | 8 +++++++ > 4 files changed, 51 insertions(+) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 5f6739f..89d9e26 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2935,6 +2935,26 @@ CREATE TABLE `quotes` ( > PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > >+-- >+-- Table structure for table linktracker >+-- This stores clicks to external links >+-- >+ >+DROP TABLE IF EXISTS linktracker; >+CREATE TABLE linktracker ( >+ id int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier >+ biblionumber int(11) DEFAULT NULL, -- biblionumber of the record the link is from >+ itemnumber int(11) DEFAULT NULL, -- itemnumber if applicable that the link was from >+ borrowernumber int(11) DEFAULT NULL, -- borrowernumber who clicked the link >+ url text, -- the link itself >+ timeclicked datetime DEFAULT NULL, -- the date and time the link was clicked >+ PRIMARY KEY (id), >+ KEY bibidx (biblionumber), >+ KEY itemidx (itemnumber), >+ KEY borridx (borrowernumber), >+ KEY dateidx (timeclicked) >+) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ > /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; > /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; > /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index a4fceea..d7f1230 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -386,3 +386,4 @@ INSERT INTO systempreferences (variable,value,explanation,type) VALUES('OPACdidy > INSERT INTO systempreferences (variable,value,explanation,type) VALUES('INTRAdidyoumean',NULL,'Did you mean? configuration for the Intranet. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'); > INSERT INTO systempreferences (variable, value, options, explanation, type) VALUES ('BlockReturnOfWithdrawnItems', '1', '0', 'If enabled, items that are marked as withdrawn cannot be returned.', 'YesNo'); > INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('HoldsToPullStartDate','2','Set the default start date for the Holds to pull list to this many days ago',NULL,'Integer'); >+INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('TrackClicks','0','Track links clicked',NULL,'Integer'); >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index e67bf3e..41772c0 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -6011,6 +6011,28 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { > SetVersion ($DBversion); > } > >+$DBversion = "XXX"; >+if (C4::Context->preference("Version") < TransformToNum($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(" >+ 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); >+} >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref >index e645785..9613d3d 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref >@@ -492,6 +492,14 @@ OPAC: > - pref: AnonymousPatron > class: integer > - as the Anonymous Patron (for anonymous suggestions and reading history) >+ - >+ - pref: TrackClicks >+ default: 0 >+ choices: >+ anonymous: "Track anonymously" >+ track: "Track" >+ no: "Don't track" >+ - links that patrons click on > > Shelf Browser: > - >-- >1.7.9.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 8917
:
12831
|
12832
|
12833
|
12834
|
12998
|
12999
|
13000
|
13001
|
14058
|
14059
|
14060
|
14061
|
15669
|
15670
|
15671
|
15672
|
15711
|
15712
|
15713
|
15714
|
15715
|
15716
|
15783
|
15784
|
15785
|
15786
|
15787
|
15812
|
15815
|
15818
|
15819
|
15820
|
15821
|
15822
|
15823
|
15824
|
15825
|
15850
|
15851
|
15852
|
15853
|
15854
|
15855
|
15856
|
15857
|
15858