Newsletter-Only Subscriptions for v1.3x

[kamelion0927]

I have been trying to get this mod to work with COWOA for the last couple of days and I know that there is documentation about COWOA and this mod having compatibility issues due to the fact that COWOA clients are still entered into the database, but as they function completely separate other than that variable, I figured I could work out a way to make them play nice - and I think I did it.

I just wanted to post what I did here in the hopes that someone who has actual php knowledge would take a look and confirm that it won't cause conflicts in my coding.

What I did was go into the includes/modules/pages/subscribe/header.php and in the "check if email address exists in CUSTOMERS table or in SUBSCRIBERS table" section, I added

$check_cust_COWOA_query = "select count(*) as total from " . TABLE_CUSTOMERS .
            " where COWOA_account = '" . zen_db_input($COWOA_account) . "'";
        $check_cust_COWOA = $db->Execute($check_cust_COWOA_query); 

underneath

$check_cust_email_query = "select count(*) as total from " . TABLE_CUSTOMERS .
            " where customers_email_address = '" . zen_db_input($email_address) . "'";
        $check_cust_email = $db->Execute($check_cust_email_query); 

and then I changed

if ($check_cust_email->fields['total'] > 0) { 

to

if (($check_cust_email->fields['total'] > 0) && ($check_cust_COWOA == 'false')){ 

I followed the same steps in admin/subscription_manager.php.

Then I created a test COWOA order, signed up for a subscription and everything worked perfectly. I got a confirmation email and was able to confirm my subscription even though I had completed a COWOA order with the same email address.

I know that the mindset is that a COWOA client will most likely not want a subscription but after so many years in the customer service field, I wouldn't be surprised if a handful of them do. People can be so weird sometimes.

[nolsowski]

I have the newsletter module in my header but I can't seem to figure out how to get it to the right and down in the middle.

http://frompropertorocker.com/fptr_test/

I am sure it's probably really simple and I am just missing where to go lol.

Thanks in advance!

[kamelion0927]

I have the newsletter module in my header but I can't seem to figure out how to get it to the right and down in the middle.

http://frompropertorocker.com/fptr_test/

I am sure it's probably really simple and I am just missing where to go lol.

Thanks in advance!

If you still need help with this, I'm not great at coding but I can show you how to adjust the css - it's really easy with FF.

I looked at your site (which is fabulous - I love the stars on your sidebox headers!) and didn't see the newsletter subscribe box.

[nolsowski]

If you still need help with this, I'm not great at coding but I can show you how to adjust the css - it's really easy with FF.

I looked at your site (which is fabulous - I love the stars on your sidebox headers!) and didn't see the newsletter subscribe box.

Thanks Kamelion. I forgot I shut it off when I was working on the header. It's up but it's hard to see now but it's at the top still lol.

If it's possible to move to the right and to the bottom that will be awesome! If not that's ok and I will just put it in the sidebox.

Thank you for the compliments of my site and for your help. :)

[kamelion0927]

Ok. I see what you're going for!

I think I have mine in about the same position that you want yours.

The first thing that you're going to need to do is go into includes/templates/your_template/common/tpl_header.php and add some <div> tags to your code which you can then utilize in the stylesheet.

In includes/templates/your_template/common/tpl_header.php, your code should look something like this:

<div id="subscribeWrapper">
<?php
// BEGIN newsletter_subscribe mod 1/1
if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') &&
(NEWSONLY_SUBSCRIPTION_ENABLED=='true') &&
(NEWSONLY_SUBSCRIPTION_HEADER=='true')) {
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_SUBSCRIBE_HEADER));
}
// END newsletter_subscribe mod 1/1
?>
</div>

By placing the <div id="subscribeWrapper"> before the code and the </div> after, you can tell the stylesheet which section needs to be moved.

Next, open up your stylesheet.css and anywhere you want add:
subscribeWrapper{}

Then you can add padding and margins as applicable inside the {}.

