Beiträge von admin

    Kleiner Nachtrag noch, Blog wurde soebend noch gefixt. Sind nur 2 Dateien.
    /blog.php
    und
    /includes/modules/metatags.php

    Sind jetzt im FP1 mit drin.
    Ich denke, mit dem FP1 läuft es jetzt wirklich lagsam rund. haben nun schon diverse projekte umgestellt und keine Bugs mehr fest gestellt.

    SQL für enlischen Newsletter


    2. Newsletter english:

    SQL
    UPDATE emails SET 
    email_content_html = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0  Strict//EN"  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html  xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de"  lang="de">\r\n<head>\r\n<meta http-equiv="Content-Type"  content="text/html;charset=utf-8"  />\r\n<title>Newsletter</title>\r\n{literal}\r\n<style  type="text/css">\r\nbody, table {\r\n font-size:11.5px;\r\n  font-family:Helvetica, sans-serif;\r\n  color:#444\r\n}\r\ntable.outerTable {\r\n border: 1px solid  #ccc\r\n}\r\ntd.TopRightDesc {\r\n letter-spacing: 1px;\r\n font-weight:  600\r\n}\r\n.ProductsTable td {\r\n color:#6d88b1;\r\n background:  #f1f1f1\r\n}\r\n.ProductsAttributes td, .ProductsName {\r\n background:  #ffffff\r\n}\r\n.bt {\r\n border-top:1px solid #ccc\r\n}\r\n.bb {\r\n  border-bottom:1px solid #ccc\r\n}\r\n.bl {\r\n border-left:1px solid  #ccc\r\n}\r\n.br {\r\n border-right:1px solid #ccc\r\n}\r\n.fs85 {\r\n  font-size:85%\r\n}\r\n</style>\r\n{/literal}\r\n</head>\r\n<body>\r\n<table  width="90%" border="0" cellpadding="10" cellspacing="0" align="center"  class="outerTable">\r\n <tr>\r\n  <td>\r\n  <table  width="100%" border="0" cellpadding="0" cellspacing="0">\r\n    <tr>\r\n    <td width="50%"><img  src="{$logo_path}logo.gif" alt="" /> </td>\r\n    <td  width="50%" class="TopRightDesc" align="right"> Newsletter  </td>\r\n   </tr>\r\n   </table>\r\n  </td>\r\n  </tr>\r\n <tr>\r\n  <td>\r\n  <div  style="width:95%; background-color:#fff; padding:10px;">\r\n   <h2  style="border-bottom:2px solid #6a0101; padding-bottom:10px;  color:#333;">{$SHOP_NAME} Newsletter</h2>\r\n    <p><strong> {if $personalize == ''yes'' &&  $greeting_type == ''0''} {if $customers_gender == ''f''} Dear  Mrs.{$customers_name}, {else} Dear Mr. {$customers_name}, {/if} {/if}  {if $personalize == ''yes'' && $greeting_type == ''1''} Welcome  {$customers_name}, {/if} {if $personalize == ''''} Dear Customer, {/if}  </strong></p>\r\n   <p>{$body}</p>\r\n   {if  $gift_id}\r\n   {if $greeting_type == ''1''}\r\n   <table  width="100%" style="border:1px #CCC; padding:10px; margin-bottom:15px;  background-color:#ffeded;">\r\n    <tr>\r\n    <td><p  style="padding-bottom:7px; margin:0 0 10px 0;"><strong  style="font-family: Georgia, Times New Roman, Times, serif;  font-size:12px;"><span id="result_box3" lang="en"  xml:lang="en">voucher</span>:</strong></p>\r\n       <span id="result_box" lang="en" xml:lang="en">We will send you a  small gift of a voucher in the amount of</span>  <b>{$gift_ammount}</b>. <br />\r\n      <span  id="result_box2" lang="en" xml:lang="en">Just give when ordering your  personal coupon code</span>:  <b>{$gift_id}</b></td>\r\n    </tr>\r\n    </table>\r\n   {else}\r\n   <table width="100%"  style="border:1px #CCC; padding:10px; margin-bottom:15px;  background-color:#ffeded;">\r\n    <tr>\r\n    <td><p  style="padding-bottom:7px; margin:0 0 10px 0;"><strong  style="font-family: Georgia, Times New Roman, Times, serif;  font-size:12px;"><span id="result_box4" lang="en"  xml:lang="en">voucher</span>:</strong></p>\r\n       <span id="result_box5" lang="en" xml:lang="en">We will send you a  small gift of a voucher in the amount of</span>  <b>{$gift_ammount}</b>. <br />\r\n      <span  id="result_box6" lang="en" xml:lang="en">Just specify when ordering  your personal coupon code</span>:  <b>{$gift_id}</b></td>\r\n    </tr>\r\n    </table>\r\n   {/if}\r\n   {/if}\r\n   <div  style="background:#fff;">\r\n    <table width="100%"  cellpadding="0" cellspacing="0" border="0">\r\n    <tr>  <td>\r\n  {foreach name=aussen item=module_data  from=$module_content}\r\n     <table width="100%" border="0"  cellpadding="10" cellspacing="0" style="border-bottom:1px solid  #999;">\r\n      <tr>\r\n      <td width="20%" rowspan="2"  valign="top" style="border-right:1px solid #999;"><a  href="{$module_data.PRODUCTS_LINK}"> <img  src="{$module_data.PRODUCTS_IMAGE}" alt="{$module_data.PRODUCTS_NAME}"  border="0" class"productImageBorder" /> </a> </td>\r\n       <td width="80%" valign="top"><a  href="{$module_data.PRODUCTS_LINK}"  style="text-decoration:none;">\r\n       <h1  style="font-size:12px;  color:#6a0101;">{$module_data.PRODUCTS_NAME}</h1>\r\n        </a>{$module_data.PRODUCTS_SHORT_DESCRIPTION}\r\n        </td>\r\n      </tr>\r\n      <tr>\r\n      <td  valign="bottom">\r\n       <div style="text-align:right;  border-top:1px solid #000; padding-top:5px; margin-top:10px;">\r\n         <a href="{$module_data.PRODUCTS_LINK}" style="color:#6a0101;  text-decoration:underline;"><b>Buy Now!</b></a> |  <strong>{$module_data.PRODUCTS_PRICE}</strong>\r\n        </div>\r\n      </td>\r\n      </tr>\r\n      </table>\r\n\r\n     {/foreach}</td> </tr>\r\n     </table>\r\n    <div style="text-align:right; font-size:10px;  margin-top:10px;">{$remove_link}</div>\r\n   </div>\r\n    </div>\r\n  </td>\r\n </tr>\r\n</table>',
    email_content_text = 'Shopname Newsletter\r\n\r\n{if $personalize ==  ''yes'' && $greeting_type == ''0''} {if $customers_gender ==  ''f''} Dear Mrs.{$customers_name}, {else} Dear Mr. {$customers_name},  {/if} {/if} {if $personalize == ''yes'' && $greeting_type ==  ''1''} Welcome {$customers_name}, {/if} {if $personalize == ''''} Dear  Customer, {/if}\r\n\r\n{$body}\r\n\r\n{if $gift_id} {if $greeting_type  == ''1''} voucher:\r\n\r\nWe will send you a small gift of a voucher in  the amount of {$gift_ammount}\r\nJust give when ordering your personal  coupon code: {$gift_id}\r\n\r\n{else} voucher:\r\n\r\nWe will send you a  small gift of a voucher in the amount of {$gift_ammount}\r\nJust give  when ordering your personal coupon code: {$gift_id}\r\n\r\n{/if} {/if}  {foreach name=aussen item=module_data from=$module_content}  \r\n\r\n{$module_data.PRODUCTS_NAME}\r\n\r\n{$module_data.PRODUCTS_SHORT_DESCRIPTION}\r\n\r\nbuy  now! | {$module_data.PRODUCTS_PRICE} EUR  \r\n\r\n{/foreach}  {$remove_link}',
    email_backup_html = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0  Strict//EN"  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html  xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de"  lang="de">\r\n<head>\r\n<meta http-equiv="Content-Type"  content="text/html;charset=utf-8"  />\r\n<title>Newsletter</title>\r\n{literal}\r\n<style  type="text/css">\r\nbody, table {\r\n font-size:11.5px;\r\n  font-family:Helvetica, sans-serif;\r\n  color:#444\r\n}\r\ntable.outerTable {\r\n border: 1px solid  #ccc\r\n}\r\ntd.TopRightDesc {\r\n letter-spacing: 1px;\r\n font-weight:  600\r\n}\r\n.ProductsTable td {\r\n color:#6d88b1;\r\n background:  #f1f1f1\r\n}\r\n.ProductsAttributes td, .ProductsName {\r\n background:  #ffffff\r\n}\r\n.bt {\r\n border-top:1px solid #ccc\r\n}\r\n.bb {\r\n  border-bottom:1px solid #ccc\r\n}\r\n.bl {\r\n border-left:1px solid  #ccc\r\n}\r\n.br {\r\n border-right:1px solid #ccc\r\n}\r\n.fs85 {\r\n  font-size:85%\r\n}\r\n</style>\r\n{/literal}\r\n</head>\r\n<body>\r\n<table  width="90%" border="0" cellpadding="10" cellspacing="0" align="center"  class="outerTable">\r\n <tr>\r\n  <td>\r\n  <table  width="100%" border="0" cellpadding="0" cellspacing="0">\r\n    <tr>\r\n    <td width="50%"><img  src="{$logo_path}logo.gif" alt="" /> </td>\r\n    <td  width="50%" class="TopRightDesc" align="right"> Newsletter  </td>\r\n   </tr>\r\n   </table>\r\n  </td>\r\n  </tr>\r\n <tr>\r\n  <td>\r\n  <div  style="width:95%; background-color:#fff; padding:10px;">\r\n   <h2  style="border-bottom:2px solid #6a0101; padding-bottom:10px;  color:#333;">{$SHOP_NAME} Newsletter</h2>\r\n    <p><strong> {if $personalize == ''yes'' &&  $greeting_type == ''0''} {if $customers_gender == ''f''} Dear  Mrs.{$customers_name}, {else} Dear Mr. {$customers_name}, {/if} {/if}  {if $personalize == ''yes'' && $greeting_type == ''1''} Welcome  {$customers_name}, {/if} {if $personalize == ''''} Dear Customer, {/if}  </strong></p>\r\n   <p>{$body}</p>\r\n   {if  $gift_id}\r\n   {if $greeting_type == ''1''}\r\n   <table  width="100%" style="border:1px #CCC; padding:10px; margin-bottom:15px;  background-color:#ffeded;">\r\n    <tr>\r\n    <td><p  style="padding-bottom:7px; margin:0 0 10px 0;"><strong  style="font-family: Georgia, Times New Roman, Times, serif;  font-size:12px;"><span id="result_box3" lang="en"  xml:lang="en">voucher</span>:</strong></p>\r\n       <span id="result_box" lang="en" xml:lang="en">We will send you a  small gift of a voucher in the amount of</span>  <b>{$gift_ammount}</b>. <br />\r\n      <span  id="result_box2" lang="en" xml:lang="en">Just give when ordering your  personal coupon code</span>:  <b>{$gift_id}</b></td>\r\n    </tr>\r\n    </table>\r\n   {else}\r\n   <table width="100%"  style="border:1px #CCC; padding:10px; margin-bottom:15px;  background-color:#ffeded;">\r\n    <tr>\r\n    <td><p  style="padding-bottom:7px; margin:0 0 10px 0;"><strong  style="font-family: Georgia, Times New Roman, Times, serif;  font-size:12px;"><span id="result_box4" lang="en"  xml:lang="en">voucher</span>:</strong></p>\r\n       <span id="result_box5" lang="en" xml:lang="en">We will send you a  small gift of a voucher in the amount of</span>  <b>{$gift_ammount}</b>. <br />\r\n      <span  id="result_box6" lang="en" xml:lang="en">Just specify when ordering  your personal coupon code</span>:  <b>{$gift_id}</b></td>\r\n    </tr>\r\n    </table>\r\n   {/if}\r\n   {/if}\r\n   <div  style="background:#fff;">\r\n    <table width="100%"  cellpadding="0" cellspacing="0" border="0">\r\n    <tr>  <td>\r\n  {foreach name=aussen item=module_data  from=$module_content}\r\n     <table width="100%" border="0"  cellpadding="10" cellspacing="0" style="border-bottom:1px solid  #999;">\r\n      <tr>\r\n      <td width="20%" rowspan="2"  valign="top" style="border-right:1px solid #999;"><a  href="{$module_data.PRODUCTS_LINK}"> <img  src="{$module_data.PRODUCTS_IMAGE}" alt="{$module_data.PRODUCTS_NAME}"  border="0" class"productImageBorder" /> </a> </td>\r\n       <td width="80%" valign="top"><a  href="{$module_data.PRODUCTS_LINK}"  style="text-decoration:none;">\r\n       <h1  style="font-size:12px;  color:#6a0101;">{$module_data.PRODUCTS_NAME}</h1>\r\n        </a>{$module_data.PRODUCTS_SHORT_DESCRIPTION}\r\n        </td>\r\n      </tr>\r\n      <tr>\r\n      <td  valign="bottom">\r\n       <div style="text-align:right;  border-top:1px solid #000; padding-top:5px; margin-top:10px;">\r\n         <a href="{$module_data.PRODUCTS_LINK}" style="color:#6a0101;  text-decoration:underline;"><b>Buy Now!</b></a> |  <strong>{$module_data.PRODUCTS_PRICE}</strong>\r\n        </div>\r\n      </td>\r\n      </tr>\r\n      </table>\r\n\r\n     {/foreach}</td> </tr>\r\n     </table>\r\n    <div style="text-align:right; font-size:10px;  margin-top:10px;">{$remove_link}</div>\r\n   </div>\r\n    </div>\r\n  </td>\r\n </tr>\r\n</table>',
    email_backup_text = 'Shopname Newsletter\r\n\r\n{if $personalize ==  ''yes'' && $greeting_type == ''0''} {if $customers_gender ==  ''f''} Dear Mrs.{$customers_name}, {else} Dear Mr. {$customers_name},  {/if} {/if} {if $personalize == ''yes'' && $greeting_type ==  ''1''} Welcome {$customers_name}, {/if} {if $personalize == ''''} Dear  Customer, {/if}\r\n\r\n{$body}\r\n\r\n{if $gift_id} {if $greeting_type  == ''1''} voucher:\r\n\r\nWe will send you a small gift of a voucher in  the amount of {$gift_ammount}\r\nJust give when ordering your personal  coupon code: {$gift_id}\r\n\r\n{else} voucher:\r\n\r\nWe will send you a  small gift of a voucher in the amount of {$gift_ammount}\r\nJust give  when ordering your personal coupon code: {$gift_id}\r\n\r\n{/if} {/if}  {foreach name=aussen item=module_data from=$module_content}  \r\n\r\n{$module_data.PRODUCTS_NAME}\r\n\r\n{$module_data.PRODUCTS_SHORT_DESCRIPTION}\r\n\r\nbuy  now! | {$module_data.PRODUCTS_PRICE} EUR  \r\n\r\n{/foreach}  {$remove_link}'
    WHERE email_name = 'newsletter'
    AND languages_id = '1';