i did that:
function getPrices(&$element,&$ids,$currency_id,$main_currency,$zone_id,$discount_before_tax){
$currency_ids = array($currency_id=>$currency_id,$main_currency=>$main_currency);
$filters=array('price_currency_id IN ('.implode(',',$this->publishedCurrencies()).')');
if(!empty($ids)){
$ids_string = '';
foreach($ids as $id){
if(!empty($id)) $ids_string.= (int)$id.',';
}
$ids_string=rtrim($ids_string,',');
if(!empty($ids_string)){
$filters[]= 'price_product_id IN ('.$ids_string.')';
}
and the new error wondow shos up like that:
500 - No valid database connection:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR discount_product_id=0 ) AND discount_zone_id IN (0,4503) AND ( discount_fla' at line 1 SQL=SELECT * FROM jos_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND ( discount_quota>discount_used_times OR discount_quota=0 ) AND discount_start < 1299064287 AND ( discount_end > 1299064287 OR discount_end = 0 ) AND ( discount_product_id IN () OR discount_product_id=0 ) AND discount_zone_id IN (0,4503) AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
You may not be able to visit this page because of:
1. an out-of-date bookmark/favourite
2. a search engine that has an out-of-date listing for this site
3. a mistyped address
4. you have no access to this page
5. The requested resource was not found.
6. An error has occurred while processing your request.
Please try one of the following pages:
* Home Page
If difficulties persist, please contact the System Administrator of this site.
No valid database connection:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR discount_product_id=0 ) AND discount_zone_id IN (0,4503) AND ( discount_fla' at line 1 SQL=SELECT * FROM jos_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND ( discount_quota>discount_used_times OR discount_quota=0 ) AND discount_start < 1299064287 AND ( discount_end > 1299064287 OR discount_end = 0 ) AND ( discount_product_id IN () OR discount_product_id=0 ) AND discount_zone_id IN (0,4503) AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )