Need code to check if sale is active

[kwright]

Greetings all,

I would like to display content base on if a salemaker sale is active.

Is there a function I can call that will return a T/F value I can test?

Any suggestions?

Thanks!

[DrByte]

Is your question whether "any" sale is active?
Or is it whether a "specific" sale is active? And if so, how do you intend to identify which "specific" sale?

[kwright]

Thanks for the reply DrByte,

Since we only do a single "All Item" sale at a time, any sale detection would work.

As a test, I just wrapped my items to display around the following code. It seems to work, but makes a db call:

$sale = $db->Execute("select sale_status from " . TABLE_SALEMAKER_SALES . " where sale_status = '1' and sale_categories_all != '' and sale_date_start <= now() and sale_date_end >= now()");
    if ($sale->RecordCount() >= 1) {

echo "Stuff to Display";

} 

BTW, the stuff I want to display is in the cart sidebox if that makes a difference!