[ Index ]

MailPress 7.1

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

title

Body

[close]

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

   1  <?php
   2  class MP_Tracking_metabox_m002all extends MP_tracking_metabox_
   3  {
   4      var $id    = 'm002all';
   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;", $mail->id ) );
  12  
  13          if ( $tracks ) 
  14          {
  15              $out = '<div class="mp_scroll"><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="' . __( 'See tracking results', 'MailPress' ) . '">' . MP_User::get_email( $track->user_id ) . '</a>';
  20                  $out .= '<tr><td><abbr title="' . $track->tmstp . '">' . substr( $track->tmstp, 0, 10 ) . '</abbr></td><td>&#160;' . $action . '</td></tr>';
  21              }
  22              $out .= '</table></div>';
  23  
  24              echo $out;
  25          }
  26      }
  27  }
  28  new MP_Tracking_metabox_m002all( __( 'All users', 'MailPress' ) );


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