"; else $error_msg=''; ?>
Two Factor Authentication
1
ORDER BY hit_id ASC
LIMIT 1000
)mx ON mx.hit_id=pg.hit_id;");
return $r;
}
// PageHit Summary
function atb_view_summary($atb_version_type) {
if(isset($_SESSION["limit_img_size_kb"])) unset($_SESSION["limit_img_size_kb"]);
if(!empty($_REQUEST['compress'])) $compress_result=atb_compress_hits();
$current_mth=current_time('Y-m-01');
$last_gen_mth=get_transient('atb_mth_max');
if(!$last_gen_mth) $last_gen_mth=$current_mth;
$mth=get_transient('atb_mth'); // Find Historical Month Stats
if(!$mth) { // Create Historical Month Stats
$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
AND date<'$current_mth'
GROUP BY LEFT(date,7)
)a
ORDER BY DATE_FORMAT(CONCAT(month,'-01'),'%y-%m');";
$mth=atb_r($mth_query);
set_transient('atb_mth',$mth,999999999);
set_transient('atb_mth_max',$current_mth,999999999);
}
// Get Month Stats since last Gen Date
$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
AND date>='$last_gen_mth'
GROUP BY LEFT(date,7)
)a
ORDER BY DATE_FORMAT(CONCAT(month,'-01'),'%y-%m');";
$mth_new=atb_r($mth_query);
if(is_array($mth_new))$mth=array_merge($mth,$mth_new);
if($current_mth>$last_gen_mth) { // Append Historical with Current
set_transient('atb_mth',$mth,999999999);
set_transient('atb_mth_max',$current_mth,999999999);
}
$current_day=current_time('Y-m-d');
$last_gen_day=get_transient('atb_day_max');
if(!$last_gen_day) $last_gen_day=$current_day;
$day=get_transient('atb_day'); // Find Historical Day Stats
if(!$day) { // Create Historical Day Stats
$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
AND date<'$current_day'
GROUP BY LEFT(date,10)
)a
ORDER BY date;";
$day=atb_r($day_query);
set_transient('atb_day',$day,999999999);
set_transient('atb_day_max',$current_day,999999999);
}
// Get Day Stats since last Gen Date
$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
AND date>='$last_gen_day'
GROUP BY LEFT(date,10)
)a
ORDER BY date;";
$day_new=atb_r($day_query);
if(is_array($day_new))$day=array_merge($day,$day_new); // Append Historical with Current
if($current_day>$last_gen_day) {
set_transient('atb_day',$day,999999999);
set_transient('atb_day_max',$current_day,999999999);
}
$max_visit_avg=0;
$max_visit_tot=0;
if($mth) 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;} ?>