Newsletter-Only Subscriptions for v1.3x

Oh, in case anyone is wondering, the wishlist so far is:

Additional query groups for testing newsletters.

Ability to import/export subscribers (so if you want to use zen for subscriptions, but want to use a more flexible newsletter program to actually send them).

Adjust unsubscribe so it will prefill email field when email is sent (user still has to confirm).

Fix the newsletter script itself (occassionally errors out sending large groups) or at least note what emails were sent so manual fixes can avoid duplication.

Add cc to admin email + config. maybe a 'new' list on index page or manager page.

I have installed the newsletter subscribe add on and it's been working well so far but I was trying to create a test account using the install patch. Anyway I was getting a syntax error with my code and clever me (!) with no knowledge of mySQL went into phpmyadmin and deleted the whole query_builder row thinking this would solve my problem but now i'm getting an error message saying:

1146 Table 'wildgard_shop.shop_query_builder' doesn't exist
in:
[select query_name, query_string from shop_query_builder where query_category like '%email%']

So i'm thinking I need to restore this table but how do i do that? HELP PLEASE!

Don't worry about the above. I figured it out on my own. I just had to insert a create table query :$ crisis adverted!

Good to hear you came through it okay.
-Ng_

sorry for the repost. server lag.

Does anyone know where all the emails are stored when a new subscriber subscribes. I mean in the ftp server, is there a particular txt file, etc that logs all the emais down onto 1 sheet.

thanks!
Niele

Hi.... i am using zencart 1.3x and newletter only ....2.2 but i get an sql error when eidting and saving something in the clients information ( admin/customers.php )

