}
$new_cells[$j++] = $cell;
}
$cells = $new_cells;
$cells = array_map("trim", $cells);
$cpath = preg_split('!\\s*>>+\\s*!', $cells[$column_names["categories_name"]]);
$categories_id = 0;
foreach ($cpath as $cat) {
if ($cat != '') {
$cat = substr($cat, 0, 32);
$cid = IXdb::read("SELECT c.categories_id FROM categories c,categories_description cd WHERE c.categories_id=cd.categories_id AND cd.categories_name='" . addslashes($cat) . "' AND c.parent_id='{$categories_id}' AND cd.language_id='{$languages_id}'", NULL, 'categories_id');
if ($cid) {
$categories_id = $cid;
} else {
$categories_id = IXdb::store('INSERT', 'categories', array('parent_id' => $categories_id));
IXdb::store('INSERT', 'categories_description', array('categories_id' => $categories_id, 'categories_name' => $cat, 'language_id' => $languages_id));
}
}
}
/*
$query = 'SELECT categories_id, categories_name FROM categories_description WHERE categories_name="'.$cells[$column_names["categories_name"]].'"';
$result = tep_db_query ($query);
if (tep_db_num_rows($result))
{
$row = tep_db_fetch_array($result);
$categories_id = $row["categories_id"];
}
else
{
$query ='INSERT INTO categories SET categories_id=""';
$result = tep_db_query ($query);
