Free call for price V4.0 + OSCLoaded4... help please

[Guest]

Hi,

 

I am trying to add the free call for price addon to my site which is using OSCloaded4, with no further mods. Im having no luck whatsoever on this one.

 

Im running on a UNIX server.

 

Can anyone help me with this.

 

Thanks

Craig

[Guest]

My main problem is with the categories page. Is there anyone out there who has any knowledge on both OSCLoaded4 and Free Call for Prices add on?

 

Possibly Linda or Ian??

 

Thanks

Craig

[Ajeh]

It can be done ... but I don't have time right now to do it ... :shock:

 

Beyond Compare is your best bet at seeing the differences between the two.

 

I am re-doing the Free Call for Price to make it easier to use/install.

 

But I do not have a date on that yet for release.

[Guest]

Linda,

 

I have done as much as I can but am getting the following error message...any ideas?

 

1064 - You have an error in your SQL syntax near 'THE_NEW_PRODUCTS_FILTER order by p.products_date_added DESC limit 9' at line 1

 

select p.products_id, p.products_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id where products_status = '1' THE_NEW_PRODUCTS_FILTER order by p.products_date_added DESC limit 9

 

[TEP STOP]

[Ajeh]

The THE_NEW_PRODUCTS_FILTER is defined in:

 

/includes/languages/english/free_call_for_price.php in this section:

// NEW PRODUCT LABEL

define('SHOW_NEW_LABEL_ON','1');

// The first filter is used for multiple table selects and the second definition is used for single table selects.

define('THE_NEW_PRODUCTS_FILTER',"and date_format(p.products_date_added, '%Y%m') >= date_format(now(), '%Y%m')"); 

define('THE_NEW_PRODUCTS_FILTER2',"and date_format(products_date_added, '%Y%m') >= date_format(now(), '%Y%m')"); 

// above definitions replace old definition below

// define('SHOW_NEW_LABEL_FOR','2002-07-24 00:00:00'); // Year Month Date Time

define('NEW_PRODUCTS_IMAGE','smile_flash.gif');

 

Without that, it does not know what to do.

 

This is selecting the current month.

[Guest]

Thanks Linda.

 

Once again your advice is perfect.