@@ -, +, @@ the branch table --- installer/data/mysql/kohastructure.sql | 2 ++ installer/data/mysql/updatedatabase.pl | 14 ++++++++++++++ .../intranet-tmpl/prog/en/modules/admin/branches.tt | 2 ++ .../prog/en/modules/admin/preferences/admin.pref | 10 ++++++++++ 4 files changed, 28 insertions(+) --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -389,6 +389,8 @@ CREATE TABLE `branches` ( -- information about your libraries or branches are st `branchphone` mediumtext, -- the primary phone for your library or branch `branchfax` mediumtext, -- the fax number for your library or branch `branchemail` mediumtext, -- the primary email address for your library or branch + `branchreplyto` mediumtext, -- the email to be used as a Reply-To + `branchreturnpath` mediumtext, -- the email to be used as Return-Path `branchurl` mediumtext, -- the URL for your library or branch's website `issuing` tinyint(4) default NULL, -- unused in Koha `branchip` varchar(15) default NULL, -- the IP address for your library or branch --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -8778,6 +8778,20 @@ if ( CheckVersion($DBversion) ) { INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('StatisticsFields','location|itype|ccode','Define fields (from the items table) used for statistics members',NULL,'Free') }); print "Upgrade to $DBversion done (Bug 12728: Checked syspref StatisticsFields)\n"; +} + +$DBversion = "3.17.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do( +"INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('ReplytoDefault', '', NULL, 'The default email address to be set as replyto.', 'Free')" + ); + $dbh->do( +"INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('ReturnpathDefault', '', NULL, 'The default email address to be set as return-path', 'Free')" + ); + $dbh->do("ALTER TABLE branches ADD branchreplyto mediumtext AFTER branchemail"); + $dbh->do("ALTER TABLE branches ADD branchreturnpath mediumtext AFTER branchreplyto"); + print +"Upgrade to $DBversion done (Bug XXX Adding replyto and returnpath addresses.)\n"; SetVersion($DBversion); } --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/branches.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/branches.tt @@ -126,6 +126,8 @@ tinyMCE.init({
  • +
  • +
  • Can be entered as a single IP, or a subnet such as 192.168.1.*
  • --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref @@ -7,6 +7,16 @@ Administration: class: email - "as the email address for the administrator of Koha. (This is the default From: address for emails unless there is one for the particular library, and is referred to when an internal error occurs.)" - + - Use + - pref: ReplytoDefault + class: email + - "as the email address that will be set as the replyto in emails" + - + - Use + - pref: ReturnpathDefault + class: email + - "as the email address set as the return path, if you leave this empty the admin address will be used." + - - Show - pref: DebugLevel default: 0 --