get_var($wpdb->prepare("SHOW TABLES LIKE %s", $user_cats_table)) != $user_cats_table) { $query = sprintf(" CREATE TABLE %s ( user_id int(11) NOT NULL, term_id int(11) NOT NULL, PRIMARY KEY (user_id, term_id))", $user_cats_table ); echo $query; $wpdb->query($query); } } //a2c_check_table // administration panel function a2c_admin() { if (function_exists('add_management_page')) { add_management_page('Authors2Categories Options', 'Authors2Categories', 8, basename(__FILE__), 'authors2categories_admin_page'); } } function authors2categories_admin_page() { global $table_prefix, $user_cats_table, $wpdb; if (isset($_POST['edit_user'])) { } if (isset($_POST['save'])) { $valueString = "VALUES "; $query = sprintf("DELETE FROM %s WHERE user_id=%d",$user_cats_table,$_POST['user']); $wpdb->query($query); if (isset($_POST['categories']) && isset($_POST['user']) && count($_POST['categories']) > 0 ){ for ($i=0; $i < count($_POST['categories']); $i++){ $valueString = $valueString . "(" . $_POST['user'] . "," . $_POST['categories'][$i] . "),"; } $valueString = substr_replace($valueString,"",-1); /** $query = "INSERT INTO $user_cats_table (user_id, term_id) " . $valueString; mysql_query($query); **/ $query = sprintf("INSERT INTO %s (user_id, term_id) %s", $user_cats_table, $valueString); $wpdb->query($query); _e('Categories were added'); } } ?>

User Category Manager

Select the user

Editing User

Choose the categories that the user can use

get_results($query); foreach ($checkCategories as $checkCategory) { $selected[] = $checkCategory->term_id; } } else $userSelected = 1; $categoryRows = $wpdb->get_results("SELECT term_id, name FROM $wpdb->terms ORDER BY name"); foreach ($categoryRows as $categoryRow) { echo "term_id . "\" "; if (in_array($categoryRow->term_id, $selected)) echo "checked=\"checked\""; echo "/> " . $categoryRow->name . "
"; } ?>

ID; $selectedCategories=$wpdb->get_results("SELECT term_id FROM $user_cats_table WHERE user_id= $myID"); foreach ($selectedCategories as $selectedCategory){ $myCategories[] = $selectedCategory->term_id; } echo "\n"; } add_action('simple_edit_form', 'a2c_disable_cats'); add_action('edit_form_advanced', 'a2c_disable_cats'); add_action('admin_menu', 'a2c_admin'); ?>