} $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);