path = get_option('siteurl').'/wp-admin/admin.php?page=podpress/podpress_stats.php';
if (isset($_GET['display']) && is_string($_GET['display'])) {
$this->path .= '&display='.$_GET['display'];
}
$this->wpdb = $wpdb;
/* set default language for graphs */
$languages = explode(',', $_SERVER['HTTP_ACCEPT_LANGUAGE']);
$primary_language = $languages[0];
if (in_array($primary_language, array('de-de', 'de'))) {
/* German specification */
setlocale(LC_TIME, 'de_DE@euro:UTF-8', 'de_de:UTF-8', 'de_DE:UTF-8', 'de:UTF-8', 'ge:UTF-8', 'German_Germany.1252:UTF-8');
$local_settings = array(
'numbers' => array(',', '.'),
'short_date' => '%a.%n%d.%m.%y',
'creation_date' => '%d.%m.%y',
);
} else {
/* default specification: english */
setlocale(LC_TIME, 'en_US:UTF-8', 'en_en:UTF-8', 'en:UTF-8');
$local_settings = array(
'numbers' => array('.', ','),
'short_date' => '%a.%n%m/%d/%y',
'creation_date' => '%m/%d/%y',
);
}
$this->local_settings = $local_settings;
$this->podPress_class();
return;
}
#############################################
#############################################
function podSafeDigit($digit = 0) {
if (is_numeric($digit) && ($digit < 10000)) {
$digit = abs((int)$digit);
} else {
$digit = 0;
}
return $digit;
}
#############################################
#############################################
function paging($start, $limit, $total, $text = null) {
$pages = ceil($total / $limit);
$actualpage = ceil($start / $limit);
if ($pages > 0) {
if ($start > 0) {
$start_new = ($start - $limit < 0) ? 0 : ($start - $limit);
$right = ''.__('Next Entries »').' ';
}
if ($start + $limit < $total) {
$start_new = ($start + $limit);
$left = ''.__('« Previous Entries').' ';
}
echo ''."\n";
echo '
'."\n";
if ($pages > 1) {
if (!is_null($text)) {
echo $text;
}
echo ' ';
$i = 0;
while ($i < $total) {
$selected = ($i == $start) ? ' selected="selected"': null;
$newi = ($i + $limit);
if ($newi > $total) {
$newi = $total;
}
echo ' '.ceil($total - ($newi - 1)).' - '.ceil($total - ($i)).' ';
#$i = ($newi + 1);
$i = $newi;
}
echo ' ';
echo ' '.__('of', 'podpress').' '.$total;
}
echo '
'."\n";
echo '
';
if ($start + $limit < $total) {
echo $left;
}
if (($start + $limit < $total) AND ($start > 0)) {
echo ' | ';
}
if ($start > 0) {
echo $right;
}
echo "
\n";
echo "
';
foreach ($data AS $key => $idata) {
$image_height = floor($idata->value / $factor);
$margin = ($box_height - $image_height);
$bgcolor = (is_array($splitter) && ($idata->$splitter[0] == $splitter[1])) ? '#aaa': '#ccc';
$bgcolor = ($image_height == $box_height) ? '#d00': $bgcolor;
$output .= '
'."\n";
}
$output .= "
'.__('We\'re sorry. At the moment we don\'t have enough data collected to display the graph.', 'podpress')."
\n";
}
return $output;
}
#############################################
#############################################
function settings_stats_edit() {
GLOBAL $wpdb;
podPress_isAuthorized();
$baseurl = get_option('siteurl') . '/wp-admin/admin.php?page=podpress/podpress_stats.php&display=';
echo ''."\n";
echo '
'.__('Download Statistics', 'podpress').' '."\n";
if($this->settings['statLogging'] == 'Full') {
$navi = array(
'quickcounts' => __('Quick Counts', 'podpress'),
'graphbypost' => __('Graph by Post', 'podpress'),
'graphbydate' => __('Graph by Date', 'podpress'),
'unqiuedownloaders' => __('Unique Downloaders', 'podpress'),
'topips' => __('Top IP Addresses', 'podpress'),
'rawstats' => __('Raw Stats', 'podpress'),
);
echo '
'."\n";
foreach ($navi AS $key => $value) {
$active = (($_GET['display'] == $key) OR (!$_GET['display'] AND ($key == 'quickcounts'))) ? ' class="current"': null;
echo ' '.$value.' ';
if($this->checkGD()) {
if($value == __('Graph by Post', 'podpress')) {
echo ' ('. __('alt', 'podpress').' )';
} elseif($value == __('Graph by Date', 'podpress')) {
echo ' ('. __('alt', 'podpress').' )';
}
}
echo ' '."\n";
} else {
$_GET['display'] = 'quickcounts';
}
// Set Paging-Settings
$start = (isset($_GET['start'])) ? $this->podSafeDigit($_GET['start']): 0;
$limit = 25;
switch($_GET['display']) {
case 'unqiuedownloaders':
$total = $wpdb->get_results('SELECT COUNT(DISTINCT remote_ip, user_agent) FROM '.$wpdb->prefix.'podpress_stats GROUP BY media;');
$total = count($total);
echo '
'."\n";
echo '
'."\n";
echo ' '.__('The Unique Downloaders', 'podpress').' '."\n";
echo ' '."\n";
echo ' '.__('Media', 'podpress').' '.__('Total', 'podpress').' '."\n";
echo ' '.podPress_wordspaceing($stat->media, 20).' '."\n";
echo ' '.$stat->total.' '."\n";
echo ' '."\n";
}
}
echo '
'."\n";
echo ' '."\n";
echo '
';
break;
case 'rawstats':
$total = $wpdb->get_var('SELECT COUNT(postID) FROM '.$wpdb->prefix.'podpress_stats WHERE postID != 0;');
echo '
'."\n";
echo '
'."\n";
echo ' '.__('The raw list', 'podpress').' '."\n";
echo ' '."\n";
echo ' '.__('Media', 'podpress').' '.__('Method', 'podpress').' '.__('IP', 'podpress').' '.__('UserAgent', 'podpress').' '.__('Timestamp', 'podpress').' '."\n";
echo ' '.podPress_wordspaceing($stat->media, 20).' '."\n";
echo ' '.$stat->method.' '."\n";
echo ' '.$stat->remote_ip.' '."\n";
echo ' '.substr($stat->user_agent,0,20).' '."\n";
echo ' '.strftime('%Y-%m-%d (%I:%M %p)', $stat->dt).' '."\n";
echo ' '."\n";
}
}
echo '
'."\n";
echo ' '."\n";
echo '
';
break;
case 'topips':
$total = $wpdb->get_results('SELECT COUNT( * ) AS TotalCount FROM '.$wpdb->prefix.'podpress_stats GROUP BY remote_ip;');
$total = count($total);
echo '
'."\n";
echo '
'."\n";
echo ' '.__('Top IP Addresses', 'podpress').' '."\n";
echo ' '."\n";
echo ' '.__('IP Address', 'podpress').' '.__('Total Count', 'podpress').' '."\n";
echo ' '.$stat->IPAddress.' '."\n";
echo ' '.$stat->TotalCount.' '."\n";
echo ' '."\n";
}
}
echo '
'."\n";
echo ' '."\n";
echo '
';
break;
case 'graphbydate':
if ($this->checkGD() && ($this->settings['statLogging'] == 'Full')) {
$this->graphByDate();
} else {
$this->graphByDateAlt('With
gdlib-support you\'ll have access to more detailed graphicals stats. Please ask your provider.');
}
break;
case 'graphbydatealt':
$this->graphByDateAlt();
break;
case 'graphbypost':
if ($this->checkGD()) {
$this->graphByPost();
} else {
$this->graphByPostAlt('With
gdlib-support you\'ll have access to more detailed graphicals stats. Please ask your provider.');
}
break;
case 'graphbypostalt':
$this->graphByPostAlt();
break;
case 'quickcounts':
default:
$total = $wpdb->get_var('SELECT COUNT(postID) FROM '.$wpdb->prefix.'podpress_statcounts WHERE postID != 0;');
if ($total > 0) {
// Load highest values
$sql = "SELECT 'blah' AS topic, MAX(total) AS total, MAX(feed) AS feed, MAX(web) AS web, MAX(play) AS play FROM ".$wpdb->prefix.'podpress_statcounts GROUP BY topic;';
$highest = $wpdb->get_results($sql);
$highest = $highest[0];
$highlight_css = ' background-color: green; color: #fff;';
$sql = 'SELECT sc.postID, sc.media, sc.total, sc.feed, sc.web, sc.play, p.post_title, p.post_date, UNIX_TIMESTAMP(p.post_date) AS pdate '
. 'FROM '.$wpdb->prefix.'podpress_statcounts AS sc, '.$wpdb->prefix.'posts AS p '
. 'WHERE (sc.postID = p.ID) ORDER BY p.post_date DESC LIMIT '.$start.', '.$limit.';';
$stats = $wpdb->get_results($sql);
$cnt_stats = count($stats);
echo '
'."\n";
echo '
'."\n";
echo ' '.__('The counts', 'podpress').' '."\n";
echo ' '."\n";
echo " \n";
echo ' '.__('Post', 'podpress')." \n";
echo ' '.__('Date', 'podpress')." \n";
echo ' '.__('Media', 'podpress')." \n";
echo ' '.__('Feed', 'podpress')." \n";
echo ' '.__('Download', 'podpress')." \n";
echo ' '.__('Play', 'podpress')." \n";
echo ' '.__('Total', 'podpress')." \n";
echo " \n";
echo " \n";
echo ' '.__('Files', 'podpress')." \n";
echo ' '.__('%', 'podpress')." \n";
echo ' '.__('Files', 'podpress')." \n";
echo ' '.__('%', 'podpress')." \n";
echo ' '.__('Files', 'podpress')." \n";
echo ' '.__('%', 'podpress')." \n";
echo " \n";
if ($cnt_stats > 0) {
$i = 0;
foreach ($stats AS $stat) {
$style = ($i % 2 != 0) ? '' : ' class="alternate"';
$highest_feed = ($stat->feed == $highest->feed) ? $highlight_css: null;
$highest_web = ($stat->web == $highest->web) ? $highlight_css: null;
$highest_play = ($stat->play == $highest->play) ? $highlight_css: null;
$highest_total = ($stat->total == $highest->total) ? $highlight_css: null;
$perc_feed = number_format(($stat->feed * 100 / $stat->total), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);
$perc_web = number_format(($stat->web * 100 / $stat->total), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);
$perc_play = number_format(($stat->play * 100 / $stat->total), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);
echo ' '."\n";
echo ' '.$stat->post_title." '.strftime('%Y-%m-%d (%I:%M %p)', $stat->pdate)." \n";
echo ' '.podPress_wordspaceing($stat->media, 30)." \n";
echo ' '.number_format($stat->feed, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])." \n";
echo ' '.$perc_feed." \n";
echo ' '.number_format($stat->web, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])." \n";
echo ' '.$perc_web." \n";
echo ' '.number_format($stat->play, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])." \n";
echo ' '.$perc_play." \n";
echo ' '.number_format($stat->total, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])." \n";
echo ' '."\n";
$i++;
}
}
echo '
'."\n";
echo ' '."\n";
echo '
';
} else {
echo '
'.__('We\'re sorry. At the moment we don\'t have enough data collected to display the graph.', 'podpress')."
\n";
}
break;
}
// Show paging
if ($_GET['display'] != 'graphbydate' && $_GET['display'] != 'graphbypost') {
echo $this->paging($start, $limit, $total, 'Posts');
}
echo '
'."\n";
echo '
'.__('Could not include font-file. Please reinstall podPress.', 'podpress')."
\n";
return false;
}
$this->fontface = $fontface;
return true;
}
#############################################
#############################################
function graphByDate() {
if ($this->checkWritableTempFileDir() && $this->checkFontFile()) {
$chronometry1 = getmicrotime();
$start = (isset($_GET['start'])) ? $this->podSafeDigit($_GET['start']): 0;
$image_width = 800;
$image_height = 470;
$col_width = 20;
$filename = 'graph-by-date.jpg';
$file = $this->tempFileSystemPath.'/'.$filename;
$sidemargin = 20;
$baseline = ($image_height - 90);
$topmargin = 60;
$maxheight = ($baseline - $topmargin);
$weeks = 5;
$timelimit = (time() - (($weeks * 7) * 86400));
/* get the data in time range ($timelimit) */
$query = 'SELECT dt AS timestamp, DAYOFWEEK(FROM_UNIXTIME(dt)) AS weekday, method, '
. 'DATE_FORMAT(FROM_UNIXTIME(dt), "%Y-%m-%d") AS day '
. 'FROM '.$this->wpdb->prefix.'podpress_stats WHERE dt >= "'.$timelimit.'" '
. 'ORDER BY dt ASC;';
$data = $this->wpdb->get_results($query);
/* create array with grouped stats */
$stats = array();
$stats_total = array();
foreach ($data AS $idata) {
$stats[$idata->day][$idata->method]++;
$stats[$idata->day]['total']++;
$stats_total[$idata->method]++;
$stats_total['total']++;
}
/* get min an max values */
$value_min = 0;
$value_max = 0;
$i = 0;
$cnt_days = count($stats);
foreach ($stats AS $day => $idata) {
/* set min and max values */
if ($value_min == 0) {
$value_min = $idata['total'];
} elseif ($idata['total'] < $value_min) {
$value_min = $idata['total'];
} elseif ($idata['total'] > $value_max) {
$value_max = $idata['total'];
}
/* set first and last day */
if ($i == 0) {
$first_day = strtotime($day);
} elseif ($i == ($cnt_days - 1)) {
$last_day = strtotime($day);
}
$i++;
}
/* Do we have enough data? */
if (($value_max > 0) && ($cnt_days > 5)) {
$h_cscale = ($maxheight / $value_max);
$h_vscale = ($maxheight / $value_min / 4);
$pos_x = ($sidemargin + 35);
$points = array( 'total' => array(0 => $pos_x, 1 => $baseline) );
foreach ($stats AS $day => $idata) {
$points['total'][] = $pos_x;
$points['total'][] = ($baseline - ($idata['total'] * $h_cscale));
$points['feed'][] = ($baseline - ($idata['feed'] * $h_cscale));
$points['web'][] = ($baseline - ($idata['web'] * $h_cscale));
$points['play'][] = ($baseline - ($idata['play'] * $h_cscale));
$pos_x = ($pos_x + $col_width);
}
$points['total'][] = ($pos_x - $col_width);
$points['total'][] = $baseline;
/* create image */
$chronometry2 = getmicrotime();
$image = imagecreatetruecolor($image_width, $image_height);
if (function_exists('imageantialias')) {
imageantialias($image, 1);
}
/* set colors */
$colors = array(
'background' => imagecolorallocate($image, 51, 51, 51),
'line' => imagecolorallocate($image, 79, 79, 79),
'total' => imagecolorallocate($image, 79, 79, 79),
'feed' => imagecolorallocate($image, 255, 0, 0),
'web' => imagecolorallocate($image, 12, 223, 0),
'play' => imagecolorallocate($image, 223, 204, 0),
'text' => imagecolorallocate($image, 255, 255, 255),
'copytext' => imagecolorallocate($image, 79, 79, 79),
'days_first' => imagecolorallocate($image, 143, 143, 143),
'days_other' => imagecolorallocate($image, 95, 95, 95),
/* gray-scales: 175 159 143 127 111 95 79 63 */
);
imagefill($image, 0, 0, $colors['background']);
/* create the legend */
imagettftext($image, 14, 0, $sidemargin, 25, $colors['text'], $this->fontface, get_option('blogname'));
imagettftext($image, 8, 0, $sidemargin, 42, $colors['text'], $this->fontface, __('last', 'podpress').' '.$weeks.' '.__('weeks', 'podpress').' » '.strftime('%d.%m.%Y', $first_day).' - '.strftime('%d.%m.%Y', $last_day));
/* Total stats */
$text_total = number_format($stats_total['total'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);
$text_feed = number_format($stats_total['feed'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]).' ('.number_format(($stats_total['feed'] * 100 / $stats_total['total']), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]).'%)';
$text_web = number_format($stats_total['web'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]).' ('.number_format(($stats_total['web'] * 100 / $stats_total['total']), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]).'%)';
$text_play = number_format($stats_total['play'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]).' ('.number_format(($stats_total['play'] * 100 / $stats_total['total']), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]).'%)';
$text_total = __('Total stats in time range', 'podpress').': '.$text_total.' / '.__('Feed', 'podpress').': '.$text_feed.' / '.__('Download', 'podpress').': '.$text_web.' / '.__('Play', 'podpress').': '.$text_play.' ';
imagettftext($image, 8, 0, $sidemargin, ($image_height - 15), $colors['text'], $this->fontface, $text_total);
$pos_y = ($image_height - 32);
imagefilledrectangle($image, ($sidemargin + 0), ($pos_y - 10), ($sidemargin + 10), ($pos_y - 0), $colors['total']);
imagettftext($image, 8, 0, ($sidemargin + 15), $pos_y, $colors['text'], $this->fontface, __('Total', 'podpress'));
imageline($image, ($sidemargin + 50), ($pos_y - 4), ($sidemargin + 60), ($pos_y - 4), $colors['feed']);
imagettftext($image, 8, 0, ($sidemargin + 65), $pos_y, $colors['text'], $this->fontface, __('Feed', 'podpress'));
imageline($image, ($sidemargin + 100), ($pos_y - 4), ($sidemargin + 110), ($pos_y - 4), $colors['web']);
imagettftext($image, 8, 0, ($sidemargin + 115), $pos_y, $colors['text'], $this->fontface, __('Download', 'podpress'));
imageline($image, ($sidemargin + 175), ($pos_y - 4), ($sidemargin + 185), ($pos_y - 4), $colors['play']);
imagettftext($image, 8, 0, ($sidemargin + 190), $pos_y, $colors['text'], $this->fontface, __('Play', 'podpress'));
imagettftext($image, 23, 0, ($image_width - 128), 30, $colors['copytext'], $this->fontface, 'podPress');
imagettftext($image, 8, 0, ($image_width - 115), 43, $colors['copytext'], $this->fontface, __('Plugin for WordPress', 'podpress'));
imagettftext($image, 6, 90, ($image_width - 15), ($image_height - 10), $colors['copytext'], $this->fontface, strftime($this->local_settings['creation_date'], time()).' ('.PODPRESS_VERSION.')');
/* draw total-stats */
$cnt_total = (count($points['total']) / 2);
imagefilledpolygon($image, $points['total'], $cnt_total, $colors['total']);
/* draw background-lines and scale-text */
$step = 0;
$h = (($baseline - $topmargin) / 10);
while ($step <= 10) {
$pos_y = ($topmargin + ($h * $step));
imageline($image, 0, ($topmargin + ($h * $step)), $image_width, ($topmargin + ($h * $step)), $colors['line']);
imagettftext($image, 8, 0, ($sidemargin), ($pos_y + 13), $colors['line'], $this->fontface, number_format((($baseline - $pos_y) / $h_cscale), 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]));
$step++;
}
$pos_x = ($sidemargin + 35);
foreach ($stats AS $day => $idata) {
/* Web einzeichnen */
$weekday = date('w', strtotime($day));
$col_total_height = ($idata['total'] * $h_cscale);
if ($weekday == 1) {
$pos_y_start = ($baseline + 27);
imagettftext($image, 8, 0, ($pos_x + 3), ($baseline + 13), $colors['text'], $this->fontface, strftime($this->local_settings['short_date'], strtotime($day)));
$color = $colors['days_first'];
} else {
$pos_y_start = $baseline;
$color = $colors['days_other'];
}
imageline($image, $pos_x, $pos_y_start, $pos_x, ($baseline - $col_total_height), $color);
$pos_x = ($pos_x + $col_width);
}
/* Linien zeichen */
$topics = array('feed', 'web', 'play');
foreach ($topics AS $topic) {
$cnt_points = count($points[$topic]);
$pos_x = ($sidemargin + 35);
for ($i = 0; $i < ($cnt_points - 1); $i++) {
imageline($image, $pos_x, $points[$topic][$i], ($pos_x + $col_width), $points[$topic][$i + 1], $colors[$topic]);
$pos_x = ($pos_x + $col_width);
}
}
imagejpeg($image, $file, 100);
$chronometry_end = getmicrotime();
$chronometry1 = ($chronometry_end - $chronometry1);
$chronometry2 = ($chronometry_end - $chronometry2);
imagedestroy($image);
/* Output */
echo ''."\n";
echo '
'."\n";
echo "
'.__('Time to generate the graph', 'podpress').': '.number_format($chronometry1, 3, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]).' '.__('seconds', 'podpress').' ('.__('image', 'podpress').': '.number_format($chronometry2, 3, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]).' '.__('seconds', 'podpress').").
\n";
} else {
echo ''.__('We\'re sorry. At the moment we don\'t have enough data collected to display the graph.', 'podpress')."
\n";
}
}
}
#############################################
#############################################
function graphByDateAlt($msg = '') {
GLOBAL $wpdb;
$sql = 'SELECT DATE_FORMAT(FROM_UNIXTIME(dt), "%a, %Y-%m-%d") AS title, DAYOFWEEK(FROM_UNIXTIME(dt)) AS weekday, COUNT(id) AS value '
. 'FROM '.$wpdb->prefix.'podpress_stats GROUP BY title ORDER BY dt DESC LIMIT 0, 100;';
$data = $wpdb->get_results($sql);
$data = array_reverse($data);
$splitter = array('weekday', '2');
echo ' '."\n";
echo '
'."\n";
echo ' '.__('Downloads by date', 'podpress').' ('.__('Last 100 days', 'podpress').') '."\n";
echo $this->podGraph($data, $splitter);
if($msg != '') {
echo ' '.$msg."
\n";
}
echo ' '."\n";
echo '
'."\n";
echo '
'."\n";
echo $this->paging($start, $limit, $total, 'Posts');
echo '
'."\n";
echo "
'.__('Time to generate the graph', 'podpress').': '.number_format($chronometry1, 3, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]).' seconds (image: '.number_format($chronometry2, 3, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])." seconds).
\n";
} else {
echo ''.__('We\'re sorry. At the moment we don\'t have enough data collected to display the graph.', 'podpress')."
\n";
}
}
}
#############################################
#############################################
function graphByPostAlt($msg = '') {
global $wpdb;
$sql = 'SELECT post_title AS title, SUM(total) AS value '
. 'FROM '.$wpdb->prefix.'podpress_statcounts, '.$wpdb->prefix.'posts '
. 'WHERE '.$wpdb->prefix.'posts.ID = '.$wpdb->prefix.'podpress_statcounts.postID '
. 'AND postID !=0 GROUP BY postID ORDER BY post_date DESC LIMIT 0, 100;';
$data = $wpdb->get_results($sql);
$data = array_reverse($data);
echo ' '."\n";
echo '
'."\n";
echo ' '.__('Downloads by Post', 'podpress').' ('.__('Last 100 posts', 'podpress').') '."\n";
echo $this->podGraph($data);
echo ' '."\n";
if ($msg != '') {
echo '
'.$msg."
\n";
}
echo '
