";
// get structure
$sql = "SELECT * FROM structure";
$query = mysql_query($sql);
$structure = array();
while($obj = mysql_fetch_object($query)) {
$structure[$obj->old_id] = $obj->id;
}
echo "get import
";
// get imports
$sql = "SELECT * FROM itemgroup_import";
$query = mysql_query($sql);
$imports = array();
while($obj = mysql_fetch_object($query)) {
$imports[] = $obj;
}
echo "imports
";
foreach ($imports as $import) {
//$sql = "UPDATE items SET structure_id='".$structure[$import->group_id]."' WHERE id=".$import->item_id;
$sql = "INSERT INTO item_structure_assign SET structure_id='".$structure[$import->group_id]."', item_id=".$import->item_id;
$query = mysql_query($sql);
if (!$query) {
echo $sql;
echo "
";
}
}