function getUrl($report, $url) { global $wpdb; $table = SendPress_Data::report_url_table(); $result = $this->wpdbQuery($wpdb->prepare("SELECT * FROM {$table} WHERE reportID = %d AND url = %s ", $report, $url), 'get_results'); return $result; }
static function get_report_export($rid) { global $wpdb; $event_table = SendPress_Data::subscriber_event_table(); $sub_table = SendPress_Data::subscriber_table(); $url_table = SendPress_Data::report_url_table(); return $wpdb->get_results($wpdb->prepare("SELECT sev.eventdate,sev.ip,sev.`devicetype`,sev.`device`, sev.type ,subs.email,rurl.url from " . $event_table . " AS sev INNER JOIN " . $sub_table . " AS subs on sev.subscriberID = subs.subscriberID LEFT JOIN " . $url_table . " AS rurl on sev.urlID = rurl.urlID where sev.reportID = %d and sev.subscriberID > 0 and sev.type != 'send'", $rid)); }
function report_url_table() { _deprecated_function(__FUNCTION__, '0.8.9', 'SendPress_Data::report_url_table()'); return SendPress_Data::report_url_table(); }