public static function init_categories_actions()
{
global $wpdb;
$cat_msg = '';
if (isset($_REQUEST['bt_save_cat'])) {
$category_name = trim(strip_tags(addslashes($_REQUEST['category_name'])));
if (isset($_REQUEST['category_id']) && $_REQUEST['category_id'] > 0) {
$old_data = WC_Compare_Categories_Data::get_row($_REQUEST['category_id']);
$count_category_name = WC_Compare_Categories_Data::get_count("category_name = '" . $category_name . "' AND id != '" . $_REQUEST['category_id'] . "'");
if ($category_name != '' && $count_category_name == 0) {
$result = WC_Compare_Categories_Data::update_row($_REQUEST);
$wpdb->query('UPDATE ' . $wpdb->prefix . 'postmeta SET meta_value="' . $category_name . '" WHERE meta_value="' . $old_data->category_name . '" AND meta_key="_wpsc_compare_category_name" ');
$cat_msg = '<div class="updated below-h2" id="result_msg"><p>' . __('Compare Category Successfully edited', 'woo_cp') . '.</p></div>';
} else {
$cat_msg = '<div class="error below-h2" id="result_msg"><p>' . __('Nothing edited! You already have a Compare Category with that name. Use unique names to edit each Compare Category.', 'woo_cp') . '</p></div>';
}
} else {
$count_category_name = WC_Compare_Categories_Data::get_count("category_name = '" . $category_name . "'");
if ($category_name != '' && $count_category_name == 0) {
$category_id = WC_Compare_Categories_Data::insert_row($_REQUEST);
if ($category_id > 0) {
$cat_msg = '<div class="updated below-h2" id="result_msg"><p>' . __('Compare Category Successfully created', 'woo_cp') . '.</p></div>';
} else {
$cat_msg = '<div class="error below-h2" id="result_msg"><p>' . __('Compare Category Error created', 'woo_cp') . '.</p></div>';
}
} else {
$cat_msg = '<div class="error below-h2" id="result_msg"><p>' . __('Nothing created! You already have a Compare Category with that name. Use unique names to create each Compare Category.', 'woo_cp') . '</p></div>';
}
}
}
if (isset($_REQUEST['act']) && $_REQUEST['act'] == 'cat-delete') {
$category_id = trim($_REQUEST['category_id']);
WC_Compare_Categories_Data::delete_row($category_id);
WC_Compare_Categories_Fields_Data::delete_row("cat_id='" . $category_id . "'");
$cat_msg = '<div class="updated below-h2" id="result_msg"><p>' . __('Compare Category deleted', 'woo_cp') . '.</p></div>';
}
return $cat_msg;
}
public static function delete_rows($items = array())
{
if (is_array($items) && count($items) > 0) {
foreach ($items as $category_id) {
WC_Compare_Categories_Data::delete_row($category_id);
}
}
}
