namibia
Git Repository Public Repository

namibia

URLs

Copy to Clipboard
Explore
Commits

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

Diff revisions: vs.
  @@ -1,3 +1,3 @@
1 - 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;\">&nbsp;</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.co.za</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;\">&nbsp;</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';
1 + 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;\">&nbsp;</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;\">&nbsp;</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';
2 2
3 3 UPDATE `mig_db`.`lib_template` SET `tags`='auctioncount' WHERE `id`='1';

View View this file contents

History View the full history

Feeds

Commits for data/old_b4c stuff/update_auction_newsletter_template.sql

Need assistance?   Get in touch, or head to our documentation site.