Newsletter-Only Subscriptions for v1.3x

[HeathenMagic]

Hiya,

Thanks for getting back to me. Just to say it is working A.O.K and is chuffing brilliant!!

Regards,

Russ

[alanpace]

I found one typo in this excellent contribution. A SQL error appeared when I deleted a customer account.

admin/customers.php

On line 343, change

where customer_id = '" . (int)$customers_id . "'");

to

where customers_id = '" . (int)$customers_id . "'");

(changed customer_id to customers_id)

[NotGoddess]

I found one typo in this excellent contribution.

Thank you for finding that!

I've added the correction and upgraded the version to 2.0.2

-Ng_

[mocha]

Thanks for the contribution NG. I am looking to do a mass import of newsletter only subscribers. Is there an easy way to do this?

Thanks

[NotGoddess]

Thanks for the contribution NG. I am looking to do a mass import of newsletter only subscribers. Is there an easy way to do this?

It would depend upon format of your list (sql, txt, xsl, csv, etc). if you email me a copy of the list (or part of it) I can build something for you.

I'll end with this caveat -not because I think you are intending it, but others might.
admin-added subscriptions are auto-confirmed, but please please do not use this as a way to send people unsolicited spam (like using a list you bought somewhere).

-Ng_

[mocha]

Thanks for the offer NG. The list format is flexible, at the moment it is an excel file with just the username and the email address. Also with the sidebox, I cannot find where to change it so the sidebox title is just "Newsletter" and is not a link.

[NotGoddess]

Okay, well the easiest way (other than having me code an interface :) would be to turn the excel into a sql file:

Copy the email address column and save as a txt file (separate with commas).

Open that file in your favorite text editor.

Add to the beginning of the file (replace tbl_name with your subscribers table name, including prefix):
INSERT INTO tbl_name (email_address) VALUES(

Use the find/replace command:
find: , [that's a comma]
replace with: '), ('

If the editor supports adding newlines you might use:
replace with: '),\n ('

At the end of the file you should have: lastemail@address
Add to end: '); so it is: lastemail@address');

You are trying to end up with:
INSERT INTO tbl_name (email_address)
VALUES([email protected]), ([email protected]),
([email protected]), ([email protected]);

Save the resulting file (as .sql or .txt) and use the sql patches feature in the Tools menu to upload/run it. If you have hundreds of names you may need to break into a few files.

-Ng_

[NotGoddess]

Also with the sidebox, I cannot find where to change it so the sidebox title is just "Newsletter" and is not a link.

? The 'Subscribe' sidebox title is not a link by default. Are your other sideboxes
linked? It might be a feature you have enabled somewhere.

[edit: found it]
edit /includes/modules/sideboxes/YOUR_TEMPLATE/subscribe.php
and add this somewhere:

$title_link = false;

Let me know if that works and I'll include it in the next update.

-Ng_

[bumba000]

Hey All,
Any chance this module works in 1.5.5?

Thanks, John

[barco57]

unlikely to work on 1.5.5