how to prevent disc couon from applying items on special?

[gsdcypher]

hi all,

how do you set the restriction on discount coupons to prevent a disc from applying to items that are on special?

thanks.

[gsdcypher]

found in another thread - thanks to tj1 and ajeh

Add the following code just before the line that reads
// modified to manage restrictions better - leave commented for now
PHP Code:
//check for specials
$specials_query = "SELECT * FROM " . TABLE_SPECIALS . "
WHERE products_id = '" . (int)$product_id . "'";

$specials = $db->Execute($specials_query);

if ($specials->fields['status'] == 1) {
return false;
}
//end specials check