I highly recommend using a Firefox add-on called Firebug if you don't already because you can actually adjust the CSS on your site through Firebug to see what it looks like before you change the stylesheet. It saves a lot of time when making adjustments to CSS.

Just an FYI, I'm pretty new to all of this too so if I didn't explain myself clearly, don't feel bad asking for further explanation.

Good luck!

[nolsowski]

Ok. I see what you're going for!

I think I have mine in about the same position that you want yours.

The first thing that you're going to need to do is go into includes/templates/your_template/common/tpl_header.php and add some <div> tags to your code which you can then utilize in the stylesheet.

In includes/templates/your_template/common/tpl_header.php, your code should look something like this:

<div id="subscribeWrapper">
<?php
// BEGIN newsletter_subscribe mod 1/1
if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') &&
(NEWSONLY_SUBSCRIPTION_ENABLED=='true') &&
(NEWSONLY_SUBSCRIPTION_HEADER=='true')) {
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_SUBSCRIBE_HEADER));
}
// END newsletter_subscribe mod 1/1
?>
</div>

By placing the <div id="subscribeWrapper"> before the code and the </div> after, you can tell the stylesheet which section needs to be moved.

Next, open up your stylesheet.css and anywhere you want add:
subscribeWrapper{}

Then you can add padding and margins as applicable inside the {}.

I highly recommend using a Firefox add-on called Firebug if you don't already because you can actually adjust the CSS on your site through Firebug to see what it looks like before you change the stylesheet. It saves a lot of time when making adjustments to CSS.

Just an FYI, I'm pretty new to all of this too so if I didn't explain myself clearly, don't feel bad asking for further explanation.

Good luck!

Thanks a bunch! I got the first part done pretty easily but on the second part I have a question. Where did you add the code in the stylesheet? I am lost on where to even put it. lol

[nolsowski]

Thanks a bunch! I got the first part done pretty easily but on the second part I have a question. Where did you add the code in the stylesheet? I am lost on where to even put it. lol

Nvm lol. I got it now. Almost lol. Just need to play with the code to get it to the bottom now. :)

[nolsowski]

Okay I was wrong. I am going to need your help lol.

I have been playing with it in the firebug and it keeps messing up my logo. (I don't have an actual header. I made my header to go in the logo since it wasn't fitting right when I named it to go in the header) Does that make a difference now? Sorry I just remembered that and now it probably won't work?

[kamelion0927]

Okay I was wrong. I am going to need your help lol.

I have been playing with it in the firebug and it keeps messing up my logo. (I don't have an actual header. I made my header to go in the logo since it wasn't fitting right when I named it to go in the header) Does that make a difference now? Sorry I just remembered that and now it probably won't work?

Nope - the code for the subscribe header is completely separate from the rest of the header. It all depends on where you put the code.

Think of the header (or any other code) as a Lego wall, the divs as small pieces of stuck together Legos and each piece of code as an individual Lego. If you have a bunch of different code in the same div, they're going to move together - just like a bunch of constructed Legos. (Stupid analogy I know, but the most visual one I can come up with on this little sleep.)

In looking at your site, I'm not showing the subscribeWrapper CSS settings. Do you have #subscribeWrapper{} on your stylesheet?

[nolsowski]

Nope - the code for the subscribe header is completely separate from the rest of the header. It all depends on where you put the code.

Think of the header (or any other code) as a Lego wall, the divs as small pieces of stuck together Legos and each piece of code as an individual Lego. If you have a bunch of different code in the same div, they're going to move together - just like a bunch of constructed Legos. (Stupid analogy I know, but the most visual one I can come up with on this little sleep.)

In looking at your site, I'm not showing the subscribeWrapper CSS settings. Do you have #subscribeWrapper{} on your stylesheet?

That does make sense. I didn't put the subscribeWrapper in the CSS yet because I am not sure where in the CSS to put it lol.

I just put it in now so hopefully it's in the right place lol