function init_categories_data() { $all_cats = GDSRDatabase::get_all_categories(); $categories = GDSRHelper::get_categories_hierarchy($all_cats); $ids_array = $items = array(); foreach ($categories as $cat) { $items[$cat->term_id] = $cat->parent; $ids_array[] = $cat->term_id; } GDSRDatabase::add_category_defaults("(" . join(", ", $ids_array) . ")", $ids_array, $items); }
function update_category_settings($ids, $upd_am, $upd_ar, $upd_cm, $upd_cr, $ids_array) { global $wpdb, $table_prefix; GDSRDatabase::add_category_defaults($ids, $ids_array); $dbt_data_cats = $table_prefix . 'gdsr_data_category'; $update = array(); if ($upd_am != '') { $update[] = "moderate_articles = '" . $upd_am . "'"; } if ($upd_cm != '') { $update[] = "moderate_comments = '" . $upd_cm . "'"; } if ($upd_ar != '') { $update[] = "rules_articles = '" . $upd_ar . "'"; } if ($upd_cr != '') { $update[] = "rules_comments = '" . $upd_cr . "'"; } if (count($update) > 0) { $updstring = join(", ", $update); $sql = sprintf("update %s set %s where category_id in %s", $dbt_data_cats, $updstring, $ids); $wpdb->query($sql); } }