Ceon Back In Stock Notifications 3.0.0

[Davx]

Hi

At the moment this module is sending plain-txt emails for non account holders and html for users that are logged in.

Is there a way I can change this so everyone gets the html emails?

Kind Regards

Dave

[conor]

Hi Dave,

At the moment this module is sending plain-txt emails for non account holders and html for users that are logged in.

Is there a way I can change this so everyone gets the html emails?

You'll have to manually recode Zen Cart's e-mail function. It is that which decides what format to send the e-mail in.

Should be easy enough to change by modifying the core file.

All the best...

Conor
ceon

[Davx]

Cheers Conor

...for anyone else looking you need to edit /includes/functions/functions_email.php.

      // handling admin/"extra"/copy emails:
      if (ADMIN_EXTRA_EMAIL_FORMAT == 'TEXT' && substr($module,-6)=='_extra') {
        $email_html='';  // just blank out the html portion if admin has selected text-only      
}

//Add this after the above around line 160
            if ($customers_email_format != 'HTML' && $email_html != '' && ($module == 'back_in_stock_notification_subscribe' || $module == 'back_in_stock_notification_subscribe')) {
        $customers_email_format = 'HTML';
      } 

[Tonyy]

Hi

Installed BISN and the request to subscribe form appears thereunder in the product page and you can subscribe all OK and you get your email confirming, so communications with database seems OK on that page.

However when you go to admin under Catalog - back in stock notifications - and you click on it you encounter an error

1146 Table 893_shop.shop_back_in_stock_notification_subscriptions' doesn't exist...

the database table exist and subscriptions are there.

I noticed that database name in our mysql is Shop_back_in_stock_notification_subscriptions with a capital S.


any suggestions?

Thank you
Tony

[conor]

Hi Tony,

I noticed that database name in our mysql is Shop_back_in_stock_notification_subscriptions with a capital S.

Make sure your table prefix is the same in both your store and admin configure.php files.

Other than that, I'm not sure but this is something you've done wrong and not a problem with the software.

Hope that helps.

All the best...

Conor
ceon

[Tonyy]

Conor

I was able to pull the page up by removing line #100 of back_in_stock_notifications.php in admin.

$products_query_raw = strtolower(str_replace("\n", ' ', $products_query_raw));

The page and notifications seem to be working fine,.

I have not explored more if there would be any other implications as a result of removing this line.

Please update if suspect any.

Thanks and happy 4th.


Tony

[conor]

Hi,

I was able to pull the page up by removing line #100 of back_in_stock_notifications.php in admin.

$products_query_raw = strtolower(str_replace("\n", ' ', $products_query_raw));

Okay, I see what happened there then. You're clearly the first person to use the software with a database that uses capital letters (that is actually very rare).

Sorry, I suppose that's technically a bug. I'll remove the strtolower() from the next version.

The reason things didn't break after you made this change is that the str_replace("\n", ' ', bit was added by the Zen Cart developers to the splitPageResults class in the latest versions of Zen Cart. In earlier versions, removing that part of the line would have broken the page altogether.

You should make the same change on line 181 by the way!

Enjoy your holiday day! :)

All the best...

Conor
ceon