";
// get items
$query = mysql_query('select import_item_prices.*, items.id as item_id from import_item_prices left join items on items.old_id=import_item_prices.pid order by pid, menge asc') or die("Anfrage nicht erfolgreich");
$data = array();
while($obj = mysql_fetch_object($query)) {
$data[] = $obj;
}
echo "imports
";
$merker = array();
foreach ($data as $object) {
$customer_group = 1;
if ($object->uid == 6) {
$customer_group = 101;
}
if ($object->menge != 1) {
$merker[$object->item_id]++;
$staffel = $merker[$object->item_id] + 1;
$sql = "
UPDATE item_prices
SET
quantity_".$staffel."=".$object->menge.",
price_".$staffel."='".mysql_real_escape_string(price($object->preis))."',
bargain_price_".$staffel."='0'
WHERE
item_id=".$object->item_id." AND customergroup_id=".$customer_group."
";
}
echo $sql."
";
$query = mysql_query($sql);
}
echo "ende
";
function price ($p) {
$p = str_replace(',', '.', $p);
return $p;
}
?>