Today's Page Loadsget_var("SELECT FORMAT(SUM(hit_count), 0) FROM $bsuite->hits_targets WHERE hit_date = CURDATE() AND object_type IN (0,1)"); ?> |
|
Avg Daily Loadsget_var("SELECT FORMAT((SUM(hit_count)/ ((TO_DAYS(CURDATE()) - TO_DAYS(MIN(hit_date))) + 1)), 0) FROM $bsuite->hits_targets WHERE hit_date > '$date' AND object_type IN (0,1)"); ?> |
|
Today's Predictionget_var("SELECT FORMAT(SUM(hit_count) * (86400/TIME_TO_SEC(TIME(NOW()))), 0) FROM $bsuite->hits_targets WHERE hit_date = CURDATE() AND object_type IN (0,1)"); ?> |
|
Total Page Loadsget_var("SELECT FORMAT(SUM(hit_count), 0) FROM $bsuite->hits_targets WHERE object_type IN (0,1)"); ?> |
get_var( 'SELECT UNIX_TIMESTAMP( CONCAT( DATE( NOW()), " ", HOUR( NOW()), ":00:00" ))' );
$sessions = $pageloads = $hours = array();
for($i = 0; $i <= 23; $i++)
$sessions[ $now - ( $i * 60 * 60 ) ] = $pageloads[ $now - ( $i * 60 * 60 ) ] = 0;
ksort( $sessions );
ksort( $pageloads );
foreach( $pageloads as $key => $val )
$hours[] = date('H', $key);
$dates = $wpdb->get_col( "SELECT sess_date
FROM (
SELECT sess_id, sess_date AS sess_timestamp, DATE(sess_date) AS sess_date, HOUR(sess_date) AS sess_hour
FROM $bsuite->hits_sessions
ORDER BY sess_id DESC
LIMIT 12500
) a
WHERE sess_timestamp >= DATE_SUB( NOW(), INTERVAL 1 DAY )
GROUP BY sess_date, sess_hour" );
$sessions_db = $wpdb->get_results( "SELECT COUNT(*) AS hit_count, UNIX_TIMESTAMP( CONCAT( sess_date, ' ', sess_hour, ':00:00' )) AS sess_timestamp
FROM (
SELECT sess_id, sess_date AS sess_timestamp, DATE(sess_date) AS sess_date, HOUR(sess_date) AS sess_hour
FROM $bsuite->hits_sessions
ORDER BY sess_id DESC
LIMIT 12500
) a
WHERE sess_timestamp >= DATE_SUB( NOW(), INTERVAL 1 DAY )
GROUP BY sess_date, sess_hour" );
foreach( $sessions_db as $session )
$sessions[$session->sess_timestamp] = $session->hit_count;
$pageloads_db = $wpdb->get_results( "SELECT COUNT(*) AS hit_count, UNIX_TIMESTAMP( CONCAT( sess_date, ' ', sess_hour, ':00:00' )) AS sess_timestamp
FROM (
SELECT sess_id, sess_date, sess_hour
FROM (
SELECT sess_id, sess_date AS sess_timestamp, DATE(sess_date) AS sess_date, HOUR(sess_date) AS sess_hour
FROM $bsuite->hits_sessions
ORDER BY sess_id DESC
LIMIT 12500
) a
WHERE sess_timestamp >= DATE_SUB( NOW(), INTERVAL 1 DAY )
) s
LEFT JOIN $bsuite->hits_shistory h ON h.sess_id = s.sess_id
WHERE h.object_type IN (0,1)
GROUP BY sess_date, sess_hour" );
foreach( $pageloads_db as $pageload )
$pageloads[$pageload->sess_timestamp] = $pageload->hit_count;
?>
page loads and visitors in last 24 hours:
';
$months = $wpdb->get_col( "SELECT DATE_FORMAT( MAKEDATE( YEAR( hit_date ) ,DAYOFYEAR( hit_date ) ) , '%M' )
FROM (
SELECT SUM(hit_count) AS hit_count, hit_date
FROM $bsuite->hits_targets
GROUP BY hit_date DESC
LIMIT 31
) a" );
$days = $wpdb->get_col( "SELECT DAY( hit_date )
FROM (
SELECT SUM(hit_count) AS hit_count, hit_date
FROM $bsuite->hits_targets
GROUP BY hit_date DESC
LIMIT 31
) a" );
$pageloads = $wpdb->get_col( "SELECT hit_count
FROM (
SELECT SUM(hit_count) AS hit_count, hit_date
FROM $bsuite->hits_targets
GROUP BY hit_date DESC
LIMIT 31
) a" );
?>
page loads in last month:
';
?>
Compiled: |
System Load Average: get_loadavg(); ?>