wpstats/stats.php at master · foghorn/wpstats · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
<?php


//OPTIONAL: Un-comment this section to protect your page by requiring a key in the URI
/*
if ($_GET['key'] != "fa554bf790dadf9fd5316ed4b8bcdedc")
    die();
*/
?>

<!DOCTYPE html>
<html>
<head>
<style>
table, th, td {
  border: 1px solid black;
  border-collapse: collapse;
}
</style>
</head>
<body>

<?php

//TODO: Insert your WordPress API key here OR use an environment variable to be safer
$api_key = 'APIKEY';

//TODO: Identify the site whose stats you wish to display
$site_id = '123456';

//Set time offset based on local time versus server clock (Optional -- otherwise uncomment the next line)
$timestamp = time() + (60*60*2);
//$timestamp = time();

$today=date('Y-m-d',($timestamp));

//Display a bar graph of the site's stats over the last two weeks
function displayChart($site_id,$api_key,$timestamp,$today)
{

    $return = file_get_contents('https://stats.wordpress.com/csv.php?api_key=' . $api_key . '&blog_id=' . $site_id . '&table=views&days=14&limit=-1&end=' . $today);
    $return = str_replace("\",","\",\"",$return);
    $return = str_replace("\n","\",",$return);
    $return = str_replace("\"\"","\"",$return);
    $return = str_getcsv($return);

    $looper = 3;

    //TODO: Set the scale for your stacked chart so it fits properly
    $scale = 2;

    while ($looper < 30)
    {
        $height = $return[$looper] / $scale;

        echo "<img src=black.png width=\"4\" height=\"" . $height . "\">";
        echo "<img src=white.png width=\"1\" height=\"2\">";

        $looper = $looper + 2;
    }
}

//Display a summary of the site's performance and the current day's performance
function currentStatsBox($site_id,$api_key,$timestamp,$today)
{
    $return = str_getcsv(file_get_contents('https://stats.wordpress.com/csv.php?api_key=' . $api_key . '&blog_id=' . $site_id . '&table=views&days=1&limit=-1&end=' . $today));

    $todayposts = $return[2];

    $yesterday=date('Y-m-d',($timestamp - 86400));
    $return = str_getcsv(file_get_contents('https://stats.wordpress.com/csv.php?api_key=' . $api_key . '&blog_id=' . $site_id . '&table=views&days=1&limit=-1&end=' . $yesterday));
    $yesterdayposts = $return[2];

    $oneweekago=date('Y-m-d',($timestamp - 604800));
    $return = str_getcsv(file_get_contents('https://stats.wordpress.com/csv.php?api_key=' . $api_key . '&blog_id=' . $site_id . '&table=views&days=1&limit=-1&end=' . $oneweekago));
    $oneweekposts = $return[2];

    $return = str_getcsv(file_get_contents('https://stats.wordpress.com/csv.php?api_key=' . $api_key . '&blog_id=' . $site_id . '&table=views&days=7&limit=-1&end=' . $yesterday . '&summarize'));
    $return = substr($return[0],6);
    $weekavg = round(($return)/7);

    $return = str_getcsv(file_get_contents('https://stats.wordpress.com/csv.php?api_key=' . $api_key . '&blog_id=' . $site_id . '&table=views&days=30&limit=-1&end=' . $yesterday . '&summarize'));
    $return = substr($return[0],6);
    $monthavg = round(($return)/30);

    //Try and predict if today's traffic will beat the average daily traffic for the last week
    //Curve based on readership of American based website with 2mil visitors per month
    $daypostcurve = array(0.027774807,0.046947967,0.061012784,0.073294306,0.086336189,0.10373341,0.129288678,0.164043895,0.20582481,0.251802359,0.299501397,0.351663383,0.402238841,0.457099445,0.510331071,0.563625406,0.618030541,0.672019175,0.729664717,0.791267675,0.85449032,0.912840097,0.961926185,1);
    $dpc_ref = date("G",$timestamp);
    if ($dpc_ref > 0)
    {
        $dpp = ($daypostcurve[$dpc_ref] - $daypostcurve[($dpc_ref - 1)]) * (date("i",$timestamp) / 60);
        $dpp = ($daypostcurve[$dpc_ref - 1] + $dpp);
    }
    else
    {
        $dpp = ($daypostcurve[$dpc_ref] * (date("i",$timestamp) / 60));
    }

    $weekavgcheck = round(($weekavg * $dpp));

    //IF we already beat the weekly curve, GREEN
    if ($todayposts >= $weekavg)
        $color = "DEFDE0";
    //IF we beat the curve based on readership by hour, BLUE
    elseif ($todayposts >= $weekavgcheck)
        $color = "9ab7d3";
    //IF we are within 10% of the curve based on readership by hour, YELLOW
    elseif ($todayposts >= ($weekavgcheck * .9))
        $color = "FCF7DE";
    //OTHERWISE RED
    else
        $color = "FDDFDF";

    echo "<table border=\"1\">";

    echo "<tr><td>";
    echo "Today";
    echo "</td><td width=\"50\" bgcolor=\"#" . $color . "\">";
    echo $todayposts;
    echo "</td><td>";
    echo date("G:i m/d/y",$timestamp);
    echo "</td></tr>";

    echo "<tr><td>";
    echo "vs yesterday";
    echo "</td><td>";
    echo $yesterdayposts;
    echo "</td><td>";
    echo ($todayposts - $yesterdayposts) . " (" . ((round((($todayposts / $yesterdayposts)*100)))-100) . "%)";
    echo "</td></tr>";

    echo "<tr><td>";
    echo "vs last week";
    echo "</td><td>";
    echo $oneweekposts;
    echo "</td><td>";
    echo ($todayposts - $oneweekposts) . " (" . ((round((($todayposts / $oneweekposts)*100)))-100) . "%)";
    echo "</td></tr>";

    echo "<tr><td>";
    echo "7d avg";
    echo "</td><td>";
    echo $weekavg;
    echo "</td><td>";
    echo ($todayposts - $weekavg) . " (" . ((round((($todayposts / $weekavg)*100)))-100) . "%)";
    echo "</td></tr>";

    echo "<tr><td>";
    echo "30d avg";
    echo "</td><td>";
    echo $monthavg;
    echo "</td><td>";
    echo ($todayposts - $monthavg) . " (" . ((round((($todayposts / $monthavg)*100)))-100) . "%)";
    echo "</td></tr>";

    echo "</table>";
}

//Display charts
if ($_GET['type'] == '1')
{
    echo "<table border=\"0\">";
    echo "<tr><td>";
    currentStatsBox($site_id,$api_key,$timestamp,$today);
    echo "</td><td>";
    displayChart($site_id,$api_key,$timestamp,$today);
    echo "</td></tr></table>";
}
elseif ($_GET['type'] == '2')
{
    displayChart($site_id,$api_key,$timestamp,$today);

}
else
{
    currentStatsBox($site_id,$api_key,$timestamp,$today);

}
?>

</body>
</html>