Attachment #3033 for bug #3881

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

Lines 418-423 sub get_template_and_user { Link Here

(-)a/C4/Auth.pm (+1 lines)
418	OpacNav => "" . C4::Context->preference("OpacNav"),	418	OpacNav => "" . C4::Context->preference("OpacNav"),
419	OpacPasswordChange => C4::Context->preference("OpacPasswordChange"),	419	OpacPasswordChange => C4::Context->preference("OpacPasswordChange"),
420	OPACPatronDetails => C4::Context->preference("OPACPatronDetails"),	420	OPACPatronDetails => C4::Context->preference("OPACPatronDetails"),
		421	OPACPrivacy => C4::Context->preference("OPACPrivacy"),
421	OPACFinesTab => C4::Context->preference("OPACFinesTab"),	422	OPACFinesTab => C4::Context->preference("OPACFinesTab"),
422	OpacTopissue => C4::Context->preference("OpacTopissue"),	423	OpacTopissue => C4::Context->preference("OpacTopissue"),
423	RequestOnOpac => C4::Context->preference("RequestOnOpac"),	424	RequestOnOpac => C4::Context->preference("RequestOnOpac"),

Lines 1516-1522 sub AddReturn { Link Here

(-)a/C4/Circulation.pm (-8 / +36 lines)
1516	}	1516	}
1517		1517
1518	if ($borrowernumber) {	1518	if ($borrowernumber) {
1519	MarkIssueReturned($borrowernumber, $item->{'itemnumber'}, $circControlBranch);	1519	MarkIssueReturned($borrowernumber, $item->{'itemnumber'}, $circControlBranch, '', $borrower->{'privacy'});
1520	$messages->{'WasReturned'} = 1; # FIXME is the "= 1" right? This could be the borrower hash.	1520	$messages->{'WasReturned'} = 1; # FIXME is the "= 1" right? This could be the borrower hash.
1521	}	1521	}
1522		1522
Lines 1621-1627 sub AddReturn { Link Here
1621		1621
1622	=head2 MarkIssueReturned	1622	=head2 MarkIssueReturned
1623		1623
1624	MarkIssueReturned($borrowernumber, $itemnumber, $dropbox_branch, $returndate);	1624	MarkIssueReturned($borrowernumber, $itemnumber, $dropbox_branch, $returndate, $privacy);
1625		1625
1626	Unconditionally marks an issue as being returned by	1626	Unconditionally marks an issue as being returned by
1627	moving the C<issues> row to C<old_issues> and	1627	moving the C<issues> row to C<old_issues> and
Lines 1633-1638 it's safe to do this, i.e. last non-holiday > issuedate. Link Here
1633	if C<$returndate> is specified (in iso format), it is used as the date	1633	if C<$returndate> is specified (in iso format), it is used as the date
1634	of the return. It is ignored when a dropbox_branch is passed in.	1634	of the return. It is ignored when a dropbox_branch is passed in.
1635		1635
		1636	C<$privacy> contains the privacy parameter. If the patron has set privacy to 2,
		1637	the old_issue is immediately anonymised
		1638
1636	Ideally, this function would be internal to C<C4::Circulation>,	1639	Ideally, this function would be internal to C<C4::Circulation>,
1637	not exported, but it is currently needed by one	1640	not exported, but it is currently needed by one
1638	routine in C<C4::Accounts>.	1641	routine in C<C4::Accounts>.
Lines 1640-1646 routine in C<C4::Accounts>. Link Here
1640	=cut	1643	=cut
1641		1644
1642	sub MarkIssueReturned {	1645	sub MarkIssueReturned {
1643	my ( $borrowernumber, $itemnumber, $dropbox_branch, $returndate ) = @_;	1646	my ( $borrowernumber, $itemnumber, $dropbox_branch, $returndate, $privacy ) = @_;
1644	my $dbh = C4::Context->dbh;	1647	my $dbh = C4::Context->dbh;
1645	my $query = "UPDATE issues SET returndate=";	1648	my $query = "UPDATE issues SET returndate=";
1646	my @bind;	1649	my @bind;
Lines 1664-1669 sub MarkIssueReturned { Link Here
1664	WHERE borrowernumber = ?	1667	WHERE borrowernumber = ?
1665	AND itemnumber = ?");	1668	AND itemnumber = ?");
1666	$sth_copy->execute($borrowernumber, $itemnumber);	1669	$sth_copy->execute($borrowernumber, $itemnumber);
		1670	# anonymise patron checkout immediately if $privacy set to 2 and AnonymousPatron is set to a valid borrowernumber
		1671	if ( $privacy == 2) {
		1672	# The default of 0 does not work due to foreign key constraints
		1673	# The anonymisation will fail quietly if AnonymousPatron is not a valid entry
		1674	my $anonymouspatron = (C4::Context->preference('AnonymousPatron')) ? C4::Context->preference('AnonymousPatron') : 0;
		1675	my $sth_ano = $dbh->prepare("UPDATE old_issues SET borrowernumber=?
		1676	WHERE borrowernumber = ?
		1677	AND itemnumber = ?");
		1678	$sth_ano->execute($anonymouspatron, $borrowernumber, $itemnumber);
		1679	}
1667	my $sth_del = $dbh->prepare("DELETE FROM issues	1680	my $sth_del = $dbh->prepare("DELETE FROM issues
1668	WHERE borrowernumber = ?	1681	WHERE borrowernumber = ?
1669	AND itemnumber = ?");	1682	AND itemnumber = ?");
Lines 2417-2427 sub DeleteTransfer { Link Here
2417		2430
2418	=head2 AnonymiseIssueHistory	2431	=head2 AnonymiseIssueHistory
2419		2432
2420	$rows = AnonymiseIssueHistory($borrowernumber,$date)	2433	$rows = AnonymiseIssueHistory($date,$borrowernumber)
2421		2434
2422	This function write NULL instead of C<$borrowernumber> given on input arg into the table issues.	2435	This function write NULL instead of C<$borrowernumber> given on input arg into the table issues.
2423	if C<$borrowernumber> is not set, it will delete the issue history for all borrower older than C<$date>.	2436	if C<$borrowernumber> is not set, it will delete the issue history for all borrower older than C<$date>.
2424		2437
		2438	If c<$borrowernumber> is set, it will delete issue history for only that borrower, regardless of their opac privacy
		2439	setting (force delete).
		2440
2425	return the number of affected rows.	2441	return the number of affected rows.
2426		2442
2427	=cut	2443	=cut
Lines 2432-2443 sub AnonymiseIssueHistory { Link Here
2432	my $dbh = C4::Context->dbh;	2448	my $dbh = C4::Context->dbh;
2433	my $query = "	2449	my $query = "
2434	UPDATE old_issues	2450	UPDATE old_issues
2435	SET borrowernumber = NULL	2451	SET borrowernumber = ?
2436	WHERE returndate < '".$date."'	2452	WHERE returndate < ?
2437	AND borrowernumber IS NOT NULL	2453	AND borrowernumber IS NOT NULL
2438	";	2454	";
2439	$query .= " AND borrowernumber = '".$borrowernumber."'" if defined $borrowernumber;	2455
2440	my $rows_affected = $dbh->do($query);	2456	# The default of 0 does not work due to foreign key constraints
		2457	# The anonymisation will fail quietly if AnonymousPatron is not a valid entry
		2458	my $anonymouspatron = (C4::Context->preference('AnonymousPatron')) ? C4::Context->preference('AnonymousPatron') : 0;
		2459	my @bind_params = ($anonymouspatron, $date);
		2460	if (defined $borrowernumber) {
		2461	$query .= " AND borrowernumber = ?";
		2462	push @bind_params, $borrowernumber;
		2463	} else {
		2464	$query .= " AND (SELECT privacy FROM borrowers WHERE borrowers.borrowernumber=old_issues.borrowernumber) <> 0";
		2465	}
		2466	my $sth = $dbh->prepare($query);
		2467	$sth->execute(@bind_params);
		2468	my $rows_affected = $sth->rows; ### doublecheck row count return function
2441	return $rows_affected;	2469	return $rows_affected;
2442	}	2470	}
2443		2471




	push @EXPORT, qw(
		&ModMember
		&changepassword
         &ModPrivacy
	);

	#Delete data

    
}

=head2 ModPrivacy

=over 4

my $success = ModPrivacy( $borrowernumber, $privacy );

Update the privacy of a patron.

return :
true on success, false on failure

=back

=cut

sub ModPrivacy {
    my $borrowernumber = shift;
    my $privacy = shift;
    return unless defined $borrowernumber;
    return unless $borrowernumber =~ /^\d+$/;

    return ModMember( borrowernumber => $borrowernumber,
                      privacy        => $privacy );
}

=head2 AddMessage

  AddMessage( $borrowernumber, $message_type, $message, $branchcode );




    SetVersion ($DBversion);
}

$DBversion = '3.03.00.xxx';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
    # reimplement OpacPrivacy system preference
    $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacPrivacy', '0', 'if ON, allows patrons to define their privacy rules (reading history)',NULL,'YesNo')");
    $dbh->do("ALTER TABLE `borrowers` ADD `privacy` INTEGER NOT NULL DEFAULT 1;");
    $dbh->do("ALTER TABLE `deletedborrowers` ADD `privacy` INTEGER NOT NULL DEFAULT 1;");
    print "Upgrade to $DBversion done (OpacPrivacy reimplementation)\n";
    SetVersion($DBversion);
};

=head1 FUNCTIONS

=head2 DropAllForeignKeys($table)




                  no: "Don't allow"
            - patrons to store items in a temporary "Cart" on the OPAC.
        -
            - pref: opacreadinghistory
              choices:
                  yes: Allow
                  no: "Don't allow"
            - patrons to see what books they have checked out in the past.
        -
            - pref: OpacTopissue
              choices:
                  yes: Allow

                  yes: Limit
                  no: "Don't limit"
            - "patrons' searches to the library they are registered at."
        -
            - pref: AnonSuggestions
              choices:
                  yes: Allow
                  no: "Don't allow"
            - "patrons that aren't logged in to make purchase suggestions."
#        -
#            This system preference does not actually affect anything
#            - pref: OpacBrowser

            - purchase suggestions from other patrons on the OPAC.
    Privacy:
        -
            - pref: AnonSuggestions
              choices:
                  yes: Allow
                  no: "Don't allow"
            - "patrons that aren't logged in to make purchase suggestions. Suggestions are connected to the AnonymousPatron syspref"
        -
            - pref: opacreadinghistory
              choices:
                  yes: Allow
                  no: "Don't allow"
            - patrons to see what books they have checked out in the past.
        -
            - pref: EnableOpacSearchHistory
              default: 0
              choices:
                  yes: Keep
                  no: "Don't keep"
            - patron search history in the OPAC.
        -
            - pref: OPACPrivacy
              default: 0
              choices:
                  yes: Allow
                  no: "Don't allow"
            - patrons to choose their own privacy settings for their reading history.  This requires opacreadinghistory and AnonymousPatron
        -
            - Use borrowernumber
            - pref: AnonymousPatron
              class: integer
            - as the Anonymous Patron (for anonymous suggestions and reading history)

    Shelf Browser:
        -
            - pref: OPACShelfBrowser

Lines 320-325 function validate1(date) { Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/members/moremember.tmpl (+5 lines)
320		320
321	<li><span class="label">Library: </span><!-- TMPL_VAR NAME="branchname" --></li>	321	<li><span class="label">Library: </span><!-- TMPL_VAR NAME="branchname" --></li>
322		322
		323	<!-- TMPL_IF NAME="OPACPrivacy" --><li><span class="label">Privacy Pref:</span>
		324	<!-- TMPL_IF NAME="privacy0" -->Forever<!-- /TMPL_IF -->
		325	<!-- TMPL_IF NAME="privacy1" -->Default<!-- /TMPL_IF -->
		326	<!-- TMPL_IF NAME="privacy2" -->Never<!-- /TMPL_IF -->
		327	</li><!-- /TMPL_IF -->
323	<!-- TMPL_IF NAME="sort1" --><li><span class="label">Sort field 1:</span><!-- TMPL_VAR NAME="lib1" --></li><!-- /TMPL_IF -->	328	<!-- TMPL_IF NAME="sort1" --><li><span class="label">Sort field 1:</span><!-- TMPL_VAR NAME="lib1" --></li><!-- /TMPL_IF -->
324	<!-- TMPL_IF NAME="sort2" --><li><span class="label">Sort field 2:</span><!-- TMPL_VAR NAME="lib2" --></li><!-- /TMPL_IF -->	329	<!-- TMPL_IF NAME="sort2" --><li><span class="label">Sort field 2:</span><!-- TMPL_VAR NAME="lib2" --></li><!-- /TMPL_IF -->
325	<li><span class="label">OPAC login: </span><!-- TMPL_VAR name="userid" --></li>	330	<li><span class="label">OPAC login: </span><!-- TMPL_VAR name="userid" --></li>

Lines 17-22 Link Here

(-)a/koha-tmpl/opac-tmpl/prog/en/includes/usermenu.inc (+3 lines)
17	<!-- /TMPL_IF -->	17	<!-- /TMPL_IF -->
18	<!-- TMPL_IF NAME="opacreadinghistory" -->	18	<!-- TMPL_IF NAME="opacreadinghistory" -->
19	<!-- TMPL_IF NAME="readingrecview" --><li class="active"><!-- TMPL_ELSE --><li><!-- /TMPL_IF --><a href="/cgi-bin/koha/opac-readingrecord.pl">my reading history</a></li>	19	<!-- TMPL_IF NAME="readingrecview" --><li class="active"><!-- TMPL_ELSE --><li><!-- /TMPL_IF --><a href="/cgi-bin/koha/opac-readingrecord.pl">my reading history</a></li>
		20	<!-- TMPL_IF NAME="OPACPrivacy" -->
		21	<!-- TMPL_IF NAME="privacyview" --><li class="active"><!-- TMPL_ELSE --><li><!-- /TMPL_IF --><a href="/cgi-bin/koha/opac-privacy.pl">my privacy</a></li>
		22	<!-- /TMPL_IF -->
20	<!-- /TMPL_IF -->	23	<!-- /TMPL_IF -->
21	<!-- TMPL_IF name="suggestion" -->	24	<!-- TMPL_IF name="suggestion" -->
22	<!-- TMPL_UNLESS NAME="AnonSuggestions" -->	25	<!-- TMPL_UNLESS NAME="AnonSuggestions" -->




<!-- TMPL_INCLUDE name="doc-head-open.inc" --><!-- TMPL_IF NAME="LibraryNameTitle" --><!-- TMPL_VAR NAME="LibraryNameTitle" --><!-- TMPL_ELSE -->Koha Online<!-- /TMPL_IF --> Catalog &rsaquo; Privacy management for <!-- TMPL_VAR name="firstname" --> <!-- TMPL_VAR name="surname" -->
<!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
</head>
<body>
<div id="doc3" class="yui-t1">
   <div id="bd">
<!-- TMPL_INCLUDE name="masthead.inc" -->

	<div id="yui-main">
	<div class="yui-b"><div class="yui-g">
	<div class="container">
	<h3><a href="/cgi-bin/koha/opac-user.pl"><!-- TMPL_VAR NAME="firstname" --> <!-- TMPL_VAR NAME="surname" -->'s account</a> <img src="<!-- TMPL_VAR NAME="themelang" -->l../../images/caret.gif" width="16" height="16" alt="&gt;" border="0" /> Privacy policy </h3>

    <!-- TMPL_IF name="deleted" -->
        <div class="dialog message">Your reading history has been deleted.</div>
    <!-- /TMPL_IF -->
    <!-- TMPL_IF NAME= "privacy_updated" -->
        <div class="dialog message">Your privacy rules have been updated</div>
    <!-- /TMPL_IF -->

    <h2>Privacy rule</h2>
    <!-- TMPL_IF NAME= "Ask_data" -->
		<p>We take great care in protecting your privacy. On this screen, you can define how long we keep your reading history.</p>
		<p>Your options are: <p>
		<form action="/cgi-bin/koha/opac-privacy.pl" method="post" id="opac-privacy-update-form">
            <input type="hidden" name="op" value="update_privacy" />
            <ul id="opac-privacy-options-list">
                <li class="privacy0">Forever: keep my reading history without limit. This is the option for users who want to keep track of what they are reading.</li>
                <li class="privacy1">Default: keep my reading history according to local laws. This is the default option : the library will keep your reading history for the duration permitted by local laws.</li>
                <li class="privacy2">Never: Delete my reading history immediately. This will delete all record of the item that was checked-out upon check-in.</li>
            </ul>
            <p id="note1">Please note that information on any book still checked-out must be kept by the library no matter which privacy option you choose.</p>
            <p id="note2">Please also note that the library staff can't update these values for you: it's your privacy!</p>
            <label for:"privacy">Please choose your privacy rule:</label>
            <select name="privacy">
                <!-- TMPL_IF name="privacy0" -->
                    <option value="0" selected="1" class="privacy0">Forever</option>
                <!-- TMPL_ELSE -->
                    <option value="0" class="privacy0">Forever</option>
                <!-- /TMPL_IF -->
                <!-- TMPL_IF name="privacy1" -->
                    <option value="1" selected="1" class="privacy1">Default</option>
                <!-- TMPL_ELSE -->
                    <option value="1" class="privacy1">Default</option>
                <!-- /TMPL_IF -->
                <!-- TMPL_IF name="privacy2" -->
                    <option value="2" selected="1" class="privacy2">Never</option>
                <!-- TMPL_ELSE -->
                    <option value="2" class="privacy2">Never</option>
                <!-- /TMPL_IF -->
            </select>
            <input type="Submit" value="Submit" />
        </form>
        <h2>Immediate deletion</h2>
        <form action="/cgi-bin/koha/opac-privacy.pl" method="post" id="opac-privacy-delete-form">
            <input type="hidden" name="op" value="delete_record" />
            <p>Whatever your privacy rule you choose, you can delete all your reading history immediately by clicking here. <b>BE CAREFUL</b>. Once you've confirmed the deletion, no one can retrieve the list!</p>
            <input type="submit" value="Immediate deletion" onclick="return confirmDelete(_('Warning: Cannot be undone. Please confirm once again'));" />
        </form>
    <!-- /TMPL_IF -->
    </div>
</div>
</div>
</div>
<div class="yui-b">
<div class="container">
<!--TMPL_INCLUDE NAME="navigation.inc" -->
<!-- TMPL_INCLUDE name="usermenu.inc" -->
</div>
</div>
</div>
<!-- TMPL_INCLUDE NAME="opac-bottom.inc" -->

Lines 230-235 my $lib2 = &GetSortDetails( "Bsort2", $data->{'sort2'} ); Link Here

(-)a/members/moremember.pl (+6 lines)
230	$template->param( lib1 => $lib1 ) if ($lib1);	230	$template->param( lib1 => $lib1 ) if ($lib1);
231	$template->param( lib2 => $lib2 ) if ($lib2);	231	$template->param( lib2 => $lib2 ) if ($lib2);
232		232
		233	# Show OPAC privacy preference is system preference is set
		234	if ( C4::Context->preference('OPACPrivacy') ) {
		235	$template->param( OPACPrivacy => 1);
		236	$template->param( "privacy".$data->{'privacy'} => 1);
		237	}
		238
233	# current issues	239	# current issues
234	#	240	#
235	my $issue = GetPendingIssues($borrowernumber);	241	my $issue = GetPendingIssues($borrowernumber);




#!/usr/bin/perl
# This script lets the users change their privacy rules
#
# copyright 2009, BibLibre, paul.poulain@biblibre.com
#
# Koha is free software; you can redistribute it and/or modify it under the
# terms of the GNU General Public License as published by the Free Software
# Foundation; either version 2 of the License, or (at your option) any later
# version.
#
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along with
# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
# Suite 330, Boston, MA  02111-1307 USA

use strict;
use CGI;

use C4::Auth;    # checkauth, getborrowernumber.
use C4::Context;
use C4::Circulation;
use C4::Members;
use C4::Output;
use C4::Dates;

my $query = new CGI;
my $dbh   = C4::Context->dbh;

my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
    {
        template_name   => "opac-privacy.tmpl",
        query           => $query,
        type            => "opac",
        authnotrequired => 0,
        flagsrequired   => { borrow => 1 },
        debug           => 1,
    }
);

my $op = $query->param("op");
my $privacy = $query->param("privacy");

if ($op eq "update_privacy")
{
    ModPrivacy($borrowernumber,$privacy);
    $template->param('privacy_updated' => 1);
}
if ($op eq "delete_record") {
    # delete all reading records for items returned
    # uses a hardcoded date ridiculously far in the future
    AnonymiseIssueHistory('2999-12-12',$borrowernumber);
    # confirm the user the deletion has been done
    $template->param('deleted' => 1);
}
# get borrower privacy ....
my ( $borr ) = GetMemberDetails( $borrowernumber );

$template->param( 'Ask_data'       => '1',
                    'privacy'.$borr->{'privacy'} => 1,
                    'firstname' => $borr->{'firstname'},
                    'surname' => $borr->{'surname'},
                    'privacyview' => 1,
);

output_html_with_http_headers $query, $cookie, $template->output;

Lines 48-54 if ( C4::Context->preference("AnonSuggestions") ) { Link Here

(-)a/opac/opac-suggestions.pl (-2 / +1 lines)
48	}	48	}
49	);	49	);
50	if ( !$$suggestion{suggestedby} ) {	50	if ( !$$suggestion{suggestedby} ) {
51	$$suggestion{suggestedby} = C4::Context->preference("AnonSuggestions");	51	$$suggestion{suggestedby} = C4::Context->preference("AnonymousPatron");
52	}	52	}
53	}	53	}
54	else {	54	else {
55	-

Return to bug 3881

Lines 3970-3975 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (+10 lines)
3970	SetVersion ($DBversion);	3970	SetVersion ($DBversion);
3971	}	3971	}
3972		3972
		3973	$DBversion = '3.03.00.xxx';
		3974	if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
		3975	# reimplement OpacPrivacy system preference
		3976	$dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacPrivacy', '0', 'if ON, allows patrons to define their privacy rules (reading history)',NULL,'YesNo')");
		3977	$dbh->do("ALTER TABLE `borrowers` ADD `privacy` INTEGER NOT NULL DEFAULT 1;");
		3978	$dbh->do("ALTER TABLE `deletedborrowers` ADD `privacy` INTEGER NOT NULL DEFAULT 1;");
		3979	print "Upgrade to $DBversion done (OpacPrivacy reimplementation)\n";
		3980	SetVersion($DBversion);
		3981	};
		3982
