Newsletter-Only Subscriptions for v1.3x

[NotGoddess]

I have found that the Send Email tool does not function if the customer is not subscribed to the newsletter.

That's not good. I'll look into it tonight.

[NotGoddess]

I have found that the Send Email tool does not function if the customer is not subscribed to the newsletter.

Found it. See the attached new audience.php file (backup your other before replacing tho :)

Also noticed another bug...it was letting me send to non-confirmed subscribers when I selected the 'All Newsletter Subscribers' option. To fix that put this in your sql patch tool (replace zen_ in zen_query_builder with your prefix, if any).

[code]
UPDATE query_builder
SET query_string = '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 where
(s.confirmed = 1 or s.customers_id >= 1)'
WHERE query_string = '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';
[code]

I'll get an update out soon as I can (Monday-ish is likely).
-Ng_

[woodlandsprite]

NG: You're wonderful. The quick testing done this am indicates it works.
Will upload to my live site later today (dont want to risk fumble fingers on the live site ;) )

[woodlandsprite]

NG - I have a really silly question. If a newsletter subscriber decides to open an account, is there any way to default their newsletter subscription status to "yes"?
I ask because the default setting on the store for newsletter subscription is No - which seems to override their newsletter subscription status if they have subscribed before becoming a customer.

Just wondering :)
Thanks again for the wonderful mod (and the superfast debug!)
-Stephanie

[NotGoddess]

It should merge the two accounts-if the person forgot to check the 'newsletter' box it should still keep their subscription, but I'll check and include a fix if needed.

-Ng_

[woodlandsprite]

Thanks NG -
I did a test on my mirror and it seems to be working as you describe.
There may have been some other confusion going on as we were trying to do some specialized setup for that particular customer.

[LloydDobbler]

Hey, NotGoddess!!

First off, thanks for what seems to be a great contribution!! (I know it's going to make my life easier, that's for sure).

I just had one question (& as I'm still pretty wet behind the ears with regards to PHP, I hope you can take a sec to help me figure it out):

Given the design of my site, I don't have room to put the full "Newsletter: Enter Email Address (& select HTML or Text-Based)" form on my main page (nor am I using sideboxes, so that approach is out)...so I'm looking at using one of the Define pages as an 'E-List' page. I'm planning to write some body copy, then I want to have the form, along with subscribe/unsubscribe buttons underneath.

My question for you: As a starting point, will I be able to just copy the newsletter_subscribe_mod code from the tpl_header.php example & paste it into the Define Pages page (and tweak the text a bit to make sure it says what I need it to say)? Or will I need to get in and rewrite some of the paths to allow the PHP to find the right way to the functions needed?

...or is there an easier way you'd suggest to do this?

It's probably a simple thing - I just don't understand PHP enough yet to figure out how you're calling the directories up to find the right code.

Thanks for helping a newbie out!

[NotGoddess]

Actually it's pretty easy...if you look at the tpl_subscribe.php in the templates/ dir you'll get an idea (it uses a defined page too). I can do a workup later tonight for you if needed.

-Ng_

[LloydDobbler]

Actually it's pretty easy...if you look at the tpl_subscribe.php in the templates/ dir you'll get an idea (it uses a defined page too). I can do a workup later tonight for you if needed.

-Ng_

Thanks, NG! I'm looking into it...we'll see if my 'PHP Coder' hat fits me well enough today to make it work...otherwise, I might take you up on your offer to do a workup of it.

Thanks again!

[LloydDobbler]

Okay. Hrmph. I'm looking over it, and I'm still not getting how it works. (And even though I've backed up, I don't want to lose track of what I'm working with & somehow mess up the whole thing.)

So I hate to do this, but might I take you up on that offer of doing a workup that would work the way I need it to? I'm just not good enough yet to understand it...and while I firmly believe in learning by doing, I just want to be DONE with this, at this point.

Basically, I'm trying to create a page something like the top of this page:

http://www.glarkware.com/elist.shtml

(Just the top part - although their way of being able to 'subscribe' to a product that's out of stock is pretty cool... But I'll just wait a year (or 5) 'til I'm a bit more familiar with the inner workings of Zen Cart, then I'll try & tackle that one myself.)

I've got the layout part down...I just need to be able to have the subscribe and unsubscribe buttons on the same page, under the field.

If there's anything you could do to look into it, I'd really appreciate it.