Newsletter-Only Subscriptions for v1.3x

[lat9]

I installed this on 1.5.4 but don't see any links to firstly upgrade the database and secondly no link Subscription Manager under the customers menu. Is this ready for 1.5.4?

Nope, it was never updated for the Zen Cart v1.3 to v1.5 change in the admin-level interfaces. I'm guessing that the number of core files that the plugin carves up is one of the reasons that no one has picked up the plugin's "baton".

[lina0962]

I created a define_subscribe_confirm.php under /includes/languages/english/html_includes, but when i clicked the link in the email, I was brought back to Newsletter Subscription page, not Newsletter Subscription Confirmation page I added. How to fix it?

[bumba000]

Hey All,
Any chance this module works in 1.5.5?

Thanks, John

[barco57]

unlikely to work on 1.5.5

[bumba000]

well it took quite a bit of file merging, but it does work. Definitely not good to just upload into a 1.5.5 file set.

John

[lina0962]

I didn't click "yes" for Display on Menu button, so I cannot see the "Subscriber Manager" under "customers". How can I fix it? I am so upset with myself.....

[tmccaff]

I updated version waiting on approval. I added an admin page and made changes for it to work with 1.5.5.

[millsii]

In includes/modules/your_template/create_account.php, find the code between // BEGIN newsletter_subscribe mod 1/1 and // END newsletter_subscribe mod 1/1 and try replacing it with:

// BEGIN newsletter_subscribe mod 1/1
// If a newsletter only account exists we update the info,
// but keep the subscription active, and give them a message that to
// change they should do so on their account page (after creation).
    if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') && (NEWSONLY_SUBSCRIPTION_ENABLED=='true')) {
      $check_subscribers_query = "select count(*) as total from " . TABLE_SUBSCRIBERS . "
                    where email_address = '" . zen_db_input($email_address) . "' ";
      $check_subscribers = $db->Execute($check_subscribers_query);
      if ($check_subscribers->fields['total'] > 0) {
        $sql = "UPDATE " . TABLE_SUBSCRIBERS . " SET
                customers_id = '" . (int)$_SESSION['customer_id'] . "',
                email_format = '" . zen_db_input($email_format) . "',
                confirmed = '1' 
                WHERE email_address = '" . zen_db_input($email_address) . "' ";
        $db->Execute($sql);
        $messageStack->add_session('login', SUBSCRIBE_MERGED_NEWSONLY_ACCT);
      } else {
        if (!empty($newsletter)) {
          $sql = "INSERT INTO " . TABLE_SUBSCRIBERS . " 
                  (customers_id, email_address, email_format, confirmed, subscribed_date)
                  VALUES ('" . (int)$_SESSION['customer_id'] . "', '" . zen_db_input($email_address) . "', '" . zen_db_input($email_format) . "', '1', now())";
          $db->Execute($sql);
        }
      }
    }
// END newsletter_subscribe mod 1/1 

I was having the same issue in getting the "1062 Duplicate entry" error when a newsletter subscriber then tried to create an account. This has resolved the issue for me. It does shorten the section of code a fair amount, so hopefully no side effects.

Should this fix by @kamelion0927 be updated in the plugin release?

[davewest]

I was having the same issue in getting the "1062 Duplicate entry" error when a newsletter subscriber then tried to create an account. This has resolved the issue for me. It does shorten the section of code a fair amount, so hopefully no side effects.

Should this fix by @kamelion0927 be updated in the plugin release?

I've been using this mod for some time, but during one of my upgrades the create account side wasn't working to catch existing subscriptions. I tried adding your code and no luck on that ether. Going back to what I needed it to do, I came up with this change.

// BEGIN newsletter_subscribe mod 1/1 
// If a newsletter only account exists we update the info, 
// If not and the new user selected subscribe we add them to the list
 
   if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') && (NEWSONLY_SUBSCRIPTION_ENABLED=='true')) { 
    
      $check_subscribers_sql = "select email_address from " . TABLE_SUBSCRIBERS . " where email_address = :email:";       
      $check_subscribers_query = $db->bindVars($check_subscribers_sql, ':email:', $email_address, 'string');       
      $check_subscribers = $db->Execute($check_subscribers_query); 
 
      if ($check_subscribers->fields['email_address'] != '') {
        // update Subscriber with new customer ID 
        $sql = "UPDATE " . TABLE_SUBSCRIBERS . " 
                 SET customers_id = :customer_id: 
                 WHERE email_address = :email_address:"; 
         $sql = $db->bindVars($sql, ':customer_id:', (int)$_SESSION['customer_id'], 'integer'); 
         $sql = $db->bindVars($sql, ':email_address:', $email_address, 'string'); 
        $db->Execute($sql); 
        // update the new customer with an active subscription
        $news_query = "UPDATE " . TABLE_CUSTOMERS . " 
                 SET customers_newsletter = 1 
                 WHERE customers_id = :customer_id:"; 
         $news_query = $db->bindVars($news_query, ':customer_id:', (int)$_SESSION['customer_id'], 'integer'); 
        $db->Execute($news_query);
         
      } else {
        if ($newsletter == 1) {
          // new customer subscription we need to add them to our subscription database too
          $sql = "INSERT INTO " . TABLE_SUBSCRIBERS . " (customers_id, email_address, email_format, confirmed, subscribed_date)
                  VALUES ('" . (int)$_SESSION['customer_id'] . "', '" . zen_db_input($email_address) . "', '" . zen_db_input($email_format) . "', '1', now())";
          $db->Execute($sql);
        }
      }  
    }
/* END newsletter_subscribe mod 1/1 */

I removed count for matching email address, should only be one and I'm not in a loop. Removed the empty test, it's never empty and I need to know if its a 1. Tested in ZC 1.5.5f and working.

[Nick1973]

Does anybody know how I can use Google Recaptcha with this please?

Contribution found here:

https://www.zen-cart.com/downloads.php?do=file&id=1455