Newsletter products, HTML email

[Bit_dippy]

Hi,

I realise that this problem has been mentioned before but I am very new to this and didn't understand how to solve the problem. Like I said I'm very new. Please could you help me with the following error that I get:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and pd.language_id=1' at line 1

 

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 products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in() and pd.language_id=1

 

 

I notice in a previous mention of this that you advise that it is to do with the empty () but I didn't understand how to rectify it. Please could you advise?

 

Many thanks.

[scottyb]

Hi,

I realise that this problem has been mentioned before but I am very new to this and didn't understand how to solve the problem. Like I said I'm very new. Please could you help me with the following error that I get:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and pd.language_id=1' at line 1

 

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 products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in() and pd.language_id=1

I notice in a previous mention of this that you advise that it is to do with the empty () but I didn't understand how to rectify it. Please could you advise?

 

Many thanks.

 

After seeing a few of these issues brought to my attention, it has become clear that there was an entry missing from the installation instructions. The reason for this error is because the product selection box is not popping up when newsletter_products is selected as the module.

 

So, find the line:

<?php echo tep_draw_pull_down_menu('module', $modules_array, $nInfo->module); ?>

 

And replace it with:

<?php echo tep_draw_pull_down_menu('module', $modules_array, $nInfo->module, 'onchange="showProducts()"'); ?>

 

And this should alleviate the problem.

[Get-Wireless 2]

I have installed this contrib, was quite easy, great instructions.

 

My only problems at the moment are.

 

When I select the newsletter_products module I dont get the products. I have to select that module and then click save.

This gives me an error newsletter title required but I am then given the products list below.

 

Line 262 of admin\newsletters.php is

<td class="main"><?php echo tep_draw_pull_down_menu('module', $modules_array, $nInfo->module, 'onchange="showProducts()"'); ?></td>

 

Which according to the previous post should rectify the problem of the products not being displayed when the module is selected.

 

Also I am struggling to find some templates, Can anyone help me out with these please?

 

Regards

Shaun

[Get-Wireless 2]

