11 |
q{ INSERT IGNORE INTO letter (module, code, name, is_html, title, content, message_transport_type) VALUES ('lists', 'TRANSFER_OWNERSHIP', 'Transfer ownership', 1, 'A list has been transferred to you', "Dear [%- INCLUDE 'patron-title.inc' patron => new_owner -%],<br>\r\n<br>\r\nA public list, titled <em>[% shelf.shelfname | html %]</em>, has been transferred to you[% IF ( old_owner ) %] by [%- INCLUDE 'patron-title.inc' patron => old_owner%][% IF ( old_owner.email ) %] <em>([% old_owner.email | html %])</em>[% END %][% END %].<br>\r\n<br>\r\nThank you<br>\r\n<br>\r\n", 'email') } |