UPDATE tblemailtemplates_static SET message = '<span style="font-size: 12pt;">Hello {contact_firstname}</span><br><br> <span style="font-size: 12pt;">Thank you for the payment. Find the payment details below:</span><br><br><span style="font-size: 12pt;">-------------------------------------------------</span><br><br><span style="font-size: 12pt;">Amount:&nbsp;<strong>{payment_total}</strong></span><br><span style="font-size: 12pt;">Date:&nbsp;<strong>{payment_date}</strong></span><br><span style="font-size: 12pt;">Invoice number:&nbsp;<strong># {invoice_number}</strong></span><br><br><span style="font-size: 12pt;">-------------------------------------------------</span><br><br><span style="font-size: 12pt;">You can always view the invoice for this payment at the following link:&nbsp;<a href="{invoice_link}">{invoice_number}</a></span><br><br><span style="font-size: 12pt;">We are looking forward working with you.</span><br><br><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug = 'invoice-payment-recorded';

UPDATE tblemailtemplates SET message = '<span style="font-size: 12pt;">Hello {contact_firstname}</span><br><br> <span style="font-size: 12pt;">Thank you for the payment. Find the payment details below:</span><br><br><span style="font-size: 12pt;">-------------------------------------------------</span><br><br><span style="font-size: 12pt;">Amount:&nbsp;<strong>{payment_total}</strong></span><br><span style="font-size: 12pt;">Date:&nbsp;<strong>{payment_date}</strong></span><br><span style="font-size: 12pt;">Invoice number:&nbsp;<strong># {invoice_number}</strong></span><br><br><span style="font-size: 12pt;">-------------------------------------------------</span><br><br><span style="font-size: 12pt;">You can always view the invoice for this payment at the following link:&nbsp;<a href="{invoice_link}">{invoice_number}</a></span><br><br><span style="font-size: 12pt;">We are looking forward working with you.</span><br><br><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug = 'invoice-payment-recorded' AND message = '<span style="font-size: 12pt;">Hello {contact_firstname}<br /><br /></span>Thank you for the payment. Find the payment details below:<br /><br />-------------------------------------------------<br /><br />Amount:&nbsp;<strong>{payment_total}<br /></strong>Date:&nbsp;<strong>{payment_date}</strong><br />Invoice number:&nbsp;<span style="font-size: 12pt;"><strong># {invoice_number}<br /><br /></strong></span>-------------------------------------------------<br /><br />You can always view the invoice for this payment at the following link:&nbsp;<a href="{invoice_link}"><span style="font-size: 12pt;">{invoice_number}</span></a><br /><br />We are looking forward working with you.<br /><br /><span style="font-size: 12pt;">{email_signature}</span>';