3973	=head1 FUNCTIONS	3983	=head1 FUNCTIONS
3974		3984
3975	=head2 DropAllForeignKeys($table)	3985	=head2 DropAllForeignKeys($table)

Lines 93-98 BEGIN { Link Here

(-)a/C4/Members.pm (+26 lines)
93	push @EXPORT, qw(	93	push @EXPORT, qw(
94	&ModMember	94	&ModMember
95	&changepassword	95	&changepassword
		96	&ModPrivacy
96	);	97	);
97		98
98	#Delete data	99	#Delete data
Lines 2022-2027 sub DebarMember { Link Here
2022		2023
2023	}	2024	}
2024		2025
		2026	=head2 ModPrivacy
		2027
		2028	=over 4
		2029
		2030	my $success = ModPrivacy( $borrowernumber, $privacy );
		2031
		2032	Update the privacy of a patron.
		2033
		2034	return :
		2035	true on success, false on failure
		2036
		2037	=back
		2038
		2039	=cut
		2040
		2041	sub ModPrivacy {
		2042	my $borrowernumber = shift;
		2043	my $privacy = shift;
		2044	return unless defined $borrowernumber;
		2045	return unless $borrowernumber =~ /^\d+$/;
		2046
		2047	return ModMember( borrowernumber => $borrowernumber,
		2048	privacy => $privacy );
		2049	}
		2050
