namibia - namibia - Diff df0489e1eeeeab5a9bd44e1d84fce49924fe1bac vs bb2698c383a0585633180c7996aba816667c9e6d on /data/old_b4c stuff/auction_email_template_update.sql - namibia - Powered by XP-Dev.com

Git Repository

Public Repository

namibia

URLs

Copy to Clipboard

Explore

Commits

Diff Revisions df0489 ... vs bb2698 ... for /data/old_b4c stuff/auction_email_template_update.sql

		@@ -1,2 +1,2 @@
1		-	update lib_template set email_template='<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n <head>\r\n <meta http-equiv=\"Content-type\" content=\"text/html; charset=utf-8\" />\r\n <title></title>\r\n </head>\r\n <body style=\"padding:0;margin:0;\">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" align=\"center\" style=\"margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;\">\r\n <tr>\r\n <td style=\"padding:20px 0;\">\r\n <!-- Begin Main Template Table --> \r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" align=\"center\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;\">\r\n <tr>\r\n <td>\r\n <img src=\"{APP_HOST}/images/EmailHeader.png\" width=\"800\" height=\"100\" alt=\"Please set images to always display for our emails\" style=\"display:block;\" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style=\"background:#f6f6f6;padding:20px 0\">\r\n <!-- Main Content table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n <!-- Main Column -->\r\n <td width=\"420\" valign=\"top\" style=\"width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <h1 style=\"font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;\">Bid Successful</h1>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n  \r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n Congratulations! You are the winning bidder of [vehicle] from [seller], at [price].\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Your responsibilities:</b>\r\n <ul>\r\n <li>Complete sale within two working days.</li>\r\n <li>Collect vehicle.</li>\r\n <li>Sign attachments when collecting vehicle.</li>\r\n </ul>\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Seller:</b>\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"3px\" width=\"420\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <td width=\"80px\"><b>Trading Name:</b></td>\r\n <td><b>[seller]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Full Name:</b></td>\r\n <td><b>[seller_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Auction Address:</b></td>\r\n <td><b>[vehicle_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Billing Address:</b></td>\r\n <td><b>[seller_billing_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>VAT Number:</b></td>\r\n <td><b>[seller_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>E-mail:</b></td>\r\n <td><b>[seller_email]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Stock Number:</b></td>\r\n <td><b>[stock_number]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n \r\n <br><br>\r\n \r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Buyer:</b>\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"3px\" width=\"420\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <td width=\"80px\"><b>Trading Name:</b></td>\r\n <td><b>[buyer]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Full Name:</b></td>\r\n <td><b>[buyer_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Physical Address:</b></td>\r\n <td><b>[buyer_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>VAT Number:</b></td>\r\n <td><b>[buyer_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Cellphone:</b></td>\r\n <td><b>[buyer_mobile]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>E-mail:</b></td>\r\n <td><b>[buyer_email]</b></td>\r\n </tr>\r\n </table>\r\n \r\n \r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\"><br/>\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width=\"40\" valign=\"top\" style=\"width:40px;\"> </td>\r\n <!-- Side Column -->\r\n <td width=\"300\" valign=\"top\" style=\"width:300px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <img src=\"{APP_HOST}/images/hammer.gif\" width=\"300px\" alt=\"Content Image\" align=\"left\" style=\"padding:5px;\" />\r\n <h2 style=\"font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;\">Auctions</h2>\r\n <p style=\"margin:0 0 1em;padding:5px;\">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p><br/>\r\n <img width="312" height="355" src="{APP_HOST}/imgs/cmbnfrght.png">\r\n <p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"font-size:10.0pt;font-family:"Arial",sans-serif\">   Website:<span style=\"color:#1f497d\">       </span><span style=\"color:#0206be\"><a href=\"http://www.combinefreight.co.za\" target=\"_blank\" wotsearchprocessed=\"true\">www.combinefreight.co.za</a><div wotsearchtarget=\"combinefreight.co.za\" style=\"cursor: pointer; display: inline-block;width: 16px; height: 16px;\"> </div></span><span style=\"color:#1f497d\"><u></u><u></u></span></span></p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style=\"background:#ececec;padding:10px 0 0;\">\r\n <!-- Begin Footer table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"600\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n <!-- Main Column -->\r\n <td width=\"560\" valign=\"top\" style=\"width:560px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <p style=\"margin:0 0 1em;padding:0;\"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\">  </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End 100% Wrapping Table --> \r\n </body>\r\n </html>\r\n ' where id=5;
2		-	update lib_template set email_template='<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n <head>\r\n <meta http-equiv=\"Content-type\" content=\"text/html; charset=utf-8\" />\r\n <title></title>\r\n </head>\r\n <body style=\"padding:0;margin:0;\">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" align=\"center\" style=\"margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;\">\r\n <tr>\r\n <td style=\"padding:20px 0;\">\r\n <!-- Begin Main Template Table --> \r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" align=\"center\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;\">\r\n <tr>\r\n <td>\r\n <img src=\"{APP_HOST}/images/EmailHeader.png\" width=\"800\" height=\"100\" alt=\"Please set images to always display for our emails\" style=\"display:block;\" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style=\"background:#f6f6f6;padding:20px 0\">\r\n <!-- Main Content table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n <!-- Main Column -->\r\n <td width=\"420\" valign=\"top\" style=\"width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <h1 style=\"font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;\">Auction Successful</h1>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n  \r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n Hello [first_name] [family_name],\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n Congratulations! Your vehicle [vehicle] finished with a winning bid of [price] from [buyer].\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Your responsibilities:</b>\r\n <ul>\r\n <li>Invoice vehicle.</li>\r\n <li>Send Natis, invoice and bank details.</li>\r\n <li>Have vehicle ready for collection.</li>\r\n <li>Print attachments.</li>\r\n </ul>\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Buyer:</b>\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"3px\" width=\"420\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <td width=\"80px\"><b>Trading Name:</b></td>\r\n <td><b>[buyer]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Full Name:</b></td>\r\n <td><b>[buyer_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Physical Address:</b></td>\r\n <td><b>[buyer_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>VAT Number:</b></td>\r\n <td><b>[buyer_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Cellphone:</b></td>\r\n <td><b>[buyer_mobile]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>E-mail:</b></td>\r\n <td><b>[buyer_email]</b></td>\r\n </tr>\r\n </table>\r\n \r\n \r\n </p>\r\n \r\n <br><br>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Seller:</b>\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"3px\" width=\"420\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <td width=\"80px\"><b>Trading Name:</b></td>\r\n <td><b>[seller]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Full Name:</b></td>\r\n <td><b>[seller_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Auction Address:</b></td>\r\n <td><b>[vehicle_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Billing Address:</b></td>\r\n <td><b>[seller_billing_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>VAT Number:</b></td>\r\n <td><b>[seller_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>E-mail:</b></td>\r\n <td><b>[seller_email]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Stock Number:</b></td>\r\n <td><b>[stock_number]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\"><br/>\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width=\"40\" valign=\"top\" style=\"width:40px;\"> </td>\r\n <!-- Side Column --> \r\n <td width=\"300\" valign=\"top\" style=\"width:300px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <img src=\"{APP_HOST}/images/hammer.gif\" width=\"300px\" alt=\"Content Image\" align=\"left\" style=\"padding:5px;\" />\r\n <h2 style=\"font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;\">Auctions</h2>\r\n <p style=\"margin:0 0 1em;padding:5px;\">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p><br/>\r\n <img width="312" height="355" src="{APP_HOST}/imgs/cmbnfrght.png">\r\n <p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"font-size:10.0pt;font-family:"Arial",sans-serif\">   Email:        <span style=\"color:#0206be\"><a href=\"mailto:louise@combinefreight.co.za\" target=\"_blank\" wotsearchprocessed=\"true\"><span style=\"color:#0206be\">louise@combinefreight.co.za</span></a></span><u></u><u></u></span></p>\r\n <p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"font-size:10.0pt;font-family:"Arial",sans-serif\">   Website:<span style=\"color:#1f497d\">       </span><span style=\"color:#0206be\"><a href=\"http://www.combinefreight.co.za\" target=\"_blank\" wotsearchprocessed=\"true\">www.combinefreight.co.za</a><div wotsearchtarget=\"combinefreight.co.za\" style=\"cursor: pointer; display: inline-block;width: 16px; height: 16px;\"> </div></span><span style=\"color:#1f497d\"><u></u><u></u></span></span></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style=\"background:#ececec;padding:10px 0 0;\">\r\n <!-- Begin Footer table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"600\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n <!-- Main Column -->\r\n <td width=\"560\" valign=\"top\" style=\"width:560px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <p style=\"margin:0 0 1em;padding:0;\"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\">  </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End 100% Wrapping Table --> \r\n </body>\r\n </html>\r\n ' where id=6;
	1	+	update lib_template set email_template='<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n <head>\r\n <meta http-equiv=\"Content-type\" content=\"text/html; charset=utf-8\" />\r\n <title></title>\r\n </head>\r\n <body style=\"padding:0;margin:0;\">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" align=\"center\" style=\"margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;\">\r\n <tr>\r\n <td style=\"padding:20px 0;\">\r\n <!-- Begin Main Template Table --> \r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" align=\"center\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;\">\r\n <tr>\r\n <td>\r\n <img src=\"{APP_HOST}/images/EmailHeader.png\" width=\"800\" height=\"100\" alt=\"Please set images to always display for our emails\" style=\"display:block;\" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style=\"background:#f6f6f6;padding:20px 0\">\r\n <!-- Main Content table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n <!-- Main Column -->\r\n <td width=\"420\" valign=\"top\" style=\"width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <h1 style=\"font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;\">Bid Successful</h1>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n  \r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n Congratulations! You are the winning bidder of [vehicle] from [seller], at [price].\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Your responsibilities:</b>\r\n <ul>\r\n <li>Complete sale within two working days.</li>\r\n <li>Collect vehicle.</li>\r\n <li>Sign attachments when collecting vehicle.</li>\r\n </ul>\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Seller:</b>\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"3px\" width=\"420\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <td width=\"80px\"><b>Trading Name:</b></td>\r\n <td><b>[seller]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Full Name:</b></td>\r\n <td><b>[seller_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Auction Address:</b></td>\r\n <td><b>[vehicle_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Billing Address:</b></td>\r\n <td><b>[seller_billing_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>VAT Number:</b></td>\r\n <td><b>[seller_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>E-mail:</b></td>\r\n <td><b>[seller_email]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Stock Number:</b></td>\r\n <td><b>[stock_number]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n \r\n <br><br>\r\n \r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Buyer:</b>\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"3px\" width=\"420\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <td width=\"80px\"><b>Trading Name:</b></td>\r\n <td><b>[buyer]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Full Name:</b></td>\r\n <td><b>[buyer_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Physical Address:</b></td>\r\n <td><b>[buyer_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>VAT Number:</b></td>\r\n <td><b>[buyer_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Cellphone:</b></td>\r\n <td><b>[buyer_mobile]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>E-mail:</b></td>\r\n <td><b>[buyer_email]</b></td>\r\n </tr>\r\n </table>\r\n \r\n \r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\"><br/>\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width=\"40\" valign=\"top\" style=\"width:40px;\"> </td>\r\n <!-- Side Column -->\r\n <td width=\"300\" valign=\"top\" style=\"width:300px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <img src=\"{APP_HOST}/images/hammer.gif\" width=\"300px\" alt=\"Content Image\" align=\"left\" style=\"padding:5px;\" />\r\n <h2 style=\"font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;\">Auctions</h2>\r\n <p style=\"margin:0 0 1em;padding:5px;\">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p><br/>\r\n <img width="312" height="355" src="{APP_HOST}/imgs/cmbnfrght.png">\r\n <p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"font-size:10.0pt;font-family:"Arial",sans-serif\">   Website:<span style=\"color:#1f497d\">       </span><span style=\"color:#0206be\"><a href=\"http://www.combinefreight.co.za\" target=\"_blank\" wotsearchprocessed=\"true\">www.combinefreight.co.za</a><div wotsearchtarget=\"combinefreight.co.za\" style=\"cursor: pointer; display: inline-block;width: 16px; height: 16px;\"> </div></span><span style=\"color:#1f497d\"><u></u><u></u></span></span></p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style=\"background:#ececec;padding:10px 0 0;\">\r\n <!-- Begin Footer table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"600\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n <!-- Main Column -->\r\n <td width=\"560\" valign=\"top\" style=\"width:560px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <p style=\"margin:0 0 1em;padding:0;\"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\">  </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End 100% Wrapping Table --> \r\n </body>\r\n </html>\r\n ' where id=5;
	2	+	update lib_template set email_template='<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n <head>\r\n <meta http-equiv=\"Content-type\" content=\"text/html; charset=utf-8\" />\r\n <title></title>\r\n </head>\r\n <body style=\"padding:0;margin:0;\">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" align=\"center\" style=\"margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;\">\r\n <tr>\r\n <td style=\"padding:20px 0;\">\r\n <!-- Begin Main Template Table --> \r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" align=\"center\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;\">\r\n <tr>\r\n <td>\r\n <img src=\"{APP_HOST}/images/EmailHeader.png\" width=\"800\" height=\"100\" alt=\"Please set images to always display for our emails\" style=\"display:block;\" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style=\"background:#f6f6f6;padding:20px 0\">\r\n <!-- Main Content table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n <!-- Main Column -->\r\n <td width=\"420\" valign=\"top\" style=\"width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <h1 style=\"font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;\">Auction Successful</h1>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n  \r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n Hello [first_name] [family_name],\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n Congratulations! Your vehicle [vehicle] finished with a winning bid of [price] from [buyer].\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Your responsibilities:</b>\r\n <ul>\r\n <li>Invoice vehicle.</li>\r\n <li>Send Natis, invoice and bank details.</li>\r\n <li>Have vehicle ready for collection.</li>\r\n <li>Print attachments.</li>\r\n </ul>\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Buyer:</b>\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"3px\" width=\"420\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <td width=\"80px\"><b>Trading Name:</b></td>\r\n <td><b>[buyer]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Full Name:</b></td>\r\n <td><b>[buyer_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Physical Address:</b></td>\r\n <td><b>[buyer_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>VAT Number:</b></td>\r\n <td><b>[buyer_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Cellphone:</b></td>\r\n <td><b>[buyer_mobile]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>E-mail:</b></td>\r\n <td><b>[buyer_email]</b></td>\r\n </tr>\r\n </table>\r\n \r\n \r\n </p>\r\n \r\n <br><br>\r\n <p style=\"margin:0 0 1em;padding:0;\">\r\n <b>Seller:</b>\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"3px\" width=\"420\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <td width=\"80px\"><b>Trading Name:</b></td>\r\n <td><b>[seller]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Full Name:</b></td>\r\n <td><b>[seller_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Auction Address:</b></td>\r\n <td><b>[vehicle_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Billing Address:</b></td>\r\n <td><b>[seller_billing_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>VAT Number:</b></td>\r\n <td><b>[seller_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>E-mail:</b></td>\r\n <td><b>[seller_email]</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"80px\"><b>Stock Number:</b></td>\r\n <td><b>[stock_number]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p style=\"margin:0 0 1em;padding:0;\"><br/>\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width=\"40\" valign=\"top\" style=\"width:40px;\"> </td>\r\n <!-- Side Column --> \r\n <td width=\"300\" valign=\"top\" style=\"width:300px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <img src=\"{APP_HOST}/images/hammer.gif\" width=\"300px\" alt=\"Content Image\" align=\"left\" style=\"padding:5px;\" />\r\n <h2 style=\"font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;\">Auctions</h2>\r\n <p style=\"margin:0 0 1em;padding:5px;\">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p><br/>\r\n <img width="312" height="355" src="{APP_HOST}/imgs/cmbnfrght.png">\r\n <p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"font-size:10.0pt;font-family:"Arial",sans-serif\">   Email:        <span style=\"color:#0206be\"><a href=\"mailto:louise@combinefreight.co.za\" target=\"_blank\" wotsearchprocessed=\"true\"><span style=\"color:#0206be\">louise@combinefreight.co.za</span></a></span><u></u><u></u></span></p>\r\n <p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"font-size:10.0pt;font-family:"Arial",sans-serif\">   Website:<span style=\"color:#1f497d\">       </span><span style=\"color:#0206be\"><a href=\"http://www.combinefreight.co.za\" target=\"_blank\" wotsearchprocessed=\"true\">www.combinefreight.co.za</a><div wotsearchtarget=\"combinefreight.co.za\" style=\"cursor: pointer; display: inline-block;width: 16px; height: 16px;\"> </div></span><span style=\"color:#1f497d\"><u></u><u></u></span></span></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style=\"background:#ececec;padding:10px 0 0;\">\r\n <!-- Begin Footer table -->\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"600\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r\n <!-- Main Column -->\r\n <td width=\"560\" valign=\"top\" style=\"width:560px; font-family: Arial, Sans-serif; font-size:12px;\">\r\n <p style=\"margin:0 0 1em;padding:0;\"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width=\"20\" valign=\"top\" style=\"width:20px;\">  </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End 100% Wrapping Table --> \r\n </body>\r\n </html>\r\n ' where id=6;

View View this file contents

History View the full history

Feeds

Commits for /data/old_b4c stuff/auction_email_template_update.sql