EVOLUTION-MANAGER
Edit File: wordpress-popular-posts.php
<?php /* Plugin Name: WordPress Popular Posts Plugin URI: http://wordpress.org/extend/plugins/wordpress-popular-posts Description: WordPress Popular Posts is a highly customizable widget that displays the most popular posts on your blog Version: 3.3.4 Author: Hector Cabrera Author URI: http://cabrerahector.com Author Email: hcabrerab@gmail.com Text Domain: wordpress-popular-posts Domain Path: /lang/ Network: false License: GPLv2 or later License URI: http://www.gnu.org/licenses/gpl-2.0.html Copyright 2008-2015 Hector Cabrera (hcabrerab@gmail.com) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License, version 2, as published by the Free Software Foundation. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */ if ( !defined('ABSPATH') ) exit('Please do not load this file directly.'); /** * WordPress Popular Posts class. */ if ( !class_exists('WordpressPopularPosts') ) { /** * Register plugin's activation / deactivation functions * @since 1.3 */ register_activation_hook( __FILE__, array( 'WordpressPopularPosts', 'activate' ) ); register_deactivation_hook( __FILE__, array( 'WordpressPopularPosts', 'deactivate' ) ); /** * Add function to widgets_init that'll load WPP. * @since 2.0 */ function load_wpp() { register_widget( 'WordpressPopularPosts' ); } add_action( 'widgets_init', 'load_wpp' ); class WordpressPopularPosts extends WP_Widget { /** * Plugin version, used for cache-busting of style and script file references. * * @since 1.3.0 * @var string */ private $version = '3.3.4'; /** * Plugin identifier. * * @since 3.0.0 * @var string */ private $plugin_slug = 'wordpress-popular-posts'; /** * Instance of this class. * * @since 3.0.0 * @var object */ protected static $instance = NULL; /** * Slug of the plugin screen. * * @since 3.0.0 * @var string */ protected $plugin_screen_hook_suffix = NULL; /** * Flag for singular pages. * * @since 3.1.2 * @var int */ private $current_post_id = 0; /** * Plugin directory. * * @since 1.4.6 * @var string */ private $plugin_dir = ''; /** * Plugin uploads directory. * * @since 3.0.4 * @var array */ private $uploads_dir = array(); /** * Default thumbnail. * * @since 2.2.0 * @var string */ private $default_thumbnail = ''; /** * Default thumbnail sizes * * @since 3.2.2 * @var array */ private $default_thumbnail_sizes = array(); /** * Flag to verify if thumbnails can be created or not. * * @since 1.4.6 * @var bool */ private $thumbnailing = false; /** * Flag to verify if qTrans is present. * * @since 1.4.6 * @var bool */ private $qTrans = false; /** * Default charset. * * @since 2.1.4 * @var string */ private $charset = "UTF-8"; /** * Plugin defaults. * * @since 2.3.3 * @var array */ protected $defaults = array( 'title' => '', 'limit' => 10, 'range' => 'daily', 'freshness' => false, 'order_by' => 'views', 'post_type' => 'post,page', 'pid' => '', 'author' => '', 'cat' => '', 'shorten_title' => array( 'active' => false, 'length' => 25, 'words' => false ), 'post-excerpt' => array( 'active' => false, 'length' => 55, 'keep_format' => false, 'words' => false ), 'thumbnail' => array( 'active' => false, 'build' => 'manual', 'width' => 15, 'height' => 15, 'crop' => true ), 'rating' => false, 'stats_tag' => array( 'comment_count' => false, 'views' => true, 'author' => false, 'date' => array( 'active' => false, 'format' => 'F j, Y' ), 'category' => false ), 'markup' => array( 'custom_html' => false, 'wpp-start' => '<ul class="wpp-list">', 'wpp-end' => '</ul>', 'post-html' => '<li>{thumb} {title} {stats}</li>', 'post-start' => '<li>', 'post-end' => '</li>', 'title-start' => '<h2>', 'title-end' => '</h2>' ) ); /** * Admin page user settings defaults. * * @since 2.3.3 * @var array */ protected $default_user_settings = array( 'stats' => array( 'order_by' => 'views', 'limit' => 10, 'post_type' => 'post,page', 'freshness' => false ), 'tools' => array( 'ajax' => false, 'css' => true, 'link' => array( 'target' => '_self' ), 'thumbnail' => array( 'source' => 'featured', 'field' => '', 'resize' => false, 'default' => '', 'responsive' => false ), 'log' => array( 'level' => 1, 'limit' => 0, 'expires_after' => 180 ), 'cache' => array( 'active' => false, 'interval' => array( 'time' => 'hour', 'value' => 1 ) ), 'sampling' => array( 'active' => false, 'rate' => 100 ) ) ); /** * Admin page user settings. * * @since 2.3.3 * @var array */ private $user_settings = array(); /** * Bots list. * * @since 3.0.0 * @var array */ protected $botlist = array( 'bot', 'crawl', 'curl', 'facebookexternalhit', 'geturl', 'google', 'java', 'msn', 'perl', 'slurp', 'spider', 'sqworm', 'search', 'wget' ); /*--------------------------------------------------*/ /* Constructor /*--------------------------------------------------*/ /** * Initialize the widget by setting localization, filters, and administration functions. * * @since 1.0.0 */ public function __construct() { // Load plugin text domain add_action( 'init', array( $this, 'widget_textdomain' ) ); // Upgrade check add_action( 'init', array( $this, 'upgrade_check' ) ); // Check location on template redirect add_action( 'template_redirect', array( $this, 'is_single' ) ); // Hook fired when a new blog is activated on WP Multisite add_action( 'wpmu_new_blog', array( $this, 'activate_new_site' ) ); // Notices check add_action( 'admin_notices', array( $this, 'check_admin_notices' ) ); // Create the widget parent::__construct( 'wpp', 'WordPress Popular Posts', array( 'classname' => 'popular-posts', 'description' => __( 'The most Popular Posts on your blog.', $this->plugin_slug ) ) ); // Get user options $this->user_settings = get_site_option('wpp_settings_config'); if ( !$this->user_settings ) { add_site_option('wpp_settings_config', $this->default_user_settings); $this->user_settings = $this->default_user_settings; } else { $this->user_settings = $this->__merge_array_r( $this->default_user_settings, $this->user_settings ); } // Allow WP themers / coders to override data sampling status (active/inactive) $this->user_settings['tools']['sampling']['active'] = apply_filters( 'wpp_data_sampling', $this->user_settings['tools']['sampling']['active'] ); // Add the options page and menu item. add_action( 'admin_menu', array( $this, 'add_plugin_admin_menu' ) ); // Register admin styles and scripts add_action( 'admin_print_styles', array( $this, 'register_admin_styles' ) ); add_action( 'admin_enqueue_scripts', array( $this, 'register_admin_scripts' ) ); add_action( 'admin_init', array( $this, 'thickbox_setup' ) ); // Register site styles and scripts if ( $this->user_settings['tools']['css'] ) add_action( 'wp_enqueue_scripts', array( $this, 'register_widget_styles' ) ); add_action( 'wp_enqueue_scripts', array( $this, 'register_widget_scripts' ) ); // Add plugin settings link add_filter( 'plugin_action_links', array( $this, 'add_plugin_settings_link' ), 10, 2 ); // Set plugin directory $this->plugin_dir = plugin_dir_url(__FILE__); // Get blog charset $this->charset = get_bloginfo('charset'); // Add ajax table truncation to wp_ajax_ hook add_action('wp_ajax_wpp_clear_data', array( $this, 'clear_data' )); // Add thumbnail cache truncation to wp_ajax_ hook add_action('wp_ajax_wpp_clear_thumbnail', array( $this, 'clear_thumbnails' )); // Add ajax hook for widget add_action('wp_ajax_wpp_get_popular', array( $this, 'get_popular') ); add_action('wp_ajax_nopriv_wpp_get_popular', array( $this, 'get_popular') ); // Check if images can be created if ( extension_loaded('ImageMagick') || (extension_loaded('GD') && function_exists('gd_info')) ) { // Enable thumbnail feature $this->thumbnailing = true; // Get available thumbnail size(s) $this->default_thumbnail_sizes = $this->__get_image_sizes(); // Add hook to flush cached thumbnail when image is changed add_action( 'update_postmeta', array( $this, 'flush_post_thumbnail'), 10, 4 ); } // Set default thumbnail $this->default_thumbnail = $this->plugin_dir . "no_thumb.jpg"; $this->default_user_settings['tools']['thumbnail']['default'] = $this->default_thumbnail; if ( !empty($this->user_settings['tools']['thumbnail']['default']) ) $this->default_thumbnail = $this->user_settings['tools']['thumbnail']['default']; else $this->user_settings['tools']['thumbnail']['default'] = $this->default_thumbnail; // Set uploads folder $wp_upload_dir = ( function_exists('wp_get_upload_dir') ) ? wp_get_upload_dir() : wp_upload_dir(); // wp_get_upload_dir() was introduced in WP 4.5! $this->uploads_dir['basedir'] = $wp_upload_dir['basedir'] . "/" . $this->plugin_slug; $this->uploads_dir['baseurl'] = $wp_upload_dir['baseurl'] . "/" . $this->plugin_slug; if ( !is_dir($this->uploads_dir['basedir']) ) { if ( !wp_mkdir_p($this->uploads_dir['basedir']) ) { $this->uploads_dir['basedir'] = $wp_upload_dir['basedir']; $this->uploads_dir['baseurl'] = $wp_upload_dir['baseurl']; } } // qTrans plugin support if ( function_exists('qtrans_useCurrentLanguageIfNotFoundUseDefaultLanguage') ) $this->qTrans = true; // Remove post/page prefetching! remove_action( 'wp_head', 'adjacent_posts_rel_link_wp_head' ); // Add the update hooks only if the logging conditions are met if ( (0 == $this->user_settings['tools']['log']['level'] && !is_user_logged_in()) || (1 == $this->user_settings['tools']['log']['level']) || (2 == $this->user_settings['tools']['log']['level'] && is_user_logged_in()) ) { add_action( 'wp_head', array(&$this, 'print_ajax') ); // Register views from everyone and/or connected users if ( 0 != $this->user_settings['tools']['log']['level'] ) add_action( 'wp_ajax_update_views_ajax', array($this, 'update_views_ajax') ); // Register views from everyone and/or visitors only if ( 2 != $this->user_settings['tools']['log']['level'] ) add_action( 'wp_ajax_nopriv_update_views_ajax', array($this, 'update_views_ajax') ); } // Add shortcode add_shortcode('wpp', array(&$this, 'shortcode')); // Purge post data from DB on deletion add_action( 'admin_init', array($this, 'purge_post_init') ); // Enable data purging at midnight if ( 1 == $this->user_settings['tools']['log']['limit'] ) { add_action( 'wpp_cache_event', array($this, 'purge_data') ); if ( !wp_next_scheduled('wpp_cache_event') ) { $tomorrow = time() + 86400; $midnight = mktime(0, 0, 0, date("m", $tomorrow), date("d", $tomorrow), date("Y", $tomorrow)); wp_schedule_event( $midnight, 'daily', 'wpp_cache_event' ); } } else { // Remove the scheduled event if exists if ( $timestamp = wp_next_scheduled('wpp_cache_event') ) { wp_unschedule_event( $timestamp, 'wpp_cache_event' ); } } } // end constructor /*--------------------------------------------------*/ /* Widget API Functions /*--------------------------------------------------*/ /** * Outputs the content of the widget. * * @since 1.0.0 * @param array args The array of form elements * @param array instance The current instance of the widget */ public function widget( $args, $instance ) { $this->__debug($args); /** * @var String $name * @var String $id * @var String $description * @var String $class * @var String $before_widget * @var String $after_widget * @var String $before_title * @var String $after_title * @var String $widget_id * @var String $widget_name */ extract( $args, EXTR_SKIP ); $markup = ( $instance['markup']['custom_html'] || has_filter('wpp_custom_html') || has_filter('wpp_post') ) ? 'custom' : 'regular'; echo "\n". "<!-- WordPress Popular Posts Plugin v{$this->version} [W] [{$instance['range']}] [{$instance['order_by']}] [{$markup}]" . ( !empty($instance['pid']) ? " [PID]" : "" ) . ( !empty($instance['cat']) ? " [CAT]" : "" ) . ( !empty($instance['author']) ? " [UID]" : "" ) . " -->" . "\n"; echo $before_widget . "\n"; // has user set a title? if ( '' != $instance['title'] ) { $title = apply_filters( 'widget_title', $instance['title'] ); if ($instance['markup']['custom_html'] && $instance['markup']['title-start'] != "" && $instance['markup']['title-end'] != "" ) { echo htmlspecialchars_decode($instance['markup']['title-start'], ENT_QUOTES) . $title . htmlspecialchars_decode($instance['markup']['title-end'], ENT_QUOTES); } else { echo $before_title . $title . $after_title; } } if ( $this->user_settings['tools']['ajax'] ) { if ( empty($before_widget) || !preg_match('/id="[^"]*"/', $before_widget) ) { ?> <p><?php _e('Error: cannot ajaxify WordPress Popular Posts on this theme. It\'s missing the <em>id</em> attribute on before_widget (see <a href="http://codex.wordpress.org/Function_Reference/register_sidebar" target="_blank" rel="nofollow">register_sidebar</a> for more).', $this->plugin_slug ); ?></p> <?php } else { ?> <script type="text/javascript"> /* jQuery is available, so proceed */ if ( window.jQuery ) { jQuery(document).ready(function($){ $.get('<?php echo admin_url('admin-ajax.php'); ?>', { action: 'wpp_get_popular', id: '<?php echo $this->number; ?>' }, function(data){ $('#<?php echo $widget_id; ?>').append(data); }); }); } /* jQuery is not defined */ else { if ( window.console && window.console.log ) { window.console.log('WordPress Popular Posts: jQuery is not defined!'); } } </script> <?php } } else { echo $this->__get_popular_posts( $instance ); } echo $after_widget . "\n"; echo "<!-- End WordPress Popular Posts Plugin v{$this->version} -->"."\n"; } // end widget /** * Processes the widget's options to be saved. * * @since 1.0.0 * @param array new_instance The previous instance of values before the update. * @param array old_instance The new instance of values to be generated via the update. * @return array instance Updated instance. */ public function update( $new_instance, $old_instance ) { $instance = $old_instance; $instance['title'] = htmlspecialchars( stripslashes_deep(strip_tags( $new_instance['title'] )), ENT_QUOTES ); $instance['limit'] = ( $this->__is_numeric($new_instance['limit']) && $new_instance['limit'] > 0 ) ? $new_instance['limit'] : 10; $instance['range'] = $new_instance['range']; $instance['order_by'] = $new_instance['order_by']; // FILTERS // user did not define the custom post type name, so we fall back to default $instance['post_type'] = ( '' == $new_instance['post_type'] ) ? 'post,page' : $new_instance['post_type']; $instance['freshness'] = isset( $new_instance['freshness'] ); $instance['pid'] = implode(",", array_filter(explode(",", preg_replace( '|[^0-9,]|', '', $new_instance['pid'] )))); $instance['cat'] = implode(",", array_filter(explode(",", preg_replace( '|[^0-9,-]|', '', $new_instance['cat'] )))); $instance['author'] = implode(",", array_filter(explode(",", preg_replace( '|[^0-9,]|', '', $new_instance['uid'] )))); $instance['shorten_title']['words'] = $new_instance['shorten_title-words']; $instance['shorten_title']['active'] = isset( $new_instance['shorten_title-active'] ); $instance['shorten_title']['length'] = ( $this->__is_numeric($new_instance['shorten_title-length']) && $new_instance['shorten_title-length'] > 0 ) ? $new_instance['shorten_title-length'] : 25; $instance['post-excerpt']['keep_format'] = isset( $new_instance['post-excerpt-format'] ); $instance['post-excerpt']['words'] = $new_instance['post-excerpt-words']; $instance['post-excerpt']['active'] = isset( $new_instance['post-excerpt-active'] ); $instance['post-excerpt']['length'] = ( $this->__is_numeric($new_instance['post-excerpt-length']) && $new_instance['post-excerpt-length'] > 0 ) ? $new_instance['post-excerpt-length'] : 55; $instance['thumbnail']['active'] = false; $instance['thumbnail']['width'] = 15; $instance['thumbnail']['height'] = 15; // can create thumbnails if ( $this->thumbnailing ) { $instance['thumbnail']['active'] = isset( $new_instance['thumbnail-active'] ); $instance['thumbnail']['build'] = $new_instance['thumbnail-size-source']; // Use predefined thumbnail sizes if ( 'predefined' == $new_instance['thumbnail-size-source'] ) { $size = $this->default_thumbnail_sizes[ $new_instance['thumbnail-size'] ]; $instance['thumbnail']['width'] = $size['width']; $instance['thumbnail']['height'] = $size['height']; $instance['thumbnail']['crop'] = $size['crop']; } // Set thumbnail size manually else { if ($this->__is_numeric($new_instance['thumbnail-width']) && $this->__is_numeric($new_instance['thumbnail-height'])) { $instance['thumbnail']['width'] = $new_instance['thumbnail-width']; $instance['thumbnail']['height'] = $new_instance['thumbnail-height']; $instance['thumbnail']['crop'] = true; } } } $instance['rating'] = isset( $new_instance['rating'] ); $instance['stats_tag']['comment_count'] = isset( $new_instance['comment_count'] ); $instance['stats_tag']['views'] = isset( $new_instance['views'] ); $instance['stats_tag']['author'] = isset( $new_instance['author'] ); $instance['stats_tag']['date']['active'] = isset( $new_instance['date'] ); $instance['stats_tag']['date']['format'] = empty($new_instance['date_format']) ? 'F j, Y' : $new_instance['date_format']; $instance['stats_tag']['category'] = isset( $new_instance['category'] ); $instance['markup']['custom_html'] = isset( $new_instance['custom_html'] ); $instance['markup']['wpp-start'] = empty($new_instance['wpp-start']) ? htmlspecialchars( '<ul class="wpp-list">', ENT_QUOTES ) : htmlspecialchars( $new_instance['wpp-start'], ENT_QUOTES ); $instance['markup']['wpp-end'] = empty($new_instance['wpp-end']) ? htmlspecialchars( '</ul>', ENT_QUOTES ) : htmlspecialchars( $new_instance['wpp-end'], ENT_QUOTES ); $instance['markup']['post-html'] = empty($new_instance['post-html']) ? htmlspecialchars( '<li>{thumb} {title} {stats}</li>', ENT_QUOTES ) : htmlspecialchars( $new_instance['post-html'], ENT_QUOTES ); $instance['markup']['title-start'] = empty($new_instance['title-start']) ? '' : htmlspecialchars( $new_instance['title-start'], ENT_QUOTES ); $instance['markup']['title-end'] = empty($new_instance['title-end']) ? '' : htmlspecialchars( $new_instance['title-end'], ENT_QUOTES ); return $instance; } // end widget /** * Generates the administration form for the widget. * * @since 1.0.0 * @param array instance The array of keys and values for the widget. */ public function form( $instance ) { // parse instance values $instance = $this->__merge_array_r( $this->defaults, $instance ); // Display the admin form include( plugin_dir_path(__FILE__) . '/views/form.php' ); } // end form /*--------------------------------------------------*/ /* Public methods /*--------------------------------------------------*/ /** * Loads the Widget's text domain for localization and translation. * * @since 1.0.0 */ public function widget_textdomain() { $domain = $this->plugin_slug; $locale = apply_filters( 'plugin_locale', get_locale(), $domain ); load_textdomain( $domain, WP_LANG_DIR . '/' . $domain . '/' . $domain . '-' . $locale . '.mo' ); load_plugin_textdomain( $domain, FALSE, dirname( plugin_basename( __FILE__ ) ) . '/lang/' ); } // end widget_textdomain /** * Registers and enqueues admin-specific styles. * * @since 1.0.0 */ public function register_admin_styles() { if ( ! isset( $this->plugin_screen_hook_suffix ) ) { return; } $screen = get_current_screen(); if ( $screen->id == $this->plugin_screen_hook_suffix ) { wp_enqueue_style( $this->plugin_slug .'-admin-styles', plugins_url( 'style/admin.css', __FILE__ ), array(), $this->version ); } } // end register_admin_styles /** * Registers and enqueues admin-specific JavaScript. * * @since 2.3.4 */ public function register_admin_scripts() { if ( ! isset( $this->plugin_screen_hook_suffix ) ) { return; } $screen = get_current_screen(); if ( $screen->id == $this->plugin_screen_hook_suffix ) { wp_enqueue_script( 'thickbox' ); wp_enqueue_style( 'thickbox' ); wp_enqueue_script( 'media-upload' ); wp_enqueue_script( $this->plugin_slug .'-admin-script', plugins_url( 'js/admin.js', __FILE__ ), array('jquery'), $this->version, true ); } } // end register_admin_scripts /** * Hooks into getttext to change upload button text when uploader is called by WPP. * * @since 2.3.4 */ function thickbox_setup() { global $pagenow; if ( 'media-upload.php' == $pagenow || 'async-upload.php' == $pagenow ) { add_filter( 'gettext', array( $this, 'replace_thickbox_text' ), 1, 3 ); } } // end thickbox_setup /** * Replaces upload button text when uploader is called by WPP. * * @since 2.3.4 * @param string translated_text * @param string text * @param string domain * @return string */ function replace_thickbox_text($translated_text, $text, $domain) { if ('Insert into Post' == $text) { $referer = strpos( wp_get_referer(), 'wpp_admin' ); if ( $referer != '' ) { return __('Upload', $this->plugin_slug ); } } return $translated_text; } // end replace_thickbox_text /** * Registers and enqueues widget-specific styles. * * @since 1.0.0 */ public function register_widget_styles() { $theme_file = get_stylesheet_directory() . '/wpp.css'; $plugin_file = plugin_dir_path(__FILE__) . 'style/wpp.css'; if ( @file_exists($theme_file) ) { // user stored a custom wpp.css on theme's directory, so use it wp_enqueue_style( $this->plugin_slug, get_stylesheet_directory_uri() . "/wpp.css", array(), $this->version ); } elseif ( @file_exists($plugin_file) ) { // no custom wpp.css, use plugin's instead wp_enqueue_style( $this->plugin_slug, plugins_url( 'style/wpp.css', __FILE__ ), array(), $this->version ); } } // end register_widget_styles /** * Registers and enqueues widget-specific scripts. */ public function register_widget_scripts() { // We need jQuery in the front-end only when ajaxifying the widget if ( $this->user_settings['tools']['ajax'] ) wp_enqueue_script( 'jquery' ); } // end register_widget_scripts /** * Register the administration menu for this plugin into the WordPress Dashboard menu. * * @since 1.0.0 */ public function add_plugin_admin_menu() { $this->plugin_screen_hook_suffix = add_options_page( 'WordPress Popular Posts', 'WordPress Popular Posts', 'manage_options', $this->plugin_slug, array( $this, 'display_plugin_admin_page' ) ); } /** * Render the settings page for this plugin. * * @since 1.0.0 */ public function display_plugin_admin_page() { include_once( 'views/admin.php' ); } /** * Registers Settings link on plugin description. * * @since 2.3.3 * @param array links * @param string file * @return array */ public function add_plugin_settings_link( $links, $file ){ $this_plugin = plugin_basename(__FILE__); if ( is_plugin_active($this_plugin) && $file == $this_plugin ) { $links[] = '<a href="' . admin_url( 'options-general.php?page=wordpress-popular-posts' ) . '">Settings</a>'; } return $links; } // end add_plugin_settings_link /*--------------------------------------------------*/ /* Install / activation / deactivation methods /*--------------------------------------------------*/ /** * Return an instance of this class. * * @since 3.0.0 * @return object A single instance of this class. */ public static function get_instance() { // If the single instance hasn't been set, set it now. if ( NULL == self::$instance ) { self::$instance = new self; } return self::$instance; } // end get_instance /** * Fired when the plugin is activated. * * @since 1.0.0 * @global object wpdb * @param bool network_wide True if WPMU superadmin uses "Network Activate" action, false if WPMU is disabled or plugin is activated on an individual blog. */ public static function activate( $network_wide ) { global $wpdb; if ( function_exists( 'is_multisite' ) && is_multisite() ) { // run activation for each blog in the network if ( $network_wide ) { $original_blog_id = get_current_blog_id(); $blogs_ids = $wpdb->get_col( "SELECT blog_id FROM {$wpdb->blogs}" ); foreach( $blogs_ids as $blog_id ) { switch_to_blog( $blog_id ); self::__activate(); } // switch back to current blog switch_to_blog( $original_blog_id ); return; } } self::__activate(); } // end activate /** * Fired when a new blog is activated on WP Multisite. * * @since 3.0.0 * @param int blog_id New blog ID */ public function activate_new_site( $blog_id ){ if ( 1 !== did_action( 'wpmu_new_blog' ) ) return; // run activation for the new blog switch_to_blog( $blog_id ); self::__activate(); // switch back to current blog restore_current_blog(); } // end activate_new_site /** * On plugin activation, checks that the WPP database tables are present. * * @since 2.4.0 * @global object wpdb */ private static function __activate() { global $wpdb; // set table name $prefix = $wpdb->prefix . "popularposts"; // fresh setup if ( $prefix != $wpdb->get_var("SHOW TABLES LIKE '{$prefix}data'") ) { self::__do_db_tables( $prefix ); } } // end __activate /** * Fired when the plugin is deactivated. * * @since 1.0.0 * @global object wpbd * @param bool network_wide True if WPMU superadmin uses "Network Activate" action, false if WPMU is disabled or plugin is activated on an individual blog */ public static function deactivate( $network_wide ) { global $wpdb; if ( function_exists( 'is_multisite' ) && is_multisite() ) { // Run deactivation for each blog in the network if ( $network_wide ) { $original_blog_id = get_current_blog_id(); $blogs_ids = $wpdb->get_col( "SELECT blog_id FROM {$wpdb->blogs}" ); foreach( $blogs_ids as $blog_id ) { switch_to_blog( $blog_id ); self::__deactivate(); } // Switch back to current blog switch_to_blog( $original_blog_id ); return; } } self::__deactivate(); } // end deactivate /** * On plugin deactivation, disables the shortcode and removes the scheduled task. * * @since 2.4.0 */ private static function __deactivate() { remove_shortcode('wpp'); wp_clear_scheduled_hook('wpp_cache_event'); } // end __deactivate /** * Checks if an upgrade procedure is required. * * @since 2.4.0 */ public function upgrade_check(){ // Get WPP version $wpp_ver = get_site_option('wpp_ver'); if ( !$wpp_ver ) { add_site_option('wpp_ver', $this->version); } elseif ( version_compare($wpp_ver, $this->version, '<') ) { $this->__upgrade(); } } // end upgrade_check /** * On plugin upgrade, performs a number of actions: update WPP database tables structures (if needed), * run the setup wizard (if needed), and some other checks. * * @since 2.4.0 * @global object wpdb */ private function __upgrade() { // Keep the upgrade process from running too many times if ( get_site_option('wpp_update') ) return; add_site_option( 'wpp_update', 1 ); global $wpdb; // set table name $prefix = $wpdb->prefix . "popularposts"; // validate the structure of the tables and create missing tables self::__do_db_tables( $prefix ); // If summary is empty, import data from popularpostsdatacache if ( !$wpdb->get_var("SELECT COUNT(*) FROM {$prefix}summary") ) { // popularpostsdatacache table is still there if ( $wpdb->get_var("SHOW TABLES LIKE '{$prefix}datacache'") ) { $sql = " INSERT INTO {$prefix}summary (postid, pageviews, view_date, last_viewed) SELECT id, pageviews, day_no_time, day FROM {$prefix}datacache GROUP BY day_no_time, id ORDER BY day_no_time DESC"; $result = $wpdb->query( $sql ); } } // Deletes old caching tables, if found $wpdb->query( "DROP TABLE IF EXISTS {$prefix}datacache, {$prefix}datacache_backup;" ); // Check storage engine $storage_engine_data = $wpdb->get_var("SELECT `ENGINE` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA`='{$wpdb->dbname}' AND `TABLE_NAME`='{$prefix}data';"); if ( 'InnoDB' != $storage_engine_data ) { $wpdb->query("ALTER TABLE {$prefix}data ENGINE=INNODB;"); } $storage_engine_summary = $wpdb->get_var("SELECT `ENGINE` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA`='{$wpdb->dbname}' AND `TABLE_NAME`='{$prefix}summary';"); if ( 'InnoDB' != $storage_engine_summary ) { $wpdb->query("ALTER TABLE {$prefix}summary ENGINE=INNODB;"); } // Update WPP version update_site_option('wpp_ver', $this->version); // Remove upgrade flag delete_site_option('wpp_update'); } // end __upgrade /** * Creates/updates the WPP database tables. * * @since 2.4.0 * @global object wpdb */ private static function __do_db_tables( $prefix ) { global $wpdb; $sql = ""; $charset_collate = ""; if ( !empty($wpdb->charset) ) $charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset} "; if ( !empty($wpdb->collate) ) $charset_collate .= "COLLATE {$wpdb->collate}"; $sql = " CREATE TABLE {$prefix}data ( postid bigint(20) NOT NULL, day datetime NOT NULL DEFAULT '0000-00-00 00:00:00', last_viewed datetime NOT NULL DEFAULT '0000-00-00 00:00:00', pageviews bigint(20) DEFAULT 1, PRIMARY KEY (postid) ) {$charset_collate} ENGINE=INNODB; CREATE TABLE {$prefix}summary ( ID bigint(20) NOT NULL AUTO_INCREMENT, postid bigint(20) NOT NULL, pageviews bigint(20) NOT NULL DEFAULT 1, view_date date NOT NULL DEFAULT '0000-00-00', last_viewed datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (ID), UNIQUE KEY ID_date (postid,view_date), KEY postid (postid), KEY view_date (view_date), KEY last_viewed (last_viewed) ) {$charset_collate} ENGINE=INNODB;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); } // end __do_db_tables /** * Checks if the technical requirements are met. * * @since 2.4.0 * @link http://wordpress.stackexchange.com/questions/25910/uninstall-activate-deactivate-a-plugin-typical-features-how-to/25979#25979 * @global string $wp_version * @return array */ private function __check_requirements() { global $wp_version; $php_min_version = '5.2'; $wp_min_version = '3.8'; $php_current_version = phpversion(); $errors = array(); if ( version_compare( $php_min_version, $php_current_version, '>' ) ) { $errors[] = sprintf( __( 'Your PHP installation is too old. WordPress Popular Posts requires at least PHP version %1$s to function correctly. Please contact your hosting provider and ask them to upgrade PHP to %1$s or higher.', $this->plugin_slug ), $php_min_version ); } if ( version_compare( $wp_min_version, $wp_version, '>' ) ) { $errors[] = sprintf( __( 'Your WordPress version is too old. WordPress Popular Posts requires at least WordPress version %1$s to function correctly. Please update your blog via Dashboard > Update.', $this->plugin_slug ), $wp_min_version ); } return $errors; } // end __check_requirements /** * Outputs error messages to wp-admin. * * @since 2.4.0 */ public function check_admin_notices() { $errors = $this->__check_requirements(); if ( empty($errors) ) return; if ( isset($_GET['activate']) ) unset($_GET['activate']); printf( __('<div class="error"><p>%1$s</p><p><i>%2$s</i> has been <strong>deactivated</strong>.</p></div>', $this->plugin_slug), join( '</p><p>', $errors ), 'WordPress Popular Posts' ); deactivate_plugins( plugin_basename( __FILE__ ) ); } // end check_admin_notices /*--------------------------------------------------*/ /* Plugin methods / functions /*--------------------------------------------------*/ /** * Purges post from data/summary tables. * * @since 3.3.0 */ public function purge_post_init() { if ( current_user_can( 'delete_posts' ) ) add_action( 'delete_post', array( $this, 'purge_post' ), 10 ); } // end purge_post_init /** * Purges post from data/summary tables. * * @since 3.3.0 * @global object $wpdb * @return bool */ public function purge_post( $pID ) { global $wpdb; if ( $wpdb->get_var( $wpdb->prepare( "SELECT postid FROM {$wpdb->prefix}popularpostsdata WHERE postid = %d", $pID ) ) ) { // Delete from data table $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}popularpostsdata WHERE postid = %d;", $pID ) ); // Delete from summary table $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}popularpostssummary WHERE postid = %d;", $pID ) ); } return true; } // end purge_post /** * Purges old post data from summary table. * * @since 2.0.0 * @global object $wpdb */ public function purge_data() { global $wpdb; $wpdb->query( "DELETE FROM {$wpdb->prefix}popularpostssummary WHERE view_date < DATE_SUB('{$this->__curdate()}', INTERVAL {$this->user_settings['tools']['log']['expires_after']} DAY);" ); } // end purge_data /** * Truncates data and cache on demand. * * @since 2.0.0 * @global object wpdb */ public function clear_data() { $token = $_POST['token']; $clear = isset($_POST['clear']) ? $_POST['clear'] : ''; $key = get_site_option("wpp_rand"); if (current_user_can('manage_options') && ($token === $key) && !empty($clear)) { global $wpdb; // set table name $prefix = $wpdb->prefix . "popularposts"; if ($clear == 'cache') { if ( $wpdb->get_var("SHOW TABLES LIKE '{$prefix}summary'") ) { $wpdb->query("TRUNCATE TABLE {$prefix}summary;"); $this->__flush_transients(); echo 1; } else { echo 2; } } else if ($clear == 'all') { if ( $wpdb->get_var("SHOW TABLES LIKE '{$prefix}data'") && $wpdb->get_var("SHOW TABLES LIKE '{$prefix}summary'") ) { $wpdb->query("TRUNCATE TABLE {$prefix}data;"); $wpdb->query("TRUNCATE TABLE {$prefix}summary;"); $this->__flush_transients(); echo 1; } else { echo 2; } } else { echo 3; } } else { echo 4; } die(); } // end clear_data /** * Flushes post's cached thumbnail(s) when the image is changed. * * @since 3.3.4 * * @param integer $meta_id ID of the meta data field * @param integer $object_id Object ID * @param string $meta_key Name of meta field * @param string $meta_value Value of meta field */ public function flush_post_thumbnail( $meta_id, $object_id, $meta_key, $meta_value ) { $files = null; // User changed the featured image if ( '_thumbnail_id' == $meta_key ) { $files = glob( "{$this->uploads_dir['basedir']}/{$object_id}-featured-*.*" ); // get all related images } if ( is_array($files) && !empty($files) ) { foreach( $files as $file ){ // iterate files if ( is_file($file) ) @unlink($file); // delete file } } } /** * Truncates thumbnails cache on demand. * * @since 2.0.0 * @global object wpdb */ public function clear_thumbnails() { $token = $_POST['token']; $key = get_site_option("wpp_rand"); if ( current_user_can('manage_options') && ($token === $key) ) { $wp_upload_dir = wp_upload_dir(); if ( is_dir( $wp_upload_dir['basedir'] . "/" . $this->plugin_slug ) ) { $files = glob( $wp_upload_dir['basedir'] . "/" . $this->plugin_slug . "/*" ); // get all file names if ( is_array($files) && !empty($files) ) { foreach($files as $file){ // iterate files if ( is_file($file) ) @unlink($file); // delete file } echo 1; } else { echo 2; } } else { echo 3; } } else { echo 4; } die(); } // end clear_data /** * Updates views count on page load via AJAX. * * @since 2.0.0 */ public function update_views_ajax(){ if ( !wp_verify_nonce($_POST['token'], 'wpp-token') || !$this->__is_numeric($_POST['wpp_id']) ) die("WPP: Oops, invalid request!"); $nonce = $_POST['token']; $post_ID = $_POST['wpp_id']; $exec_time = 0; $start = $this->__microtime_float(); $result = $this->__update_views($post_ID); $end = $this->__microtime_float(); $exec_time += round($end - $start, 6); if ( $result ) { die( "WPP: OK. Execution time: " . $exec_time . " seconds" ); } die( "WPP: Oops, could not update the views count!" ); } // end update_views_ajax /** * Outputs script to update views via AJAX. * * @since 2.0.0 * @global object post */ public function print_ajax(){ if ( 0 != $this->current_post_id ) { ?> <!-- WordPress Popular Posts v<?php echo $this->version; ?> --> <script type="text/javascript"> var sampling_active = <?php echo ( $this->user_settings['tools']['sampling']['active'] ) ? 1 : 0; ?>; var sampling_rate = <?php echo intval( $this->user_settings['tools']['sampling']['rate'] ); ?>; var do_request = false; if ( !sampling_active ) { do_request = true; } else { var num = Math.floor(Math.random() * sampling_rate) + 1; do_request = ( 1 === num ); } if ( do_request ) { /* Create XMLHttpRequest object and set variables */ var xhr = ( window.XMLHttpRequest ) ? new XMLHttpRequest() : new ActiveXObject( "Microsoft.XMLHTTP" ), url = '<?php echo admin_url('admin-ajax.php', is_ssl() ? 'https' : 'http'); ?>', params = 'action=update_views_ajax&token=<?php echo wp_create_nonce('wpp-token') ?>&wpp_id=<?php echo $this->current_post_id; ?>'; /* Set request method and target URL */ xhr.open( "POST", url, true ); /* Set request header */ xhr.setRequestHeader( "Content-type", "application/x-www-form-urlencoded" ); /* Hook into onreadystatechange */ xhr.onreadystatechange = function() { if ( 4 === xhr.readyState && 200 === xhr.status ) { if ( window.console && window.console.log ) { window.console.log( xhr.responseText ); } } }; /* Send request */ xhr.send( params ); } </script> <!-- End WordPress Popular Posts v<?php echo $this->version; ?> --> <?php } } // end print_ajax /** * Deletes cached (transient) data. * * @since 3.0.0 */ private function __flush_transients() { $wpp_transients = get_site_option('wpp_transients'); if ( $wpp_transients && is_array($wpp_transients) && !empty($wpp_transients) ) { for ($t=0; $t < count($wpp_transients); $t++) delete_transient( $wpp_transients[$t] ); update_site_option('wpp_transients', array()); } } // end __flush_transients /** * Updates views count. * * @since 1.4.0 * @global object $wpdb * @param int Post ID * @return bool|int FALSE if query failed, TRUE on success */ private function __update_views($id) { /* TODO: For WordPress Multisite, we must define the DIEONDBERROR constant for database errors to display like so: <?php define( 'DIEONDBERROR', true ); ?> */ global $wpdb; $table = $wpdb->prefix . "popularposts"; $wpdb->show_errors(); // WPML support, get original post/page ID if ( defined('ICL_LANGUAGE_CODE') && function_exists('icl_object_id') ) { global $sitepress; if ( isset( $sitepress )) { // avoids a fatal error with Polylang $id = icl_object_id( $id, get_post_type( $id ), true, $sitepress->get_default_language() ); } else if ( function_exists( 'pll_default_language' ) ) { // adds Polylang support $id = icl_object_id( $id, get_post_type( $id ), true, pll_default_language() ); } } $now = $this->__now(); $curdate = $this->__curdate(); $views = ( $this->user_settings['tools']['sampling']['active'] ) ? $this->user_settings['tools']['sampling']['rate'] : 1; // Allow WP themers / coders perform an action // before updating views count if ( has_action( 'wpp_pre_update_views' ) ) do_action( 'wpp_pre_update_views', $id, $views ); // Update all-time table $result1 = $wpdb->query( $wpdb->prepare( "INSERT INTO {$table}data (postid, day, last_viewed, pageviews) VALUES (%d, %s, %s, %d) ON DUPLICATE KEY UPDATE pageviews = pageviews + %4\$d, last_viewed = '%3\$s';", $id, $now, $now, $views )); // Update range (summary) table $result2 = $wpdb->query( $wpdb->prepare( "INSERT INTO {$table}summary (postid, pageviews, view_date, last_viewed) VALUES (%d, %d, %s, %s) ON DUPLICATE KEY UPDATE pageviews = pageviews + %2\$d, last_viewed = '%4\$s';", $id, $views, $curdate, $now )); if ( !$result1 || !$result2 ) return false; // Allow WP themers / coders perform an action // after updating views count if ( has_action( 'wpp_post_update_views' ) ) do_action( 'wpp_post_update_views', $id ); return true; } // end __update_views /** * Queries the database and returns the posts (if any met the criteria set by the user). * * @since 1.4.0 * @global object $wpdb * @param array Widget instance * @return null|array Array of posts, or null if nothing was found */ protected function _query_posts($instance) { global $wpdb; // parse instance values $instance = $this->__merge_array_r( $this->defaults, $instance ); $prefix = $wpdb->prefix . "popularposts"; $fields = "p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid'"; $from = ""; $where = "WHERE 1 = 1"; $orderby = ""; $groupby = ""; $limit = "LIMIT {$instance['limit']}"; $post_types = ""; $pids = ""; $cats = ""; $authors = ""; $content = ""; $now = $this->__now(); // post filters // * freshness - get posts published within the selected time range only if ( $instance['freshness'] ) { switch( $instance['range'] ){ case "daily": $where .= " AND p.post_date > DATE_SUB('{$now}', INTERVAL 1 DAY) "; break; case "weekly": $where .= " AND p.post_date > DATE_SUB('{$now}', INTERVAL 1 WEEK) "; break; case "monthly": $where .= " AND p.post_date > DATE_SUB('{$now}', INTERVAL 1 MONTH) "; break; default: $where .= ""; break; } } // * post types - based on code seen at https://github.com/williamsba/WordPress-Popular-Posts-with-Custom-Post-Type-Support $types = explode(",", $instance['post_type']); $sql_post_types = ""; $join_cats = true; // if we're getting just pages, why join the categories table? if ( 'page' == strtolower($instance['post_type']) ) { $join_cats = false; $where .= " AND p.post_type = '{$instance['post_type']}'"; } // we're listing other custom type(s) else { if ( count($types) > 1 ) { foreach ( $types as $post_type ) { $post_type = trim($post_type); // required in case user places whitespace between commas $sql_post_types .= "'{$post_type}',"; } $sql_post_types = rtrim( $sql_post_types, ","); $where .= " AND p.post_type IN({$sql_post_types})"; } else { $where .= " AND p.post_type = '{$instance['post_type']}'"; } } // * posts exclusion if ( !empty($instance['pid']) ) { $ath = explode(",", $instance['pid']); $where .= ( count($ath) > 1 ) ? " AND p.ID NOT IN({$instance['pid']})" : " AND p.ID <> '{$instance['pid']}'"; } // * categories if ( !empty($instance['cat']) && $join_cats ) { $cat_ids = explode(",", $instance['cat']); $in = array(); $out = array(); for ($i=0; $i < count($cat_ids); $i++) { if ($cat_ids[$i] >= 0) $in[] = $cat_ids[$i]; else $out[] = $cat_ids[$i]; } $in_cats = implode(",", $in); $out_cats = implode(",", $out); $out_cats = preg_replace( '|[^0-9,]|', '', $out_cats ); if ($in_cats != "" && $out_cats == "") { // get posts from from given cats only $where .= " AND p.ID IN ( SELECT object_id FROM {$wpdb->term_relationships} AS r JOIN {$wpdb->term_taxonomy} AS x ON x.term_taxonomy_id = r.term_taxonomy_id WHERE x.taxonomy = 'category' AND x.term_id IN({$in_cats}) )"; } else if ($in_cats == "" && $out_cats != "") { // exclude posts from given cats only $where .= " AND p.ID NOT IN ( SELECT object_id FROM {$wpdb->term_relationships} AS r JOIN {$wpdb->term_taxonomy} AS x ON x.term_taxonomy_id = r.term_taxonomy_id WHERE x.taxonomy = 'category' AND x.term_id IN({$out_cats}) )"; } else { // mixed $where .= " AND p.ID IN ( SELECT object_id FROM {$wpdb->term_relationships} AS r JOIN {$wpdb->term_taxonomy} AS x ON x.term_taxonomy_id = r.term_taxonomy_id WHERE x.taxonomy = 'category' AND x.term_id IN({$in_cats}) AND x.term_id NOT IN({$out_cats}) ) "; } } // * authors if ( !empty($instance['author']) ) { $ath = explode(",", $instance['author']); $where .= ( count($ath) > 1 ) ? " AND p.post_author IN({$instance['author']})" : " AND p.post_author = '{$instance['author']}'"; } // All-time range if ( "all" == $instance['range'] ) { $fields .= ", p.comment_count AS 'comment_count'"; // order by comments if ( "comments" == $instance['order_by'] ) { $from = "{$wpdb->posts} p"; $where .= " AND p.comment_count > 0 "; $orderby = " ORDER BY p.comment_count DESC"; // get views, too if ( $instance['stats_tag']['views'] ) { $fields .= ", IFNULL(v.pageviews, 0) AS 'pageviews'"; $from .= " LEFT JOIN {$prefix}data v ON p.ID = v.postid"; } } // order by (avg) views else { $from = "{$prefix}data v LEFT JOIN {$wpdb->posts} p ON v.postid = p.ID"; // order by views if ( "views" == $instance['order_by'] ) { $fields .= ", v.pageviews AS 'pageviews'"; $orderby = "ORDER BY pageviews DESC"; } // order by avg views elseif ( "avg" == $instance['order_by'] ) { $fields .= ", ( v.pageviews/(IF ( DATEDIFF('{$now}', MIN(v.day)) > 0, DATEDIFF('{$now}', MIN(v.day)), 1) ) ) AS 'avg_views'"; $groupby = "GROUP BY v.postid"; $orderby = "ORDER BY avg_views DESC"; } } } else { // CUSTOM RANGE $interval = ""; switch( $instance['range'] ){ case "daily": $interval = "1 DAY"; break; case "weekly": $interval = "1 WEEK"; break; case "monthly": $interval = "1 MONTH"; break; default: $interval = "1 DAY"; break; } // order by comments if ( "comments" == $instance['order_by'] ) { $fields .= ", COUNT(c.comment_post_ID) AS 'comment_count'"; $from = "{$wpdb->comments} c LEFT JOIN {$wpdb->posts} p ON c.comment_post_ID = p.ID"; $where .= " AND c.comment_date_gmt > DATE_SUB('{$now}', INTERVAL {$interval}) AND c.comment_approved = 1 "; $groupby = "GROUP BY c.comment_post_ID"; $orderby = "ORDER BY comment_count DESC"; if ( $instance['stats_tag']['views'] ) { // get views, too $fields .= ", IFNULL(v.pageviews, 0) AS 'pageviews'"; $from .= " LEFT JOIN (SELECT postid, SUM(pageviews) AS pageviews FROM {$prefix}summary WHERE last_viewed > DATE_SUB('{$now}', INTERVAL {$interval}) GROUP BY postid) v ON p.ID = v.postid"; } } // ordered by views / avg else { $from = "{$prefix}summary v LEFT JOIN {$wpdb->posts} p ON v.postid = p.ID"; $where .= " AND v.last_viewed > DATE_SUB('{$now}', INTERVAL {$interval}) "; $groupby = "GROUP BY v.postid"; // ordered by views if ( "views" == $instance['order_by'] ) { $fields .= ", SUM(v.pageviews) AS 'pageviews'"; $orderby = "ORDER BY pageviews DESC"; } // ordered by avg views elseif ( "avg" == $instance['order_by'] ) { $fields .= ", ( SUM(v.pageviews)/(IF ( DATEDIFF('{$now}', DATE_SUB('{$now}', INTERVAL {$interval})) > 0, DATEDIFF('{$now}', DATE_SUB('{$now}', INTERVAL {$interval})), 1) ) ) AS 'avg_views' "; $orderby = "ORDER BY avg_views DESC"; } // get comments, too if ( $instance['stats_tag']['comment_count'] ) { $fields .= ", IFNULL(c.comment_count, 0) AS 'comment_count'"; $from .= " LEFT JOIN (SELECT comment_post_ID, COUNT(comment_post_ID) AS 'comment_count' FROM {$wpdb->comments} WHERE comment_date_gmt > DATE_SUB('{$now}', INTERVAL {$interval}) AND comment_approved = 1 GROUP BY comment_post_ID) c ON p.ID = c.comment_post_ID"; } } } // List only published, non password-protected posts $where .= " AND p.post_password = '' AND p.post_status = 'publish'"; // Build query $query = "SELECT {$fields} FROM {$from} {$where} {$groupby} {$orderby} {$limit};"; $this->__debug( $query ); $result = $wpdb->get_results($query); return apply_filters( 'wpp_query_posts', $result, $instance ); } // end query_posts /** * Returns the formatted list of posts. * * @since 3.0.0 * @param array instance The current instance of the widget / shortcode parameters * @return string HTML list of popular posts */ private function __get_popular_posts( $instance ) { // Parse instance values $instance = $this->__merge_array_r( $this->defaults, $instance ); // Pass the widget ID, might come in handy if ( isset($this->id) ) $instance['widget_id'] = $this->id; $content = ""; // Fetch posts if ( !defined('WPP_ADMIN') && $this->user_settings['tools']['cache']['active'] ) { $transient_name = md5(json_encode($instance)); $mostpopular = ( function_exists( 'is_multisite' ) && is_multisite() ) ? get_site_transient( $transient_name ) : get_transient( $transient_name ); $content = "\n" . "<!-- cached -->" . "\n"; // It wasn't there, so regenerate the data and save the transient if ( false === $mostpopular ) { $mostpopular = $this->_query_posts( $instance ); switch($this->user_settings['tools']['cache']['interval']['time']){ case 'minute': $time = 60; break; case 'hour': $time = 60 * 60; break; case 'day': $time = 60 * 60 * 24; break; case 'week': $time = 60 * 60 * 24 * 7; break; case 'month': $time = 60 * 60 * 24 * 30; break; case 'year': $time = 60 * 60 * 24 * 365; break; } $expiration = $time * $this->user_settings['tools']['cache']['interval']['value']; if ( function_exists( 'is_multisite' ) && is_multisite() ) set_site_transient( $transient_name, $mostpopular, $expiration ); else set_transient( $transient_name, $mostpopular, $expiration ); $wpp_transients = get_site_option('wpp_transients'); if ( !$wpp_transients ) { $wpp_transients = array( $transient_name ); add_site_option('wpp_transients', $wpp_transients); } else { if ( !in_array($transient_name, $wpp_transients) ) { $wpp_transients[] = $transient_name; update_site_option('wpp_transients', $wpp_transients); } } } } else { $mostpopular = $this->_query_posts( $instance ); } // No posts to show if ( !is_array($mostpopular) || empty($mostpopular) ) { return apply_filters( 'wpp_no_data', "<p class=\"wpp-no-data\">" . __('Sorry. No data so far.', $this->plugin_slug) . "</p>" ); } // Allow WP themers / coders access to raw data // so they can build their own output if ( has_filter( 'wpp_custom_html' ) && !defined('WPP_ADMIN') ) { return apply_filters( 'wpp_custom_html', $mostpopular, $instance ); } // HTML wrapper if ($instance['markup']['custom_html']) { $content .= "\n" . htmlspecialchars_decode($instance['markup']['wpp-start'], ENT_QUOTES) ."\n"; } else { $content .= "\n" . "<ul class=\"wpp-list\">" . "\n"; } // Loop through posts foreach($mostpopular as $p) { $content .= $this->__render_popular_post( $p, $instance ); } // END HTML wrapper if ($instance['markup']['custom_html']) { $content .= "\n". htmlspecialchars_decode($instance['markup']['wpp-end'], ENT_QUOTES) ."\n"; } else { $content .= "\n". "</ul>". "\n"; } return $content; } // end __get_popular_posts /** * Returns the formatted post. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return string */ private function __render_popular_post($p, $instance) { // WPML support, based on Serhat Evren's suggestion - see http://wordpress.org/support/topic/wpml-trick#post-5452607 if ( defined('ICL_LANGUAGE_CODE') && function_exists('icl_object_id') ) { $current_id = icl_object_id( $p->id, get_post_type( $p->id ), true, ICL_LANGUAGE_CODE ); $permalink = get_permalink( $current_id ); } // Get original permalink else { $permalink = get_permalink($p->id); } $title = $this->_get_title($p, $instance); $title_sub = $this->_get_title_sub($p, $instance); $author = $this->_get_author($p, $instance); $post_cat = $this->_get_post_cat($p, $instance); $thumb = $this->_get_thumb($p, $instance); $excerpt = $this->_get_excerpt($p, $instance); $pageviews = $this->_get_pageviews($p, $instance); $comments = $this->_get_comments($p, $instance); $rating = $this->_get_rating($p, $instance); $date = $this->_get_date($p, $instance); $_stats = join(' | ', $this->_get_stats($p, $instance)); // PUTTING IT ALL TOGETHER // build custom layout if ($instance['markup']['custom_html']) { $data = array( 'title' => '<a href="'.$permalink.'" title="'. esc_attr($title) .'" class="wpp-post-title" target="' . $this->user_settings['tools']['link']['target'] . '">'.$title_sub.'</a>', 'summary' => $excerpt, 'stats' => $_stats, 'img' => ( !empty($thumb) ) ? '<a href="'.$permalink.'" title="'. esc_attr($title) .'" target="' . $this->user_settings['tools']['link']['target'] . '">' . $thumb . '</a>' : '', 'img_no_link' => $thumb, 'id' => $p->id, 'url' => $permalink, 'text_title' => esc_attr($title), 'category' => $post_cat, 'author' => '<a href="' . get_author_posts_url($p->uid) . '">' . $author . '</a>', 'views' => ($instance['order_by'] == "views" || $instance['order_by'] == "comments") ? number_format_i18n( $pageviews ) : number_format_i18n( $pageviews, 2 ), 'comments' => number_format_i18n( $comments ), 'date' => $date ); $content = $this->__format_content( htmlspecialchars_decode($instance['markup']['post-html'], ENT_QUOTES ), $data, $instance['rating'] ). "\n"; } // build regular layout else { $thumb = ( !empty($thumb) ) ? '<a ' . ( ( $this->current_post_id == $p->id ) ? '' : 'href="' . $permalink . '"' ) . ' title="' . esc_attr($title) . '" target="' . $this->user_settings['tools']['link']['target'] . '">' . $thumb . '</a> ' : ''; $_stats = ( !empty($_stats) ) ? ' <span class="post-stats">' . $_stats . '</span> ' : ''; $content = '<li' . ( ( $this->current_post_id == $p->id ) ? ' class="current"' : '' ) . '>' . $thumb . '<a ' . ( ( $this->current_post_id == $p->id ) ? '' : 'href="' . $permalink . '"' ) . ' title="' . esc_attr($title) . '" class="wpp-post-title" target="' . $this->user_settings['tools']['link']['target'] . '">' . $title_sub . '</a> ' . $excerpt . $_stats . $rating . "</li>\n"; } return apply_filters('wpp_post', $content, $p, $instance); } // end __render_popular_post /** * Cache. * * @since 3.0.0 * @param string $func function name * @param mixed $default * @return mixed */ private function &__cache($func, $default = null) { static $cache; if ( !isset($cache) ) { $cache = array(); } if ( !isset($cache[$func]) ) { $cache[$func] = $default; } return $cache[$func]; } // end __cache /** * Gets post title. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return string */ protected function _get_title($p, $instance) { $cache = &$this->__cache(__FUNCTION__, array()); if ( isset($cache[$p->id]) ) { return $cache[$p->id]; } // WPML support, based on Serhat Evren's suggestion - see http://wordpress.org/support/topic/wpml-trick#post-5452607 if ( defined('ICL_LANGUAGE_CODE') && function_exists('icl_object_id') ) { $current_id = icl_object_id( $p->id, get_post_type( $p->id ), true, ICL_LANGUAGE_CODE ); $title = get_the_title( $current_id ); } // Check for qTranslate else if ( $this->qTrans && function_exists('qtrans_useCurrentLanguageIfNotFoundUseDefaultLanguage') ) { $title = qtrans_useCurrentLanguageIfNotFoundUseDefaultLanguage( $p->title ); } // Use ol' plain title else { $title = $p->title; } // Strip HTML tags $title = strip_tags($title); return $cache[$p->id] = apply_filters('the_title', $title, $p->id); } // end _get_title /** * Gets substring of post title. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return string */ protected function _get_title_sub($p, $instance) { $cache = &$this->__cache(__FUNCTION__, array()); if ( isset($cache[$p->id]) ) { return $cache[$p->id]; } // TITLE $title_sub = $this->_get_title($p, $instance); // truncate title if ($instance['shorten_title']['active']) { // by words if (isset($instance['shorten_title']['words']) && $instance['shorten_title']['words']) { $words = explode(" ", $title_sub, $instance['shorten_title']['length'] + 1); if (count($words) > $instance['shorten_title']['length']) { array_pop($words); $title_sub = rtrim( implode(" ", $words), ",." ) . " ..."; } } elseif (strlen($title_sub) > $instance['shorten_title']['length']) { $title_sub = rtrim( mb_substr($title_sub, 0, $instance['shorten_title']['length'], $this->charset), " ,." ) . "..."; } } return $cache[$p->id] = $title_sub; } // end _get_title_sub /** * Gets post's excerpt. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return string */ protected function _get_excerpt($p, $instance) { $excerpt = ''; // EXCERPT if ($instance['post-excerpt']['active']) { $excerpt = trim($this->_get_summary($p->id, $instance)); if (!empty($excerpt) && !$instance['markup']['custom_html']) { $excerpt = '<span class="wpp-excerpt">' . $excerpt . '</span>'; } } return $excerpt; } // end _get_excerpt /** * Gets post's thumbnail. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return string */ protected function _get_thumb($p, $instance) { if ( !$instance['thumbnail']['active'] || !$this->thumbnailing ) { return ''; } $tbWidth = $instance['thumbnail']['width']; $tbHeight = $instance['thumbnail']['height']; $crop = $instance['thumbnail']['crop']; $title = $this->_get_title($p, $instance); $thumb = ''; // get image from custom field if ($this->user_settings['tools']['thumbnail']['source'] == "custom_field") { $path = get_post_meta($p->id, $this->user_settings['tools']['thumbnail']['field'], true); if ($path != '') { // user has requested to resize cf image if ( $this->user_settings['tools']['thumbnail']['resize'] ) { $thumb .= $this->__get_img($p, null, $path, array($tbWidth, $tbHeight), $crop, $this->user_settings['tools']['thumbnail']['source'], $title); } // use original size else { $thumb .= $this->_render_image($path, array($tbWidth, $tbHeight), 'wpp-thumbnail wpp_cf', $title); } } else { $thumb .= $this->_render_image($this->default_thumbnail, array($tbWidth, $tbHeight), 'wpp-thumbnail wpp_cf_def', $title); } } // get image from post / Featured Image else { // User wants to use the Featured Image using the 'stock' sizes, get stock thumbnails if ( 'predefined' == $instance['thumbnail']['build'] && 'featured' == $this->user_settings['tools']['thumbnail']['source'] ) { // The has_post_thumbnail() functions requires theme's 'post-thumbnails' support, otherwise an error will be thrown if ( current_theme_supports( 'post-thumbnails' ) ) { // Featured image found, retrieve it if ( has_post_thumbnail($p->id) ) { $size = null; foreach ( $this->default_thumbnail_sizes as $name => $attr ) : if ( $attr['width'] == $tbWidth && $attr['height'] == $tbHeight && $attr['crop'] == $crop ) { $size = $name; break; } endforeach; // Couldn't find a matching size (this should like never happen, but...) let's use width & height instead if ( null == $size ) { $size = array( $tbWidth, $tbHeight ); } if ( $this->user_settings['tools']['thumbnail']['responsive'] ) $thumb .= preg_replace( '/(width|height)=["\']\d*["\']\s?/', "", get_the_post_thumbnail($p->id, $size, array( 'class' => 'wpp-thumbnail wpp_featured_stock' )) ); else $thumb .= get_the_post_thumbnail( $p->id, $size, array( 'class' => 'wpp-thumbnail wpp_featured_stock' ) ); } // No featured image found else { $thumb .= $this->_render_image($this->default_thumbnail, array($tbWidth, $tbHeight), 'wpp-thumbnail wpp_featured_def', $title); } } // Current theme does not support 'post-thumbnails' feature else { $thumb .= $this->_render_image($this->default_thumbnail, array($tbWidth, $tbHeight), 'wpp-thumbnail wpp_featured_def', $title, 'No post-thumbnail support?'); } } // Get/generate custom thumbnail else { $thumb .= $this->__get_img($p, $p->id, null, array($tbWidth, $tbHeight), $crop, $this->user_settings['tools']['thumbnail']['source'], $title); } } return $thumb; } // end _get_thumb /** * Gets post's views. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return int|float */ protected function _get_pageviews($p, $instance) { $pageviews = 0; if ( $instance['order_by'] == "views" || $instance['order_by'] == "avg" || $instance['stats_tag']['views'] ) { $pageviews = ($instance['order_by'] == "views" || $instance['order_by'] == "comments") ? $p->pageviews : $p->avg_views; } return $pageviews; } // end _get_pageviews /** * Gets post's comment count. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return int */ protected function _get_comments($p, $instance) { $comments = ($instance['order_by'] == "comments" || $instance['stats_tag']['comment_count']) ? $p->comment_count : 0; return $comments; } // end _get_comments /** * Gets post's rating. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return string */ protected function _get_rating($p, $instance) { $cache = &$this->__cache(__FUNCTION__, array()); if ( isset($cache[$p->id]) ) { return $cache[$p->id]; } $rating = ''; // RATING if (function_exists('the_ratings') && $instance['rating']) { $rating = '<span class="wpp-rating">' . the_ratings('span', $p->id, false) . '</span>'; } return $cache[$p->id] = $rating; } // end _get_rating /** * Gets post's author. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return string */ protected function _get_author($p, $instance) { $cache = &$this->__cache(__FUNCTION__, array()); if ( isset($cache[$p->id]) ) { return $cache[$p->id]; } $author = ($instance['stats_tag']['author']) ? get_the_author_meta('display_name', $p->uid) : ""; return $cache[$p->id] = $author; } // end _get_author /** * Gets post's date. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return string */ protected function _get_date($p, $instance) { $cache = &$this->__cache(__FUNCTION__, array()); if ( isset($cache[$p->id]) ) { return $cache[$p->id]; } $date = date_i18n($instance['stats_tag']['date']['format'], strtotime($p->date)); return $cache[$p->id] = $date; } // end _get_date /** * Gets post's category. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return string */ protected function _get_post_cat($p, $instance) { $post_cat = ''; if ($instance['stats_tag']['category']) { $cache = &$this->__cache(__FUNCTION__, array()); if ( isset($cache[$p->id]) ) { return $cache[$p->id]; } // Try and get parent category $cats = get_the_category($p->id); foreach( $cats as $cat ) { if( $cat->category_parent == 0) { $post_cat = $cat; } } // Default to first category avaliable if ( $post_cat == "" && isset($cats[0]) && isset($cats[0]->slug) ) { $post_cat = $cats[0]; } // Build category tag if ( "" != $post_cat ) { $category_id = $post_cat->term_id; $category_name = $post_cat->cat_name; // WPML support, based on Serhat Evren's suggestion - see http://wordpress.org/support/topic/wpml-trick#post-5452607 if ( defined('ICL_LANGUAGE_CODE') && function_exists('icl_object_id') ) { $category_id = icl_object_id( $category_id, 'category', true, ICL_LANGUAGE_CODE ); $category_name = get_the_category_by_ID( $category_id ); } $post_cat = '<a href="' . get_category_link( $category_id ) . '" class="cat-id-' . $category_id . '">' . $category_name . '</a>'; } return $cache[$p->id] = $post_cat; } return $post_cat; } // end _get_post_cat /** * Gets statistics data. * * @since 3.0.0 * @param object p * @param array instance The current instance of the widget / shortcode parameters * @return array */ protected function _get_stats($p, $instance) { $cache = &$this->__cache(__FUNCTION__ . md5(json_encode($instance)), array()); if ( isset($cache[$p->id]) ) { return $cache[$p->id]; } $stats = array(); // STATS // comments if ($instance['stats_tag']['comment_count']) { $comments = $this->_get_comments($p, $instance); $comments_text = sprintf( _n('1 comment', '%s comments', $comments, $this->plugin_slug), number_format_i18n( $comments ) ); } // views if ($instance['stats_tag']['views']) { $pageviews = $this->_get_pageviews($p, $instance); if ($instance['order_by'] == 'avg') { $views_text = sprintf( _n('1 view per day', '%s views per day', $pageviews, $this->plugin_slug), number_format_i18n( $pageviews, 2 ) ); } else { $views_text = sprintf( _n('1 view', '%s views', $pageviews, $this->plugin_slug), number_format_i18n( $pageviews ) ); } } if ( "comments" == $instance['order_by'] ) { if ($instance['stats_tag']['comment_count']) $stats[] = '<span class="wpp-comments">' . $comments_text . '</span>'; // First comments count if ($instance['stats_tag']['views']) $stats[] = '<span class="wpp-views">' . $views_text . "</span>"; // ... then views } else { if ($instance['stats_tag']['views']) $stats[] = '<span class="wpp-views">' . $views_text . "</span>"; // First views count if ($instance['stats_tag']['comment_count']) $stats[] = '<span class="wpp-comments">' . $comments_text . '</span>'; // ... then comments } // author if ($instance['stats_tag']['author']) { $author = $this->_get_author($p, $instance); $display_name = '<a href="' . get_author_posts_url($p->uid) . '">' . $author . '</a>'; $stats[] = '<span class="wpp-author">' . sprintf(__('by %s', $this->plugin_slug), $display_name).'</span>'; } // date if ($instance['stats_tag']['date']['active']) { $date = $this->_get_date($p, $instance); $stats[] = '<span class="wpp-date">' . sprintf(__('posted on %s', $this->plugin_slug), $date) . '</span>'; } // category if ($instance['stats_tag']['category']) { $post_cat = $this->_get_post_cat($p, $instance); if ($post_cat != '') { $stats[] = '<span class="wpp-category">' . sprintf(__('under %s', $this->plugin_slug), $post_cat) . '</span>'; } } return $cache[$p->id] = $stats; } // end _get_stats /** * Retrieves / creates the post thumbnail. * * @since 2.3.3 * @param int id Post ID * @param string url Image URL * @param array dim Thumbnail width & height * @param string source Image source * @return string */ private function __get_img($p, $id = null, $url = null, $dim = array(80, 80), $crop = true, $source = "featured", $title) { if ( (!$id || empty($id) || !$this->__is_numeric($id)) && (!$url || empty($url)) ) { return $this->_render_image($this->default_thumbnail, $dim, 'wpp-thumbnail wpp_def_noID', $title); } // Get image by post ID (parent) if ( $id ) { $file_path = $this->__get_image_file_paths($id, $source); // No images found, return default thumbnail if ( !$file_path ) { return $this->_render_image($this->default_thumbnail, $dim, 'wpp-thumbnail wpp_def_noPath wpp_' . $source, $title); } } // Get image from URL else { // sanitize URL, just in case $image_url = esc_url( $url ); // remove querystring preg_match('/[^\?]+\.(jpg|JPG|jpe|JPE|jpeg|JPEG|gif|GIF|png|PNG)/', $image_url, $matches); $image_url = $matches[0]; $attachment_id = $this->__get_attachment_id($image_url); // Image is hosted locally if ( $attachment_id ) { $file_path = get_attached_file($attachment_id); } // Image is hosted outside WordPress else { $external_image = $this->__fetch_external_image($p->id, $image_url); if ( !$external_image ) { return $this->_render_image($this->default_thumbnail, $dim, 'wpp-thumbnail wpp_def_noPath wpp_no_external', $title); } $file_path = $external_image; } } $file_info = pathinfo($file_path); // there is a thumbnail already if ( file_exists(trailingslashit($this->uploads_dir['basedir']) . $p->id . '-' . $source . '-' . $dim[0] . 'x' . $dim[1] . '.' . $file_info['extension']) ) { return $this->_render_image( trailingslashit($this->uploads_dir['baseurl']) . $p->id . '-' . $source . '-' . $dim[0] . 'x' . $dim[1] . '.' . $file_info['extension'], $dim, 'wpp-thumbnail wpp_cached_thumb wpp_' . $source, $title ); } return $this->__image_resize($p, $file_path, $dim, $crop, $source); } // end __get_img /** * Resizes image. * * @since 3.0.0 * @param object p Post object * @param string path Image path * @param array dimension Image's width and height * @param string source Image source * @return string */ private function __image_resize($p, $path, $dimension, $crop, $source) { $image = wp_get_image_editor($path); // valid image, create thumbnail if ( !is_wp_error($image) ) { $file_info = pathinfo($path); $image->resize($dimension[0], $dimension[1], $crop); $new_img = $image->save( trailingslashit($this->uploads_dir['basedir']) . $p->id . '-' . $source . '-' . $dimension[0] . 'x' . $dimension[1] . '.' . $file_info['extension'] ); if ( is_wp_error($new_img) ) { return $this->_render_image($this->default_thumbnail, $dimension, 'wpp-thumbnail wpp_imgeditor_error wpp_' . $source, '', $new_img->get_error_message()); } return $this->_render_image( trailingslashit($this->uploads_dir['baseurl']) . $new_img['file'], $dimension, 'wpp-thumbnail wpp_imgeditor_thumb wpp_' . $source, ''); } // ELSE // image file path is invalid return $this->_render_image($this->default_thumbnail, $dimension, 'wpp-thumbnail wpp_imgeditor_error wpp_' . $source, '', $image->get_error_message()); } // end __image_resize /** * Get image absolute path / URL. * * @since 3.0.0 * @param int id Post ID * @param string source Image source * @return array */ private function __get_image_file_paths($id, $source) { $file_path = ''; // get thumbnail path from the Featured Image if ($source == "featured") { // thumb attachment ID $thumbnail_id = get_post_thumbnail_id($id); if ($thumbnail_id) { // image path return get_attached_file($thumbnail_id); } } // get thumbnail path from first image attachment elseif ($source == "first_attachment") { $post_attachments = get_children( array( 'numberposts' => 1, 'order' => 'ASC', 'post_parent' => $id, 'post_type' => 'attachment', 'post_mime_type' => 'image' )); if ( !empty($post_attachments) ) { $first_img = array_shift( $post_attachments ); return get_attached_file($first_img->ID); } } // get thumbnail path from post content elseif ($source == "first_image") { /** @var wpdb $wpdb */ global $wpdb; if ( $content = $wpdb->get_var( "SELECT post_content FROM {$wpdb->posts} WHERE ID = {$id};" ) ) { // at least one image has been found if ( preg_match( '/<img[^>]+>/i', $content, $img ) ) { // get img src attribute from the first image found preg_match( '/(src)="([^"]*)"/i', $img[0], $src_attr ); if ( isset($src_attr[2]) && !empty($src_attr[2]) ) { // image from Media Library if ( $attachment_id = $this->__get_attachment_id( $src_attr[2] ) ) { $file_path = get_attached_file($attachment_id); // There's a file path, so return it if ( !empty($file_path) ) { return $file_path; } } // external image? else { return $this->__fetch_external_image($id, $src_attr[2]); } } } } } return false; } // end __get_image_file_paths /** * Render image tag. * * @since 3.0.0 * @param string src Image URL * @param array dimension Image's width and height * @param string class CSS class * @param string title Image's title/alt attribute * @param string error Error, if the image could not be created * @return string */ protected function _render_image($src, $dimension, $class, $title = "", $error = null) { $msg = ''; if ($error) { $msg = '<!-- ' . $error . ' --> '; } if ( is_ssl() ) { $src = str_ireplace( "http://", "https://", $src ); } return apply_filters( 'wpp_render_image', $msg . '<img src="' . $src . '" ' . ( false == $this->user_settings['tools']['thumbnail']['responsive'] ? 'width="' . $dimension[0] . '" height="' . $dimension[1] . '"' : '' ) . ' title="' . esc_attr($title) . '" alt="' . esc_attr($title) . '" class="' . $class . '" />' ); } // _render_image /** * Get the Attachment ID for a given image URL. * * @since 3.0.0 * @author Frankie Jarrett * @link http://frankiejarrett.com/get-an-attachment-id-by-url-in-wordpress/ * @param string url * @return bool|int */ private function __get_attachment_id($url) { // Split the $url into two parts with the wp-content directory as the separator. $parse_url = explode( parse_url( WP_CONTENT_URL, PHP_URL_PATH ), $url ); // Get the host of the current site and the host of the $url, ignoring www. $this_host = str_ireplace( 'www.', '', parse_url( home_url(), PHP_URL_HOST ) ); $file_host = str_ireplace( 'www.', '', parse_url( $url, PHP_URL_HOST ) ); // Return nothing if there aren't any $url parts or if the current host and $url host do not match. if ( ! isset( $parse_url[1] ) || empty( $parse_url[1] ) || ( $this_host != $file_host ) ) { return false; } // Now we're going to quickly search the DB for any attachment GUID with a partial path match. // Example: /uploads/2013/05/test-image.jpg global $wpdb; if ( !$attachment = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM {$wpdb->prefix}posts WHERE guid RLIKE %s;", $parse_url[1] ) ) ) { // Maybe it's a resized image, so try to get the full one $parse_url[1] = preg_replace( '/-[0-9]{1,4}x[0-9]{1,4}\.(jpg|jpeg|png|gif|bmp)$/i', '.$1', $parse_url[1] ); $attachment = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM {$wpdb->prefix}posts WHERE guid RLIKE %s;", $parse_url[1] ) ); } // Returns null if no attachment is found. return isset($attachment[0]) ? $attachment[0] : NULL; } // __get_attachment_id /** * Fetchs external images. * * @since 2.3.3 * @param string url * @return bool|int */ private function __fetch_external_image($id, $url){ $full_image_path = trailingslashit( $this->uploads_dir['basedir'] ) . "{$id}_". sanitize_file_name( rawurldecode(wp_basename( $url )) ); // if the file exists already, return URL and path if ( file_exists($full_image_path) ) return $full_image_path; $accepted_status_codes = array( 200, 301, 302 ); $response = wp_remote_head( $url, array( 'timeout' => 5, 'sslverify' => false ) ); if ( !is_wp_error($response) && in_array(wp_remote_retrieve_response_code($response), $accepted_status_codes) ) { require_once( ABSPATH . 'wp-admin/includes/file.php' ); $url = str_replace( 'https://', 'http://', $url ); $tmp = download_url( $url ); if ( !is_wp_error( $tmp ) ) { if ( function_exists('exif_imagetype') ) { $image_type = exif_imagetype( $tmp ); } else { $image_type = getimagesize( $tmp ); $image_type = ( isset($image_type[2]) ) ? $image_type[2] : NULL; } if ( in_array($image_type, array(IMAGETYPE_GIF, IMAGETYPE_JPEG, IMAGETYPE_PNG)) ) { // move file to Uploads if ( @rename($tmp, $full_image_path) ) { // borrowed from WP - set correct file permissions $stat = stat( dirname( $full_image_path )); $perms = $stat['mode'] & 0000644; @chmod( $full_image_path, $perms ); return $full_image_path; } } // remove temp file @unlink( $tmp ); } } return false; } // end __fetch_external_image /** * Builds post's excerpt * * @since 1.4.6 * @global object wpdb * @param int post ID * @param array widget instance * @return string */ protected function _get_summary($id, $instance){ if ( !$this->__is_numeric($id) ) return false; global $wpdb; $excerpt = ""; // WPML support, get excerpt for current language if ( defined('ICL_LANGUAGE_CODE') && function_exists('icl_object_id') ) { $current_id = icl_object_id( $id, get_post_type( $id ), true, ICL_LANGUAGE_CODE ); $the_post = get_post( $current_id ); $excerpt = ( empty($the_post->post_excerpt) ) ? $the_post->post_content : $the_post->post_excerpt; } // Use ol' plain excerpt else { $the_post = get_post( $id ); $excerpt = ( empty($the_post->post_excerpt) ) ? $the_post->post_content : $the_post->post_excerpt; // RRR added call to the_content filters, allows qTranslate to hook in. if ( $this->qTrans ) $excerpt = qtrans_useCurrentLanguageIfNotFoundUseDefaultLanguage( $excerpt ); } // remove caption tags $excerpt = preg_replace( "/\[caption.*\[\/caption\]/", "", $excerpt ); // remove Flash objects $excerpt = preg_replace( "/<object[0-9 a-z_?*=\":\-\/\.#\,\\n\\r\\t]+/smi", "", $excerpt ); // remove Iframes $excerpt = preg_replace( "/<iframe.*?\/iframe>/i", "", $excerpt); // remove WP shortcodes $excerpt = strip_shortcodes( $excerpt ); // remove style/script tags $excerpt = preg_replace( '@<(script|style)[^>]*?>.*?</\\1>@si', '', $excerpt ); // remove HTML tags if requested if ( $instance['post-excerpt']['keep_format'] ) { $excerpt = strip_tags($excerpt, '<a><b><i><em><strong>'); } else { $excerpt = strip_tags($excerpt); // remove URLs, too $excerpt = preg_replace( '_^(?:(?:https?|ftp)://)(?:\S+(?::\S*)?@)?(?:(?!10(?:\.\d{1,3}){3})(?!127(?:\.\d{1,3}){3})(?!169\.254(?:\.\d{1,3}){2})(?!192\.168(?:\.\d{1,3}){2})(?!172\.(?:1[6-9]|2\d|3[0-1])(?:\.\d{1,3}){2})(?:[1-9]\d?|1\d\d|2[01]\d|22[0-3])(?:\.(?:1?\d{1,2}|2[0-4]\d|25[0-5])){2}(?:\.(?:[1-9]\d?|1\d\d|2[0-4]\d|25[0-4]))|(?:(?:[a-z\x{00a1}-\x{ffff}0-9]+-?)*[a-z\x{00a1}-\x{ffff}0-9]+)(?:\.(?:[a-z\x{00a1}-\x{ffff}0-9]+-?)*[a-z\x{00a1}-\x{ffff}0-9]+)*(?:\.(?:[a-z\x{00a1}-\x{ffff}]{2,})))(?::\d{2,5})?(?:/[^\s]*)?$_iuS', '', $excerpt ); } // Fix RSS CDATA tags $excerpt = str_replace( ']]>', ']]>', $excerpt ); // do we still have something to display? if ( !empty($excerpt) ) { // truncate excerpt if ( isset($instance['post-excerpt']['words']) && $instance['post-excerpt']['words'] ) { // by words $words = explode(" ", $excerpt, $instance['post-excerpt']['length'] + 1); if ( count($words) > $instance['post-excerpt']['length'] ) { array_pop($words); $excerpt = rtrim( implode(" ", $words), ".," ) . " ..."; } } else { // by characters if ( strlen($excerpt) > $instance['post-excerpt']['length'] ) { $excerpt = rtrim( mb_substr( $excerpt, 0, $instance['post-excerpt']['length'], $this->charset ), ".," ) . "..."; } } } // Balance tags, if needed if ( $instance['post-excerpt']['keep_format'] ) { $excerpt = force_balance_tags($excerpt); } return $excerpt; } // _get_summary /** * WPP shortcode handler * Since 2.0.0 */ public function shortcode($atts = null, $content = null) { /** * @var String $header * @var Int $limit * @var String $range * @var Bool $freshness * @var String $order_by * @var String $post_type * @var String $pid * @var String $cat * @var String $author * @var Int $title_length * @var Int $title_by_words * @var Int $excerpt_length * @var Int $excerpt_format * @var Int $excerpt_by_words * @var Int $thumbnail_width * @var Int $thumbnail_height * @var Bool $rating * @var Bool $stats_comments * @var Bool $stats_views * @var Bool $stats_author * @var Bool $stats_date * @var String $stats_date_format * @var Bool $stats_category * @var String $wpp_start * @var String $wpp_end * @var String $header_start * @var String $header_end * @var String $post_html * @var Bool $php */ extract( shortcode_atts( array( 'header' => '', 'limit' => 10, 'range' => 'daily', 'freshness' => false, 'order_by' => 'views', 'post_type' => 'post,page', 'pid' => '', 'cat' => '', 'author' => '', 'title_length' => 0, 'title_by_words' => 0, 'excerpt_length' => 0, 'excerpt_format' => 0, 'excerpt_by_words' => 0, 'thumbnail_width' => 0, 'thumbnail_height' => 0, 'rating' => false, 'stats_comments' => false, 'stats_views' => true, 'stats_author' => false, 'stats_date' => false, 'stats_date_format' => 'F j, Y', 'stats_category' => false, 'wpp_start' => '<ul class="wpp-list">', 'wpp_end' => '</ul>', 'header_start' => '<h2>', 'header_end' => '</h2>', 'post_html' => '', 'php' => false ), $atts, 'wpp')); // possible values for "Time Range" and "Order by" $range_values = array("yesterday", "daily", "weekly", "monthly", "all"); $order_by_values = array("comments", "views", "avg"); $shortcode_ops = array( 'title' => strip_tags($header), 'limit' => (!empty($limit) && $this->__is_numeric($limit) && $limit > 0) ? $limit : 10, 'range' => (in_array($range, $range_values)) ? $range : 'daily', 'freshness' => empty($freshness) ? false : $freshness, 'order_by' => (in_array($order_by, $order_by_values)) ? $order_by : 'views', 'post_type' => empty($post_type) ? 'post,page' : $post_type, 'pid' => preg_replace('|[^0-9,]|', '', $pid), 'cat' => preg_replace('|[^0-9,-]|', '', $cat), 'author' => preg_replace('|[^0-9,]|', '', $author), 'shorten_title' => array( 'active' => (!empty($title_length) && $this->__is_numeric($title_length) && $title_length > 0), 'length' => (!empty($title_length) && $this->__is_numeric($title_length)) ? $title_length : 0, 'words' => (!empty($title_by_words) && $this->__is_numeric($title_by_words) && $title_by_words > 0), ), 'post-excerpt' => array( 'active' => (!empty($excerpt_length) && $this->__is_numeric($excerpt_length) && ($excerpt_length > 0)), 'length' => (!empty($excerpt_length) && $this->__is_numeric($excerpt_length)) ? $excerpt_length : 0, 'keep_format' => (!empty($excerpt_format) && $this->__is_numeric($excerpt_format) && ($excerpt_format > 0)), 'words' => (!empty($excerpt_by_words) && $this->__is_numeric($excerpt_by_words) && $excerpt_by_words > 0), ), 'thumbnail' => array( 'active' => (!empty($thumbnail_width) && $this->__is_numeric($thumbnail_width) && $thumbnail_width > 0), 'width' => (!empty($thumbnail_width) && $this->__is_numeric($thumbnail_width) && $thumbnail_width > 0) ? $thumbnail_width : 0, 'height' => (!empty($thumbnail_height) && $this->__is_numeric($thumbnail_height) && $thumbnail_height > 0) ? $thumbnail_height : 0, ), 'rating' => empty($rating) ? false : $rating, 'stats_tag' => array( 'comment_count' => empty($stats_comments) ? false : $stats_comments, 'views' => empty($stats_views) ? false : $stats_views, 'author' => empty($stats_author) ? false : $stats_author, 'date' => array( 'active' => empty($stats_date) ? false : $stats_date, 'format' => empty($stats_date_format) ? 'F j, Y' : $stats_date_format ), 'category' => empty($stats_category) ? false : $stats_category, ), 'markup' => array( 'custom_html' => true, 'wpp-start' => empty($wpp_start) ? '<ul class="wpp-list">' : $wpp_start, 'wpp-end' => empty($wpp_end) ? '</ul>' : $wpp_end, 'title-start' => empty($header_start) ? '' : $header_start, 'title-end' => empty($header_end) ? '' : $header_end, 'post-html' => empty($post_html) ? '<li>{thumb} {title} {stats}</li>' : $post_html ) ); $shortcode_content = "\n". "<!-- WordPress Popular Posts Plugin v". $this->version ." [" . ( $php ? "PHP" : "SC" ) . "] [".$shortcode_ops['range']."] [".$shortcode_ops['order_by']."] [custom]" . ( !empty($shortcode_ops['pid']) ? " [PID]" : "" ) . ( !empty($shortcode_ops['cat']) ? " [CAT]" : "" ) . ( !empty($shortcode_ops['author']) ? " [UID]" : "" ) . " -->"."\n"; // is there a title defined by user? if (!empty($header) && !empty($header_start) && !empty($header_end)) { $shortcode_content .= htmlspecialchars_decode($header_start, ENT_QUOTES) . apply_filters('widget_title', $header) . htmlspecialchars_decode($header_end, ENT_QUOTES); } // print popular posts list $shortcode_content .= $this->__get_popular_posts($shortcode_ops); $shortcode_content .= "\n". "<!-- End WordPress Popular Posts Plugin v". $this->version ." -->"."\n"; return $shortcode_content; } // end shortcode /** * Parses content tags * * @since 1.4.6 * @param string HTML string with content tags * @param array Post data * @param bool Used to display post rating (if functionality is available) * @return string */ private function __format_content($string, $data = array(), $rating) { if (empty($string) || (empty($data) || !is_array($data))) return false; $params = array(); $pattern = '/\{(pid|excerpt|summary|stats|title|image|thumb|thumb_img|rating|score|url|text_title|author|category|views|comments|date)\}/i'; preg_match_all($pattern, $string, $matches); array_map('strtolower', $matches[0]); if ( in_array("{pid}", $matches[0]) ) { $string = str_replace( "{pid}", $data['id'], $string ); } if ( in_array("{title}", $matches[0]) ) { $string = str_replace( "{title}", $data['title'], $string ); } if ( in_array("{stats}", $matches[0]) ) { $string = str_replace( "{stats}", $data['stats'], $string ); } if ( in_array("{excerpt}", $matches[0]) || in_array("{summary}", $matches[0]) ) { $string = str_replace( array("{excerpt}", "{summary}"), $data['summary'], $string ); } if ( in_array("{image}", $matches[0]) || in_array("{thumb}", $matches[0]) ) { $string = str_replace( array("{image}", "{thumb}"), $data['img'], $string ); } if ( in_array("{thumb_img}", $matches[0]) ) { $string = str_replace( "{thumb_img}", $data['img_no_link'], $string ); } // WP-PostRatings check if ( $rating ) { if ( function_exists('the_ratings_results') && in_array("{rating}", $matches[0]) ) { $string = str_replace( "{rating}", the_ratings_results($data['id']), $string ); } if ( function_exists('expand_ratings_template') && in_array("{score}", $matches[0]) ) { $string = str_replace( "{score}", expand_ratings_template('%RATINGS_SCORE%', $data['id']), $string); // removing the redundant plus sign $string = str_replace('+', '', $string); } } if ( in_array("{url}", $matches[0]) ) { $string = str_replace( "{url}", $data['url'], $string ); } if ( in_array("{text_title}", $matches[0]) ) { $string = str_replace( "{text_title}", $data['text_title'], $string ); } if ( in_array("{author}", $matches[0]) ) { $string = str_replace( "{author}", $data['author'], $string ); } if ( in_array("{category}", $matches[0]) ) { $string = str_replace( "{category}", $data['category'], $string ); } if ( in_array("{views}", $matches[0]) ) { $string = str_replace( "{views}", $data['views'], $string ); } if ( in_array("{comments}", $matches[0]) ) { $string = str_replace( "{comments}", $data['comments'], $string ); } if ( in_array("{date}", $matches[0]) ) { $string = str_replace( "{date}", $data['date'], $string ); } return $string; } // end __format_content /** * Returns HTML list via AJAX * * @since 2.3.3 * @return string */ public function get_popular( ) { if ( $this->__is_numeric($_GET['id']) && ($_GET['id'] != '') ) { $id = $_GET['id']; } else { die("Invalid ID"); } $widget_instances = $this->get_settings(); if ( isset($widget_instances[$id]) ) { echo $this->__get_popular_posts( $widget_instances[$id] ); } else { echo "Invalid Widget ID"; } exit(); } // end get_popular /*--------------------------------------------------*/ /* Helper functions /*--------------------------------------------------*/ /** * Gets list of available thumbnails sizes * * @since 3.2.0 * @link http://codex.wordpress.org/Function_Reference/get_intermediate_image_sizes * @param string $size * @return array|bool */ private function __get_image_sizes( $size = '' ) { global $_wp_additional_image_sizes; $sizes = array(); $get_intermediate_image_sizes = get_intermediate_image_sizes(); // Create the full array with sizes and crop info foreach( $get_intermediate_image_sizes as $_size ) { if ( in_array( $_size, array( 'thumbnail', 'medium', 'large' ) ) ) { $sizes[ $_size ]['width'] = get_option( $_size . '_size_w' ); $sizes[ $_size ]['height'] = get_option( $_size . '_size_h' ); $sizes[ $_size ]['crop'] = (bool) get_option( $_size . '_crop' ); } elseif ( isset( $_wp_additional_image_sizes[ $_size ] ) ) { $sizes[ $_size ] = array( 'width' => $_wp_additional_image_sizes[ $_size ]['width'], 'height' => $_wp_additional_image_sizes[ $_size ]['height'], 'crop' => $_wp_additional_image_sizes[ $_size ]['crop'] ); } } // Get only 1 size if found if ( $size ) { if( isset( $sizes[ $size ] ) ) { return $sizes[ $size ]; } else { return false; } } return $sizes; } /** * Gets post/page ID if current page is singular * * @since 3.1.2 */ public function is_single() { $trackable = array(); $registered_post_types = get_post_types( array('public' => true), 'names' ); foreach ( $registered_post_types as $post_type ) { $trackable[] = $post_type; } $trackable = apply_filters( 'wpp_trackable_post_types', $trackable ); if ( is_singular($trackable) && !is_front_page() && !is_preview() && !is_trackback() && !is_feed() && !is_robots() ) { global $post; $this->current_post_id = ( is_object($post) ) ? $post->ID : 0; } else { $this->current_post_id = 0; } } // end is_single /** * Checks for valid number * * @since 2.1.6 * @param int number * @return bool */ private function __is_numeric($number){ return !empty($number) && is_numeric($number) && (intval($number) == floatval($number)); } /** * Returns server datetime * * @since 2.1.6 * @return string */ private function __curdate() { return gmdate( 'Y-m-d', ( time() + ( get_site_option( 'gmt_offset' ) * 3600 ) )); } // end __curdate /** * Returns mysql datetime * * @since 2.1.6 * @return string */ private function __now() { return current_time('mysql'); } // end __now /** * Returns time * * @since 2.3.0 * @return string */ private function __microtime_float() { list( $msec, $sec ) = explode( ' ', microtime() ); $microtime = (float) $msec + (float) $sec; return $microtime; } // end __microtime_float /** * Merges two associative arrays recursively * * @since 2.3.4 * @link http://www.php.net/manual/en/function.array-merge-recursive.php#92195 * @param array array1 * @param array array2 * @return array */ private function __merge_array_r( array &$array1, array &$array2 ) { $merged = $array1; foreach ( $array2 as $key => &$value ) { if ( is_array( $value ) && isset ( $merged[$key] ) && is_array( $merged[$key] ) ) { $merged[$key] = $this->__merge_array_r( $merged[$key], $value ); } else { $merged[$key] = $value; } } return $merged; } // end __merge_array_r /** * Checks if visitor is human or bot. * * @since 3.0.0 * @return bool FALSE if human, TRUE if bot */ private function __is_bot() { if ( !isset($_SERVER['HTTP_USER_AGENT']) || empty($_SERVER['HTTP_USER_AGENT']) ) return true; // No UA? Bot (probably) $user_agent = strtolower($_SERVER['HTTP_USER_AGENT']); foreach ( $this->botlist as $bot ) { if ( false !== strpos($user_agent, $bot) ) { return true; // Bot } } return false; // Human, I guess... } // end __is_bot /** * Debug function. * * @since 3.0.0 * @param mixed $v variable to display with var_dump() * @param mixed $v,... unlimited optional number of variables to display with var_dump() */ private function __debug($v) { if ( !defined('WPP_DEBUG') || !WPP_DEBUG ) return; foreach (func_get_args() as $arg) { print "<pre>"; var_dump($arg); print "</pre>"; } } // end __debug } // end class } /** * WordPress Popular Posts template tags for use in themes. */ /** * Template tag - gets views count. * * @since 2.0.3 * @global object wpdb * @param int id * @param string range * @param bool number_format * @return string */ function wpp_get_views($id = NULL, $range = NULL, $number_format = true) { // have we got an id? if ( empty($id) || is_null($id) || !is_numeric($id) ) { return "-1"; } else { global $wpdb; $table_name = $wpdb->prefix . "popularposts"; if ( !$range || 'all' == $range ) { $query = "SELECT pageviews FROM {$table_name}data WHERE postid = '{$id}'"; } else { $interval = ""; switch( $range ){ case "yesterday": $interval = "1 DAY"; break; case "daily": $interval = "1 DAY"; break; case "weekly": $interval = "1 WEEK"; break; case "monthly": $interval = "1 MONTH"; break; default: $interval = "1 DAY"; break; } $now = current_time('mysql'); $query = "SELECT SUM(pageviews) FROM {$table_name}summary WHERE postid = '{$id}' AND last_viewed > DATE_SUB('{$now}', INTERVAL {$interval}) LIMIT 1;"; } $result = $wpdb->get_var($query); if ( !$result ) { return "0"; } return ($number_format) ? number_format_i18n( intval($result) ) : $result; } } /** * Template tag - gets popular posts. * * @since 2.0.3 * @param mixed args */ function wpp_get_mostpopular($args = NULL) { $shortcode = '[wpp'; if ( is_null( $args ) ) { $shortcode .= ']'; } else { if( is_array( $args ) ){ $atts = ''; foreach( $args as $key => $arg ){ $atts .= ' ' . $key . '="' . htmlspecialchars($arg, ENT_QUOTES, $encoding = ini_get("default_charset"), false) . '"'; } } else { $atts = trim( str_replace( "&", " ", $args ) ); } $shortcode .= ' ' . $atts . ' php=true]'; } echo do_shortcode( $shortcode ); } /** * Template tag - gets popular posts. Deprecated in 2.0.3, use wpp_get_mostpopular instead. * * @since 1.0 * @param mixed args */ function get_mostpopular($args = NULL) { trigger_error( 'The get_mostpopular() template tag has been deprecated since 2.0.3. Please use wpp_get_mostpopular() instead.', E_USER_WARNING ); }