Lines 13868-13883
if( CheckVersion( $DBversion ) ) {
Link Here
|
13868 |
$dbh->do(q|ALTER TABLE opac_news CHANGE COLUMN new content text NOT NULL|); |
13868 |
$dbh->do(q|ALTER TABLE opac_news CHANGE COLUMN new content text NOT NULL|); |
13869 |
} |
13869 |
} |
13870 |
|
13870 |
|
13871 |
my ( $used_in_templates ) = $dbh->selectrow_array(q| |
13871 |
$dbh->do(q| |
13872 |
SELECT COUNT(*) FROM letter WHERE content LIKE "%<<opac_news.new>>%"; |
13872 |
UPDATE letter SET content = REPLACE(content, "<<opac_news.new>>", "<<opac_news.content>>") WHERE content LIKE "%<<opac_news.new>>%" |
13873 |
|); |
13873 |
|); |
13874 |
if ( $used_in_templates ) { |
|
|
13875 |
print "WARNING - It seems that you are using the opac_news.new column in your notice templates\n"; |
13876 |
print "Since it has now been renamed with opac_news.content, you should update them.\n"; |
13877 |
} |
13878 |
|
13874 |
|
13879 |
SetVersion( $DBversion ); |
13875 |
SetVersion( $DBversion ); |
13880 |
print "Upgrade to $DBversion done (Bug 17960 - Rename opac_news with opac_news.content)\n"; |
13876 |
print "Upgrade to $DBversion done (Bug 17960 - Rename opac_news with opac_news.content (template notices have been updated!))\n"; |
13881 |
} |
13877 |
} |
13882 |
|
13878 |
|
13883 |
$DBversion = "16.12.00.008"; |
13879 |
$DBversion = "16.12.00.008"; |
13884 |
- |
|
|