[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 )
  35          {
  36              $out = '';
  37  
  38              foreach( $tracks as $track )
  39              {
  40                  $args = array( 'id' => $track->mail_id, 'mp_user_id' => $mp_user->id, 'key' => $mp_user->confkey , 'action' => 'mp_ajax', 'mp_action' => 'iview', 'TB_iframe' => 'true' );
  41                  $view_url = esc_url( add_query_arg( $args, admin_url( 'admin-ajax.php' ) ) );    
  42  
  43                    $subject    = $wpdb->get_var( $wpdb->prepare( "SELECT subject FROM $wpdb->mp_mails WHERE id = %d ;", $track->mail_id ) );
  44                  if ( $subject )
  45                  {
  46                      $subject     = $x->viewsubject( $subject, $track->mail_id, $track->mail_id, $mp_user->id );
  47                      $out .= '( ' . $track->count . ' ) <a href="' . $view_url . '" class="thickbox thickbox-preview" title="' . esc_attr( sprintf( __( 'View &#8220;%1$s&#8221;', 'MailPress' ) , ( $subject ) ? $subject : $track->mail_id ) ) . '">' . ( ( $subject ) ? $subject : $track->mail_id ) . '</a> <br />';
  48                  }
  49                  else
  50                  {
  51                      $out .= "( {$track->count} )  {$track->mail_id} <br />";
  52                  }
  53              }
  54  
  55              echo $out;
  56          }
  57      }
  58  }
  59  new MP_Tracking_metabox_u008( __( 'Most clicked', 'MailPress' ) );