id , array('advertiser', 'campaign', 'ads_banner' , 'zone'))) return; global $menu; foreach($menu as $order => $m){ if($m[2] == 'edit.php?post_type=zone'){ $menu[$order][4] .= ' wp-has-current-submenu '; break; } } } add_action('admin_menu','aas_admin_menu'); add_action('load-post.php', 'set_aas_admin_menu_class'); add_action('load-post-new.php', 'set_aas_admin_menu_class'); //Necessary scripts for backend function add_aas_script(){ wp_enqueue_style( 'datetimepicker', AAS_PLUGIN_URL . 'js/datetimepicker-master/jquery.datetimepicker.css' ); wp_enqueue_style( 'chosen', AAS_PLUGIN_URL . 'js/chosen/chosen.min.css' ); wp_enqueue_script('my_validate', AAS_PLUGIN_URL . 'js/validator/jquery.validate.min.js', array('jquery')); wp_enqueue_script('datetimepicker', AAS_PLUGIN_URL . 'js/datetimepicker-master/jquery.datetimepicker.js', array('jquery')); wp_enqueue_script('chosen', AAS_PLUGIN_URL . 'js/chosen/chosen.jquery.min.js', array('jquery')); ?> query("CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}". AAS_Log::$log_table_name ."` ( `logged_id` BIGINT NOT NULL AUTO_INCREMENT, `ip_address` VARCHAR(255) NOT NULL, `browser` VARCHAR(255) NOT NULL, `device` VARCHAR(255) NOT NULL, `type` VARCHAR(1) NOT NULL, `zone_id` INT NOT NULL, `cam_id` INT NOT NULL, `banner_id` INT NOT NULL, `adv_id` INT NOT NULL, `net_price` FLOAT NOT NULL, `time` DATETIME NOT NULL, PRIMARY KEY (`logged_id`) ) ENGINE = myisam;"); } register_activation_hook( __FILE__, 'create_aas_ads_log_table' ); function aas_column_orderby( $query ) { if( ! is_admin() ) return; if(!in_array($query->get('post_type'),array('ads_banner','advertiser','campaign','zone'))) return; $orderby = $query->get( 'orderby'); if( 'click' == $orderby ) { $query->set('meta_key','_total_click'); $query->set('orderby','meta_value_num'); } elseif('impression' == $orderby){ $query->set('meta_key','_total_view'); $query->set('orderby','meta_value_num'); } elseif('payment' == $orderby){ $query->set('meta_key','_total_payment'); $query->set('orderby','meta_value_num'); } elseif('priority' == $orderby){ $query->set('meta_key','priority'); $query->set('orderby','meta_value_num'); } elseif('ctr' == $orderby){ $query->set('meta_key','_ctr'); $query->set('orderby','meta_value_num'); } } add_action( 'pre_get_posts', 'aas_column_orderby' );