PageRenderTime 63ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

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

https://github.com/bill742/verbalbrew
PHP | 1961 lines | 1585 code | 171 blank | 205 comment | 314 complexity | a5136e2db41d32c39249e679f9bee3d5 MD5 | raw file
Possible License(s): BSD-3-Clause, GPL-3.0, AGPL-1.0, LGPL-2.1, GPL-2.0 
    

  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 limiting 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 ( isset($_POST['podPress_submitted']) AND '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. 					

    365. 

  365. 					if ( isset($_POST['podpress_maxrowsperpage']) AND FALSE == empty($_POST['podpress_maxrowsperpage']) AND $limit <= intval($_POST['podpress_maxrowsperpage']) ) {

    366. 

  366. 						$this->settings['maxrowsperpage_'.$show_this_page] =  intval($_POST['podpress_maxrowsperpage']);

    367. 

  367. 					}

    368. 

  368. 					if ( isset($this->settings['maxrowsperpage_'.$show_this_page]) AND is_int($this->settings['maxrowsperpage_'.$show_this_page]) AND $limit <= $this->settings['maxrowsperpage_'.$show_this_page] ) {

    369. 

  369. 						$limit = $this->settings['maxrowsperpage_'.$show_this_page];

    370. 

  370. 					}

    371. 

  371. 					$result = podPress_update_option('podPress_config', $this->settings);

    372. 

  372. 

    373. 

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

    374. 

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

    375. 

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

    376. 

  376. 					}

    377. 

  377. 				}

    378. 

  378. 				

    379. 

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

    380. 

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

    381. 

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

    382. 

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

    383. 

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

    384. 

  384. 					wp_nonce_field('podPress_botdb_nonce');

    385. 

  385. 				}

    386. 

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

    387. 

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

    388. 

  388. 				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";

    389. 

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

    390. 

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

    391. 

  391. 				$nobots = FALSE;

    392. 

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

    393. 

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

    394. 

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

    395. 

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

    396. 

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

    397. 

  397. 						$high = $start+$limit;

    398. 

  398. 					} else {

    399. 

  399. 						$high = $rows_total;

    400. 

  400. 					}

    401. 

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

    402. 

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

    403. 

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

    404. 

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

    405. 

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

    406. 

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

    407. 

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

    408. 

  408. 							$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";

    409. 

  409. 						} else {

    410. 

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

    411. 

  411. 						}

    412. 

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

    413. 

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

    414. 

  414. 							$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";

    415. 

  415. 						} else {

    416. 

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

    417. 

  417. 						}

    418. 

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

    419. 

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

    420. 

  420. 					}

    421. 

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

    422. 

  422. 						$nobots = TRUE;

    423. 

  423. 					}

    424. 

  424. 				}  else {

    425. 

  425. 					$nobots = TRUE;

    426. 

  426. 				}				

    427. 

  427. 				if (TRUE == $nobots) {

    428. 

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

    429. 

  429. 				}

    430. 

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

    431. 

  431. 				echo '				<tfoot>'."\n";

    432. 

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

    433. 

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

    434. 

  434. 					// Show paging

    435. 

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

    436. 

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

    437. 

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

    438. 

  438. 				echo '				</tfoot>'."\n";

    439. 

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

    440. 

  440. 				$this->podpress_print_maxrowsperpage($limit);

    441. 

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

    442. 

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

    443. 

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

    444. 

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

    445. 

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

    446. 

  446. 

    447. 

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

    448. 

  448. 				echo '	</div>';

    449. 

  449. 				break;

    450. 

  450. 			case 'botdb_mark_bots':

    451. 

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

    452. 

  452. 				podPress_isAuthorized();

    453. 

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

    454. 

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

    455. 

  455. 				if ( isset($_POST['podPress_submitted']) AND 'botdb' == $_POST['podPress_submitted'] ) {

    456. 

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

    457. 

  457. 						check_admin_referer('podPress_botdb_nonce');

    458. 

  458. 					}

    459. 

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

    460. 

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

    461. 

  461. 					

    462. 

  462. 					if (is_array($botdb)) {

    463. 

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

    464. 

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

    465. 

  465. 						

    466. 

  466. 						//add new bots

    467. 

  467. 						if (is_array($IPs)) {

    468. 

  468. 							$unique_IPs = array_unique($IPs);

    469. 

  469. 							foreach ($unique_IPs as $IP) {

    470. 

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

    471. 

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

    472. 

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

    473. 

  473. 									}

    474. 

  474. 								} else {

    475. 

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

    476. 

  476. 								}

    477. 

  477. 							}

    478. 

  478. 							

    479. 

  479. 							// eventually remove bots

    480. 

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

    481. 

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

    482. 

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

    483. 

  483. 						} else {

    484. 

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

    485. 

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

    486. 

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

    487. 

  487. 							}

    488. 

  488. 						}

    489. 

  489. 						

    490. 

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

    491. 

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

    492. 

  492. 						if (is_array($fullbotnames)) {

    493. 

  493. 							$unique_fullbotnames = array_unique($fullbotnames);

    494. 

  494. 							foreach ($unique_fullbotnames as $fullbotname) {

    495. 

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

    496. 

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

    497. 

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

    498. 

  498. 									}

    499. 

  499. 								} else {

    500. 

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

    501. 

  501. 								}

    502. 

  502. 							}

    503. 

  503. 							

    504. 

  504. 							// eventually remove bots

    505. 

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

    506. 

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

    507. 

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

    508. 

  508. 						} else {

    509. 

  509. 							// eventually remove bots

    510. 

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

    511. 

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

    512. 

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

    513. 

  513. 							}

    514. 

  514. 						}

    515. 

  515. 					} else {

    516. 

  516. 						//add new bots (first time)

    517. 

  517. 						if (is_array($IPs)) {

    518. 

  518. 							$unique_IPs = array_unique($IPs);

    519. 

  519. 							foreach ($unique_IPs as $IP) {

    520. 

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

    521. 

  521. 							}

    522. 

  522. 						}

    523. 

  523. 						if (is_array($fullbotnames)) {

    524. 

  524. 							$unique_fullbotnames = array_unique($fullbotnames);

    525. 

  525. 							foreach ($unique_fullbotnames as $fullbotname) {

    526. 

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

    527. 

  527. 							}

    528. 

  528. 						}

    529. 

  529. 					}

    530. 

  530. 					

    531. 

  531. 					if ( isset($_POST['podpress_maxrowsperpage']) AND FALSE == empty($_POST['podpress_maxrowsperpage']) AND $limit <= intval($_POST['podpress_maxrowsperpage']) ) {

    532. 

  532. 						$this->settings['maxrowsperpage_'.$show_this_page] =  intval($_POST['podpress_maxrowsperpage']);

    533. 

  533. 					}

    534. 

  534. 					if ( isset($this->settings['maxrowsperpage_'.$show_this_page]) AND is_int($this->settings['maxrowsperpage_'.$show_this_page]) AND $limit <= $this->settings['maxrowsperpage_'.$show_this_page] ) {

    535. 

  535. 						$limit = $this->settings['maxrowsperpage_'.$show_this_page];

    536. 

  536. 					}

    537. 

  537. 					$result = podPress_update_option('podPress_config', $this->settings);

    538. 

  538. 

    539. 

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

    540. 

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

    541. 

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

    542. 

  542. 					}

    543. 

  543. 				}

    544. 

  544. 				

    545. 

  545. 				$where='';

    546. 

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

    547. 

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

    548. 

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

    549. 

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

    550. 

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

    551. 

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

    552. 

  552. 				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";				

    553. 

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

    554. 

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

    555. 

  555. 					wp_nonce_field('podPress_botdb_nonce');

    556. 

  556. 				}

    557. 

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

    558. 

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

    559. 

  559. 				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";

    560. 

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

    561. 

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

    562. 

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

    563. 

  563. 					$i = 0;

    564. 

  564. 					foreach ($stats as $stat) {

    565. 

  565. 						++$i;

    566. 

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

    567. 

  567. 						$bot_style = '';

    568. 

  568. 						$ip_chb_checked = '';

    569. 

  569. 						$name_chb_checked = '';

    570. 

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

    571. 

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

    572. 

  572. 								$bot_style = ' podpress_is_bot';

    573. 

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

    574. 

  574. 							}

    575. 

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

    576. 

  576. 								$bot_style = ' podpress_is_bot';

    577. 

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

    578. 

  578. 							}

    579. 

  579. 						}

    580. 

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

    581. 

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

    582. 

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

    583. 

  583. 						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";

    584. 

  584. 						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";

    585. 

  585. 						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";

    586. 

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

    587. 

  587. 					}

    588. 

  588. 				} else {

    589. 

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

    590. 

  590. 				}

    591. 

  591. 

    592. 

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

    593. 

  593. 				echo '				<tfoot>'."\n";

    594. 

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

    595. 

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

    596. 

  596. 					// Show paging

    597. 

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

    598. 

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

    599. 

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

    600. 

  600. 				echo '				</tfoot>'."\n";

    601. 

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

    602. 

  602. 				

    603. 

  603. 				$this->podpress_print_maxrowsperpage($limit);

    604. 

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

    605. 

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

    606. 

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

    607. 

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

    608. 

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

    609. 

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

    610. 

  610. 				echo '	</div>';

    611. 

  611. 				break;

    612. 

  612. 			case 'downloads_per_media_file':

    613. 

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

    614. 

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

    615. 

  615. 				

    616. 

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

    617. 

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

    618. 

  618. 

    619. 

  619. 				if ( isset($_POST['podPress_submitted']) AND $show_this_page == $_POST['podPress_submitted'] ) {

    620. 

  620. 					if ( isset($_POST['podpress_maxrowsperpage']) AND FALSE == empty($_POST['podpress_maxrowsperpage']) AND $limit <= intval($_POST['podpress_maxrowsperpage']) ) {

    621. 

  621. 						$this->settings['maxrowsperpage_'.$show_this_page] =  intval($_POST['podpress_maxrowsperpage']);

    622. 

  622. 					}

    623. 

  623. 					$result = podPress_update_option('podPress_config', $this->settings);

    624. 

  624. 				}

    625. 

  625. 				if ( isset($this->settings['maxrowsperpage_'.$show_this_page]) AND is_int($this->settings['maxrowsperpage_'.$show_this_page]) AND $limit <= $this->settings['maxrowsperpage_'.$show_this_page] ) {

    626. 

  626. 					$limit = $this->settings['maxrowsperpage_'.$show_this_page];

    627. 

  627. 				}

    628. 

  628. 			

    629. 

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

    630. 

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

    631. 

  631. 				$nr_postswpm = count($posts_with_podpressmedia);

    632. 

  632. 				if ( 0 < $nr_postswpm) {

    633. 

  633. 					$i=1;

    634. 

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

    635. 

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

    636. 

  636. 					} else {

    637. 

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

    638. 

  638. 					}

    639. 

  639. 					foreach ($posts_with_podpressmedia as $post) {

    640. 

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

    641. 

  641. 							$where_posts .= "'".$wpdb->escape($post->media)."'";

    642. 

  642. 						} else {

    643. 

  643. 							$where_posts .= "'".$wpdb->escape($post->media)."', ";

    644. 

  644. 						}

    645. 

  645. 						$i++;

    646. 

  646. 					}

    647. 

  647. 					$where_posts .= ") ";

    648. 

  648. 				} else {

    649. 

  649. 					$where_posts = '';

    650. 

  650. 				}

    651. 

  651. 

    652. 

  652. 				$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";

    653. 

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

    654. 

  654. 				

    655. 

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

    656. 

  656. 					$where_or_and = "AND";

    657. 

  657. 				} else {

    658. 

  658. 					$where_or_and = "WHERE";

    659. 

  659. 				}

    660. 

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

    661. 

  661. 				foreach ($methods as $method) {

    662. 

  662. 					$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";

    663. 

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

    664. 

  664. 					switch ($method) {

    665. 

  665. 						case 'feed' :

    666. 

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

    667. 

  667. 						break;

    668. 

  668. 						case 'web' :

    669. 

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

    670. 

  670. 						break;

    671. 

  671. 						case 'play' :

    672. 

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

    673. 

  673. 						break;

    674. 

  674. 					}

    675. 

  675. 				}

    676. 

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

    677. 

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

    678. 

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

    679. 

  679. 				

    680. 

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

    681. 

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

    682. 

  682. 				foreach ($stat_data_sets as $stat_data_set) {

    683. 

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

    684. 

  684. 					switch ($stat_data_set->method) {

    685. 

  685. 						case 'feed' :

    686. 

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

    687. 

  687. 						break;

    688. 

  688. 						case 'web' :

    689. 

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

    690. 

  690. 						break;

    691. 

  691. 						case 'play' :

    692. 

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

    693. 

  693. 						break;

    694. 

  694. 					}

    695. 

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

    696. 

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

    697. 

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

    698. 

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

    699. 

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

    700. 

  700. 				}

    701. 

  701. 				

    702. 

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

    703. 

  703. 				if ( is_array($stats) AND FALSE == empty($stats) AND method_exists($this, 'sort_downloads_per_media_desc') ) {

    704. 

  704. 					uasort($stats, array($this, 'sort_downloads_per_media_desc'));

    705. 

  705. 				}

    706. 

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

    707. 

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

    708. 

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

    709. 

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

    710. 

  710. 				echo '				<thead>';

    711. 

  711. 				echo "				<tr>\n";

    712. 

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

    713. 

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

    714. 

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

    715. 

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

    716. 

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

    717. 

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

    718. 

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

    719. 

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

    720. 

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

    721. 

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

    722. 

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

    723. 

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

    724. 

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

    725. 

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

    726. 

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

    727. 

  727. 				echo '				</thead>';

    728. 

  728. 				echo '				<tbody>';

    729. 

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

    730. 

  730. 					$i = 0;

    731. 

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

    732. 

  732. 						$i++;

    733. 

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

    734. 

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

    735. 

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

    736. 

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

    737. 

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

    738. 

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

    739. 

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

    740. 

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

    741. 

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

    742. 

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

    743. 

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

    744. 

  744. 						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";

    745. 

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

    746. 

  746. 						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";

    747. 

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

    748. 

  748. 						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";

    749. 

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

    750. 

  750. 						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";

    751. 

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

    752. 

  752. 					}

    753. 

  753. 				} else {

    754. 

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

    755. 

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

    756. 

  756. 					} else {

    757. 

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

    758. 

  758. 					}

    759. 

  759. 				}

    760. 

  760. 				echo '				</tbody>';

    761. 

  761. 				echo '				<tfoot>'."\n";

    762. 

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

    763. 

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

    764. 

  764. 					// Show paging

    765. 

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

    766. 

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

    767. 

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

    768. 

  768. 				echo '				</tfoot>'."\n";

    769. 

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

    770. 

  770. 				

    771. 

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

    772. 

  772. 				$this->podpress_print_maxrowsperpage($limit, TRUE);

    773. 

  773. 				echo '			<input type="hidden" name="podPress_submitted" value="'.$show_this_page.'" />'."\n";

    774. 

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

    775. 

  775. 				

    776. 

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

    777. 

  777. 				echo '	</div>';

    778. 

  778. 				break;

    779. 

  779. 			case 'rawstats':

    780. 

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

    781. 

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

    782. 

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

    783. 

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

    784. 

  784. 				$where = '';

    785. 

  785. 				

    786. 

  786. 				if ( isset($_POST['podPress_submitted']) AND $show_this_page == $_POST['podPress_submitted'] ) {

    787. 

  787. 					if ( isset($_POST['podpress_maxrowsperpage']) AND FALSE == empty($_POST['podpress_maxrowsperpage']) AND $limit <= intval($_POST['podpress_maxrowsperpage']) ) {

    788. 

  788. 						$this->settings['maxrowsperpage_'.$show_this_page] =  intval($_POST['podpress_maxrowsperpage']);

    789. 

  789. 					}

    790. 

  790. 					$result = podPress_update_option('podPress_config', $this->settings);

    791. 

  791. 				}

    792. 

  792. 				if ( isset($this->settings['maxrowsperpage_'.$show_this_page]) AND is_int($this->settings['maxrowsperpage_'.$show_this_page]) AND $limit <= $this->settings['maxrowsperpage_'.$show_this_page] ) {

    793. 

  793. 					$limit = $this->settings['maxrowsperpage_'.$show_this_page];

    794. 

  794. 				}

    795. 

  795. 

    796. 

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

    797. 

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

    798. 

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

    799. 

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

    800. 

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

    801. 

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

    802. 

  802. 				echo '				<thead>';

    803. 

  803. 				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";

    804. 

  804. 				echo '				</thead>';

    805. 

  805. 				echo '				<tbody>';

    806. 

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

    807. 

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

    808. 

  808. 						$i = 0;

    809. 

  809. 						foreach ($stats as $stat) {

    810. 

  810. 							++$i;

    811. 

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

    812. 

  812. 							

    813. 

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

    814. 

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

    815. 

  815. 									$bot_style = '';

    816. 

  816. 								} else {

    817. 

  817. 									$bot_style = ' podpress_is_bot';

    818. 

  818. 								}

    819. 

  819. 							} else {

    820. 

  820. 								$bot_style = ' podpress_is_bot';

    821. 

  821. 							}

    822. 

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

    823. 

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

    824. 

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

    825. 

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

    826. 

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

    827. 

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

    828. 

  828. 

    829. 

  829. 							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";

    830. 

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

    831. 

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

    832. 

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

    833. 

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

    834. 

  834. 						}

    835. 

  835. 					} else {

    836. 

  836. 						$i = 0;

    837. 

  837. 						foreach ($stats as $stat) {

    838. 

  838. 							++$i;

    839. 

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

    840. 

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

    841. 

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

    842. 

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

    843. 

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

    844. 

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

    845. 

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

    846. 

  846. 

    847. 

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

    848. 

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

    849. 

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

    850. 

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

    851. 

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

    852. 

  852. 						}

    853. 

  853. 					}

    854. 

  854. 				} else {

    855. 

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

    856. 

  856. 				}

    857. 

  857. 				echo '				</tbody>';

    858. 

  858. 				echo '				<tfoot>'."\n";

    859. 

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

    860. 

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

    861. 

  861. 					// Show paging

    862. 

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

    863. 

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

    864. 

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

    865. 

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

    866. 

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

    867. 

  867. 				

    868. 

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

    869. 

  869. 				$this->podpress_print_maxrowsperpage($limit, TRUE);

    870. 

  870. 				echo '			<input type="hidden" name="podPress_submitted" value="'.$show_this_page.'" />'."\n";

    871. 

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

    872. 

  872. 				

    873. 

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

    874. 

  874. 				echo '	</div>';

    875. 

  875. 				break;

    876. 

  876. 			case 'topips':

    877. 

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

    878. 

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

    879. 

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

    880. 

  880. 				

    881. 

  881. 				if ( isset($_POST['podPress_submitted']) AND $show_this_page == $_POST['podPress_submitted'] ) {

    882. 

  882. 					if ( isset($_POST['podpress_maxrowsperpage']) AND FALSE == empty($_POST['podpress_maxrowsperpage']) AND $limit <= intval($_POST['podpress_maxrowsperpage']) ) {

    883. 

  883. 						$this->settings['maxrowsperpage_'.$show_this_page] =  intval($_POST['podpress_maxrowsperpage']);

    884. 

  884. 					}

    885. 

  885. 					$result = podPress_update_option('podPress_config', $this->settings);

    886. 

  886. 				}

    887. 

  887. 				if ( isset($this->settings['maxrowsperpage_'.$show_this_page]) AND is_int($this->settings['maxrowsperpage_'.$show_this_page]) AND $limit <= $this->settings['maxrowsperpage_'.$show_this_page] ) {

    888. 

  888. 					$limit = $this->settings['maxrowsperpage_'.$show_this_page];

    889. 

  889. 				}

    890. 

  890. 				

    891. 

  891. 				$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;

    892. 

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

    893. 

  893. 				

    894. 

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

    895. 

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

    896. 

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

    897. 

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

    898. 

  898. 				echo '				<thead>';

    899. 

  899. 				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";

    900. 

  900. 				echo '				</thead>';

    901. 

  901. 				echo '				<tbody>';

    902. 

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

    903. 

  903. 					$i = 0;

    904. 

  904. 					foreach ($stats as $stat) {

    905. 

  905. 						++$i;

    906. 

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

    907. 

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

    908. 

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

    909. 

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

    910. 

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

    911. 

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

    912. 

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

    913. 

  913. 					}

    914. 

  914. 				} else {

    915. 

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

    916. 

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

    917. 

  917. 					} else {

    918. 

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

    919. 

  919. 					}

    920. 

  920. 				}

    921. 

  921. 				echo '				</tbody>';

    922. 

  922. 				echo '				<tfoot>'."\n";

    923. 

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

    924. 

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

    925. 

  925. 					// Show paging

    926. 

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

    927. 

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

    928. 

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

    929. 

  929. 				echo '				</tfoot>'."\n";

    930. 

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

    931. 

  931. 				

    932. 

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

    933. 

  933. 				$this->podpress_print_maxrowsperpage($limit, TRUE);

    934. 

  934. 				echo '			<input type="hidden" name="podPress_submitted" value="'.$show_this_page.'" />'."\n";

    935. 

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

    936. 

  936. 				

    937. 

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

    938. 

  938. 				echo '	</div>';

    939. 

  939. 				break;

    940. 

  940. 			case 'graphbydate':

    941. 

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

    942. 

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

    943. 

  943. 					$this->graphByDate();

    944. 

  944. 				} else {

    945. 

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

    946. 

  946. 				}

    947. 

  947. 				break;

    948. 

  948. 			case 'graphbydatealt':

    949. 

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

    950. 

  950. 				$this->graphByDateAlt();

    951. 

  951. 				break;

    952. 

  952. 			case 'graphbypost':

    953. 

  953. 				// ntm: stat logging: Counts Only

    954. 

  954. 				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>';

    955. 

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

    956. 

  956. 					$this->graphByPost();

    957. 

  957. 				} else {

    958. 

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

    959. 

  959. 				}

    960. 

  960. 				break;

    961. 

  961. 			case 'graphbypostalt':

    962. 

  962. 				// ntm: stat logging: Counts Only

    963. 

  963. 				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>';

    964. 

  964. 				$this->graphByPostAlt();

    965. 

  965. 				break;

    966. 

  966. 			case 'downloads_per_post' :

    967. 

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

    968. 

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

    969. 

  969. 				

    970. 

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

    971. 

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

    972. 

  972. 				

    973. 

  973. 				// take only posts which are still in the wp_posts table. It is possible that the stats table contains stats of file which were only in posts which are deleted.

    974. 

  974. 				if ( TRUE == empty($where) ) {

    975. 

  975. 					$where_ID .= " WHERE p.ID = pod.postID";

    976. 

  976. 				} else {

    977. 

  977. 					$where_ID .= " AND p.ID = pod.postID";

    978. 

  978. 				}

    979. 

  979. 				

    980. 

  980. 				// get all post with podPress podcasts

    981. 

  981. 				$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.$where_ID." ORDER BY pod.postID DESC";

    982. 

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

    983. 

  983. 				

    984. 

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

    985. 

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

    986. 

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

    987. 

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

    988. 

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

    989. 

  989. 					wp_nonce_field('podPress_downloads_per_post_nonce');

    990. 

  990. 				}

    991. 

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

    992. 

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

    993. 

  993. 				foreach ($posts_with_podpressmedia as $post) {

    994. 

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

    995. 

  995. 						$selected = ' selected="selected"';

    996. 

  996. 					} else {

    997. 

  997. 						$selected = '';

    998. 

  998. 					}

    999. 

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

    1000. 

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

    1001. 

  1001. 				}

    1002. 

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

    1003. 

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

    1004. 

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

    1005. 

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

    1006. 

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

    1007. 

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

    1008. 

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

    1009. 

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

    1010. 

  1010. 				

    1011. 

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

    1012. 

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

    1013. 

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

    1014. 

  1014. 						check_admin_referer('podPress_downloads_per_post_nonce');

    1015. 

  1015. 					}

    1016. 

  1016. 

    1017. 

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

    1018. 

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

    1019. 

  1019. 					} else {

    1020. 

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

    1021. 

  1021. 					}

    1022. 

  1022. 					$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";

    1023. 

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

    1024. 

  1024. 					

    1025. 

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

    1026. 

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

    1027. 

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

    1028. 

  1028. 					$feed_max = 0;

    1029. 

  1029. 					$web_max = 0;

    1030. 

  1030. 					$play_max = 0;

    1031. 

  1031. 					$total_max = 0;

    1032. 

  1032. 					foreach ($stat_data_sets as $stat_data_set) {

    1033. 

  1033. 						$feed = 0;

    1034. 

  1034. 						$web = 0;

    1035. 

  1035. 						$play = 0;

    1036. 

  1036. 						switch ($stat_data_set->method) {

    1037. 

  1037. 							case 'feed' :

    1038. 

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

    1039. 

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

    1040. 

  1040. 							break;

    1041. 

  1041. 							case 'web' :

    1042. 

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

    1043. 

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

    1044. 

  1044. 							break;

    1045. 

  1045. 							case 'play' :

    1046. 

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

    1047. 

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

    1048. 

  1048. 							break;

    1049. 

  1049. 						}

    1050. 

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

    1051. 

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

    1052. 

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

    1053. 

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

    1054. 

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

    1055. 

  1055. 					}

    1056. 

  1056. 				

    1057. 

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

    1058. 

  1058. 					if ( is_array($stats) AND FALSE == empty($stats) AND method_exists($this, 'sort_downloads_per_media_desc') ) {

    1059. 

  1059. 						uasort($stats, array($this, 'sort_downloads_per_media_desc'));

    1060. 

  1060. 					}

    1061. 

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

    1062. 

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

    1063. 

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

    1064. 

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

    1065. 

  1065. 					echo '				<thead>';

    1066. 

  1066. 					echo "				<tr>\n";

    1067. 

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

    1068. 

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

    1069. 

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

    1070. 

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

    1071. 

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

    1072. 

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

    1073. 

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

    1074. 

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

    1075. 

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

    1076. 

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

    1077. 

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

    1078. 

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

    1079. 

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

    1080. 

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

    1081. 

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

    1082. 

  1082. 					echo '				</thead>';

    1083. 

  1083. 					echo '				<tbody>';

    1084. 

  1084. 					$mark_highest = FALSE;

    1085. 

  1085. 					$nr_stat_data_sets = count($stat_data_sets);

    1086. 

  1086. 					if (0 < $nr_stat_data_sets) {

    1087. 

  1087. 						if ( 1 < $nr_stat_data_sets ) {

    1088. 

  1088. 							$mark_highest = TRUE;

    1089. 

  1089. 						}

    1090. 

  1090. 						$i = 0;

    1091. 

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

    1092. 

  1092. 							$i++;

    1093. 

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

    1094. 

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

    1095. 

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

    1096. 

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

    1097. 

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

    1098. 

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

    1099. 

  1099. 							}

    1100. 

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

    1101. 

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

    1102. 

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

    1103. 

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

    1104. 

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

    1105. 

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

    1106. 

  1106. 							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";

    1107. 

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

    1108. 

  1108. 							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";

    1109. 

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

    1110. 

  1110. 							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";

    1111. 

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

    1112. 

  1112. 							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";

    1113. 

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

    1114. 

  1114. 						}

    1115. 

  1115. 					} else {

    1116. 

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

    1117. 

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

    1118. 

  1118. 						} else {

    1119. 

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

    1120. 

  1120. 						}

    1121. 

  1121. 					}

    1122. 

  1122. 					echo '				</tbody>';

    1123. 

  1123. 					echo '				<tfoot>'."\n";

    1124. 

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

    1125. 

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

    1126. 

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

    1127. 

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

    1128. 

  1128. 					echo '				</tfoot>'."\n";

    1129. 

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

    1130. 

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

    1131. 

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

    1132. 

  1132. 				}

    1133. 

  1133. 				break;

    1134. 

  1134. 			case 'quickcounts':

    1135. 

  1135. 				// ntm: stat logging: Counts Only

    1136. 

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

    1137. 

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

    1138. 

  1138. 				if ($total > 0) {

    1139. 

  1139. 					if ( isset($_POST['podPress_submitted']) AND $show_this_page == $_POST['podPress_submitted'] ) {

    1140. 

  1140. 						if ( isset($_POST['podpress_maxrowsperpage']) AND FALSE == empty($_POST['podpress_maxrowsperpage']) AND $limit <= intval($_POST['podpress_maxrowsperpage']) ) {

    1141. 

  1141. 							$this->settings['maxrowsperpage_'.$show_this_page] =  intval($_POST['podpress_maxrowsperpage']);

    1142. 

  1142. 						}

    1143. 

  1143. 						$result = podPress_update_option('podPress_config', $this->settings);

    1144. 

  1144. 					}

    1145. 

  1145. 					if ( isset($this->settings['maxrowsperpage_'.$show_this_page]) AND is_int($this->settings['maxrowsperpage_'.$show_this_page]) AND $limit <= $this->settings['maxrowsperpage_'.$show_this_page] ) {

    1146. 

  1146. 						$limit = $this->settings['maxrowsperpage_'.$show_this_page];

    1147. 

  1147. 					}

    1148. 

  1148. 					

    1149. 

  1149. 					// Load highest values

    1150. 

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

    1151. 

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

    1152. 

  1152. 					$highest = $highest[0];

    1153. 

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

    1154. 

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

    1155. 

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

    1156. 

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

    1157. 

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

    1158. 

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

    1159. 

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

    1160. 

  1160. 					$cnt_stats     = count($stats);

    1161. 

  1161. 					

    1162. 

  1162. 					if ( isset($_POST['podpress_quickcounts_view_options']) AND 'sortquickcountsbypost' == $_POST['podpress_quickcounts_view_options'] ) {

    1163. 

  1163. 						$this->settings['sortquickcountsbypost'] = TRUE;

    1164. 

  1164. 					} elseif ( isset($_POST['podpress_quickcounts_view_options']) AND 'sortquickcountsbymediafilenames' == $_POST['podpress_quickcounts_view_options'] ) {

    1165. 

  1165. 						$this->settings['sortquickcountsbypost'] = FALSE;

    1166. 

  1166. 					}

    1167. 

  1167. 					//~ printphpnotices_var_dump($_POST['podpress_quickcounts_view_options']);

    1168. 

  1168. 					//~ printphpnotices_var_dump($this->settings['sortquickcountsbypost']);

    1169. 

  1169. 					if ( isset($this->settings['sortquickcountsbypost']) AND TRUE === $this->settings['sortquickcountsbypost'] ) {

    1170. 

  1170. 						foreach ($stats as $stat) {

    1171. 

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

    1172. 

  1172. 						}

    1173. 

  1173. 						if ( $cnt_stats > 1 ) {

    1174. 

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

    1175. 

  1175. 						} else {

    1176. 

  1176. 							$where_instr = $where_instr_ar[0];

    1177. 

  1177. 						} 

    1178. 

  1178. 						$where = 'pm.meta_key="_podPressMedia" AND ('.$where_instr.')';

    1179. 

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

    1180. 

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

    1181. 

  1181. 						

    1182. 

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

    1183. 

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

    1184. 

  1184. 						foreach ($postmeta_data as $postmeta) {

    1185. 

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

    1186. 

  1186. 							foreach ($stats as $stat) {

    1187. 

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

    1188. 

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

    1189. 

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

    1190. 

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

    1191. 

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

    1192. 

  1192. 									}

    1193. 

  1193. 								}

    1194. 

  1194. 							}

    1195. 

  1195. 						}

    1196. 

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

    1197. 

  1197. 							foreach ($stats as $stat) {

    1198. 

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

    1199. 

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

    1200. 

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

    1201. 

  1201. 									$stats_new[] = $stat;

    1202. 

  1202. 								}

    1203. 

  1203. 							}

    1204. 

  1204. 						}

    1205. 

  1205. 						$stats=$stats_new;

    1206. 

  1206. 						unset($stats_new);

    1207. 

  1207. 						

    1208. 

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

    1209. 

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

    1210. 

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

    1211. 

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

    1212. 

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

    1213. 

  1213. 						echo '				<thead>';

    1214. 

  1214. 						echo "				<tr>\n";

    1215. 

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

    1216. 

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

    1217. 

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

    1218. 

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

    1219. 

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

    1220. 

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

    1221. 

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

    1222. 

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

    1223. 

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

    1224. 

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

    1225. 

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

    1226. 

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

    1227. 

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

    1228. 

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

    1229. 

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

    1230. 

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

    1231. 

  1231. 						echo '				</thead>';

    1232. 

  1232. 						echo '				<tbody>';

    1233. 

  1233. 

    1234. 

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

    1235. 

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

    1236. 

  1236. 						

    1237. 

  1237. 						if ($cnt_stats > 0) {

    1238. 

  1238. 							$i = 0;

    1239. 

  1239. 							foreach ($stats AS $stat) {

    1240. 

  1240. 								$i++;

    1241. 

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

    1242. 

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

    1243. 

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

    1244. 

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

    1245. 

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

    1246. 

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

    1247. 

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

    1248. 

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

    1249. 

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

    1250. 

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

    1251. 

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

    1252. 

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

    1253. 

  1253. 									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";

    1254. 

  1254. 								} else {

    1255. 

  1255. 									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";

    1256. 

  1256. 								}

    1257. 

  1257. 								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";

    1258. 

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

    1259. 

  1259. 								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";

    1260. 

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

    1261. 

  1261. 								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";

    1262. 

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

    1263. 

  1263. 								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";

    1264. 

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

    1265. 

  1265. 							}

    1266. 

  1266. 						}

    1267. 

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

    1268. 

  1268. 						echo '				<tfoot>'."\n";

    1269. 

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

    1270. 

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

    1271. 

  1271. 					} else {

    1272. 

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

    1273. 

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

    1274. 

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

    1275. 

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

    1276. 

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

    1277. 

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

    1278. 

  1278. 						echo '				<thead>';

    1279. 

  1279. 						echo "				<tr>\n";

    1280. 

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

    1281. 

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

    1282. 

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

    1283. 

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

    1284. 

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

    1285. 

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

    1286. 

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

    1287. 

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

    1288. 

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

    1289. 

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

    1290. 

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

    1291. 

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

    1292. 

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

    1293. 

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

    1294. 

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

    1295. 

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

    1296. 

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

    1297. 

  1297. 						echo '				</thead>';

    1298. 

  1298. 						echo '				<tbody>';

    1299. 

  1299. 

    1300. 

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

    1301. 

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

    1302. 

  1302. 						

    1303. 

  1303. 						if ($cnt_stats > 0) {

    1304. 

  1304. 							$i = 0;

    1305. 

  1305. 							foreach ($stats AS $stat) {

    1306. 

  1306. 								$i++;

    1307. 

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

    1308. 

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

    1309. 

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

    1310. 

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

    1311. 

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

    1312. 

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

    1313. 

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

    1314. 

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

    1315. 

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

    1316. 

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

    1317. 

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

    1318. 

  1318. 									//~ 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";

    1319. 

  1319. 								//~ } else {

    1320. 

  1320. 									//~ 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";

    1321. 

  1321. 								//~ }

    1322. 

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

    1323. 

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

    1324. 

  1324. 								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";

    1325. 

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

    1326. 

  1326. 								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";

    1327. 

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

    1328. 

  1328. 								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";

    1329. 

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

    1330. 

  1330. 								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";

    1331. 

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

    1332. 

  1332. 							}

    1333. 

  1333. 						}

    1334. 

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

    1335. 

  1335. 						echo '				<tfoot>'."\n";

    1336. 

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

    1337. 

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

    1338. 

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

    1339. 

  1339. 					}

    1340. 

  1340. 					

    1341. 

  1341. 					// Show paging

    1342. 

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

    1343. 

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

    1344. 

  1344. 					}

    1345. 

  1345. 					

    1346. 

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

    1347. 

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

    1348. 

  1348. 					echo '				</tfoot>'."\n";

    1349. 

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

    1350. 

  1350. 					

    1351. 

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

    1352. 

  1352. 					echo '			<div> '."\n";

    1353. 

  1353. 					$this->podpress_print_maxrowsperpage($limit);

    1354. 

  1354. 					echo '			<br /> '."\n";

    1355. 

  1355. 					if ( isset($this->settings['sortquickcountsbypost']) AND TRUE === $this->settings['sortquickcountsbypost'] ) {

    1356. 

  1356. 						echo '				<input type="radio" name="podpress_quickcounts_view_options" id="sortquickcountsbymediafilenames" value="sortquickcountsbymediafilenames" /> <label for="sortquickcountsbymediafilenames">'.__('sort the media files by their names', 'podpress')."</label><br />\n";

    1357. 

  1357. 						echo '				<input type="radio" name="podpress_quickcounts_view_options" id="sortquickcountsbypost" value="sortquickcountsbypost" checked="checked" /> <label for="sortquickcountsbypost">'.__('sort the media files by the IDs of the posts in which they were last published', 'podpress')."</label>\n";

    1358. 

  1358. 					} else {

    1359. 

  1359. 						echo '				<input type="radio" name="podpress_quickcounts_view_options" id="sortquickcountsbymediafilenames" value="sortquickcountsbymediafilenames" checked="checked" /> <label for="sortquickcountsbymediafilenames">'.__('sort the media files by their names', 'podpress')."</label><br />\n";

    1360. 

  1360. 						echo '				<input type="radio" name="podpress_quickcounts_view_options" id="sortquickcountsbypost" value="sortquickcountsbypost" />  <label for="sortquickcountsbypost">'.__('sort the media files by the IDs of the posts in which they were last published', 'podpress')."</label>\n";

    1361. 

  1361. 					}

    1362. 

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

    1363. 

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

    1364. 

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

    1365. 

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

    1366. 

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

    1367. 

  1367. 					

    1368. 

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

    1369. 

  1369. 					echo '	</div>';

    1370. 

  1370. 				} else {

    1371. 

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

    1372. 

  1372. 				}

    1373. 

  1373. 			break;

    1374. 

  1374. 			default:

    1375. 

  1375. 			return;

    1376. 

  1376. 		}

    1377. 

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

    1378. 

  1378. 		echo '</div>';

    1379. 

  1379. 	}

    1380. 

  1380. 	

    1381. 

  1381. 	#############################################

    1382. 

  1382. 	#############################################

    1383. 

  1383. 

    1384. 

  1384. 	/**

    1385. 

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

    1386. 

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

    1387. 

  1387. 	*

    1388. 

  1388. 	* @package podPress

    1389. 

  1389. 	* @since 8.8.5 beta 3

    1390. 

  1390. 	*

    1391. 

  1391. 	* @param int $a

    1392. 

  1392. 	* @param int $b

    1393. 

  1393. 	*

    1394. 

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

    1395. 

  1395. 	*/

    1396. 

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

    1397. 

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

    1398. 

  1398. 			return 0;

    1399. 

  1399. 		}

    1400. 

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

    1401. 

  1401. 	}

    1402. 

  1402. 	

    1403. 

  1403. 	#############################################

    1404. 

  1404. 	#############################################

    1405. 

  1405. 

    1406. 

  1406. 	/**

    1407. 

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

    1408. 

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

    1409. 

  1409. 	*

    1410. 

  1410. 	* @package podPress

    1411. 

  1411. 	* @since 8.8.5 beta 3

    1412. 

  1412. 	*

    1413. 

  1413. 	* @param int $a

    1414. 

  1414. 	* @param int $b

    1415. 

  1415. 	*

    1416. 

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

    1417. 

  1417. 	*/

    1418. 

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

    1419. 

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

    1420. 

  1420. 			return 0;

    1421. 

  1421. 		}

    1422. 

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

    1423. 

  1423. 	}

    1424. 

  1424. 	

    1425. 

  1425. 	#############################################

    1426. 

  1426. 	#############################################

    1427. 

  1427. 

    1428. 

  1428. 	/**

    1429. 

  1429. 	podpress_print_maxrowsperpage() - prints a selectbox with numerical values 

    1430. 

  1430. 	*

    1431. 

  1431. 	* @package podPress

    1432. 

  1432. 	* @since 8.8.10.13

    1433. 

  1433. 	*

    1434. 

  1434. 	* @param int $limit - the value which should be selected

    1435. 

  1435. 	* @param bool $do_submit - submit the form on change (add the necessary JS code if TRUE)

    1436. 

  1436. 	* @param int $min_limit - minimal number value

    1437. 

  1437. 	*/

    1438. 

  1438. 	function podpress_print_maxrowsperpage($limit = 25, $do_submit = FALSE, $min_limit = 25) {

    1439. 

  1439. 		if ( TRUE === $do_submit ) {

    1440. 

  1440. 			echo '			<label for="podpress_maxrowsperpage">'.__('max. rows per page:', 'podpress') . '</label> <select id="podpress_maxrowsperpage" name="podpress_maxrowsperpage" onchange="this.form.submit();">'."\n";

    1441. 

  1441. 		} else {

    1442. 

  1442. 			echo '			<label for="podpress_maxrowsperpage">'.__('max. rows per page:', 'podpress') . '</label> <select id="podpress_maxrowsperpage" name="podpress_maxrowsperpage">'."\n";

    1443. 

  1443. 		}

    1444. 

  1444. 		for ($i = $min_limit; $i <= 150; $i += 5 ) {

    1445. 

  1445. 			if ( $i == $limit ) {

    1446. 

  1446. 				echo '				<option value="'.$i.'" selected="selected">'.$i.'</option>'."\n";

    1447. 

  1447. 			} else {

    1448. 

  1448. 				echo '				<option value="'.$i.'">'.$i.'</option>'."\n";

    1449. 

  1449. 			}

    1450. 

  1450. 		}

    1451. 

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

    1452. 

  1452. 	}

    1453. 

  1453. 

    1454. 

  1454. 	/**

    1455. 

  1455. 	 * Check GD-Library-Support

    1456. 

  1456. 	 *

    1457. 

  1457. 	 * @return unknown

    1458. 

  1458. 	 */

    1459. 

  1459. 	function checkGD() {

    1460. 

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

    1461. 

  1461. 	        /* php > 4.3 */

    1462. 

  1462.     		$info = gd_info();

    1463. 

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

    1464. 

  1464.     			return true;

    1465. 

  1465.     		}

    1466. 

  1466. 	    } else {

    1467. 

  1467. 	        /* php < 4.3 */

    1468. 

  1468.             ob_start();

    1469. 

  1469.             phpinfo(8);

    1470. 

  1470.             $info   = ob_get_contents();

    1471. 

  1471.             ob_end_clean();

    1472. 

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

    1473. 

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

    1474. 

  1474.             $gd_ver = $match[0];

    1475. 

  1475.             if ($gd_ver > 0) {

    1476. 

  1476.                 return true;

    1477. 

  1477.             }

    1478. 

  1478. 	   }

    1479. 

  1479. 		return false;

    1480. 

  1480. 	}

    1481. 

  1481. 

    1482. 

  1482. 	#############################################

    1483. 

  1483. 	#############################################

    1484. 

  1484. 

    1485. 

  1485. 	function checkFontFile() {

    1486. 

  1486. 		clearstatcache();

    1487. 

  1487. 

    1488. 

  1488. 		/* check font */

    1489. 

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

    1490. 

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

    1491. 

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

    1492. 

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

    1493. 

  1493. 		}

    1494. 

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

    1495. 

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

    1496. 

  1496. 			return false;

    1497. 

  1497. 		}

    1498. 

  1498. 		$this->fontface = $fontface;

    1499. 

  1499. 

    1500. 

  1500. 		return true;

    1501. 

  1501. 	}

    1502. 

  1502. 

    1503. 

  1503. 	#############################################

    1504. 

  1504. 	#############################################

    1505. 

  1505. 

    1506. 

  1506. 	function graphByDate() {

    1507. 

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

    1508. 

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

    1509. 

  1509. 			$chronometry1 = getmicrotime();

    1510. 

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

    1511. 

  1511. 			$image_width  = 1800;

    1512. 

  1512. 			$image_height = 470;

    1513. 

  1513. 			$col_width    = 20;

    1514. 

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

    1515. 

  1515. 			$file         = $this->tempfilesystempath.'/'.$filename;

    1516. 

  1516. 			$sidemargin   = 20;

    1517. 

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

    1518. 

  1518. 			$topmargin    = 60;

    1519. 

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

    1520. 

  1520. 			$weeks        = 15;

    1521. 

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

    1522. 

  1522. 			$min_downloaddays = 4;

    1523. 

  1523. 			

    1524. 

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

    1525. 

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

    1526. 

  1526. 			$start_memory = memory_get_usage();

    1527. 

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

    1528. 

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

    1529. 

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

    1530. 

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

    1531. 

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

    1532. 

  1532.                           . 'ORDER BY dt ASC;';

    1533. 

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

    1534. 

  1534. 

    1535. 

  1535. 			/* create array with grouped stats */

    1536. 

  1536. 			$stats        = array();

    1537. 

  1537. 			$stats_total  = array();

    1538. 

  1538. 			foreach ($data AS $idata) {

    1539. 

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

    1540. 

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

    1541. 

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

    1542. 

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

    1543. 

  1543. 			}

    1544. 

  1544. 

    1545. 

  1545. 			/* get min an max values */

    1546. 

  1546. 			$value_min = 0;

    1547. 

  1547. 			$value_max = 0;

    1548. 

  1548. 			$i         = 0;

    1549. 

  1549. 			$cnt_days  = count($stats);

    1550. 

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

    1551. 

  1551. 				/* set min and max values */

    1552. 

  1552. 				if ($value_min == 0) {

    1553. 

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

    1554. 

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

    1555. 

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

    1556. 

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

    1557. 

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

    1558. 

  1558. 				}

    1559. 

  1559. 				/* set first and last day */

    1560. 

  1560. 				if ($i == 0) {

    1561. 

  1561. 					$first_day = strtotime($day);

    1562. 

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

    1563. 

  1563. 					$last_day  = strtotime($day);

    1564. 

  1564. 				}

    1565. 

  1565. 				$i++;

    1566. 

  1566. 			}

    1567. 

  1567. 

    1568. 

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

    1569. 

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

    1570. 

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

    1571. 

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

    1572. 

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

    1573. 

  1573. 				$points   = array( 'total' => array(0 => $pos_x, 1 => $baseline) );

    1574. 

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

    1575. 

  1575. 					$points['total'][] = $pos_x;

    1576. 

  1576. 					$points['total'][] = ($baseline - ($idata['total'] * $h_cscale));

    1577. 

  1577. 					$points['feed'][]  = ($baseline - ($idata['feed'] * $h_cscale));

    1578. 

  1578. 					$points['web'][]   = ($baseline - ($idata['web'] * $h_cscale));

    1579. 

  1579. 					$points['play'][]  = ($baseline - ($idata['play'] * $h_cscale));

    1580. 

  1580. 					$pos_x             = ($pos_x + $col_width);

    1581. 

  1581. 				}

    1582. 

  1582. 				$points['total'][] = ($pos_x - $col_width);

    1583. 

  1583. 				$points['total'][] = $baseline;

    1584. 

  1584. 

    1585. 

  1585. 

    1586. 

  1586. 				/* create image */

    1587. 

  1587. 				$chronometry2 = getmicrotime();

    1588. 

  1588. 				$image        = imagecreatetruecolor($image_width, $image_height);

    1589. 

  1589. 				if (function_exists('imageantialias')) {

    1590. 

  1590. 					imageantialias($image, 1);

    1591. 

  1591. 				}

    1592. 

  1592. 

    1593. 

  1593. 				/* set colors */

    1594. 

  1594. 				$colors = array(

    1595. 

  1595. 						'background' => imagecolorallocate($image, 51, 51, 51),

    1596. 

  1596. 						'line'       => imagecolorallocate($image, 79, 79, 79),

    1597. 

  1597. 						'total'      => imagecolorallocate($image, 79, 79, 79),

    1598. 

  1598. 						'feed'       => imagecolorallocate($image, 255, 0, 0),

    1599. 

  1599. 						'web'        => imagecolorallocate($image, 12, 223, 0),

    1600. 

  1600. 						'play'       => imagecolorallocate($image, 223, 204, 0),

    1601. 

  1601. 						'text'       => imagecolorallocate($image, 255, 255, 255),

    1602. 

  1602. 						'copytext'   => imagecolorallocate($image, 79, 79, 79),

    1603. 

  1603. 						'days_first' => imagecolorallocate($image, 143, 143, 143),

    1604. 

  1604. 						'days_other' => imagecolorallocate($image, 95, 95, 95),

    1605. 

  1605. 						/* gray-scales: 175 159 143 127 111 95 79 63 */

    1606. 

  1606. 					       );

    1607. 

  1607. 				imagefill($image, 0, 0, $colors['background']);

    1608. 

  1608. 

    1609. 

  1609. 				/* create the legend */

    1610. 

  1610. 				imagettftext($image, 14, 0, $sidemargin, 25, $colors['text'], $this->fontface, get_option('blogname'));

    1611. 

  1611. 				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));

    1612. 

  1612. 

    1613. 

  1613. 				/* Total stats */

    1614. 

  1614. 				$text_total = number_format($stats_total['total'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1615. 

  1615. 				$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]).'%)';

    1616. 

  1616. 				$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]).'%)';

    1617. 

  1617. 				$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]).'%)';

    1618. 

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

    1619. 

  1619. 				imagettftext($image, 8, 0, $sidemargin, ($image_height - 15), $colors['text'], $this->fontface, $text_total);

    1620. 

  1620. 

    1621. 

  1621. 				$pos_y = ($image_height - 32);

    1622. 

  1622. 

    1623. 

  1623. 				imagefilledrectangle($image, ($sidemargin + 0), ($pos_y - 10), ($sidemargin + 10), ($pos_y - 0), $colors['total']);

    1624. 

  1624. 				imagettftext($image, 8, 0, ($sidemargin + 15), $pos_y, $colors['text'], $this->fontface, __('Total', 'podpress'));

    1625. 

  1625. 

    1626. 

  1626. 				imageline($image, ($sidemargin + 50), ($pos_y - 4), ($sidemargin + 60), ($pos_y - 4), $colors['feed']);

    1627. 

  1627. 				imagettftext($image, 8, 0, ($sidemargin + 65), $pos_y, $colors['text'], $this->fontface, __('Feed', 'podpress'));

    1628. 

  1628. 

    1629. 

  1629. 				imageline($image, ($sidemargin + 100), ($pos_y - 4), ($sidemargin + 110), ($pos_y - 4), $colors['web']);

    1630. 

  1630. 				imagettftext($image, 8, 0, ($sidemargin + 115), $pos_y, $colors['text'], $this->fontface, __('Download', 'podpress'));

    1631. 

  1631. 

    1632. 

  1632. 				imageline($image, ($sidemargin + 175), ($pos_y - 4), ($sidemargin + 185), ($pos_y - 4), $colors['play']);

    1633. 

  1633. 				imagettftext($image, 8, 0, ($sidemargin + 190), $pos_y, $colors['text'], $this->fontface, __('Play', 'podpress'));

    1634. 

  1634. 

    1635. 

  1635. 				imagettftext($image, 23, 0, ($image_width - 128), 30, $colors['copytext'], $this->fontface, 'podPress');

    1636. 

  1636. 				imagettftext($image, 8, 0, ($image_width - 115), 43, $colors['copytext'], $this->fontface, __('Plugin for WordPress', 'podpress'));

    1637. 

  1637. 

    1638. 

  1638. 				imagettftext($image, 6, 90, ($image_width - 15), ($image_height - 10), $colors['copytext'], $this->fontface, strftime($this->local_settings['creation_date'], time()).' ('.PODPRESS_VERSION.')');

    1639. 

  1639. 

    1640. 

  1640. 				/* draw total-stats */

    1641. 

  1641. 				$cnt_total = (count($points['total']) / 2);

    1642. 

  1642. 				imagefilledpolygon($image, $points['total'], $cnt_total, $colors['total']);

    1643. 

  1643. 

    1644. 

  1644. 				/* draw background-lines and scale-text */

    1645. 

  1645. 				$step = 0;

    1646. 

  1646. 				$h    = (($baseline - $topmargin) / 10);

    1647. 

  1647. 				while ($step <=  10) {

    1648. 

  1648. 					$pos_y = ($topmargin + ($h * $step));

    1649. 

  1649. 					imageline($image, 0, ($topmargin + ($h * $step)), $image_width, ($topmargin + ($h * $step)), $colors['line']);

    1650. 

  1650. 					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]));

    1651. 

  1651. 					$step++;

    1652. 

  1652. 				}

    1653. 

  1653. 

    1654. 

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

    1655. 

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

    1656. 

  1656. 					/* Web einzeichnen */

    1657. 

  1657. 					$weekday          = date('w', strtotime($day));

    1658. 

  1658. 					$col_total_height = ($idata['total'] * $h_cscale);

    1659. 

  1659. 

    1660. 

  1660. 					if ($weekday == 1) {

    1661. 

  1661. 						$pos_y_start = ($baseline + 27);

    1662. 

  1662. 						imagettftext($image, 8, 0, ($pos_x + 3), ($baseline + 13), $colors['text'], $this->fontface, strftime($this->local_settings['short_date'], strtotime($day)));

    1663. 

  1663. 						$color       = $colors['days_first'];

    1664. 

  1664. 					} else {

    1665. 

  1665. 						$pos_y_start = $baseline;

    1666. 

  1666. 						$color       = $colors['days_other'];

    1667. 

  1667. 					}

    1668. 

  1668. 					imageline($image, $pos_x, $pos_y_start, $pos_x, ($baseline - $col_total_height), $color);

    1669. 

  1669. 

    1670. 

  1670. 					$pos_x = ($pos_x + $col_width);

    1671. 

  1671. 				}

    1672. 

  1672. 

    1673. 

  1673. 

    1674. 

  1674. 				/* Linien zeichen */

    1675. 

  1675. 				$topics = array('feed', 'web', 'play');

    1676. 

  1676. 				foreach ($topics AS $topic) {

    1677. 

  1677. 					$cnt_points = count($points[$topic]);

    1678. 

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

    1679. 

  1679. 					for ($i = 0; $i < ($cnt_points - 1); $i++) {

    1680. 

  1680. 						imageline($image, $pos_x, $points[$topic][$i], ($pos_x + $col_width), $points[$topic][$i + 1], $colors[$topic]);

    1681. 

  1681. 						$pos_x = ($pos_x + $col_width);

    1682. 

  1682. 					}

    1683. 

  1683. 				}

    1684. 

  1684. 

    1685. 

  1685. 				imagejpeg($image, $file, 100);

    1686. 

  1686. 				$chronometry_end = getmicrotime();

    1687. 

  1687. 				$chronometry1    = ($chronometry_end - $chronometry1);

    1688. 

  1688. 				$chronometry2    = ($chronometry_end - $chronometry2);

    1689. 

  1689. 				imagedestroy($image);

    1690. 

  1690. 

    1691. 

  1691. 						$end_memory = memory_get_usage();

    1692. 

  1692. 						$memory_used = podPress_bytes($end_memory-$start_memory);

    1693. 

  1693. 				/* Output */

    1694. 

  1694. 				echo '<div id="podPress_graph" style="width: '.$image_width.'px;">'."\n";

    1695. 

  1695. 				echo '    <p><img src="'.$this->tempfileurlpath.'/'.$filename.'" width="'.$image_width.'" height="'.$image_height.'" alt="podPress-Statistics" /></p>'."\n";

    1696. 

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

    1697. 

  1697. 				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";

    1698. 

  1698. 				echo '<br/>'.__('Memory to generate the graph', 'podpress').': '.$memory_used.".</p>\n";

    1699. 

  1699. 			} else {

    1700. 

  1700. 				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";

    1701. 

  1701. 			}

    1702. 

  1702. 		}

    1703. 

  1703. 	}

    1704. 

  1704. 

    1705. 

  1705. 	#############################################

    1706. 

  1706. 	#############################################

    1707. 

  1707. 

    1708. 

  1708. 	function graphByDateAlt($msg = '') {

    1709. 

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

    1710. 

  1710. 		GLOBAL $wpdb;

    1711. 

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

    1712. 

  1712. 		$sql      = 'SELECT DATE_FORMAT(FROM_UNIXTIME(dt), "%a, %Y-%m-%d") AS title, DAYOFWEEK(FROM_UNIXTIME(dt)) AS weekday, COUNT(id) AS value '

    1713. 

  1713. 		          . 'FROM '.$wpdb->prefix.'podpress_stats '.$where.'GROUP BY title ORDER BY dt DESC LIMIT 0, 100;';

    1714. 

  1714.  		$data     = $wpdb->get_results($sql);

    1715. 

  1715.  		$data     = array_reverse($data);

    1716. 

  1716.  		$splitter = array('weekday', '2');

    1717. 

  1717. 

    1718. 

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

    1719. 

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

    1720. 

  1720.  		echo '			<legend>'.__('Downloads by date', 'podpress').' ('.__('Last 100 days', 'podpress').')</legend>'."\n";

    1721. 

  1721.  		echo $this->podGraph($data, $splitter);

    1722. 

  1722. 		if($msg != '') {

    1723. 

  1723. 			echo '      <p>'.$msg."</p>\n";

    1724. 

  1724. 		}

    1725. 

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

    1726. 

  1726. 		echo '	</div>';

    1727. 

  1727. 	}

    1728. 

  1728. 

    1729. 

  1729. 	#############################################

    1730. 

  1730. 	#############################################

    1731. 

  1731. 

    1732. 

  1732. 	function graphByPost() {

    1733. 

  1733. 		// ntm: stat logging: Counts Only

    1734. 

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

    1735. 

  1735. 			$chronometry1 = getmicrotime();

    1736. 

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

    1737. 

  1737. 			$limit        = 20;

    1738. 

  1738. 			$image_width  = 1200;

    1739. 

  1739. 			$image_height = 470;

    1740. 

  1740. 			$col_width    = 25;

    1741. 

  1741. 			$col_space    = 15;

    1742. 

  1742. 			$filename     = 'graph-by-post.jpg';

    1743. 

  1743. 			$file         = $this->tempfilesystempath.'/'.$filename;

    1744. 

  1744. 			$sidemargin   = 20;

    1745. 

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

    1746. 

  1746. 			$topmargin    = 60;

    1747. 

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

    1748. 

  1748. 			$timelimit    = (time() - ((5 * 7) * 86400));

    1749. 

  1749. 

    1750. 

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

    1751. 

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

    1752. 

  1752. 			$start_memory = memory_get_usage();

    1753. 

  1753. 			/* get data */

    1754. 

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

    1755. 

  1755. 			$query        = 'SELECT post_title AS title, total, feed, web, play, UNIX_TIMESTAMP(post_date) AS post_date '

    1756. 

  1756. 			              . 'FROM '.$this->wpdb->prefix.'podpress_statcounts, '.$this->wpdb->prefix.'posts '

    1757. 

  1757. 			              . 'WHERE '.$this->wpdb->prefix.'posts.ID = '.$this->wpdb->prefix.'podpress_statcounts.postID '

    1758. 

  1758. 			              . 'AND postID !=0 GROUP BY postID ORDER BY post_date DESC LIMIT '.$start.', '.$limit.';';

    1759. 

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

    1760. 

  1760. 			

    1761. 

  1761. 			$cnt_data     = count($data);

    1762. 

  1762. 

    1763. 

  1763. 			$first_post   = $data[($cnt_data - 1)]->post_date;

    1764. 

  1764. 			$last_post    = $data[0]->post_date;

    1765. 

  1765. 

    1766. 

  1766. 			$stats        = array();

    1767. 

  1767. 			foreach ($data AS $idata) {

    1768. 

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

    1769. 

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

    1770. 

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

    1771. 

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

    1772. 

  1772. 			}

    1773. 

  1773. 

    1774. 

  1774. 			/* get min an max values */

    1775. 

  1775. 			$value_min   = 0;

    1776. 

  1776. 			$value_max   = 0;

    1777. 

  1777. 			$stats_total = array();

    1778. 

  1778. 			foreach ($data AS $idata) {

    1779. 

  1779. 				if ($value_min == 0) {

    1780. 

  1780. 					$value_min = $idata->total;

    1781. 

  1781. 				} elseif ($idata->total < $value_min) {

    1782. 

  1782. 					$value_min = $idata->total;

    1783. 

  1783. 				}

    1784. 

  1784. 				if ($idata->total > $value_max) {

    1785. 

  1785. 					$value_max = $idata->total;

    1786. 

  1786. 				}

    1787. 

  1787. 				$stats_total['feed']  = ($stats_total['feed'] + $idata->feed);

    1788. 

  1788. 				$stats_total['web']   = ($stats_total['web'] + $idata->web);

    1789. 

  1789. 				$stats_total['play']  = ($stats_total['play'] + $idata->play);

    1790. 

  1790. 				$stats_total['total'] = ($stats_total['total'] + $idata->total);

    1791. 

  1791. 			}

    1792. 

  1792. 

    1793. 

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

    1794. 

  1794. 			if (intval($value_max) > 0) {

    1795. 

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

    1796. 

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

    1797. 

  1797. 				$w_scale     = intval($image_width - (2 * $sidemargin) + intval(($image_width - (2 * $sidemargin)) / ($limit) / 4)) / ($limit);

    1798. 

  1798. 

    1799. 

  1799. 				/* create image */

    1800. 

  1800. 				$chronometry2 = getmicrotime();

    1801. 

  1801. 				$image        = imagecreatetruecolor($image_width, $image_height);

    1802. 

  1802. 				if (function_exists('imageantialias')) {

    1803. 

  1803. 					imageantialias($image, 1);

    1804. 

  1804. 				}

    1805. 

  1805. 

    1806. 

  1806. 				$colors = array(

    1807. 

  1807. 						'background' => imagecolorallocate($image, 51, 51, 51),

    1808. 

  1808. 						'line'       => imagecolorallocate($image, 79, 79, 79),

    1809. 

  1809. 						'text'       => imagecolorallocate($image, 255, 255, 255),

    1810. 

  1810. 						'copytext'   => imagecolorallocate($image, 79, 79, 79),

    1811. 

  1811. 						'total'      => imagecolorallocate($image, 0, 0, 0),

    1812. 

  1812. 						'feed'       => imagecolorallocate($image, 143, 53, 53),

    1813. 

  1813. 						'web'        => imagecolorallocate($image, 71, 143, 88),

    1814. 

  1814. 						'play'       => imagecolorallocate($image, 142, 143, 71),

    1815. 

  1815. 					      );

    1816. 

  1816. 

    1817. 

  1817. 				imagefill($image, 0, 0, $colors['background']);

    1818. 

  1818. 

    1819. 

  1819. 				/* draw background-lines and scale-text */

    1820. 

  1820. 				$step = 0;

    1821. 

  1821. 				$h    = (($baseline - $topmargin) / 10);

    1822. 

  1822. 				while ($step <=  10) {

    1823. 

  1823. 					$pos_y = ($topmargin + ($h * $step));

    1824. 

  1824. 					imageline($image, 0, ($topmargin + ($h * $step)), $image_width, ($topmargin + ($h * $step)), $colors['line']);

    1825. 

  1825. 					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]));

    1826. 

  1826. 					$step++;

    1827. 

  1827. 				}

    1828. 

  1828. 

    1829. 

  1829. 				/* create the legend */

    1830. 

  1830. 				imagettftext($image, 14, 0, $sidemargin, 25, $colors['text'], $this->fontface, get_option('blogname'));

    1831. 

  1831. 				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));

    1832. 

  1832. 

    1833. 

  1833. 				$text_total = number_format($stats_total['total'], 0, $this->local_settings['numbers'][0], $this->local_settings['numbers'][1]);

    1834. 

  1834. 				$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]).'%)';

    1835. 

  1835. 				$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]).'%)';

    1836. 

  1836. 				$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]).'%)';

    1837. 

  1837. 				$text_total = __('Total stats from displayed posts', 'podpress').':  '.$text_total.'  /  '.__('Feed', 'podpress').': '.$text_feed.'  /  '.__('Download', 'podpress').': '.$text_web.'  /  '.__('Play', 'podpress').': '.$text_play.' ';

    1838. 

  1838. 				imagettftext($image, 8, 0, $sidemargin, ($image_height - 15), $colors['text'], $this->fontface, $text_total);

    1839. 

  1839. 

    1840. 

  1840. 				$pos_y = ($image_height - 32);

    1841. 

  1841. 

    1842. 

  1842. 				imagefilledrectangle($image, ($sidemargin + 0), ($pos_y - 10), ($sidemargin + 10), $pos_y, $colors['feed']);

    1843. 

  1843. 				imagettftext($image, 8, 0, ($sidemargin + 15), $pos_y, $colors['text'], $this->fontface, __('Feed', 'podpress'));

    1844. 

  1844. 

    1845. 

  1845. 				imagefilledrectangle($image, ($sidemargin + 50), ($pos_y - 10), ($sidemargin + 60), $pos_y, $colors['web']);

    1846. 

  1846. 				imagettftext($image, 8, 0, ($sidemargin + 65), $pos_y, $colors['text'], $this->fontface, __('Download', 'podpress'));

    1847. 

  1847. 

    1848. 

  1848. 				imagefilledrectangle($image, ($sidemargin + 125), ($pos_y - 10), ($sidemargin + 135), $pos_y, $colors['play']);

    1849. 

  1849. 				imagettftext($image, 8, 0, ($sidemargin + 140), $pos_y, $colors['text'], $this->fontface, __('Play', 'podpress'));

    1850. 

  1850. 

    1851. 

  1851. 				imagettftext($image, 23, 0, ($image_width - 128), 30, $colors['copytext'], $this->fontface, 'podPress');

    1852. 

  1852. 				imagettftext($image, 8, 0, ($image_width - 115), 43, $colors['copytext'], $this->fontface, __('Plugin for WordPress', 'podpress'));

    1853. 

  1853. 

    1854. 

  1854. 				imagettftext($image, 6, 90, ($image_width - 15), ($image_height - 10), $colors['copytext'], $this->fontface, strftime($this->local_settings['creation_date'], time()).' ('.PODPRESS_VERSION.')');

    1855. 

  1855. 

    1856. 

  1856. 				$pos_x = ($image_width - $sidemargin - 15);

    1857. 

  1857. 

    1858. 

  1858. 				/* draw the posts */

    1859. 

  1859. 				foreach ($data AS $idata) {

    1860. 

  1860. 					/* Total stats */

    1861. 

  1861. 					$col_total_height = ($idata->total * $h_cscale);

    1862. 

  1862. 

    1863. 

  1863. 					imageline($image, ($pos_x - 2), $baseline, ($pos_x - 2), ($baseline - $col_total_height), $colors['total']);

    1864. 

  1864. 					imagettftext($image, 8, 0, ($pos_x - $col_width - 3), ($baseline - 3 - ($idata->total * $h_cscale)), $colors['text'], $this->fontface, $idata->total);

    1865. 

  1865. 

    1866. 

  1866. 					/* Feeds */

    1867. 

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

    1868. 

  1868. 					$col_feed_height = ($idata->feed * $h_cscale);

    1869. 

  1869. 					if ($col_feed_height < 0) {

    1870. 

  1870. 						imagefilledrectangle($image, ($pos_x - $col_width - 3), $baseline, ($pos_x - 3), ($baseline - $col_feed_height), $colors['feed']);

    1871. 

  1871. 					} else {

    1872. 

  1872. 						imagefilledrectangle($image, ($pos_x - $col_width - 3), ($baseline - $col_feed_height), ($pos_x - 3), $baseline, $colors['feed']);

    1873. 

  1873. 					}

    1874. 

  1874. 					if ($col_feed_height > 11) {

    1875. 

  1875. 						imagettftext($image, 8, 0, ($pos_x - $col_width - 2), (($baseline - ($idata->feed * $h_cscale)) + 11), $colors['text'], $this->fontface, $perc_feed.'%');

    1876. 

  1876. 					}

    1877. 

  1877. 

    1878. 

  1878. 					/* Web */

    1879. 

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

    1880. 

  1880. 					$col_web_height = ($idata->web * $h_cscale);

    1881. 

  1881. 					if ($col_web_height < 0) {

    1882. 

  1882. 						imagefilledrectangle($image, ($pos_x - $col_width - 3), ($baseline - $col_feed_height), ($pos_x - 3), ($baseline - $col_web_height - $col_feed_height), $colors['web']);

    1883. 

  1883. 					} else {

    1884. 

  1884. 						imagefilledrectangle($image, ($pos_x - $col_width - 3), ($baseline - $col_web_height - $col_feed_height), ($pos_x - 3), ($baseline - $col_feed_height), $colors['web']);

    1885. 

  1885. 					}

    1886. 

  1886. 					if ($col_web_height > 11) {

    1887. 

  1887. 						imagettftext($image, 8, 0, ($pos_x - $col_width - 2), (($baseline - $col_web_height - $col_feed_height) + 11), $colors['text'], $this->fontface, $perc_web.'%');

    1888. 

  1888. 					}

    1889. 

  1889. 

    1890. 

  1890. 					/* Play */

    1891. 

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

    1892. 

  1892. 					$col_play_height = ($idata->play * $h_cscale);

    1893. 

  1893. 					if ($col_play_height < 0) {

    1894. 

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

    1895. 

  1895. 					} else {

    1896. 

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

    1897. 

  1897. 					}

    1898. 

  1898. 					if ($col_play_height > 11) {

    1899. 

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

    1900. 

  1900. 					}

    1901. 

  1901. 

    1902. 

  1902. 					/* Set Date and Title */

    1903. 

  1903. 					$title = (strlen($idata->title) > 70) ? substr($idata->title, 0, 70).'...' : $idata->title;

    1904. 

  1904. 					imagettftext($image, 8, 90, ($pos_x + 10), $baseline, $colors['text'], $this->fontface, $title);

    1905. 

  1905. 					imagettftext($image, 8, 0, ($pos_x - $col_width - 3), ($baseline + 14), $colors['text'], $this->fontface, strftime($this->local_settings['short_date'], $idata->post_date));

    1906. 

  1906. 

    1907. 

  1907. 					$pos_x = ($pos_x - $col_width - $col_space - 15);

    1908. 

  1908. 				}

    1909. 

  1909. 

    1910. 

  1910. 				imagejpeg($image, $file, 100);

    1911. 

  1911. 				$chronometry_end = getmicrotime();

    1912. 

  1912. 				$chronometry1    = ($chronometry_end - $chronometry1);

    1913. 

  1913. 				$chronometry2    = ($chronometry_end - $chronometry2);

    1914. 

  1914. 				imagedestroy($image);

    1915. 

  1915. 

    1916. 

  1916. 				$end_memory = memory_get_usage();

    1917. 

  1917. 				$memory_used = podPress_bytes($end_memory-$start_memory);

    1918. 

  1918. 				echo '<div id="podPress_graph" style="width: '.$image_width.'px;">'."\n";

    1919. 

  1919. 				echo '    <p style="padding-top: 0;"><img src="'.$this->tempfileurlpath.'/'.$filename.'" width="'.$image_width.'" height="'.$image_height.'" alt="podPress-Statistics" /></p>'."\n";

    1920. 

  1920. 				echo $this->paging($start, $limit, $total, 'Posts');

    1921. 

  1921. 				echo '    <div class="clear"></div>'."\n";

    1922. 

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

    1923. 

  1923. 				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";

    1924. 

  1924. 				echo '<br/>'.__('Memory to generate the graph', 'podpress').': '.$memory_used.".</p>\n";

    1925. 

  1925. 			} else {

    1926. 

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

    1927. 

  1927. 			}

    1928. 

  1928. 		}

    1929. 

  1929. 	}

    1930. 

  1930. 

    1931. 

  1931. 	#############################################

    1932. 

  1932. 	#############################################

    1933. 

  1933. 

    1934. 

  1934. 	function graphByPostAlt($msg = '') {

    1935. 

  1935. 		// ntm: stat logging: Counts Only

    1936. 

  1936. 		global $wpdb;

    1937. 

  1937. 		

    1938. 

  1938. 		$sql  = 'SELECT post_title AS title, SUM(total) AS value '

    1939. 

  1939. 			. 'FROM '.$wpdb->prefix.'podpress_statcounts, '.$wpdb->prefix.'posts '

    1940. 

  1940. 			. 'WHERE '.$wpdb->prefix.'posts.ID = '.$wpdb->prefix.'podpress_statcounts.postID '

    1941. 

  1941. 			. 'AND postID !=0 GROUP BY postID ORDER BY post_date DESC LIMIT 0, 100;';

    1942. 

  1942. 		

    1943. 

  1943. 		$data = $wpdb->get_results($sql);

    1944. 

  1944. 		$data = array_reverse($data);

    1945. 

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

    1946. 

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

    1947. 

  1947.  		echo '			<legend>'.__('Downloads by Post', 'podpress').' ('.__('Last 100 posts', 'podpress').')</legend>'."\n";

    1948. 

  1948.  		echo $this->podGraph($data);

    1949. 

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

    1950. 

  1950. 

    1951. 

  1951.  		if ($msg != '') {

    1952. 

  1952. 			echo '      <p>'.$msg."</p>\n";

    1953. 

  1953. 		}

    1954. 

  1954. 		echo '	</div>';

    1955. 

  1955. 	}

    1956. 

  1956. 

    1957. 

  1957. 	#############################################

    1958. 

  1958. 	#############################################

    1959. 

  1959. 

    1960. 

  1960. }

    1961. 

  1961. ?>
    1962.