Back In Stock Notifications

[conor]

Hi,

I am getting error 1066 Not unique table/alias: 'njm'

Simply remove the following from the code you posted and it will work:

, 
                        ". TABLE_PRODUCTS . " njm 

(Don't forget to remove that comma!)

As for having the model appended to the product's name and the name and model link to the product page, you'll need to modify

includes/templates/template_default/templates/tpl_account_back_in_stock_notifications_default.php

change:

        // Add the product's name
        $product_name =
            htmlentities($subscribed_notification_lists[$i]['product_name'], ENT_COMPAT, CHARSET);
            
        $back_in_stock_notifications_item->setVariable('product_name', $product_name); 

to

        // Add the product's name
        $product_name =
            htmlentities($subscribed_notification_lists[$i]['product_name'], ENT_COMPAT, CHARSET);
            
        $back_in_stock_notifications_item->setVariable('product_name', $product_name);
        
        // Add the product's model
        $product_model =
            htmlentities($subscribed_notification_lists[$i]['product_model'], ENT_COMPAT, CHARSET);
            
        $back_in_stock_notifications_item->setVariable('product_model', $product_model);
        
        // Add a link to the product's page
        $product_info_page_link = zen_href_link(PRODUCT_INFO, 'products_id=' 
            $subscribed_notification_lists[$i]['id']);
            
        $back_in_stock_notifications_item->setVariable('product_info_page_link',
            $product_info_page_link); 

Finally, you'll need to update the template file to use the variables you'd just "placed" with the new code above (courtesy of Ceon's cool template system):

includes/templates/template_default/templates/inc.html.back_in_stock_notifications.html

In ACCOUNT_BACK_IN_STOCK_NOTIFICATIONS_ITEM1 and ACCOUNT_BACK_IN_STOCK_NOTIFICATIONS_ITEM2 change:

<ceon:variable name="product_name">Product Number One</ceon:variable> 

to:

<a href="{ceon:product_info_page_link}"><ceon:variable name="product_name">Product Number One</ceon:variable> (<ceon:variable name="product_model">Product Model</ceon:variable>)</a> 

That's it! (You can opt not to use the brackets around the model, just remove them from the template code).

Easy with Ceon's template system! :)

Glad you like the software!

All the best..

Conor
ceon