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