2025	=head2 AddMessage	2051	=head2 AddMessage
2026		2052
2027	AddMessage( $borrowernumber, $message_type, $message, $branchcode );	2053	AddMessage( $borrowernumber, $message_type, $message, $branchcode );

Lines 9-15 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here

(-)a/installer/data/mysql/de-DE/mandatory/sysprefs.sql (-1 / +3 lines)
9	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US\|CA\|DE\|FR\|JP\|UK','Choice');	9	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US\|CA\|DE\|FR\|JP\|UK','Choice');
10	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free');	10	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free');
11	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free');	11	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free');
12	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free');	12	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber',NULL,'YesNo');
		13	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonymousPatron', '0', 'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',NULL,'');
13	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Babeltheque',0,'Turn ON Babeltheque content - See babeltheque.com to subscribe to this service','','YesNo');	14	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Babeltheque',0,'Turn ON Babeltheque content - See babeltheque.com to subscribe to this service','','YesNo');
14		15
15	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free');	16	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free');
Lines 79-84 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here
79	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Important links here.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70\|10','Textarea');	80	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Important links here.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70\|10','Textarea');
80	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACNoResultsFound','','Display this HTML when no results are found for a search in the OPAC','70\|10','Textarea');	81	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACNoResultsFound','','Display this HTML when no results are found for a search in the OPAC','70\|10','Textarea');
81	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');	82	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');
		83	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPrivacy', '0', 'if ON, allows patrons to define their privacy rules (reading history)',NULL,'YesNo');
