Newsletter-Only Subscriptions for v1.3x

[NotGoddess]

You should see two newsletter groups in the newsletter dropdown list:

Customer Account Newsletter Subscribers
and
All Newsletter Subscribers

They should have numbers behind them e.g. (4)

The 'all' list should have a higher number than the customer account list (if you have newsletter only subscribers). That's the one you use to mail to everyone.

[ctcentralinfo]

fFr anyone using this mod in conjunction with dream-scape's ultimated sefu and Image handler 2 should follow these instructions:

http://www.zen-cart.com/forum/showpo...4&postcount=43

[wildgarden]

You should see two newsletter groups in the newsletter dropdown list:

Customer Account Newsletter Subscribers
and
All Newsletter Subscribers

They should have numbers behind them e.g. (4)

The 'all' list should have a higher number than the customer account list (if you have newsletter only subscribers). That's the one you use to mail to everyone.

I think something is wrong with mine cos I'm only getting 'All newsletter subscribers' which seems to be pulling from customer database only. Even though I can see Newsletter subscribers in the Subscription Management. Any ideas what might be wrong?

[wildgarden]

I think something is wrong with mine cos I'm only getting 'All newsletter subscribers' which seems to be pulling from customer database only. Even though I can see Newsletter subscribers in the Subscription Management. Any ideas what might be wrong?

Once again I worked it out on my own! I removed and reinstalled the subscription manager and it's now showing all newsletter subscribers

[NotGoddess]

It sounds like the query_builder didn't get updated.

Try putting this in from your sql patches page:
(remember to add your db prefix to the query_builder bit if you have one):

UPDATE query_builder SET 
 query_name='Customer Account Newsletter Subscribers', 
 query_description='Returns name and email address of newsletter subscribers who have a customer account.'
 WHERE query_string='select customers_firstname, customers_lastname, customers_email_address from TABLE_CUSTOMERS where customers_newsletter = \'1\'';
 
INSERT INTO query_builder 
  (query_category, query_name, query_description, query_string, query_keys_list)
	VALUES ('email,newsletters', 'Newsletter Subscribers',
	'Returns name and email address of all Customer Account subscribers and all Newsletter-Only subscribers.',
	'select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from TABLE_SUBSCRIBERS as s left join TABLE_CUSTOMERS as c on c.customers_id = s.customers_id ', '');

Note that I purposely changed the name of the new query, removing the 'All' bit just in case the query is already in there.

I'm still a few hours out from the next update-doesn't look like I'll make it tonight, so try that solution.

-Ng_

[barco57]

Has anyone noticed that there is a limit to the size of the email address entered in the subscribe box? I counted out to be 30 characters, well I have a customer that has a 31 character email address. so she could not sign up through the subscribe box, in her case she just subscribed when creating her account, but it doesn't solve the problem for newsletter only subscribers with long email addresses.

[NotGoddess]

I'm not quite ready to release the update yet, but it should be in the next couple days.

In the meantime I've added another patch on my site to fix the subscription manager-it wasn't properly saving/setting the email format.

http://notgoddess.com/scripts/newsletter-subscribe (scroll down to 'known issues'..the patch is there).

Thank you to Wildgarden for noticing this.

-Ng_

[NotGoddess]

Has anyone noticed that there is a limit to the size of the email address entered in the subscribe box?

Just edit the templates to take out the maxlength.
includes/templates/yourtemplate/sideboxes/tpl_subscribe.php
and
includes/templates/yourtemplate/templates/tpl_subscribe_header.php

-Ng_

[barco57]

Thanks for the quick response. I just went in and changed it to 35 characters and I'll wait and see if I have any problems with that.

[frypanman]

Hi,
I love your mod it works very well. My only difficulty is cosmetic. I use firefox so didn't notice at first but in IE I was told that the subscribe box is 2x as wide as the the other boxes and sure enough it was. I checked the size in the layout menu and the boxes and columns are all set to 150px so I can't figure out how IE is figureing it scince I there is no specific size reference in the template or mod. Do you have any idea how I might fix this if it is fiaable? Thanks for any help