get_var($wpdb->prepare("SELECT COUNT(id) FROM `" . $this->tbl_social_posts . "`")); $social_types = array( "tw" => "Twitter", "fb" => "Facebook", "ln" => "LinkedIn", ); $current_page = isset($_GET['paged']) && is_numeric($_GET['paged']) ? $_GET['paged'] : 1; $pages_count = $posts_count/20 > intval($posts_count/20) ? intval($posts_count/20) + 1 : intval($posts_count/20); $social_posts = $wpdb->get_results("SELECT id, title, network, state, status, date_format(scheduled_time,'%Y/%m/%d %r') as scheduled_time, date_format(published_time, '%Y/%m/%d %r') as published_time FROM `" . $this->tbl_social_posts . "` order by id desc limit 20 offset ".(($current_page-1)*20), ARRAY_A); $action_url = substr($_SERVER['REQUEST_URI'],0,strpos($_SERVER['REQUEST_URI'],"social_posts")+12)."&paged="; $next_page = $current_page < $pages_count ? $current_page + 1 : null; $prev_page = $current_page > 1 ? $current_page - 1 : null; ?>

Social Posts


items " title="Go to the first page" href="">« " title="Go to the previous page" href="">‹ of " title="Go to the next page" href="">› " title="Go to the last page" href="">»
Title Network Status Date
Share Already shared
OK FAILED SCHEDULED ">