82	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo');	84	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo');
83	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free');	85	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free');
84	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');	86	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');

Lines 9-15 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here

(-)a/installer/data/mysql/en/mandatory/sysprefs.sql (-1 / +3 lines)
9	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US\|CA\|DE\|FR\|JP\|UK','Choice');	9	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US\|CA\|DE\|FR\|JP\|UK','Choice');
10	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free');	10	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free');
11	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free');	11	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free');
12	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free');	12	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber',NULL,'YesNo');
		13	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonymousPatron', '0', 'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',NULL,'');
13	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Babeltheque',0,'Turn ON Babeltheque content - See babeltheque.com to subscribe to this service','','YesNo');	14	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Babeltheque',0,'Turn ON Babeltheque content - See babeltheque.com to subscribe to this service','','YesNo');
14		15
15	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free');	16	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free');
Lines 79-84 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here
79	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Important links here.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70\|10','Textarea');	80	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Important links here.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70\|10','Textarea');
80	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACNoResultsFound','','Display this HTML when no results are found for a search in the OPAC','70\|10','Textarea');	81	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACNoResultsFound','','Display this HTML when no results are found for a search in the OPAC','70\|10','Textarea');
81	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');	82	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');
		83	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPrivacy', '0', 'if ON, allows patrons to define their privacy rules (reading history)',NULL,'YesNo');
82	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo');	84	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo');
83	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free');	85	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free');
84	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');	86	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');

Lines 10-16 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here

(-)a/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql (-1 / +3 lines)
10	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Utilisé pour définir la localisation des web services Amazon','US\|CA\|DE\|FR\|JP\|UK','Choice');	10	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Utilisé pour définir la localisation des web services Amazon','US\|CA\|DE\|FR\|JP\|UK','Choice');
11	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','Voir : http://aws.amazon.com','','free');	11	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','Voir : http://aws.amazon.com','','free');
12	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag', '', 'Voir : associates.amazon.com/gp/flex/associates/apply-login.html', '', '');	12	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag', '', 'Voir : associates.amazon.com/gp/flex/associates/apply-login.html', '', '');
13	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions', '0', 'Attribuée au n° de l''emprunteur anonyme pour activer les suggestions anonymes. 0, pas de suggestions anonymes.', '', 'free');	13	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber',NULL,'YesNo');
		14	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonymousPatron', '0', 'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',NULL,'');
