insert($wpdb->prefix . 'tag_category_mapping', array('tag_name' => sanitize_text_field($tag_name), 'category_list' => sanitize_text_field($serialized_Array)), array('%s', '%s')); } } function auto_apc_delete_tag(){ // only if numeric values // Validate user role/permissions if (!current_user_can('manage_options')) { wp_die(__('You do not have sufficient permissions to access this page.')); } if (isset($_REQUEST['deleteval']) && is_numeric($_REQUEST['deleteval'])) { $id = $_REQUEST['deleteval']; if (!isset($wpdb)) $wpdb = $GLOBALS['wpdb']; $auto_apc_table_name = $wpdb->prefix . 'tag_category_mapping'; $wpdb->query("DELETE FROM $auto_apc_table_name WHERE ID = $id "); } } function auto_apc_add_category($post_id = 0) { if (!$post_id) return; if (!isset($wpdb)) $wpdb = $GLOBALS['wpdb']; $all_tags = $wpdb->get_results("SELECT id, tag_name, category_list FROM " . $wpdb->prefix . "tag_category_mapping"); $catArray = array(); $finalArray = array(); $post_tags = wp_get_post_tags($post_id, array('fields' => 'names')); foreach ($all_tags as $tag) { if ($tag->tag_name && auto_apc_in_arrayi($tag->tag_name, $post_tags)) { $catArray = unserialize($tag->category_list); $finalArray = array_merge($finalArray, $catArray); wp_set_post_categories($post_id, $finalArray, $append = false); } } } add_action('publish_post', 'auto_apc_add_category'); // function auto_apc_admin_menu() { add_menu_page('Auto Category Tag', 'Auto Category Tag', 'manage_options', 'category-mapping', 'auto_apc_menu_plugin_options'); } // add_action('admin_menu', 'auto_apc_admin_menu'); // function auto_apc_add_submenu_page() { add_submenu_page( 'category-mapping', 'Assign New', 'Assign New', 'manage_options', 'mapnew_categories', 'auto_apc_add_options_function' ); } add_action('admin_menu', 'auto_apc_add_submenu_page'); function auto_apc_add_options_function() { // Validate user role/permissions if (!current_user_can('manage_options')) { wp_die(__('You do not have sufficient permissions to access this page.')); } ?>

0, 'hide_empty' => 0)); $select_cats = str_replace('id=', 'multiple="multiple" required id=', $select_cats); $select_cats = preg_replace('/\bcat\b/', 'cat[]', $select_cats); echo $select_cats; ?>

get_results("SELECT id, tag_name, category_list FROM " . $wpdb->prefix . "tag_category_mapping"); foreach ($all_tags as $tag) { $cat_string = ''; ?> category_list); ?>
tag_name); ?>
prefix . 'tag_category_mapping'; if ($wpdb->get_var("show tables like '$auto_apc_table_name'") != $auto_apc_table_name) { $sql = "CREATE TABLE " . $auto_apc_table_name . " ( id INT NOT NULL AUTO_INCREMENT, tag_name TEXT NOT NULL, category_list TEXT NOT NULL, PRIMARY KEY (id) );"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); } } register_activation_hook(__FILE__, 'auto_apc_plugin_options_install'); // Plugin deactivation hook function auto_apc_hook_uninstall() { if (!isset($wpdb)) $wpdb = $GLOBALS['wpdb']; $auto_apc_table_name = $wpdb->prefix . 'tag_category_mapping'; $wpdb->query("DROP TABLE IF EXISTS $auto_apc_table_name"); } register_uninstall_hook(__FILE__, 'auto_apc_hook_uninstall'); ?>