insert into email_messages (message_send,message_subject,message_reply_to,message_text,message_format,message_type)values('','Affiliate Information','','<table border="0" cellspacing="0" cellpadding="0" width="100%"><tr><td align="center"><img  border="0" src="templates/Freeway/images/aff_home_logo.jpg"/></td></tr><tr><td height="10"></td></tr><tr><td valign="top" style="padding-left:10px;padding-right:10px"><table border="0" cellspacing="0" cellpadding="3" width="100%"><tr><td><table border="0" cellspacing="2" cellpadding="5" width="100%"><tr><td><table border="0" cellspacing="0" cellpadding="0" style="float:right;margin:5px;" width="210"  bgcolor="#F5E474"><tr bgcolor="#FFCC00"><td class="boxtopleft" width="8" height="8"><img src="images/pixel_trans.gif" /></td><td class="boxtopmiddle" height="8"><img src="images/pixel_trans.gif" /></td><td class="boxtopright" width="8" height="8"><img src="images/pixel_trans.gif" /></td></tr><tr><td class="boxleft"></td><td><table cellpadding="0" cellspacing="0" border="0" width="100%"><tr height="45"><td colspan="4" align="center" valign="middle"><font style="color:#000000;font-weight:bold;font-size:15px">Affiliate Programme Benefits</font></td></tr><tr height="45"  bgcolor="#FFCC00"><td width="5"></td><td width="10" align="right" valign="middle" style="padding-top:5px"><img  border="0" src="templates/Freeway/images/icon_arrow_yellow.gif"/></td> <td align="left" valign="middle" style="padding-left:10px"><font style="color:#000000;font-weight:bold;font-size:11px;">Earn 20% commission on all <br />new and repeat purchases for 30 days</font></td><td width="5"></td></tr><tr height="35"><td width="5"></td><td width="10" align="right" valign="middle" style="padding-top:5px"><img src="templates/freeway/images/icon_arrow_lightyellow.gif" border="0"/></td><td align="left" valign="middle" style="padding-left:10px"><font style="color:#000000;font-weight:bold;font-size:11px;">Link to the most advanced<br>eCommerce platform</font></td><td width="5"></td></tr><tr height="30" bgcolor="#FFCC00"><td width="5"></td><td width="10" align="right" valign="middle" style="padding-top:5px">
<img  border="0" src="templates/Freeway/images/icon_arrow_yellow.gif"/></td><td align="left" valign="middle" style="padding-left:10px"><font style="color:#000000;font-weight:bold;font-size:11px;">30 days return cookie</font></td><td width="5"></td></tr><tr height="30"><td width="5"></td><td width="10" align="right" valign="middle" style="padding-top:5px"><img src="templates/freeway/images/icon_arrow_lightyellow.gif" border="0"/></td><td align="left" valign="middle" style="padding-left:10px"><font style="color:#000000;font-weight:bold;font-size:11px;">Seasonal Banners and Promotions</font></td> <td width="5"></td></tr></table></td><td class="boxright"></td></tr><tr><td class="boxbottomleft"  width="8" height="8"><img src="images/pixel_trans.gif" /></td><td class="boxbottommiddle" height="8"><img src="images/pixel_trans.gif" /></td><td class="boxbottomright"  height="8"><img src="images/pixel_trans.gif" /></td></tr></table><span style="color:#FF6600;font-weight:bold;font-size:21px;height:50px">Welcome to the ZacWare Affiliate Information </span><br /><span style="color:#000000;font-size:12px;height:35px">We\'re pleased to announce our new Affiliate Program in partnership with Commission Junction - <a href="http://www.cj.com" style="color:#0C67CD" target="_blank">www.cj.com</a>.<br /> Please click to join below. </span><br><br />	<span style="color:#FF6600;font-size:13px;height:55px;"><b>Partner with ZacWare to link with the supplier of the most advanced Open Source eCommerce platform.</b></span><br /><br /> <span style="color:#000000;font-size:12px;height:35	px text-align:justify">Join the Affiliate Program from ZacWare the leader in Open Source eCommerce and online business video software. You already know how valuable Freeway is to your site visitors and you are going to love SMACKB!Z. It makes uploading video the the web fun and displaying it professionally online very easy. </span><br /> <span style="color:#000000;font-size:12px;height:35	px text-align:justify">
No matter what your site\'s industry focus or personality, <br />SMACKB!Z has something for everyone!  </span> </td></tr> </table><td></tr><tr height="20"><td></td></tr><tr><td><img  border="0" src="templates/Freeway/images/icon_arrow.gif"/><a href="affiliate_faq.php"><span style="color:#0C67CD;font-size:12px">View FAQ</span></a><p></td></tr><tr style="color:#000000;font-size:12px"> <td>Have a question or need help getting started? Please contact us at <a href="mailto:affiliate@zac-ware.com" style="color:#0C67CD">affiliate@zac-ware.com</a></td> </tr><tr><td height="10"></td> </tr><tr height="25" valign="bottom"> <td align="right"> <a href="https://signup.cj.com/member/brandedPublisherSignUp.do?air_refmerchantid=2096898" style="color:#0C67CD"><img src="templates/freeway/images/buttons/english/button_joinnow.gif" border="0"/></a></td> </tr></table></td></tr></table>','H','AIM');

INSERT into sql_queries values('freeway_v1_0_7.sql',now());
