INSERT IGNORE  INTO `#__sobipro_paypaladv_setting` (`id`, `lang_type`, `name`, `val`) VALUES(38, 'lang', 'paypal_renew_title', 'Entry Renewal Fee in {section.name} - entry id:{entry.id}');
INSERT IGNORE  INTO `#__sobipro_paypaladv_setting` (`id`, `lang_type`, `name`, `val`) VALUES(39, 'lang', 'paypal_renew_email_subject', 'Entry Renewal Fee in {section.name} - entry id:{entry.id}');
INSERT IGNORE  INTO `#__sobipro_paypaladv_setting` (`id`, `lang_type`, `name`, `val`) VALUES(40, 'lang', 'paypal_renew_email_temp', '<div>Dear {order.contact_name} <br />\n \n<br />\nThank you for submitting your listing <a href="{entry.url}">{entry.name} </a> in  our <strong>{section.name}</strong>. We look forward to a successful working relationship\n<br /> \n<br />\nYour order confirmation number is <strong>{order.id}</strong> and order status is <strong>{order.status}</strong>.\n{payment.summary.sum_brutto} will be charged to your account to complete your order. <br />\n \n<br />\n<strong>You order details are:</strong>\n<div>\n<div style="float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;width:30%">Reference</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">Net</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">Vat</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">Gross</div>\n</div>\n\n{start}\n<div style="clear:both;">\n<div style=" float:left;padding:7px;border:1px solid #e7e7e7;width:30%">{payment.refnum}</div>\n<div style="width:10%; float:left;padding:7px;border:1px solid #e7e7e7;">{payment.net}</div>\n<div style="width:10%; float:left;padding:7px;border:1px solid #e7e7e7;">{payment.vat}</div>\n<div style="width:10%; float:left;padding:7px;border:1px solid #e7e7e7;">{payment.gross}</div>\n</div>\n{end}\n\n<div style="clear:both;">\n<div style="float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;width:30%; text-align:right;">Total</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">{payment.summary.sum_netto}</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">{payment.summary.sum_vat}</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">{payment.summary.sum_brutto}</div>\n</div>\n\n<div style="clear:both;"></div>\n<br /> \n<a href="{payment_url}"><strong>Please click her to pay via Paypal</strong>\n</a>\n<br />\nOR Copy paste below link in your browser to complete the Payment<br />\n<strong>{payment_url}</strong>\n<br />\n<hr />\n Remember, your username and password to manage your listings. <br />\n<br />\nOnce again, thanks for submitting your listing in <strong>{section.name}</strong>. We value your business, and we hope to see you again soon. <br />\n<br />\n \n<br />\nBest Regards, \n<br />\n{sitename}<br />\n{live_site}</div>');
INSERT IGNORE  INTO `#__sobipro_paypaladv_setting` (`id`, `lang_type`, `name`, `val`) VALUES(41, 'lang', 'paypal_renew_confirm_email_subject', 'Order Confirmation');
INSERT IGNORE  INTO `#__sobipro_paypaladv_setting` (`id`, `lang_type`, `name`, `val`) VALUES(42, 'lang', 'paypal_renew_confirm_email_temp', '<div>Dear {order.contact_name} <br />\n \n<br />\nThank you for making payment for your listing <a href="{entry.url}">{entry.name} </a> in  our <strong>{section.name}</strong>. Your entry is now renewed up to {entry.validUntil} on our website <a href="{live_site}">{sitename}</a>.\n<br />\nYour order confirmation number is <strong>{order.id}</strong> and order status is <strong>{order.status}</strong>. ${order.amount} has been  charged to your account to complete your order. <br />\n \n<hr />\n Remember, your username and password to manage your listings. <br />\n<br />\nOnce again, thanks for making payment in <strong>{section.name}</strong>. We value your business, and we hope to see you again soon. <br />\n<br />\n \n<br />\nBest Regards, \n<br />\n{sitename}<br />\n{live_site}</div>');
INSERT IGNORE  INTO `#__sobipro_paypaladv_setting` (`id`, `lang_type`, `name`, `val`) VALUES(43, 'lang', 'paypal_renew_email_subject_admin', '[Admin] New Order Created [entry renewed]');
INSERT IGNORE  INTO `#__sobipro_paypaladv_setting` (`id`, `lang_type`, `name`, `val`) VALUES(44, 'lang', 'paypal_renew_email_temp_admin', 'Hello Admin,\nA new order is created on the website. Below is the copy of email sent to {order.email}  \n<br />\n\n<hr />\n<br />\n\n<div>Dear {order.contact_name} <br />\n \n<br />\nThank you for submitting your listing <a href="{entry.url}">{entry.name} </a> in  our <strong>{section.name}</strong>. We look forward to a successful working relationship\n<br /> \n<br />\nYour order confirmation number is <strong>{order.id}</strong> and order status is <strong>{order.status}</strong>.\n{payment.summary.sum_brutto} will be charged to your account to complete your order. <br />\n \n<br />\n<strong>You order details are:</strong>\n<div>\n<div style="float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;width:30%">Reference</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">Net</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">Vat</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">Gross</div>\n</div>\n\n{start}\n<div style="clear:both;">\n<div style=" float:left;padding:7px;border:1px solid #e7e7e7;width:30%">{payment.refnum}</div>\n<div style="width:10%; float:left;padding:7px;border:1px solid #e7e7e7;">{payment.net}</div>\n<div style="width:10%; float:left;padding:7px;border:1px solid #e7e7e7;">{payment.vat}</div>\n<div style="width:10%; float:left;padding:7px;border:1px solid #e7e7e7;">{payment.gross}</div>\n</div>\n{end}\n\n<div style="clear:both;">\n<div style="float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;width:30%; text-align:right;">Total</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">{payment.summary.sum_netto}</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">{payment.summary.sum_vat}</div>\n<div style="width:10%; float:left;padding:7px;font-weight:700;border:1px solid #e7e7e7;">{payment.summary.sum_brutto}</div>\n</div>\n\n<div style="clear:both;"></div>\n<br /> \n<a href="{payment_url}"><strong>Please click her to pay via Paypal</strong>\n</a>\n<br />\nOR Copy paste below link in your browser to complete the Payment<br />\n<strong>{payment_url}</strong>\n<br />\n<hr />\n Remember, your username and password to manage your listings. <br />\n<br />\nOnce again, thanks for submitting your listing in <strong>{section.name}</strong>. We value your business, and we hope to see you again soon. <br />\n<br />\n \n<br />\nBest Regards, \n<br />\n{sitename}<br />\n{live_site}</div>');
INSERT IGNORE  INTO `#__sobipro_paypaladv_setting` (`id`, `lang_type`, `name`, `val`) VALUES(45, 'lang', 'paypal_renew_confirm_email_subject_admin', '[Admin] Order Confirmation[entry:{entry.id}]');
INSERT IGNORE  INTO `#__sobipro_paypaladv_setting` (`id`, `lang_type`, `name`, `val`) VALUES(46, 'lang', 'paypal_renew_confirm_email_temp_admin', '<div>Hello Admin <br />\n \n<br />\nAn order has been confirmed for listing  <a href="{entry.url}">{entry.name} </a> in  your <strong>{section.name}</strong>.  The  entry is Auto renewed by Paypal. Please verify the data and take necessary action.\n<br />\n<p><strong>Order details:</strong> <br />\nOrder Id :{order.id}<br />\nOrder Amount : ${order.amount}<br />\nPaypal txn Id:{order.txn} <br />\nEntry Id:{entry.id} <br />\nEntry name: <a href="{entry.url}">{entry.name} </a> \n</p>\n \n \n<br />\nBest Regards, \n<br />\n{sitename}<br />\n{live_site}</div>');
