namibia
90d6a07e7e4539815d3e24e48c81d37282fb4e71
1 2 3 |
UPDATE `mig_db`.`lib_template` SET `email_template`='<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r <head>\r <meta http-equiv=\"Content-type\" content=\"text/html; charset=utf-8\" />\r <title></title>\r </head>\r <body style=\"padding:0;margin:0;\">\r <!-- Begin 100% Wrapping Table -->\r <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 <tr>\r <td style=\"padding:20px 0;\">\r <!-- Begin Main Template Table -->\r <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 <tr>\r <td colspan=\"7\">\r <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 </td>\r </tr>\r <tr>\r <td colspan=\"7\" align=\"right\" style=\"margin:0;padding:10px;font-weight:bold;color:#FFFFFF;background:#AA0000;\">\r Auction vehicles that will end today: [auctioncount]\r </td>\r </tr>\r <tr>\r <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r Model\r </td>\r <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r Type\r </td>\r <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r M&M code\r </td>\r <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r Year\r </td>\r <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r KM\r </td>\r <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r Location\r </td>\r <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r Reserve\r </td>\r </tr>\r [repeater]\r <tr>\r <td colspan=\"7\" style=\"background:#ececec;padding:10px 0 0;\">\r <!-- Begin Footer table -->\r <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 <tr>\r <!-- Spacing Column -->\r <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r <!-- Main Column -->\r <td width=\"380\" valign=\"top\" style=\"width:380px; font-family: Arial, Sans-serif; font-size:12px;\">\r <p style=\"margin:0 0 1em;padding:0;\"><b>bid4cars.com.na</b></p>\r </td>\r <!-- Spacing Column -->\r <td width=\"380\" valign=\"top\" align=\"right\" style=\"width:380px;\">\r Click <a href=\"{APP_HOST}/unsubscribe/newsletter\">here</a> to unsubscribe from newsletters.\r </td>\r <!-- Spacing Column -->\r <td width=\"20\" valign=\"top\" style=\"width:20px;\"> </td>\r </tr>\r </table>\r <!-- /End Footer Table -->\r </td>\r </tr>\r </table>\r <!-- /End Main Template Table -->\r </td>\r </tr>\r </table>\r <!-- /End 100% Wrapping Table -->\r </body>\r </html>\r ' WHERE `id`='1';
UPDATE `mig_db`.`lib_template` SET `tags`='auctioncount' WHERE `id`='1';
|
Commits for namibia/data/old_b4c stuff/update_auction_newsletter_template.sql
| Revision | Author | Commited | Message |
|---|---|---|---|
bb2698 ...
 Diff
|
Mark | Mon 24 Oct, 2016 08:44:08 +0000 | latest update |
| df0489 ... | Mark | Fri 14 Oct, 2016 10:01:00 +0000 | initial commit |
View complete history
Commits RSS feed for