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();
}
