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

/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

Large files files are truncated, but you can click here to view the full file

    

  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>'."…
    1009.

Large files files are truncated, but you can click here to view the full file