Community Add-Ons

While preparing to modify the newsletter products module to work with the MSRP contribution I noticed that the SQL queries failed to cast certain variables as integers as is safe programming practice. I also noticed that the images inserted into the newsletter did not have the size set which will cause problems with the newsletter layout when your products have large images. Also the link function used in the language file for the unsubscribe link was incorrect.

This update corrects the SQL queries, updates the text for unsubscribe with the correct link for accounts_newsletters.php, and passes the SMALL_IMAGE width and height to the tep_image function so that the images in the newsletter will display at a reasonable size. Complete package is attached but only the two newsletter_products.php files have changed since version 2.25.

Minor update to 2.20. Changed so that template files may end with either .html OR .htm and made the check case insensitive so template files can be named with uppercase, lowercase or mixed case and still be retrieved later. Reversed order of step by step instructions for modifying newsletters.php manually so that they will be easier to follow since modifying from top down changes the line numbers you are looking for later on. I also updated the step by step instructions with one step that was missing and was originally only included in the modified newsletters.php file that comes with the contribution. Added sample template to templates folder.

Corrected earlier download as I missed a closing parenthesis in one statement that causes the file to not work. Full package attached.

Minor update to 2.20. Changed so that template files may end with either .html OR .htm and made the check case insensitive so template files can be named with uppercase, lowercase or mixed case and still be retrieved later. Reversed order of step by step instructions for modifying newsletters.php manually so that they will be easier to follow since modifying from top down changes the line numbers you are looking for later on. Added sample template to templates folder. Full package attached.

Fixed sql file

Fixed error with content from textarea not showing up in html email

Fixed php5 error "1054 - Unknown column"

Thanks to the original author

Emmetje, The Netherlands.

version 2 with the last two fixes :
FIX 6 Sep 2007
FIX wrong name in query field 12 Feb 2008

Repost here from http://forums.oscommerce.com/index.php?showtopic=168346&st=160 by scott wrote.

FILE:
catalogadminincludesmodulesnewslettersnewsletter_products.php

LINE WITH ERROR:
$product_query = tep_db_query("select p.products_id, pd.products_name, p.products_image2, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(" . $p_string . ") and pd.language_id=" . $languages_id);

ERROR (wrong field name):
p.products_image2

CHANGE TO (the original DB field name):
p.products_image

I made 2 fixes for this great contrib.

WYSIWYG editors & browser compatibility have come a long way. However some issues still exist between browsers & WYSIWYG editors. Newsletter Products 2.0 is designed to take the trouble out of the html newsletters - bare bones approach.

Version 2.0 includes issues discovered in the support thread. Multipart emails are utilized with text and html parts to help lower spam scores. 2.0 is recommended over any versions posted because it is more "osCommerce" friendly.

********* HOT NEW !!! *********
V1.2 by milerwan (20.05.2007):
- Prices and special prices added
- Fix for Price Break contribution with PriceFormatter.php file (with special price fix)
- French language added
- stylesheet.css added for modulable color and size prices

This is full package.

Enjoy! : )

It seems that author was too modest, or he forgot to put a link to contribution support for his excellent contribution.

Anyway, here is link:
http://forums.oscommerce.com/index.php?showtopic=168346&st=0

A simple fix for the script error if you do not select any products to add to the newsletter.

In admin/includes/modules/newsletters/newsletters_products.php

FIND:
$images_query = tep_db_query("select p.products_id, pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and p.products_id in(" . $this->products . ")");

CHANGE TO:
if ($this->products != ''){
$images_query = tep_db_query("select p.products_id, pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and p.products_id in(" . $this->products . ")");
}

Full version with fix attached

For those who don't use IE, and therefore can't/don't want to use the WYSIWYG contribution. This is a simple html newsletter email that sends an html email with pictures and links to those receiving email. Uses product selection boxes when creating email. Templates can also be used to display the content of the email within the newsletter. Most of the code changes made to existing files are simple sql changes.