iiid == NULL) {
$sql = "
UPDATE items
SET inventory=0
WHERE id=".$obj->id;
echo $sql;echo "
";
$query = mysql_query($sql);
}
}
echo "ende";
/*
echo "get items
";
$sql = "SELECT id, parent_id FROM items";
$query = mysql_query($sql);
$item_ids = array();
$parent_ids = array();
while($obj = mysql_fetch_object($query)) {
$manufacturers[$obj->name] = $obj->id;
$item_ids[] = $obj->id;
$parent_ids['p'.$obj->parent_id] = 1;
}
echo "update items
";
foreach ($item_ids as $item_id) {
if (!isset($parent_ids['p'.$item_id])) {
$sql = "
UPDATE items
SET schema_id=0
WHERE id=".$item_id.' AND parent_id = 0';
echo $sql;echo "
";
$query = mysql_query($sql);
}
}
*/
?>