connect_errno) {
die('Failed to connect to the database server - ' . $mysqli->connect_error);
}
#
# The db querys
#
$result = $mysqli->query('SET time_zone="+10:00"');
if (!$result) {
die('ERROR - TZ Statement');
}
// construct a new query for visits in last 24 hrs
$query= 'SELECT
COUNT(DISTINCT(idvisit)) AS visits,
COUNT(DISTINCT(idvisitor)) AS visitors
FROM
mtys_log_link_visit_action
WHERE
DATE_ADD(server_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 1 DAY )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - visits in last 24 hrs time
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$visitsToday= $row['visits'];
$visitorsToday= $row['visitors'];
}
// construct a new query for visits in last 7 days
$query= 'SELECT
COUNT(DISTINCT(idvisit)) AS visits,
COUNT(DISTINCT(idvisitor)) AS visitors
FROM
mtys_log_link_visit_action
WHERE
DATE_ADD(server_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 7 DAY )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - visits in last 7 days
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$visits7day= $row['visits'];
$visitors7day= $row['visitors'];
}
// construct a new query for visits in last 30 days
$query= 'SELECT
COUNT(DISTINCT(idvisit)) AS visits,
COUNT(DISTINCT(idvisitor)) AS visitors
FROM
mtys_log_link_visit_action
WHERE
DATE_ADD(server_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 1 MONTH )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - visits in last 30 days
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$visits30day= $row['visits'];
$visitors30day= $row['visitors'];
}
// construct a new query for visits in last year
$query= 'SELECT
COUNT(DISTINCT(idvisit)) AS visits,
COUNT(DISTINCT(idvisitor)) AS visitors
FROM
mtys_log_link_visit_action
WHERE
DATE_ADD(server_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 1 YEAR )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - visits in last year
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$visits1Year= $row['visits'];
$visitors1Year= $row['visitors'];
}
// construct a new query for visits -all time
$query= 'SELECT
COUNT(DISTINCT(idvisit)) AS visits,
COUNT(DISTINCT(idvisitor)) AS visitors
FROM
mtys_log_link_visit_action';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - visits - all time
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$visits= $row['visits'];
$visitors= $row['visitors'];
}
// construct a new query for page views in last 24 hrs
$query= 'SELECT
COUNT(idvisitor) AS page_views
FROM
mtys_log_link_visit_action
WHERE
DATE_ADD(server_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 1 DAY )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - page views in last 24 hours
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$pageViewsToday= $row['page_views'];
}
// construct a new query for page views in last 7 days
$query= 'SELECT
COUNT(idvisitor) AS page_views
FROM
mtys_log_link_visit_action
WHERE
DATE_ADD(server_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 7 DAY )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - page view in last 7 days
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$pageViews7day= $row['page_views'];
}
// construct a new query for page views in last 30 days
$query= 'SELECT
COUNT(idvisitor) AS page_views
FROM
mtys_log_link_visit_action
WHERE
DATE_ADD(server_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 1 MONTH )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - page views in last 30 days
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$pageViews30day= $row['page_views'];
}
// construct a new query for page views in last 1 year
$query= 'SELECT
COUNT(idvisitor) AS page_views
FROM
mtys_log_link_visit_action
WHERE
DATE_ADD(server_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 1 YEAR )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - page views in last year
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$pageViews1Year= $row['page_views'];
}
// construct a new query for page views -all time
$query= 'SELECT
COUNT(idvisitor) AS page_views
FROM
mtys_log_link_visit_action';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - page view - all time
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$pageViews= $row['page_views'];
}
// construct a new query for return visits in last 24 hrs
$query= 'SELECT
COUNT(DISTINCT idvisit) AS return_visits
FROM
mtys_log_visit
WHERE
visitor_returning <> 0
AND DATE_ADD(visit_last_action_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 1 DAY )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - return visits in last 24 hrs
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$returnVisitsToday= $row['return_visits'];
}
// construct a new query for return visits in last 7 days
$query= 'SELECT
COUNT(DISTINCT idvisit) AS return_visits
FROM
mtys_log_visit
WHERE
visitor_returning <> 0
AND DATE_ADD(visit_last_action_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 7 DAY )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - return visits in last 7 days
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$returnVisits7day= $row['return_visits'];
}
// construct a new query for return visits in last 30 days
$query= 'SELECT
COUNT(DISTINCT idvisit) AS return_visits
FROM
mtys_log_visit
WHERE
visitor_returning <> 0
AND DATE_ADD(visit_last_action_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 30 DAY )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - return visits in last 30 days
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$returnVisits30day= $row['return_visits'];
}
// construct a new query for return visits in last 1 year
$query= 'SELECT
COUNT(DISTINCT idvisit) AS return_visits
FROM
mtys_log_visit
WHERE
visitor_returning <> 0
AND DATE_ADD(visit_last_action_time,INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 1 YEAR )';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - return visits in last year
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$returnVisits1Year= $row['return_visits'];
}
// construct a new query for return visits -all time
$query= 'SELECT
COUNT(DISTINCT idvisit) AS return_visits
FROM
mtys_log_visit
WHERE
visitor_returning <> 0';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - return visits - all time
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$returnVisits= $row['return_visits'];
}
// construct a new query for frequent return visits in last 24 hrs
$query= '-- To return the number of regular visitors and the number of visits
SELECT COUNT(visitors) AS visitors, SUM(count_visits) as visits
FROM(
-- inner query to get all regular visitors
SELECT
idvisitor AS visitors,
count(idvisitor) as count_visits
FROM
mtys_log_visit
WHERE
visitor_returning > 0
AND DATE_ADD(visit_last_action_time, INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 1 DAY )
AND visitor_seconds_since_last <= 2592000 -- this is 30 days
GROUP BY
idvisitor
) AS Data
-- subquery to return just the visitors that have contributed to 5 % of the total frequent return visitor numbers
WHERE count_visits >= 2';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - frequent return visits in last 24 hours
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$frequentVisitorsToday= $row['visitors'];
$frequentVisitsToday= $row['visits'];
}
// construct a new query for frequent return visits in last 7 days
$query= '-- To return the number of regular visitors and the number of visits
SELECT COUNT(visitors) AS visitors, SUM(count_visits) as visits
FROM(
-- inner query to get all regular visitors
SELECT
idvisitor AS visitors,
count(idvisitor) as count_visits
FROM
mtys_log_visit
WHERE
visitor_returning > 0
AND DATE_ADD(visit_last_action_time, INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 7 DAY )
AND visitor_seconds_since_last <= 2592000 -- this is 30 days
GROUP BY
idvisitor
) AS Data
-- subquery to return just the visitors that have contributed to 5 % of the total frequent return visitor numbers
WHERE count_visits >= 4';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - frequent return visits in last 7 days
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$frequentVisitors7day= $row['visitors'];
$frequentVisits7day= $row['visits'];
}
// construct a new query for frequent return visits in last 30 days
$query= '-- To return the number of regular visitors and the number of visits
SELECT COUNT(visitors) AS visitors, SUM(count_visits) as visits
FROM(
-- inner query to get all regular visitors
SELECT
idvisitor AS visitors,
count(idvisitor) as count_visits
FROM
mtys_log_visit
WHERE
visitor_returning > 0
AND DATE_ADD(visit_last_action_time, INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 30 DAY )
AND visitor_seconds_since_last <= 2592000 -- this is 30 days
GROUP BY
idvisitor
) AS Data
-- subquery to return just the visitors that have contributed to 5 % of the total frequent return visitor numbers
WHERE count_visits >= 5
';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - frequent return visits in last 30 days
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$frequentVisitors30day= $row['visitors'];
$frequentVisits30day= $row['visits'];
}
// construct a new query for frequent return visits in last 1 year
$query= '-- To return the number of regular visitors and the number of visits
SELECT COUNT(visitors) AS visitors, SUM(count_visits) as visits
FROM(
-- inner query to get all regular visitors
SELECT
idvisitor AS visitors,
count(idvisitor) as count_visits
FROM
mtys_log_visit
WHERE
visitor_returning > 0
AND DATE_ADD(visit_last_action_time, INTERVAL 10 HOUR) >= (CURDATE() - INTERVAL 1 YEAR )
AND visitor_seconds_since_last <= 78840000 -- this is 30 days
GROUP BY
idvisitor
) AS Data
-- subquery to return just the visitors that have contributed to 5 % of the total frequent return visitor numbers
WHERE count_visits >= 5
';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - frequent return visits in last year
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$frequentVisitors1Year= $row['visitors'];
$frequentVisits1Year= $row['visits'];
}
// construct a new query for frequent return visits - all time
$query= '-- To return the number of regular visitors and the number of visits
SELECT COUNT(visitors) AS visitors, SUM(count_visits) as visits
FROM(
-- inner query to get all regular visitors
SELECT
idvisitor AS visitors,
count(idvisitor) as count_visits
FROM
mtys_log_visit
WHERE
visitor_returning > 0
AND visitor_seconds_since_last <= 2592000 -- this is 30 days
GROUP BY
idvisitor
) AS Data
-- subquery to return just the visitors that have contributed to 1 % of the total frequent return visitor numbers
WHERE count_visits >= (SELECT
0.01*COUNT(idvisitor)
FROM
mtys_log_visit
WHERE
visitor_returning > 0
AND visitor_seconds_since_last <= 2592000 -- this is 30 days
)';
$result = $mysqli->query($query);
if (!$result) {
die('ERROR - Bad Select Statement query - frequent return visits - all time
' . $query);
}
while($row = $result->fetch_array()) {
// pull data from query into var
$frequentVisitors= $row['visitors'];
$frequentVisits= $row['visits'];
}
// close connection
$mysqli->close();
$visits = $visits +308;
$pageViews = $pageViews + 154;
if($frequentVisitsToday === NULL)
{
$frequentVisitsToday=0;
}
else
{
$frequentVisitsToday;
}
/*
Vars to use in a web page from data obtained in this script.
$visitsToday;
$visits7day;
$visits30day;
$visits;
$pageViewsToday;
$pageViews7day;
$pageViews30day;
$pageViews;
$returnVisitsToday;
$returnVisits7day;
$returnVisits30day;
$returnVisits;
$frequentVisitorsToday;
$frequentVisitsToday;
$frequentVisitors7day;
$frequentVisits7day;
$frequentVisitors30day;
$frequentVisits30day;
$frequentVisitors1Year;
$frequentVisits1Year;
$returnVisits1Year;
$pageViews1Year;
$visits1Year;
*/
header('Cache-Control: private');
?>