From 66b51c9214296c4026f343c683b2fc1b0204ce65 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 31 May 2013 12:32:29 +0200 Subject: [PATCH] Bug 9032: Share a list (dbrev for SHARE_INVITE notice) Content-Type: text/plain; charset=utf-8 Adds notice in updatedatabase and sample_notices. Test plan: Do install or upgrade and verify that you have the new notice under Tools. --- .../data/mysql/en/mandatory/sample_notices.sql | 16 ++++++++++++++ installer/data/mysql/updatedatabase.pl | 22 ++++++++++++++++++++ 2 files changed, 38 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql index 2d09971..c662a9c 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.sql +++ b/installer/data/mysql/en/mandatory/sample_notices.sql @@ -117,3 +117,19 @@ http://<>/cgi-bin/koha/opac-registration-verify.pl?token=<>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' +); diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index f3a90d8..f576931 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -6983,6 +6983,28 @@ INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ( SetVersion($DBversion); } +$DBversion = "3.13.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do(" +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' + )"); + print "Upgrade to $DBversion done (Bug 9032: Share a list (part 1: Send the invitation)\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS -- 1.7.7.6