Bugzilla – Attachment 15850 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.79 KB, created by
Jonathan Druart
on 2013-03-04 16:00:35 UTC
(
hide
)
Description:
Bug 8917 : Creating tables and system pref, no functional changes at all
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2013-03-04 16:00:35 UTC
Size:
4.79 KB
patch
obsolete
>From 3701f9c11313105ea4e6e17706bfaff2399227f0 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 > >Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> > >Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com> >--- > installer/data/mysql/kohastructure.sql | 20 +++++++++++++++++++ > installer/data/mysql/sysprefs.sql | 1 + > installer/data/mysql/updatedatabase.pl | 21 ++++++++++++++++++++ > .../prog/en/modules/admin/preferences/opac.pref | 8 ++++++++ > 4 files changed, 50 insertions(+) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index ed673da..d004fe1 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3056,6 +3056,26 @@ CREATE TABLE IF NOT EXISTS `borrower_modifications` ( > KEY `borrowernumber` (`borrowernumber`) > ) 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 ca9b6bd..91b508d 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -416,3 +416,4 @@ INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ( > INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('IntranetNumbersPreferPhrase','0', NULL, 'Control the use of phr operator in callnumber and standard number staff client searches', 'YesNo'); > INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('UNIMARCField100Language', 'fre','UNIMARC field 100 default language',NULL,'short'); > INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('Persona',0,'Use Mozilla Persona for login','','YesNo'); >+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 7e5e243..e640ba6 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -6444,6 +6444,27 @@ if ( CheckVersion($DBversion) ) { > SetVersion($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(" >+ 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 > >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 6d6672c..9d487b1 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 >@@ -517,6 +517,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.10.4
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