[ Index ]

MailPress 7.1

[ Index ]     [ Classes ]     [ Functions ]     [ Variables ]     [ Constants ]     [ Statistics ]    

title

Body

[close]

/mp-includes/class/options/tracking/metaboxes/mail/ -> m002.php (source)

   1  <?php
   2  class MP_Tracking_metabox_m002 extends MP_tracking_metabox_
   3  {
   4      var $id    = 'm002';
   5      var $context= 'normal';
   6      var $file     = __FILE__;
   7  
   8  	function meta_box( $mail )
   9      {
  10          global $wpdb;
  11          $tracks = $wpdb->get_results( $wpdb->prepare( "SELECT user_id, MAX( tmstp ) as tmstp FROM $wpdb->mp_tracks WHERE mail_id = %d GROUP BY user_id ORDER BY tmstp DESC LIMIT 10;", $mail->id ) );
  12  
  13          if ( $tracks ) 
  14          {
  15              $out = '<table>';
  16              foreach( $tracks as $track )
  17              {
  18                  $tracking_url = esc_url( MP_::url( MailPress_tracking_u, array( 'id' => $track->user_id ) ) );
  19                  $action = '<a href="' . $tracking_url . '" target="_blank" title="' . esc_attr( __( 'See tracking results', 'MailPress' ) ) . '">' . MP_User::get_email( $track->user_id ) . '</a>';
  20                  $out .= '<tr><td><abbr title="' . esc_attr( $track->tmstp ) . '">' . substr( $track->tmstp, 0, 10 ) . '</abbr></td><td>&#160;' . $action . '</td></tr>';
  21              }
  22              $out .= '</table>';
  23              echo $out;
  24          }
  25      }
  26  }
  27  new MP_Tracking_metabox_m002( __( 'Last 10 mails', 'MailPress' ) );


Generated: Mon Mar 11 18:33:33 2019 Cross-referenced by PHPXref 0.7.1