14	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Babeltheque',0,'Active les contenus Babelthèque - Voir babeltheque.com pour s''abonner','','YesNo');	15	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Babeltheque',0,'Active les contenus Babelthèque - Voir babeltheque.com pour s''abonner','','YesNo');
15	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep', '--', 'Le séparateur utilisé dans les autorités. Habituellement --', '10', 'free');	16	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep', '--', 'Le séparateur utilisé dans les autorités. Habituellement --', '10', 'free');
16	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('autoBarcode', 'OFF', 'Utilisé pour générer automatiquement les codes barre: incremental sera de la forme 1, 2, 3; annual de la forme 2007-0001, 2007-0002, hbyymmincr de la forme HB09010001 où HB=la branche d''appartenance', 'incremental\|annual\|hbyymmincr\|OFF', 'Choice');	17	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('autoBarcode', 'OFF', 'Utilisé pour générer automatiquement les codes barre: incremental sera de la forme 1, 2, 3; annual de la forme 2007-0001, 2007-0002, hbyymmincr de la forme HB09010001 où HB=la branche d''appartenance', 'incremental\|annual\|hbyymmincr\|OFF', 'Choice');
Lines 91-96 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here
91	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMainUserBlock','Bienvenue dans Koha...\r\n<hr>','Bloc HTML défini par la bibliothèque, qui apparaît sur la page principale de l''OPAC','70\|10','Textarea');	92	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMainUserBlock','Bienvenue dans Koha...\r\n<hr>','Bloc HTML défini par la bibliothèque, qui apparaît sur la page principale de l''OPAC','70\|10','Textarea');
92	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav', '', 'Ce paramètre contient du code HTML, qui est mis au début de la barre de navigation, sur la gauche, à l''OPAC.','70\|10', 'Textarea');	93	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav', '', 'Ce paramètre contient du code HTML, qui est mis au début de la barre de navigation, sur la gauche, à l''OPAC.','70\|10', 'Textarea');
93	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange', '1', 'Si ce paramètre est activé, les adhérents peuvent modifier leur mot de passe à l''OPAC. A désactiver si vous utilisez l''authentification ldap', '', 'YesNo');	94	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange', '1', 'Si ce paramètre est activé, les adhérents peuvent modifier leur mot de passe à l''OPAC. A désactiver si vous utilisez l''authentification ldap', '', 'YesNo');
		95	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPrivacy', '0', 'if ON, allows patrons to define their privacy rules (reading history)',NULL,'YesNo');
94	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory', '1', 'Si ce paramètre est activé, les adhérents peuvent consulter leur historique de lecture à l''OPAC', '', 'YesNo');	96	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory', '1', 'Si ce paramètre est activé, les adhérents peuvent consulter leur historique de lecture à l''OPAC', '', 'YesNo');
95	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage', '', 'Ce paramètre contient une URL. Il permet de définir l''image qui est affichée en haut, à gauche de l''OPAC', '', 'free');	97	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage', '', 'Ce paramètre contient une URL. Il permet de définir l''image qui est affichée en haut, à gauche de l''OPAC', '', 'free');
96	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet', '', 'Ce paramètre a la forme d''une URL. Il définit la feuille de style utilisée à l''OPAC. S''il est vide, vous aurez la feuille de style par défault de Koha', '', 'free');	98	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet', '', 'Ce paramètre a la forme d''une URL. Il définit la feuille de style utilisée à l''OPAC. S''il est vide, vous aurez la feuille de style par défault de Koha', '', 'free');

Lines 9-14 insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, Link Here

(-)a/installer/data/mysql/it-IT/necessari/sysprefs.sql (-1 / +8 lines)
9	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('advancedMARCeditor','0','','Se su ON, nel MARC editor non verranno visualizzati i campi/sottocampi delle descrizioni.','YesNo');	9	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('advancedMARCeditor','0','','Se su ON, nel MARC editor non verranno visualizzati i campi/sottocampi delle descrizioni.','YesNo');
10	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AdvancedSearchTypes','itemtypes','itemtypes\|ccode','Selezionare quale set di campi comprenderà la ricerca avanzata per tipo.','Choice');	10	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AdvancedSearchTypes','itemtypes','itemtypes\|ccode','Selezionare quale set di campi comprenderà la ricerca avanzata per tipo.','Choice');
11	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AllowHoldsOnDamagedItems','1','','Permette l\'inserimento di richieste di prenotazione su copie danneggiate','YesNo');	11	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AllowHoldsOnDamagedItems','1','','Permette l\'inserimento di richieste di prenotazione su copie danneggiate','YesNo');
		12	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AllowNotForLoanOverride','0','','Se ON, abilita il bibliotecario a poter scegliere di dare in prestito un documento normalmente escluso.','YesNo');
12	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AllowOnShelfHolds','1','','Permette di inserire prenotazioni su documenti non in prestito.','YesNo');	13	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AllowOnShelfHolds','1','','Permette di inserire prenotazioni su documenti non in prestito.','YesNo');
13	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AllowRenewalLimitOverride','1','','Se On, permette che i limiti ai rinnovi possano essere superati dal bibliotecario nel modulo della circolazione','YesNo');	14	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AllowRenewalLimitOverride','1','','Se On, permette che i limiti ai rinnovi possano essere superati dal bibliotecario nel modulo della circolazione','YesNo');
14	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AmazonAssocTag','','','See: http://aws.amazon.com','free');	15	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AmazonAssocTag','','','See: http://aws.amazon.com','free');
Lines 17-23 insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, Link Here
17	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AmazonLocale','US','US\|CA\|DE\|FR\|JP\|UK','Usalo per definire il tuo specifico Amazon.com Web Services','Choice');	18	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AmazonLocale','US','US\|CA\|DE\|FR\|JP\|UK','Usalo per definire il tuo specifico Amazon.com Web Services','Choice');
18	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AmazonReviews','0','','Visualizza Amazon reviews sull\'interfaccia dello staff.','YesNo');	19	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AmazonReviews','0','','Visualizza Amazon reviews sull\'interfaccia dello staff.','YesNo');
19	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AmazonSimilarItems','0','','Messa su ON attiva l\' Amazon Similar Items feature - Devi settare i valori in AWSAccessKeyID e in AmazonAssocTag per usarla','YesNo');	20	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AmazonSimilarItems','0','','Messa su ON attiva l\' Amazon Similar Items feature - Devi settare i valori in AWSAccessKeyID e in AmazonAssocTag per usarla','YesNo');
20	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AnonSuggestions','0','','Imposta un utente anonimo per abilitare i suggerimenti d\'acquisto da utenti non registrati.','free');	21	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber',NULL,'YesNo');
		22	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonymousPatron', '0', 'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',NULL,'');
		23	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AuthDisplayHierarchy','0','','Se ON attiva la gestione gerarchica dell\'authority. Da usare solo con thesaurus','YesNo');
21	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('authoritysep','--','10','Carattere usato nella visualizzazione come separatore della lista delle authority. Normalmente è --','free');	24	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('authoritysep','--','10','Carattere usato nella visualizzazione come separatore della lista delle authority. Normalmente è --','free');
22	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('autoBarcode','annual','incremental\|annual\|hbyymmincr\|OFF','Da usare per impostare la generazione automatica dei barcode: incremental per la tipologia 1, 2, 3; annuale per 2007-0001, 2007-0002; hbyymmincr per HB08010001 dove HB sta per Home Branch (sottobiblioteca predefinita)','Choice');	25	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('autoBarcode','annual','incremental\|annual\|hbyymmincr\|OFF','Da usare per impostare la generazione automatica dei barcode: incremental per la tipologia 1, 2, 3; annuale per 2007-0001, 2007-0002; hbyymmincr per HB08010001 dove HB sta per Home Branch (sottobiblioteca predefinita)','Choice');
23	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AutoEmailOpacUser','0','','Quando viene creato un account, invia notifica via email all\'utente con i dettagli del nuovo account.','YesNo');	26	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('AutoEmailOpacUser','0','','Quando viene creato un account, invia notifica via email all\'utente con i dettagli del nuovo account.','YesNo');
Lines 89-98 insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, Link Here
89	-- insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('marcflavour','UNIMARC','MARC21\|UNIMARC','Define global MARC flavor (MARC21 or UNIMARC) used for character encoding','Choice');	92	-- insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('marcflavour','UNIMARC','MARC21\|UNIMARC','Define global MARC flavor (MARC21 or UNIMARC) used for character encoding','Choice');
90	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('MARCOrgCode','0','','Il MARC Organization Code - http://www.loc.gov/marc/organizations/orgshome.html','free');	93	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('MARCOrgCode','0','','Il MARC Organization Code - http://www.loc.gov/marc/organizations/orgshome.html','free');
91	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('MaxFine','9999','','Multa massima che un utente potrebbe avere per un singolo ritardo.','Integer');	94	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('MaxFine','9999','','Multa massima che un utente potrebbe avere per un singolo ritardo.','Integer');
		95	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('maxItemsInSearchResults','20','','Specifica il numero massimo di copie visualizzate nelle pagine di risultati','free');
