[Summary view] [Print] [Text view]

   1  <?php
   2  class MP_Tracking_metabox_u008 extends MP_tracking_metabox_
   3  {
   4      var $id    = 'u008';
   5      var $context= 'side';
   6      var $file     = __FILE__;
   7  
   8  	function __construct($title)
   9      {
  10          add_filter('MailPress_scripts', array($this, 'scripts'), 8, 2);
  11          add_filter('MailPress_styles',  array($this, 'styles'),  8, 2);
  12          parent::__construct($title);
  13      }
  14  
  15  	function styles($styles) 
  16      {
  17          $styles[] = 'thickbox';
  18          return $styles;
  19      }
  20  
  21  	function scripts($scripts)
  22      {
  23          wp_register_script( 'mp-thickbox',         '/' . MP_PATH . 'mp-includes/js/mp_thickbox.js', array('thickbox'), false, 1);
  24          $scripts[] = 'mp-thickbox';
  25          return $scripts;
  26      }
  27  
  28  	function meta_box($mp_user)
  29      {
  30          global $wpdb;
  31          $x = new MP_Mail();
  32  
  33          $tracks = $wpdb->get_results( $wpdb->prepare( "SELECT mail_id, count(*) as count FROM $wpdb->mp_tracks WHERE user_id = %d AND track <> '_MailPress_mail_opened' AND mail_id <> 0 GROUP BY 1 ORDER BY 2 DESC, 1 DESC LIMIT 10;", $mp_user->id) );
  34          if ($tracks) foreach($tracks as $track)
  35          {
  36              $view_url    = esc_url(add_query_arg( array('action' => 'iview', 'id' => $track->mail_id, 'mp_user_id' => $mp_user->id, 'key' => $mp_user->confkey, 'preview_iframe' => 1, 'TB_iframe' => 'true'), MP_Action_url ));
  37              $subject    = $wpdb->get_var($wpdb->prepare( "SELECT subject FROM $wpdb->mp_mails WHERE id = %d ;", $track->mail_id));
  38              if ($subject)
  39              {
  40                  $subject     = $x->viewsubject($subject, $track->mail_id, $track->mail_id, $mp_user->id);
  41                  echo "({$track->count}) <a href='$view_url' class='thickbox thickbox-preview'  title='" . sprintf( __('View "%1$s"', MP_TXTDOM) , ($subject) ? $subject : $track->mail_id ) . "'>" . (($subject) ? $subject : $track->mail_id) . '</a> <br />';
  42              }
  43              else
  44              {
  45                  echo "({$track->count})  {$track->mail_id} <br />";
  46              }
  47          }
  48      }
  49  }
  50  new MP_Tracking_metabox_u008(__('Most clicked', MP_TXTDOM));