Error is:

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 'confirmed = 1 WHERE customers_id = '2'' at line 4
in:
[UPDATE soemprefix_subscribers SET email_address = '[email protected]', email_format = 'TEXT' confirmed = 1 WHERE customers_id = '2' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have no clue...what is wrong here..

nielest:

Does anyone know where all the emails are stored when a new subscriber subscribes. I mean in the ftp server, is there a particular txt file, etc that logs all the emais down onto 1 sheet.

thanks!
Niele

The email template itself is in email/email_template_newsletter_subscription.html
The english text for the template is in includeds/languages/english/(your_template)/subscribe.php

kookiewookie:

Error is:

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 'confirmed = 1 WHERE customers_id = '2'' at line 4
in:
[UPDATE soemprefix_subscribers SET email_address = '[email protected]', email_format = 'TEXT' confirmed = 1 WHERE customers_id = '2' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

There is a comma missing. :(
Edit customers.php at at the end of line 274, add a comma:

email_format = '" . $customers_email_format . "', <----

The entire query:

$db->Execute("UPDATE " . TABLE_SUBSCRIBERS . "
SET email_address = '" . $customers_email_address . "',
email_format = '" . $customers_email_format . "',
confirmed = 1
WHERE customers_id = '" . (int)$customers_id . "' ");

Sorry!

-Ng_

NotGoddess:

The email template itself is in email/email_template_newsletter_subscription.html
The english text for the template is in includeds/languages/english/(your_template)/subscribe.php

Thanks for your reply Not Goddess, although i think i've not explained myself clearly enough. Alow me to try once more, i sincerely thank you for your time.

What i wanna know is where the emails from the newsletter subscribers get stored on the ftp server? Like if i enter my email in the subscribe list where does it get written to on the FTP, i ask this in hopes of editing that file to add more emails from an external email set i've accumulated over the years of my clients.

I hope this helps.

thank a million!
Niele

See post 15 in this thread: http://www.zen-cart.com/forum/showpost.php?p=210100&postcount=15

But since then I've added the confirmation requirement, so you'd follow the same basics, but add a 'confirmed' field so the sql would look like this:

INSERT INTO tbl_name (email_address, confirmed)
VALUES('[email protected]' , 1), ('[email protected]' , 1),
('[email protected]', 1), ('[email protected]' , 1);

I'm going to get another update out that has import from/export to a file (and the other wishlist items), but it's going to be this weekend (Sunday) at the earliest as I've got to earn gas/food money this week or I'm sunk :0 I'll try to work on it and get it out earlier, but no guarantees.

-Ng_

how to disable the email confirmation ??

besides, i receeved the confirmation link broken. i had to copy paste it to the address bar..

Regarding the uri in the email, by 'broken' I assume you mean on two lines? Most email programs will still link properly even if they wrap the line, but there's not much I can do about that- there's no way to shorten it.

Regarding turning off the confirmation:

Short answer: you don't - it's there for your security and their peace of mind.

Longer answer:
You would have to edit the header.php file for the subscribe page and comment out the email,
and change the sql query inserting the subscription to have it as '1' instead of the confirmation code,
then edit the language file to remove any mention that a confirmation is sent,
then you'd have to manually confirm each in admin (or run a sql query via the sql patch: update table_subscribers set confirmed = '1'; ) for any existing emails.

You are more than welcome to do this, but I won't make it an on/off option because I get so much spam every day where it says 'well according to our records you signed up for this' and most people feel more secure when they know a company cares that it does not spam (with or without intent to do so).

-Ng_

u know, i liked the short answer more. hahahahaha. thanks for the help

chac416:

u know, i liked the short answer more. hahahahaha. thanks for the help
laugh anytime.

NotGoddess:

See post 15 in this thread: http://www.zen-cart.com/forum/showpost.php?p=210100&postcount=15

But since then I've added the confirmation requirement, so you'd follow the same basics, but add a 'confirmed' field so the sql would look like this:

INSERT INTO tbl_name (email_address, confirmed)
VALUES('[email protected]' , 1), ('[email protected]' , 1),
('[email protected]', 1), ('[email protected]' , 1);

> 
> I'm going to get another update out that has import from/export to a file (and the other wishlist items), but it's going to be this weekend (Sunday) at the earliest as I've got to earn gas/food money this week or I'm sunk :0  I'll try to work on it and get it out earlier, but no guarantees.
> 
> -Ng_

this is great i can't wait for the next update as i have a list of a few thousand emails i've compiled over the years that i desperately need to put into the auto mailer. thank you so much. Your work is so appreciated. It's people like you that keep us moving forward. Respect.

NotGoddess:

There is a comma missing. :(
Edit customers.php at at the end of line 274, add a comma:

email_format = '" . $customers_email_format . "', <----

> The entire query:
> ```
$db->Execute("UPDATE " . TABLE_SUBSCRIBERS . " 
	 SET	email_address = '" . $customers_email_address . "',
	email_format = '" . $customers_email_format . "',
               confirmed = 1
	 WHERE	customers_id = '" . (int)$customers_id . "' ");

Sorry!

-Ng_

OEF.. i should have seen that one myself really.
Strnagly enough IT only seems to occur when i am using Group Discount.
when i switched it off all worked well again.
NOW with this small "bugfix" it works wuth Discount Groups activated as well!

thank you NG

I just installed image handler over this mod. Before if I but in an entry that wasn't an email address I would bet an error message, but now that I installed the new image handler mod I am getting a success message no matter what. What files might have been overwrittein with the installation of image handler that could have caused this?

My bad, this is my test site:

http://www.books-japan-online.com/test/

ctcentralinfo:

What files might have been overwrittein with the installation of image handler that could have caused this?

I assume you are using Image Handler 2.0 for v1.3 (Tim Kroeger) ?
Taking a quick look I don't see any overlap.
I'll check when I get to my dev machine in a few hours, but I don't see the connect. I have IH2 on a cart and haven't run into issues.

The function that checks for a valid email is:
zen_validate_email() which is in includes/functions/functions_email.php

Are you familiar with using WinMerge or similar file diff utility? If so you can try comparing the contrib to the existing files to see if any has changed.
Pay special attention to the file includes/modules/pages/subscribe/header_php.php as that is where the check is performed.

Unfortunately it's not something I can diagnose from here. :(

-Ng_

[oann- looks like you'll want the sidebox width patch. on my site or outlined in this thread (just need a few spaces or br's before input/submit)]