92	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('maxoutstanding','5','','Definisci il numero massimo di operazioni in corso (prestiti+prenotazioni) dopo il quale si blocca la possibilità di fare prenotazioni','Integer');	96	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('maxoutstanding','5','','Definisci il numero massimo di operazioni in corso (prestiti+prenotazioni) dopo il quale si blocca la possibilità di fare prenotazioni','Integer');
93	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('maxreserves','2','','Definisce il numero massimo di prenotazioni che un utente può effettuare.','Integer');	97	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('maxreserves','2','','Definisce il numero massimo di prenotazioni che un utente può effettuare.','Integer');
94	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('maxItemsInSearchResults',20,'Specify the maximum number of items to display for each result on a page of results',NULL,'free');	98	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('maxItemsInSearchResults',20,'Specify the maximum number of items to display for each result on a page of results',NULL,'free');
95	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('memberofinstitution','0','','Se ON, gli utenti possono essere linkati alle istituzioni.','YesNo');	99	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('memberofinstitution','0','','Se ON, gli utenti possono essere linkati alle istituzioni.','YesNo');
		100	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('MergeAuthoritiesOnUpdate','1','','Se ON, aggiornando le authorities saranno automaticamente aggiornati anche i record bibliografici','YesNo');
96	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('minPasswordLength','3','','Specifica la lunghezza minima della password sia per l\'utente che per lo staff','free');	101	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('minPasswordLength','3','','Specifica la lunghezza minima della password sia per l\'utente che per lo staff','free');
97	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('noissuescharge','5','','Definisce l’ammontare massimo di multa che un utente può raggiungere prima di venir sospeso dal prestito','Integer');	102	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('noissuescharge','5','','Definisce l’ammontare massimo di multa che un utente può raggiungere prima di venir sospeso dal prestito','Integer');
98	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('noItemTypeImages','0','','Se Attivo, disabilita le immagini relative al tipo documento','YesNo');	103	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('noItemTypeImages','0','','Se Attivo, disabilita le immagini relative al tipo documento','YesNo');
Lines 130-135 insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, Link Here
130	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('OPACNoResultsFound','','Display this HTML when no results are found for a search in the OPAC','70\|10','Textarea');	135	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('OPACNoResultsFound','','Display this HTML when no results are found for a search in the OPAC','70\|10','Textarea');
131	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('OPACnumSearchResults','20','','Specifica il numero massimo di risposte da visualizzare nella pagina dei risultati ','Integer');	136	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('OPACnumSearchResults','20','','Specifica il numero massimo di risposte da visualizzare nella pagina dei risultati ','Integer');
132	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('OpacPasswordChange','1','','Se ON, abilita l\'utente alla modifica della password nell\'OPAC (disabiltare la funzione quando è usato LDAP auth)','YesNo');	137	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('OpacPasswordChange','1','','Se ON, abilita l\'utente alla modifica della password nell\'OPAC (disabiltare la funzione quando è usato LDAP auth)','YesNo');
		138	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPrivacy', '0', 'if ON, allows patrons to define their privacy rules (reading history)',NULL,'YesNo');
133	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('opacreadinghistory','1','','Se ON, si abilita la visualizzazione dello storico circolazione utente nell\'OPAC','YesNo');	139	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('opacreadinghistory','1','','Se ON, si abilita la visualizzazione dello storico circolazione utente nell\'OPAC','YesNo');
134	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('OpacRenewalAllowed','0','','Se ON, gli utenti possono rinnovare i propri prestiti direttamente dal proprio account OPAC','YesNo');	140	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('OpacRenewalAllowed','0','','Se ON, gli utenti possono rinnovare i propri prestiti direttamente dal proprio account OPAC','YesNo');
135	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('OPACShelfBrowser','0','','Abilita/disabilita una ricerca per scaffale (Shelf Browser) nella pagina dettagli documento. ATTENZIONE: questa feature consuma molte risorse nelle collezioni molto grandi.','YesNo');	141	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('OPACShelfBrowser','0','','Abilita/disabilita una ricerca per scaffale (Shelf Browser) nella pagina dettagli documento. ATTENZIONE: questa feature consuma molte risorse nelle collezioni molto grandi.','YesNo');
Lines 153-158 insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, Link Here
153	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('QueryStemming','0','','Se ON, abilita le ricerche con lo stemming (uso di forme variabili)','YesNo');	159	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('QueryStemming','0','','Se ON, abilita le ricerche con lo stemming (uso di forme variabili)','YesNo');
154	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('QueryWeightFields','0','','Se ON, abilita le opzioni di ricerca per dare uno peso diverso ai vari campi. Opzione sperimentale','YesNo');	160	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('QueryWeightFields','0','','Se ON, abilita le opzioni di ricerca per dare uno peso diverso ai vari campi. Opzione sperimentale','YesNo');
155	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('RandomizeHoldsQueueWeight','0','','Se ON, la coda delle prenotazione nella circolazione avrà un ordine casuale per tutte le collocazioni o solo per quelle collocazioni specificate sotto StaticHoldsQueueWeight, se impostato.','YesNo');	161	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('RandomizeHoldsQueueWeight','0','','Se ON, la coda delle prenotazione nella circolazione avrà un ordine casuale per tutte le collocazioni o solo per quelle collocazioni specificate sotto StaticHoldsQueueWeight, se impostato.','YesNo');
		162	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('ReceiveBackIssues','5','','Numero di periodici precedenti da visualizzare quando si guarda il dettaglio di una sottoscrizione','');
