Add Category

get_js_menu(0); IF(isset($_POST['Submit'])) { demoversion(); $times = 0; $parts = explode('/', $_POST['cat_mode']); $locale = $parts['0']; $mode = $parts['1']; IF(!isset($_POST['cat_node'])) { $_POST['cat_node'] = ''; } // Loop through text file (Use "|" to Delimit Fields) (Title|Parent|Node) $fp = @fopen($_POST['file_name'], "rb") or die("Couldn't open file"); $data = fread($fp, filesize($fp)); while(!feof($fp)) { $data = fgets($fp, 1024); //$values = explode("\r\n", $data); $values = explode("|", $data); $Title = $values[0]; $Parent = $values[1]; $Node = $values[2]; // Find Category Parent Id (category_pid) $query = "SELECT category_id FROM `amzs_categories` WHERE category_node='" . $Parent . "'"; $query_result = @mysql_query ($query); while ($info = @mysql_fetch_array($query_result)) { $new_parent = $info['category_id']; } // See if root if ($new_parent =='') { $new_parent = 0; } $query = "INSERT INTO `amzs_categories` ( `category_id` , `category_locale` , `category_pid` , `category_name` , `category_node` , `category_amzname` , `category_type` , `category_search` , `category_path` ) VALUES ('', '" . $locale . "', '" . $new_parent . "', '" . $Title . "', '" . $Node . "', '" . $mode . "', '" . $_POST['type'] . "', '', '0');"; mysql_query($query); $insert_id = mysql_insert_id(); IF($new_parent == 0) { $path = "0|" . $insert_id; } ELSE { $query = "SELECT category_path FROM `amzs_categories` WHERE category_id='" . $new_parent . "' LIMIT 1"; $query_result = @mysql_query ($query); while ($info = @mysql_fetch_array($query_result)) { $parent = $info['category_path']; } $path = $parent . "|" . $insert_id; } mysql_query("UPDATE `amzs_categories` SET `category_path` = '" . $path . "' WHERE `category_id` = '" . $insert_id . "' LIMIT 1 ;"); // loop until file finished } fclose($fp); log_action('Added Category'); transfer('cat_add_file.php','Added Categories'); exit; } ?> Add Category