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; }
function subscriber_event_table() { _deprecated_function(__FUNCTION__, '0.8.9', 'SendPress_Data::subscriber_event_table()'); return SendPress_Data::subscriber_event_table(); }