PageRenderTime 63ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 1ms

/blog/wp-content/plugins/podpress/podpress_admin_stats_class.php

https://bitbucket.org/sergiohzlz/reportaprod
PHP | 1835 lines | 1489 code | 155 blank | 191 comment | 277 complexity | 668f50afdac4dd874a3b2e4d670a6f56 MD5 | raw file
Possible License(s): GPL-2.0, GPL-3.0, AGPL-1.0, LGPL-2.1 
    

  1. <?php

    2. 

  2. /*

    3. 

  3. License:

    4. 

  4.  ==============================================================================

    5. 

  5. 

    6. 

  6.     Copyright 2006  Dan Kuykendall  (email : dan@kuykendall.org)

    7. 

  7.     Modifications:  Jeff Norris     (email : jeff@iscifi.tv)

    8. 

  8.     Thanks to The P2R Team ( prepare2respond.com ) for stats suggestions.

    9. 

  9. 

    10. 

  10. 

    11. 

  11.     This program is free software; you can redistribute it and/or modify

    12. 

  12.     it under the terms of the GNU General Public License as published by

    13. 

  13.     the Free Software Foundation; either version 2 of the License, or

    14. 

  14.     (at your option) any later version.

    15. 

  15. 

    16. 

  16.     This program is distributed in the hope that it will be useful,

    17. 

  17.     but WITHOUT ANY WARRANTY; without even the implied warranty of

    18. 

  18.     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    19. 

  19.     GNU General Public License for more details.

    20. 

  20. 

    21. 

  21.     You should have received a copy of the GNU General Public License

    22. 

  22.     along with this program; if not, write to the Free Software

    23. 

  23.     Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-107  USA

    24. 

  24. */

    25. 

  25. class podPressAdmin_class extends podPress_class {

    26. 

  26. 	function podPressAdmin_class() {

    27. 

  27. 		GLOBAL $wpdb;

    28. 

  28. 		

    29. 

  29. 		$this->path = get_option('siteurl').'/wp-admin/admin.php?page=podpress/podpress_stats.php';

    30. 

  30. 		if (isset($_GET['display']) && is_string($_GET['display'])) {

    31. 

  31. 			$this->path .= '&amp;display='.$_GET['display'];

    32. 

  32. 		}

    33. 

  33. 		

    34. 

  34. 		// since 8.8.5 beta 3

    35. 

  35. 		parent::wherestr_to_exclude_bots();

    36. 

  36. 		

    37. 

  37. 		$this->wpdb                 = $wpdb;

    38. 

  38. 

    39. 

  39. 		/* set default language for graphs */

    40. 

  40. 		$languages        = explode(',', $_SERVER['HTTP_ACCEPT_LANGUAGE']);

    41. 

  41. 		$primary_language = $languages[0];

    42. 

  42. 		if (in_array($primary_language, array('de-de', 'de'))) {

    43. 

  43. 			/* German specification */

    44. 

  44. 			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');

    45. 

  45. 

    46. 

  46. 			$local_settings = array(

    47. 

  47. 			                        'numbers'       => array(',', '.'),

    48. 

  48. 			                        'short_date'    => '%a.%n%d.%m.%y',

    49. 

  49. 			                        'creation_date' => '%d.%m.%y',

    50. 

  50. 			                      );

    51. 

  51. 		} else {

    52. 

  52. 			/* default specification: english */

    53. 

  53. 			setlocale(LC_TIME, 'en_US:UTF-8', 'en_en:UTF-8', 'en:UTF-8');

    54. 

  54. 

    55. 

  55. 			$local_settings = array(

    56. 

  56. 			                        'numbers' => array('.', ','),

    57. 

  57. 			                        'short_date' => '%a.%n%m/%d/%y',

    58. 

  58. 			                        'creation_date' => '%m/%d/%y',

    59. 

  59. 			                       );

    60. 

  60. 		}

    61. 

  61. 		$this->local_settings = $local_settings;

    62. 

  62. 

    63. 

  63. 		$this->podPress_class();

    64. 

  64. 		return;

    65. 

  65. 	}

    66. 

  66. 

    67. 

  67. 	#############################################

    68. 

  68. 	#############################################

    69. 

  69. 

    70. 

  70. 	function podSafeDigit($digit = 0) {

    71. 

  71. 		if (is_numeric($digit) && ($digit < 10000)) {

    72. 

  72. 			$digit = abs((int)$digit);

    73. 

  73. 		} else {

    74. 

  74. 			$digit = 0;

    75. 

  75. 		}

    76. 

  76. 		return $digit;

    77. 

  77. 	}

    78. 

  78. 

    79. 

  79. 	#############################################

    80. 

  80. 	#############################################

    81. 

  81. 

    82. 

  82. 	function paging($start, $limit, $total, $text = null) {

    83. 

  83. 		$pages = ceil($total / $limit);

    84. 

  84. 		$actualpage = ceil($start / $limit);

    85. 

  85. 

    86. 

  86. 		if ($pages > 0) {

    87. 

  87. 			if ($start > 0) {

    88. 

  88. 				$start_new = ($start - $limit < 0) ? 0 : ($start - $limit);

    89. 

  89. 				$right = '<a href="'.$this->path.'&amp;start='.$start_new.'">'.__('Next Entries &raquo;').'</a>';

    90. 

  90. 			}

    91. 

  91. 

    92. 

  92. 			if ($start + $limit < $total) {

    93. 

  93. 				$start_new = ($start + $limit);

    94. 

  94. 				$left = '<a href="'.$this->path.'&amp;start='.$start_new.'">'.__('&laquo; Previous Entries').'</a>';

    95. 

  95. 			}

    96. 

  96. 

    97. 

  97. 			echo '<div id="podPress_paging">'."\n";

    98. 

  98. 			echo '	<div id="podPress_pagingLeft">'."\n";

    99. 

  99. 			if ($pages > 1) {

    100. 

  100. 				if (!is_null($text)) {

    101. 

  101. 					echo $text;

    102. 

  102. 				}

    103. 

  103. 				echo '    <select name="podPress_pageSelect" onchange="javascript: window.location = \''.$this->path.'&start=\'+this.value;">';

    104. 

  104. 				$i = 0;

    105. 

  105. 				while ($i < $total) {

    106. 

  106. 					$selected = ($i == $start) ? ' selected="selected"': null;

    107. 

  107. 					$newi = ($i + $limit);

    108. 

  108. 					if ($newi > $total) {

    109. 

  109. 						$newi = $total;

    110. 

  110. 					}

    111. 

  111. 					echo '    	<option value="'.$i.'"'.$selected.'>'.ceil($total - ($newi - 1)).' - '.ceil($total - ($i)).'</option>';

    112. 

  112. 					#$i = ($newi + 1);

    113. 

  113. 					$i = $newi;

    114. 

  114. 				}

    115. 

  115. 				echo '	</select>';

    116. 

  116. 

    117. 

  117. 				echo '	'.__('of', 'podpress').' '.$total;

    118. 

  118. 			}

    119. 

  119. 			echo '	</div>'."\n";

    120. 

  120. 

    121. 

  121. 			echo '	<div id="podPress_pagingRight">';

    122. 

  122. 				if ($start + $limit < $total) {

    123. 

  123. 					echo $left;

    124. 

  124. 				}

    125. 

  125. 				if (($start + $limit < $total) AND ($start > 0)) {

    126. 

  126. 					echo '&nbsp;&nbsp;|&nbsp;&nbsp;';

    127. 

  127. 				}

    128. 

  128. 				if ($start > 0) {

    129. 

  129. 					echo $right;

    130. 

  130. 				}

    131. 

  131. 			echo "	</div>\n";

    132. 

  132. 			echo "</div>\n";

    133. 

  133. 		}

    134. 

  134. 	}

    135. 

  135. 	

    136. 

  136. 	// ntm: paging() revised for v8.8.5 beta 3

    137. 

  137. 	// -'previous/next entries' string swaped

    138. 

  138. 	// - '$text from x to y' - select box revised

    139. 

  139. 	function paging2($start, $limit, $total, $text = null) {

    140. 

  140. 		$pages = ceil($total / $limit);

    141. 

  141. 		if ($pages > 0) {

    142. 

  142. 			echo '<div id="podPress_paging">'."\n";

    143. 

  143. 			echo '	<div id="podPress_pagingLeft">'."\n";

    144. 

  144. 			if ($pages > 1) {

    145. 

  145. 				if (!is_null($text)) {

    146. 

  146. 					echo $text;

    147. 

  147. 				}

    148. 

  148. 				echo '    <select name="podPress_pageSelect" onchange="javascript: window.location = \''.$this->path.'&start=\'+this.value;">';

    149. 

  149. 				$low = (1);

    150. 

  150. 				for ($i=$low; $i <= $total; $i++) {

    151. 

  151. 					$selected = (($i-1) == $start) ? ' selected="selected"': '';

    152. 

  152. 					if ( ($i % $limit) == 1 ) {

    153. 

  153. 						if ((($low-1)+$limit) < $total) {

    154. 

  154. 							$high = ($low-1)+$limit;

    155. 

  155. 						} else {

    156. 

  156. 							$high = $total;

    157. 

  157. 						}

    158. 

  158. 						if ($low != $high) {

    159. 

  159. 							echo '    		<option value="'.($i-1).'"'.$selected.'>'.$low.' - '.$high.'</option>';

    160. 

  160. 						} else {

    161. 

  161. 							echo '    		<option value="'.($i-1).'"'.$selected.'>'.$high.'</option>';

    162. 

  162. 						}

    163. 

  163. 						$low += $limit;

    164. 

  164. 					} 

    165. 

  165. 				}

    166. 

  166. 				echo '	</select>';

    167. 

  167. 

    168. 

  168. 				echo '	'.__('of', 'podpress').' '.$total;

    169. 

  169. 			}

    170. 

  170. 			//echo '<p>'.$start.' | '.$limit.' | '.$total.' | '.$text.'</p>';

    171. 

  171. 			echo '	</div>'."\n";

    172. 

  172. 

    173. 

  173. 			if ($start + $limit < $total) {

    174. 

  174. 				$right = '<a href="'.$this->path.'&amp;start='.($start+$limit).'">'.__('Next Entries &raquo;').'</a>';

    175. 

  175. 			}

    176. 

  176. 			if ($start > 0) {

    177. 

  177. 				$left = '<a href="'.$this->path.'&amp;start='.($start-$limit).'">'.__('&laquo; Previous Entries').'</a>';

    178. 

  178. 			}

    179. 

  179. 

    180. 

  180. 			echo '	<div id="podPress_pagingRight">';

    181. 

  181. 				if ($start > 0) {

    182. 

  182. 					echo $left;

    183. 

  183. 				}

    184. 

  184. 				if (($start + $limit < $total) AND ($start > 0)) {

    185. 

  185. 					echo '&nbsp;|&nbsp;';

    186. 

  186. 				}

    187. 

  187. 				if ($start + $limit < $total) {

    188. 

  188. 					echo $right;

    189. 

  189. 				}

    190. 

  190. 			echo "	</div>\n";

    191. 

  191. 			echo "</div>\n";

    192. 

  192. 		}

    193. 

  193. 	}

    194. 

  194. 

    195. 

  195. 	#############################################

    196. 

  196. 	#############################################

    197. 

  197. 

    198. 

  198. 	function podGetHighest($data) {

    199. 

  199. 		$highest = 0;

    200. 

  200. 		foreach ($data AS $key => $idata) {

    201. 

  201. 			if ($idata->value > $highest) {

    202. 

  202. 				$highest = $idata->value;

    203. 

  203. 			}

    204. 

  204. 		}

    205. 

  205. 		return $highest;

    206. 

  206. 	}

    207. 

  207. 

    208. 

  208. 	#############################################

    209. 

  209. 	#############################################

    210. 

  210. 

    211. 

  211. 	function podGraph($data, $splitter = null) {

    212. 

  212. 		$cnt_data   = count($data);

    213. 

  213. 

    214. 

  214. 		if ($cnt_data > 0) {

    215. 

  215.     		$box_width  = 600;

    216. 

  216.     		$box_height = 400;

    217. 

  217.     		$bar_margin = 2;

    218. 

  218.     		$bar_width  = floor(($box_width - ($cnt_data * $bar_margin)) / $cnt_data);

    219. 

  219.     		$bar_width  = ($bar_width < 2) ? 2: $bar_width;

    220. 

  220.     		$highest    = $this->podGetHighest($data);

    221. 

  221.     		$factor     = ($highest / $box_height);

    222. 

  222. 

    223. 

  223.     		$output     = '<div id="podGraph" style="height: '.$box_height.'px; width: '.$box_width.'px; float: left; border: 1px solid #ccc; padding: 0.5em;">';

    224. 

  224.     		foreach ($data AS $key => $idata) {

    225. 

  225.     			$image_height  = floor($idata->value / $factor);

    226. 

  226.     			$margin  = ($box_height - $image_height);

    227. 

  227.     			$bgcolor = (is_array($splitter) && ($idata->$splitter[0] == $splitter[1])) ? '#aaa': '#ccc';

    228. 

  228.     			$bgcolor = ($image_height == $box_height) ? '#d00': $bgcolor;

    229. 

  229.     			$output .= '    <div style="float: left; margin-top: '.$margin.'px; margin-right: '.$bar_margin.'px; height: '.$image_height.'px; background-color: '.$bgcolor.'; width: '.$bar_width.'px; cursor: help;'.$split.'" title="'.$idata->title.' ('.number_format($idata->value, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]).' x)"></div>'."\n";

    230. 

  230.     		}

    231. 

  231.     		$output .= "</div>\n";

    232. 

  232. 		} else {

    233. 

  233.             $output = '<p>'.__('We\'re sorry. At the moment we don\'t have enough data collected to display the graph.', 'podpress')."</p>\n";

    234. 

  234. 		}

    235. 

  235. 

    236. 

  236. 		return $output;

    237. 

  237. 	}

    238. 

  238. 

    239. 

  239. 	#############################################

    240. 

  240. 	#############################################

    241. 

  241. 

    242. 

  242. 	function settings_stats_edit() {

    243. 

  243. 		GLOBAL $wpdb, $wp_version;

    244. 

  244. 		podPress_isAuthorized();

    245. 

  245. 		$baseurl = get_option('siteurl') . '/wp-admin/admin.php?page=podpress/podpress_stats.php&display=';

    246. 

  246. 		echo '<div class="wrap">'."\n";

    247. 

  247. 		

    248. 

  248. 		if ( TRUE == version_compare($wp_version, '2.7', '>=') ) {

    249. 

  249. 			echo '<div id="podpress-icon" class="icon32"><br /></div>';

    250. 

  250. 		} 

    251. 

  251. 		if ( TRUE == version_compare($wp_version, '2.8', '>=') ) {

    252. 

  252. 			echo '	<h2>'.__('Download Statistics', 'podpress').'</h2>'."\n";

    253. 

  253. 			// get the plugins version information via the WP plugins version check

    254. 

  254. 			if ( TRUE == version_compare($wp_version, '2.9', '>=') ) {

    255. 

  255. 				$versioninfo = get_site_transient( 'update_plugins' );

    256. 

  256. 			} else {

    257. 

  257. 				$versioninfo = get_transient( 'update_plugins' );

    258. 

  258. 			}

    259. 

  259. 			// If there is a new version then there is a 'response'. This is the method from the plugins page. 

    260. 

  260. 			if ( FALSE !== isset($versioninfo->response[plugin_basename(dirname(__FILE__).'/podpress.php')]->new_version) ) {

    261. 

  261. 				echo '<div class="message updated"><p><a href="http://wordpress.org/extend/plugins/podpress/" target="_blank">'.__('a new podPress version is available', 'podpress').'</a></p></div>';

    262. 

  262. 			}

    263. 

  263. 		} else {

    264. 

  264. 			echo '	<h2>'.__('Download Statistics', 'podpress').'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="http://www.mightyseek.com/podpress/#download" target="_new"><img src="http://www.mightyseek.com/podpress_downloads/versioncheck.php?current='.PODPRESS_VERSION.'" alt="'.__('Checking for updates... Failed.', 'podpress').'" border="0" /></a></h2>'."\n";

    265. 

  265. 		}

    266. 

  266. 		

    267. 

  267. 		if($this->settings['statLogging'] == 'Full' || $this->settings['statLogging'] == 'FullPlus') {

    268. 

  268. 			// Show all statistics which are based on wp_stats [stat logging: Full and Full+]

    269. 

  269. 			$navi = array(

    270. 

  270. 				'downloads_per_media_file' => __('Downloads Per Media File', 'podpress'),

    271. 

  271. 				'downloads_per_post' => __('Downloads Per Post', 'podpress'),

    272. 

  272. 				'topips' => __('Downloads Per IP Address', 'podpress'),

    273. 

  273. 				'graphbydate' => __('Graph by Date', 'podpress'),

    274. 

  274. 				'rawstats' => __('Raw Stats', 'podpress'),

    275. 

  275. 			);

    276. 

  276. 			echo '	<ul id="podPress_navi">'."\n";

    277. 

  277. 			foreach ($navi AS $key => $value) {

    278. 

  278. 				$active = (($_GET['display'] == $key) OR (!$_GET['display'] AND ($key == 'downloads_per_media_file'))) ? ' class="current"': null;

    279. 

  279. 				echo '        	<li class="podpress_stats_sub_menu_item"><a href="'.$baseurl.$key.'"'.$active.'>'.$value.'</a>';

    280. 

  280. 				if($this->checkGD()) {

    281. 

  281. 					if ($value == __('Graph by Date', 'podpress')) {

    282. 

  282. 						echo ' (<a href="'.$baseurl.'graphbydatealt" title="'.sprintf(__('An alternative view of the %1$s', 'podpress'), __('Graph by Date', 'podpress')).'">'. __('alt', 'podpress').'</a>)';

    283. 

  283. 					}

    284. 

  284. 				}

    285. 

  285. 				echo '</li>'."\n";

    286. 

  286. 			}

    287. 

  287. 			echo '	</ul>'."\n";

    288. 

  288. 			

    289. 

  289. 			// bot management menu (since 8.8.5 beta 3)

    290. 

  290. 			$navi2 = array(

    291. 

  291. 				'botdb_mark_bots' => __('Select / Deselect Bots', 'podpress'),

    292. 

  292. 				'botdb_list' => __('List of Bots', 'podpress'),

    293. 

  293. 			);

    294. 

  294. 			echo '	<ul id="podPress_navi">'."\n";

    295. 

  295. 			foreach ($navi2 AS $key => $value) {

    296. 

  296. 				$active = (($_GET['display'] == $key) OR (!$_GET['display'] AND ($key == 'quickcounts'))) ? ' class="current"': null;

    297. 

  297. 				echo '        	<li class="podpress_stats_sub_menu_item"><a href="'.$baseurl.$key.'"'.$active.'>'.$value.'</a></li>'."\n";

    298. 

  298. 			}

    299. 

  299. 			echo '	</ul>'."\n";

    300. 

  300. 			

    301. 

  301. 		} else {

    302. 

  302. 		

    303. 

  303. 			// Show all statistics which are based on wp_statcounts	[stat logging: Counts Only]

    304. 

  304. 			// old: $_GET['display'] = 'downloads_per_media_file';

    305. 

  305. 			$navi = array(

    306. 

  306. 				'quickcounts' => __('Quick Counts', 'podpress'),

    307. 

  307. 				'graphbypost' => __('Graph by Post', 'podpress'),

    308. 

  308. 			);

    309. 

  309. 			echo '	<ul id="podPress_navi">'."\n";

    310. 

  310. 			foreach ($navi AS $key => $value) {

    311. 

  311. 				$active = (($_GET['display'] == $key) OR (!$_GET['display'] AND ($key == 'quickcounts'))) ? ' class="current"': null;

    312. 

  312. 				echo '        	<li class="podpress_stats_sub_menu_item"><a href="'.$baseurl.$key.'"'.$active.'>'.$value.'</a>';

    313. 

  313. 				if($this->checkGD()) {

    314. 

  314. 					if($value == __('Graph by Post', 'podpress')) {

    315. 

  315. 						echo ' (<a href="'.$baseurl.'graphbypostalt" title="'.sprintf(__('An alternative view of the %1$s', 'podpress'), __('Graph by Post', 'podpress')).'">'. __('alt', 'podpress').'</a>)';

    316. 

  316. 					}

    317. 

  317. 				}

    318. 

  318. 				echo '</li>'."\n";

    319. 

  319. 			}

    320. 

  320. 			echo '	</ul>'."\n";

    321. 

  321. 

    322. 

  322. 		}

    323. 

  323. 

    324. 

  324. 		// Set Paging-Settings

    325. 

  325. 		$start = (isset($_GET['start'])) ? $this->podSafeDigit($_GET['start']): 0;

    326. 

  326. 		

    327. 

  327. 		//~ ####################

    328. 

  328. 		//~ Limit is limits the number of rows of the statistic tables

    329. 

  329. 		$limit = 25;

    330. 

  330. 		//~ ####################

    331. 

  331. 		

    332. 

  332. 		// ntm: since 8.8.5 beta 3 there are two different default statistic tables quickcounts and downloads_per_media_file that is why the default value has to be found before that Switch (and not with this Switch)

    333. 

  333. 		if (FALSE == isset($_GET['display']) OR FALSE !== empty($_GET['display'])) {

    334. 

  334. 			if ($this->settings['statLogging'] == 'Full' || $this->settings['statLogging'] == 'FullPlus') {

    335. 

  335. 				$show_this_page = 'downloads_per_media_file';

    336. 

  336. 			} else {

    337. 

  337. 				$show_this_page = 'quickcounts';

    338. 

  338. 			}

    339. 

  339. 		} else {

    340. 

  340. 			$show_this_page = $_GET['display'];

    341. 

  341. 		}

    342. 

  342. 		Switch($show_this_page) {

    343. 

  343. 			case 'botdb_list':

    344. 

  344. 				// ntm: stat logging: Full and Full+

    345. 

  345. 				podPress_isAuthorized();

    346. 

  346. 				$botdb = get_option('podpress_botdb');

    347. 

  347. 				if ( 'botdb' == $_POST['podPress_submitted'] ) {

    348. 

  348. 					if ( function_exists('check_admin_referer') ) {

    349. 

  349. 						check_admin_referer('podPress_botdb_nonce');

    350. 

  350. 					}

    351. 

  351. 					$IPs = $_POST['podpress_remote_ips'];

    352. 

  352. 					$fullbotnames = stripslashes_deep($_POST['podpress_user_agents']);

    353. 

  353. 					if ( is_array($botdb) ) {

    354. 

  354. 						$something_removed=FALSE;

    355. 

  355. 						if ( is_array($IPs) and is_array($botdb['IP'])) {

    356. 

  356. 							$botdb['IP'] = array_diff($botdb['IP'], $IPs);

    357. 

  357. 							sort($botdb['IP']);

    358. 

  358. 						}

    359. 

  359. 						if ( is_array($fullbotnames) and is_array($botdb['fullbotnames'])) {

    360. 

  360. 							$botdb['fullbotnames'] = array_diff($botdb['fullbotnames'], $fullbotnames);

    361. 

  361. 							sort($botdb['fullbotnames']);

    362. 

  362. 						}

    363. 

  363. 					}

    364. 

  364. 					$updated=update_option('podpress_botdb', $botdb);

    365. 

  365. 					if (isset($updated) AND $updated == TRUE) {

    366. 

  366. 						echo '<div id="message" class="updated fade"><p>'. __('Settings Saved', 'podpress').'</p></div>';

    367. 

  367. 					}

    368. 

  368. 				}

    369. 

  369. 				

    370. 

  370. 				echo '	<div class="wrap">'."\n";

    371. 

  371. 				echo '		<fieldset class="options">'."\n";

    372. 

  372. 				echo '			<legend>'.__('The list of IP addresses and names of bots', 'podpress').'</legend>'."\n";

    373. 

  373. 				echo '			<form method="post">'."\n";

    374. 

  374. 				if ( function_exists('wp_nonce_field') ) { // since WP 2.0.4

    375. 

  375. 					wp_nonce_field('podPress_botdb_nonce');

    376. 

  376. 				}

    377. 

  377. 				echo '			<table class="the-list-x widefat">'."\n";

    378. 

  378. 				echo '				<thead>'."\n";

    379. 

  379. 				echo '				<tr><th rowspan="2">'.__('Nr.', 'podpress').'</th><th rowspan="2">'.__('Bot IP Address', 'podpress').'</th><th rowspan="2">'.__('Bot User Agent', 'podpress').'</th><th colspan="2">'.__('Remove this', 'podpress').'</th></tr><tr><th>'.__('IP', 'podpress').'</th><th>'.__('Name', 'podpress').'</th></tr>'."\n";

    380. 

  380. 				echo '				</thead>'."\n";

    381. 

  381. 				echo '				<tbody>'."\n";

    382. 

  382. 				$nobots = FALSE;

    383. 

  383. 				if (is_array($botdb) and (is_array($botdb['fullbotnames']) OR is_array($botdb['IP'])) ) {

    384. 

  384. 					$botnames_len = count($botdb['fullbotnames']);

    385. 

  385. 					$IPs_len = count($botdb['IP']);

    386. 

  386. 					$rows_total = max($botnames_len, $IPs_len);

    387. 

  387. 					if ( $rows_total > ($start+$limit) ) {

    388. 

  388. 						$high = $start+$limit;

    389. 

  389. 					} else {

    390. 

  390. 						$high = $rows_total;

    391. 

  391. 					}

    392. 

  392. 					$low = ($start+1);

    393. 

  393. 					for ($i=$low; $i <= $high; $i++) {

    394. 

  394. 						$style = ($i % 2) ? '' : ' class="alternate"';

    395. 

  395. 						echo '				<tr'.$style.'>'."\n";

    396. 

  396. 							echo '                  			<td>'.($start +$i).'.</td>'."\n";

    397. 

  397. 						if ($i <= ($IPs_len-$start)) {

    398. 

  398. 							$col_ip = '                  			<td>'.stripslashes($botdb['IP'][($i-1)]).'</td>'."\n";

    399. 

  399. 							$col_ip_chb = '                  			<td><input type="checkbox" id="podpress_remote_ip_'.$i.'" name="podpress_remote_ips[]" value="'.$botdb['IP'][($i-1)].'" '.$ip_chb_checked.' /></td>'."\n";

    400. 

  400. 						} else {

    401. 

  401. 							$col_ip = $col_ip_chb = '                  			<td></td>'."\n";

    402. 

  402. 						}

    403. 

  403. 						if ($i <= ($botnames_len-$start)) {

    404. 

  404. 							$col_botname = '                  			<td>'.stripslashes($botdb['fullbotnames'][($i-1)]).'</td>'."\n";

    405. 

  405. 							$col_botname_chb = '                  			<td><input type="checkbox" id="podpress_user_agent_'.$i.'" name="podpress_user_agents[]" value="'.attribute_escape($botdb['fullbotnames'][($i-1)]).'" '.$name_chb_checked.' /></td>'."\n";

    406. 

  406. 						} else {

    407. 

  407. 							$col_botname = $col_botname_chb = '                  			<td></td>'."\n";

    408. 

  408. 						}

    409. 

  409. 						echo $col_ip.$col_botname.$col_ip_chb.$col_botname_chb;

    410. 

  410. 						echo '              			</tr>'."\n";

    411. 

  411. 					}

    412. 

  412. 					if ( 0 == $botnames_len AND 0 == $IPs_len ) {

    413. 

  413. 						$nobots = TRUE;

    414. 

  414. 					}

    415. 

  415. 				}  else {

    416. 

  416. 					$nobots = TRUE;

    417. 

  417. 				}				

    418. 

  418. 				if (TRUE == $nobots) {

    419. 

  419. 					echo '				<td colspan="5">'.__('Currently are no IP addresses or user agents marked as bots.', 'podpress').'</td>'."\n";

    420. 

  420. 				}

    421. 

  421. 				echo '				</tbody>'."\n";

    422. 

  422. 				echo '				<tfood>'."\n";

    423. 

  423. 				echo '				<tr>'."\n";

    424. 

  424. 				echo '				<th colspan="5">'."\n";

    425. 

  425. 					// Show paging

    426. 

  426. 					echo $this->paging2($start, $limit, $rows_total, __('names and IPs','podpress'));

    427. 

  427. 				echo '				</th>'."\n";

    428. 

  428. 				echo '              			</tr>'."\n";

    429. 

  429. 				echo '				</tfood>'."\n";

    430. 

  430. 				echo '			</table>'."\n";				

    431. 

  431. 				echo '			<p class="submit"> '."\n";

    432. 

  432. 				echo '				<input class="button-primary" type="submit" name="Submit" value="'.__('Remove elements', 'podpress').' &raquo;" /><br />'."\n";

    433. 

  433. 				echo '			</p> '."\n";

    434. 

  434. 				echo '			<input type="hidden" name="podPress_submitted" value="botdb" />'."\n";

    435. 

  435. 				echo '			</form>'."\n";

    436. 

  436. 				echo '		</fieldset>'."\n";

    437. 

  437. 				echo '	</div>';

    438. 

  438. 				break;

    439. 

  439. 			case 'botdb_mark_bots':

    440. 

  440. 				// ntm: stat logging: Full and Full+

    441. 

  441. 				podPress_isAuthorized();

    442. 

  442. 				$blog_charset = get_bloginfo('charset');

    443. 

  443. 				$botdb = get_option('podpress_botdb');

    444. 

  444. 				if ( 'botdb' == $_POST['podPress_submitted'] ) {

    445. 

  445. 					if ( function_exists('check_admin_referer') ) {

    446. 

  446. 						check_admin_referer('podPress_botdb_nonce');

    447. 

  447. 					}

    448. 

  448. 					$IPs = $_POST['podpress_remote_ips'];

    449. 

  449. 					$fullbotnames = stripslashes_deep($_POST['podpress_user_agents']);

    450. 

  450. 					

    451. 

  451. 					if (is_array($botdb)) {

    452. 

  452. 						$current_IP_set = $_POST['podpress_current_IP_set'];

    453. 

  453. 						$unique_current_data_IPs = array_unique($_POST['podpress_current_IP_set']);

    454. 

  454. 						

    455. 

  455. 						//add new bots

    456. 

  456. 						if (is_array($IPs)) {

    457. 

  457. 							$unique_IPs = array_unique($IPs);

    458. 

  458. 							foreach ($unique_IPs as $IP) {

    459. 

  459. 								if (is_array($botdb['IP'])) {

    460. 

  460. 									if ( FALSE === array_search($IP, $botdb['IP']) )  {

    461. 

  461. 										$botdb['IP'][] = $IP;

    462. 

  462. 									}

    463. 

  463. 								} else {

    464. 

  464. 									$botdb['IP'][] = $IP;

    465. 

  465. 								}

    466. 

  466. 							}

    467. 

  467. 							

    468. 

  468. 							// eventually remove bots

    469. 

  469. 							$unmarked_IPs = array_diff($unique_current_data_IPs, $unique_IPs);

    470. 

  470. 							$botdb['IP'] = array_diff($botdb['IP'], $unmarked_IPs);

    471. 

  471. 							sort($botdb['IP']);

    472. 

  472. 						} else {

    473. 

  473. 							if (is_array($botdb['IP'])) {

    474. 

  474. 								$botdb['IP'] = array_diff($botdb['IP'], $unique_current_data_IPs);

    475. 

  475. 								sort($botdb['IP']);

    476. 

  476. 							}

    477. 

  477. 						}

    478. 

  478. 						

    479. 

  479. 						$current_user_agent_set = $_POST['podpress_current_user_agent_set'];

    480. 

  480. 						$unique_current_data_fbnames = array_unique($_POST['podpress_current_user_agent_set']);

    481. 

  481. 						if (is_array($fullbotnames)) {

    482. 

  482. 							$unique_fullbotnames = array_unique($fullbotnames);

    483. 

  483. 							foreach ($unique_fullbotnames as $fullbotname) {

    484. 

  484. 								if (is_array($botdb['fullbotnames'])) {

    485. 

  485. 									if ( FALSE === array_search($fullbotname, $botdb['fullbotnames']) ) {

    486. 

  486. 										$botdb['fullbotnames'][] = $fullbotname;

    487. 

  487. 									}

    488. 

  488. 								} else {

    489. 

  489. 									$botdb['fullbotnames'][] = $fullbotname;

    490. 

  490. 								}

    491. 

  491. 							}

    492. 

  492. 							

    493. 

  493. 							// eventually remove bots

    494. 

  494. 							$unmarked_fullbotnames = array_diff($unique_current_data_fbnames, $unique_fullbotnames);

    495. 

  495. 							$botdb['fullbotnames'] = array_diff($botdb['fullbotnames'], $unmarked_fullbotnames);

    496. 

  496. 							sort($botdb['fullbotnames']);

    497. 

  497. 						} else {

    498. 

  498. 							// eventually remove bots

    499. 

  499. 							if (is_array($botdb['fullbotnames'])) {

    500. 

  500. 								$botdb['fullbotnames'] = array_diff($botdb['fullbotnames'], $unique_current_data_fbnames);

    501. 

  501. 								sort($botdb['fullbotnames']);

    502. 

  502. 							}

    503. 

  503. 						}

    504. 

  504. 					} else {

    505. 

  505. 						//add new bots (first time)

    506. 

  506. 						if (is_array($IPs)) {

    507. 

  507. 							$unique_IPs = array_unique($IPs);

    508. 

  508. 							foreach ($unique_IPs as $IP) {

    509. 

  509. 								$botdb['IP'][] = $IP;

    510. 

  510. 							}

    511. 

  511. 						}

    512. 

  512. 						if (is_array($fullbotnames)) {

    513. 

  513. 							$unique_fullbotnames = array_unique($fullbotnames);

    514. 

  514. 							foreach ($unique_fullbotnames as $fullbotname) {

    515. 

  515. 								$botdb['fullbotnames'][] = $fullbotname;

    516. 

  516. 							}

    517. 

  517. 						}

    518. 

  518. 					}

    519. 

  519. 					

    520. 

  520. 					$updated=update_option('podpress_botdb', $botdb);

    521. 

  521. 					if (isset($updated) AND $updated == TRUE) {

    522. 

  522. 						echo '<div id="message" class="updated fade"><p>'. __('Settings Saved', 'podpress').'</p></div>';

    523. 

  523. 					}

    524. 

  524. 				}

    525. 

  525. 				$where='';

    526. 

  526. 				$rows_total = intval($wpdb->get_var('SELECT COUNT(DISTINCT remote_ip, user_agent) AS total FROM '.$wpdb->prefix.'podpress_stats '.$where));

    527. 

  527. 				$query_string = 'SELECT DISTINCT remote_ip, user_agent FROM '.$wpdb->prefix.'podpress_stats '.$where.'ORDER BY dt DESC LIMIT '.$start.', '.$limit;

    528. 

  528. 				$stats = $wpdb->get_results($query_string);

    529. 

  529. 	

    530. 

  530. 				echo '	<div class="wrap">'."\n";

    531. 

  531. 				echo '		<fieldset class="options">'."\n";

    532. 

  532. 				echo '			<legend>'.__('Which IP address or user agent name is from a web bot?', 'podpress').'</legend>'."\n";

    533. 

  533. 				echo '			<p>'.__('Probably not every counted download is a download of a real human listener. Some hits are eventually from so called <a href="http://en.wikipedia.org/wiki/Internet_bot" target="_blank" title="en.Wikipedia: Internet Bot">Internet bots</a>. Every downloader has an <a href="http://en.wikipedia.org/wiki/IP_address" target="_blank" title="en.Wikipedia: IP Address">IP address</a> and a <a href="http://en.wikipedia.org/wiki/User_agent" target="_blank" title="en.Wikipedia: User Agent">user agent</a> name. The user agent name indicates often very good whether it is the name of a browser of a real listener or a name of a bot. Whether a IP address is one of a bot or not is more difficult. But there are some websites which can help to find out more about an IP address. (Some bots are using IP addresses only temporarily.)<br />The list below shows all unique combinations of IP addresses and user agent names. It is possible to select (resp. deselect) only the IP address or the user agent name or both. Downloads of the selected IP addresses or user agents do not appear in the statistics.', 'podpress').'</p>'."\n";				

    534. 

  534. 				echo '			<form method="post">'."\n";

    535. 

  535. 				if ( function_exists('wp_nonce_field') ) { // since WP 2.0.4

    536. 

  536. 					wp_nonce_field('podPress_botdb_nonce');

    537. 

  537. 				}

    538. 

  538. 				echo "\n".'			<table class="the-list-x widefat">'."\n";

    539. 

  539. 				echo '				<thead>'."\n";

    540. 

  540. 				echo '				<tr><th rowspan="2">'.__('Nr.', 'podpress').'</th><th rowspan="2">'.__('IP Address', 'podpress').'</th><th rowspan="2">'.__('User Agent', 'podpress').'</th><th colspan="2">'.__('Is it a bot?', 'podpress').'</th></tr><tr><th>'.__('IP', 'podpress').'</th><th>'.__('Name', 'podpress').'</th></tr>'."\n";

    541. 

  541. 				echo '				</thead>'."\n";

    542. 

  542. 				echo '				<tbody>'."\n";

    543. 

  543. 				if(0 < count($stats)) {

    544. 

  544. 					$i = 0;

    545. 

  545. 					foreach ($stats as $stat) {

    546. 

  546. 						++$i;

    547. 

  547. 						$alternate = ($i % 2) ? '' : 'alternate';

    548. 

  548. 						$bot_style = '';

    549. 

  549. 						$ip_chb_checked = '';

    550. 

  550. 						$name_chb_checked = '';

    551. 

  551. 						if (TRUE == is_array($botdb)) {

    552. 

  552. 							if (TRUE == is_array($botdb['IP']) AND FALSE !== array_search($stat->remote_ip, $botdb['IP'])) {

    553. 

  553. 								$bot_style = ' podpress_is_bot';

    554. 

  554. 								$ip_chb_checked = ' checked="checked"';

    555. 

  555. 							}

    556. 

  556. 							if (TRUE == is_array($botdb['fullbotnames']) AND FALSE !== array_search($stat->user_agent, $botdb['fullbotnames'])) {

    557. 

  557. 								$bot_style = ' podpress_is_bot';

    558. 

  558. 								$name_chb_checked = ' checked="checked"';

    559. 

  559. 							}

    560. 

  560. 						}

    561. 

  561. 						echo '				<tr id ="podpress_ip_user_agent_row_'.($i).'" class="'.$alternate.$bot_style.'">'."\n";

    562. 

  562. 						echo '                  			<td>'.($start+$i).'</td>'."\n";

    563. 

  563. 						echo '                  			<td>'.$stat->remote_ip.'<input type="hidden" name="podpress_current_IP_set[]" value="'.$stat->remote_ip.'" /></td>'."\n";

    564. 

  564. 						echo '                  			<td>'.podPress_strlimiter2($stat->user_agent, 80, TRUE).'<input type="hidden" name="podpress_current_user_agent_set[]" value="'.attribute_escape($stat->user_agent).'" /></td>'."\n";

    565. 

  565. 						echo '                  			<td><input type="checkbox" id="podpress_remote_ip_'.$i.'" name="podpress_remote_ips[]" value="'.$stat->remote_ip.'" onclick="podpress_mark_same_all_bots( \'remote_ips\' , '.$i.', '.($start).' );" '.$ip_chb_checked.' /></td>'."\n";

    566. 

  566. 						echo '                  			<td><input type="checkbox" id="podpress_user_agent_'.$i.'" name="podpress_user_agents[]" value="'.attribute_escape($stat->user_agent).'" onclick="podpress_mark_same_all_bots( \'user_agent\' , '.$i.', '.($start).' );" '.$name_chb_checked.' /></td>'."\n";

    567. 

  567. 						echo '              			</tr>'."\n";

    568. 

  568. 					}

    569. 

  569. 				} else {

    570. 

  570. 					echo '<td colspan="5">'.__('No downloads yet.','podpress')."</td>\n";

    571. 

  571. 				}

    572. 

  572. 

    573. 

  573. 				echo '				</tbody>'."\n";

    574. 

  574. 				echo '				<tfood>'."\n";

    575. 

  575. 				echo '				<tr>'."\n";

    576. 

  576. 				echo '				<th colspan="5">'."\n";

    577. 

  577. 					// Show paging

    578. 

  578. 					echo $this->paging2($start, $limit, $rows_total, __('names and IPs','podpress'));

    579. 

  579. 				echo '				</th>'."\n";

    580. 

  580. 				echo '              			</tr>'."\n";

    581. 

  581. 				echo '				</tfood>'."\n";

    582. 

  582. 				echo '			</table>'."\n";				

    583. 

  583. 				

    584. 

  584. 				echo '				<p class="submit"> '."\n";

    585. 

  585. 				echo '					<input class="button-primary" type="submit" name="Submit" value="'.__('Update Options', 'podpress').' &raquo;" /><br />'."\n";

    586. 

  586. 				echo '				</p> '."\n";

    587. 

  587. 				echo '				<input type="hidden" name="podPress_submitted" value="botdb" />'."\n";

    588. 

  588. 				echo '			</form>'."\n";

    589. 

  589. 				echo '		</fieldset>'."\n";

    590. 

  590. 				echo '	</div>';

    591. 

  591. 				break;

    592. 

  592. 			case 'downloads_per_media_file':

    593. 

  593. 				// ntm: stat logging: Full and Full+

    594. 

  594. 				$where = $this->wherestr_to_exclude_bots('pod');

    595. 

  595. 				

    596. 

  596. 				$query_string = "SELECT COUNT(DISTINCT pod.media) as total_rows FROM ".$wpdb->prefix."podpress_stats as pod ".$where;

    597. 

  597. 				$rows_total = intval($wpdb->get_var($query_string));

    598. 

  598. 

    599. 

  599. 				$query_string = "SELECT DISTINCT (pod.media) FROM ".$wpdb->prefix."podpress_stats as pod ".$where." LIMIT ".$start.", ".$limit;

    600. 

  600. 				$posts_with_podpressmedia = $wpdb->get_results($query_string);

    601. 

  601. 				$nr_postswpm = count($posts_with_podpressmedia);

    602. 

  602. 				if ( 0 < $nr_postswpm) {

    603. 

  603. 					$i=1;

    604. 

  604. 					if (FALSE == empty($where)) {

    605. 

  605. 						$where_posts = "AND pod.media IN (";

    606. 

  606. 					} else {

    607. 

  607. 						$where_posts = "WHERE pod.media IN (";

    608. 

  608. 					}

    609. 

  609. 					foreach ($posts_with_podpressmedia as $post) {

    610. 

  610. 						if ($i == $nr_postswpm) {

    611. 

  611. 							$where_posts .= "'".$post->media."'";

    612. 

  612. 						} else {

    613. 

  613. 							$where_posts .= "'".$post->media."', ";

    614. 

  614. 						}

    615. 

  615. 						$i++;

    616. 

  616. 					}

    617. 

  617. 					$where_posts .= ") ";

    618. 

  618. 				} else {

    619. 

  619. 					$where_posts = '';

    620. 

  620. 				}

    621. 

  621. 

    622. 

  622. 				$query_string="SELECT pod.media, pod.method, COUNT(*) as downloads FROM ".$wpdb->prefix."podpress_stats as pod ".$where.$where_posts."GROUP BY pod.method, pod.media ORDER BY pod.media DESC";

    623. 

  623. 				$stat_data_sets = $wpdb->get_results($query_string);

    624. 

  624. 				

    625. 

  625. 				if (FALSE == empty($where)) {

    626. 

  626. 					$where_or_and = "AND";

    627. 

  627. 				} else {

    628. 

  628. 					$where_or_and = "WHERE";

    629. 

  629. 				}				

    630. 

  630. 				$methods = Array('feed', 'web', 'play');

    631. 

  631. 				foreach ($methods as $method) {

    632. 

  632. 					$query_string="SELECT COUNT(*) as downloads, pod.media FROM ".$wpdb->prefix."podpress_stats AS pod ".$where.$where_or_and." pod.method='".$method."' GROUP BY pod.media ORDER BY downloads DESC";

    633. 

  633. 					$downloads_col = $wpdb->get_col($query_string);

    634. 

  634. 					switch ($method) {

    635. 

  635. 						case 'feed' :

    636. 

  636. 							$feed_max = intval($downloads_col[0]);

    637. 

  637. 						break;

    638. 

  638. 						case 'web' :

    639. 

  639. 							$web_max = intval($downloads_col[0]);

    640. 

  640. 						break;

    641. 

  641. 						case 'play' :

    642. 

  642. 							$play_max = intval($downloads_col[0]);

    643. 

  643. 						break;

    644. 

  644. 					}		

    645. 

  645. 				}

    646. 

  646. 				$query_string="SELECT COUNT(*) as downloads, pod.media FROM ".$wpdb->prefix."podpress_stats AS pod ".$where." GROUP BY pod.media ORDER BY downloads DESC";

    647. 

  647. 				$downloads_col = $wpdb->get_col($query_string);

    648. 

  648. 				$total_max = intval($downloads_col[0]);

    649. 

  649. 				

    650. 

  650. 				// prepare the query result for the output:

    651. 

  651. 				// - if a media file was not downloaded  by one or more method then add this method  and a int(0) to the media file 		

    652. 

  652. 				foreach ($stat_data_sets as $stat_data_set) {

    653. 

  653. 					$feed = $web = $play = 0;

    654. 

  654. 					switch ($stat_data_set->method) {

    655. 

  655. 						case 'feed' :

    656. 

  656. 							$feed = intval($stat_data_set->downloads);

    657. 

  657. 						break;

    658. 

  658. 						case 'web' :

    659. 

  659. 							$web = intval($stat_data_set->downloads);

    660. 

  660. 						break;

    661. 

  661. 						case 'play' :

    662. 

  662. 							$play = intval($stat_data_set->downloads);

    663. 

  663. 						break;

    664. 

  664. 					}

    665. 

  665. 					$total_sum = $feed+$web+$play;

    666. 

  666. 					$stats[$stat_data_set->media]['feed'] += $feed;

    667. 

  667. 					$stats[$stat_data_set->media]['web'] += $web;

    668. 

  668. 					$stats[$stat_data_set->media]['play'] += $play;

    669. 

  669. 					$stats[$stat_data_set->media]['total'] += $total_sum;

    670. 

  670. 				}

    671. 

  671. 				

    672. 

  672. 				// sort the media files by their 'total' value

    673. 

  673. 				if (is_array($stats)) {

    674. 

  674. 					uasort($stats, array(self, 'sort_downloads_per_media_desc'));

    675. 

  675. 				}

    676. 

  676. 				echo '	<div class="wrap">'."\n";

    677. 

  677. 				echo '		<fieldset class="options">'."\n";

    678. 

  678. 				echo '			<legend>'.__('Downloads Per Media File', 'podpress').'</legend>'."\n";

    679. 

  679. 				echo '			<table class="the-list-x widefat">'."\n";

    680. 

  680. 				echo '				<thead>';

    681. 

  681. 				echo "				<tr>\n";

    682. 

  682. 				echo '                  			<th rowspan="2">'.__('Nr.', 'podpress')."</th>\n";

    683. 

  683. 				echo '                  			<th rowspan="2">'.__('Media File', 'podpress')."</th>\n";

    684. 

  684. 				echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Feed', 'podpress')."</th>\n";

    685. 

  685. 				echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Web', 'podpress')."</th>\n";

    686. 

  686. 				echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Play', 'podpress')."</th>\n";

    687. 

  687. 				echo '                  			<th class="podpress_stats_nr_head" rowspan="2">'.__('Total', 'podpress')."</th>\n";

    688. 

  688. 				echo '              			</tr>'."\n";

    689. 

  689. 				echo '				<tr>'."\n";

    690. 

  690. 				echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    691. 

  691. 				echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    692. 

  692. 				echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    693. 

  693. 				echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    694. 

  694. 				echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    695. 

  695. 				echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    696. 

  696. 				echo '              			</tr>'."\n";

    697. 

  697. 				echo '				</thead>';

    698. 

  698. 				echo '				<tbody>';

    699. 

  699. 				if (0 < count($stat_data_sets)) {

    700. 

  700. 					$i = 0;

    701. 

  701. 					foreach ( $stats as $media => $downloads_per_method ) {

    702. 

  702. 						$i++;

    703. 

  703. 						$style = ($i % 2 != 0) ? '' : ' class="alternate"';

    704. 

  704. 						$highest_feed = ($downloads_per_method['feed'] == $feed_max AND 0 < $feed_max) ? ' podpress_stats_highest': '';

    705. 

  705. 						$highest_web = ($downloads_per_method['web'] == $web_max AND 0 < $web_max) ? ' podpress_stats_highest': '';

    706. 

  706. 						$highest_play = ($downloads_per_method['play'] == $play_max AND 0 < $play_max) ? ' podpress_stats_highest': '';

    707. 

  707. 						$highest_total = ($downloads_per_method['total'] == $total_max AND 0 < $total_max) ? ' podpress_stats_highest': '';

    708. 

  708. 						$perc_feed = number_format(($downloads_per_method['feed'] * 100 / $downloads_per_method['total']), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    709. 

  709. 						$perc_web = number_format(($downloads_per_method['web']  * 100 / $downloads_per_method['total']), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    710. 

  710. 						$perc_play = number_format(($downloads_per_method['play'] * 100 / $downloads_per_method['total']), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    711. 

  711. 						echo '		<tr'.$style.'>'."\n";

    712. 

  712. 						echo '                  	<td>'.($start +$i).'.</td>'."\n";

    713. 

  713. 						echo '                  	<td>'.podPress_strlimiter2(urldecode($media), 50, TRUE).'</td>'."\n";

    714. 

  714. 						echo '                  	<td class="podpress_stats_numbers_abs'.$highest_feed.'">'.number_format($downloads_per_method['feed'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    715. 

  715. 						echo '                  	<td class="podpress_stats_numbers_percent'.$highest_feed.'">'.$perc_feed."</td>\n";

    716. 

  716. 						echo '                  	<td class="podpress_stats_numbers_abs'.$highest_web.'" >'.number_format($downloads_per_method['web'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    717. 

  717. 						echo '                  	<td class="podpress_stats_numbers_percent'.$highest_web.'">'.$perc_web."</td>\n";

    718. 

  718. 						echo '                  	<td class="podpress_stats_numbers_abs'.$highest_play.'">'.number_format($downloads_per_method['play'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    719. 

  719. 						echo '                  	<td class="podpress_stats_numbers_percent'.$highest_play.'">'.$perc_play."</td>\n";

    720. 

  720. 						echo '                  	<td class="podpress_stats_numbers_total'.$highest_total.'">'.number_format($downloads_per_method['total'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    721. 

  721. 						echo '		</tr>'."\n";

    722. 

  722. 					}

    723. 

  723. 				} else {

    724. 

  724. 					if (FALSE == empty($where)) {

    725. 

  725. 						echo '<td colspan="9">'.__('No downloads yet. (Bots have been filtered.)','podpress')."</td>\n";

    726. 

  726. 					} else {

    727. 

  727. 						echo '<td colspan="9">'.__('No downloads yet.','podpress')."</td>\n";

    728. 

  728. 					}

    729. 

  729. 				}

    730. 

  730. 				echo '				</tbody>';

    731. 

  731. 				echo '				<tfood>'."\n";

    732. 

  732. 				echo '				<tr>'."\n";

    733. 

  733. 				echo '				<th colspan="9">'."\n";

    734. 

  734. 					// Show paging

    735. 

  735. 					echo $this->paging2($start, $limit, $rows_total, __('Ranks','podpress'));

    736. 

  736. 				echo '				</th>'."\n";

    737. 

  737. 				echo '              			</tr>'."\n";

    738. 

  738. 				echo '				</tfood>'."\n";

    739. 

  739. 				echo '			</table>'."\n";

    740. 

  740. 				echo '		</fieldset>'."\n";

    741. 

  741. 				echo '	</div>';

    742. 

  742. 				break;

    743. 

  743. 			case 'rawstats':

    744. 

  744. 				// ntm: stat logging: Full and Full+

    745. 

  745. 				$date_format = get_option('date_format');

    746. 

  746. 				$time_format = get_option('time_format');

    747. 

  747. 				$botdb = get_option('podpress_botdb');

    748. 

  748. 				$where = '';

    749. 

  749. 				$rows_total = $wpdb->get_var('SELECT COUNT(*) FROM '.$wpdb->prefix.'podpress_stats '.$where);

    750. 

  750. 				$stats = $wpdb->get_results('SELECT * FROM '.$wpdb->prefix.'podpress_stats '.$where.'ORDER BY id DESC LIMIT '.$start.', '.$limit);

    751. 

  751. 				echo '	<div class="wrap">'."\n";

    752. 

  752. 				echo '		<fieldset class="options">'."\n";

    753. 

  753. 				echo '			<legend>'.__('The raw list', 'podpress').'</legend>'."\n";

    754. 

  754. 				echo '			<table class="the-list-x widefat">'."\n"; //width="100%" cellpadding="1" cellspacing="1"

    755. 

  755. 				echo '				<thead>';

    756. 

  756. 				echo '				<tr><th>'.__('Hit', 'podpress').'</th><th>'.__('Media File', 'podpress').'</th><th>'.__('Method', 'podpress').'</th><th>'.__('IP', 'podpress').'</th><th>'.__('User Agent', 'podpress').'</th><th>'.__('Timestamp', 'podpress').'</th></tr>'."\n";

    757. 

  757. 				echo '				</thead>';

    758. 

  758. 				echo '				<tbody>';

    759. 

  759. 				if(0 < count($stats)) {

    760. 

  760. 					if ( TRUE === is_array($botdb['IP']) OR TRUE === is_array($botdb['fullbotnames']) ) {

    761. 

  761. 						$i = 0;

    762. 

  762. 						foreach ($stats as $stat) {

    763. 

  763. 							++$i;

    764. 

  764. 							$style = ($i % 2) ? '' : 'alternate';

    765. 

  765. 							

    766. 

  766. 							if ( (FALSE !== empty($botdb['fullbotnames']) OR FALSE === array_search($stat->user_agent, $botdb['fullbotnames']))) {

    767. 

  767. 								if ( (FALSE !== empty($botdb['IP']) OR FALSE === array_search($stat->remote_ip, $botdb['IP']))) {

    768. 

  768. 									$bot_style = '';

    769. 

  769. 								} else {

    770. 

  770. 									$bot_style = ' podpress_is_bot';

    771. 

  771. 								}

    772. 

  772. 							} else {

    773. 

  773. 								$bot_style = ' podpress_is_bot';

    774. 

  774. 							}

    775. 

  775. 							echo '		<tr class="'.$style.$bot_style.'">'."\n";

    776. 

  776. 							echo '                  	<td>'.($start +$i).'.</td>'."\n";

    777. 

  777. 							echo '                  	<td>'.podPress_strlimiter2(urldecode($stat->media), 20, TRUE).'</td>'."\n";

    778. 

  778. 							echo '                  	<td>'.$stat->method.'</td>'."\n";

    779. 

  779. 							// iscifi : mod of stats output to create a link to domaintools.com whois lookup

    780. 

  780. 							// domaintools seems faster and provides more concise infomation, url can not have trailing /

    781. 

  781. 

    782. 

  782. 							echo '                  	<td><a href="http://whois.domaintools.com/'.$stat->remote_ip.'" target="_blank" title="'.__('Look for more details about this IP at whois.domaintools.com', 'podpress').'">'.$stat->remote_ip.'</a></td>'."\n";

    783. 

  783. 							// OLD code where this .echo '                  <td>'.$stat->remote_ip.'</td>'."\n";

    784. 

  784. 							echo '                  	<td>'.podPress_strlimiter2($stat->user_agent, 50, TRUE).'</td>'."\n";

    785. 

  785. 							echo '                  	<td>'.date($date_format.' - '.$time_format,  intval($stat->dt)).'</td>'."\n";

    786. 

  786. 							echo '		</tr>'."\n";

    787. 

  787. 						}

    788. 

  788. 					} else {

    789. 

  789. 						$i = 0;

    790. 

  790. 						foreach ($stats as $stat) {

    791. 

  791. 							++$i;

    792. 

  792. 							$style = ($i % 2) ? '' : 'alternate';

    793. 

  793. 							echo '				<tr class="'.$style.'">'."\n";

    794. 

  794. 							echo '                  <td>'.($start +$i).'.</td>'."\n";

    795. 

  795. 							echo '                  <td>'.podPress_strlimiter2(urldecode($stat->media), 20, TRUE).'</td>'."\n";

    796. 

  796. 							echo '                  <td>'.$stat->method.'</td>'."\n";

    797. 

  797. 							// iscifi : mod of stats output to create a link to domaintools.com whois lookup

    798. 

  798. 							// domaintools seems faster and provides more concise infomation, url can not have trailing /

    799. 

  799. 

    800. 

  800. 							echo '                  <td><a href="http://whois.domaintools.com/'.$stat->remote_ip.'" target="_blank">'.$stat->remote_ip.'</a></td>'."\n";

    801. 

  801. 							// OLD code where this .echo '                  <td>'.$stat->remote_ip.'</td>'."\n";

    802. 

  802. 							echo '                  <td>'.podPress_strlimiter2($stat->user_agent, 50, TRUE).'</td>'."\n";

    803. 

  803. 							echo '                  <td>'.date($date_format.' - '.$time_format,  intval($stat->dt)).'</td>'."\n";

    804. 

  804. 							echo '              </tr>'."\n";

    805. 

  805. 						}

    806. 

  806. 					}

    807. 

  807. 				} else {

    808. 

  808. 					echo '<td colspan="6">'.__('No downloads yet.','podpress').'</td>'."\n";

    809. 

  809. 				}

    810. 

  810. 				echo '				</tbody>';

    811. 

  811. 				echo '				<tfood>'."\n";

    812. 

  812. 				echo '				<tr>'."\n";

    813. 

  813. 				echo '				<th colspan="6">'."\n";

    814. 

  814. 					// Show paging

    815. 

  815. 					echo $this->paging2($start, $limit, $rows_total, __('Hit','podpress'));

    816. 

  816. 				echo '				</th>'."\n";

    817. 

  817. 				echo '              			</tr>'."\n";

    818. 

  818. 				echo '				</tfood>'."\n";

    819. 

  819. 				echo '			</table>'."\n";

    820. 

  820. 				echo '		</fieldset>'."\n";

    821. 

  821. 				echo '	</div>';

    822. 

  822. 				break;

    823. 

  823. 			case 'topips':

    824. 

  824. 				// ntm: stat logging: Full and Full+

    825. 

  825. 				$where = $this->wherestr_to_exclude_bots();

    826. 

  826. 				$rows_total = ($wpdb->get_var('SELECT COUNT(DISTINCT remote_ip) as uniq FROM '.$wpdb->prefix.'podpress_stats '.$where));

    827. 

  827. 				

    828. 

  828. 				$sql   = 'SELECT remote_ip AS IPAddress, COUNT(DISTINCT remote_ip, media) as uniq, COUNT( * ) AS total FROM '.$wpdb->prefix.'podpress_stats '.$where.'GROUP BY remote_ip ORDER BY total DESC LIMIT '.$start.', '.$limit;

    829. 

  829. 				$stats = $wpdb->get_results($sql);

    830. 

  830. 				

    831. 

  831. 				echo '	<div class="wrap">'."\n";

    832. 

  832. 				echo '		<fieldset class="options">'."\n";

    833. 

  833. 				echo '			<legend>'.__('Top IP Addresses', 'podpress').'</legend>'."\n";

    834. 

  834. 				echo '			<table class="the-list-x widefat">'."\n";

    835. 

  835. 				echo '				<thead>';

    836. 

  836. 				echo '				<tr><th>'.__('Nr.', 'podpress').'</th><th>'.__('IP Address', 'podpress').'</th><th><abbr class="podpress_abbr" title="'.__('Only one download per file from this IP address has been counted. In other words: It is the number of different files which were downloaded from this IP address.','podpress').'">'.__('Unique Files', 'podpress').'</abbr></th><th>'.__('Total', 'podpress').'</th></tr>'."\n";

    837. 

  837. 				echo '				</thead>';

    838. 

  838. 				echo '				<tbody>';

    839. 

  839. 				if(0<count($stats)) {

    840. 

  840. 					$i = 0;

    841. 

  841. 					foreach ($stats as $stat) {

    842. 

  842. 						++$i;

    843. 

  843. 						$style = ($i % 2) ? '' : ' class="alternate"';

    844. 

  844. 						echo '		<tr'.$style.'>'."\n";

    845. 

  845. 						echo '                  	<td>'.($start +$i).'.</td>'."\n";

    846. 

  846. 						echo '                  	<td>'.$stat->IPAddress.'</td>'."\n";

    847. 

  847. 						echo '                  	<td>'.$stat->uniq.'</td>'."\n";

    848. 

  848. 						echo '                  	<td>'.$stat->total.'</td>'."\n";

    849. 

  849. 						echo '             	</tr>'."\n";

    850. 

  850. 					}

    851. 

  851. 				} else {

    852. 

  852. 					if (FALSE == empty($where)) {

    853. 

  853. 						echo '<td colspan="4">'.__('No downloads yet. (Bots have been filtered.)','podpress')."</td>\n";

    854. 

  854. 					} else {

    855. 

  855. 						echo '<td colspan="4">'.__('No downloads yet.','podpress')."</td>\n";

    856. 

  856. 					}

    857. 

  857. 				}

    858. 

  858. 				echo '				</tbody>';

    859. 

  859. 				echo '				<tfood>'."\n";

    860. 

  860. 				echo '				<tr>'."\n";

    861. 

  861. 				echo '				<th colspan="4">'."\n";

    862. 

  862. 					// Show paging

    863. 

  863. 					echo $this->paging2($start, $limit, $rows_total, __('IP Address','podpress'));

    864. 

  864. 				echo '				</th>'."\n";

    865. 

  865. 				echo '              			</tr>'."\n";

    866. 

  866. 				echo '				</tfood>'."\n";

    867. 

  867. 				echo '			</table>'."\n";

    868. 

  868. 				echo '		</fieldset>'."\n";

    869. 

  869. 				echo '	</div>';

    870. 

  870. 				break;

    871. 

  871. 			case 'graphbydate':

    872. 

  872. 				// ntm: stat logging: Full and Full+

    873. 

  873. 				if ($this->checkGD() ) {//&& ($this->settings['statLogging'] == 'Full' || $this->settings['statLogging'] == 'FullPlus')

    874. 

  874. 					$this->graphByDate();

    875. 

  875. 				} else {

    876. 

  876. 					$this->graphByDateAlt('With <a href="http://us2.php.net/manual/en/ref.image.php">gdlib-support</a> you\'ll have access to more detailed graphicals stats. Please ask your provider.');

    877. 

  877. 				}

    878. 

  878. 				break;

    879. 

  879. 			case 'graphbydatealt':

    880. 

  880. 				// ntm: stat logging: Full and Full+

    881. 

  881. 				$this->graphByDateAlt();

    882. 

  882. 				break;

    883. 

  883. 			case 'graphbypost':

    884. 

  884. 				// ntm: stat logging: Counts Only

    885. 

  885. 				echo '<p>'.__('<strong>Notice:</strong> This graph is only faultless if your podcast posts contain only one media file per post, each file has a unique name and if you change the media file name on a re-post (deleting a post and publishing the content in a new post)!', 'podpress').'</p>';

    886. 

  886. 				if ($this->checkGD()) {

    887. 

  887. 					$this->graphByPost();

    888. 

  888. 				} else {

    889. 

  889. 					$this->graphByPostAlt('With <a href="http://us2.php.net/manual/en/ref.image.php">gdlib-support</a> you\'ll have access to more detailed graphicals stats. Please ask your provider.');

    890. 

  890. 				}

    891. 

  891. 				break;

    892. 

  892. 			case 'graphbypostalt':

    893. 

  893. 				// ntm: stat logging: Counts Only

    894. 

  894. 				echo '<p>'.__('<strong>Notice:</strong> This graph is only faultless if your podcast posts contain only one media file per post, each file has a unique name and if you change the media file name on a re-post (deleting a post and publishing the content in a new post)!', 'podpress').'</p>';

    895. 

  895. 				$this->graphByPostAlt();

    896. 

  896. 				break;

    897. 

  897. 			case 'downloads_per_post' :

    898. 

  898. 				// ntm: stat logging: Full and Full+

    899. 

  899. 				$where = $this->wherestr_to_exclude_bots('pod');

    900. 

  900. 				

    901. 

  901. 				// get the number of all post with podPress podcasts

    902. 

  902. 				$query_string = "SELECT COUNT(DISTINCT postID) as posts FROM ".$wpdb->prefix."podpress_stats ".$where;

    903. 

  903. 				// get all post with podPress podcasts

    904. 

  904. 				$query_string="SELECT DISTINCT(pod.postID), p.post_title FROM ".$wpdb->prefix."podpress_stats AS pod LEFT JOIN ".$wpdb->prefix."posts AS p ON pod.postID = p.ID ".$where." ORDER BY pod.postID DESC";

    905. 

  905. 				$posts_with_podpressmedia = $wpdb->get_results($query_string);

    906. 

  906. 				

    907. 

  907. 				echo '	<div class="wrap">'."\n";

    908. 

  908. 				echo '		<fieldset class="options">'."\n";

    909. 

  909. 				echo '			<legend>'.__('Downloads Per Post', 'podpress').'</legend>'."\n";

    910. 

  910. 				echo '			<form method="post">'."\n";

    911. 

  911. 				if ( function_exists('wp_nonce_field') ) { // since WP 2.0.4

    912. 

  912. 					wp_nonce_field('podPress_downloads_per_post_nonce');

    913. 

  913. 				}

    914. 

  914. 				echo '				<label>'.__('Select a post with a media file (attached with podPress):', 'podpress').'</label><br />'."\n";

    915. 

  915. 				echo '				<select id="post_with_podpressmedia" name="post_with_podpressmedia" size="5">'."\n";

    916. 

  916. 				foreach ($posts_with_podpressmedia as $post) {

    917. 

  917. 					if ($post->postID == $_POST['post_with_podpressmedia']) {

    918. 

  918. 						$selected = ' selected="selected"';

    919. 

  919. 					} else {

    920. 

  920. 						$selected = '';

    921. 

  921. 					}

    922. 

  922. 					echo '				<option value="'.$post->postID.'"'.$selected.'>'.$post->post_title.'</option>'."\n";

    923. 

  923. 					$post_titles[$post->postID] = $post->post_title;

    924. 

  924. 				}

    925. 

  925. 				echo '				</select>'."\n";

    926. 

  926. 				echo '				<p class="submit"> '."\n";

    927. 

  927. 				echo '					<input type="submit" name="Submit" value="'.__('Show the stats for this post', 'podpress').' &raquo;" /><br />'."\n";

    928. 

  928. 				echo '				</p> '."\n";

    929. 

  929. 				echo '				<input type="hidden" name="podPress_submitted" value="downloadsperpost" />'."\n";

    930. 

  930. 				echo '			</form>'."\n";

    931. 

  931. 				echo '		</fieldset>'."\n";

    932. 

  932. 				echo '	</div><!-- .wrap -->'."\n";

    933. 

  933. 				

    934. 

  934. 				// show the statistics of the media files of the submitted post

    935. 

  935. 				if ( 'downloadsperpost' == $_POST['podPress_submitted'] ) {

    936. 

  936. 					if ( function_exists('check_admin_referer') ) {

    937. 

  937. 						check_admin_referer('podPress_downloads_per_post_nonce');

    938. 

  938. 					}

    939. 

  939. 

    940. 

  940. 					if (FALSE == empty($where)) {

    941. 

  941. 						$where_postID = "AND pod.postID = '".$_POST['post_with_podpressmedia']."' ";

    942. 

  942. 					} else {

    943. 

  943. 						$where_postID = "WHERE pod.postID = '".$_POST['post_with_podpressmedia']."' ";

    944. 

  944. 					}

    945. 

  945. 					$query_string="SELECT pod.media, pod.method, COUNT(*) as downloads FROM ".$wpdb->prefix."podpress_stats as pod ".$where.$where_postID."GROUP BY pod.method, pod.media ORDER BY media DESC";

    946. 

  946. 					$stat_data_sets = $wpdb->get_results($query_string);

    947. 

  947. 					

    948. 

  948. 					// prepare the query result for the output:

    949. 

  949. 					// - find the maximal downloads value for each download method

    950. 

  950. 					// - if a media file was not downloaded  by one or more method then add this method  and a int(0) to the media file 		

    951. 

  951. 					$feed_max = 0;

    952. 

  952. 					$web_max = 0;

    953. 

  953. 					$play_max = 0;

    954. 

  954. 					$total_max = 0;

    955. 

  955. 					foreach ($stat_data_sets as $stat_data_set) {

    956. 

  956. 						$feed = 0;

    957. 

  957. 						$web = 0;

    958. 

  958. 						$play = 0;

    959. 

  959. 						switch ($stat_data_set->method) {

    960. 

  960. 							case 'feed' :

    961. 

  961. 								$feed = intval($stat_data_set->downloads);

    962. 

  962. 								$feed_max = max($feed_max, $feed);

    963. 

  963. 							break;

    964. 

  964. 							case 'web' :

    965. 

  965. 								$web = intval($stat_data_set->downloads);

    966. 

  966. 								$web_max = max($web_max, $web);

    967. 

  967. 							break;

    968. 

  968. 							case 'play' :

    969. 

  969. 								$play = intval($stat_data_set->downloads);

    970. 

  970. 								$play_max = max($play_max, $play);

    971. 

  971. 							break;

    972. 

  972. 						}

    973. 

  973. 						$stats[$stat_data_set->media]['feed'] += $feed;

    974. 

  974. 						$stats[$stat_data_set->media]['web'] += $web;

    975. 

  975. 						$stats[$stat_data_set->media]['play'] += $play;

    976. 

  976. 						$stats[$stat_data_set->media]['total'] += ($feed + $web + $play);

    977. 

  977. 						$total_max = max($total_max, $stats[$stat_data_set->media]['total']);

    978. 

  978. 					}

    979. 

  979. 				

    980. 

  980. 					// sort the media files by their 'total' value

    981. 

  981. 					uasort($stats, array(self, 'sort_downloads_per_media_desc'));

    982. 

  982. 

    983. 

  983. 					echo '	<div class="wrap">'."\n";

    984. 

  984. 					echo '		<fieldset class="options">'."\n";

    985. 

  985. 					echo '			<legend>'.__('Post:', 'podpress')." ".$post_titles[$_POST['post_with_podpressmedia']]." - ".__('Downloads Per Media File', 'podpress').'</legend>'."\n";

    986. 

  986. 					echo '			<table class="the-list-x widefat">'."\n";

    987. 

  987. 					echo '				<thead>';

    988. 

  988. 					echo "				<tr>\n";

    989. 

  989. 					echo '                  			<th rowspan="2">'.__('Nr.', 'podpress')."</th>\n";

    990. 

  990. 					echo '                  			<th rowspan="2">'.__('Media File', 'podpress')."</th>\n";

    991. 

  991. 					echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Feed', 'podpress')."</th>\n";

    992. 

  992. 					echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Web', 'podpress')."</th>\n";

    993. 

  993. 					echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Play', 'podpress')."</th>\n";

    994. 

  994. 					echo '                  			<th class="podpress_stats_nr_head" rowspan="2">'.__('Total', 'podpress')."</th>\n";

    995. 

  995. 					echo '              			</tr>'."\n";

    996. 

  996. 					echo '				<tr>'."\n";

    997. 

  997. 					echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    998. 

  998. 					echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    999. 

  999. 					echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    1000. 

  1000. 					echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    1001. 

  1001. 					echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    1002. 

  1002. 					echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    1003. 

  1003. 					echo '              			</tr>'."\n";

    1004. 

  1004. 					echo '				</thead>';

    1005. 

  1005. 					echo '				<tbody>';

    1006. 

  1006. 					$mark_highest = FALSE;

    1007. 

  1007. 					$nr_stat_data_sets = count($stat_data_sets);

    1008. 

  1008. 					if (0 < $nr_stat_data_sets) {

    1009. 

  1009. 						if ( 1 < $nr_stat_data_sets ) {

    1010. 

  1010. 							$mark_highest = TRUE;

    1011. 

  1011. 						}

    1012. 

  1012. 						$i = 0;

    1013. 

  1013. 						foreach ( $stats as $media => $downloads_per_method ) {

    1014. 

  1014. 							$i++;

    1015. 

  1015. 							$style = ($i % 2 != 0) ? '' : ' class="alternate"';

    1016. 

  1016. 							if (TRUE === $mark_highest) {

    1017. 

  1017. 								$highest_feed = ($downloads_per_method['feed'] == $feed_max AND 0 < $feed_max) ? ' podpress_stats_highest': '';

    1018. 

  1018. 								$highest_web = ($downloads_per_method['web'] == $web_max AND 0 < $web_max) ? ' podpress_stats_highest': '';

    1019. 

  1019. 								$highest_play = ($downloads_per_method['play'] == $play_max AND 0 < $play_max) ? ' podpress_stats_highest': '';

    1020. 

  1020. 								$highest_total = ($downloads_per_method['total'] == $total_max AND 0 < $total_max) ? ' podpress_stats_highest': '';

    1021. 

  1021. 							}

    1022. 

  1022. 							$perc_feed = number_format(($downloads_per_method['feed'] * 100 / $downloads_per_method['total']), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1023. 

  1023. 							$perc_web = number_format(($downloads_per_method['web']  * 100 / $downloads_per_method['total']), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1024. 

  1024. 							$perc_play = number_format(($downloads_per_method['play'] * 100 / $downloads_per_method['total']), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1025. 

  1025. 							echo '		<tr'.$style.'>'."\n";

    1026. 

  1026. 							echo '                  	<td>'.($start +$i).'.</td>'."\n";

    1027. 

  1027. 							echo '                  	<td>'.podPress_strlimiter2(urldecode($media), 50, TRUE).'</td>'."\n";

    1028. 

  1028. 							echo '                  	<td class="podpress_stats_numbers_abs'.$highest_feed.'">'.number_format($downloads_per_method['feed'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1029. 

  1029. 							echo '                  	<td class="podpress_stats_numbers_percent'.$highest_feed.'">'.$perc_feed."</td>\n";

    1030. 

  1030. 							echo '                  	<td class="podpress_stats_numbers_abs'.$highest_web.'" >'.number_format($downloads_per_method['web'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1031. 

  1031. 							echo '                  	<td class="podpress_stats_numbers_percent'.$highest_web.'">'.$perc_web."</td>\n";

    1032. 

  1032. 							echo '                  	<td class="podpress_stats_numbers_abs'.$highest_play.'">'.number_format($downloads_per_method['play'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1033. 

  1033. 							echo '                  	<td class="podpress_stats_numbers_percent'.$highest_play.'">'.$perc_play."</td>\n";

    1034. 

  1034. 							echo '                  	<td class="podpress_stats_numbers_total'.$highest_total.'">'.number_format($downloads_per_method['total'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1035. 

  1035. 							echo '		</tr>'."\n";

    1036. 

  1036. 						}

    1037. 

  1037. 					} else {

    1038. 

  1038. 						if (FALSE == empty($where)) {

    1039. 

  1039. 							echo '<td colspan="9">'.__('No downloads yet. (Bots have been filtered.)','podpress')."</td>\n";

    1040. 

  1040. 						} else {

    1041. 

  1041. 							echo '<td colspan="9">'.__('No downloads yet.','podpress')."</td>\n";

    1042. 

  1042. 						}

    1043. 

  1043. 					}

    1044. 

  1044. 					echo '				</tbody>';

    1045. 

  1045. 					echo '				<tfood>'."\n";

    1046. 

  1046. 					echo '				<tr>'."\n";

    1047. 

  1047. 					echo '				<th colspan="9">'."\n";

    1048. 

  1048. 					echo '				</th>'."\n";

    1049. 

  1049. 					echo '              			</tr>'."\n";

    1050. 

  1050. 					echo '				</tfood>'."\n";

    1051. 

  1051. 					echo '			</table>'."\n";

    1052. 

  1052. 					echo '		</fieldset>'."\n";

    1053. 

  1053. 					echo '	</div><!-- .wrap -->'."\n";

    1054. 

  1054. 				}

    1055. 

  1055. 				break;

    1056. 

  1056. 			case 'quickcounts':

    1057. 

  1057. 				// ntm: stat logging: Counts Only

    1058. 

  1058. 				// ntm: 'quickcounts' takes the data from the wp_podpress_statcounts table.

    1059. 

  1059. 				$total= $wpdb->get_var('SELECT COUNT(postID) FROM '.$wpdb->prefix.'podpress_statcounts WHERE postID != 0;');

    1060. 

  1060. 				if ($total > 0) {

    1061. 

  1061. 					// Load highest values

    1062. 

  1062. 					$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';

    1063. 

  1063. 					$highest = $wpdb->get_results($sql);

    1064. 

  1064. 					$highest = $highest[0];

    1065. 

  1065. 					//~ $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 '

    1066. 

  1066. 					//~ 	. 'FROM '.$wpdb->prefix.'podpress_statcounts AS sc, '.$wpdb->prefix.'posts AS p '

    1067. 

  1067. 					//~ 	. 'WHERE (sc.postID = p.ID) ORDER BY p.post_date DESC LIMIT '.$start.', '.$limit.'';

    1068. 

  1068. 					$sql = 'SELECT sc.media, sc.total, sc.feed, sc.web, sc.play '

    1069. 

  1069. 						. 'FROM '.$wpdb->prefix.'podpress_statcounts AS sc '

    1070. 

  1070. 						. 'ORDER BY sc.media DESC LIMIT '.$start.', '.$limit.'';

    1071. 

  1071. 					$stats         = $wpdb->get_results($sql);

    1072. 

  1072. 					$cnt_stats     = count($stats);

    1073. 

  1073. 					

    1074. 

  1074. 					if ( isset($_POST['podPress_submitted']) AND 'sortquickcountsbypost' == $_POST['podPress_submitted'] ) {

    1075. 

  1075. 						foreach ($stats as $stat) {

    1076. 

  1076. 							$where_instr_ar[] = 'INSTR(pm.meta_value, "'.$stat->media.'")';

    1077. 

  1077. 						}

    1078. 

  1078. 						if ( $cnt_stats > 1 ) {

    1079. 

  1079. 							$where_instr = implode(' OR ', $where_instr_ar);

    1080. 

  1080. 						} else {

    1081. 

  1081. 							$where_instr = $where_instr_ar[0];

    1082. 

  1082. 						} 

    1083. 

  1083. 						$where = 'pm.meta_key="podPressMedia" AND ('.$where_instr.')';

    1084. 

  1084. 						$sql = 'SELECT pm.post_id, pm.meta_key, pm.meta_value, p.post_title FROM '.$wpdb->prefix.'postmeta AS pm LEFT JOIN '.$wpdb->prefix.'posts AS p ON pm.post_id = p.ID WHERE '.$where.' ORDER BY pm.post_id DESC';

    1085. 

  1085. 						$postmeta_data = $wpdb->get_results($sql);

    1086. 

  1086. 						

    1087. 

  1087. 						// get the highest post_id of posts which have a certain media file attached with podPress

    1088. 

  1088. 						// in other words get the last post which has a certain media file attached 

    1089. 

  1089. 						foreach ($postmeta_data as $postmeta) {

    1090. 

  1090. 							$postmeta->post_id=intval($postmeta->post_id);

    1091. 

  1091. 							foreach ($stats as $stat) {

    1092. 

  1092. 								if (FALSE !== stristr($postmeta->meta_value, $stat->media)) {

    1093. 

  1093. 									//echo $postmeta->post_id.': '.$stat->media."\n";

    1094. 

  1094. 									$max_post_ids[$stat->media]['ID'] = max($max_post_ids[$stat->media]['ID'], $postmeta->post_id);

    1095. 

  1095. 									if ($max_post_ids[$stat->media]['ID'] == $postmeta->post_id) {

    1096. 

  1096. 										$max_post_ids[$stat->media]['title'] = $postmeta->post_title;

    1097. 

  1097. 									}

    1098. 

  1098. 								}

    1099. 

  1099. 							}

    1100. 

  1100. 						}

    1101. 

  1101. 						foreach ($max_post_ids as $media => $last_published_in_post) {

    1102. 

  1102. 							foreach ($stats as $stat) {

    1103. 

  1103. 								if ($stat->media == $media) {

    1104. 

  1104. 									$stat->postID = $last_published_in_post['ID'];

    1105. 

  1105. 									$stat->post_title = $last_published_in_post['title'];

    1106. 

  1106. 									$stats_new[] = $stat;

    1107. 

  1107. 								}

    1108. 

  1108. 							}

    1109. 

  1109. 						}

    1110. 

  1110. 						$stats=$stats_new;

    1111. 

  1111. 						unset($stats_new);

    1112. 

  1112. 						

    1113. 

  1113. 						echo '	<div class="wrap">'."\n";

    1114. 

  1114. 						echo '		<fieldset class="options">'."\n";

    1115. 

  1115. 						echo '			<legend>'.__('Downloads Per Media File', 'podpress').'</legend>'."\n";

    1116. 

  1116. 						echo '			<p>'.__('sorted by the IDs of the posts in which the media files were last published (descending)', 'podpress').'</p>';

    1117. 

  1117. 						echo '			<table class="the-list-x widefat">'."\n";

    1118. 

  1118. 						echo '				<thead>';

    1119. 

  1119. 						echo "				<tr>\n";

    1120. 

  1120. 						echo '                  			<th rowspan="2">'.__('Nr.', 'podpress')."</th>\n";

    1121. 

  1121. 						echo '                  			<th rowspan="2">'.__('Media File', 'podpress')."</th>\n";

    1122. 

  1122. 						echo '                  			<th rowspan="2">'.__('last published in post', 'podpress')."</th>\n";

    1123. 

  1123. 						echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Feed', 'podpress')."</th>\n";

    1124. 

  1124. 						echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Download', 'podpress')."</th>\n";

    1125. 

  1125. 						echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Play', 'podpress')."</th>\n";

    1126. 

  1126. 						echo '                  			<th class="podpress_stats_nr_head" rowspan="2">'.__('Total', 'podpress')."</th>\n";

    1127. 

  1127. 						echo '              			</tr>'."\n";

    1128. 

  1128. 						echo '				<tr>'."\n";

    1129. 

  1129. 						echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    1130. 

  1130. 						echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    1131. 

  1131. 						echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    1132. 

  1132. 						echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    1133. 

  1133. 						echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    1134. 

  1134. 						echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    1135. 

  1135. 						echo '              			</tr>'."\n";

    1136. 

  1136. 						echo '				</thead>';

    1137. 

  1137. 						echo '				<tbody>';

    1138. 

  1138. 

    1139. 

  1139. 						$date_format = get_option('date_format');

    1140. 

  1140. 						$time_format = get_option('time_format');

    1141. 

  1141. 						

    1142. 

  1142. 						if ($cnt_stats > 0) {

    1143. 

  1143. 							$i = 0;

    1144. 

  1144. 							foreach ($stats AS $stat) {

    1145. 

  1145. 								$i++;

    1146. 

  1146. 								$style = ($i % 2 != 0) ? '' : ' class="alternate"';

    1147. 

  1147. 								$highest_feed = ($stat->feed == $highest->feed AND 0 < $highest->feed) ? ' podpress_stats_highest': '';

    1148. 

  1148. 								$highest_web = ($stat->web == $highest->web AND 0 < $highest->web) ? ' podpress_stats_highest': '';

    1149. 

  1149. 								$highest_play = ($stat->play == $highest->play AND 0 < $highest->play) ? ' podpress_stats_highest': '';

    1150. 

  1150. 								$highest_total = ($stat->total == $highest->total) ? ' podpress_stats_highest': '';

    1151. 

  1151. 								$perc_feed = number_format(($stat->feed * 100 / $stat->total), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1152. 

  1152. 								$perc_web = number_format(($stat->web  * 100 / $stat->total), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1153. 

  1153. 								$perc_play = number_format(($stat->play * 100 / $stat->total), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1154. 

  1154. 								echo '		<tr'.$style.'>'."\n";

    1155. 

  1155. 								echo '                  	<td>'.($start +$i).'.</td>'."\n";

    1156. 

  1156. 								echo '                  	<td>'.podPress_strlimiter2(urldecode($stat->media), 30, TRUE).'</td>'."\n";

    1157. 

  1157. 								if ( TRUE == version_compare($wp_version, '2.3', '<') ) {

    1158. 

  1158. 									echo '                  	<td><a href="'.get_option('siteurl').'/wp-admin/post.php?action=edit&amp;post='.$stat->postID.'" title="'.__('Edit this post','podpress').'">'.podPress_strlimiter2($stat->post_title, 30, TRUE).'</a></td>'."\n";

    1159. 

  1159. 								} else {

    1160. 

  1160. 									echo '                  	<td><a href="'.get_edit_post_link($stat->postID).'" title="'.__('Edit this post','podpress').'">'.podPress_strlimiter2($stat->post_title, 30, TRUE).'</a></td>'."\n";

    1161. 

  1161. 								}

    1162. 

  1162. 								echo '                  	<td class="podpress_stats_numbers_abs'.$highest_feed.'">'.number_format($stat->feed, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1163. 

  1163. 								echo '                  	<td class="podpress_stats_numbers_percent'.$highest_feed.'">'.$perc_feed."</td>\n";

    1164. 

  1164. 								echo '                  	<td class="podpress_stats_numbers_abs'.$highest_web.'" >'.number_format($stat->web, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1165. 

  1165. 								echo '                  	<td class="podpress_stats_numbers_percent'.$highest_web.'">'.$perc_web."</td>\n";

    1166. 

  1166. 								echo '                  	<td class="podpress_stats_numbers_abs'.$highest_play.'">'.number_format($stat->play, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1167. 

  1167. 								echo '                  	<td class="podpress_stats_numbers_percent'.$highest_play.'">'.$perc_play."</td>\n";

    1168. 

  1168. 								echo '                  	<td class="podpress_stats_numbers_total'.$highest_total.'">'.number_format($stat->total, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1169. 

  1169. 								echo '              </tr>'."\n";

    1170. 

  1170. 							}

    1171. 

  1171. 						}

    1172. 

  1172. 						echo '				</tbody>'."\n";

    1173. 

  1173. 						echo '				<tfood>'."\n";

    1174. 

  1174. 						echo '				<tr>'."\n";

    1175. 

  1175. 						echo '				<th colspan="10">'."\n";

    1176. 

  1176. 					} else {

    1177. 

  1177. 						echo '	<div class="wrap">'."\n";

    1178. 

  1178. 						echo '		<fieldset class="options">'."\n";

    1179. 

  1179. 						//echo '			<legend>'.__('The counts', 'podpress').'</legend>'."\n";

    1180. 

  1180. 						echo '			<legend>'.__('Downloads Per Media File', 'podpress').'</legend>'."\n";

    1181. 

  1181. 						echo '			<p>'.__('sorted by the names of the media files (descending)', 'podpress').'</p>';

    1182. 

  1182. 						echo '			<table class="the-list-x widefat">'."\n";

    1183. 

  1183. 						echo '				<thead>';

    1184. 

  1184. 						echo "				<tr>\n";

    1185. 

  1185. 						echo '                  			<th rowspan="2">'.__('Nr.', 'podpress')."</th>\n";

    1186. 

  1186. 						//~ echo '                  			<th rowspan="2">'.__('Post', 'podpress')."</th>\n";

    1187. 

  1187. 						//~ echo '                  			<th rowspan="2">'.__('Publication Date', 'podpress')."</th>\n";

    1188. 

  1188. 						echo '                  			<th rowspan="2">'.__('Media File', 'podpress')."</th>\n";

    1189. 

  1189. 						echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Feed', 'podpress')."</th>\n";

    1190. 

  1190. 						echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Download', 'podpress')."</th>\n";

    1191. 

  1191. 						echo '                  			<th class="podpress_stats_nr_head" colspan="2">'.__('Play', 'podpress')."</th>\n";

    1192. 

  1192. 						echo '                  			<th class="podpress_stats_nr_head" rowspan="2">'.__('Total', 'podpress')."</th>\n";

    1193. 

  1193. 						echo '              			</tr>'."\n";

    1194. 

  1194. 						echo '				<tr>'."\n";

    1195. 

  1195. 						echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    1196. 

  1196. 						echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    1197. 

  1197. 						echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    1198. 

  1198. 						echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    1199. 

  1199. 						echo '                  			<th class="podpress_stats_nr_head">'.__('Files', 'podpress')."</th>\n";

    1200. 

  1200. 						echo '                  			<th class="podpress_stats_nr_head">'.__('%', 'podpress')."</th>\n";

    1201. 

  1201. 						echo '              			</tr>'."\n";

    1202. 

  1202. 						echo '				</thead>';

    1203. 

  1203. 						echo '				<tbody>';

    1204. 

  1204. 

    1205. 

  1205. 						$date_format = get_option('date_format');

    1206. 

  1206. 						$time_format = get_option('time_format');

    1207. 

  1207. 						

    1208. 

  1208. 						if ($cnt_stats > 0) {

    1209. 

  1209. 							$i = 0;

    1210. 

  1210. 							foreach ($stats AS $stat) {

    1211. 

  1211. 								$i++;

    1212. 

  1212. 								$style = ($i % 2 != 0) ? '' : ' class="alternate"';

    1213. 

  1213. 								$highest_feed = ($stat->feed == $highest->feed AND 0 < $highest->feed) ? ' podpress_stats_highest': '';

    1214. 

  1214. 								$highest_web = ($stat->web == $highest->web AND 0 < $highest->web) ? ' podpress_stats_highest': '';

    1215. 

  1215. 								$highest_play = ($stat->play == $highest->play AND 0 < $highest->play) ? ' podpress_stats_highest': '';

    1216. 

  1216. 								$highest_total = ($stat->total == $highest->total) ? ' podpress_stats_highest': '';

    1217. 

  1217. 								$perc_feed = number_format(($stat->feed * 100 / $stat->total), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1218. 

  1218. 								$perc_web = number_format(($stat->web  * 100 / $stat->total), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1219. 

  1219. 								$perc_play = number_format(($stat->play * 100 / $stat->total), 1, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1220. 

  1220. 								echo '		<tr'.$style.'>'."\n";

    1221. 

  1221. 								echo '                  	<td>'.($start +$i).'.</td>'."\n";

    1222. 

  1222. 								//~ if ( TRUE == version_compare($wp_version, '2.3', '<') ) {

    1223. 

  1223. 									//~ echo '                  	<td><a href="'.get_option('siteurl').'/wp-admin/post.php?action=edit&amp;post='.$stat->postID.'" title="'.__('Edit this post','podpress').'">'.podPress_strlimiter2($stat->post_title, 30, TRUE).'</a></td>'."\n";

    1224. 

  1224. 								//~ } else {

    1225. 

  1225. 									//~ echo '                  	<td><a href="'.get_edit_post_link($stat->postID).'" title="'.__('Edit this post','podpress').'">'.podPress_strlimiter2($stat->post_title, 30, TRUE).'</a></td>'."\n";

    1226. 

  1226. 								//~ }

    1227. 

  1227. 								//~ echo '                  	<td>'.date($date_format.' - '.$time_format, $stat->pdate).'</td>'."\n";

    1228. 

  1228. 								echo '                  	<td>'.podPress_strlimiter2(urldecode($stat->media), 30, TRUE).'</td>'."\n";

    1229. 

  1229. 								echo '                  	<td class="podpress_stats_numbers_abs'.$highest_feed.'">'.number_format($stat->feed, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1230. 

  1230. 								echo '                  	<td class="podpress_stats_numbers_percent'.$highest_feed.'">'.$perc_feed."</td>\n";

    1231. 

  1231. 								echo '                  	<td class="podpress_stats_numbers_abs'.$highest_web.'" >'.number_format($stat->web, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1232. 

  1232. 								echo '                  	<td class="podpress_stats_numbers_percent'.$highest_web.'">'.$perc_web."</td>\n";

    1233. 

  1233. 								echo '                  	<td class="podpress_stats_numbers_abs'.$highest_play.'">'.number_format($stat->play, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1234. 

  1234. 								echo '                  	<td class="podpress_stats_numbers_percent'.$highest_play.'">'.$perc_play."</td>\n";

    1235. 

  1235. 								echo '                  	<td class="podpress_stats_numbers_total'.$highest_total.'">'.number_format($stat->total, 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1])."</td>\n";

    1236. 

  1236. 								echo '              </tr>'."\n";

    1237. 

  1237. 							}

    1238. 

  1238. 						}

    1239. 

  1239. 						echo '				</tbody>'."\n";

    1240. 

  1240. 						echo '				<tfood>'."\n";

    1241. 

  1241. 						echo '				<tr>'."\n";

    1242. 

  1242. 						//~ echo '				<th colspan="11">'."\n";

    1243. 

  1243. 						echo '				<th colspan="9">'."\n";

    1244. 

  1244. 					}

    1245. 

  1245. 					

    1246. 

  1246. 					// Show paging

    1247. 

  1247. 					if ($_GET['display'] != 'graphbydate' && $_GET['display'] != 'graphbypost') {

    1248. 

  1248. 						echo $this->paging2($start, $limit, $total, __('Nr.', 'podpress'));

    1249. 

  1249. 					}

    1250. 

  1250. 					

    1251. 

  1251. 					echo '				</th>'."\n";

    1252. 

  1252. 					echo '              			</tr>'."\n";

    1253. 

  1253. 					echo '				</tfood>'."\n";

    1254. 

  1254. 					echo '			</table>'."\n";

    1255. 

  1255. 					

    1256. 

  1256. 					echo '			<form method="post">'."\n";

    1257. 

  1257. 					echo '			<p class="submit"> '."\n";

    1258. 

  1258. 					

    1259. 

  1259. 					if ( isset($_POST['podPress_submitted']) AND 'sortquickcountsbypost' == $_POST['podPress_submitted'] ) {

    1260. 

  1260. 						echo '				<input type="submit" name="Submit" value="'.__('sort the media files by their names', 'podpress').' &raquo;" /><br />'."\n";

    1261. 

  1261. 					} else {

    1262. 

  1262. 						echo '				<input type="submit" name="Submit" value="'.__('sort the media files by the IDs of the posts in which they were last published', 'podpress').' &raquo;" /><br />'."\n";

    1263. 

  1263. 						echo '				<input type="hidden" name="podPress_submitted" value="sortquickcountsbypost" />'."\n";

    1264. 

  1264. 					}

    1265. 

  1265. 					echo '			</p> '."\n";

    1266. 

  1266. 					echo '			</form>'."\n";

    1267. 

  1267. 					

    1268. 

  1268. 					echo '		</fieldset>'."\n";

    1269. 

  1269. 					echo '	</div>';

    1270. 

  1270. 				} else {

    1271. 

  1271. 					echo '<p>'.__('We\'re sorry. At the moment we don\'t have enough data collected to display the graph.', 'podpress')."</p>\n";

    1272. 

  1272. 				}

    1273. 

  1273. 			break;

    1274. 

  1274. 			default:

    1275. 

  1275. 			return;

    1276. 

  1276. 		}

    1277. 

  1277. 		echo '<div style="clear: both;"></div>'."\n";

    1278. 

  1278. 		echo '</div>';

    1279. 

  1279. 	}

    1280. 

  1280. 	

    1281. 

  1281. 	#############################################

    1282. 

  1282. 	#############################################

    1283. 

  1283. 

    1284. 

  1284. 	/**

    1285. 

  1285. 	* sort_downloads_per_media_asc - is a callback function to sort arrays by their 'total' value ascending

    1286. 

  1286. 	* for more info: http://www.php.net/manual/en/function.uasort.php

    1287. 

  1287. 	*

    1288. 

  1288. 	* @package podPress

    1289. 

  1289. 	* @since 8.8.5 beta 3

    1290. 

  1290. 	*

    1291. 

  1291. 	* @param int $a

    1292. 

  1292. 	* @param int $b

    1293. 

  1293. 	*

    1294. 

  1294. 	* @return int 0 => equal, -1 => $a < $b, 1 => $a > $b

    1295. 

  1295. 	*/

    1296. 

  1296. 	function sort_downloads_per_media_asc($a, $b) {

    1297. 

  1297. 		if ($a['total'] == $b['total']) {

    1298. 

  1298. 			return 0;

    1299. 

  1299. 		}

    1300. 

  1300. 		return ($a['total'] < $b['total']) ? -1 : 1;

    1301. 

  1301. 	}

    1302. 

  1302. 	

    1303. 

  1303. 	#############################################

    1304. 

  1304. 	#############################################

    1305. 

  1305. 

    1306. 

  1306. 	/**

    1307. 

  1307. 	* sort_downloads_per_media_desc - is a callback function to sort arrays by their 'total' value descending

    1308. 

  1308. 	* for more info: http://www.php.net/manual/en/function.uasort.php

    1309. 

  1309. 	*

    1310. 

  1310. 	* @package podPress

    1311. 

  1311. 	* @since 8.8.5 beta 3

    1312. 

  1312. 	*

    1313. 

  1313. 	* @param int $a

    1314. 

  1314. 	* @param int $b

    1315. 

  1315. 	*

    1316. 

  1316. 	* @return int 0 => equal, -1 => $a < $b, 1 => $a > $b

    1317. 

  1317. 	*/

    1318. 

  1318. 	function sort_downloads_per_media_desc($a, $b) {

    1319. 

  1319. 		if ($a['total'] == $b['total']) {

    1320. 

  1320. 			return 0;

    1321. 

  1321. 		}

    1322. 

  1322. 		return ($a['total'] > $b['total']) ? -1 : 1;

    1323. 

  1323. 	}

    1324. 

  1324. 	

    1325. 

  1325. 	#############################################

    1326. 

  1326. 	#############################################

    1327. 

  1327. 

    1328. 

  1328. 	/**

    1329. 

  1329. 	 * Check GD-Library-Support

    1330. 

  1330. 	 *

    1331. 

  1331. 	 * @return unknown

    1332. 

  1332. 	 */

    1333. 

  1333. 	function checkGD() {

    1334. 

  1334. 	    if (!function_exists('gd_info')) {

    1335. 

  1335. 	        /* php > 4.3 */

    1336. 

  1336.     		$info = gd_info();

    1337. 

  1337.     		if (isset($info) AND ($info['JPG Support'] == 1) AND ($info['FreeType Support'] == 1)) {

    1338. 

  1338.     			return true;

    1339. 

  1339.     		}

    1340. 

  1340. 	    } else {

    1341. 

  1341. 	        /* php < 4.3 */

    1342. 

  1342.             ob_start();

    1343. 

  1343.             phpinfo(8);

    1344. 

  1344.             $info   = ob_get_contents();

    1345. 

  1345.             ob_end_clean();

    1346. 

  1346.             $info   = stristr($info, 'gd version');

    1347. 

  1347.             preg_match('/\d/', $info, $match);

    1348. 

  1348.             $gd_ver = $match[0];

    1349. 

  1349.             if ($gd_ver > 0) {

    1350. 

  1350.                 return true;

    1351. 

  1351.             }

    1352. 

  1352. 	   }

    1353. 

  1353. 		return false;

    1354. 

  1354. 	}

    1355. 

  1355. 

    1356. 

  1356. 	#############################################

    1357. 

  1357. 	#############################################

    1358. 

  1358. 

    1359. 

  1359. 	function checkFontFile() {

    1360. 

  1360. 		clearstatcache();

    1361. 

  1361. 

    1362. 

  1362. 		/* check font */

    1363. 

  1363. 		$file     = 'share-regular.ttf';

    1364. 

  1364. 		$fontface = ABSPATH.PLUGINDIR.'/podpress/optional_files/'.$file;

    1365. 

  1365. 		if (!file_exists($fontface)) {

    1366. 

  1366. 			$fontface = '../optional_files/'.$file;

    1367. 

  1367. 		}

    1368. 

  1368. 		if (!is_readable($fontface)) {

    1369. 

  1369. 			echo '<p>'.__('Could not include font-file. Please reinstall podPress.', 'podpress')."</p>\n";

    1370. 

  1370. 			return false;

    1371. 

  1371. 		}

    1372. 

  1372. 		$this->fontface = $fontface;

    1373. 

  1373. 

    1374. 

  1374. 		return true;

    1375. 

  1375. 	}

    1376. 

  1376. 

    1377. 

  1377. 	#############################################

    1378. 

  1378. 	#############################################

    1379. 

  1379. 

    1380. 

  1380. 	function graphByDate() {

    1381. 

  1381. 		// ntm: stat logging: Full and Full+

    1382. 

  1382. 		if ($this->checkWritableTempFileDir() && $this->checkFontFile()) {

    1383. 

  1383. 			$chronometry1 = getmicrotime();

    1384. 

  1384. 			$start        = (isset($_GET['start'])) ? $this->podSafeDigit($_GET['start']): 0;

    1385. 

  1385. 			$image_width  = 1800;

    1386. 

  1386. 			$image_height = 470;

    1387. 

  1387. 			$col_width    = 20;

    1388. 

  1388. 			$filename     = 'graph-by-date.jpg';

    1389. 

  1389. 			$file         = $this->tempFileSystemPath.'/'.$filename;

    1390. 

  1390. 			$sidemargin   = 20;

    1391. 

  1391. 			$baseline     = ($image_height - 90);

    1392. 

  1392. 			$topmargin    = 60;

    1393. 

  1393. 			$maxheight    = ($baseline - $topmargin);

    1394. 

  1394. 			$weeks        = 15;

    1395. 

  1395. 			$timelimit    = (time() - (($weeks * 7) * 86400));

    1396. 

  1396. 			$min_downloaddays = 4;

    1397. 

  1397. 			

    1398. 

  1398. 			ini_set('memory_limit', '120M');

    1399. 

  1399. 			ini_set('max_execution_time', '60');

    1400. 

  1400. 			$start_memory = memory_get_usage();

    1401. 

  1401. 			$where = $this->wherestr_to_exclude_bots('', 'AND');

    1402. 

  1402. 			/* get the data in time range ($timelimit) */

    1403. 

  1403. 			$query        = 'SELECT dt AS timestamp, DAYOFWEEK(FROM_UNIXTIME(dt)) AS weekday, method, '

    1404. 

  1404.                           . 'DATE_FORMAT(FROM_UNIXTIME(dt), "%Y-%m-%d") AS day '

    1405. 

  1405.                           . 'FROM '.$this->wpdb->prefix."podpress_stats WHERE dt >= '".$timelimit."' ".$where

    1406. 

  1406.                           . 'ORDER BY dt ASC;';

    1407. 

  1407. 			$data         = $this->wpdb->get_results($query);

    1408. 

  1408. 

    1409. 

  1409. 			/* create array with grouped stats */

    1410. 

  1410. 			$stats        = array();

    1411. 

  1411. 			$stats_total  = array();

    1412. 

  1412. 			foreach ($data AS $idata) {

    1413. 

  1413. 				$stats[$idata->day][$idata->method]++;

    1414. 

  1414. 				$stats[$idata->day]['total']++;

    1415. 

  1415. 				$stats_total[$idata->method]++;

    1416. 

  1416. 				$stats_total['total']++;

    1417. 

  1417. 			}

    1418. 

  1418. 

    1419. 

  1419. 			/* get min an max values */

    1420. 

  1420. 			$value_min = 0;

    1421. 

  1421. 			$value_max = 0;

    1422. 

  1422. 			$i         = 0;

    1423. 

  1423. 			$cnt_days  = count($stats);

    1424. 

  1424. 			foreach ($stats AS $day => $idata) {

    1425. 

  1425. 				/* set min and max values */

    1426. 

  1426. 				if ($value_min == 0) {

    1427. 

  1427. 					$value_min = $idata['total'];

    1428. 

  1428. 				} elseif ($idata['total'] < $value_min) {

    1429. 

  1429. 					$value_min = $idata['total'];

    1430. 

  1430. 				} elseif ($idata['total'] > $value_max) {

    1431. 

  1431. 					$value_max = $idata['total'];

    1432. 

  1432. 				}

    1433. 

  1433. 				/* set first and last day */

    1434. 

  1434. 				if ($i == 0) {

    1435. 

  1435. 					$first_day = strtotime($day);

    1436. 

  1436. 				} elseif ($i == ($cnt_days - 1)) {

    1437. 

  1437. 					$last_day  = strtotime($day);

    1438. 

  1438. 				}

    1439. 

  1439. 				$i++;

    1440. 

  1440. 			}

    1441. 

  1441. 

    1442. 

  1442. 			/* Do we have enough data? */

    1443. 

  1443. 			if (($value_max > 0) && ($cnt_days >= $min_downloaddays)) {

    1444. 

  1444. 				$h_cscale = ($maxheight / $value_max);

    1445. 

  1445. 				$h_vscale = ($maxheight / $value_min / 4);

    1446. 

  1446. 				$pos_x    = ($sidemargin + 35);

    1447. 

  1447. 				$points   = array( 'total' => array(0 => $pos_x, 1 => $baseline) );

    1448. 

  1448. 				foreach ($stats AS $day => $idata) {

    1449. 

  1449. 					$points['total'][] = $pos_x;

    1450. 

  1450. 					$points['total'][] = ($baseline - ($idata['total'] * $h_cscale));

    1451. 

  1451. 					$points['feed'][]  = ($baseline - ($idata['feed'] * $h_cscale));

    1452. 

  1452. 					$points['web'][]   = ($baseline - ($idata['web'] * $h_cscale));

    1453. 

  1453. 					$points['play'][]  = ($baseline - ($idata['play'] * $h_cscale));

    1454. 

  1454. 					$pos_x             = ($pos_x + $col_width);

    1455. 

  1455. 				}

    1456. 

  1456. 				$points['total'][] = ($pos_x - $col_width);

    1457. 

  1457. 				$points['total'][] = $baseline;

    1458. 

  1458. 

    1459. 

  1459. 

    1460. 

  1460. 				/* create image */

    1461. 

  1461. 				$chronometry2 = getmicrotime();

    1462. 

  1462. 				$image        = imagecreatetruecolor($image_width, $image_height);

    1463. 

  1463. 				if (function_exists('imageantialias')) {

    1464. 

  1464. 					imageantialias($image, 1);

    1465. 

  1465. 				}

    1466. 

  1466. 

    1467. 

  1467. 				/* set colors */

    1468. 

  1468. 				$colors = array(

    1469. 

  1469. 						'background' => imagecolorallocate($image, 51, 51, 51),

    1470. 

  1470. 						'line'       => imagecolorallocate($image, 79, 79, 79),

    1471. 

  1471. 						'total'      => imagecolorallocate($image, 79, 79, 79),

    1472. 

  1472. 						'feed'       => imagecolorallocate($image, 255, 0, 0),

    1473. 

  1473. 						'web'        => imagecolorallocate($image, 12, 223, 0),

    1474. 

  1474. 						'play'       => imagecolorallocate($image, 223, 204, 0),

    1475. 

  1475. 						'text'       => imagecolorallocate($image, 255, 255, 255),

    1476. 

  1476. 						'copytext'   => imagecolorallocate($image, 79, 79, 79),

    1477. 

  1477. 						'days_first' => imagecolorallocate($image, 143, 143, 143),

    1478. 

  1478. 						'days_other' => imagecolorallocate($image, 95, 95, 95),

    1479. 

  1479. 						/* gray-scales: 175 159 143 127 111 95 79 63 */

    1480. 

  1480. 					       );

    1481. 

  1481. 				imagefill($image, 0, 0, $colors['background']);

    1482. 

  1482. 

    1483. 

  1483. 				/* create the legend */

    1484. 

  1484. 				imagettftext($image, 14, 0, $sidemargin, 25, $colors['text'], $this->fontface, get_option('blogname'));

    1485. 

  1485. 				imagettftext($image, 8, 0, $sidemargin, 42, $colors['text'], $this->fontface, sprintf(__('last %1$s weeks', 'podpress'), $weeks).' &#187; '.strftime('%d.%m.%Y', $first_day).' - '.strftime('%d.%m.%Y', $last_day));

    1486. 

  1486. 

    1487. 

  1487. 				/* Total stats */

    1488. 

  1488. 				$text_total = number_format($stats_total['total'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1489. 

  1489. 				$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]).'%)';

    1490. 

  1490. 				$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]).'%)';

    1491. 

  1491. 				$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]).'%)';

    1492. 

  1492. 				$text_total = html_entity_decode(__('Total stats in time range', 'podpress')).':  '.$text_total.'  /  '.__('Feed', 'podpress').': '.$text_feed.'  /  '.__('Download', 'podpress').': '.$text_web.'  /  '.__('Play', 'podpress').': '.$text_play.' ';

    1493. 

  1493. 				imagettftext($image, 8, 0, $sidemargin, ($image_height - 15), $colors['text'], $this->fontface, $text_total);

    1494. 

  1494. 

    1495. 

  1495. 				$pos_y = ($image_height - 32);

    1496. 

  1496. 

    1497. 

  1497. 				imagefilledrectangle($image, ($sidemargin + 0), ($pos_y - 10), ($sidemargin + 10), ($pos_y - 0), $colors['total']);

    1498. 

  1498. 				imagettftext($image, 8, 0, ($sidemargin + 15), $pos_y, $colors['text'], $this->fontface, __('Total', 'podpress'));

    1499. 

  1499. 

    1500. 

  1500. 				imageline($image, ($sidemargin + 50), ($pos_y - 4), ($sidemargin + 60), ($pos_y - 4), $colors['feed']);

    1501. 

  1501. 				imagettftext($image, 8, 0, ($sidemargin + 65), $pos_y, $colors['text'], $this->fontface, __('Feed', 'podpress'));

    1502. 

  1502. 

    1503. 

  1503. 				imageline($image, ($sidemargin + 100), ($pos_y - 4), ($sidemargin + 110), ($pos_y - 4), $colors['web']);

    1504. 

  1504. 				imagettftext($image, 8, 0, ($sidemargin + 115), $pos_y, $colors['text'], $this->fontface, __('Download', 'podpress'));

    1505. 

  1505. 

    1506. 

  1506. 				imageline($image, ($sidemargin + 175), ($pos_y - 4), ($sidemargin + 185), ($pos_y - 4), $colors['play']);

    1507. 

  1507. 				imagettftext($image, 8, 0, ($sidemargin + 190), $pos_y, $colors['text'], $this->fontface, __('Play', 'podpress'));

    1508. 

  1508. 

    1509. 

  1509. 				imagettftext($image, 23, 0, ($image_width - 128), 30, $colors['copytext'], $this->fontface, 'podPress');

    1510. 

  1510. 				imagettftext($image, 8, 0, ($image_width - 115), 43, $colors['copytext'], $this->fontface, __('Plugin for WordPress', 'podpress'));

    1511. 

  1511. 

    1512. 

  1512. 				imagettftext($image, 6, 90, ($image_width - 15), ($image_height - 10), $colors['copytext'], $this->fontface, strftime($this->local_settings['creation_date'], time()).' ('.PODPRESS_VERSION.')');

    1513. 

  1513. 

    1514. 

  1514. 				/* draw total-stats */

    1515. 

  1515. 				$cnt_total = (count($points['total']) / 2);

    1516. 

  1516. 				imagefilledpolygon($image, $points['total'], $cnt_total, $colors['total']);

    1517. 

  1517. 

    1518. 

  1518. 				/* draw background-lines and scale-text */

    1519. 

  1519. 				$step = 0;

    1520. 

  1520. 				$h    = (($baseline - $topmargin) / 10);

    1521. 

  1521. 				while ($step <=  10) {

    1522. 

  1522. 					$pos_y = ($topmargin + ($h * $step));

    1523. 

  1523. 					imageline($image, 0, ($topmargin + ($h * $step)), $image_width, ($topmargin + ($h * $step)), $colors['line']);

    1524. 

  1524. 					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]));

    1525. 

  1525. 					$step++;

    1526. 

  1526. 				}

    1527. 

  1527. 

    1528. 

  1528. 				$pos_x    = ($sidemargin + 35);

    1529. 

  1529. 				foreach ($stats AS $day => $idata) {

    1530. 

  1530. 					/* Web einzeichnen */

    1531. 

  1531. 					$weekday          = date('w', strtotime($day));

    1532. 

  1532. 					$col_total_height = ($idata['total'] * $h_cscale);

    1533. 

  1533. 

    1534. 

  1534. 					if ($weekday == 1) {

    1535. 

  1535. 						$pos_y_start = ($baseline + 27);

    1536. 

  1536. 						imagettftext($image, 8, 0, ($pos_x + 3), ($baseline + 13), $colors['text'], $this->fontface, strftime($this->local_settings['short_date'], strtotime($day)));

    1537. 

  1537. 						$color       = $colors['days_first'];

    1538. 

  1538. 					} else {

    1539. 

  1539. 						$pos_y_start = $baseline;

    1540. 

  1540. 						$color       = $colors['days_other'];

    1541. 

  1541. 					}

    1542. 

  1542. 					imageline($image, $pos_x, $pos_y_start, $pos_x, ($baseline - $col_total_height), $color);

    1543. 

  1543. 

    1544. 

  1544. 					$pos_x = ($pos_x + $col_width);

    1545. 

  1545. 				}

    1546. 

  1546. 

    1547. 

  1547. 

    1548. 

  1548. 				/* Linien zeichen */

    1549. 

  1549. 				$topics = array('feed', 'web', 'play');

    1550. 

  1550. 				foreach ($topics AS $topic) {

    1551. 

  1551. 					$cnt_points = count($points[$topic]);

    1552. 

  1552. 					$pos_x      = ($sidemargin + 35);

    1553. 

  1553. 					for ($i = 0; $i < ($cnt_points - 1); $i++) {

    1554. 

  1554. 						imageline($image, $pos_x, $points[$topic][$i], ($pos_x + $col_width), $points[$topic][$i + 1], $colors[$topic]);

    1555. 

  1555. 						$pos_x = ($pos_x + $col_width);

    1556. 

  1556. 					}

    1557. 

  1557. 				}

    1558. 

  1558. 

    1559. 

  1559. 				imagejpeg($image, $file, 100);

    1560. 

  1560. 				$chronometry_end = getmicrotime();

    1561. 

  1561. 				$chronometry1    = ($chronometry_end - $chronometry1);

    1562. 

  1562. 				$chronometry2    = ($chronometry_end - $chronometry2);

    1563. 

  1563. 				imagedestroy($image);

    1564. 

  1564. 

    1565. 

  1565. 						$end_memory = memory_get_usage();

    1566. 

  1566. 						$memory_used = podPress_bytes($end_memory-$start_memory);

    1567. 

  1567. 				/* Output */

    1568. 

  1568. 				echo '<div id="podPress_graph" style="width: '.$image_width.'px;">'."\n";

    1569. 

  1569. 				echo '    <p><img src="'.$this->tempFileURLPath.'/'.$filename.'" width="'.$image_width.'" height="'.$image_height.'" alt="podPress-Statistics" /></p>'."\n";

    1570. 

  1570. 				echo "</div>\n";

    1571. 

  1571. 				echo '<p>'.__('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";

    1572. 

  1572. 				echo '<br/>'.__('Memory to generate the graph', 'podpress').': '.$memory_used.".</p>\n";

    1573. 

  1573. 			} else {

    1574. 

  1574. 				echo '<p>'.sprintf(__('We\'re sorry. At the moment we don\'t have enough data collected to display the graph. (Downloads on %1$s different days are necessary)', 'podpress'), $min_downloaddays)."</p>\n";

    1575. 

  1575. 			}

    1576. 

  1576. 		}

    1577. 

  1577. 	}

    1578. 

  1578. 

    1579. 

  1579. 	#############################################

    1580. 

  1580. 	#############################################

    1581. 

  1581. 

    1582. 

  1582. 	function graphByDateAlt($msg = '') {

    1583. 

  1583. 		// ntm: stat logging: Full and Full+

    1584. 

  1584. 		GLOBAL $wpdb;

    1585. 

  1585. 		$where = $this->wherestr_to_exclude_bots();

    1586. 

  1586. 		$sql      = 'SELECT DATE_FORMAT(FROM_UNIXTIME(dt), "%a, %Y-%m-%d") AS title, DAYOFWEEK(FROM_UNIXTIME(dt)) AS weekday, COUNT(id) AS value '

    1587. 

  1587. 		          . 'FROM '.$wpdb->prefix.'podpress_stats '.$where.'GROUP BY title ORDER BY dt DESC LIMIT 0, 100;';

    1588. 

  1588.  		$data     = $wpdb->get_results($sql);

    1589. 

  1589.  		$data     = array_reverse($data);

    1590. 

  1590.  		$splitter = array('weekday', '2');

    1591. 

  1591. 

    1592. 

  1592.  		echo '	<div class="wrap">'."\n";

    1593. 

  1593.  		echo '		<fieldset class="options">'."\n";

    1594. 

  1594.  		echo '			<legend>'.__('Downloads by date', 'podpress').' ('.__('Last 100 days', 'podpress').')</legend>'."\n";

    1595. 

  1595.  		echo $this->podGraph($data, $splitter);

    1596. 

  1596. 		if($msg != '') {

    1597. 

  1597. 			echo '      <p>'.$msg."</p>\n";

    1598. 

  1598. 		}

    1599. 

  1599. 		echo '		</fieldset>'."\n";

    1600. 

  1600. 		echo '	</div>';

    1601. 

  1601. 	}

    1602. 

  1602. 

    1603. 

  1603. 	#############################################

    1604. 

  1604. 	#############################################

    1605. 

  1605. 

    1606. 

  1606. 	function graphByPost() {

    1607. 

  1607. 		// ntm: stat logging: Counts Only

    1608. 

  1608. 		if ($this->checkWritableTempFileDir() && $this->checkFontFile()) {

    1609. 

  1609. 			$chronometry1 = getmicrotime();

    1610. 

  1610. 			$start        = (isset($_GET['start'])) ? $this->podSafeDigit($_GET['start']): 0;

    1611. 

  1611. 			$limit        = 20;

    1612. 

  1612. 			$image_width  = 1200;

    1613. 

  1613. 			$image_height = 470;

    1614. 

  1614. 			$col_width    = 25;

    1615. 

  1615. 			$col_space    = 15;

    1616. 

  1616. 			$filename     = 'graph-by-post.jpg';

    1617. 

  1617. 			$file         = $this->tempFileSystemPath.'/'.$filename;

    1618. 

  1618. 			$sidemargin   = 20;

    1619. 

  1619. 			$baseline     = ($image_height - 90);

    1620. 

  1620. 			$topmargin    = 60;

    1621. 

  1621. 			$maxheight    = ($baseline - $topmargin);

    1622. 

  1622. 			$timelimit    = (time() - ((5 * 7) * 86400));

    1623. 

  1623. 

    1624. 

  1624. 			ini_set('memory_limit', '120M');

    1625. 

  1625. 			ini_set('max_execution_time', '60');

    1626. 

  1626. 			$start_memory = memory_get_usage();

    1627. 

  1627. 			/* get data */

    1628. 

  1628. 			$total        = $this->wpdb->get_var('SELECT COUNT(postID) FROM '.$this->wpdb->prefix."podpress_statcounts WHERE postID != 0;");

    1629. 

  1629. 			$query        = 'SELECT post_title AS title, total, feed, web, play, UNIX_TIMESTAMP(post_date) AS post_date '

    1630. 

  1630. 			              . 'FROM '.$this->wpdb->prefix.'podpress_statcounts, '.$this->wpdb->prefix.'posts '

    1631. 

  1631. 			              . 'WHERE '.$this->wpdb->prefix.'posts.ID = '.$this->wpdb->prefix.'podpress_statcounts.postID '

    1632. 

  1632. 			              . 'AND postID !=0 GROUP BY postID ORDER BY post_date DESC LIMIT '.$start.', '.$limit.';';

    1633. 

  1633. 			$data         = $this->wpdb->get_results($query);

    1634. 

  1634. 			

    1635. 

  1635. 			$cnt_data     = count($data);

    1636. 

  1636. 

    1637. 

  1637. 			$first_post   = $data[($cnt_data - 1)]->post_date;

    1638. 

  1638. 			$last_post    = $data[0]->post_date;

    1639. 

  1639. 

    1640. 

  1640. 			$stats        = array();

    1641. 

  1641. 			foreach ($data AS $idata) {

    1642. 

  1642. 				$stats[$idata->day][$idata->method]++;

    1643. 

  1643. 				$stats[$idata->day]['total']++;

    1644. 

  1644. 				$stats_total[$idata->method]++;

    1645. 

  1645. 				$stats_total['total']++;

    1646. 

  1646. 			}

    1647. 

  1647. 

    1648. 

  1648. 			/* get min an max values */

    1649. 

  1649. 			$value_min   = 0;

    1650. 

  1650. 			$value_max   = 0;

    1651. 

  1651. 			$stats_total = array();

    1652. 

  1652. 			foreach ($data AS $idata) {

    1653. 

  1653. 				if ($value_min == 0) {

    1654. 

  1654. 					$value_min = $idata->total;

    1655. 

  1655. 				} elseif ($idata->total < $value_min) {

    1656. 

  1656. 					$value_min = $idata->total;

    1657. 

  1657. 				}

    1658. 

  1658. 				if ($idata->total > $value_max) {

    1659. 

  1659. 					$value_max = $idata->total;

    1660. 

  1660. 				}

    1661. 

  1661. 				$stats_total['feed']  = ($stats_total['feed'] + $idata->feed);

    1662. 

  1662. 				$stats_total['web']   = ($stats_total['web'] + $idata->web);

    1663. 

  1663. 				$stats_total['play']  = ($stats_total['play'] + $idata->play);

    1664. 

  1664. 				$stats_total['total'] = ($stats_total['total'] + $idata->total);

    1665. 

  1665. 			}

    1666. 

  1666. 

    1667. 

  1667. 			/* Do we have enough data? */

    1668. 

  1668. 			if (intval($value_max) > 0) {

    1669. 

  1669. 				$h_cscale    = ($maxheight / $value_max);

    1670. 

  1670. 				$h_vscale    = ($maxheight / $value_min / 4);

    1671. 

  1671. 				$w_scale     = intval($image_width - (2 * $sidemargin) + intval(($image_width - (2 * $sidemargin)) / ($limit) / 4)) / ($limit);

    1672. 

  1672. 

    1673. 

  1673. 				/* create image */

    1674. 

  1674. 				$chronometry2 = getmicrotime();

    1675. 

  1675. 				$image        = imagecreatetruecolor($image_width, $image_height);

    1676. 

  1676. 				if (function_exists('imageantialias')) {

    1677. 

  1677. 					imageantialias($image, 1);

    1678. 

  1678. 				}

    1679. 

  1679. 

    1680. 

  1680. 				$colors = array(

    1681. 

  1681. 						'background' => imagecolorallocate($image, 51, 51, 51),

    1682. 

  1682. 						'line'       => imagecolorallocate($image, 79, 79, 79),

    1683. 

  1683. 						'text'       => imagecolorallocate($image, 255, 255, 255),

    1684. 

  1684. 						'copytext'   => imagecolorallocate($image, 79, 79, 79),

    1685. 

  1685. 						'total'      => imagecolorallocate($image, 0, 0, 0),

    1686. 

  1686. 						'feed'       => imagecolorallocate($image, 143, 53, 53),

    1687. 

  1687. 						'web'        => imagecolorallocate($image, 71, 143, 88),

    1688. 

  1688. 						'play'       => imagecolorallocate($image, 142, 143, 71),

    1689. 

  1689. 					      );

    1690. 

  1690. 

    1691. 

  1691. 				imagefill($image, 0, 0, $colors['background']);

    1692. 

  1692. 

    1693. 

  1693. 				/* draw background-lines and scale-text */

    1694. 

  1694. 				$step = 0;

    1695. 

  1695. 				$h    = (($baseline - $topmargin) / 10);

    1696. 

  1696. 				while ($step <=  10) {

    1697. 

  1697. 					$pos_y = ($topmargin + ($h * $step));

    1698. 

  1698. 					imageline($image, 0, ($topmargin + ($h * $step)), $image_width, ($topmargin + ($h * $step)), $colors['line']);

    1699. 

  1699. 					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]));

    1700. 

  1700. 					$step++;

    1701. 

  1701. 				}

    1702. 

  1702. 

    1703. 

  1703. 				/* create the legend */

    1704. 

  1704. 				imagettftext($image, 14, 0, $sidemargin, 25, $colors['text'], $this->fontface, get_option('blogname'));

    1705. 

  1705. 				imagettftext($image, 8, 0, $sidemargin, 42, $colors['text'], $this->fontface, __('Posts', 'podpress').' &#187; '.strftime('%d.%m.%Y', $first_post).' - '.strftime('%d.%m.%Y', $last_post));

    1706. 

  1706. 

    1707. 

  1707. 				$text_total = number_format($stats_total['total'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1708. 

  1708. 				$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]).'%)';

    1709. 

  1709. 				$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]).'%)';

    1710. 

  1710. 				$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]).'%)';

    1711. 

  1711. 				$text_total = __('Total stats from displayed posts', 'podpress').':  '.$text_total.'  /  '.__('Feed', 'podpress').': '.$text_feed.'  /  '.__('Download', 'podpress').': '.$text_web.'  /  '.__('Play', 'podpress').': '.$text_play.' ';

    1712. 

  1712. 				imagettftext($image, 8, 0, $sidemargin, ($image_height - 15), $colors['text'], $this->fontface, $text_total);

    1713. 

  1713. 

    1714. 

  1714. 				$pos_y = ($image_height - 32);

    1715. 

  1715. 

    1716. 

  1716. 				imagefilledrectangle($image, ($sidemargin + 0), ($pos_y - 10), ($sidemargin + 10), $pos_y, $colors['feed']);

    1717. 

  1717. 				imagettftext($image, 8, 0, ($sidemargin + 15), $pos_y, $colors['text'], $this->fontface, __('Feed', 'podpress'));

    1718. 

  1718. 

    1719. 

  1719. 				imagefilledrectangle($image, ($sidemargin + 50), ($pos_y - 10), ($sidemargin + 60), $pos_y, $colors['web']);

    1720. 

  1720. 				imagettftext($image, 8, 0, ($sidemargin + 65), $pos_y, $colors['text'], $this->fontface, __('Download', 'podpress'));

    1721. 

  1721. 

    1722. 

  1722. 				imagefilledrectangle($image, ($sidemargin + 125), ($pos_y - 10), ($sidemargin + 135), $pos_y, $colors['play']);

    1723. 

  1723. 				imagettftext($image, 8, 0, ($sidemargin + 140), $pos_y, $colors['text'], $this->fontface, __('Play', 'podpress'));

    1724. 

  1724. 

    1725. 

  1725. 				imagettftext($image, 23, 0, ($image_width - 128), 30, $colors['copytext'], $this->fontface, 'podPress');

    1726. 

  1726. 				imagettftext($image, 8, 0, ($image_width - 115), 43, $colors['copytext'], $this->fontface, __('Plugin for WordPress', 'podpress'));

    1727. 

  1727. 

    1728. 

  1728. 				imagettftext($image, 6, 90, ($image_width - 15), ($image_height - 10), $colors['copytext'], $this->fontface, strftime($this->local_settings['creation_date'], time()).' ('.PODPRESS_VERSION.')');

    1729. 

  1729. 

    1730. 

  1730. 				$pos_x = ($image_width - $sidemargin - 15);

    1731. 

  1731. 

    1732. 

  1732. 				/* draw the posts */

    1733. 

  1733. 				foreach ($data AS $idata) {

    1734. 

  1734. 					/* Total stats */

    1735. 

  1735. 					$col_total_height = ($idata->total * $h_cscale);

    1736. 

  1736. 

    1737. 

  1737. 					imageline($image, ($pos_x - 2), $baseline, ($pos_x - 2), ($baseline - $col_total_height), $colors['total']);

    1738. 

  1738. 					imagettftext($image, 8, 0, ($pos_x - $col_width - 3), ($baseline - 3 - ($idata->total * $h_cscale)), $colors['text'], $this->fontface, $idata->total);

    1739. 

  1739. 

    1740. 

  1740. 					/* Feeds */

    1741. 

  1741. 					$perc_feed       = number_format(($idata->feed * 100 / $idata->total), 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1742. 

  1742. 					$col_feed_height = ($idata->feed * $h_cscale);

    1743. 

  1743. 					if ($col_feed_height < 0) {

    1744. 

  1744. 						imagefilledrectangle($image, ($pos_x - $col_width - 3), $baseline, ($pos_x - 3), ($baseline - $col_feed_height), $colors['feed']);

    1745. 

  1745. 					} else {

    1746. 

  1746. 						imagefilledrectangle($image, ($pos_x - $col_width - 3), ($baseline - $col_feed_height), ($pos_x - 3), $baseline, $colors['feed']);

    1747. 

  1747. 					}

    1748. 

  1748. 					if ($col_feed_height > 11) {

    1749. 

  1749. 						imagettftext($image, 8, 0, ($pos_x - $col_width - 2), (($baseline - ($idata->feed * $h_cscale)) + 11), $colors['text'], $this->fontface, $perc_feed.'%');

    1750. 

  1750. 					}

    1751. 

  1751. 

    1752. 

  1752. 					/* Web */

    1753. 

  1753. 					$perc_web        = number_format(($idata->web * 100 / $idata->total), 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1754. 

  1754. 					$col_web_height = ($idata->web * $h_cscale);

    1755. 

  1755. 					if ($col_web_height < 0) {

    1756. 

  1756. 						imagefilledrectangle($image, ($pos_x - $col_width - 3), ($baseline - $col_feed_height), ($pos_x - 3), ($baseline - $col_web_height - $col_feed_height), $colors['web']);

    1757. 

  1757. 					} else {

    1758. 

  1758. 						imagefilledrectangle($image, ($pos_x - $col_width - 3), ($baseline - $col_web_height - $col_feed_height), ($pos_x - 3), ($baseline - $col_feed_height), $colors['web']);

    1759. 

  1759. 					}

    1760. 

  1760. 					if ($col_web_height > 11) {

    1761. 

  1761. 						imagettftext($image, 8, 0, ($pos_x - $col_width - 2), (($baseline - $col_web_height - $col_feed_height) + 11), $colors['text'], $this->fontface, $perc_web.'%');

    1762. 

  1762. 					}

    1763. 

  1763. 

    1764. 

  1764. 					/* Play */

    1765. 

  1765. 					$perc_play       = number_format(($idata->play * 100 / $idata->total), 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1766. 

  1766. 					$col_play_height = ($idata->play * $h_cscale);

    1767. 

  1767. 					if ($col_play_height < 0) {

    1768. 

  1768. 						imagefilledrectangle($image, ($pos_x - $col_width - 3), ($baseline - $col_feed_height - $col_web_height), ($pos_x - 3), ($baseline - $col_play_height - $col_web_height - $col_feed_height), $colors['play']);

    1769. 

  1769. 					} else {

    1770. 

  1770. 						imagefilledrectangle($image, ($pos_x - $col_width - 3), ($baseline - $col_play_height - $col_web_height - $col_feed_height), ($pos_x - 3), ($baseline - $col_feed_height - $col_web_height), $colors['play']);

    1771. 

  1771. 					}

    1772. 

  1772. 					if ($col_play_height > 11) {

    1773. 

  1773. 						imagettftext($image, 8, 0, ($pos_x - $col_width - 2), (($baseline - $col_play_height - $col_web_height - $col_feed_height) + 11), $colors['text'], $this->fontface, $perc_play.'%');

    1774. 

  1774. 					}

    1775. 

  1775. 

    1776. 

  1776. 					/* Set Date and Title */

    1777. 

  1777. 					$title = (strlen($idata->title) > 70) ? substr($idata->title, 0, 70).'...' : $idata->title;

    1778. 

  1778. 					imagettftext($image, 8, 90, ($pos_x + 10), $baseline, $colors['text'], $this->fontface, $title);

    1779. 

  1779. 					imagettftext($image, 8, 0, ($pos_x - $col_width - 3), ($baseline + 14), $colors['text'], $this->fontface, strftime($this->local_settings['short_date'], $idata->post_date));

    1780. 

  1780. 

    1781. 

  1781. 					$pos_x = ($pos_x - $col_width - $col_space - 15);

    1782. 

  1782. 				}

    1783. 

  1783. 

    1784. 

  1784. 				imagejpeg($image, $file, 100);

    1785. 

  1785. 				$chronometry_end = getmicrotime();

    1786. 

  1786. 				$chronometry1    = ($chronometry_end - $chronometry1);

    1787. 

  1787. 				$chronometry2    = ($chronometry_end - $chronometry2);

    1788. 

  1788. 				imagedestroy($image);

    1789. 

  1789. 

    1790. 

  1790. 				$end_memory = memory_get_usage();

    1791. 

  1791. 				$memory_used = podPress_bytes($end_memory-$start_memory);

    1792. 

  1792. 				echo '<div id="podPress_graph" style="width: '.$image_width.'px;">'."\n";

    1793. 

  1793. 				echo '    <p style="padding-top: 0;"><img src="'.$this->tempFileURLPath.'/'.$filename.'" width="'.$image_width.'" height="'.$image_height.'" alt="podPress-Statistics" /></p>'."\n";

    1794. 

  1794. 				echo $this->paging($start, $limit, $total, 'Posts');

    1795. 

  1795. 				echo '    <div class="clear"></div>'."\n";

    1796. 

  1796. 				echo "</div>\n";

    1797. 

  1797. 				echo '<p>'.__('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";

    1798. 

  1798. 				echo '<br/>'.__('Memory to generate the graph', 'podpress').': '.$memory_used.".</p>\n";

    1799. 

  1799. 			} else {

    1800. 

  1800. 				echo '<p>'.__('We\'re sorry. At the moment we don\'t have enough data collected to display the graph.', 'podpress')."</p>\n";

    1801. 

  1801. 			}

    1802. 

  1802. 		}

    1803. 

  1803. 	}

    1804. 

  1804. 

    1805. 

  1805. 	#############################################

    1806. 

  1806. 	#############################################

    1807. 

  1807. 

    1808. 

  1808. 	function graphByPostAlt($msg = '') {

    1809. 

  1809. 		// ntm: stat logging: Counts Only

    1810. 

  1810. 		global $wpdb;

    1811. 

  1811. 		

    1812. 

  1812. 		$sql  = 'SELECT post_title AS title, SUM(total) AS value '

    1813. 

  1813. 			. 'FROM '.$wpdb->prefix.'podpress_statcounts, '.$wpdb->prefix.'posts '

    1814. 

  1814. 			. 'WHERE '.$wpdb->prefix.'posts.ID = '.$wpdb->prefix.'podpress_statcounts.postID '

    1815. 

  1815. 			. 'AND postID !=0 GROUP BY postID ORDER BY post_date DESC LIMIT 0, 100;';

    1816. 

  1816. 		

    1817. 

  1817. 		$data = $wpdb->get_results($sql);

    1818. 

  1818. 		$data = array_reverse($data);

    1819. 

  1819. 		echo '	<div class="wrap">'."\n";

    1820. 

  1820.  		echo '		<fieldset class="options">'."\n";

    1821. 

  1821.  		echo '			<legend>'.__('Downloads by Post', 'podpress').' ('.__('Last 100 posts', 'podpress').')</legend>'."\n";

    1822. 

  1822.  		echo $this->podGraph($data);

    1823. 

  1823.  		echo '		</fieldset>'."\n";

    1824. 

  1824. 

    1825. 

  1825.  		if ($msg != '') {

    1826. 

  1826. 			echo '      <p>'.$msg."</p>\n";

    1827. 

  1827. 		}

    1828. 

  1828. 		echo '	</div>';

    1829. 

  1829. 	}

    1830. 

  1830. 

    1831. 

  1831. 	#############################################

    1832. 

  1832. 	#############################################

    1833. 

  1833. 

    1834. 

  1834. }

    1835. 

  1835. ?>
    1836.