get_row("SELECT * FROM `".$wpdb->prefix."wpsc_categorisation_groups` WHERE `active` IN ('1') AND `default` IN ('1') LIMIT 1 ",ARRAY_A); } else { $current_categorisation = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."wpsc_categorisation_groups` WHERE `active` IN ('1') AND `id` IN ('".(int)$_GET['category_group']."') LIMIT 1 ",ARRAY_A); } function admin_categorylist($curent_category) { global $wpdb; $options = ""; //$options .= "\r\n"; $values = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."product_categories` ORDER BY `id` ASC",ARRAY_A); foreach($values as $option) { if($curent_category == $option['id']) { $selected = "selected='selected'"; } $options .= "\r\n"; $selected = ""; } $concat .= "\r\n"; return $concat; } function display_categories($group_id, $id = null, $level = 0) { global $wpdb,$category_data; if(is_numeric($id)) { $category_sql = "SELECT * FROM `".$wpdb->prefix."product_categories` WHERE `group_id` IN ('$group_id') AND `active`='1' AND `category_parent` = '".$id."' ORDER BY `id`"; $category_list = $wpdb->get_results($category_sql,ARRAY_A); } else { $category_sql = "SELECT * FROM `".$wpdb->prefix."product_categories` WHERE `group_id` IN ('$group_id') AND `active`='1' AND `category_parent` = '0' ORDER BY `id`"; $category_list = $wpdb->get_results($category_sql,ARRAY_A); } if($category_list != null) { foreach($category_list as $category) { display_category_row($category, $level); display_categories($group_id, $category['id'], ($level+1)); } } } function display_category_row($category,$subcategory_level = 0) { echo " \n\r"; echo " \n\r"; if($subcategory_level > 0) { echo "

"; echo "

"; } echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; /* $displaydescription = substr(stripslashes($category['description']),0,44); if($displaydescription != $category['description']) { $displaydescription_arr = explode(" ",$displaydescription); $lastword = count($displaydescription_arr); if($lastword > 1) { unset($displaydescription_arr[$lastword-1]); $displaydescription = ''; $j = 0; foreach($displaydescription_arr as $displaydescription_row) { $j++; $displaydescription .= $displaydescription_row; if($j < $lastword -1) { $displaydescription .= " "; } } } $displaydescription .= "..."; } echo " \n\r"; */ echo " \n\r"; echo " \n\r"; echo "

\n\r"; if($category['image'] !=null) { echo "

"; } else { echo "

"; } echo "

\n\r"; echo "".htmlentities(stripslashes($category['name']), ENT_QUOTES, 'UTF-8')." (".$category['id'].")"; echo "

\n\r"; echo "".stripslashes($displaydescription).""; echo "

\n\r"; echo "".TXT_WPSC_EDIT.""; echo "

"; if($subcategory_level > 0) { echo "

"; } echo " \n\r"; echo " \n\r"; } if($_POST['submit_action'] == "add") { //exit("

".print_r($_POST,true)."

"); if(($_FILES['image'] != null) && preg_match("/\.(gif|jp(e)*g|png){1}$/i",$_FILES['image']['name'])) { if(function_exists("getimagesize")) { if(((int)$_POST['width'] > 10 && (int)$_POST['width'] < 512) && ((int)$_POST['height'] > 10 && (int)$_POST['height'] < 512) ) { $width = (int)$_POST['width']; $height = (int)$_POST['height']; image_processing($_FILES['image']['tmp_name'], (WPSC_CATEGORY_DIR.$_FILES['image']['name']), $width, $height); } else { image_processing($_FILES['image']['tmp_name'], (WPSC_CATEGORY_DIR.$_FILES['image']['name'])); } $image = $wpdb->escape($_FILES['image']['name']); } else { $new_image_path = (WPSC_CATEGORY_DIR.basename($_FILES['image']['name'])); move_uploaded_file($_FILES['image']['tmp_name'], $new_image_path); $stat = stat( dirname( $new_image_path )); $perms = $stat['mode'] & 0000666; @ chmod( $new_image_path, $perms ); $image = $wpdb->escape($_FILES['image']['name']); } } else { $image = ''; } if(is_numeric($_POST['category_parent'])) { $parent_category = (int)$_POST['category_parent']; } else { $parent_category = 0; } $tidied_name = trim($_POST['name']); $tidied_name = strtolower($tidied_name); $url_name = preg_replace(array("/(\s)+/","/[^\w-]+/"), array("-", ''), $tidied_name); $similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`nice-name`, '$url_name', '')) AS `max_number` FROM `".$wpdb->prefix."product_categories` WHERE `nice-name` REGEXP '^($url_name){1}(\d)*$' ",ARRAY_A); $extension_number = ''; if($similar_names['count'] > 0) { $extension_number = (int)$similar_names['max_number']+1; } $url_name .= $extension_number; switch($_POST['display_type']) { case "grid": $display_type = 'grid'; break; case "list": $display_type = 'list'; break; default: $display_type = 'default'; break; } if($_POST['product_height'] > 0) { $product_height = (int)$_POST['product_height']; } else { $product_height = ''; } if($_POST['product_width'] > 0) { $product_width = (int)$_POST['product_width']; } else { $product_width = ''; } if(trim($_POST['name']) != null) { $insertsql = "INSERT INTO `".$wpdb->prefix."product_categories` (`group_id`, `name` , `nice-name` , `description`, `image`, `fee` , `active`, `category_parent`, `order` ) VALUES ( '".(int)$_POST['categorisation_group']."', '".$wpdb->escape(stripslashes($_POST['name']))."', '".$url_name."', '".$wpdb->escape(stripslashes($_POST['description']))."', '$image', '0', '1' ,'$parent_category', '0')"; $wp_rewrite->flush_rules(); if($wpdb->query($insertsql)) { echo "

".TXT_WPSC_ITEMHASBEENADDED."

"; } else { echo "

".TXT_WPSC_ITEMHASNOTBEENADDED."

"; } $wp_rewrite->flush_rules(); } else { echo "

".TXT_WPSC_ITEMHASNOTBEENADDED."

"; } } if(($_POST['submit_action'] == "edit") && is_numeric($_POST['prodid'])) { if(($_FILES['image'] != null) && preg_match("/\.(gif|jp(e)*g|png){1}$/i",$_FILES['image']['name'])) { if(function_exists("getimagesize")) { if(((int)$_POST['width'] >= 10 && (int)$_POST['width'] <= 512) && ((int)$_POST['height'] >= 10 && (int)$_POST['height'] <= 512) ) { $height = (int)$_POST['width']; $height = (int)$_POST['height']; image_processing($_FILES['image']['tmp_name'], (WPSC_CATEGORY_DIR.$_FILES['image']['name']), $width, $height); } else { image_processing($_FILES['image']['tmp_name'], (WPSC_CATEGORY_DIR.$_FILES['image']['name'])); } $image = $wpdb->escape($_FILES['image']['name']); } else { move_uploaded_file($_FILES['image']['tmp_name'], (WPSC_CATEGORY_DIR.$_FILES['image']['name'])); $image = $wpdb->escape($_FILES['image']['name']); } } else { $image = ''; } if(is_numeric($_POST['height']) && is_numeric($_POST['width']) && ($image == null)) { $imagesql = "SELECT `image` FROM `".$wpdb->prefix."product_categories` WHERE `id`=".(int)$_POST['prodid']." LIMIT 1"; $imagedata = $wpdb->get_results($imagesql,ARRAY_A); if($imagedata[0]['image'] != null) { $height = $_POST['height']; $width = $_POST['width']; $imagepath = WPSC_CATEGORY_DIR . $imagedata[0]['image']; $image_output = WPSC_CATEGORY_DIR . $imagedata[0]['image']; image_processing($imagepath, $image_output, $width, $height); } } $category_data = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."product_categories` WHERE `id` IN ('".(int)$_POST['prodid']."')", ARRAY_A); if(($_POST['title'] != $category_data['name']) && (trim($_POST['title']) != null)) { $category_name = $_POST['title']; $category_sql_list[] = "`name` = '$category_name' "; /* creates and checks the tidy URL name */ $tidied_name = trim($category_name); $tidied_name = strtolower($tidied_name); $url_name = preg_replace(array("/(\s)+/","/[^\w-]+/"), array("-", ''), $tidied_name); if($url_name != $category_data['nice-name']) { $similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`nice-name`, '$url_name', '')) AS `max_number` FROM `".$wpdb->prefix."product_categories` WHERE `nice-name` REGEXP '^($url_name){1}(0-9)*$' AND `id` NOT IN ('".(int)$category_data['id']."') ",ARRAY_A); //exit("

".print_r($similar_names,true)."

"); $extension_number = ''; if($similar_names['count'] > 0) { $extension_number = (int)$similar_names['max_number']+1; } $url_name .= $extension_number; } /* checks again, just in case */ if($url_name != $category_data['nice-name']) { $category_sql_list[] = "`nice-name` = '$url_name' "; } $wp_rewrite->flush_rules(); } if($_POST['description'] != $category_data['description']) { $description = $_POST['description']; $category_sql_list[] = "`description` = '$description' "; } if(is_numeric($_POST['category_parent']) and ($_POST['category_parent'] != $category_data['category_parent'])) { $parent_category = (int)$_POST['category_parent']; $category_sql_list[] = "`category_parent` = '$parent_category' "; } if($_POST['deleteimage'] == 1) { $category_sql_list[] = "`image` = ''"; } else { if($image != null) { $category_sql_list[] = "`image` = '$image'"; } } if($_POST['display_type'] != $category_data['display_type']) { switch($_POST['display_type']) { case "grid": $display_type = 'grid'; break; case "list": $display_type = 'list'; break; default: $display_type = 'default'; break; } $category_sql_list[] = "`display_type` = '$display_type' "; } //echo "

".print_r($category_sql_list,true)."

"; if($_POST['product_height'] > 0) { $product_height = (int)$_POST['product_height']; } else { $product_height = ''; } $category_sql_list[] = "`image_height` = '$product_height' "; if($_POST['product_width'] > 0) { $product_width = (int)$_POST['product_width']; } else { $product_width = ''; } $category_sql_list[] = "`image_width` = '$product_height' "; if(count($category_sql_list) > 0) { $category_sql = implode(", ",$category_sql_list); $wpdb->query("UPDATE `".$wpdb->prefix."product_categories` SET $category_sql WHERE `id`='".(int)$_POST['prodid']."' LIMIT 1"); $wp_rewrite->flush_rules(); } echo "

".TXT_WPSC_CATEGORYHASBEENEDITED."

"; } if($_POST['submit_action'] == "add_categorisation") { $wpdb->query("INSERT INTO `{$wpdb->prefix}wpsc_categorisation_groups` ( `name`, `description`, `active`, `default`) VALUES ( '".$wpdb->escape(stripslashes($_POST['name']))."', '".$wpdb->escape(stripslashes($_POST['description']))."', '1', '0')"); echo "

".TXT_WPSC_CATEGORISATIONHASBEENADDED."

"; } if($_POST['submit_action'] == "edit_categorisation") { $edit_group_id = $_POST['group_id']; $wpdb->query("UPDATE `{$wpdb->prefix}wpsc_categorisation_groups` SET `name` = '".$wpdb->escape(stripslashes($_POST['name']))."', `description` = '".$wpdb->escape(stripslashes($_POST['description']))."' WHERE `id` IN('$edit_group_id') LIMIT 1 "); echo "

".TXT_WPSC_CATEGORISATIONHASBEENEDITED."

"; if(!is_numeric($_GET['category_group']) || ((int)$_GET['category_group'] == null)) { $current_categorisation = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."wpsc_categorisation_groups` WHERE `active` IN ('1') AND `default` IN ('1') LIMIT 1 ",ARRAY_A); } else { $current_categorisation = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."wpsc_categorisation_groups` WHERE `active` IN ('1') AND `id` IN ('".(int)$_GET['category_group']."') LIMIT 1 ",ARRAY_A); } } if(is_numeric($_GET['category_delete_id'])) { $delete_id = (int)$_GET['category_delete_id']; $deletesql = "UPDATE `".$wpdb->prefix."wpsc_categorisation_groups` SET `active` = '0' WHERE `id`='{$delete_id}' AND `default` IN ('0') LIMIT 1"; $wpdb->query($deletesql); $delete_subcat_sql = "UPDATE `".$wpdb->prefix."product_categories` SET `active` = '0', `nice-name` = '' WHERE `group_id`='{$delete_id}'"; $wpdb->query($delete_subcat_sql); $wp_rewrite->flush_rules(); } if(is_numeric($_GET['deleteid'])) { $delete_id = (int)$_GET['deleteid']; $deletesql = "UPDATE `".$wpdb->prefix."product_categories` SET `active` = '0', `nice-name` = '' WHERE `id`='{$delete_id}' LIMIT 1"; if($wpdb->query($deletesql)) { $delete_subcat_sql = "UPDATE `".$wpdb->prefix."product_categories` SET `active` = '0', `nice-name` = '' WHERE `category_parent`='{$delete_id}'"; $wpdb->query($delete_subcat_sql); // if this is the default category, we need to find a new default category if($delete_id == get_option('wpsc_default_category')) { // select the category that is not deleted with the greatest number of products in it $new_default = $wpdb->get_var("SELECT `cat`.`id` FROM `{$wpdb->prefix}product_categories` AS `cat` LEFT JOIN `{$wpdb->prefix}item_category_associations` AS `assoc` ON `cat`.`id` = `assoc`.`category_id` WHERE `cat`.`active` IN ( '1' ) GROUP BY `cat`.`id` ORDER BY COUNT( `assoc`.`id` ) DESC LIMIT 1"); if($new_default > 0) { update_option('wpsc_default_category', $new_default); } } $wp_rewrite->flush_rules(); } } ?>

"; } ?>

"; } else { echo "

"; } ?>

\n\r"; echo " \n\r"; if (function_exists('add_object_page')){ echo "

"; echo "

".ucfirst(TXT_WPSC_GROUPCOUNT_PLURAL)."

"; echo "

"; } //echo "

". TXT_WPSC_ADDNEWCATEGORY."".str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_MANAGE_CATEGORISATION)." [".TXT_WPSC_EDIT."]

"; echo " \n\r"; if (function_exists('add_object_page')) { echo ""; } else { echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; } echo " \n\r"; echo " \n\r"; echo " \n\r"; display_categories($current_categorisation['id']); if (function_exists('add_object_page')){ echo "

\n\r"; echo TXT_WPSC_IMAGE; echo "	\n\r"; echo TXT_WPSC_NAME; echo "	\n\r"; //echo TXT_WPSC_DESCRIPTION; echo "	\n\r"; echo TXT_WPSC_EDIT; echo "
\n\r"; echo " "; echo str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_EDITING_GROUP); echo " [ ".TXT_WPSC_EDIT_THIS_GROUP." ]"; echo " "; echo "". TXT_WPSC_ADDNEWCATEGORY.""; echo "

"; echo "

"; //class inside ends echo "

"; //class postbox ends } else { echo "\n\r"; } echo " \n\r"; echo "

"; echo "\n\r"; echo "

\n\r"; ?> "; echo "

".str_replace("[categorisation]", $current_categorisation['name'], TXT_WPSC_ADDING_TO_GROUP)."

"; echo "

"; } else { echo "

"; echo "

".TXT_WPSC_ADDDETAILS."

"; } ?>

\n\r"; echo " \n\r"; if (function_exists('add_object_page')) { echo "

"; } ?>