";
$user_info=get_userdata(atb_current_userid());
$email=$user_info->user_email;?>
Two Factor Authentication
prefix}atb_pagehits
GROUP BY LEFT(date,7)
)a
ORDER BY DATE_FORMAT(CONCAT(month,'-01'),'%y-%m');";
$mth=$wpdb->get_results($mth_query, OBJECT);
$day_query="
SELECT DATE_FORMAT(date,'%a %D') as day
,date as date_id
,DATE_FORMAT(CONCAT(date,'-01'),'%b %y') as month
,visitors
FROM (
SELECT LEFT(date,10) as date
,COUNT(DISTINCT ip) as visitors
FROM {$wpdb->prefix}atb_pagehits
GROUP BY LEFT(date,10)
)a
ORDER BY date;";
$day=$wpdb->get_results($day_query, OBJECT);
$max_visit_avg=0;
$max_visit_tot=0;
foreach($mth as $mth_item) if($mth_item->day_avg>$max_visit_avg) {$max_visit_avg=$mth_item->day_avg; $max_visit_tot=$mth_item->visitors;}?>
prefix}atb_pagehits ph
LEFT JOIN {$wpdb->prefix}users u ON u.ID=ph.userid
WHERE 1=1
AND (LENGTH('$uid')=0 OR userid='$uid')
AND (LENGTH('$date')=0 OR LEFT(DATE_ADD(date,INTERVAL -5 HOUR),10)='$date')
AND (LENGTH('$url')=0 OR url LIKE '$url%')
ORDER BY 1 DESC
LIMIT $row_limit;
";
$hits=$wpdb->get_results($hit_query, OBJECT);
$date_query="
SELECT DISTINCT DATE_FORMAT(DATE_ADD(date,INTERVAL -5 HOUR),'%Y-%m-%d') as date
FROM {$wpdb->prefix}atb_pagehits
ORDER BY 1 DESC
";
$dates=$wpdb->get_results($date_query, OBJECT);
$user_query="
SELECT DISTINCT userid
,IFNULL(CONCAT(u.display_name,' (',user_email,')'),'Visitor') as user
FROM {$wpdb->prefix}atb_pagehits ph
LEFT JOIN {$wpdb->prefix}users u ON u.ID=ph.userid
ORDER BY user
";
$users=$wpdb->get_results($user_query, OBJECT);
$url_query="
SELECT * FROM (
SELECT DISTINCT url
FROM {$wpdb->prefix}atb_pagehits
WHERE LOCATE('?',url)=0
UNION
SELECT DISTINCT LEFT(url,INSTR(url,'?')-1) as url
FROM {$wpdb->prefix}atb_pagehits
)ph
WHERE LENGTH(url)>1
AND LOCATE('/>',url)=0
AND LOCATE('auto-draft',url)=0
AND LOCATE('checkout/order-',url)=0
ORDER BY 1;
";
$urls=$wpdb->get_results($url_query, OBJECT);?>