|
Lines 7130-7136
if ( CheckVersion($DBversion) ) {
Link Here
|
| 7130 |
SetVersion($DBversion); |
7130 |
SetVersion($DBversion); |
| 7131 |
} |
7131 |
} |
| 7132 |
|
7132 |
|
| 7133 |
|
|
|
| 7134 |
$DBversion = "3.13.00.020"; |
7133 |
$DBversion = "3.13.00.020"; |
| 7135 |
if ( CheckVersion($DBversion) ) { |
7134 |
if ( CheckVersion($DBversion) ) { |
| 7136 |
$dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES('WhenLostForgiveFine','0',NULL,'If ON, Forgives the fines on an item when it is lost.','YesNo')"); |
7135 |
$dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES('WhenLostForgiveFine','0',NULL,'If ON, Forgives the fines on an item when it is lost.','YesNo')"); |
|
Lines 7139-7162
if ( CheckVersion($DBversion) ) {
Link Here
|
| 7139 |
SetVersion($DBversion); |
7138 |
SetVersion($DBversion); |
| 7140 |
} |
7139 |
} |
| 7141 |
|
7140 |
|
| 7142 |
|
|
|
| 7143 |
$DBversion = "3.13.00.XXX"; |
| 7144 |
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { |
| 7145 |
$dbh->do(" |
| 7146 |
INSERT INTO systempreferences (variable,value,explanation,options,type) |
| 7147 |
VALUES ( |
| 7148 |
'BlockExpiredPatronOpacActions', |
| 7149 |
'1', |
| 7150 |
'Set whether an expired patron can perform opac actions such as placing holds or renew books, can be overridden on a per patron-type basis', |
| 7151 |
NULL, |
| 7152 |
'YesNo' |
| 7153 |
) |
| 7154 |
"); |
| 7155 |
$dbh->do("ALTER TABLE `categories` ADD COLUMN `BlockExpiredPatronOpacActions` TINYINT(1) DEFAULT -1 NOT NULL AFTER category_type"); |
| 7156 |
print "Upgraded to $DBversion done (Bug 6739 - expired patrons not blocked from opac actions)\n"; |
| 7157 |
SetVersion ($DBversion); |
| 7158 |
} |
| 7159 |
|
| 7160 |
$DBversion ="3.13.00.021"; |
7141 |
$DBversion ="3.13.00.021"; |
| 7161 |
if ( CheckVersion($DBversion) ) { |
7142 |
if ( CheckVersion($DBversion) ) { |
| 7162 |
$dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('ConfirmFutureHolds','0','Number of days for confirming future holds','','Integer');"); |
7143 |
$dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('ConfirmFutureHolds','0','Number of days for confirming future holds','','Integer');"); |
|
Lines 8101-8106
if ( CheckVersion($DBversion) ) {
Link Here
|
| 8101 |
SetVersion($DBversion); |
8082 |
SetVersion($DBversion); |
| 8102 |
} |
8083 |
} |
| 8103 |
|
8084 |
|
|
|
8085 |
$DBversion = "3.15.00.XXX"; |
| 8086 |
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { |
| 8087 |
$dbh->do(" |
| 8088 |
INSERT INTO systempreferences (variable,value,explanation,options,type) |
| 8089 |
VALUES ( |
| 8090 |
'BlockExpiredPatronOpacActions', |
| 8091 |
'1', |
| 8092 |
'Set whether an expired patron can perform opac actions such as placing holds or renew books, can be overridden on a per patron-type basis', |
| 8093 |
NULL, |
| 8094 |
'YesNo' |
| 8095 |
) |
| 8096 |
"); |
| 8097 |
$dbh->do("ALTER TABLE `categories` ADD COLUMN `BlockExpiredPatronOpacActions` TINYINT(1) DEFAULT -1 NOT NULL AFTER category_type"); |
| 8098 |
print "Upgraded to $DBversion done (Bug 6739 - expired patrons not blocked from opac actions)\n"; |
| 8099 |
SetVersion ($DBversion); |
| 8100 |
} |
| 8101 |
|
| 8102 |
|
| 8104 |
=head1 FUNCTIONS |
8103 |
=head1 FUNCTIONS |
| 8105 |
|
8104 |
|
| 8106 |
=head2 TableExists($table) |
8105 |
=head2 TableExists($table) |