Will

<?php

include_once('wpcm-options.php');

if( ! class_exists('wpcm_functions')) :

class wpcm_functions
{
        public static function remove_category($postId, $categoryId)
        {
                global $wpdb;
                $wpdb->show_errors();
                $queryStr = "DELETE FROM $wpdb->term_relationships
                          where object_id = $postId and term_taxonomy_id= $categoryId";

                $wpdb->query($queryStr);
        }

       
        public static function get_posts($category, $page)
        {
                global $wpdb;
                $wpdb->show_errors();

                // First figure out how many posts to show per page. This will be your limit
                $pageSize = wpcm_options::get_option('postsperpage');

                $finalQueryLine = '';

                if($pageSize != -1)
                {
                        // Next figure out how many posts to skip. This will be your offset
                        $offset = $pageSize * $page;

                        $finalQueryLine = "limit " . $pageSize . "offset " . $offset;

                }

                $querystr = "select wposts.*,wp_term_taxonomy.term_taxonomy_id
                                 from $wpdb->posts wposts
                                  LEFT JOIN $wpdb->term_relationships wp_term_relationships ON wposts.ID = wp_term_relationships.object_id
                                  LEFT JOIN $wpdb->term_taxonomy wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
                                  LEFT JOIN $wpdb->terms wp_terms ON wp_terms.term_id = wp_term_taxonomy.term_id
                                                WHERE wp_term_taxonomy.taxonomy = 'category'
                                                                and wp_terms.name = '" . $category . "'
                                                                and wposts.post_status='publish'
                                        ORDER BY wposts.ID " . $finalQueryLine;
                 $postlist = $wpdb->get_results($querystr);
                 return $postlist;
        }

        public static function get_postCount($category)
        {
                global $wpdb;
                $wpdb->show_errors();
              
                $querystr = "select count(*)
                                 from $wpdb->posts wposts
                                  LEFT JOIN $wpdb->term_relationships wp_term_relationships ON wposts.ID = wp_term_relationships.object_id
                                  LEFT JOIN $wpdb->term_taxonomy wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
                                  LEFT JOIN $wpdb->terms wp_terms ON wp_terms.term_id = wp_term_taxonomy.term_id
                                                WHERE wp_term_taxonomy.taxonomy = 'category'
                                                                and wp_terms.name = '" . $category . "'
                                                                and wposts.post_status='publish'";

                $result = $wpdb->get_var($querystr, 0, 0);
                return $result;

        }

        public static function render_posts($postlist)
        {
                if($postlist)
                {
                         foreach($postlist as $post)
                         {
                                echo '<div>';
                                echo '<span ><a href="'. get_permalink($post->ID) .'"title="'.$post->post_title . '">' . $post->post_title . '</a></span><span >' . date_format(date_create($post->post_date), "F j,Y") . '</span>';
                                echo '<p ><a href="javascript:void(0);"postID="'.$post->ID.'"catID="'. $post->term_taxonomy_id  .'"title="Remove post from this category">Remove</a>| ';
                                echo edit_post_link('Edit Post', '', '', $post->ID);
                                echo '</p></div>';
                         }
                }
                else
                {
                        echo '<strong>No posts found</strong>';
                }
        }

        public static function render_postcount($category)
        {
                $count = wpcm_functions::get_postCount($category);

                echo '<span>'.$count.'</span>';
        }

        public static function get_categories()
        {
                global $wpdb;

                $wpdb->show_errors();

                $querystr = "select wt.name,wt.term_id
                                          from $wpdb->terms wt
                                          join $wpdb->term_taxonomy wtt on wtt.term_id = wt.term_id
                                          where wtt.taxonomy = 'category'
                                          order by wt.name";
                $catlist = $wpdb->get_results($querystr);
                return $catlist;
        }
}
endif;

?>