public function productscategoriesAction() { $products = new Model_Products(); $product_id = $this->_getParam('ProductID'); if ($_POST) { $data = $_POST; $data['Created'] = date('Y-m-d H:i:s'); $data['LastEdited'] = date('Y-m-d H:i:s'); $products->oldSkul("delete from ProductCategory where ProductID=" . $product_id, false); unset($data['CategoryID']); foreach ($_POST['CategoryID'] as $category) { $parent_child = explode('-', $category); $ParentID = isset($parent_child[0]) ? $parent_child[0] : '0'; $SubParentID = isset($parent_child[1]) ? $parent_child[1] : '0'; $ChildID = isset($parent_child[2]) ? $parent_child[2] : '0'; if ($ChildID != '0') { $data['CategoryID'] = $ChildID; } else { if ($SubParentID != '0') { $data['CategoryID'] = $SubParentID; } else { $data['CategoryID'] = $ParentID; } } $data['TreeID'] = $category; $products->insertData('ProductCategory', $data); } $this->_redirect('/admin/productsdisplay/pid/' . $product_id); } }