156	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('RenewalPeriodBase','date_due','date_due\|now','Per impostare se la data di rinnovo deve essere conteggiata a partire dalla data di scadenza del prestito o a partire dal momento in cui l’utente ne chiede il rinnovo.','Choice');	163	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('RenewalPeriodBase','date_due','date_due\|now','Per impostare se la data di rinnovo deve essere conteggiata a partire dalla data di scadenza del prestito o a partire dal momento in cui l’utente ne chiede il rinnovo.','Choice');
157	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('RenewSerialAddsSuggestion','0','','Se ON, puoi aggiungere un nuovo suggerimento durante il rinnovo di un periodico','YesNo');	164	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('RenewSerialAddsSuggestion','0','','Se ON, puoi aggiungere un nuovo suggerimento durante il rinnovo di un periodico','YesNo');
158	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('RequestOnOpac','1','','Se ON, si abilitano gli utenti globalmente a inserire prenotazione nell\'OPAC','YesNo');	165	insert into `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) values('RequestOnOpac','1','','Se ON, si abilitano gli utenti globalmente a inserire prenotazione nell\'OPAC','YesNo');

Lines 9-15 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here

(-)a/installer/data/mysql/pl-PL/mandatory/sysprefs.sql (-1 / +3 lines)
9	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US\|CA\|DE\|FR\|JP\|UK','Choice');	9	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US\|CA\|DE\|FR\|JP\|UK','Choice');
10	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free');	10	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free');
11	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free');	11	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free');
12	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free');	12	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber',NULL,'YesNo');
		13	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonymousPatron', '0', 'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',NULL,'');
13	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Babeltheque',0,'Turn ON Babeltheque content - See babeltheque.com to subscribe to this service','','YesNo');	14	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Babeltheque',0,'Turn ON Babeltheque content - See babeltheque.com to subscribe to this service','','YesNo');
14		15
15	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free');	16	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free');
Lines 78-83 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here
78	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMainUserBlock','Welcome to Koha...\r\n<hr>','A user-defined block of HTML in the main content area of the opac main page','70\|10','Textarea');	79	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMainUserBlock','Welcome to Koha...\r\n<hr>','A user-defined block of HTML in the main content area of the opac main page','70\|10','Textarea');
79	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Important links here.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70\|10','Textarea');	80	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Important links here.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70\|10','Textarea');
80	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');	81	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');
		82	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPrivacy', '0', 'if ON, allows patrons to define their privacy rules (reading history)',NULL,'YesNo');
81	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo');	83	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo');
82	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free');	84	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free');
83	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');	85	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');

Lines 24-30 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here

(-)a/installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql (-1 / +3 lines)
24	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US\|CA\|DE\|FR\|JP\|UK','Choice');	24	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US\|CA\|DE\|FR\|JP\|UK','Choice');
25	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free');	25	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free');
26	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free');	26	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free');
27	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free');	27	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber',NULL,'YesNo');
		28	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonymousPatron', '0', 'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',NULL,'');
28		29
29		30
30	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free');	31	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free');
Lines 107-112 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here
107	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMainUserBlock','Добро пожаловать в АБИС Koha...\r\n<hr>','A user-defined block of HTML in the main content area of the opac main page','50\|20','Textarea');	108	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMainUserBlock','Добро пожаловать в АБИС Koha...\r\n<hr>','A user-defined block of HTML in the main content area of the opac main page','50\|20','Textarea');
108	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Здесь будут важные ссылки.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70\|10','Textarea');	109	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Здесь будут важные ссылки.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70\|10','Textarea');
109	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');	110	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');
		111	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPrivacy', '0', 'if ON, allows patrons to define their privacy rules (reading history)',NULL,'YesNo');
110	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo');	112	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo');
111	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free');	113	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free');
112	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');	114	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');

Lines 24-31 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here

(-)a/installer/data/mysql/uk-UA/mandatory/system_preferences_full_optimal_for_install_only.sql (-2 / +3 lines)
24	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US\|CA\|DE\|FR\|JP\|UK','Choice');	24	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US\|CA\|DE\|FR\|JP\|UK','Choice');
25	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free');	25	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free');
26	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free');	26	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free');
27	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free');	27	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber',NULL,'YesNo');
28		28	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonymousPatron', '0', 'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',NULL,'');
29		29
30	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free');	30	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free');
31	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('autoBarcode','incremental','Used to autogenerate a barcode: incremental will be of the form 1, 2, 3; annual of the form 2007-0001, 2007-0002; hbyymmincr of the form HB08010001 where HB=Home Branch','incremental\|annual\|hbyymmincr\|OFF','Choice');	31	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('autoBarcode','incremental','Used to autogenerate a barcode: incremental will be of the form 1, 2, 3; annual of the form 2007-0001, 2007-0002; hbyymmincr of the form HB08010001 where HB=Home Branch','incremental\|annual\|hbyymmincr\|OFF','Choice');
Lines 107-112 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES Link Here
107	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMainUserBlock','Вітаємо у АБІС Koha...\r\n<hr>','A user-defined block of HTML in the main content area of the opac main page','50\|20','Textarea');	107	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMainUserBlock','Вітаємо у АБІС Koha...\r\n<hr>','A user-defined block of HTML in the main content area of the opac main page','50\|20','Textarea');
108	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Тут будуть важливі посилання.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70\|10','Textarea');	108	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Тут будуть важливі посилання.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70\|10','Textarea');
109	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');	109	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo');
		110	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPrivacy', '0', 'if ON, allows patrons to define their privacy rules (reading history)',NULL,'YesNo');
110	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo');	111	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo');
111	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free');	112	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free');
112	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');	113	INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free');

Lines 202-213 OPAC: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref (-12 / +25 lines)
202	no: "Don't allow"	202	no: "Don't allow"
203	- patrons to store items in a temporary "Cart" on the OPAC.	203	- patrons to store items in a temporary "Cart" on the OPAC.
204	-	204	-
205	- pref: opacreadinghistory
206	choices:
207	yes: Allow
208	no: "Don't allow"
209	- patrons to see what books they have checked out in the past.
210	-
211	- pref: OpacTopissue	205	- pref: OpacTopissue
212	choices:	206	choices:
213	yes: Allow	207	yes: Allow
Lines 245-256 OPAC: Link Here
245	yes: Limit	239	yes: Limit
246	no: "Don't limit"	240	no: "Don't limit"
247	- "patrons' searches to the library they are registered at."	241	- "patrons' searches to the library they are registered at."
248	-
249	- pref: AnonSuggestions
250	choices:
251	yes: Allow
252	no: "Don't allow"
253	- "patrons that aren't logged in to make purchase suggestions."
254	# -	242	# -
255	# This system preference does not actually affect anything	243	# This system preference does not actually affect anything
256	# - pref: OpacBrowser	244	# - pref: OpacBrowser
Lines 288-299 OPAC: Link Here
288	- purchase suggestions from other patrons on the OPAC.	276	- purchase suggestions from other patrons on the OPAC.
289	Privacy:	277	Privacy:
290	-	278	-
		279	- pref: AnonSuggestions
		280	choices:
		281	yes: Allow
		282	no: "Don't allow"
		283	- "patrons that aren't logged in to make purchase suggestions. Suggestions are connected to the AnonymousPatron syspref"
		284	-
		285	- pref: opacreadinghistory
		286	choices:
		287	yes: Allow
		288	no: "Don't allow"
		289	- patrons to see what books they have checked out in the past.
		290	-
291	- pref: EnableOpacSearchHistory	291	- pref: EnableOpacSearchHistory
292	default: 0	292	default: 0
293	choices:	293	choices:
294	yes: Keep	294	yes: Keep
295	no: "Don't keep"	295	no: "Don't keep"
296	- patron search history in the OPAC.	296	- patron search history in the OPAC.
		297	-
		298	- pref: OPACPrivacy
		299	default: 0
		300	choices:
		301	yes: Allow
		302	no: "Don't allow"
		303	- patrons to choose their own privacy settings for their reading history. This requires opacreadinghistory and AnonymousPatron
		304	-
		305	- Use borrowernumber
		306	- pref: AnonymousPatron
		307	class: integer
		308	- as the Anonymous Patron (for anonymous suggestions and reading history)
		309
297	Shelf Browser:	310	Shelf Browser:
298	-	311	-
299	- pref: OPACShelfBrowser	312	- pref: OPACShelfBrowser

Line 0 Link Here

(-)a/koha-tmpl/opac-tmpl/prog/en/modules/opac-privacy.tmpl (+72 lines)
		1	<!-- TMPL_INCLUDE name="doc-head-open.inc" --><!-- TMPL_IF NAME="LibraryNameTitle" --><!-- TMPL_VAR NAME="LibraryNameTitle" --><!-- TMPL_ELSE -->Koha Online<!-- /TMPL_IF --> Catalog &rsaquo; Privacy management for <!-- TMPL_VAR name="firstname" --> <!-- TMPL_VAR name="surname" -->
		2	<!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
		3	</head>
		4	<body>
		5	<div id="doc3" class="yui-t1">
		6	<div id="bd">
		7	<!-- TMPL_INCLUDE name="masthead.inc" -->
		8
		9	<div id="yui-main">
		10	<div class="yui-b"><div class="yui-g">
		11	<div class="container">
		12	<h3><a href="/cgi-bin/koha/opac-user.pl"><!-- TMPL_VAR NAME="firstname" --> <!-- TMPL_VAR NAME="surname" -->'s account</a> <img src="<!-- TMPL_VAR NAME="themelang" -->l../../images/caret.gif" width="16" height="16" alt=">" border="0" /> Privacy policy </h3>
		13
		14	<!-- TMPL_IF name="deleted" -->
		15	<div class="dialog message">Your reading history has been deleted.</div>
		16	<!-- /TMPL_IF -->
		17	<!-- TMPL_IF NAME= "privacy_updated" -->
		18	<div class="dialog message">Your privacy rules have been updated</div>
		19	<!-- /TMPL_IF -->
		20
		21	<h2>Privacy rule</h2>
		22	<!-- TMPL_IF NAME= "Ask_data" -->
		23	<p>We take great care in protecting your privacy. On this screen, you can define how long we keep your reading history.</p>
		24	<p>Your options are: <p>
		25	<form action="/cgi-bin/koha/opac-privacy.pl" method="post" id="opac-privacy-update-form">
		26	<input type="hidden" name="op" value="update_privacy" />
		27	<ul id="opac-privacy-options-list">
		28	<li class="privacy0">Forever: keep my reading history without limit. This is the option for users who want to keep track of what they are reading.</li>
		29	<li class="privacy1">Default: keep my reading history according to local laws. This is the default option : the library will keep your reading history for the duration permitted by local laws.</li>
		30	<li class="privacy2">Never: Delete my reading history immediately. This will delete all record of the item that was checked-out upon check-in.</li>
		31	</ul>
		32	<p id="note1">Please note that information on any book still checked-out must be kept by the library no matter which privacy option you choose.</p>
		33	<p id="note2">Please also note that the library staff can't update these values for you: it's your privacy!</p>
		34	<label for:"privacy">Please choose your privacy rule:</label>
		35	<select name="privacy">
		36	<!-- TMPL_IF name="privacy0" -->
		37	<option value="0" selected="1" class="privacy0">Forever</option>
		38	<!-- TMPL_ELSE -->
		39	<option value="0" class="privacy0">Forever</option>
		40	<!-- /TMPL_IF -->
		41	<!-- TMPL_IF name="privacy1" -->
		42	<option value="1" selected="1" class="privacy1">Default</option>
		43	<!-- TMPL_ELSE -->
		44	<option value="1" class="privacy1">Default</option>
		45	<!-- /TMPL_IF -->
		46	<!-- TMPL_IF name="privacy2" -->
		47	<option value="2" selected="1" class="privacy2">Never</option>
		48	<!-- TMPL_ELSE -->
		49	<option value="2" class="privacy2">Never</option>
		50	<!-- /TMPL_IF -->
		51	</select>
		52	<input type="Submit" value="Submit" />
		53	</form>
		54	<h2>Immediate deletion</h2>
		55	<form action="/cgi-bin/koha/opac-privacy.pl" method="post" id="opac-privacy-delete-form">
		56	<input type="hidden" name="op" value="delete_record" />
		57	<p>Whatever your privacy rule you choose, you can delete all your reading history immediately by clicking here. <b>BE CAREFUL</b>. Once you've confirmed the deletion, no one can retrieve the list!</p>
		58	<input type="submit" value="Immediate deletion" onclick="return confirmDelete(_('Warning: Cannot be undone. Please confirm once again'));" />
		59	</form>
		60	<!-- /TMPL_IF -->
		61	</div>
		62	</div>
		63	</div>
		64	</div>
65	<div class="yui-b">
66	<div class="container">
67	<!--TMPL_INCLUDE NAME="navigation.inc" -->
68	<!-- TMPL_INCLUDE name="usermenu.inc" -->
69	</div>
70	</div>
71	</div>
72	<!-- TMPL_INCLUDE NAME="opac-bottom.inc" -->

Line 0 Link Here

(-)a/opac/opac-privacy.pl (+68 lines)
		1	#!/usr/bin/perl
		2	# This script lets the users change their privacy rules
		3	#
		4	# copyright 2009, BibLibre, paul.poulain@biblibre.com
		5	#
		6	# Koha is free software; you can redistribute it and/or modify it under the
		7	# terms of the GNU General Public License as published by the Free Software
		8	# Foundation; either version 2 of the License, or (at your option) any later
		9	# version.
		10	#
		11	# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
		12	# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
		13	# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
		14	#
		15	# You should have received a copy of the GNU General Public License along with
		16	# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
		17	# Suite 330, Boston, MA 02111-1307 USA
		18
		19	use strict;
		20	use CGI;
		21
		22	use C4::Auth; # checkauth, getborrowernumber.
		23	use C4::Context;
		24	use C4::Circulation;
		25	use C4::Members;
		26	use C4::Output;
		27	use C4::Dates;
		28
		29	my $query = new CGI;
		30	my $dbh = C4::Context->dbh;
		31
		32	my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
		33	{
		34	template_name => "opac-privacy.tmpl",
		35	query => $query,
		36	type => "opac",
		37	authnotrequired => 0,
		38	flagsrequired => { borrow => 1 },
		39	debug => 1,
		40	}
		41	);
		42
		43	my $op = $query->param("op");
		44	my $privacy = $query->param("privacy");
		45
		46	if ($op eq "update_privacy")
		47	{
		48	ModPrivacy($borrowernumber,$privacy);
		49	$template->param('privacy_updated' => 1);
		50	}
		51	if ($op eq "delete_record") {
		52	# delete all reading records for items returned
		53	# uses a hardcoded date ridiculously far in the future
		54	AnonymiseIssueHistory('2999-12-12',$borrowernumber);
		55	# confirm the user the deletion has been done
		56	$template->param('deleted' => 1);
		57	}
		58	# get borrower privacy ....
		59	my ( $borr ) = GetMemberDetails( $borrowernumber );
		60
		61	$template->param( 'Ask_data' => '1',
		62	'privacy'.$borr->{'privacy'} => 1,
		63	'firstname' => $borr->{'firstname'},
		64	'surname' => $borr->{'surname'},
65	'privacyview' => 1,
66	);
67
68	output_html_with_http_headers $query, $cookie, $template->output;