Sorry for double posting but the forum wont allow me to edit my post :(

 

I have installed this contrib, was quite easy, great instructions.

 

My only problems at the moment are.

 

When I select the newsletter_products module I dont get the products. I have to select that module and then click save.

This gives me an error newsletter title required but I am then given the products list below.

 

Line 262 of admin\newsletters.php is

<td class="main"><?php echo tep_draw_pull_down_menu('module', $modules_array, $nInfo->module, 'onchange="showProducts()"'); ?></td>

 

Which according to the previous post should rectify the problem of the products not being displayed when the module is selected.

 

I also get the p.products_image2 error I too have more pics contrib installed. I see that some has got round this issue but didnt say how, I do have an images stored.

 

Also if I click edit I get:

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/getwi/public_html/dev/admin/includes/classes/object_info.php on line 17

Warning: Variable passed to each() is not an array or object in /home/getwi/public_html/dev/admin/includes/classes/object_info.php on line 18

 

I have made the mod to admin/includes/functions/html_output.php but still have the error.

 

The newsletter is also reset, so any products I have added or text I have put in has gone :(

 

 

Also I am struggling to find some templates, Can anyone help me out with these please?

 

Regards

Shaun

[Guest]

Hi, it's because in your dsatabase, p.products_image2 don't exists.

change in your files to p.products_image .

 

Bye

 

 

Sir I have a similar problem that is

 

1054 - Unknown column 'p.products_image2' in 'field list'

 

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 products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(79) and pd.language_id=1

 

[TEP STOP]

 

Can someone tell me what to do as I am a newbie in PHP and i really didnt understand what you want us to do in the above quotes

 

thanks

[Guest]

Hi, it's because in your dsatabase, p.products_image2 don't exists.

change in your files to p.products_image .

 

Bye

 

 

Sir I have a similar problem that is

 

1054 - Unknown column 'p.products_image2' in 'field list'

 

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 products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(79) and pd.language_id=1

 

[TEP STOP]

 

Can someone tell me what to do as I am a newbie in PHP and i really didnt understand what you want us to do in the above quotes

 

thanks

[Guest]

Hi, it's because in your dsatabase, p.products_image2 don't exists.

change in your files to p.products_image .

 

Bye

 

 

Sir I have a similar problem that is

 

1054 - Unknown column 'p.products_image2' in 'field list'

 

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 products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(79) and pd.language_id=1

 

[TEP STOP]

 

Can someone tell me what to do as I am a newbie in PHP and i really didnt understand what you want us to do in the above quotes

 

thanks

[NekoSign]

Sir I have a similar problem that is

Can someone tell me what to do as I am a newbie in PHP and i really didnt understand what you want us to do in the above quotes

 

thanks

 

You must change "products_image2" by "products_image"

 

in admin/includes/modules/newsletter/newsletter_products.php :

 

$product_query = tep_db_query("select p.products_id, pd.products_name, p.products_image2

 

by

 

$product_query = tep_db_query("select p.products_id, pd.products_name, p.products_image

 

and in a few lines after

 

'products_image' => $product['products_image2'],

 

by

 

'products_image' => $product['products_image'],

 

 

 

;)

[Stin_]

Hello,

 

 

I heve this problem wen i try to make a new newsletter_products

 

 

You need only select products and a template if you are using the newsletter_products module

 

Catchable fatal error: Object of class newsletter_products could not be converted to string in /home/djstools/public_html/admin/includes/functions/html_output.php on line 282

 

 

this is the line 282

 

if (empty($default) && isset($GLOBALS[$name])) $default = stripslashes($GLOBALS[$name]);

 

for ($i=0, $n=sizeof($values); $i<$n; $i++) {

$field .= '<option value="' . tep_output_string($values[$i]['id']) . '"';

if ($default == $values[$i]['id']) {

$field .= ' SELECTED';

}

 

$field .= '>' . tep_output_string($values[$i]['text'], array('"' => '"', '\'' => ''', '<' => '<', '>' => '>')) . '</option>';

}

$field .= '</select>';

 

if ($required == true) $field .= TEXT_FIELD_REQUIRED;

 

return $field;

}

?>

 

 

also wen i go to preview a old newsletter i get this error

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(1143, 1144) and pd.language_id=4

 

[TEP STOP]

 

 

all this becouse naw I have PHP5 but also I edit the index php end the advanced serch result php i ceck this http://www.oscommerce.com/forums/index.php?showtopic=263592 ... but nothing to do so pls what i have to do more ....

 

 

(Apologize for my English)

 

Thank YOU!

 

Cristian

[Vmotion]

You must change "products_image2" by "products_image"

 

in admin/includes/modules/newsletter/newsletter_products.php :

 

$product_query = tep_db_query("select p.products_id, pd.products_name, p.products_image2

 

by

 

$product_query = tep_db_query("select p.products_id, pd.products_name, p.products_image

 

and in a few lines after

 

'products_image' => $product['products_image2'],

 

by

 

'products_image' => $product['products_image'],

;)

 

 

I tried your solution and I'm still having the same Error Message. HELP!

[Vmotion]

can anyone help me with this error message Thanks.

 

Fatal error: Cannot redeclare class newsletter_products in /home/public_html/admin/includes/languages/english/modules/newsletters/newsletter_products.php on line 0

[Vmotion]

can anyone help me with this error message Thanks.

 

Fatal error: Cannot redeclare class newsletter_products in /home/public_html/admin/includes/languages/english/modules/newsletters/newsletter_products.php on line 0

 

 

Anybody?

[NekoSign]

I tried your solution and I'm still having the same Error Message. HELP!

 

I give you my code of admin/includes/languages/english/modules/newsletters/newsletter_products.php

 

 

<?php
/*
 $Id: newsletter_products.php,v 2.0 2007/05/17 scottyb Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License
 //newsletter products
*/

 class newsletter_products {

function newsletter_products($title, $content, $products, $template) {
  $this->title = $title;
  $this->content = $content;
  $this->products = $products;
  $this->template = $template;
}

function choose_products() {
  global $HTTP_GET_VARS, $languages_id;

  //first let's get the products that have been added to newsletter
  if($HTTP_GET_VARS['nID']){
	  $newsletter_products_query = tep_db_query("select products_id from " . TABLE_NEWSLETTERS_TO_PRODUCTS . " where newsletters_id ='" . $HTTP_GET_VARS['nID'] . "'");
	  $newsletter_products_string = '';
	  while($newsletter_products = tep_db_fetch_array($newsletter_products_query)){
		  $newsletter_products_string .= $newsletter_products['products_id'] . ', ';
	  }
	  $newsletter_products_string = trim($newsletter_products_string, ', ');

  //$newsletter_products_string = tep_db_result($newsletter_products_query, 0, $newsletter_products_query['products']);
	  $current_products_query = "select pd.products_id, pd.products_name, p.products_model from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.language_id = '" . $languages_id . "' and pd.products_id = p.products_id and p.products_status = '1'";
	  if($newsletter_products_string) $current_products_query .= " and pd.products_id in(" . $newsletter_products_string . ")";
	$current_products_query .= " order by pd.products_name";
	$current_products_query = tep_db_query($current_products_query);
  }   

  if($newsletter_products_string){
	  $current_products_array = array();
	  while ($current_products = tep_db_fetch_array($current_products_query)){
		  $current_products_array[] = array('id' => $current_products['products_id'],
											'text' => $current_products['products_name'] . ' - ' . $current_products['products_model']);
	  }
  }

  $products_query = "select pd.products_id, pd.products_name, p.products_model from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.language_id = '" . $languages_id . "' and pd.products_id = p.products_id and p.products_status = '1'";
  if($newsletter_products_string) $products_query .= " and pd.products_id not in(" . $newsletter_products_string . ")";
  $products_query .= " order by pd.products_name";

  $products_array = array();
  $products_query = tep_db_query($products_query);

  while ($products = tep_db_fetch_array($products_query)) {
	$products_array[] = array('id' => $products['products_id'],
							  'text' => $products['products_name'] . ' - ' . $products['products_model']);
  }

$choose_products_string = '<script language="javascript"><!--
function mover(move) {
 if (move == \'remove\') {
for (x=0; x<(document.newsletter.products.length); x++) {
  if (document.newsletter.products.options[x].selected) {
	with(document.newsletter.elements[\'chosen[]\']) {
	  options[options.length] = new Option(document.newsletter.products.options[x].text,document.newsletter.products.options[x].value);
	}
	document.newsletter.products.options[x] = null;
	x = -1;
  }
}
 }
 if (move == \'add\') {
for (x=0; x<(document.newsletter.elements[\'chosen[]\'].length); x++) {
  if (document.newsletter.elements[\'chosen[]\'].options[x].selected) {
	with(document.newsletter.products) {
	  options[options.length] = new Option(document.newsletter.elements[\'chosen[]\'].options[x].text,document.newsletter.elements[\'chosen[]\'].options[x].value);
	}
	document.newsletter.elements[\'chosen[]\'].options[x] = null;
	x = -1;
  }
}
 }
 return true;
}

function selectAll(FormName, SelectBox) {
 temp = "document." + FormName + ".elements[\'" + SelectBox + "\']";
 Source = eval(temp);

 for (x=0; x<(Source.length); x++) {
Source.options[x].selected = "true";
 }
}
//--></script>';

  $choose_products_string .= '<table border="0" width="100%" cellspacing="0" cellpadding="2">' . "\n" .
							 '  <tr>' . "\n" .
							 '	<td align="center" class="main"><b>' . TEXT_PRODUCTS . '</b><br>' . tep_draw_pull_down_menu('products', $products_array, '', 'size="20" style="width: 32em;" multiple') . '</td>' . "\n" .
							 '	<td align="center" class="main"> <br><br><input type="button" value="' . BUTTON_SELECT . '" style="width: 8em;" onClick="mover(\'remove\');"><br><br><input type="button" value="' . BUTTON_UNSELECT . '" style="width: 8em;" onClick="mover(\'add\');"></td>' . "\n" .
							 '	<td align="center" class="main"><b>' . TEXT_SELECTED_PRODUCTS . '</b><br>' . tep_draw_pull_down_menu('chosen[]', $current_products_array, '', 'size="20" style="width: 25em;" multiple') . '</td>' . "\n" .
							 '  </tr>' . "\n" .
							 '</table>';

  return $choose_products_string;
}

function productInfo(){
	global $languages_id;
	$this->productInfo = array();
	$p_string = '';
	for($i=0, $n=sizeof($this->products); $i<$n; $i++){
		$p_string .= $this->products[$i] . ', ';
	}
	$p_string = trim($p_string, ', ');

	$product_query = tep_db_query("select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from products p INNER JOIN products_description pd left join 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);

	//$this->productsInfo = array();
	while($product = tep_db_fetch_array($product_query)){
		$this->productsInfo[] = array('products_id' => $product['products_id'],
									  'products_name' => $product['products_name'],
									  'products_image' => $product['products_image'],
									  'products_price' => $product['products_price'],
									  'specials_price' => $product['specials_price'],
									  'products_tax_class_id' => $product['products_tax_class_id']);

	}
}	

function html_content() {	
	global $currencies, $languages_id;		
	//create HTML string containing links & pics

	//define product columns here
	define('COLS', 3);
	$width = intval(100/COLS);
	$html_content = '<table border="0" width="100%" cellpadding="" cellspacing="3"><tr>';

	$col = 0;		
	$this->productInfo();

	//change html body styles here
	$cssPrice = 'color: #000000;';
	$cssSale = 'color: #ff0000;';
	$cssMarkdown = 'color: #000000; text-decoration: line-through';
	$cssLink = 'color: #000000; text-decoration: none; font-weight: bold;';

	for($i=0, $n=sizeof($this->productsInfo); $i<$n; $i++){
		if($col > COLS-1){
			$html_content .= '</tr><tr><td align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $this->productsInfo[$i]['products_id']) . '" style="' . $cssLink . '">' . tep_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES . $this->productsInfo[$i]['products_image'], $this->productsInfo[$i]['products_name']) . '<br>' . $this->productsInfo[$i]['products_name'] . '</a><br></td>';
			$col = 0;
		}else{
			$html_content .= '<td align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $this->productsInfo[$i]['products_id']) . '" style="' . $cssLink . '">' . tep_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES . $this->productsInfo[$i]['products_image'], $this->productsInfo[$i]['products_name']) . '<br>' . $this->productsInfo[$i]['products_name'] . '</a><br></td>';
		}
		$col++;
	}

	//uncomment & create your unsubscribe link in your includes/languages/YOUR LANGUAGE/modules/newsletters/newsletter_products.php
	$html_content .= '</tr></table>';

	if(tep_not_null($this->template)){
		//HTML page from template
		//$content = join('', file(DIR_WS_TEMPLATES . $this->template));
		$content = file_get_contents(DIR_WS_TEMPLATES . $this->template);
		//remove all line breaks and spaces in template to ensure no spaces resulting from email class
		$content = str_replace("\n", '', $content);
		$content = str_replace("\r", '', $content);
		//$content = str_replace('> ', '>', $content);
		$content = addslashes($content);
		$email_title = $this->title;
		$email_message = nl2br($this->content);
		eval ("\$content = \"$content\";");
		$html_content = $content;
	}

	return $html_content;
}

function text_content(){
	global $currencies, $languages_id;

	$text_content = $this->content . "\r\n\r\n";

	//var_dump($this->productsInfo);
	for($i=0, $n=sizeof($this->productsInfo); $i<$n; $i++){
		$text_content .= $this->productsInfo[$i]['products_name'] . ' ';
		$price = ($this->productsInfo[$i]['specials_price']) ? 'Sale Price: ' . $currencies->display_price($this->productsInfo[$i]['specials_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . ' Down from: ' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) : $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id']));
		$text_content .= $price . "\n";
		$text_content .= tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $this->productsInfo[$i]['products_id']) . "\r\r";
	}

	//uncomment & create your unsubscribe link in your includes/languages/YOUR LANGUAGE/modules/newsletters/newsletter_products.php
	$text_content .= "\r\r" . TEXT_UNSUBSCRIBE;

	return $text_content;
}

function confirm() {
  global $HTTP_GET_VARS;

  $mail_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'");
  $mail = tep_db_fetch_array($mail_query);

  $confirm_string = '<table border="0" cellspacing="0" cellpadding="2">' . "\n" .
					'  <tr>' . "\n" .
					'	<td class="main"><font color="#ff0000"><b>' . sprintf(TEXT_COUNT_CUSTOMERS, $mail['count']) . '</b></font></td>' . "\n" .
					'  </tr>' . "\n" .
					'  <tr>' . "\n" .
					'	<td>' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td>' . "\n" .
					'  </tr>' . "\n" .
					'  <tr>' . "\n" .
					'	<td class="main"><b>' . $this->title . '</b></td>' . "\n" .
					'  </tr>' . "\n" .
					'  <tr>' . "\n" .
					'	<td>' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td>' . "\n" .
					'  </tr>' . "\n" .
					'  <tr>' . "\n" .
					'	<td class="main">' . $this->html_content() . '</td>' . "\n" .
					'  </tr>' . "\n" .
					'  <tr>' . "\n" .
					'	<td>' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td>' . "\n" .
					'  </tr>' . "\n" .
					'  <tr>' . "\n" .
					'	<td align="right"><a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID'] . '&action=confirm_send') . '">' . tep_image_button('button_send.gif', IMAGE_SEND) . '</a> <a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a></td>' . "\n" .
					'  </tr>' . "\n" .
					'</table>';

  return $confirm_string;
}

function send($newsletter_id) {
  $mail_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'");
  //create id for current mailing
  $messageId = "Message-Id: <" . time() . "@" . $_SERVER['SERVER_NAME'] . ">";

  $mimemessage = new email(array('X-Mailer: osCommerce bulk mailer', $messageId));

  //$mimemessage->add_text($this->content);
  //$text = $this->text_content();

  $mimemessage->add_html($this->html_content(), $this->text_content(), HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES);
  $mimemessage->build_message();

  while ($mail = tep_db_fetch_array($mail_query)) {
   $mimemessage->send($mail['customers_firstname'] . ' ' . $mail['customers_lastname'], $mail['customers_email_address'], '', EMAIL_FROM, $this->title);
  }

  $newsletter_id = tep_db_prepare_input($newsletter_id);
  tep_db_query("update " . TABLE_NEWSLETTERS . " set date_sent = now(), status = '1' where newsletters_id = '" . tep_db_input($newsletter_id) . "'");
}
 }
?>

[actarus1011]

Hello. I'm trying to install this nice contribution but get stuck by 2 updates to the /admin/newsletter.php file

Indeed, when I try to send a newsletter_product, I got this message

 

Fatal error: Call to undefined method: newsletter_products->send_fckeditor() in /home/httpd/vhosts/www.mt-performances.com/web/catalog/admin/newsletters.php on line 481

 

FCKeditor seems to be the reason, and here below are the 2 updates that cause problems...

 

1.

<!-- ########## [Delaballe] ADD FCKeditor ########## //-->
<!-- Effacer nl2br qui provoque des br suplémentaire à chaque ligne //--> 
       <td><tt><?php echo $nInfo->content; ?></tt></td>
<!-- ########## [Delaballe] END - ADD FCKeditor ########## //-->

 

to be replaced by ?

 

    <td><tt><?php echo nl2br($nInfo->content); ?></tt></td>

 

2.

// ########## [Delaballe] ADD FCKeditor ##########
 $module->send_fckeditor($nInfo->newsletters_id);
// ########## [Delaballe] END - ADD FCKeditor ##########

 

To be replaced by ?

 

  $module->send($nInfo->newsletters_id);

 

 

This last one seems to be the most painful.

Has anybody an Idea ?

 

Thanks in advance

[Rod_Miller]

[Trentide]

Hi Everyone. I'm thinking of using this contribution. Does it work? Is there any support for it? Just wondering.

 

Thanks,

Jason

[azer]

I just installed newsletter2.0 as well because my newsletters.php was cutting off right after the text box,

 

im now getting the following error: Unable to determine the page link!

 

Function used:

 

tep_href_link('', '', 'NONSSL')

anyone found a solution to that ?

[azer]

answering my own question

around line 167 in admin/includes/modules/newsletters/newsletter_products.php :

		if(tep_not_null($this->template)){
		//HTML page from template
		$content = join('', file(DIR_WS_TEMPLATES . $this->template)); // this was originally commented out
		//$content = file_get_contents(DIR_WS_TEMPLATES . $this->template); // this wasn't commented out. switcharoo fixed the template not being used .
		//remove all line breaks and spaces in template to ensure no spaces resulting from email class
		$content = str_replace("\n", '', $content);

 

can somebody confirm that we have to uncomment first line and comment 2nd line ?

[sunrise99]

Dears:

Would you please help to advise how to setup ununsubscribe asap? and give one example?

 

To unsubscribe, follow this '. tep_href_link(HTTPS_CATALOG_SERVER /*. YOUR_UNSUBSCRIBE_LINK*/) .' link.' ??????

from Readme:

define('TEXT_UNSUBSCRIBE', 'You are receiving this notice because you have subscribed to our newsletter. To unsubscribe, follow this '. tep_href_link(HTTPS_CATALOG_SERVER /*. YOUR_UNSUBSCRIBE_LINK*/) .' link.');

 

Thanks & Best Regards,

Sunrise

[emmetje]

Posted version 2.20

 

Fixed sql file

 

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

 

Fixed php5 error "1054 - Unknown column"

 

Enjoy ;)

[skhuu]

Hi Guys

 

Can someone help, there is no unsubscribe link on the newsletter. I only see this;

 

You are receiving this notice because you have subscribed to our newsletter. To unsubscribe, follow this http://www.mzansimp3.co.za/admin/http://www.mzansimp3.co.za link.

 

Where do I change and what,

 

Thanks

[x-plosiv]

anyone found a solution to that ?

 

i have the same problem :-(

[amadorbr]

I need of one help...

 

Why i order by product..????

 

In the newsletter, show the old to new product... i want of new to old product list.

 

The new products in top of Newsletter...

 

Someone can help me?

 

Thanks!

[amadorbr]

please help

Edited April 20, 2008 by amadorbr

[random183]

Hi patamu,

 

to change the size of your pictures in your newsletter , just change into the module/newsletter/newsletter_product.php

the osc function tep_image

 

tep_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES . $this->productsInfo[$i]['products_image'], $this->productsInfo[$i]['products_name'], $imgWidth, $imgHeight)

 

Hi,

 

I've installed this contribution, and all seems to be working well, except for the image sizes.

I currently have the "More_Pics_6 for 2.2 ms2" contribution installed, which appears not to create a thumbnail image and just resized the images on the fly.

I've tried the mod above and it does'nt appear to have made much difference (I changed 2 lines to the above), all my pictures are coming out huge!

Does anyone have a suggestion on how to fix this? I'm quite happy to have a fixed picture size on the newsletters by specifying the pixel size in the code if that would make life easier ! :)

 

Cheers

 

Mat