[Koha-patches] [PATCH] New feature Number of Returned Items to Show - database update

[Mike Hafen]

Quite right in both cases.  Both of these features are two patches, and the
first contains the update to en/mandatory/sysprefs.sql.  My lack of French
prevents me from adding the SQL to the other file.  If someone would be so
kind as to translate the two strings for me I will correct and re-submit.

If set, date due will not be past this date.  Enter date according to the
dateformat System Preference

Number of returned items to show on the check-in page

Thanks.

On Thu, Mar 5, 2009 at 9:13 AM, Joe Atzberger <joe.atzberger at liblime.com>wrote:

> Same comment here, that a new syspref should also be added to:
>
>    - installer/data/mysql/en/mandatory/sysprefs.sql
>    -
>    installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql
>
> --Joe
>
> On Wed, Feb 25, 2009 at 5:48 PM, Michael Hafen <mdhafen at tech.washk12.org>wrote:
>
>> This is the database update to add the system preference for
>> numReturnedItemsToShow
>> ---
>>  installer/data/mysql/updatedatabase.pl |    8 ++++++++
>>  1 files changed, 8 insertions(+), 0 deletions(-)
>>
>> diff --git a/installer/data/mysql/updatedatabase.pl
>> b/installer/data/mysql/updatedatabase.pl
>> index 6b4d6ba..8f0fe8b 100755
>> --- a/installer/data/mysql/updatedatabase.pl
>> +++ b/installer/data/mysql/updatedatabase.pl
>> @@ -2221,6 +2221,14 @@ if (C4::Context->preference("Version") <
>> TransformToNum($DBversion)) {
>>     SetVersion ($DBversion);
>>  }
>>
>> +$DBversion = '3.01.00.024';
>> +if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
>> +    $dbh->do("INSERT INTO `systempreferences` ( `variable` , `value` ,
>> `options` , `explanation` , `type` ) VALUES ( 'numReturnedItemsToShow',
>> '20', '', 'Number of returned items to show on the check-in page',
>> 'Integer')");
>> +
>> +    print "Upgrade to $DBversion done (added numReturnedItemsToShow
>> system preference)\n";
>> +    SetVersion ($DBversion);
>> +}
>> +
>>  =item DropAllForeignKeys($table)
>>
>>   Drop all foreign keys of the table $table
>> --
>> 1.5.6.3
>>
>> _______________________________________________
>> Koha-patches mailing list
>> Koha-patches at lists.koha.org
>> http://lists.koha.org/mailman/listinfo/koha-patches
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-patches/attachments/20090305/2c77cdec/attachment-0002.htm>