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

(-)a/installer/data/mysql/atomicupdate/bug_21066b.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q|
4
        UPDATE letter
5
        SET content = REPLACE(content,?,?)
6
        WHERE content LIKE ?
7
    |, undef, 'opac_news.timestamp', 'opac_news.publicationdate', '%opac_news.timestamp%' );
8
    NewVersion( $DBversion, 21066, "Replace timestamp references in letters table");
9
}
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-1 / +1 lines)
Lines 505-511 tables: Link Here
505
            - "<div class=\"newsitem\">"
505
            - "<div class=\"newsitem\">"
506
            - "<h5 style=\"margin-bottom: 1px; margin-top: 1px\"><b><<opac_news.title>></b></h5>"
506
            - "<h5 style=\"margin-bottom: 1px; margin-top: 1px\"><b><<opac_news.title>></b></h5>"
507
            - "<p style=\"margin-bottom: 1px; margin-top: 1px\"><<opac_news.content>></p>"
507
            - "<p style=\"margin-bottom: 1px; margin-top: 1px\"><<opac_news.content>></p>"
508
            - "<p class=\"newsfooter\" style=\"font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px\">Posted on <<opac_news.timestamp>></p>"
508
            - "<p class=\"newsfooter\" style=\"font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px\">Posted on <<opac_news.publicationdate>></p>"
509
            - "<hr />"
509
            - "<hr />"
510
            - "</div>"
510
            - "</div>"
511
            - "</news>"
511
            - "</news>"
(-)a/installer/data/mysql/en/optional/sample_news.yml (-2 / +2 lines)
Lines 29-35 tables: Link Here
29
          content:
29
          content:
30
            - "Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe."
30
            - "Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe."
31
          lang: "koha"
31
          lang: "koha"
32
          timestamp: "2007-10-29 05:25:58"
32
          publicationdate: "2007-10-29 05:25:58"
33
          expirationdate: "2099-01-10"
33
          expirationdate: "2099-01-10"
34
          number: 1
34
          number: 1
35
35
Lines 46-51 tables: Link Here
46
            - "</ul>"
46
            - "</ul>"
47
            - ""
47
            - ""
48
          lang: "koha"
48
          lang: "koha"
49
          timestamp: "2007-10-29 05:34:45"
49
          publicationdate: "2007-10-29 05:34:45"
50
          expirationdate: "2099-01-10"
50
          expirationdate: "2099-01-10"
51
          number: 2
51
          number: 2
(-)a/t/db_dependent/Letters/TemplateToolkit.t (-2 / +3 lines)
Lines 667-673 Date due: <<issues.date_due | dateonly>><br /> Link Here
667
<div class="newsitem">
667
<div class="newsitem">
668
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
668
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
669
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.content>></p>
669
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.content>></p>
670
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
670
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.publicationdate>></p>
671
<hr />
671
<hr />
672
</div>
672
</div>
673
</news>
673
</news>
Lines 1174-1176 sub process_letter { Link Here
1174
    );
1174
    );
1175
    return $letter;
1175
    return $letter;
1176
}
1176
}
1177
- 
1177
1178
$schema->storage->txn_rollback;

Return to bug 21066