function get_clicks_and_opens($rid)
 {
     global $wpdb;
     $table = SendPress_Data::subscriber_event_table();
     $result = $this->wpdbQuery($wpdb->prepare("SELECT * FROM {$table} WHERE reportID = %d ORDER BY eventID DESC;", $rid), 'get_results');
     return $result;
 }
 static function get_last_send($sid)
 {
     global $wpdb;
     $table = SendPress_Data::subscriber_event_table();
     //SELECT * FROM table_name WHERE MONTH(date_column) = 4;
     $result = $wpdb->get_var($wpdb->prepare("SELECT reportID FROM {$table} WHERE type = 'send' AND subscriberID = %d ORDER BY eventdate DESC", $sid));
     return $result;
 }
示例#3
0
 function subscriber_event_table()
 {
     _deprecated_function(__FUNCTION__, '0.8.9', 'SendPress_Data::subscriber_event_table()');
     return SendPress_Data::subscriber_event_table();
 }