/** * [set_product_to_category_oxid description] * @param [type] $product [description] */ private function set_product_to_category_oxid($product) { global $oxid, $selectline; $array = array('OXID' => substr(md5(uniqid('', true) . '|' . microtime()), 0, 32), 'OXOBJECTID' => $product->ART_ID, 'OXCATNID' => Categories::get_category_id_from_number($product->Artikelgruppe), 'OXPOS' => 0, 'OXTIME' => 0); $category_object_exsits = $oxid['db']->get_var("SELECT OXID FROM " . $oxid['table_product_to_category'] . " WHERE OXOBJECTID = '" . $product->ART_ID . "' AND OXCATNID = '" . Categories::get_category_id_from_number($product->Artikelgruppe) . "' "); if ($category_object_exsits) { unset($array['OXID']); $oxid['db']->query($this->format_update_query($oxid['table_product_to_category'], $array, array('OXID' => $category_object_exsits))); } else { $oxid['db']->query($this->format_insert_query($oxid['table_product_to_category'], $array)); } }