Thanks for the report.
Code:
function updatePrices($element,$status){
$filters=array('price_product_id='.$status);
if(count($element->prices)){
$ids = array();
foreach($element->prices as $price){
if(!empty($price->price_id) && !empty($price->price_value)) $ids[] = $price->price_id;
}
if(!empty($ids)){
$filters[]= 'price_id NOT IN ('.implode(',',$ids).')';
}
}
$query = 'DELETE FROM '.hikashop_table('price').' WHERE '.implode(' AND ',$filters);
$this->database->setQuery($query);
$this->database->query();
if(count($element->prices)){
$insert = array();
foreach($element->prices as $price){
if((int)$price->price_currency_id == 0)
$price->price_currency_id = hikashop_getCurrency();
if(empty($price->price_value)) continue;
if(empty($price->price_id)) $price->price_id = 'NULL';
$line = '('.(int)$price->price_currency_id.','.$status.','.(int)$price->price_min_quantity.','.(float)$price->price_value.','.$price->price_id.','.$this->database->Quote(@$price->price_site_id);
if(hikashop_level(2)){
if(empty($price->price_access)){
$price->price_access = 'all';
}
$line.=','.$this->database->Quote($price->price_access);
}
$insert[]=$line.')';
}
if(!empty($insert)){
$select = 'price_currency_id,price_product_id,price_min_quantity,price_value,price_id,price_site_id';
if(hikashop_level(2)){
$select.=',price_access';
}
$query = 'REPLACE '.hikashop_table('price').' ('.$select.') VALUES '.implode(',',$insert).';';
$this->database->setQuery($query);
$this->database->query();
}
}
}
