5 description => "Modify AR notices, include TOC line",
8 my ($dbh, $out) = @$args{qw(dbh out)};
11 SET content=REPLACE(content, '\nPages:', '\nTOC: [% IF article_request.toc_request %]Yes[% ELSE %]No[% END %]\nPages:')
12 WHERE code RLIKE '^AR_' AND module='circulation' AND content NOT RLIKE '\nTOC:';
16 # Warn if we find translated notices (educated guess with word Pages)
20 WHERE code RLIKE '^AR_' AND module='circulation' AND content NOT RLIKE '\nPages:';
22 my ( $count ) = $dbh->selectrow_array( $sql );
23 say $out "WARNING: If you have translated AR notices, please add TOC lines yourself." if $count;