Newsletter-Only Subscriptions for v1.3x

Radish:

Once a site has been blacklisted, is it a real process to 'remove' the blacklisting?

It can be, but there are a number of things you and your host can do. You can google 'mail server blacklisted' for more ideas, but some basic things:

You can:
See if you can send using the php mail instead of smtp (or vice versa).

Suggest to your host that they:

Track down the spammer (if still hosted there-spammers are notorious for signing up for 1 month, sending as much spam as they can, then diving out with no forwarding address) and shut him down if still active.

Change the MX ip address for the mail server.

You can also see what servers have you blacklisted and see what requirements they have for removal (if the other address didn't have one you can also do it at http://www.dnsstuff.com/ )

In reality it's up to your host to handle the situation, and most good hosts already have policies in place to do so. If they are unwilling or unable, your best bet is to use an external mail server or switch hosts.

-Ng_

If this question has been answered already, I apologize. I've seen it asked a few times, but not answered because the OPs never seem to want to provide an example.

Anyway, I have a problem with the email entry box in the sidebox being too wide in Firefox. In IE it's both too wide and screws up the the look of the sidebox.

Example can be found at http://bishiharem.com

I noticed that in the tpl_subscribe file there is no width defined, however if I give it one I find not only does the width not matter (145px and 25px both look the same), but adjusting the width screws up the text in the other sideboxes.

Any help would be greatly appreciated.

edit file includes\templates\your template\sideboxes\tpl_subscribe.php

edit line
$content .= '  ' . zen_draw_input_field('email', '', 'size="18" maxlength="30" style="width:

where it says 18, make this smaller or larger to fit your template.

Rob

Ng,

Thanks for the info on removing my site/server from being blacklisted. I spoke with my host and they are going change the MX ip address of the mail server. Hopefully that will fix the problem.

Thanks again!

bhfruitcakeco:

If this question has been answered already, I apologize. I've seen it asked a few times, but not answered because the OPs never seem to want to provide an example.

Anyway, I have a problem with the email entry box in the sidebox being too wide in Firefox. In IE it's both too wide and screws up the the look of the sidebox.

Example can be found at http://bishiharem.com

I noticed that in the tpl_subscribe file there is no width defined, however if I give it one I find not only does the width not matter (145px and 25px both look the same), but adjusting the width screws up the text in the other sideboxes.

Any help would be greatly appreciated.
Forgive for sounding a bit annoyed, but as the OP ....

I posted something blandly assuming it was the issue. I'm rechecking it....

Your box width is only 146px wide (inner width), so with the padding on the input, it's too wide at 145px (col width 175-30=145) to fit.

You need to find in the template:
style="width: ' . ($column_width-30) . 'px"

and change that 30 to 40 or 45, etc until it fits for you.

I'll do some research and see if I can find the proper reference for the box width and adjust the template.

-Ng_

@Radish:

btw, I just wanted to let you know I haven't forgotten you-I just haven't had a chance to research it properly as above, when I try to answer hastily it's trouble. :)

My first thought is that it's just an error in the subscription checking-see it shouldn't LET you subscribe the same email twice.

If that email already has a news-only subscription:
If you try to do another newsonly: it should give a dup error. (in zc not sql).
If you make an account, it should merge those records.

If that email already has a customer account:
newsonly: it's says that and tells you to change on your account page.
new acct: shouldn't allow it (std zen, not just this mod).

So if it's not doing that, it's a bug in the script, not anything you've done and I just have to get the time to fix it. I've got a new setup for the error checking but I'll especially test that case.

The sql you posted won't do any harm, but it's for cased where you uploaded your table and 'lost' the auto-increment values. You can try it but I don't think that's the issue.

-Ng_

NotGoddess:

Forgive for sounding a bit annoyed, but as the OP ....

I posted something blandly assuming it was the issue. I'm rechecking it....

I apologize for your annoyance. I did not mean you. I was referring to the querants with similar problems, whom you tried to help, but they wouldn't provide you with an example to help you figure out the problem (OPs=plural).

bhfruitcakeco:

I apologize for your annoyance.
Then it should be I that apologizes. I've been oversensitive of late. :(

At any rate...did either Knuckle-101's or my suggestion help?

-Ng_

NG,
You know we all love ya anyway.

By the way get on messenger later i finally got the id we need for the sp mod if you are ready to mess with it.

Let me know.

The contibution is working well except for one minor issue. If a new customer signs up for the newsletter, then when the record is added to the subscriber's table, the data added is null. I looked through the code, particularly in create_account.php and don't see in the SQL a date reference. I guess it doesn't really matter, but it just looks odd in the subscription manager screen when the date shows up as something in 2036. Has anyone else seen that?

its a sql insert bug, I am currently working on it to fix it. NG is probably aware of it as well.

Rob

If you try to do a test other then your website address test with a hotmail address or yahoo see if it corrects the year, I beleive it creates the year 2036 when the mod is installed on certian sql levels, not everyones.

NotGoddess:

Your box width is only 146px wide (inner width), so with the padding on the input, it's too wide at 145px (col width 175-30=145) to fit.

You need to find in the template:
style="width: ' . ($column_width-30) . 'px"

and change that 30 to 40 or 45, etc until it fits for you.

I'll do some research and see if I can find the proper reference for the box width and adjust the template.

-Ng_

The only file I can find that, as written, is /includes/templates/template_default/sideboxes/tpl_search.php

However, the sophyblue template already overrides it with style="width: ' . ($column_width-50) . 'px"

I also tried knuckle-101's suggestion. Neither increasing nor decreasing worked. :(

I just checked the Layout Boxes Controller and found : sideboxes/sophyblue/subscribe.php (ZenCart's coloring, not mine).

It appears that ZenCart is alerting me to something regarding this file. Maybe this is where the problem lies?

bhfruitcakeco:

I just checked the Layout Boxes Controller and found : sideboxes/sophyblue/subscribe.php (ZenCart's coloring, not mine).

It appears that ZenCart is alerting me to something regarding this file. Maybe this is where the problem lies?

It's red because it's letting you know that the box is in your custom template and not a default box (helps you more easily find it for editing).

I doublechecked and the $column_width variable IS the width of the inner boxes, not the width of the column itself, so that's right at least.

and your width is correct-you have it set to 175 px but your image have spacing that's about 15px worth of padding/margin on each side, so the boxes really ARE 175px wide, but just appear to be more narrow.

But the sideboxes don't know the padding they just know the width. You need to manually adjust for the 'new' width by editing that section I told you:

style="width: ' . ($column_width-30) . 'px"

This is in this file:
/includes/templates/sophyblue/sideboxes/tpl_subscribe.php

Now that line might be wrapped...you might see it as this (including surrounding text) on lines 17-20:

   $content .= '  ' . zen_draw_input_field('email', '', 'size="18" maxlength="30" style="width: ' .
               ($column_width-30) . 'px" value="' . HEADER_SUBSCRIBE_DEFAULT_TEXT .
               '" onfocus="if (this.value == \'' . HEADER_SUBSCRIBE_DEFAULT_TEXT . '\') this.value = \'\';"');

Perhaps that is what is confusing you. You need to change that 30 to a higher number to compensate for the padding-try 40 to get a snug fit, 45 for a little room or 50 for about 10px on either side.

To help you, I've included that sidebox edited to have width-45px (should fit inside the box with just a little padding)

-Ng_

Maybe I can just get this fixed one file at a time. :) :)

@radish: This -might- help you as well, but I'm not certain yet. If you are using 1.3.5 it won't hurt.

@dgwyn:

I've attached a patch that updates create_account.php module and admin/customers.php for 1.3.5 it adds the subscribed date for customers.

What it does is set the subscribed date to the current time-so if a customer subscribes, then unsubscribes, then subscribes again, the date will be that 2nd subscription date.

If a news-only subscriber creates an account, it'll update the subscribed_date to the day they sign up.

Remember to backup before making change to files or the db!

To fix customers currently in the system run this in your sql patches section of the admin:

update subscribers set subscribed_date = now() where subscribed_date = '0000-00-00';

For those not upgraded to 1.3.5 yet:

1. upgrade.
   1a) if you can't, read the readme included for how to manually edit the files.

-Ng_

I'll also get this on my site.

@dgwyn: I rec'd a message that your host has fixed this for you.

-Ng_

Thank you SO much for taking the time to do that for me! It looks perfect now. :happy:

Now I must go and thwap the Zen Cart Developer's Tool Kit for not displaying tpl_subscribe.php when I searched for that "phrase".

bhfruitcakeco:

Thank you SO much for taking the time to do that for me! It looks perfect now. :happy:

Now I must go and thwap the Zen Cart Developer's Tool Kit for not displaying tpl_subscribe.php when I searched for that "phrase".

Like other searches, the tool kit searches line by line so it wouldn't catch the wrapping. If you ever run into that again, you can try searching by part of the string that's significant-e.g. $column_width - 30 . You'll get more false positives, but may have more luck finding it.

btw, does this mean we're on the fruitcake list? :) :)

-Ng_