"; else $error_msg='';
$user_info=get_userdata(atb_cui());
$email=$user_info->user_email;?>
Two Factor Authentication
query("DELETE pg
FROM wp_atb_pagehits pg
JOIN (
SELECT MAX(hit_id) as hit_id
FROM wp_atb_pagehits
WHERE userid<1
AND date < NOW()-INTERVAL 30 DAY
GROUP BY LEFT(date,10),ip,userid,url,referrer
HAVING COUNT(ip)>1
ORDER BY hit_id ASC
LIMIT 1000
)mx ON mx.hit_id=pg.hit_id;");
}
$mth_query="
SELECT DATE_FORMAT(CONCAT(month,'-01'),'%b %y') as month
,month as month_id,visitors
,ROUND(visitors/CASE WHEN month=DATE_FORMAT(NOW(),'%Y-%m') THEN DAY(NOW()) ELSE 30 END,0) as day_avg
FROM (
SELECT LEFT(date,7) as month,COUNT(DISTINCT ip) as visitors
FROM wp_atb_pagehits
WHERE date>NOW()-INTERVAL 400 DAY
GROUP BY LEFT(date,7)
)a
ORDER BY DATE_FORMAT(CONCAT(month,'-01'),'%y-%m');";
$mth=atb_r($mth_query);
$day_query="
SELECT DATE_FORMAT(date,'%a %D') as day
,date as date_id
,DATE_FORMAT(CONCAT(date,'-01'),'%b %y') as month,visitors
,visitors
FROM (
SELECT LEFT(date,10) as date,COUNT(DISTINCT ip) as visitors
FROM wp_atb_pagehits
WHERE date>NOW()-INTERVAL 400 DAY
GROUP BY LEFT(date,10)
)a
ORDER BY date;";
$day=atb_r($day_query);
$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;} ?>
0) $uid_criteria="AND userid='$uid'";
if(strlen($date)>0) $date_criteria="AND LEFT(DATE_ADD(date,INTERVAL -5 HOUR),10)='$date'";
if(strlen($url)>0) $url_criteria="AND url LIKE '$url%'";
global $wpdb;
$hit_query="
SELECT hit_id,DATE_ADD(date,INTERVAL -5 HOUR) as date,ip,userid,url,referrer
,IFNULL(
CONCAT(
COALESCE(
CONCAT((SELECT meta_value FROM {$wpdb->base_prefix}usermeta WHERE user_id=u.ID AND meta_key='first_name' AND LENGTH(meta_value)>0)
,(SELECT CONCAT(' ',meta_value) FROM {$wpdb->base_prefix}usermeta WHERE user_id=u.ID AND meta_key='last_name' AND LENGTH(meta_value)>0))
,(SELECT meta_value FROM {$wpdb->base_prefix}usermeta WHERE user_id=u.ID AND meta_key='nickname' AND LENGTH(meta_value)>0)
,u.display_name
)
,' (',user_email,')')
,'Visitor') as user
FROM (
SELECT hit_id,date,ip,userid,url,referrer
FROM wp_atb_pagehits ph
WHERE 1=1
$uid_criteria
$date_criteria
$url_criteria
ORDER BY 1 DESC
LIMIT $row_limit
)a
LEFT JOIN {$wpdb->base_prefix}users u ON u.ID=a.userid; ";
$hits=atb_r($hit_query);
$date_query="
SELECT DISTINCT DATE_FORMAT(DATE_ADD(date,INTERVAL -5 HOUR),'%Y-%m-%d') as date
FROM wp_atb_pagehits
WHERE date>NOW()-INTERVAL 400 DAY
ORDER BY 1 DESC; ";
$dates=atb_r($date_query);
$user_query="
SELECT userid
,IFNULL(
CONCAT(
COALESCE(
CONCAT((SELECT meta_value FROM {$wpdb->base_prefix}usermeta WHERE user_id=u.ID AND meta_key='first_name' AND LENGTH(meta_value)>0)
,(SELECT CONCAT(' ',meta_value) FROM {$wpdb->base_prefix}usermeta WHERE user_id=u.ID AND meta_key='last_name' AND LENGTH(meta_value)>0))
,(SELECT meta_value FROM {$wpdb->base_prefix}usermeta WHERE user_id=u.ID AND meta_key='nickname' AND LENGTH(meta_value)>0)
,u.display_name
)
,' (',user_email,')')
,'Visitor') as user
FROM (SELECT DISTINCT userid FROM wp_atb_pagehits) ph
LEFT JOIN {$wpdb->base_prefix}users u ON u.ID=ph.userid
ORDER BY user; ";
$users=atb_r($user_query);
$url_query="
SELECT * FROM (
SELECT DISTINCT url
FROM wp_atb_pagehits
WHERE LOCATE('?',url)=0
UNION
SELECT DISTINCT LEFT(url,INSTR(url,'?')-1) as url
FROM wp_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=atb_r($url_query);
?>