PageRenderTime 73ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 1ms

/wp-content/plugins/newstatpress/newstatpress.php

https://bitbucket.org/lgorence/quickpress
PHP | 3334 lines | 2753 code | 269 blank | 312 comment | 380 complexity | d0f5ca5e121e2cf049afb43acdb4832b MD5 | raw file
Possible License(s): GPL-2.0, LGPL-2.1, AGPL-1.0 
    

  1. <?php
    2. 

  2. /*
    3. 

  3. Plugin Name: NewStatPress
    4. 

  4. Plugin URI: http://newstatpress.altervista.org
    5. 

  5. Description: Real time stats for your Wordpress blog
    6. 

  6. Version: 0.4.4
    7. 

  7. Author: Stefano Tognon (from Daniele Lippi works)
    8. 

  8. Author URI: http://newstatpress.altervista.org
    9. 

  9. */
    10. 

  10. 

  11. $_NEWSTATPRESS['version']='0.4.4';
    12. 

  12. $_NEWSTATPRESS['feedtype']='';
    13. 

  13. 

  14. include ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/includes/charts.php';
    15. 

  15. 

  16. /**
    17. 

  17.  * Get the url of the plugin
    18. 

  18.  *
    19. 

  19.  * @return the url of the plugin
    20. 

  20.  */
    21. 

  21. function PluginUrl() {
    22. 

  22.   //Try to use WP API if possible, introduced in WP 2.6
    23. 

  23.   if (function_exists('plugins_url')) return trailingslashit(plugins_url(basename(dirname(__FILE__))));
    24. 

  24. 

  25.   //Try to find manually... can't work if wp-content was renamed or is redirected
    26. 

  26.   $path = dirname(__FILE__);
    27. 

  27.   $path = str_replace("\\","/",$path);
    28. 

  28.   $path = trailingslashit(get_bloginfo('wpurl')) . trailingslashit(substr($path,strpos($path,"wp-content/")));
    29. 

  29.   return $path;
    30. 

  30. }
    31. 

  31. 

  32. /**
    33. 

  33.  * Add pages with NewStatPress commands
    34. 

  34.  */
    35. 

  35. function iri_add_pages() {
    36. 

  36.   # Create/update table if it not exists
    37. 

  37.   global $wpdb;
    38. 

  38.   $table_name = $wpdb->prefix . "statpress";
    39. 

  39.   if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
    40. 

  40.     iri_NewStatPress_CreateTable();
    41. 

  41.   }
    42. 

  42. 

  43.   # add submenu
    44. 

  44.   $mincap=get_option('newstatpress_mincap');
    45. 

  45.   if($mincap == '') {
    46. 

  46.     $mincap="level_8";
    47. 

  47.   }
    48. 

  48. 

  49.   // ORIG   add_submenu_page('index.php', 'StatPress', 'StatPress', 8, 'statpress', 'iriNewStatPress');
    50. 

  50.   add_menu_page('NewStatPress', 'NewStatPress', $mincap, __FILE__, 'iriNewStatPress', plugins_url('newstatpress/images/stat.png',dirname(plugin_basename(__FILE__))));
    51. 

  51.   add_submenu_page(__FILE__, __('Overview','newstatpress'), __('Overview','newstatpress'), $mincap, __FILE__, 'iriNewStatPress');
    52. 

  52.   add_submenu_page(__FILE__, __('Details','newstatpress'), __('Details','newstatpress'), $mincap, __FILE__ . '&newstatpress_action=details', 'iriNewStatPress');
    53. 

  53.   add_submenu_page(__FILE__, __('Spy','newstatpress'), __('Spy','newstatpress'), $mincap, __FILE__ . '&newstatpress_action=spy', 'iriNewStatPress');
    54. 

  54.   add_submenu_page(__FILE__, __('New Spy','newstatpress'), __('New Spy','newstatpress'), $mincap, __FILE__ . '&newstatpress_action=newspy', 'iriNewStatPress');
    55. 

  55.   add_submenu_page(__FILE__, __('Spy Bot','newstatpress'), __('Spy Bot','newstatpress'), $mincap, __FILE__ . '&newstatpress_action=spybot', 'iriNewStatPress');
    56. 

  56.   add_submenu_page(__FILE__, __('Search','newstatpress'), __('Search','newstatpress'), $mincap, __FILE__ . '&newstatpress_action=search', 'iriNewStatPress');
    57. 

  57.   add_submenu_page(__FILE__, __('Export','newstatpress'), __('Export','newstatpress'), $mincap, __FILE__ . '&newstatpress_action=export', 'iriNewStatPress');
    58. 

  58.   add_submenu_page(__FILE__, __('Options','newstatpress'), __('Options','newstatpress'), $mincap, __FILE__ . '&newstatpress_action=options', 'iriNewStatPress');
    59. 

  59.   add_submenu_page(__FILE__, __('NewStatPressUpdate','newstatpress'), __('NewStatPressUpdate','newstatpress'), $mincap, __FILE__ . '&newstatpress_action=up', 'iriNewStatPress');  
    60. 

  60.   add_submenu_page(__FILE__, __('NewStatpress blog','newstatpress'), __('NewStatpress blog','newstatpress'), $mincap,  __FILE__ . '&newstatpress_action=redirect', 'iriNewStatPress');
    61. 

  61.   add_submenu_page(__FILE__, __('Credits','newstatpress'), __('Credits','newstatpress'), $mincap,  __FILE__ . '&newstatpress_action=credits', 'iriNewStatPress');
    62. 

  62. }
    63. 

  63. 

  64. /**
    65. 

  65.  * General function for calling the action that user had choice
    66. 

  66.  */
    67. 

  67. function iriNewStatPress() {
    68. 

  68.   ?>
    69. 

  69.   <?php
    70. 

  70.     if(isset($_GET['newstatpress_action'])){
    71. 

  71.       if ($_GET['newstatpress_action'] == 'export') {
    72. 

  72.         iriNewStatPressExport();
    73. 

  73.       } elseif ($_GET['newstatpress_action'] == 'up') {
    74. 

  74.           iriNewStatPressUpdate();
    75. 

  75.       } elseif ($_GET['newstatpress_action'] == 'spy') {
    76. 

  76.           iriNewStatPressSpy();
    77. 

  77.       } elseif ($_GET['newstatpress_action'] == 'newspy') {
    78. 

  78.           iriNewStatPressNewSpy();
    79. 

  79.       } elseif ($_GET['newstatpress_action'] == 'spybot') {
    80. 

  80.           iriNewStatPressSpyBot();
    81. 

  81.       } elseif ($_GET['newstatpress_action'] == 'search') {
    82. 

  82.            iriNewStatPressSearch();
    83. 

  83.       } elseif ($_GET['newstatpress_action'] == 'details') {
    84. 

  84.            iriNewStatPressDetails();
    85. 

  85.       } elseif ($_GET['newstatpress_action'] == 'options') {
    86. 

  86.            iriNewStatPressOptions();
    87. 

  87.       } elseif ($_GET['newstatpress_action'] == 'redirect') {
    88. 

  88.            iriNewStatPressRedirect();      
    89. 

  89.       } elseif ($_GET['newstatpress_action'] == 'credits') {
    90. 

  90.            iriNewStatPressCredits();
    91. 

  91.       } 
    92. 

  92.    } else iriNewStatPressMain();
    93. 

  93. }
    94. 

  94. 

  95. /**
    96. 

  96.  * Redirect the wordpress page to the newstatpress blog
    97. 

  97.  */
    98. 

  98. function iriNewStatPressRedirect() {
    99. 

  99.   echo "<script language=javascript>window.location.href= 'http://newstatpress.altervista.org'</script>";
    100. 

  100. }
    101. 

  101. 

  102. /**
    103. 

  103.  * Filter the given value for preventing XSS attacks
    104. 

  104.  *
    105. 

  105.  * @param _value the value to filter
    106. 

  106.  * @return filtered value
    107. 

  107.  */
    108. 

  108. function iriNewStatPress_filter_for_xss($_value){
    109. 

  109.   $_value=trim($_value);
    110. 

  110. 

  111.   // Avoid XSS attacks
    112. 

  112.   $clean_value = preg_replace('/[^a-zA-Z0-9\,\.\/\ \-\_\?=&;]/', '', $_value);
    113. 

  113.   if (strlen($_value)==0){
    114. 

  114.     return array();
    115. 

  115.   } else {
    116. 

  116.       $array_values = explode(',',$clean_value);
    117. 

  117.       array_walk($array_values, 'iriNewStatPress_trim_value');
    118. 

  118.       return $array_values;
    119. 

  119.     }
    120. 

  120. }
    121. 

  121. 

  122. /**
    123. 

  123.  * Trim the given string
    124. 

  124.  */
    125. 

  125. function iriNewStatPress_trim_value(&$value) { 
    126. 

  126.   $value = trim($value); 
    127. 

  127. }
    128. 

  128. 

  129. /**
    130. 

  130.  * Generate HTML for option menu in Wordpress
    131. 

  131.  */
    132. 

  132. function iriNewStatPressOptions() {
    133. 

  133.   if(isset($_POST['saveit']) && $_POST['saveit'] == 'yes') {
    134. 

  134.     if (isset($_POST['newstatpress_collectloggeduser'])) update_option('newstatpress_collectloggeduser', $_POST['newstatpress_collectloggeduser']);
    135. 

  135.     else update_option('newstatpress_collectloggeduser', null);
    136. 

  136.     update_option('newstatpress_ip_per_page_newspy', $_POST['newstatpress_ip_per_page_newspy']);
    137. 

  137.     update_option('newstatpress_visits_per_ip_newspy', $_POST['newstatpress_visits_per_ip_newspy']);
    138. 

  138.     update_option('newstatpress_bot_per_page_spybot', $_POST['newstatpress_bot_per_page_spybot']);
    139. 

  139.     update_option('newstatpress_visits_per_bot_spybot', $_POST['newstatpress_visits_per_bot_spybot']);
    140. 

  140.     update_option('newstatpress_autodelete', $_POST['newstatpress_autodelete']);
    141. 

  141.     update_option('newstatpress_daysinoverviewgraph', $_POST['newstatpress_daysinoverviewgraph']);
    142. 

  142.     update_option('newstatpress_mincap', $_POST['newstatpress_mincap']);
    143. 

  143.     if (isset($_POST['newstatpress_donotcollectspider'])) update_option('newstatpress_donotcollectspider', $_POST['newstatpress_donotcollectspider']);
    144. 

  144.     else update_option('newstatpress_donotcollectspider', null);
    145. 

  145.     if (isset($_POST['newstatpress_cryptip'])) update_option('newstatpress_cryptip', $_POST['newstatpress_cryptip']);
    146. 

  146.     else update_option('newstatpress_cryptip', null);
    147. 

  147.     if (isset($_POST['newstatpress_dashboard'])) update_option('newstatpress_dashboard', $_POST['newstatpress_dashboard']);
    148. 

  148.     else update_option('newstatpress_dashboard', null);
    149. 

  149.     update_option('newstatpress_ignore_users', iriNewStatPress_filter_for_xss($_POST['newstatpress_ignore_users']));
    150. 

  150.     update_option('newstatpress_ignore_ip', iriNewStatPress_filter_for_xss($_POST['newstatpress_ignore_ip']));
    151. 

  151.     update_option('newstatpress_ignore_permalink', iriNewStatPress_filter_for_xss($_POST['newstatpress_ignore_permalink']));
    152. 

  152.     update_option('newstatpress_el_top_days', $_POST['newstatpress_el_top_days']);
    153. 

  153.     update_option('newstatpress_el_os', $_POST['newstatpress_el_os']);
    154. 

  154.     update_option('newstatpress_el_browser', $_POST['newstatpress_el_browser']);
    155. 

  155.     update_option('newstatpress_el_feed', $_POST['newstatpress_el_feed']);
    156. 

  156.     update_option('newstatpress_el_searchengine', $_POST['newstatpress_el_searchengine']);
    157. 

  157.     update_option('newstatpress_el_search', $_POST['newstatpress_el_search']);
    158. 

  158.     update_option('newstatpress_el_referrer', $_POST['newstatpress_el_referrer']);
    159. 

  159.     update_option('newstatpress_el_languages', $_POST['newstatpress_el_languages']);
    160. 

  160.     update_option('newstatpress_el_spiders', $_POST['newstatpress_el_spiders']);
    161. 

  161.     update_option('newstatpress_el_pages', $_POST['newstatpress_el_pages']);
    162. 

  162.     update_option('newstatpress_el_visitors', $_POST['newstatpress_el_visitors']);
    163. 

  163.     update_option('newstatpress_el_daypages', $_POST['newstatpress_el_daypages']);
    164. 

  164.     update_option('newstatpress_el_ippages', $_POST['newstatpress_el_ippages']);
    165. 

  165.     update_option('newstatpress_updateint', $_POST['newstatpress_updateint']);
    166. 

  166. 

  167.     # update database too
    168. 

  168.     iri_NewStatPress_CreateTable();
    169. 

  169.     print "<br /><div class='updated'><p>".__('Saved','newstatpress')."!</p></div>";
    170. 

  170.   } else {
    171. 

  171.       ?>
    172. 

  172.       <div class='wrap'><h2><?php _e('Options','newstatpress'); ?></h2>
    173. 

  173.       <form method=post><table width=100%>
    174. 

  174.       <?php
    175. 

  175.         print "<tr><td><input type=checkbox name='newstatpress_collectloggeduser' value='checked' ".get_option('newstatpress_collectloggeduser')."> ".__('Collect data about logged users, too.','newstatpress')."</td></tr>";
    176. 

  176.         print "<tr><td><input type=checkbox name='newstatpress_donotcollectspider' value='checked' ".get_option('newstatpress_donotcollectspider')."> ".__('Do not collect spiders visits','newstatpress')."</td></tr>";
    177. 

  177.         print "<tr><td><input type=checkbox name='newstatpress_cryptip' value='checked' ".get_option('newstatpress_cryptip')."> ".__('Crypt IP addresses','newstatpress')."</td></tr>";
    178. 

  178.         print "<tr><td><input type=checkbox name='newstatpress_dashboard' value='checked' ".get_option('newstatpress_dashboard')."> ".__('Show NewStatPress dashboard widget','newstatpress')."</td></tr>";
    179. 

  179.       ?>
    180. 

  180. 

  181.       <tr><td><?php _e('New Spy: number of IP per page','newstatpress'); ?>
    182. 

  182.         <select name="newstatpress_ip_per_page_newspy">          
    183. 

  183.           <option value="20" <?php if(get_option('newstatpress_ip_per_page_newspy') == "20") print "selected"; ?>>20</option>
    184. 

  184.           <option value="50" <?php if(get_option('newstatpress_ip_per_page_newspy') == "50") print "selected"; ?>>50</option>
    185. 

  185.           <option value="100" <?php if(get_option('newstatpress_ip_per_page_newspy') == "100") print "selected"; ?>>100</option>          
    186. 

  186.         </select></td></tr>
    187. 

  187. 

  188.       <tr><td><?php _e('New Spy: number of visits for IP','newstatpress'); ?>
    189. 

  189.         <select name="newstatpress_visits_per_ip_newspy">          
    190. 

  190.           <option value="20" <?php if(get_option('newstatpress_visits_per_ip_newspy') == "20") print "selected"; ?>>20</option>
    191. 

  191.           <option value="50" <?php if(get_option('newstatpress_visits_per_ip_newspy') == "50") print "selected"; ?>>50</option>
    192. 

  192.           <option value="100" <?php if(get_option('newstatpress_visits_per_ip_newspy') == "100") print "selected"; ?>>100</option>          
    193. 

  193.         </select></td></tr>
    194. 

  194. 

  195.       <tr><td><?php _e('Spy Bot: number of bot per page','newstatpress'); ?>
    196. 

  196.         <select name="newstatpress_bot_per_page_spybot">          
    197. 

  197.           <option value="20" <?php if(get_option('newstatpress_bot_per_page_spybot') == "20") print "selected"; ?>>20</option>
    198. 

  198.           <option value="50" <?php if(get_option('newstatpress_bot_per_page_spybot') == "50") print "selected"; ?>>50</option>
    199. 

  199.           <option value="100" <?php if(get_option('newstatpress_bot_per_page_spybot') == "100") print "selected"; ?>>100</option>          
    200. 

  200.         </select></td></tr>
    201. 

  201. 

  202.       <tr><td><?php _e('Spy Bot: number of bot for IP','newstatpress'); ?>
    203. 

  203.         <select name="newstatpress_visits_per_bot_spybot">          
    204. 

  204.           <option value="20" <?php if(get_option('newstatpress_visits_per_bot_spybot') == "20") print "selected"; ?>>20</option>
    205. 

  205.           <option value="50" <?php if(get_option('newstatpress_visits_per_bot_spybot') == "50") print "selected"; ?>>50</option>
    206. 

  206.           <option value="100" <?php if(get_option('newstatpress_visits_per_bot_spybot') == "100") print "selected"; ?>>100</option>          
    207. 

  207.         </select></td></tr>
    208. 

  208. 

  209.       <tr><td><?php _e('Automatically delete visits older than','newstatpress'); ?>
    210. 

  210.         <select name="newstatpress_autodelete">
    211. 

  211.           <option value="" <?php if(get_option('newstatpress_autodelete') =='' ) print "selected"; ?>><?php _e('Never delete!','newstatpress'); ?></option>
    212. 

  212.           <option value="1 month" <?php if(get_option('newstatpress_autodelete') == "1 month") print "selected"; ?>>1 <?php _e('month','newstatpress'); ?></option>
    213. 

  213.           <option value="3 months" <?php if(get_option('newstatpress_autodelete') == "3 months") print "selected"; ?>>3 <?php _e('months','newstatpress'); ?></option>
    214. 

  214.           <option value="6 months" <?php if(get_option('newstatpress_autodelete') == "6 months") print "selected"; ?>>6 <?php _e('months','newstatpress'); ?></option>
    215. 

  215.           <option value="1 year" <?php if(get_option('newstatpress_autodelete') == "1 year") print "selected"; ?>>1 <?php _e('year','newstatpress'); ?></option>
    216. 

  216.         </select></td></tr>
    217. 

  217. 

  218.       <tr><td><?php _e('Days in Overview graph','newstatpress'); ?>
    219. 

  219.         <select name="newstatpress_daysinoverviewgraph">
    220. 

  220.           <option value="7" <?php if(get_option('newstatpress_daysinoverviewgraph') == 7) print "selected"; ?>>7</option>
    221. 

  221.           <option value="10" <?php if(get_option('newstatpress_daysinoverviewgraph') == 10) print "selected"; ?>>10</option>
    222. 

  222.           <option value="20" <?php if(get_option('newstatpress_daysinoverviewgraph') == 20) print "selected"; ?>>20</option>
    223. 

  223.           <option value="30" <?php if(get_option('newstatpress_daysinoverviewgraph') == 30) print "selected"; ?>>30</option>
    224. 

  224.           <option value="50" <?php if(get_option('newstatpress_daysinoverviewgraph') == 50) print "selected"; ?>>50</option>
    225. 

  225.         </select></td></tr>
    226. 

  226. 

  227.       <tr><td><?php _e('Minimum capability to view stats','newstatpress'); ?>
    228. 

  228.         <select name="newstatpress_mincap">
    229. 

  229.          <?php iri_dropdown_caps(get_option('newstatpress_mincap')); ?>
    230. 

  230.         </select> 
    231. 

  231.         <a href="http://codex.wordpress.org/Roles_and_Capabilities" target="_blank"><?php _e("more info",'newstatpress'); ?></a>
    232. 

  232.         </td></tr>
    233. 

  233. 

  234.       <tr><td><hr></hr></td></tr>
    235. 

  235. 

  236.       <tr><td>
    237. 

  237.         <h3><label for="newstatpress_ignore_users"><?php _e('Logged users to ignore','newstatpress') ?></label></h3>
    238. 

  238.         <p><?php _e("Enter a list of users you don't want to track, separated by commas, even if collect data about logged users is on",'newstatpress') ?></p>
    239. 

  239.         <p><textarea class="large-text code" cols="50" rows="1" name="newstatpress_ignore_users" id="newstatpress_ignore_users">
    240. 

  240.               <?php echo implode(',', get_option('newstatpress_ignore_users',array())) ?>
    241. 

  241.             </textarea></p>
    242. 

  242.         </td></tr>
    243. 

  243. 

  244.       <tr><td>
    245. 

  245.         <h3><label for="newstatpress_ignore_ip"><?php _e('IP addresses to ignore','newstatpress') ?></label></h3>
    246. 

  246.         <p><?php _e("Enter a list of networks you don't want to track, separated by commas. Each network <strong>must</strong> be defined using the CIDR notation (i.e. <em>192.168.1.1/24</em>). If the format is incorrect, NewStatPress may not track pageviews properly.",'newstatpress') ?></p>
    247. 

  247.         <p><textarea class="large-text code" cols="50" rows="1" name="newstatpress_ignore_ip" id="newstatpress_ignore_ip">
    248. 

  248.               <?php echo implode(',', get_option('newstatpress_ignore_ip',array())) ?>
    249. 

  249.             </textarea></p>
    250. 

  250.         </td></tr>
    251. 

  251. 

  252.       <tr><td>
    253. 

  253.         <h3><label for="newstatpress_ignore_permalink"><?php _e('Pages and posts to ignore','newstatpress') ?></label></h3>
    254. 

  254.         <p><?php _e("Enter a list of permalinks you don't want to track, separated by commas. You should omit the domain name from these resources: <em>/about, p=1</em>, etc. NewStatPress will ignore all the pageviews whose permalink <strong>contains</strong> at least one of them.",'newstatpress') ?></p>
    255. 

  255.         <p><textarea class="large-text code" cols="50" rows="1" name="newstatpress_ignore_permalink" id="newstatpress_ignore_permalink">
    256. 

  256.               <?php echo implode(',', get_option('newstatpress_ignore_permalink',array())) ?>
    257. 

  257.             </textarea></p>
    258. 

  258.         </td></tr>
    259. 

  259. 

  260.       <tr><td><hr></hr></td></tr>
    261. 

  261. 

  262.       <tr>
    263. 

  263.         <td>
    264. 

  264.       <h3><label for="newstatpress_details_options"><?php _e('Details options','newstatpress') ?></label></h3>
    265. 

  265.        </td></tr>
    266. 

  266. 

  267.       <tr>
    268. 

  268.         <td>
    269. 

  269.         <label for="newstatpress_el_top_days"><?php _e('Elements in Top days (default 5)','newstatpress') ?></label>
    270. 

  270.         <input type="text" name="newstatpress_el_top_days" value="<?php echo (get_option('newstatpress_el_top_days')=='') ? 5:get_option('newstatpress_el_top_days'); ?>" size="3" maxlength="3" />
    271. 

  271.        </td></tr>
    272. 

  272. 

  273.       <tr>
    274. 

  274.         <td>
    275. 

  275.         <label for="newstatpress_el_os"><?php _e('Elements in O.S. (default 10)','newstatpress') ?></label>
    276. 

  276.         <input type="text" name="newstatpress_el_os" value="<?php echo (get_option('newstatpress_el_os')=='') ? 10:get_option('newstatpress_el_os'); ?>" size="3" maxlength="3" />
    277. 

  277.        </td></tr>
    278. 

  278. 

  279.       <tr>
    280. 

  280.         <td>
    281. 

  281.         <label for="newstatpress_el_browser"><?php _e('Elements in Browser (default 10)','newstatpress') ?></label>
    282. 

  282.         <input type="text" name="newstatpress_el_browser" value="<?php echo (get_option('newstatpress_el_browser')=='') ? 10:get_option('newstatpress_el_browser'); ?>" size="3" maxlength="3" />
    283. 

  283.        </td></tr>
    284. 

  284. 

  285.       <tr>
    286. 

  286.         <td>
    287. 

  287.         <label for="newstatpress_el_feed"><?php _e('Elements in Feed (default 5)','newstatpress') ?></label>
    288. 

  288.         <input type="text" name="newstatpress_el_feed" value="<?php echo (get_option('newstatpress_el_feed')=='') ? 5:get_option('newstatpress_el_feed'); ?>" size="3" maxlength="3" />
    289. 

  289.        </td></tr>
    290. 

  290. 

  291.       <tr>
    292. 

  292.         <td>
    293. 

  293.         <label for="newstatpress_el_searchengine"><?php _e('Elements in Search Engines (default 10)','newstatpress') ?></label>
    294. 

  294.         <input type="text" name="newstatpress_el_searchengine" value="<?php echo (get_option('newstatpress_el_searchengine')=='') ? 10:get_option('newstatpress_el_searchengine'); ?>" size="3" maxlength="3" />
    295. 

  295.        </td></tr>
    296. 

  296. 

  297.       <tr>
    298. 

  298.         <td>
    299. 

  299.         <label for="newstatpress_el_search"><?php _e('Elements in Top Search Terms (default 20)','newstatpress') ?></label>
    300. 

  300.         <input type="text" name="newstatpress_el_search" value="<?php echo (get_option('newstatpress_el_search')=='') ? 20:get_option('newstatpress_el_search'); ?>" size="3" maxlength="3" />
    301. 

  301.        </td></tr>
    302. 

  302. 

  303.       <tr>
    304. 

  304.         <td>
    305. 

  305.         <label for="newstatpress_el_referrer"><?php _e('Elements in Top Refferer (default 10)','newstatpress') ?></label>
    306. 

  306.         <input type="text" name="newstatpress_el_referrer" value="<?php echo (get_option('newstatpress_el_referrer')=='') ? 10:get_option('newstatpress_el_referrer'); ?>" size="3" maxlength="3" />
    307. 

  307.        </td></tr>
    308. 

  308. 

  309.       <tr>
    310. 

  310.         <td>
    311. 

  311.         <label for="newstatpress_el_languages"><?php _e('Elements in Countries/Languages (default 20)','newstatpress') ?></label>
    312. 

  312.         <input type="text" name="newstatpress_el_languages" value="<?php echo (get_option('newstatpress_el_languages')=='') ? 20:get_option('newstatpress_el_languages'); ?>" size="3" maxlength="3" />
    313. 

  313.        </td></tr>
    314. 

  314. 

  315.       <tr>
    316. 

  316.         <td>
    317. 

  317.         <label for="newstatpress_el_spiders"><?php _e('Elements in Spiders (default 10)','newstatpress') ?></label>
    318. 

  318.         <input type="text" name="newstatpress_el_spiders" value="<?php echo (get_option('newstatpress_el_spiders')=='') ? 10:get_option('newstatpress_el_spiders'); ?>" size="3" maxlength="3" />
    319. 

  319.        </td></tr>
    320. 

  320. 

  321.       <tr>
    322. 

  322.         <td>
    323. 

  323.         <label for="newstatpress_el_pages"><?php _e('Elements in Top Pages (default 5)','newstatpress') ?></label>
    324. 

  324.         <input type="text" name="newstatpress_el_pages" value="<?php echo (get_option('newstatpress_el_pages')=='') ? 5:get_option('newstatpress_el_pages'); ?>" size="3" maxlength="3" />
    325. 

  325.        </td></tr>
    326. 

  326. 

  327.       <tr>
    328. 

  328.         <td>
    329. 

  329.         <label for="newstatpress_el_visitors"><?php _e('Elements in Top Days - Unique visitors (default 5)','newstatpress') ?></label>
    330. 

  330.         <input type="text" name="newstatpress_el_visitors" value="<?php echo (get_option('newstatpress_el_visitors')=='') ? 5:get_option('newstatpress_el_visitors'); ?>" size="3" maxlength="3" />
    331. 

  331.        </td></tr>
    332. 

  332. 

  333.       <tr>
    334. 

  334.         <td>
    335. 

  335.         <label for="newstatpress_el_daypages"><?php _e('Elements in Top Days - Pageviews (default 5)','newstatpress') ?></label>
    336. 

  336.         <input type="text" name="newstatpress_el_daypages" value="<?php echo (get_option('newstatpress_el_daypages')=='') ? 5:get_option('newstatpress_el_daypages'); ?>" size="3" maxlength="3" />
    337. 

  337.        </td></tr>
    338. 

  338. 

  339.       <tr>
    340. 

  340.         <td>
    341. 

  341.         <label for="newstatpress_el_ippages"><?php _e('Elements in Top IPs - Pageviews (default 5)','newstatpress') ?></label>
    342. 

  342.         <input type="text" name="newstatpress_el_ippages" value="<?php echo (get_option('newstatpress_el_ippages')=='') ? 5:get_option('newstatpress_el_ippages'); ?>" size="3" maxlength="3" />
    343. 

  343.        </td></tr>
    344. 

  344. 

  345.       <tr><td><hr></hr></td></tr>
    346. 

  346. 

  347.       <tr>
    348. 

  348.        <td>
    349. 

  349.         <h2><?php _e('Database update option','newstatpress'); ?></h3>
    350. 

  350.        </td></tr>
    351. 

  351.       <tr>
    352. 

  352.        <td>
    353. 

  353.          <p><?php _e("Select the interval of date from today you want to use for updating your database with new definitions. More it is big and more times and resources it require. You can choose to not update some fields if you want.",'newstatpress') ?></p>
    354. 

  354.        </td></tr>
    355. 

  355. 

  356.       <tr>
    357. 

  357.        <td>
    358. 

  358.         <?php _e('Update data in the given period','newstatpress'); ?>
    359. 

  359.         <select name="newstatpress_updateint">
    360. 

  360.           <option value="" <?php if(get_option('newstatpress_updateint') =='' ) print "selected"; ?>><?php _e('All!','newstatpress'); ?></option>
    361. 

  361.           <option value="1 week" <?php if(get_option('newstatpress_updateint') == "1 week") print "selected"; ?>>1 <?php _e('week','newstatpress'); ?></option>
    362. 

  362.           <option value="2 weeks" <?php if(get_option('newstatpress_updateint') == "2 weeks") print "selected"; ?>>2 <?php _e('weeks','newstatpress'); ?></option>
    363. 

  363.           <option value="3 weeks" <?php if(get_option('newstatpress_updateint') == "3 weeks") print "selected"; ?>>3 <?php _e('weeks','newstatpress'); ?></option>
    364. 

  364.           <option value="1 month" <?php if(get_option('newstatpress_updateint') == "1 month") print "selected"; ?>>1 <?php _e('month','newstatpress'); ?></option>
    365. 

  365.           <option value="2 months" <?php if(get_option('newstatpress_updateint') == "2 months") print "selected"; ?>>2 <?php _e('months','newstatpress'); ?></option>
    366. 

  366.           <option value="3 months" <?php if(get_option('newstatpress_updateint') == "3 months") print "selected"; ?>>3 <?php _e('months','newstatpress'); ?></option>
    367. 

  367.           <option value="6 months" <?php if(get_option('newstatpress_updateint') == "6 months") print "selected"; ?>>6 <?php _e('months','newstatpress'); ?></option>
    368. 

  368.           <option value="9 months" <?php if(get_option('newstatpress_updateint') == "9 months") print "selected"; ?>>9 <?php _e('months','newstatpress'); ?></option>
    369. 

  369.           <option value="1 year" <?php if(get_option('newstatpress_updateint') == "1 year") print "selected"; ?>>1 <?php _e('year','newstatpress'); ?></option>
    370. 

  370.         </select></td></tr>
    371. 

  371.        </td></tr>
    372. 

  372. 

  373.       <tr><td><hr></hr></td></tr>
    374. 

  374. 

  375.       <tr><td><br><input type=submit value="<?php _e('Save options','newstatpress'); ?>"></td></tr>
    376. 

  376.       </tr>
    377. 

  377.       </table>
    378. 

  378.       <input type=hidden name=saveit value=yes>
    379. 

  379.       <input type=hidden name=page value=newstatpress><input type=hidden name=newstatpress_action value=options>
    380. 

  380.       </form>
    381. 

  381.       </div>
    382. 

  382.       <?php
    383. 

  383.     } 
    384. 

  384. }
    385. 

  385. 

  386. 

  387. function iri_dropdown_caps( $default = false ) {
    388. 

  388.   global $wp_roles;
    389. 

  389.   $role = get_role('administrator');
    390. 

  390.   foreach($role->capabilities as $cap => $grant) {
    391. 

  391.     print "<option ";
    392. 

  392.     if($default == $cap) { print "selected "; }
    393. 

  393.     print ">$cap</option>";
    394. 

  394.   }
    395. 

  395. }
    396. 

  396. 

  397. /**
    398. 

  398.  * Show credits about this plugin
    399. 

  399.  */
    400. 

  400. function iriNewStatPressCredits() {
    401. 

  401. ?>
    402. 

  402.   <div class='wrap'><h2><?php _e('Credits','newstatpress'); ?></h2>
    403. 

  403.   <table border="1">
    404. 

  404.    <tr>
    405. 

  405.     <th>People</th>
    406. 

  406.     <th>Description</th>
    407. 

  407.     <th>Link</th>
    408. 

  408.    </tr>
    409. 

  409.    <tr>
    410. 

  410.     <td>Stefano Tognon</td>
    411. 

  411.     <td>NewStatPress develoup</td>
    412. 

  412.     <td><a href="http://newstatpress.altervista.org">NewStatPress site</a></td>
    413. 

  413.    </tr>
    414. 

  414.    <tr>
    415. 

  415.     <td>Daniele Lippi</td>
    416. 

  416.     <td>Original StatPress develoup</td>
    417. 

  417.     <td><a href="http://wordpress.org/extend/plugins/statpress/">StatPress site</a></td>
    418. 

  418.    </tr>
    419. 

  419.    <tr>
    420. 

  420.     <td>Pawel Dworniak</td>
    421. 

  421.     <td>Better polish translation</td>
    422. 

  422.     <td></td>
    423. 

  423.    </tr>
    424. 

  424.    <tr>
    425. 

  425.     <td>Sisko</td>
    426. 

  426.     <td>Open link in new tab/window<br>
    427. 

  427.         New displays of data for spy function<br>
    428. 

  428.     </td>
    429. 

  429.     <td></td>
    430. 

  430.    </tr>
    431. 

  431.    <tr>
    432. 

  432.     <td>from wp_slimstat</td>
    433. 

  433.     <td>Add option for not track given IPs<br>
    434. 

  434.         Add option for not track given permalinks
    435. 

  435.     </td>
    436. 

  436.     <td></td>
    437. 

  437.    </tr>
    438. 

  438.    <tr>
    439. 

  439.     <td>Ladislav</td>
    440. 

  440.     <td>Let Search function to works again</td>
    441. 

  441.     <td></td>
    442. 

  442.    </tr>
    443. 

  443.    <tr>
    444. 

  444.     <td>from statpress-visitors</td>
    445. 

  445.     <td>Add new OS (+44), browsers (+52) and spiders (+71)<br>
    446. 

  446.         Add in the option the ability to update in a range of date<br>
    447. 

  447.         New spy and bot
    448. 

  448.     </td>
    449. 

  449.     <td></td>
    450. 

  450.    </tr>
    451. 

  451.    <tr>
    452. 

  452.     <td>Christopher Meng</td>
    453. 

  453.     <td>Add Simplified Chinese translation</td>
    454. 

  454.     <td><a href="http://cicku.me">cicku.me</a></td>
    455. 

  455.    </tr>
    456. 

  456.    <tr>
    457. 

  457.     <td>Maurice Cramer</td>
    458. 

  458.     <td>Add dashboard widget<br>
    459. 

  459.         Fix total since in overwiew<br>
    460. 

  460.         Fix missing browser image and IE aligment failure in spy section<br>
    461. 

  461.         Fix nation image display in spy
    462. 

  462.     </td>
    463. 

  463.     <td></td>
    464. 

  464.    </tr>
    465. 

  465.    <tr>
    466. 

  466.     <td>shilom</td>
    467. 

  467.     <td>Updating French translation</td>
    468. 

  468.     <td></td>
    469. 

  469.    </tr>
    470. 

  470.    <tr>
    471. 

  471.     <td>Vincent G</td>
    472. 

  472.     <td>Add Lithuanian translation</td>
    473. 

  473.     <td><a href="http://www.Host1Free.com">Host1Free (Free Hosting)</a></td>
    474. 

  474.    </tr>
    475. 

  475.    <tr>
    476. 

  476.     <td>Ruud van der Veen</td>
    477. 

  477.     <td>Add tab delimiter for exporting data</td>
    478. 

  478.     <td></td>
    479. 

  479.    </tr>
    480. 

  480.   </table>
    481. 

  481.   </div>
    482. 

  482. <?php
    483. 

  483. }
    484. 

  484. 

  485. 

  486. function iriNewStatPressExport() {
    487. 

  487. ?>
    488. 

  488. 	<div class='wrap'><h2><?php _e('Export stats to text file','newstatpress'); ?> (csv)</h2>
    489. 

  489. 	<form method=get><table>
    490. 

  490. 	<tr><td><?php _e('From','newstatpress'); ?></td><td><input type=text name=from> (YYYYMMDD)</td></tr>
    491. 

  491. 	<tr><td><?php _e('To','newstatpress'); ?></td><td><input type=text name=to> (YYYYMMDD)</td></tr>
    492. 

  492. 	<tr><td><?php _e('Fields delimiter','newstatpress'); ?></td><td><select name=del><option>,</option><option>tab</option><option>;</option><option>|</option></select></tr>
    493. 

  493. 	<tr><td></td><td><input type=submit value=<?php _e('Export','newstatpress'); ?>></td></tr>
    494. 

  494. 	<input type=hidden name=page value=newstatpress><input type=hidden name=newstatpress_action value=exportnow>
    495. 

  495. 	</table></form>
    496. 

  496. 	</div>
    497. 

  497. <?php
    498. 

  498. }
    499. 

  499. 

  500. /**
    501. 

  501.  * Check and export if capability of user allow that
    502. 

  502.  */
    503. 

  503. function iri_checkExport(){
    504. 

  504.   if (isset($_GET['newstatpress_action']) && $_GET['newstatpress_action'] == 'exportnow') {
    505. 

  505.     $mincap=get_option('newstatpress_mincap');
    506. 

  506.     if ($mincap == '') $mincap = "level_8";
    507. 

  507.     if ( current_user_can( $mincap ) ) {
    508. 

  508.       iriNewStatPressExportNow();
    509. 

  509.     } 
    510. 

  510.   }
    511. 

  511. }
    512. 

  512. 

  513. /**
    514. 

  514.  * Export the NewStatPress data
    515. 

  515.  */
    516. 

  516. function iriNewStatPressExportNow() {
    517. 

  517.   global $wpdb;
    518. 

  518.   $table_name = $wpdb->prefix . "statpress";
    519. 

  519.   $filename=get_bloginfo('title' )."-newstatpress_".$_GET['from']."-".$_GET['to'].".csv";
    520. 

  520.   header('Content-Description: File Transfer');
    521. 

  521.   header("Content-Disposition: attachment; filename=$filename");
    522. 

  522.   header('Content-Type: text/plain charset=' . get_option('blog_charset'), true);
    523. 

  523.   $qry = $wpdb->get_results(
    524. 

  524.     "SELECT * 
    525. 

  525.      FROM $table_name 
    526. 

  526.      WHERE 
    527. 

  527.        date>='".(date("Ymd",strtotime(substr($_GET['from'],0,8))))."' AND 
    528. 

  528.        date<='".(date("Ymd",strtotime(substr($_GET['to'],0,8))))."';
    529. 

  529.     ");
    530. 

  530.   $del=substr($_GET['del'],0,1);
    531. 

  531.   if ($del=="t") { 
    532. 

  532.     $del="\t"; 
    533. 

  533.   }
    534. 

  534.   print "date".$del."time".$del."ip".$del."urlrequested".$del."agent".$del."referrer".$del."search".$del."nation".$del."os".$del."browser".$del."searchengine".$del."spider".$del."feed\n";
    535. 

  535.   foreach ($qry as $rk) {
    536. 

  536.     print '"'.$rk->date.'"'.$del.'"'.$rk->time.'"'.$del.'"'.$rk->ip.'"'.$del.'"'.$rk->urlrequested.'"'.$del.'"'.$rk->agent.'"'.$del.'"'.$rk->referrer.'"'.$del.'"'.$rk->search.'"'.$del.'"'.$rk->nation.'"'.$del.'"'.$rk->os.'"'.$del.'"'.$rk->browser.'"'.$del.'"'.$rk->searchengine.'"'.$del.'"'.$rk->spider.'"'.$del.'"'.$rk->feed.'"'."\n";
    537. 

  537.   }
    538. 

  538.   die();
    539. 

  539. }
    540. 

  540. 

  541. /**
    542. 

  542.  * Show overwiew
    543. 

  543.  */
    544. 

  544. function iriNewStatPressMain() {
    545. 

  545.   global $wpdb;
    546. 

  546.   $table_name = $wpdb->prefix . "statpress";
    547. 

  547. 

  548.   iriOverview();
    549. 

  549. 

  550.   $_newstatpress_url=PluginUrl();
    551. 

  551. 

  552.   $querylimit="LIMIT 10";
    553. 

  553.     
    554. 

  554.   # Tabella Last hits
    555. 

  555.   print "<div class='wrap'><h2>". __('Last hits','newstatpress'). "</h2><table class='widefat'><thead><tr><th scope='col'>". __('Date','newstatpress'). "</th><th scope='col'>". __('Time','newstatpress'). "</th><th scope='col'>IP</th><th scope='col'>". __('Country','newstatpress').'/'.__('Language','newstatpress'). "</th><th scope='col'>". __('Page','newstatpress'). "</th><th scope='col'>Feed</th><th></th><th scope='col' style='width:120px;'>OS</th><th></th><th scope='col' style='width:120px;'>Browser</th></tr></thead>";
    556. 

  556.   print "<tbody id='the-list'>";	
    557. 

  557. 

  558.   $fivesdrafts = $wpdb->get_results("
    559. 

  559.     SELECT * 
    560. 

  560.     FROM $table_name 
    561. 

  561.     WHERE (os<>'' OR feed<>'') 
    562. 

  562.     ORDER bY id DESC $querylimit
    563. 

  563.   ");
    564. 

  564.   foreach ($fivesdrafts as $fivesdraft) {
    565. 

  565.     print "<tr>";
    566. 

  566.     print "<td>". irihdate($fivesdraft->date) ."</td>";
    567. 

  567.     print "<td>". $fivesdraft->time ."</td>";
    568. 

  568.     print "<td>". $fivesdraft->ip ."</td>";
    569. 

  569.     print "<td>". $fivesdraft->nation ."</td>";
    570. 

  570.     print "<td>". iri_NewStatPress_Abbrevia(iri_NewStatPress_Decode($fivesdraft->urlrequested),30) ."</td>";
    571. 

  571.     print "<td>". $fivesdraft->feed . "</td>";
    572. 

  572.     if($fivesdraft->os != '') {
    573. 

  573.       $img=str_replace(" ","_",strtolower($fivesdraft->os)).".png";
    574. 

  574.       print "<td><IMG style='border:0px;width:16px;height:16px;' SRC='".$_newstatpress_url."/images/os/$img'> </td>";
    575. 

  575.     } else {
    576. 

  576.         print "<td></td>";
    577. 

  577.       }
    578. 

  578.     print "<td>". $fivesdraft->os . "</td>";
    579. 

  579.     if($fivesdraft->browser != '') {
    580. 

  580.       $img=str_replace(" ","",strtolower($fivesdraft->browser)).".png";
    581. 

  581.       print "<td><IMG style='border:0px;width:16px;height:16px;' SRC='".$_newstatpress_url."/images/browsers/$img'></td>";
    582. 

  582.     } else {
    583. 

  583.        print "<td></td>";
    584. 

  584.     }
    585. 

  585.     print "<td>".$fivesdraft->browser."</td></tr>\n";
    586. 

  586.     print "</tr>";
    587. 

  587.   }
    588. 

  588.   print "</table></div>";
    589. 

  589. 

  590. 

  591.   # Last Search terms
    592. 

  592.   print "<div class='wrap'><h2>" . __('Last search terms','newstatpress') . "</h2><table class='widefat'><thead><tr><th scope='col'>".__('Date','newstatpress')."</th><th scope='col'>".__('Time','newstatpress')."</th><th scope='col'>".__('Terms','newstatpress')."</th><th scope='col'>". __('Engine','newstatpress'). "</th><th scope='col'>". __('Result','newstatpress'). "</th></tr></thead>";
    593. 

  593.   print "<tbody id='the-list'>";	
    594. 

  594.   $qry = $wpdb->get_results("
    595. 

  595.     SELECT date,time,referrer,urlrequested,search,searchengine 
    596. 

  596.     FROM $table_name 
    597. 

  597.     WHERE search<>'' 
    598. 

  598.     ORDER BY id DESC $querylimit
    599. 

  599.   ");
    600. 

  600.   foreach ($qry as $rk) {
    601. 

  601.     print "<tr><td>".irihdate($rk->date)."</td><td>".$rk->time."</td><td><a href='".$rk->referrer."' target='_blank'>".$rk->search."</a></td><td>".$rk->searchengine."</td><td><a href='".get_bloginfo('url')."/?".$rk->urlrequested."' target='_blank'>". __('page viewed','newstatpress'). "</a></td></tr>\n";
    602. 

  602.   }
    603. 

  603.   print "</table></div>";
    604. 

  604. 

  605.   # Referrer
    606. 

  606.   print "<div class='wrap'><h2>".__('Last referrers','newstatpress')."</h2><table class='widefat'><thead><tr><th scope='col'>".__('Date','newstatpress')."</th><th scope='col'>".__('Time','newstatpress')."</th><th scope='col'>".__('URL','newstatpress')."</th><th scope='col'>".__('Result','newstatpress')."</th></tr></thead>";
    607. 

  607.   print "<tbody id='the-list'>";	
    608. 

  608.   $qry = $wpdb->get_results("
    609. 

  609.     SELECT date,time,referrer,urlrequested 
    610. 

  610.     FROM $table_name 
    611. 

  611.     WHERE 
    612. 

  612.      ((referrer NOT LIKE '".get_option('home')."%') AND 
    613. 

  613.       (referrer <>'') AND 
    614. 

  614.       (searchengine='')
    615. 

  615.      ) ORDER BY id DESC $querylimit
    616. 

  616.   ");
    617. 

  617.   foreach ($qry as $rk) {
    618. 

  618.     print "<tr><td>".irihdate($rk->date)."</td><td>".$rk->time."</td><td><a href='".$rk->referrer."' target='_blank'>".iri_NewStatPress_Abbrevia($rk->referrer,80)."</a></td><td><a href='".get_bloginfo('url')."/?".$rk->urlrequested."'  target='_blank'>". __('page viewed','newstatpress'). "</a></td></tr>\n";
    619. 

  619.   }
    620. 

  620.   print "</table></div>";
    621. 

  621. 

  622. 

  623.   # Last Agents
    624. 

  624.   print "<div class='wrap'><h2>".__('Last agents','newstatpress')."</h2><table class='widefat'><thead><tr><th scope='col'>".__('Agent','newstatpress')."</th><th scope='col'></th><th scope='col' style='width:120px;'>OS</th><th scope='col'></th><th scope='col' style='width:120px;'>Browser/Spider</th></tr></thead>";
    625. 

  625.   print "<tbody id='the-list'>";	
    626. 

  626.   $qry = $wpdb->get_results("
    627. 

  627.     SELECT agent,os,browser,spider 
    628. 

  628.     FROM $table_name 
    629. 

  629.     GROUP BY agent,os,browser,spider 
    630. 

  630.     ORDER BY id DESC $querylimit
    631. 

  631.   ");
    632. 

  632.   foreach ($qry as $rk) {
    633. 

  633.     print "<tr><td>".$rk->agent."</td>";
    634. 

  634.     if($rk->os != '') {
    635. 

  635.       $img=str_replace(" ","_",strtolower($rk->os)).".png";
    636. 

  636.       print "<td><IMG style='border:0px;width:16px;height:16px;' SRC='".$_newstatpress_url."/images/os/$img'> </td>";
    637. 

  637.     } else {
    638. 

  638.         print "<td></td>";
    639. 

  639.       }
    640. 

  640.     print "<td>". $rk->os . "</td>";
    641. 

  641.     if($rk->browser != '') {
    642. 

  642.       $img=str_replace(" ","",strtolower($rk->browser)).".png";
    643. 

  643.       print "<td><IMG style='border:0px;width:16px;height:16px;' SRC='".$_newstatpress_url."/images/browsers/$img'></td>";
    644. 

  644.     } else {
    645. 

  645.         print "<td></td>";
    646. 

  646.       }
    647. 

  647.     print "<td>".$rk->browser." ".$rk->spider."</td></tr>\n";
    648. 

  648.   }
    649. 

  649.   print "</table></div>";
    650. 

  650. 

  651. 

  652.   # Last pages
    653. 

  653.   print "<div class='wrap'><h2>".__('Last pages','newstatpress')."</h2><table class='widefat'><thead><tr><th scope='col'>".__('Date','newstatpress')."</th><th scope='col'>".__('Time','newstatpress')."</th><th scope='col'>".__('Page','newstatpress')."</th><th scope='col' style='width:17px;'></th><th scope='col' style='width:120px;'>".__('OS','newstatpress')."</th><th style='width:17px;'></th><th scope='col' style='width:120px;'>".__('Browser','newstatpress')."</th></tr></thead>";
    654. 

  654.   print "<tbody id='the-list'>";	
    655. 

  655.   $qry = $wpdb->get_results("
    656. 

  656.     SELECT date,time,urlrequested,os,browser,spider 
    657. 

  657.     FROM $table_name 
    658. 

  658.     WHERE (spider='' AND feed='') 
    659. 

  659.     ORDER BY id DESC $querylimit
    660. 

  660.   ");
    661. 

  661.   foreach ($qry as $rk) {
    662. 

  662.     print "<tr><td>".irihdate($rk->date)."</td><td>".$rk->time."</td><td>".iri_NewStatPress_Abbrevia(iri_NewStatPress_Decode($rk->urlrequested),60)."</td>";
    663. 

  663.     if($rk->os != '') {
    664. 

  664.       $img=str_replace(" ","_",strtolower($rk->os)).".png";
    665. 

  665.       print "<td><IMG style='border:0px;width:16px;height:16px;' SRC='".$_newstatpress_url."/images/os/$img'> </td>";
    666. 

  666.     } else {
    667. 

  667.         print "<td></td>";
    668. 

  668.       }
    669. 

  669.     print "<td>". $rk->os . "</td>";
    670. 

  670.     if($rk->browser != '') {
    671. 

  671.       $img=str_replace(" ","",strtolower($rk->browser)).".png";
    672. 

  672.       print "<td><IMG style='border:0px;width:16px;height:16px;' SRC='".$_newstatpress_url."/images/browsers/$img'></td>";
    673. 

  673.     } else {
    674. 

  674.         print "<td></td>";
    675. 

  675.       }
    676. 

  676.     print "<td>".$rk->browser." ".$rk->spider."</td></tr>\n";
    677. 

  677.   }
    678. 

  678.   print "</table></div>";
    679. 

  679. 

  680. 

  681.   # Last Spiders
    682. 

  682.   print "<div class='wrap'><h2>".__('Last spiders','newstatpress')."</h2><table class='widefat'><thead><tr><th scope='col'>".__('Date','newstatpress')."</th><th scope='col'>".__('Time','newstatpress')."</th><th scope='col'></th><th scope='col'>".__('Spider','newstatpress')."</th><th scope='col'>".__('Agent','newstatpress')."</th></tr></thead>";
    683. 

  683.   print "<tbody id='the-list'>";	
    684. 

  684.   $qry = $wpdb->get_results("
    685. 

  685.     SELECT date,time,agent,os,browser,spider 
    686. 

  686.     FROM $table_name 
    687. 

  687.     WHERE (spider<>'') 
    688. 

  688.     ORDER BY id DESC $querylimit
    689. 

  689.   ");
    690. 

  690.   foreach ($qry as $rk) {
    691. 

  691.     print "<tr><td>".irihdate($rk->date)."</td><td>".$rk->time."</td>";
    692. 

  692.     if($rk->spider != '') {
    693. 

  693.       $img=str_replace(" ","_",strtolower($rk->spider)).".png";
    694. 

  694.       print "<td><IMG style='border:0px;height:16px;' SRC='".$_newstatpress_url."/images/spider/$img'> </td>";
    695. 

  695.     } else print "<td></td>";
    696. 

  696.     print "<td>".$rk->spider."</td><td> ".$rk->agent."</td></tr>\n";
    697. 

  697.   }
    698. 

  698.   print "</table></div>";
    699. 

  699. 

  700.   print "<br />";
    701. 

  701.   print "&nbsp;<i>StatPress table size: <b>".iritablesize($wpdb->prefix . "statpress")."</b></i><br />";
    702. 

  702.   print "&nbsp;<i>StatPress current time: <b>".current_time('mysql')."</b></i><br />";
    703. 

  703.   print "&nbsp;<i>RSS2 url: <b>".get_bloginfo('rss2_url').' ('.iriNewStatPress_extractfeedreq(get_bloginfo('rss2_url')).")</b></i><br />"; 
    704. 

  704. }
    705. 

  705. 

  706. /**
    707. 

  707.  * Extract the feed from the given url
    708. 

  708.  *
    709. 

  709.  * @param url the url to parse
    710. 

  710.  * @return the extracted url 
    711. 

  711.  */
    712. 

  712. function iriNewStatPress_extractfeedreq($url) {
    713. 

  713.   list($null,$q)=explode("?",$url);
    714. 

  714.   if (strpos($q, "&")!== false) list($res,$null)=explode("&",$q);
    715. 

  715.   else $res=$q;
    716. 

  716.   return $res;
    717. 

  717. }
    718. 

  718. 

  719. function iriNewStatPressDetails() {
    720. 

  720.   global $wpdb;
    721. 

  721.   $table_name = $wpdb->prefix . "statpress";
    722. 

  722. 

  723.   $querylimit="LIMIT 10";
    724. 

  724. 

  725.   # Top days
    726. 

  726.   iriValueTable2("date","Top days",(get_option('newstatpress_el_top_days')=='') ? 5:get_option('newstatpress_el_top_days'));
    727. 

  727. 

  728.   # O.S.
    729. 

  729.   iriValueTable2("os","O.S.",(get_option('newstatpress_el_os')=='') ? 10:get_option('newstatpress_el_os'),"","","AND feed='' AND spider='' AND os<>''");
    730. 

  730. 

  731.   # Browser
    732. 

  732.   iriValueTable2("browser","Browser",(get_option('newstatpress_el_browser')=='') ? 10:get_option('newstatpress_el_browser'),"","","AND feed='' AND spider='' AND browser<>''");	
    733. 

  733. 

  734.   # Feeds
    735. 

  735.   iriValueTable2("feed","Feeds",(get_option('newstatpress_el_feed')=='') ? 5:get_option('newstatpress_el_feed'),"","","AND feed<>''");
    736. 

  736.     
    737. 

  737.   # SE
    738. 

  738.   iriValueTable2("searchengine","Search engines",(get_option('newstatpress_el_searchengine')=='') ? 10:get_option('newstatpress_el_searchengine'),"","","AND searchengine<>''");
    739. 

  739. 

  740.   # Search terms
    741. 

  741.   iriValueTable2("search","Top search terms",(get_option('newstatpress_el_search')=='') ? 20:get_option('newstatpress_el_search'),"","","AND search<>''");
    742. 

  742. 

  743.   # Top referrer
    744. 

  744.   iriValueTable2("referrer","Top referrer",(get_option('newstatpress_el_referrer')=='') ? 10:get_option('newstatpress_el_referrer'),"","","AND referrer<>'' AND referrer NOT LIKE '%".get_bloginfo('url')."%'");
    745. 

  745.  
    746. 

  746.   # Languages
    747. 

  747.   iriValueTable2("nation","Countries/Languages",(get_option('newstatpress_el_languages')=='') ? 20:get_option('newstatpress_el_languages'),"","","AND nation<>'' AND spider=''");
    748. 

  748. 

  749.   # Spider
    750. 

  750.   iriValueTable2("spider","Spiders",(get_option('newstatpress_el_spiders')=='') ? 10:get_option('newstatpress_el_spiders'),"","","AND spider<>''");
    751. 

  751. 

  752.   # Top Pages
    753. 

  753.   iriValueTable2("urlrequested","Top pages",(get_option('newstatpress_el_pages')=='') ? 5:get_option('newstatpress_el_pages'),"","urlrequested","AND feed='' and spider=''");
    754. 

  754. 

  755.   # Top Days - Unique visitors
    756. 

  756.   iriValueTable2("date","Top Days - Unique visitors",(get_option('newstatpress_el_visitors')=='') ? 5:get_option('newstatpress_el_visitors'),"distinct","ip","AND feed='' and spider=''"); /* Maddler 04112007: required patching iriValueTable */
    757. 

  757. 

  758.   # Top Days - Pageviews
    759. 

  759.   iriValueTable2("date","Top Days - Pageviews",(get_option('newstatpress_el_daypages')=='') ? 5:get_option('newstatpress_el_daypages'),"","urlrequested","AND feed='' and spider=''"); /* Maddler 04112007: required patching iriValueTable */
    760. 

  760. 

  761.   # Top IPs - Pageviews
    762. 

  762.   iriValueTable2("ip","Top IPs - Pageviews",(get_option('newstatpress_el_ippages')=='') ? 5:get_option('newstatpress_el_ippages'),"","urlrequested","AND feed='' and spider=''"); /* Maddler 04112007: required patching iriValueTable */
    763. 

  763. }
    764. 

  764. 

  765. 

  766. /**
    767. 

  767.  * Converte da data us to default format di Wordpress
    768. 

  768.  *
    769. 

  769.  * @param dt the date to convert
    770. 

  770.  * @return converted data
    771. 

  771.  */
    772. 

  772. function newstatpress_hdate($dt = "00000000") {
    773. 

  773.   return mysql2date(get_option('date_format'), my_substr($dt, 0, 4) . "-" . my_substr($dt, 4, 2) . "-" . my_substr($dt, 6, 2));
    774. 

  774. }
    775. 

  775. 

  776. /**
    777. 

  777.  * Decode the url in a better manner
    778. 

  778.  */
    779. 

  779. function newstatpress_Decode($out_url) {
    780. 

  780.   if(!permalinksEnabled()) {
    781. 

  781.     if ($out_url == '') $out_url = __('Page', 'newstatpress') . ": Home";
    782. 

  782.     if (my_substr($out_url, 0, 4) == "cat=") $out_url = __('Category', 'statpress') . ": " . get_cat_name(my_substr($out_url, 4));
    783. 

  783.     if (my_substr($out_url, 0, 2) == "m=") $out_url = __('Calendar', 'newstatpress') . ": " . my_substr($out_url, 6, 2) . "/" . my_substr($out_url, 2, 4);
    784. 

  784.     if (my_substr($out_url, 0, 2) == "s=") $out_url = __('Search', 'newstatpress') . ": " . my_substr($out_url, 2);
    785. 

  785.     if (my_substr($out_url, 0, 2) == "p=") {
    786. 

  786.       $post_id_7 = get_post(my_substr($out_url, 2), ARRAY_A);
    787. 

  787.       $out_url = $post_id_7['post_title'];
    788. 

  788.     }
    789. 

  789.     if (my_substr($out_url, 0, 8) == "page_id=") {
    790. 

  790.       $post_id_7 = get_page(my_substr($out_url, 8), ARRAY_A);
    791. 

  791.       $out_url = __('Page', 'newstatpress') . ": " . $post_id_7['post_title'];
    792. 

  792.     }
    793. 

  793.  } else {
    794. 

  794.      if ($out_url == '') $out_url = __('Page', 'newstatpress') . ": Home";
    795. 

  795.      else if (my_substr($out_url, 0, 9) == "category/") $out_url = __('Category', 'newstatpress') . ": " . get_cat_name(my_substr($out_url, 9));
    796. 

  796.           else if (my_substr($out_url, 0, 2) == "s=") $out_url = __('Search', 'newstatpress') . ": " . my_substr($out_url, 2);
    797. 

  797.                else if (my_substr($out_url, 0, 2) == "p=") {
    798. 

  798.                       // not working yet           
    799. 

  799.                       $post_id_7 = get_post(my_substr($out_url, 2), ARRAY_A);
    800. 

  800.                       $out_url = $post_id_7['post_title'];
    801. 

  801.                     } else if (my_substr($out_url, 0, 8) == "page_id=") { 
    802. 

  802.                              // not working yet
    803. 

  803.                              $post_id_7 = get_page(my_substr($out_url, 8), ARRAY_A);
    804. 

  804.                              $out_url = __('Page', 'newstatpress') . ": " . $post_id_7['post_title'];
    805. 

  805.                            }
    806. 

  806.    }
    807. 

  807.    return $out_url;
    808. 

  808. }
    809. 

  809. 

  810. /**
    811. 

  811.  * Get true if permalink is enabled in Wordpress
    812. 

  812.  * (taken in statpress-visitors)
    813. 

  813.  *
    814. 

  814.  * @return true if permalink is enabled in Wordpress
    815. 

  815.  */
    816. 

  816. function permalinksEnabled() { 
    817. 

  817.   global $wpdb;
    818. 

  818.       
    819. 

  819.   $result = $wpdb->get_row('SELECT `option_value` FROM `' . $wpdb->prefix . 'options` WHERE `option_name` = "permalink_structure"');
    820. 

  820.   if ($result->option_value != '') return true;
    821. 

  821.   else return false;
    822. 

  822. }
    823. 

  823. 

  824. /** 
    825. 

  825.  * PHP 4 compatible mb_substr function
    826. 

  826.  * (taken in statpress-visitors)
    827. 

  827.  */
    828. 

  828. function my_substr($str, $x, $y = 0) {
    829. 

  829.   if($y == 0) $y = strlen($str) - $x;
    830. 

  830.   if(function_exists('mb_substr'))
    831. 

  831.   return mb_substr($str, $x, $y);
    832. 

  832.   else
    833. 

  833.  return substr($str, $x, $y);
    834. 

  834. }
    835. 

  835. 

  836. /**
    837. 

  837.  * Display links for group of pages
    838. 

  838.  *
    839. 

  839.  * @param NP the group of pages
    840. 

  840.  * @param pp the page to show
    841. 

  841.  * @param action the action
    842. 

  842.  */
    843. 

  843. function newstatpress_print_pp_link($NP,$pp,$action) {
    844. 

  844.   // For all pages ($NP) Display first 3 pages, 3 pages before current page($pp), 3 pages after current page , each 25 pages and the 3 last pages for($action)
    845. 

  845.   $GUIL1 = FALSE;
    846. 

  846.   $GUIL2 = FALSE;// suspension points  not writed  style='border:0px;width:16px;height:16px;   style="border:0px;width:16px;height:16px;"
    847. 

  847.   if ($NP >1) {
    848. 

  848.     print "<font size='1'>".__('period of days','newstatpress')." : </font>";
    849. 

  849.     for ($i = 1; $i <= $NP; $i++) {
    850. 

  850.       if ($i <= $NP) { 
    851. 

  851.         // $page is not the last page
    852. 

  852.         if($i == $pp) echo " [{$i}] "; // $page is current page
    853. 

  853.         else { 
    854. 

  854.           // Not the current page Hyperlink them
    855. 

  855.           if (($i <= 3) or (($i >= $pp-3) and ($i <= $pp+3)) or ($i >= $NP-3) or is_int($i/100)) { 
    856. 

  856.             echo '<a href="' . $_SERVER['SCRIPT_NAME'] . '?page=newstatpress/newstatpress.php&newstatpress_action='.$action.'&pp=' . $i .'">' . $i . '</a> ';
    857. 

  857.           } else { 
    858. 

  858.               if (($GUIL1 == FALSE) OR ($i==$pp+4)) {
    859. 

  859.                 echo "..."; 
    860. 

  860.                 $GUIL1 = TRUE;
    861. 

  861.               }
    862. 

  862.               if ($i == $pp-4) echo ".."; 
    863. 

  863.               if (is_int(($i-1)/100)) echo "."; 
    864. 

  864.               if ($i == $NP-4) echo "..";   
    865. 

  865.               // suspension points writed
    866. 

  866.             }
    867. 

  867.          }
    868. 

  868.       }
    869. 

  869.     }
    870. 

  870.   }
    871. 

  871. }
    872. 

  872. 

  873. /**
    874. 

  874.  * Display links for group of pages
    875. 

  875.  *
    876. 

  876.  * @param NP the group of pages
    877. 

  877.  * @param pp the page to show
    878. 

  878.  * @param action the action
    879. 

  879.  * @param NA group
    880. 

  880.  * @param pa current page
    881. 

  881.  */
    882. 

  882. function newstatpress_print_pp_pa_link($NP,$pp,$action,$NA,$pa) {   
    883. 

  883.   if ($NP<>0) newstatpress_print_pp_link($NP,$pp,$action);
    884. 

  884. 

  885.   // For all pages ($NP) display first 5 pages, 3 pages before current page($pa), 3 pages after current page , 3 last pages 
    886. 

  886.   $GUIL1 = FALSE;// suspension points not writed
    887. 

  887.   $GUIL2 = FALSE;
    888. 

  888. 

  889.   echo '<table width="100%" border="0"><tr></tr></table>';
    890. 

  890.   if ($NA >1 ) {
    891. 

  891.     echo "<font size='1'>".__('Pages','newstatpress')." : </font>";
    892. 

  892.     for ($j = 1; $j <= $NA; $j++) {
    893. 

  893.       if ($j <= $NA) {  // $i is not the last Articles page
    894. 

  894.         if($j == $pa)  // $i is current page
    895. 

  895.           echo " [{$j}] ";
    896. 

  896.         else { // Not the current page Hyperlink them
    897. 

  897.           if (($j <= 5) or (( $j>=$pa-2) and ($j <= $pa+2)) or ($j >= $NA-2)) 
    898. 

  898.             echo '<a href="' . $_SERVER['SCRIPT_NAME'] . '?page=newstatpress/newstatpress.php&newstatpress_action='.$action.'&pp=' . $pp . '&pa='. $j . '">' . $j . '</a> ';
    899. 

  899.           else { 
    900. 

  900.             if ($GUIL1 == FALSE) echo "... "; $GUIL1 = TRUE;
    901. 

  901.             if (($j == $pa+4) and ($GUIL2 == FALSE)) {
    902. 

  902.               echo " ... "; 
    903. 

  903.               $GUIL2 = TRUE;
    904. 

  904.             }
    905. 

  905.             // suspension points writed
    906. 

  906.           }
    907. 

  907.         }
    908. 

  908.       }
    909. 

  909.     }
    910. 

  910.   }
    911. 

  911. }
    912. 

  912. 

  913. /**
    914. 

  914.  * Get page period taken in statpress-visitors
    915. 

  915.  */
    916. 

  916. function newstatpress_page_periode() { 
    917. 

  917.   // pp is the display page periode 
    918. 

  918.   if(isset($_GET['pp'])) { 
    919. 

  919.     // Get Current page periode from URL
    920. 

  920.     $periode = $_GET['pp'];
    921. 

  921.     if($periode <= 0)
    922. 

  922.       // Periode is less than 0 then set it to 1
    923. 

  923.       $periode = 1;
    924. 

  924.   } else
    925. 

  925.       // URL does not show the page set it to 1
    926. 

  926.       $periode = 1;
    927. 

  927.   return $periode;
    928. 

  928. }
    929. 

  929. 

  930. /**
    931. 

  931.  * Get page post taken in statprss-visitors
    932. 

  932.  */
    933. 

  933. function newstatpress_page_posts() {
    934. 

  934.   global $wpdb;
    935. 

  935.   // pa is the display pages Articles
    936. 

  936.   if(isset($_GET['pa'])) {
    937. 

  937.     // Get Current page Articles from URL 
    938. 

  938.     $pageA = $_GET['pa']; 
    939. 

  939.     if($pageA <= 0) 
    940. 

  940.       // Article is less than 0 then set it to 1
    941. 

  941.       $pageA = 1;
    942. 

  942.   } else  
    943. 

  943.       // URL does not show the Article set it to 1
    944. 

  944.       $pageA = 1;
    945. 

  945.   return $pageA;
    946. 

  946. }
    947. 

  947. 

  948. /**
    949. 

  949.  * New spy function taken in statpress-visitors
    950. 

  950.  */
    951. 

  951. function iriNewStatPressNewSpy() {
    952. 

  952.   global $wpdb;
    953. 

  953.   $action="newspy";
    954. 

  954.   $table_name = $wpdb->prefix . "statpress";
    955. 

  955.  
    956. 

  956.   // number of IP or bot by page
    957. 

  957.   $LIMIT = get_option('newstatpress_ip_per_page_newspy');
    958. 

  958.   $LIMIT_PROOF = get_option('newstatpress_visits_per_ip_newspy');
    959. 

  959.   if ($LIMIT == 0) $LIMIT = 20;
    960. 

  960.   if ($LIMIT_PROOF == 0) $LIMIT_PROOF = 20;
    961. 

  961. 

  962.   $pp = newstatpress_page_periode();
    963. 

  963. 

  964.   // Number of distinct ip (unique visitors)
    965. 

  965.   $NumIP = $wpdb->get_var("
    966. 

  966.     SELECT count(distinct ip) 
    967. 

  967.     FROM $table_name 
    968. 

  968.     WHERE spider=''"
    969. 

  969.   );
    970. 

  970.   $NP = ceil($NumIP/$LIMIT);
    971. 

  971.   $LimitValue = ($pp * $LIMIT) - $LIMIT;
    972. 

  972.         
    973. 

  973.   $sql = "
    974. 

  974.     SELECT *
    975. 

  975.     FROM $table_name as T1
    976. 

  976.     JOIN
    977. 

  977.       (SELECT max(id) as MaxId,min(id) as MinId,ip, nation 
    978. 

  978.        FROM $table_name 
    979. 

  979.        WHERE spider='' 
    980. 

  980.        GROUP BY ip 
    981. 

  981.        ORDER BY MaxId 
    982. 

  982.        DESC LIMIT $LimitValue, $LIMIT ) as T2
    983. 

  983.     ON T1.ip = T2.ip 
    984. 

  984.     WHERE id BETWEEN MinId AND MaxId
    985. 

  985.     ORDER BY MaxId DESC, id DESC
    986. 

  986.   ";
    987. 

    988. 

  988.   $qry = $wpdb->get_results($sql);
    989. 

  989. 

  990.   echo "<div class='wrap'><h2>" . __('Visitor Spy', 'newstatpress') . "</h2>";
    991. 

  991. ?>
    992. 

  992. <script>
    993. 

  993. function ttogle(thediv){
    994. 

  994. if (document.getElementById(thediv).style.display=="inline") {
    995. 

  995. document.getElementById(thediv).style.display="none"
    996. 

  996. } else {document.getElementById(thediv).style.display="inline"}
    997. 

  997. }
    998. 

  998. </script>
    999. 

  999. <?php    
    1000. 

  1000.   $ip = 0;
    1001. 

  1001.   $num_row=0;
    1002. 

  1002.   echo'<div id="paginating" align="center">';
    1003. 

  1003.   newstatpress_print_pp_link($NP,$pp,$action);
    1004. 

  1004.   echo'</div><table id="mainspytab" name="mainspytab" width="99%" border="0" cellspacing="0" cellpadding="4">';    
    1005. 

  1005.   foreach ($qry as $rk) {
    1006. 

  1006.     // Visitor Spy
    1007. 

  1007.     if ($ip <> $rk->ip) { 
    1008. 

  1008.       //this is the first time these ip appear, print informations
    1009. 

  1009.       echo "<tr><td colspan='2' bgcolor='#dedede'><div align='left'>";  
    1010. 

  1010.       $title='';
    1011. 

  1011.       $id ='';
    1012. 

  1012.       ///if ($rk->country <> '') { 
    1013. 

  1013.       ///  $img=strtolower($rk->country).".png"; 
    1014. 

  1014.       ///  $lines = file(ABSPATH.'wp-content/plugins/'.dirname(dirname(dirname(plugin_basename(__FILE__)))) .'/def/domain.dat');
    1015. 

  1015.       ///  foreach($lines as $line_num => $country) { 
    1016. 

  1016.       ///    list($id,$title)=explode("|",$country);
    1017. 

  1017.       ///    if($id===strtolower($rk->country)) break;
    1018. 

  1018.       ///  }  
    1019. 

  1019.       ///  echo "http country <IMG style='border:0px;height:16px;' alt='".$title."' title='".$title."' SRC='" .plugins_url('newstatpress/images/domain/'.$img, dirname(dirname(dirname(__FILE__)))). "'>  ";
    1020. 

  1020.       ///} else
    1021. 

  1021.         if($rk->nation <> '') { 
    1022. 

  1022.           // the nation exist
    1023. 

  1023.           $img=strtolower($rk->nation).".png"; 
    1024. 

  1024.           $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/domain.dat');
    1025. 

  1025.           foreach($lines as $line_num => $nation) { 
    1026. 

  1026.             list($id,$title)=explode("|",$nation);
    1027. 

  1027.             if($id===$rk->nation) break;
    1028. 

  1028.           }  
    1029. 

  1029.           print "".__('Http domain', 'newstatpress')." <IMG style='border:0px;height:16px;' alt='".$title."' title='".$title."' SRC='" .plugins_url('newstatpress/images/domain/'.$img, dirname(plugin_basename(__FILE__))). "'>  ";
    1030. 

  1030. 

  1031.         } else {
    1032. 

  1032.             $ch = curl_init('http://api.hostip.info/country.php?ip='.$rk->ip);
    1033. 

  1033.             curl_setopt($ch, CURLOPT_HEADER, 0);
    1034. 

  1034.             curl_setopt($ch, CURLOPT_POST, 1);
    1035. 

  1035.             curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    1036. 

  1036.             $output = curl_exec($ch); 
    1037. 

  1037.             $output .=".png";
    1038. 

  1038.             $output = strtolower($output);
    1039. 

  1039.             curl_close($ch);
    1040. 

  1040.             print "".__('Hostip country','newstatpress'). "<IMG style='border:0px;width:18;height:12px;' alt='".$title."' title='".$title."' SRC='" .plugins_url('newstatpress/images/domain/'.$output, dirname(plugin_basename(__FILE__))). "'>  ";
    1041. 

  1041.       }
    1042. 

  1042. 

  1043.         print "<strong><span><font size='2' color='#7b7b7b'>".$rk->ip."</font></span></strong> ";
    1044. 

  1044.         print "<span style='color:#006dca;cursor:pointer;border-bottom:1px dotted #AFD5F9;font-size:8pt;' onClick=ttogle('".$rk->ip."');>".__('more info','newstatpress')."</span></div>";
    1045. 

  1045.         print "<div id='".$rk->ip."' name='".$rk->ip."'>";
    1046. 

  1046. 

  1047.         if(get_option('newstatpress_cryptip')!='checked') {
    1048. 

  1048.           print "<br><iframe style='overflow:hidden;border:0px;width:100%;height:60px;font-family:helvetica;padding:0;' scrolling='no' marginwidth=0 marginheight=0 src=http://api.hostip.info/get_html.php?ip=".$rk->ip."></iframe>";
    1049. 

  1049.         }
    1050. 

  1050.         print "<br><small><span style='font-weight:700;'>OS or device:</span> ".$rk->os."</small>";
    1051. 

  1051.         print "<br><small><span style='font-weight:700;'>DNS Name:</span> ".gethostbyaddr($rk->ip)."</small>";
    1052. 

  1052.         print "<br><small><span style='font-weight:700;'>Browser:</span> ".$rk->browser."</small>";
    1053. 

  1053.         print "<br><small><span style='font-weight:700;'>Browser Detail:</span> ".$rk->agent."</small>";
    1054. 

  1054.         print "<br><br></div>";
    1055. 

  1055.         print "<script>document.getElementById('".$rk->ip."').style.display='none';</script>";
    1056. 

  1056.         print "</td></tr>";  
    1057. 

  1057. 

  1058. 

  1059.         echo "<td valign='top' width='151'><div><font size='1' color='#3B3B3B'><strong>" . newstatpress_hdate($rk->date) . " " . $rk->time . "</strong></font></div></td>
    1060. 

  1060.               <td>" . newstatpress_Decode($rk->urlrequested) ."";
    1061. 

  1061.         if ($rk->searchengine != '') print "<br><small>".__('arrived from','newstatpress')." <b>" . $rk->searchengine . "</b> ".__('searching','newstatpress')." <a href='" . $rk->referrer . "' target=_blank>" . urldecode($rk->search) . "</a></small>";
    1062. 

  1062.         elseif ($rk->referrer != '' && strpos($rk->referrer, get_option('home')) === false) print "<br><small>".__('arrived from','newstatpress')." <a href='" . $rk->referrer . "' target=_blank>" . $rk->referrer . "</a></small>";
    1063. 

  1063.         echo "</div></td></tr>\n";
    1064. 

  1064.         $ip=$rk->ip;
    1065. 

  1065.         $num_row = 1;
    1066. 

  1066.     } elseif ($num_row < $LIMIT_PROOF) { 
    1067. 

  1067.         echo "<tr><td valign='top' width='151'><div><font size='1' color='#3B3B3B'><strong>" . newstatpress_hdate($rk->date) . " " . $rk->time . "</strong></font></div></td>
    1068. 

  1068.               <td><div>" . newstatpress_Decode($rk->urlrequested) . "";
    1069. 

  1069.         if ($rk->searchengine != '') print "<br><small>".__('arrived from','newstatpress')." <b>" . $rk->searchengine . "</b> ".__('searching','newstatpress')." <a href='" . $rk->referrer . "' target=_blank>" . urldecode($rk->search) . "</a></small>";
    1070. 

  1070.         elseif ($rk->referrer != '' && strpos($rk->referrer, get_option('home')) === false) print "<br><small>".__('arrived from','newstatpress')." <a href='" . $rk->referrer . "' target=_blank>" . $rk->referrer . "</a></small>";
    1071. 

  1071.         $num_row += 1;
    1072. 

  1072.         echo "</div></td></tr>\n";
    1073. 

  1073.       }
    1074. 

  1074.    }
    1075. 

  1075.    echo "</div></td></tr>\n</table>";   
    1076. 

  1076.    newstatpress_print_pp_link($NP,$pp,$action);
    1077. 

  1077.    echo "</div>";
    1078. 

  1078. } 
    1079. 

  1079. 

  1080. /**
    1081. 

  1081.  * New spy bot function taken in statpress-visitors
    1082. 

  1082.  */
    1083. 

  1083. function iriNewStatPressSpyBot() {
    1084. 

  1084.   global $wpdb;
    1085. 

  1085. 

  1086.   $action="spybot";
    1087. 

  1087.   $table_name = $wpdb->prefix . "statpress";
    1088. 

  1088.  
    1089. 

  1089.   $LIMIT = get_option('newstatpress_bot_per_page_spybot');
    1090. 

  1090.   $LIMIT_PROOF = get_option('newstatpress_visits_per_bot_spybot');
    1091. 

  1091. 

  1092.   if ($LIMIT ==0) $LIMIT = 10;
    1093. 

  1093.   if ($LIMIT_PROOF == 0) $LIMIT_PROOF = 30;
    1094. 

  1094. 

  1095.   $pa = newstatpress_page_posts();
    1096. 

  1096.   $LimitValue = ($pa * $LIMIT) - $LIMIT;
    1097. 

  1097. 

  1098.   // limit the search 7 days ago
    1099. 

  1099.   $day_ago = gmdate('Ymd', current_time('timestamp') - 7*86400);	   
    1100. 

  1100.   $MinId = $wpdb->get_var("
    1101. 

  1101.     SELECT min(id) as MinId 
    1102. 

  1102.     FROM $table_name 
    1103. 

  1103.     WHERE date > $day_ago
    1104. 

  1104.   ");
    1105. 

    1106. 

  1106.   // Number of distinct spiders after $day_ago
    1107. 

  1107.   $Num = $wpdb->get_var("
    1108. 

  1108.     SELECT count(distinct spider) 
    1109. 

  1109.     FROM $table_name 
    1110. 

  1110.     WHERE 
    1111. 

  1111.       spider<>'' AND 
    1112. 

  1112.       id >$MinId
    1113. 

  1113.   ");
    1114. 

  1114.   $NA = ceil($Num/$LIMIT);
    1115. 

  1115. 

  1116.   echo "<div class='wrap'><h2>" . __('Spy Bot', 'newstatpress') . "</h2>";
    1117. 

  1117. 

  1118.   // selection of spider, group by spider, order by most recently visit (last id in the table)
    1119. 

  1119.   $sql = "
    1120. 

  1120.     SELECT *
    1121. 

  1121.     FROM $table_name as T1
    1122. 

  1122.     JOIN
    1123. 

  1123.     (SELECT spider,max(id) as MaxId 
    1124. 

  1124.      FROM $table_name 
    1125. 

  1125.      WHERE spider<>'' 
    1126. 

  1126.      GROUP BY spider 
    1127. 

  1127.      ORDER BY MaxId 
    1128. 

  1128.      DESC LIMIT $LimitValue, $LIMIT 
    1129. 

  1129.     ) as T2
    1130. 

  1130.     ON T1.spider = T2.spider
    1131. 

  1131.     WHERE T1.id > $MinId
    1132. 

  1132.     ORDER BY MaxId DESC, id DESC
    1133. 

  1133.   ";
    1134. 

  1134.   $qry = $wpdb->get_results($sql);
    1135. 

  1135. 

  1136.   echo '<div align="center">';
    1137. 

  1137.   newstatpress_print_pp_pa_link (0,0,$action,$NA,$pa);
    1138. 

  1138.   echo '</div><div align="left">';
    1139. 

  1139. ?>
    1140. 

  1140. <script>
    1141. 

  1141. function ttogle(thediv){
    1142. 

  1142. if (document.getElementById(thediv).style.display=="inline") {
    1143. 

  1143. document.getElementById(thediv).style.display="none"
    1144. 

  1144. } else {document.getElementById(thediv).style.display="inline"}
    1145. 

  1145. }
    1146. 

  1146. </script>
    1147. 

  1147. <table id="mainspytab" name="mainspytab" width="99%" border="0" cellspacing="0" cellpadding="4"><div align='left'>
    1148. 

  1148. <?php        
    1149. 

  1149.   $spider="robot";
    1150. 

  1150.   $num_row=0;
    1151. 

  1151.   foreach ($qry as $rk) {  // Bot Spy
    1152. 

  1152.     if ($robot <> $rk->spider) {
    1153. 

  1153.       echo "<div align='left'>
    1154. 

  1154.             <tr>
    1155. 

  1155.             <td colspan='2' bgcolor='#dedede'>";
    1156. 

  1156.       $img=str_replace(" ","_",strtolower($rk->spider));
    1157. 

  1157.       $img=str_replace('.','',$img).".png";
    1158. 

  1158.       $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/spider.dat');
    1159. 

  1159.       foreach($lines as $line_num => $spider) { //seeks the tooltip corresponding to the photo
    1160. 

  1160.         list($title,$id)=explode("|",$spider);
    1161. 

  1161.         if($title==$rk->spider) break; // break, the tooltip ($title) is found
    1162. 

  1162.       }
    1163. 

  1163.       echo "<IMG style='border:0px;height:16px;align:left;' alt='".$title."' title='".$title."' SRC='" .plugins_url('newstatpress/images/spider/'.$img, dirname(plugin_basename(__FILE__))). "'>
    1164. 

  1164.             <span style='color:#006dca;cursor:pointer;border-bottom:1px dotted #AFD5F9;font-size:8pt;' onClick=ttogle('" . $img . "');>http more info</span>
    1165. 

  1165.             <div id='" . $img . "' name='" . $img . "'><br /><small>" . $rk->ip . "</small><br><small>" . $rk->agent . "<br /></small></div>
    1166. 

  1166.             <script>document.getElementById('" . $img . "').style.display='none';</script>
    1167. 

  1167.             </tr>
    1168. 

  1168.             <tr><td valign='top' width='170'><div><font size='1' color='#3B3B3B'><strong>" . newstatpress_hdate($rk->date) . " " . $rk->time . "</strong></font></div></td>
    1169. 

  1169.             <td><div>" . newstatpress_Decode($rk->urlrequested) . "</div></td></tr>";
    1170. 

  1170.       $robot=$rk->spider;
    1171. 

  1171.       $num_row=1;
    1172. 

  1172.     } elseif ($num_row < $LIMIT_PROOF) {
    1173. 

  1173.         echo "<tr>
    1174. 

  1174.               <td valign='top' width='170'><div><font size='1' color='#3B3B3B'><strong>" . newstatpress_hdate($rk->date) . " " . $rk->time . "</strong></font></div></td>
    1175. 

  1175.               <td><div>" . newstatpress_Decode($rk->urlrequested) . "</div></td></tr>";
    1176. 

  1176.         $num_row+=1;
    1177. 

  1177.       }
    1178. 

  1178.       echo "</div></td></tr>\n";
    1179. 

  1179.   }
    1180. 

  1180.   echo "</table>"; 
    1181. 

  1181.   newstatpress_print_pp_pa_link (0,0,$action,$NA,$pa);
    1182. 

  1182.   echo "</div>";
    1183. 

  1183. }
    1184. 

  1184. 

  1185. /**
    1186. 

  1186.  * Newstatpress spy function
    1187. 

  1187.  */
    1188. 

  1188. function iriNewStatPressSpy() {
    1189. 

  1189.   global $wpdb;
    1190. 

  1190.   $table_name = $wpdb->prefix . "statpress";
    1191. 

  1191. 

  1192.   # Spy
    1193. 

  1193.   $today = gmdate('Ymd', current_time('timestamp'));
    1194. 

  1194.   $yesterday = gmdate('Ymd', current_time('timestamp')-86400);
    1195. 

  1195.   print "<div class='wrap'><h2>".__('Spy','newstatpress')."</h2>";
    1196. 

  1196.   $sql="
    1197. 

  1197.     SELECT ip,nation,os,browser,agent 
    1198. 

  1198.     FROM $table_name 
    1199. 

  1199.     WHERE 
    1200. 

  1200.       spider='' AND 
    1201. 

  1201.       feed='' AND 
    1202. 

  1202.       date BETWEEN '$yesterday' AND '$today' 
    1203. 

  1203.     GROUP BY ip ORDER BY id DESC LIMIT 20";
    1204. 

  1204.   $qry = $wpdb->get_results($sql);
    1205. 

  1205. 

  1206. ?>
    1207. 

  1207. <script>
    1208. 

  1208. function ttogle(thediv){
    1209. 

  1209. if (document.getElementById(thediv).style.display=="inline") {
    1210. 

  1210. document.getElementById(thediv).style.display="none"
    1211. 

  1211. } else {document.getElementById(thediv).style.display="inline"}
    1212. 

  1212. }
    1213. 

  1213. </script>
    1214. 

  1214. <div>
    1215. 

  1215. <table id="mainspytab" name="mainspytab" width="99%" border="0" cellspacing="0" cellpadding="4">
    1216. 

  1216. <?php
    1217. 

  1217.   foreach ($qry as $rk) {
    1218. 

  1218.     print "<tr><td colspan='2' bgcolor='#dedede'><div align='left'>";
    1219. 

  1219. 

  1220.     if($rk->nation <> '') { 
    1221. 

  1221.       // the nation exist
    1222. 

  1222.       $img=strtolower($rk->nation).".png"; 
    1223. 

  1223.       $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/domain.dat');
    1224. 

  1224.       foreach($lines as $line_num => $nation) { 
    1225. 

  1225.         list($id,$title)=explode("|",$nation);
    1226. 

  1226.         if($id===$rk->nation) break;
    1227. 

  1227.       }  
    1228. 

  1228.       echo "<IMG style='border:0px;height:16px;' alt='".$title."' title='".$title."' SRC='" .plugins_url('newstatpress/images/domain/'.$img, dirname(plugin_basename(__FILE__))). "'>  ";
    1229. 

  1229.     } else {
    1230. 

  1230.         $ch = curl_init('http://api.hostip.info/country.php?ip='.$rk->ip);
    1231. 

  1231.         curl_setopt($ch, CURLOPT_HEADER, 0);
    1232. 

  1232.         curl_setopt($ch, CURLOPT_POST, 1);
    1233. 

  1233.         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    1234. 

  1234.         $output = curl_exec($ch); 
    1235. 

  1235.         $output .=".png";
    1236. 

  1236.         $output = strtolower($output);
    1237. 

  1237.         curl_close($ch);
    1238. 

  1238.         echo "<IMG style='border:0px;width:18;height:12px;' alt='".$title."' title='".$title."' SRC='" .plugins_url('newstatpress/images/domain/'.$output, dirname(plugin_basename(__FILE__))). "'>  "; 
    1239. 

  1239.       }
    1240. 

  1240. 

  1241.     
    1242. 

  1242.     print " <strong><span><font size='2' color='#7b7b7b'>".$rk->ip."</font></span></strong> ";
    1243. 

  1243.     print "<span style='color:#006dca;cursor:pointer;border-bottom:1px dotted #AFD5F9;font-size:8pt;' onClick=ttogle('".$rk->ip."');>".__('more info','newstatpress')."</span></div>";
    1244. 

  1244.     print "<div id='".$rk->ip."' name='".$rk->ip."'>";
    1245. 

  1245.     if(get_option('newstatpress_cryptip')!='checked') {
    1246. 

  1246.       print "<br><iframe style='overflow:hidden;border:0px;width:100%;height:60px;font-family:helvetica;padding:0;' scrolling='no' marginwidth=0 marginheight=0 src=http://api.hostip.info/get_html.php?ip=".$rk->ip."></iframe>";
    1247. 

  1247.     }
    1248. 

  1248.     print "<br><small><span style='font-weight:700;'>OS or device:</span> ".$rk->os."</small>";
    1249. 

  1249.     print "<br><small><span style='font-weight:700;'>DNS Name:</span> ".gethostbyaddr($rk->ip)."</small>";
    1250. 

  1250.     print "<br><small><span style='font-weight:700;'>Browser:</span> ".$rk->browser."</small>";
    1251. 

  1251.     print "<br><small><span style='font-weight:700;'>Browser Detail:</span> ".$rk->agent."</small>";
    1252. 

  1252.     print "<br><br></div>";
    1253. 

  1253.     print "<script>document.getElementById('".$rk->ip."').style.display='none';</script>";
    1254. 

  1254.     print "</td></tr>";
    1255. 

  1255.     $qry2=$wpdb->get_results("
    1256. 

  1256.       SELECT * 
    1257. 

  1257.       FROM $table_name 
    1258. 

  1258.       WHERE 
    1259. 

  1259.         ip='".$rk->ip."' AND 
    1260. 

  1260.         (date BETWEEN '$yesterday' AND '$today') 
    1261. 

  1261.       ORDER BY id 
    1262. 

  1262.       LIMIT 10"
    1263. 

  1263.     );
    1264. 

  1264.     foreach ($qry2 as $details) {
    1265. 

  1265.       print "<tr>";
    1266. 

  1266.       print "<td valign='top' width='151'><div><font size='1' color='#3B3B3B'><strong>".irihdate($details->date)." ".$details->time."</strong></font></div></td>";
    1267. 

  1267.       print "<td><div><a href='".get_bloginfo('url')."/?".$details->urlrequested."' target='_blank'>".iri_NewStatPress_Decode($details->urlrequested)."</a>";
    1268. 

  1268.       if($details->searchengine != '') {
    1269. 

  1269.         print "<br><small>".__('arrived from','newstatpress')." <b>".$details->searchengine."</b> ".__('searching','newstatpress')." <a href='".$details->referrer."' target='_blank'>".$details->search."</a></small>";
    1270. 

  1270.       } elseif($details->referrer != '' && strpos($details->referrer,get_option('home'))===FALSE) {
    1271. 

  1271.           print "<br><small>".__('arrived from','newstatpress')." <a href='".$details->referrer."' target='_blank'>".$details->referrer."</a></small>";
    1272. 

  1272.         }
    1273. 

  1273.       print "</div></td>";
    1274. 

  1274.       print "</tr>\n";
    1275. 

  1275.     }
    1276. 

  1276.   }
    1277. 

  1277. ?>
    1278. 

  1278. </table>
    1279. 

  1279. </div>
    1280. 

  1280. <?php
    1281. 

  1281. }
    1282. 

  1282. 

  1283. 

  1284. /**
    1285. 

  1285.  * Check if the argoument is an IP addresses
    1286. 

  1286.  * 
    1287. 

  1287.  * @param ip the ip to check
    1288. 

  1288.  * @return TRUE if it is an ip
    1289. 

  1289.  */
    1290. 

  1290. function iri_CheckIP($ip) {
    1291. 

  1291.   return ( ! preg_match( "/^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$/", $ip)) ? FALSE : TRUE;
    1292. 

  1292. }
    1293. 

  1293. 

  1294. function iriNewStatPressSearch($what='') {
    1295. 

  1295.   global $wpdb;
    1296. 

  1296.   $table_name = $wpdb->prefix . "statpress";
    1297. 

  1297. 

  1298.   $f['urlrequested']=__('URL Requested','newstatpress');
    1299. 

  1299.   $f['agent']=__('Agent','newstatpress');
    1300. 

  1300.   $f['referrer']=__('Referrer','newstatpress');
    1301. 

  1301.   $f['search']=__('Search terms','newstatpress');
    1302. 

  1302.   $f['searchengine']=__('Search engine','newstatpress');
    1303. 

  1303.   $f['os']=__('Operative system','newstatpress');	
    1304. 

  1304.   $f['browser']="Browser";
    1305. 

  1305.   $f['spider']="Spider";
    1306. 

  1306.   $f['ip']="IP";
    1307. 

  1307. ?>
    1308. 

  1308.   <div class='wrap'><h2><?php _e('Search','newstatpress'); ?></h2>
    1309. 

  1309.   <form method=get><table>
    1310. 

  1310.   <?php
    1311. 

  1311.     for($i=1;$i<=3;$i++) {
    1312. 

  1312.       print "<tr>";
    1313. 

  1313.       print "<td>".__('Field','newstatpress')." <select name=where$i><option value=''></option>";
    1314. 

  1314.       foreach ( array_keys($f) as $k ) {
    1315. 

  1315.         print "<option value='$k'";
    1316. 

  1316.         if($_GET["where$i"] == $k) { print " SELECTED "; }
    1317. 

  1317.         print ">".$f[$k]."</option>";
    1318. 

  1318.       }
    1319. 

  1319.       print "</select></td>";
    1320. 

  1320.       if (isset($_GET["groupby$i"])) print "<td><input type=checkbox name=groupby$i value='checked' ".$_GET["groupby$i"]."> ".__('Group by','newstatpress')."</td>";
    1321. 

  1321.       else print "<td><input type=checkbox name=groupby$i value='checked' "."> ".__('Group by','newstatpress')."</td>";
    1322. 

  1322. 

  1323.       if (isset($_GET["sortby$i"])) print "<td><input type=checkbox name=sortby$i value='checked' ".$_GET["sortby$i"]."> ".__('Sort by','newstatpress')."</td>";
    1324. 

  1324.       else print "<td><input type=checkbox name=sortby$i value='checked' "."> ".__('Sort by','newstatpress')."</td>";
    1325. 

  1325. 

  1326.       print "<td>, ".__('if contains','newstatpress')." <input type=text name=what$i value='".$_GET["what$i"]."'></td>";
    1327. 

  1327.       print "</tr>";
    1328. 

  1328.     }
    1329. 

  1329. ?>
    1330. 

  1330.   </table>
    1331. 

  1331.   <br>
    1332. 

  1332.   <table>
    1333. 

  1333.    <tr>
    1334. 

  1334.      <td>
    1335. 

  1335.        <table>
    1336. 

  1336.          <tr><td><input type=checkbox name=oderbycount value=checked <?php print $_GET['oderbycount'] ?>> <?php _e('sort by count if grouped','newstatpress'); ?></td></tr>
    1337. 

  1337.          <tr><td><input type=checkbox name=spider value=checked <?php print $_GET['spider'] ?>> <?php _e('include spiders/crawlers/bot','newstatpress'); ?></td></tr>
    1338. 

  1338.          <tr><td><input type=checkbox name=feed value=checked <?php print $_GET['feed'] ?>> <?php _e('include feed','newstatpress'); ?></td></tr>
    1339. 

  1339.        </table>
    1340. 

  1340.      </td>
    1341. 

  1341.      <td width=15> </td>
    1342. 

  1342.      <td>
    1343. 

  1343.        <table>
    1344. 

  1344.          <tr>
    1345. 

  1345.            <td><?php _e('Limit results to','newstatpress'); ?>
    1346. 

  1346.              <select name=limitquery><?php if($_GET['limitquery'] >0) { print "<option>".$_GET['limitquery']."</option>";} ?><option>1</option><option>5</option><option>10</option><option>20</option><option>50</option></select>
    1347. 

  1347.            </td>
    1348. 

  1348.          </tr>
    1349. 

  1349.          <tr><td>&nbsp;</td></tr>
    1350. 

  1350.          <tr>
    1351. 

  1351.           <td align=right><input type=submit value=<?php _e('Search','newstatpress'); ?> name=searchsubmit></td>
    1352. 

  1352.          </tr>
    1353. 

  1353.        </table>
    1354. 

  1354.      </td>
    1355. 

  1355.     </tr>		
    1356. 

  1356.    </table>	
    1357. 

  1357.    <input type=hidden name=page value='newstatpress/newstatpress.php'><input type=hidden name=newstatpress_action value=search>
    1358. 

  1358.   </form><br>
    1359. 

  1359. <?php
    1360. 

  1360. 

  1361.  if(isset($_GET['searchsubmit'])) {
    1362. 

  1362.    # query builder
    1363. 

  1363.    $qry="";
    1364. 

  1364.    # FIELDS
    1365. 

  1365.    $fields="";
    1366. 

  1366.    for($i=1;$i<=3;$i++) {
    1367. 

  1367.      if($_GET["where$i"] != '') {
    1368. 

  1368.        $fields.=$_GET["where$i"].",";
    1369. 

  1369.      }
    1370. 

  1370.    }
    1371. 

  1371.    $fields=rtrim($fields,",");
    1372. 

  1372.    # WHERE
    1373. 

  1373.    $where="WHERE 1=1";
    1374. 

  1374. 

  1375.    if (!isset($_GET['spider'])) { $where.=" AND spider=''"; }
    1376. 

  1376.    else if($_GET['spider'] != 'checked') { $where.=" AND spider=''"; }
    1377. 

  1377. 

  1378.    if (!isset($_GET['feed'])) { $where.=" AND feed=''"; }
    1379. 

  1379.    else if($_GET['feed'] != 'checked') { $where.=" AND feed=''"; }
    1380. 

  1380. 

  1381.    for($i=1;$i<=3;$i++) {
    1382. 

  1382.      if(($_GET["what$i"] != '') && ($_GET["where$i"] != '')) {
    1383. 

  1383.        $where.=" AND ".$_GET["where$i"]." LIKE '%".$_GET["what$i"]."%'";
    1384. 

  1384.      }
    1385. 

  1385.    }
    1386. 

  1386.    # ORDER BY
    1387. 

  1387.    $orderby="";
    1388. 

  1388.    for($i=1;$i<=3;$i++) {
    1389. 

  1389.      if (isset($_GET["sortby$i"]) && ($_GET["sortby$i"] == 'checked') && ($_GET["where$i"] != '')) {
    1390. 

  1390.        $orderby.=$_GET["where$i"].',';
    1391. 

  1391.      }
    1392. 

  1392.    }
    1393. 

  1393. 

  1394.    # GROUP BY
    1395. 

  1395.    $groupby="";
    1396. 

  1396.    for($i=1;$i<=3;$i++) {
    1397. 

  1397.      if(isset($_GET["groupby$i"]) && ($_GET["groupby$i"] == 'checked') && ($_GET["where$i"] != '')) {
    1398. 

  1398.        $groupby.=$_GET["where$i"].',';
    1399. 

  1399.      }
    1400. 

  1400.    }
    1401. 

  1401.    if($groupby != '') {
    1402. 

  1402.      $groupby="GROUP BY ".rtrim($groupby,',');
    1403. 

  1403.      $fields.=",count(*) as totale";
    1404. 

  1404.      if(isset($_GET["oderbycount"]) && $_GET['oderbycount'] == 'checked') { $orderby="totale DESC,".$orderby; }
    1405. 

  1405.    }
    1406. 

  1406. 

  1407.    if($orderby != '') { $orderby="ORDER BY ".rtrim($orderby,','); }
    1408. 

  1408.  
    1409. 

  1409.    $limit="LIMIT ".$_GET['limitquery'];
    1410. 

  1410. 

  1411.    # Results
    1412. 

  1412.    print "<h2>".__('Results','newstatpress')."</h2>";
    1413. 

  1413.    $sql="SELECT $fields FROM $table_name $where $groupby $orderby $limit;";
    1414. 

  1414.    //print "$sql<br>";
    1415. 

  1415.    print "<table class='widefat'><thead><tr>";
    1416. 

  1416.    for($i=1;$i<=3;$i++) { 
    1417. 

  1417.      if($_GET["where$i"] != '') { print "<th scope='col'>".ucfirst($_GET["where$i"])."</th>"; }
    1418. 

  1418.    }
    1419. 

  1419.    if($groupby != '') { print "<th scope='col'>".__('Count','newstatpress')."</th>"; }
    1420. 

  1420.      print "</tr></thead><tbody id='the-list'>";	
    1421. 

  1421.      $qry=$wpdb->get_results($sql,ARRAY_N);
    1422. 

  1422.      foreach ($qry as $rk) {
    1423. 

  1423.        print "<tr>";
    1424. 

  1424.        for($i=1;$i<=3;$i++) {
    1425. 

  1425.          print "<td>";
    1426. 

  1426.          if($_GET["where$i"] == 'urlrequested') { print iri_NewStatPress_Decode($rk[$i-1]); }
    1427. 

  1427.          else { if(isset($rk[$i-1])) print $rk[$i-1]; }
    1428. 

  1428.          print "</td>";
    1429. 

  1429.        }
    1430. 

  1430.          print "</tr>";
    1431. 

  1431.      }
    1432. 

  1432.      print "</table>";
    1433. 

  1433.      print "<br /><br /><font size=1 color=gray>sql: $sql</font></div>";
    1434. 

  1434.   }
    1435. 

  1435. }
    1436. 

  1436. 

  1437. function iri_NewStatPress_Abbrevia($s,$c) {
    1438. 

  1438. 	$res=""; if(strlen($s)>$c) { $res="..."; }
    1439. 

  1439. 	return substr($s,0,$c).$res;
    1440. 

  1440. 	
    1441. 

  1441. }
    1442. 

  1442. 

  1443. 

  1444. function iri_NewStatPress_Decode($out_url) {
    1445. 

  1445. 	if($out_url == '') { $out_url=__('Page','newstatpress').": Home"; }
    1446. 

  1446. 	if(substr($out_url,0,4)=="cat=") { $out_url=__('Category','newstatpress').": ".get_cat_name(substr($out_url,4)); }
    1447. 

  1447. 	if(substr($out_url,0,2)=="m=") { $out_url=__('Calendar','newstatpress').": ".substr($out_url,6,2)."/".substr($out_url,2,4); }
    1448. 

  1448. 	if(substr($out_url,0,2)=="s=") { $out_url=__('Search','newstatpress').": ".substr($out_url,2); }
    1449. 

  1449. 	if(substr($out_url,0,2)=="p=") {
    1450. 

  1450. 		$post_id_7 = get_post(substr($out_url,2), ARRAY_A);
    1451. 

  1451. 		$out_url = $post_id_7['post_title'];
    1452. 

  1452. 	}
    1453. 

  1453. 	if(substr($out_url,0,8)=="page_id=") {
    1454. 

  1454. 		$post_id_7=get_page(substr($out_url,8), ARRAY_A);
    1455. 

  1455. 		$out_url = __('Page','newstatpress').": ".$post_id_7['post_title'];
    1456. 

  1456. 	}
    1457. 

  1457. 	return $out_url;
    1458. 

  1458. }
    1459. 

  1459. 

  1460. 

  1461. function iri_NewStatPress_URL() {
    1462. 

  1462.     $urlRequested = (isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : '' );
    1463. 

  1463. 	if ( $urlRequested == "" ) { // SEO problem!
    1464. 

  1464. 	    $urlRequested = (isset($_SERVER["REQUEST_URI"]) ? $_SERVER["REQUEST_URI"] : '' );
    1465. 

  1465. 	}
    1466. 

  1466. 	if(substr($urlRequested,0,2) == '/?') { $urlRequested=substr($urlRequested,2); }
    1467. 

  1467. 	if($urlRequested == '/') { $urlRequested=''; }
    1468. 

  1468. 	return $urlRequested;
    1469. 

  1469. }
    1470. 

  1470. 

  1471. 

  1472. # Converte da data us to default format di Wordpress
    1473. 

  1473. function irihdate($dt = "00000000") {
    1474. 

  1474. 	return mysql2date(get_option('date_format'), substr($dt,0,4)."-".substr($dt,4,2)."-".substr($dt,6,2));
    1475. 

  1475. }
    1476. 

  1476. 

  1477. 

  1478. function iritablesize($table) {
    1479. 

  1479. 	global $wpdb;
    1480. 

  1480. 	$res = $wpdb->get_results("SHOW TABLE STATUS LIKE '$table'");
    1481. 

  1481. 	foreach ($res as $fstatus) {
    1482. 

  1482. 		$data_lenght = $fstatus->Data_length;
    1483. 

  1483. 		$data_rows = $fstatus->Rows;
    1484. 

  1484. 	}
    1485. 

  1485. 	return number_format(($data_lenght/1024/1024), 2, ",", " ")." Mb ($data_rows records)";
    1486. 

  1486. }
    1487. 

  1487. 

  1488. function iriindextablesize($table) {
    1489. 

  1489. 	global $wpdb;
    1490. 

  1490. 	$res = $wpdb->get_results("SHOW TABLE STATUS LIKE '$table'");
    1491. 

  1491. 	foreach ($res as $fstatus) {
    1492. 

  1492. 		$index_lenght = $fstatus->Index_length;
    1493. 

  1493. 	}
    1494. 

  1494. 	return number_format(($index_lenght/1024/1024), 2, ",", " ")." Mb";
    1495. 

  1495. }
    1496. 

  1496. 

  1497. 

  1498. function iriValueTable2($fld,$fldtitle,$limit = 0,$param = "", $queryfld = "", $exclude= "", $print = TRUE) {
    1499. 

  1499.   global $wpdb;
    1500. 

  1500.   $table_name = $wpdb->prefix . "statpress";
    1501. 

  1501. 

  1502.   if ($queryfld == '') { 
    1503. 

  1503.     $queryfld = $fld; 
    1504. 

  1504.   }
    1505. 

  1505.   $text = "<div class='wrap'><table class='widefat'><thead><tr><th scope='col' style='width:400px;'><h2>$fldtitle</h2></th><th scope='col' style='width:100px;'>".__('Visits','newstatpress')."</th><th></th></tr></thead>";
    1506. 

  1506.   $rks = $wpdb->get_var("
    1507. 

  1507.      SELECT count($param $queryfld) as rks 
    1508. 

  1508.      FROM $table_name 
    1509. 

  1509.      WHERE 1=1 $exclude;
    1510. 

  1510.   "); 
    1511. 

    1512. 

  1512.   if($rks > 0) {
    1513. 

  1513.     $sql="
    1514. 

  1514.       SELECT count($param $queryfld) as pageview, $fld 
    1515. 

  1515.       FROM $table_name 
    1516. 

  1516.       WHERE 1=1 $exclude 
    1517. 

  1517.       GROUP BY $fld 
    1518. 

  1518.       ORDER BY pageview DESC
    1519. 

  1519.     ";
    1520. 

  1520.     if($limit > 0) { 
    1521. 

  1521.       $sql=$sql." LIMIT $limit"; 
    1522. 

  1522.     }
    1523. 

  1523.     $qry = $wpdb->get_results($sql);
    1524. 

  1524.     $tdwidth=450;
    1525. 

  1525. 

  1526.     // Collects data
    1527. 

  1527.     $data=array();
    1528. 

  1528.     foreach ($qry as $rk) {
    1529. 

  1529.       $pc=round(($rk->pageview*100/$rks),1);
    1530. 

  1530.       if($fld == 'nation') { $rk->$fld = strtoupper($rk->$fld); }
    1531. 

  1531.       if($fld == 'date') { $rk->$fld = irihdate($rk->$fld); }
    1532. 

  1532.       if($fld == 'urlrequested') { $rk->$fld = iri_NewStatPress_Decode($rk->$fld); }
    1533. 

  1533.       $data[substr($rk->$fld,0,50)]=$rk->pageview;
    1534. 

  1534.     }
    1535. 

  1535.   }
    1536. 

  1536. 

  1537.   // Draw table body
    1538. 

  1538.   $text = $text."<tbody id='the-list'>";
    1539. 

  1539.   if($rks > 0) {  // Chart!
    1540. 

  1540.     if($fld == 'nation') {
    1541. 

  1541.       $chart=iriGoogleGeo("","",$data);
    1542. 

  1542.     } else {
    1543. 

  1543.         $chart=iriGoogleChart("","500x200",$data);
    1544. 

  1544.       }
    1545. 

  1545.     $text = $text. "<tr><td></td><td></td><td rowspan='".($limit+2)."'>$chart</td></tr>";
    1546. 

  1546.     foreach ($data as $key => $value) {
    1547. 

  1547.       $text = $text."<tr><td style='width:500px;overflow: hidden; white-space: nowrap; text-overflow: ellipsis;'>".$key;
    1548. 

  1548.       $text = $text."</td><td style='width:100px;text-align:center;'>".$value."</td>";
    1549. 

  1549.       $text = $text."</tr>";
    1550. 

  1550.     }
    1551. 

  1551.   }
    1552. 

  1552.   $text = $text."</tbody></table></div><br>\n";
    1553. 

  1553.   if ($print) print $text;
    1554. 

  1554.   else return $text;
    1555. 

  1555. }
    1556. 

  1556. 

  1557. 

  1558. function iriGetLanguage($accepted) {
    1559. 

  1559. 	return substr($accepted,0,2);
    1560. 

  1560. }
    1561. 

  1561. 

  1562. 

  1563. function iriGetQueryPairs($url){
    1564. 

  1564. $parsed_url = parse_url($url);
    1565. 

  1565. $tab=parse_url($url);
    1566. 

  1566. $host = $tab['host'];
    1567. 

  1567. if(key_exists("query",$tab)){
    1568. 

  1568.  $query=$tab["query"];
    1569. 

  1569.  return explode("&",$query);
    1570. 

  1570. }
    1571. 

  1571. else{return null;}
    1572. 

  1572. }
    1573. 

  1573. 

  1574. 

  1575. /**
    1576. 

  1576.  * Get OS from the given argument
    1577. 

  1577.  * 
    1578. 

  1578.  * @param arg the argument to parse for OS
    1579. 

  1579.  * @return the OS find in configuration file
    1580. 

  1580.  */
    1581. 

  1581. function iriGetOS($arg) {
    1582. 

  1582.   $arg=str_replace(" ","",$arg);
    1583. 

  1583.   $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/os.dat');
    1584. 

  1584.   foreach($lines as $line_num => $os) {
    1585. 

  1585.     list($nome_os,$id_os)=explode("|",$os);
    1586. 

  1586.     if(strpos($arg,$id_os)===FALSE) continue;
    1587. 

  1587.     return $nome_os;     // fount
    1588. 

  1588.   }
    1589. 

  1589.   return '';
    1590. 

  1590. }
    1591. 

  1591. 

  1592. /**
    1593. 

  1593.  * Get Browser from the given argument
    1594. 

  1594.  * 
    1595. 

  1595.  * @param arg the argument to parse for Brower
    1596. 

  1596.  * @return the Browser find in configuration file
    1597. 

  1597.  */
    1598. 

  1598. function iriGetBrowser($arg) {
    1599. 

  1599.   $arg=str_replace(" ","",$arg);
    1600. 

  1600.   $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/browser.dat');
    1601. 

  1601.   foreach($lines as $line_num => $browser) {
    1602. 

  1602.     list($nome,$id)=explode("|",$browser);
    1603. 

  1603.     if(strpos($arg,$id)===FALSE) continue;
    1604. 

  1604.     return $nome;     // fount
    1605. 

  1605.   }
    1606. 

  1606.   return '';
    1607. 

  1607. }
    1608. 

  1608. 

  1609. function iriCheckBanIP($arg){
    1610. 

  1610. 	$lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/banips.dat');
    1611. 

  1611. 	foreach($lines as $line_num => $banip) {
    1612. 

  1612. 		if(strpos($arg,rtrim($banip,"\n"))===FALSE) continue;
    1613. 

  1613.     	return ''; // riconosciuto, da scartare
    1614. 

  1614. 	}
    1615. 

  1615.     return $arg;
    1616. 

  1616. }
    1617. 

  1617. 

  1618. function iriGetSE($referrer = null){
    1619. 

  1619. 	$key = null;
    1620. 

  1620. 	$lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/searchengines.dat');
    1621. 

  1621. 	foreach($lines as $line_num => $se) {
    1622. 

  1622. 		list($nome,$url,$key)=explode("|",$se);
    1623. 

  1623. 		if(strpos($referrer,$url)===FALSE) continue;
    1624. 

  1624. 		# trovato se
    1625. 

  1625. 		$variables = iriGetQueryPairs(html_entity_decode($referrer));
    1626. 

  1626. 		$i = count($variables);
    1627. 

  1627. 		while($i--){
    1628. 

  1628. 		   $tab=explode("=",$variables[$i]);
    1629. 

  1629. 			   if($tab[0] == $key){return ($nome."|".urldecode($tab[1]));}
    1630. 

  1630. 		}
    1631. 

  1631. 	}
    1632. 

  1632. 	return null;
    1633. 

  1633. }
    1634. 

  1634. 

  1635. /**
    1636. 

  1636.  * Get the spider from the given agent
    1637. 

  1637.  *
    1638. 

  1638.  * @param agent the agent string
    1639. 

  1639.  * @return agent the fount agent
    1640. 

  1640.  */
    1641. 

  1641. function iriGetSpider($agent = null){
    1642. 

  1642.   $agent=str_replace(" ","",$agent);
    1643. 

  1643.   $key = null;
    1644. 

  1644.   $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/spider.dat');
    1645. 

  1645.   foreach($lines as $line_num => $spider) {
    1646. 

  1646.     list($nome,$key)=explode("|",$spider);
    1647. 

  1647.     if(strpos($agent,$key)===FALSE) continue;
    1648. 

  1648.     # fount
    1649. 

  1649.     return $nome;
    1650. 

  1650.   }
    1651. 

  1651.   return null;
    1652. 

  1652. }
    1653. 

  1653. 

  1654. function iri_NewStatPress_lastmonth() {
    1655. 

  1655.   $ta = getdate(current_time('timestamp'));
    1656. 

  1656.     
    1657. 

  1657.   $year = $ta['year'];
    1658. 

  1658.   $month = $ta['mon'];
    1659. 

  1659.     
    1660. 

  1660.   --$month; // go back 1 month
    1661. 

  1661.     
    1662. 

  1662.   if( $month === 0 ): // if this month is Jan
    1663. 

  1663.     --$year; // go back a year
    1664. 

  1664.     $month = 12; // last month is Dec
    1665. 

  1665.   endif;
    1666. 

  1666.     
    1667. 

  1667.   // return in format 'YYYYMM'
    1668. 

  1668.   return sprintf( $year.'%02d', $month); 
    1669. 

  1669. }
    1670. 

  1670. 

  1671. /**
    1672. 

  1672.  * Create or update the table
    1673. 

  1673.  */
    1674. 

  1674. function iri_NewStatPress_CreateTable() {
    1675. 

  1675.   global $wpdb;
    1676. 

  1676.   global $wp_db_version;
    1677. 

  1677.   $table_name = $wpdb->prefix . "statpress";
    1678. 

  1678.   $sql_createtable = "
    1679. 

  1679.     CREATE TABLE " . $table_name . " (
    1680. 

  1680.       id mediumint(9) NOT NULL AUTO_INCREMENT,
    1681. 

  1681.       date int(8),
    1682. 

  1682.       time time,
    1683. 

  1683.       ip varchar(15),
    1684. 

  1684.       urlrequested varchar(250),
    1685. 

  1685.       agent varchar(250),
    1686. 

  1686.       referrer varchar(250),
    1687. 

  1687.       search varchar(250),
    1688. 

  1688.       nation varchar(2),
    1689. 

  1689.       os varchar(30),
    1690. 

  1690.       browser varchar(32),
    1691. 

  1691.       searchengine varchar(16),
    1692. 

  1692.       spider varchar(32),
    1693. 

  1693.       feed varchar(8),
    1694. 

  1694.       user varchar(16),
    1695. 

  1695.       timestamp timestamp DEFAULT 0,
    1696. 

  1696.       UNIQUE KEY id (id),
    1697. 

  1697.       index spider_nation (spider, nation),  
    1698. 

  1698.       index ip_date (ip, date),  
    1699. 

  1699.       index agent (agent),  
    1700. 

  1700.       index search (search),  
    1701. 

  1701.       index referrer (referrer),  
    1702. 

  1702.       index feed_spider_os (feed, spider, os),  
    1703. 

  1703.       index os (os),  
    1704. 

  1704.       index date_feed_spider (date, feed, spider),  
    1705. 

  1705.       index feed_spider_browser (feed, spider, browser),  
    1706. 

  1706.       index browser (browser)
    1707. 

  1707.     );";
    1708. 

  1708.   if($wp_db_version >= 5540) $page = 'wp-admin/includes/upgrade.php';  
    1709. 

  1709.   else $page = 'wp-admin/upgrade'.'-functions.php';
    1710. 

  1710. 

  1711.   require_once(ABSPATH . $page);
    1712. 

  1712.   dbDelta($sql_createtable);	
    1713. 

  1713. }
    1714. 

  1714. 

  1715. function iri_NewStatPress_is_feed($url) {
    1716. 

  1716. 	if (stristr($url,get_bloginfo('rdf_url')) != FALSE) { return 'RDF'; }
    1717. 

  1717. 	if (stristr($url,get_bloginfo('rss2_url')) != FALSE) { return 'RSS2'; }
    1718. 

  1718. 	if (stristr($url,get_bloginfo('rss_url')) != FALSE) { return 'RSS'; }
    1719. 

  1719. 	if (stristr($url,get_bloginfo('atom_url')) != FALSE) { return 'ATOM'; }
    1720. 

  1720. 	if (stristr($url,get_bloginfo('comments_rss2_url')) != FALSE) { return 'COMMENT'; }
    1721. 

  1721. 	if (stristr($url,get_bloginfo('comments_atom_url')) != FALSE) { return 'COMMENT'; }
    1722. 

  1722. 	if (stristr($url,'wp-feed.php') != FALSE) { return 'RSS2'; }
    1723. 

  1723. 	if (stristr($url,'/feed/') != FALSE) { return 'RSS2'; }
    1724. 

  1724. 	return '';
    1725. 

  1725. }
    1726. 

  1726. 

  1727. /**
    1728. 

  1728.  * Insert statistic into the database
    1729. 

  1729.  */
    1730. 

  1730. function iriStatAppend() {
    1731. 

  1731.   global $wpdb;
    1732. 

  1732.   $table_name = $wpdb->prefix . "statpress";
    1733. 

  1733.   global $userdata;
    1734. 

  1734.   global $_STATPRESS;
    1735. 

  1735. 

  1736.   get_currentuserinfo();
    1737. 

  1737.   $feed='';
    1738. 

  1738. 

  1739.   // Time
    1740. 

  1740.   $timestamp  = current_time('timestamp');
    1741. 

  1741.   $vdate  = gmdate("Ymd",$timestamp);
    1742. 

  1742.   $vtime  = gmdate("H:i:s",$timestamp);
    1743. 

  1743.   $timestamp = date('Y-m-d H:i:s', $timestamp);
    1744. 

  1744. 

  1745.   // IP
    1746. 

  1746.   $ipAddress = $_SERVER['REMOTE_ADDR'];
    1747. 

  1747. 

  1748.   // Is this IP blacklisted from file?
    1749. 

  1749.   if(iriCheckBanIP($ipAddress) == '') { return ''; }
    1750. 

  1750. 

  1751.   // Is this IP blacklisted from user?
    1752. 

  1752.   $to_ignore = get_option('newstatpress_ignore_ip', array());
    1753. 

  1753.   foreach($to_ignore as $a_ip_range){
    1754. 

  1754.     list ($ip_to_ignore, $mask) = @explode("/", trim($a_ip_range));
    1755. 

  1755.     if (empty($mask)) $mask = 32;
    1756. 

  1756.     $long_ip_to_ignore = ip2long($ip_to_ignore);
    1757. 

  1757.     $long_mask = bindec( str_pad('', $mask, '1') . str_pad('', 32-$mask, '0') );
    1758. 

  1758.     $long_masked_user_ip = $ipAddress & $long_mask;
    1759. 

  1759.     $long_masked_ip_to_ignore = $long_ip_to_ignore & $long_mask;
    1760. 

  1760.     if ($long_masked_user_ip == $long_masked_ip_to_ignore) { return ''; }
    1761. 

  1761.   }
    1762. 

  1762. 

  1763.   if(get_option('newstatpress_cryptip')=='checked') {
    1764. 

  1764.     $ipAddress = crypt($ipAddress,'newstatpress');
    1765. 

  1765.   }
    1766. 

  1766. 

  1767.   // URL (requested)
    1768. 

  1768.   $urlRequested=iri_NewStatPress_URL();
    1769. 

  1769.   if (preg_match("/.ico$/i", $urlRequested)) { return ''; }
    1770. 

  1770.   if (preg_match("/favicon.ico/i", $urlRequested)) { return ''; }
    1771. 

  1771.   if (preg_match("/.css$/i", $urlRequested)) { return ''; }
    1772. 

  1772.   if (preg_match("/.js$/i", $urlRequested)) { return ''; }
    1773. 

  1773.   if (stristr($urlRequested,"/wp-content/plugins") != FALSE) { return ''; }
    1774. 

  1774.   if (stristr($urlRequested,"/wp-content/themes") != FALSE) { return ''; }
    1775. 

  1775.   if (stristr($urlRequested,"/wp-admin/") != FALSE) { return ''; }
    1776. 

  1776. 

  1777.   // Is a given permalink blacklisted?
    1778. 

  1778.   $to_ignore = get_option('newstatpress_ignore_permalink', array());
    1779. 

  1779.     foreach($to_ignore as $a_filter){
    1780. 

  1780.     if (!empty($urlRequested) && strpos($urlRequested, $a_filter) === 0) { return ''; }
    1781. 

  1781.   }
    1782. 

  1782. 

  1783.   $referrer = (isset($_SERVER['HTTP_REFERER']) ? htmlentities($_SERVER['HTTP_REFERER']) : '');
    1784. 

  1784.   $userAgent = (isset($_SERVER['HTTP_USER_AGENT']) ? htmlentities($_SERVER['HTTP_USER_AGENT']) : '');
    1785. 

  1785.   $spider=iriGetSpider($userAgent);
    1786. 

  1786. 

  1787.   if(($spider != '') and (get_option('newstatpress_donotcollectspider')=='checked')) { return ''; }
    1788. 

  1788.     
    1789. 

  1789.   if($spider != '') {
    1790. 

  1790.     $os=''; $browser='';
    1791. 

  1791.   } else {
    1792. 

  1792.       // Trap feeds
    1793. 

  1793.       $feed=iri_NewStatPress_is_feed(get_bloginfo('url').$_SERVER['REQUEST_URI']);
    1794. 

  1794.       // Get OS and browser
    1795. 

  1795.       $os=iriGetOS($userAgent);
    1796. 

  1796.       $browser=iriGetBrowser($userAgent);
    1797. 

  1797.       list($searchengine,$search_phrase)=explode("|",iriGetSE($referrer));
    1798. 

  1798.     }
    1799. 

  1799. 

  1800.   // Country (ip2nation table) or language
    1801. 

  1801.   $countrylang="";
    1802. 

  1802.   if($wpdb->get_var("SHOW TABLES LIKE 'ip2nation'") == 'ip2nation') {
    1803. 

  1803.     $sql='SELECT * 
    1804. 

  1804.           FROM ip2nation 
    1805. 

  1805.           WHERE ip < INET_ATON("'.$ipAddress.'") 
    1806. 

  1806.           ORDER BY ip DESC 
    1807. 

  1807.           LIMIT 0,1';
    1808. 

  1808.     $qry = $wpdb->get_row($sql);
    1809. 

  1809.     $countrylang=$qry->country;
    1810. 

  1810.   }
    1811. 

  1811. 

  1812.   if($countrylang == '') {
    1813. 

  1813.     $countrylang=iriGetLanguage($_SERVER['HTTP_ACCEPT_LANGUAGE']);
    1814. 

  1814.   }
    1815. 

  1815. 

  1816.   // Auto-delete visits if...
    1817. 

  1817.   if(get_option('newstatpress_autodelete') != '') {
    1818. 

  1818.     $t=gmdate("Ymd",strtotime('-'.get_option('newstatpress_autodelete')));
    1819. 

  1819.     $results =$wpdb->query( "DELETE FROM " . $table_name . " WHERE date < '" . $t . "'");
    1820. 

  1820.   }
    1821. 

  1821.   if ((!is_user_logged_in()) OR (get_option('newstatpress_collectloggeduser')=='checked')) {
    1822. 

  1822.     if (is_user_logged_in() AND (get_option('newstatpress_collectloggeduser')=='checked')) {
    1823. 

  1823.       $current_user = wp_get_current_user();
    1824. 

  1824. 

  1825.       // Is a given name to ignore?
    1826. 

  1826.       $to_ignore = get_option('newstatpress_ignore_users', array());
    1827. 

  1827.       foreach($to_ignore as $a_filter) {
    1828. 

  1828.         if ($current_user->user_login == $a_filter) { return ''; }
    1829. 

  1829.       }
    1830. 

  1830.     }
    1831. 

  1831. 

  1832.     if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
    1833. 

  1833.       iri_NewStatPress_CreateTable();
    1834. 

  1834.     }
    1835. 

  1835. 

  1836.     $insert = 
    1837. 

  1837.       "INSERT INTO " . $table_name . "(
    1838. 

  1838.         date, 
    1839. 

  1839.         time, 
    1840. 

  1840.         ip, 
    1841. 

  1841.         urlrequested, 
    1842. 

  1842.         agent, 
    1843. 

  1843.         referrer, 
    1844. 

  1844.         search,
    1845. 

  1845.         nation,
    1846. 

  1846.         os, 
    1847. 

  1847.         browser,
    1848. 

  1848.         searchengine,
    1849. 

  1849.         spider,
    1850. 

  1850.         feed,
    1851. 

  1851.         user,
    1852. 

  1852.         timestamp
    1853. 

  1853.        ) VALUES (
    1854. 

  1854.         '$vdate',
    1855. 

  1855.         '$vtime',
    1856. 

  1856.         '$ipAddress',
    1857. 

  1857.         '$urlRequested',
    1858. 

  1858.         '".addslashes(strip_tags($userAgent))."',
    1859. 

  1859.         '$referrer','" .
    1860. 

  1860.         addslashes(strip_tags($search_phrase))."',
    1861. 

  1861.         '".$countrylang."',
    1862. 

  1862.         '$os',
    1863. 

  1863.         '$browser',
    1864. 

  1864.         '$searchengine',
    1865. 

  1865.         '$spider',
    1866. 

  1866.         '$feed',
    1867. 

  1867.         '$userdata->user_login', 
    1868. 

  1868.         '$timestamp'
    1869. 

  1869.        )";
    1870. 

  1870.     $results = $wpdb->query( $insert );
    1871. 

  1871.   }
    1872. 

  1872. }
    1873. 

  1873. 

  1874. 

  1875. /**
    1876. 

  1876.  * Get the days a use has choice for updating the database
    1877. 

  1877.  *
    1878. 

  1878.  * @return the number of days of -1 for all days
    1879. 

  1879.  */
    1880. 

  1880. function iriNewStatPressDays() {
    1881. 

  1881.   $days=-1;     // infinite in the past
    1882. 

  1882. 

  1883.   // Get Current page periode from URL
    1884. 

  1884.   $updateint =get_option('newstatpress_updateint');
    1885. 

  1885.     
    1886. 

  1886.   if     ($updateint=="1 week") $days=7;
    1887. 

  1887.   elseif ($updateint=="2 weeks") $days=14;
    1888. 

  1888.   elseif ($updateint=="3 weeks") $days=21;
    1889. 

  1889.   elseif ($updateint=="1 month") $days=30;
    1890. 

  1890.   elseif ($updateint=="2 months") $days=60;
    1891. 

  1891.   elseif ($updateint=="3 months") $days=90;
    1892. 

  1892.   elseif ($updateint=="6 months") $days=180;
    1893. 

  1893.   elseif ($updateint=="9 months") $days=270;
    1894. 

  1894.   elseif ($updateint=="1 year") $days=365;
    1895. 

  1895. 

  1896.   return $days;  
    1897. 

  1897. }
    1898. 

  1898. 

  1899. /**
    1900. 

  1900.  * Performes database update with new definitions
    1901. 

  1901.  */
    1902. 

  1902. function iriNewStatPressUpdate() {
    1903. 

  1903.   global $wpdb;
    1904. 

  1904.   $table_name = $wpdb->prefix . "statpress";
    1905. 

  1905. 

  1906.   $wpdb->flush();     // flush for counting right the queries
    1907. 

  1907.   $start_time = microtime(true);
    1908. 

  1908. 

  1909.   $days=iriNewStatPressDays();  // get the number of days for the update
    1910. 

  1910.   
    1911. 

  1911.   $to_date  = gmdate("Ymd",current_time('timestamp'));
    1912. 

  1912. 

  1913.   if ($days==-1) $from_date= "19990101";   // use a date where this plugin was not present
    1914. 

  1914.   else $from_date = gmdate('Ymd', current_time('timestamp')-86400*$days);
    1915. 

  1915. 

  1916.   $_newstatpress_url=PluginUrl();
    1917. 

  1917. 

  1918.   $wpdb->show_errors();
    1919. 

  1919. 

  1920.   print "<div class='wrap'><table class='widefat'><thead><tr><th scope='col'><h2>".__('Updating...','newstatpress')."</h2></th><th scope='col' style='width:150px;'>".__('Size','newstatpress')."</th><th scope='col' style='width:100px;'>".__('Result','newstatpress')."</th><th></th></tr></thead>";
    1921. 

  1921.   print "<tbody id='the-list'>";
    1922. 

  1922. 

  1923.   # check if ip2nation .sql file exists
    1924. 

  1924.   if(file_exists(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/ip2nation.sql')) {
    1925. 

  1925.     print "<tr><td>ip2nation.sql</td>";
    1926. 

  1926.     $FP = fopen (ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/ip2nation.sql', 'r' ); 
    1927. 

  1927.     $READ = fread ( $FP, filesize (ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/ip2nation.sql') ); 
    1928. 

  1928.     $READ = explode ( ";\n", $READ ); 
    1929. 

  1929.     foreach ( $READ as $RED ) { 
    1930. 

  1930.       if($RES != '') { $wpdb->query($RED); }
    1931. 

  1931.     } 
    1932. 

  1932.     print "<td>".iritablesize("ip2nation")."</td>";
    1933. 

  1933.     print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    1934. 

  1934.   }
    1935. 

  1935. 

  1936.   # update table
    1937. 

  1937.   print "<tr><td>Struct $table_name</td>";
    1938. 

  1938.   iri_NewStatPress_CreateTable();
    1939. 

  1939.   print "<td>".iritablesize($wpdb->prefix."statpress")."</td>";
    1940. 

  1940.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    1941. 

  1941. 

  1942.   print "<tr><td>Index $table_name</td>";
    1943. 

  1943.   print "<td>".iriindextablesize($wpdb->prefix."statpress")."</td>";
    1944. 

  1944.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    1945. 

  1945. 

  1946.   # Update Feed
    1947. 

  1947.   print "<tr><td>Feeds</td>";
    1948. 

  1948.   $wpdb->query("
    1949. 

  1949.     UPDATE $table_name 
    1950. 

  1950.     SET feed='' 
    1951. 

  1951.     WHERE date BETWEEN $from_date AND $to_date;"
    1952. 

  1952.   );
    1953. 

  1953. 

  1954.   # not standard
    1955. 

  1955.   $wpdb->query("
    1956. 

  1956.     UPDATE $table_name 
    1957. 

  1957.     SET feed='RSS2' 
    1958. 

  1958.     WHERE 
    1959. 

  1959.       urlrequested LIKE '%/feed/%' AND
    1960. 

  1960.       date BETWEEN $from_date AND $to_date;"
    1961. 

  1961.   );
    1962. 

  1962. 

  1963.   $wpdb->query("
    1964. 

  1964.     UPDATE $table_name 
    1965. 

  1965.     SET feed='RSS2' 
    1966. 

  1966.     WHERE 
    1967. 

  1967.       urlrequested LIKE '%wp-feed.php%' AND
    1968. 

  1968.       date BETWEEN $from_date AND $to_date;"    
    1969. 

  1969.   );
    1970. 

  1970. 

  1971.   # standard blog info urls
    1972. 

  1972.   $s=iriNewStatPress_extractfeedreq(get_bloginfo('comments_atom_url'));
    1973. 

  1973.   if($s != '') {
    1974. 

  1974.     $wpdb->query("
    1975. 

  1975.       UPDATE $table_name 
    1976. 

  1976.       SET feed='COMMENT' 
    1977. 

  1977.       WHERE 
    1978. 

  1978.         INSTR(urlrequested,'$s')>0 AND
    1979. 

  1979.         date BETWEEN $from_date AND $to_date;"
    1980. 

  1980.     );
    1981. 

  1981.   }
    1982. 

  1982.   $s=iriNewStatPress_extractfeedreq(get_bloginfo('comments_rss2_url'));
    1983. 

  1983.   if($s != '') {
    1984. 

  1984.     $wpdb->query("
    1985. 

  1985.       UPDATE $table_name 
    1986. 

  1986.       SET feed='COMMENT' 
    1987. 

  1987.       WHERE 
    1988. 

  1988.         INSTR(urlrequested,'$s')>0 AND
    1989. 

  1989.         date BETWEEN $from_date AND $to_date;"
    1990. 

  1990.     );
    1991. 

  1991.   }
    1992. 

  1992.   $s=iriNewStatPress_extractfeedreq(get_bloginfo('atom_url'));
    1993. 

  1993.   if($s != '') {
    1994. 

  1994.     $wpdb->query("
    1995. 

  1995.       UPDATE $table_name 
    1996. 

  1996.       SET feed='ATOM' 
    1997. 

  1997.       WHERE 
    1998. 

  1998.         INSTR(urlrequested,'$s')>0 AND
    1999. 

  1999.         date BETWEEN $from_date AND $to_date;"
    2000. 

  2000.     );
    2001. 

  2001.   }
    2002. 

  2002.   $s=iriNewStatPress_extractfeedreq(get_bloginfo('rdf_url'));
    2003. 

  2003.   if($s != '') {
    2004. 

  2004.     $wpdb->query("
    2005. 

  2005.       UPDATE $table_name 
    2006. 

  2006.       SET feed='RDF'  
    2007. 

  2007.       WHERE 
    2008. 

  2008.         INSTR(urlrequested,'$s')>0 AND
    2009. 

  2009.         date BETWEEN $from_date AND $to_date;"
    2010. 

  2010.     );
    2011. 

  2011.   }
    2012. 

  2012.   $s=iriNewStatPress_extractfeedreq(get_bloginfo('rss_url'));
    2013. 

  2013.   if($s != '') {
    2014. 

  2014.     $wpdb->query("
    2015. 

  2015.       UPDATE $table_name 
    2016. 

  2016.       SET feed='RSS'  
    2017. 

  2017.       WHERE 
    2018. 

  2018.         INSTR(urlrequested,'$s')>0 AND
    2019. 

  2019.         date BETWEEN $from_date AND $to_date;"
    2020. 

  2020.     );
    2021. 

  2021.   }
    2022. 

  2022.   $s=iriNewStatPress_extractfeedreq(get_bloginfo('rss2_url'));
    2023. 

  2023.   if($s != '') {
    2024. 

  2024.     $wpdb->query("
    2025. 

  2025.       UPDATE $table_name 
    2026. 

  2026.       SET feed='RSS2' 
    2027. 

  2027.       WHERE 
    2028. 

  2028.         INSTR(urlrequested,'$s')>0 AND
    2029. 

  2029.         date BETWEEN $from_date AND $to_date;"
    2030. 

  2030.     );
    2031. 

  2031.   }
    2032. 

  2032. 

  2033.   $wpdb->query("
    2034. 

  2034.     UPDATE $table_name 
    2035. 

  2035.     SET feed = '' 
    2036. 

  2036.     WHERE 
    2037. 

  2037.       isnull(feed) AND
    2038. 

  2038.       date BETWEEN $from_date AND $to_date;"
    2039. 

  2039.    );
    2040. 

  2040. 

  2041.   print "<td></td>";
    2042. 

  2042.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    2043. 

  2043. 

  2044.   # Update OS
    2045. 

  2045.   print "<tr><td>OSes</td>";
    2046. 

  2046.   $wpdb->query("
    2047. 

  2047.     UPDATE $table_name 
    2048. 

  2048.     SET os = ''
    2049. 

  2049.     WHERE date BETWEEN $from_date AND $to_date;"
    2050. 

  2050.   );
    2051. 

  2051.   $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/os.dat');
    2052. 

  2052.   foreach($lines as $line_num => $os) {
    2053. 

  2053.     list($nome_os,$id_os)=explode("|",$os);
    2054. 

  2054.     $qry="
    2055. 

  2055.       UPDATE $table_name 
    2056. 

  2056.       SET os = '$nome_os' 
    2057. 

  2057.       WHERE 
    2058. 

  2058.         os='' AND 
    2059. 

  2059.         replace(agent,' ','') LIKE '%".$id_os."%' AND
    2060. 

  2060.         date BETWEEN $from_date AND $to_date;";
    2061. 

  2061.     $wpdb->query($qry);
    2062. 

  2062.   }
    2063. 

  2063.   print "<td></td>";
    2064. 

  2064.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    2065. 

  2065. 

  2066. 

  2067.   # Update Browser
    2068. 

  2068.   print "<tr><td>Browsers</td>";
    2069. 

  2069.   $wpdb->query("
    2070. 

  2070.     UPDATE $table_name 
    2071. 

  2071.     SET browser = ''
    2072. 

  2072.     WHERE date BETWEEN $from_date AND $to_date;"
    2073. 

  2073.   );
    2074. 

  2074.   $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/browser.dat');
    2075. 

  2075.   foreach($lines as $line_num => $browser) {
    2076. 

  2076.     list($nome,$id)=explode("|",$browser);
    2077. 

  2077.     $qry="
    2078. 

  2078.       UPDATE $table_name 
    2079. 

  2079.       SET browser = '$nome' 
    2080. 

  2080.       WHERE 
    2081. 

  2081.         browser='' AND 
    2082. 

  2082.         replace(agent,' ','') LIKE '%".$id."%' AND
    2083. 

  2083.         date BETWEEN $from_date AND $to_date;";
    2084. 

  2084.     $wpdb->query($qry);
    2085. 

  2085.   }
    2086. 

  2086.   print "<td></td>";
    2087. 

  2087.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    2088. 

  2088. 

  2089. 

  2090.   # Update Spider
    2091. 

  2091.   print "<tr><td>Spiders</td>";
    2092. 

  2092.   $wpdb->query("
    2093. 

  2093.     UPDATE $table_name 
    2094. 

  2094.     SET spider = ''
    2095. 

  2095.     WHERE date BETWEEN $from_date AND $to_date;"
    2096. 

  2096.   );
    2097. 

  2097.   $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/spider.dat');
    2098. 

  2098.   foreach($lines as $line_num => $spider) {
    2099. 

  2099.     list($nome,$id)=explode("|",$spider);
    2100. 

  2100.     $qry="
    2101. 

  2101.       UPDATE $table_name 
    2102. 

  2102.       SET spider = '$nome',os='',browser='' 
    2103. 

  2103.       WHERE 
    2104. 

  2104.         spider='' AND 
    2105. 

  2105.         replace(agent,' ','') LIKE '%".$id."%' AND
    2106. 

  2106.         date BETWEEN $from_date AND $to_date;";
    2107. 

  2107.     $wpdb->query($qry);
    2108. 

  2108.   }
    2109. 

  2109.   print "<td></td>";
    2110. 

  2110.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    2111. 

  2111. 

  2112. 

  2113.   # Update Search engine
    2114. 

  2114.   print "<tr><td>Search engines</td>";
    2115. 

  2115.   $wpdb->query("
    2116. 

  2116.     UPDATE $table_name 
    2117. 

  2117.     SET searchengine = '', search=''
    2118. 

  2118.     WHERE date BETWEEN $from_date AND $to_date;");
    2119. 

  2119.   $qry = $wpdb->get_results("
    2120. 

  2120.     SELECT id, referrer 
    2121. 

  2121.     FROM $table_name 
    2122. 

  2122.     WHERE 
    2123. 

  2123.       length(referrer)!=0 AND
    2124. 

  2124.       date BETWEEN $from_date AND $to_date");
    2125. 

  2125.   foreach ($qry as $rk) {
    2126. 

  2126.     list($searchengine,$search_phrase)=explode("|",iriGetSE($rk->referrer));
    2127. 

  2127.     if($searchengine <> '') {
    2128. 

  2128.       $q="
    2129. 

  2129.         UPDATE $table_name 
    2130. 

  2130.         SET searchengine = '$searchengine', search='".addslashes($search_phrase)."' 
    2131. 

  2131.         WHERE 
    2132. 

  2132.           id=".$rk->id." AND
    2133. 

  2133.           date BETWEEN $from_date AND $to_date;";
    2134. 

  2134.       $wpdb->query($q);
    2135. 

  2135.     }
    2136. 

  2136.   }
    2137. 

  2137.   print "<td></td>";
    2138. 

  2138.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    2139. 

  2139. 

  2140.   $end_time = microtime(true);
    2141. 

  2141.   $sql_queries=$wpdb->num_queries;
    2142. 

  2142. 

  2143.   # Final statistics
    2144. 

  2144.   print "<tr><td>Final Struct $table_name</td>";
    2145. 

  2145.   print "<td>".iritablesize($wpdb->prefix."statpress")."</td>";
    2146. 

  2146.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    2147. 

  2147. 

  2148.   print "<tr><td>Final Index $table_name</td>";
    2149. 

  2149.   print "<td>".iriindextablesize($wpdb->prefix."statpress")."</td>";
    2150. 

  2150.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    2151. 

  2151. 

  2152.   print "<tr><td>Duration of the update</td>";
    2153. 

  2153.   print "<td>".round($end_time - $start_time, 2)." sec</td>";
    2154. 

  2154.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    2155. 

  2155. 

  2156.   print "<tr><td>This update was done in</td>";
    2157. 

  2157.   print "<td>".$sql_queries." SQL queries.</td>";
    2158. 

  2158.   print "<td><IMG style='border:0px;width:20px;height:20px;' SRC='".$_newstatpress_url."/images/ok.gif'></td></tr>";
    2159. 

  2159. 

  2160.   print "</tbody></table></div><br>\n";
    2161. 

  2161.   $wpdb->hide_errors();
    2162. 

  2162. }
    2163. 

  2163. 

  2164. 

  2165. function NewStatPress_Widget($w='') {
    2166. 

  2166. 

  2167. }
    2168. 

  2168. 

  2169. /**
    2170. 

  2170.  * Return the expanded vars into the give code. Wrapper for internal use
    2171. 

  2171.  */
    2172. 

  2172. function NewStatPress_Print($body='') {
    2173. 

  2173.   return iri_NewStatPress_Vars($body);
    2174. 

  2174. }
    2175. 

  2175. 

  2176. 

  2177. /**
    2178. 

  2178.  * Expand vars into the give code
    2179. 

  2179.  * 
    2180. 

  2180.  * @param boby the code where to look for variables to expand
    2181. 

  2181.  * @return the modified code
    2182. 

  2182.  */
    2183. 

  2183. function iri_NewStatPress_Vars($body) {
    2184. 

  2184.   global $wpdb;
    2185. 

  2185.   $table_name = $wpdb->prefix . "statpress";
    2186. 

  2186. 

  2187.   # look for %visits%
    2188. 

  2188.   if(strpos(strtolower($body),"%visits%") !== FALSE) {
    2189. 

  2189.     $qry = $wpdb->get_results(
    2190. 

  2190.       "SELECT count(DISTINCT(ip)) AS pageview 
    2191. 

  2191.        FROM $table_name 
    2192. 

  2192.        WHERE 
    2193. 

  2193.         date = '".gmdate("Ymd",current_time('timestamp'))."' AND
    2194. 

  2194.         spider='' and feed='';
    2195. 

  2195.       ");
    2196. 

  2196.     $body = str_replace("%visits%", $qry[0]->pageview, $body);
    2197. 

  2197.   }
    2198. 

  2198. 

  2199.   # look for %totalvisits%
    2200. 

  2200.   if(strpos(strtolower($body),"%totalvisits%") !== FALSE) {
    2201. 

  2201.     $qry = $wpdb->get_results(
    2202. 

  2202.       "SELECT count(DISTINCT(ip)) AS pageview 
    2203. 

  2203.        FROM $table_name 
    2204. 

  2204.        WHERE 
    2205. 

  2205.          spider='' AND
    2206. 

  2206.          feed='';
    2207. 

  2207.       ");
    2208. 

  2208.     $body = str_replace("%totalvisits%", $qry[0]->pageview, $body);
    2209. 

  2209.   }
    2210. 

  2210. 

  2211.   # look for %totalpageviews%
    2212. 

  2212.   if(strpos(strtolower($body),"%totalpageviews%") !== FALSE) {
    2213. 

  2213.     $qry = $wpdb->get_results(
    2214. 

  2214.       "SELECT count(id) AS pageview 
    2215. 

  2215.        FROM $table_name 
    2216. 

  2216.        WHERE 
    2217. 

  2217.          spider='' AND 
    2218. 

  2218.          feed='';
    2219. 

  2219.       ");
    2220. 

  2220.     $body = str_replace("%totalpageviews%", $qry[0]->pageview, $body);
    2221. 

  2221.   }
    2222. 

  2222. 

  2223.   # look for %thistotalvisits%
    2224. 

  2224.   if(strpos(strtolower($body),"%thistotalvisits%") !== FALSE) {
    2225. 

  2225.     $qry = $wpdb->get_results(
    2226. 

  2226.       "SELECT count(DISTINCT(ip)) AS pageview 
    2227. 

  2227.        FROM $table_name 
    2228. 

  2228.        WHERE 
    2229. 

  2229.          spider='' AND
    2230. 

  2230.          feed='' AND 
    2231. 

  2231.          urlrequested='".iri_NewStatPress_URL()."';
    2232. 

  2232.       ");
    2233. 

  2233.     $body = str_replace("%thistotalvisits%", $qry[0]->pageview, $body);
    2234. 

  2234.   }
    2235. 

  2235. 

  2236.   # look for %alltotalvisits%
    2237. 

  2237.   if(strpos(strtolower($body),"%alltotalvisits%") !== FALSE) {
    2238. 

  2238.     $qry = $wpdb->get_results(
    2239. 

  2239.       "SELECT SUM(pageview) AS pageview 
    2240. 

  2240.        FROM (
    2241. 

  2241.          SELECT count(DISTINCT(ip)) AS pageview 
    2242. 

  2242.          FROM $table_name AS t1 
    2243. 

  2243.          WHERE 
    2244. 

  2244.            spider='' AND 
    2245. 

  2245.            feed='' AND 
    2246. 

  2246.            urlrequested!='' 
    2247. 

  2247.          GROUP BY urlrequested
    2248. 

  2248.        ) AS t2;
    2249. 

  2249.       ");
    2250. 

  2250.     $body = str_replace("%alltotalvisits%", $qry[0]->pageview, $body); 
    2251. 

  2251.   }
    2252. 

  2252. 

  2253.   # look for %since%
    2254. 

  2254.   if(strpos(strtolower($body),"%since%") !== FALSE) {
    2255. 

  2255.     $qry = $wpdb->get_results(
    2256. 

  2256.       "SELECT date 
    2257. 

  2257.        FROM $table_name 
    2258. 

  2258.        ORDER BY date 
    2259. 

  2259.        LIMIT 1;
    2260. 

  2260.       ");
    2261. 

  2261.     $body = str_replace("%since%", irihdate($qry[0]->date), $body);
    2262. 

  2262.   }
    2263. 

  2263. 

  2264.   # look for %os%
    2265. 

  2265.   if(strpos(strtolower($body),"%os%") !== FALSE) {
    2266. 

  2266.     $userAgent = (isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '');
    2267. 

  2267.     $os=iriGetOS($userAgent);
    2268. 

  2268.     $body = str_replace("%os%", $os, $body);
    2269. 

  2269.   }
    2270. 

  2270. 

  2271.   # look for %browser%
    2272. 

  2272.   if(strpos(strtolower($body),"%browser%") !== FALSE) {
    2273. 

  2273.     $browser=iriGetBrowser($userAgent);
    2274. 

  2274.     $body = str_replace("%browser%", $browser, $body);
    2275. 

  2275.   }
    2276. 

  2276. 

  2277.   # look for %ip%
    2278. 

  2278.   if(strpos(strtolower($body),"%ip%") !== FALSE) { 	
    2279. 

  2279.     $ipAddress = $_SERVER['REMOTE_ADDR'];
    2280. 

  2280.     $body = str_replace("%ip%", $ipAddress, $body);
    2281. 

  2281.   }
    2282. 

  2282. 

  2283.   # look for %visitorsonline%
    2284. 

  2284.   if(strpos(strtolower($body),"%visitorsonline%") !== FALSE) { 	
    2285. 

  2285.     $to_time =  current_time('timestamp');
    2286. 

  2286.     $from_time =  date('Y-m-d H:i:s', strtotime('-4 minutes', $to_time));
    2287. 

  2287.     $to_time = date('Y-m-d H:i:s', $to_time);
    2288. 

  2288.     $qry = $wpdb->get_results(
    2289. 

  2289.       "SELECT count(DISTINCT(ip)) AS visitors 
    2290. 

  2290.        FROM $table_name 
    2291. 

  2291.        WHERE 
    2292. 

  2292.          spider='' AND
    2293. 

  2293.          feed='' AND 
    2294. 

  2294.          timestamp BETWEEN '$from_time' AND '$to_time';
    2295. 

  2295.       ");
    2296. 

  2296.     $body = str_replace("%visitorsonline%", $qry[0]->visitors, $body);
    2297. 

  2297.   }
    2298. 

  2298. 

  2299.   # look for %usersonline%
    2300. 

  2300.   if(strpos(strtolower($body),"%usersonline%") !== FALSE) { 	
    2301. 

  2301.     $to_time =  current_time('timestamp');
    2302. 

  2302.     $from_time =  date('Y-m-d H:i:s', strtotime('-4 minutes', $to_time));
    2303. 

  2303.     $to_time = date('Y-m-d H:i:s', $to_time);
    2304. 

  2304.     $qry = $wpdb->get_results(
    2305. 

  2305.       "SELECT count(DISTINCT(ip)) AS users 
    2306. 

  2306.        FROM $table_name 
    2307. 

  2307.        WHERE 
    2308. 

  2308.          spider='' AND 
    2309. 

  2309.          feed='' AND 
    2310. 

  2310.          user<>'' AND 
    2311. 

  2311.          timestamp BETWEEN '$from_time' AND '$to_time';
    2312. 

  2312.       ");
    2313. 

  2313.     $body = str_replace("%usersonline%", $qry[0]->users, $body);
    2314. 

  2314.   }
    2315. 

  2315. 

  2316.   # look for %toppost%
    2317. 

  2317.   if(strpos(strtolower($body),"%toppost%") !== FALSE) {
    2318. 

  2318.     $qry = $wpdb->get_results(
    2319. 

  2319.       "SELECT urlrequested,count(*) AS totale 
    2320. 

  2320.        FROM $table_name 
    2321. 

  2321.        WHERE 
    2322. 

  2322.          spider='' AND 
    2323. 

  2323.          feed='' AND 
    2324. 

  2324.          urlrequested LIKE '%p=%' 
    2325. 

  2325.        GROUP BY urlrequested 
    2326. 

  2326.        ORDER BY totale DESC 
    2327. 

  2327.        LIMIT 1;
    2328. 

  2328.       ");
    2329. 

  2329.     $body = str_replace("%toppost%", iri_NewStatPress_Decode($qry[0]->urlrequested), $body);
    2330. 

  2330.   }
    2331. 

  2331. 

  2332.   # look for %topbrowser%
    2333. 

  2333.   if(strpos(strtolower($body),"%topbrowser%") !== FALSE) {
    2334. 

  2334.     $qry = $wpdb->get_results(
    2335. 

  2335.        "SELECT browser,count(*) AS totale 
    2336. 

  2336.         FROM $table_name 
    2337. 

  2337.         WHERE 
    2338. 

  2338.           spider='' AND 
    2339. 

  2339.           feed='' 
    2340. 

  2340.         GROUP BY browser 
    2341. 

  2341.         ORDER BY totale DESC 
    2342. 

  2342.         LIMIT 1;
    2343. 

  2343.        ");
    2344. 

  2344.     $body = str_replace("%topbrowser%", iri_NewStatPress_Decode($qry[0]->browser), $body);
    2345. 

  2345.   }
    2346. 

  2346. 

  2347.   # look for %topos%
    2348. 

  2348.   if(strpos(strtolower($body),"%topos%") !== FALSE) {
    2349. 

  2349.     $qry = $wpdb->get_results(
    2350. 

  2350.       "SELECT os,count(*) AS totale 
    2351. 

  2351.        FROM $table_name 
    2352. 

  2352.        WHERE 
    2353. 

  2353.          spider='' AND 
    2354. 

  2354.          feed='' 
    2355. 

  2355.        GROUP BY os 
    2356. 

  2356.        ORDER BY totale DESC
    2357. 

  2357.        LIMIT 1;
    2358. 

  2358.       ");
    2359. 

  2359.     $body = str_replace("%topos%", iri_NewStatPress_Decode($qry[0]->os), $body);
    2360. 

  2360.   }
    2361. 

  2361. 

  2362.   return $body;
    2363. 

  2363. }
    2364. 

  2364. 

  2365. /**
    2366. 

  2366.  * Get top posts
    2367. 

  2367.  *
    2368. 

  2368.  * @param limit the number of post to show
    2369. 

  2369.  * @param showcounts if checked show totals
    2370. 

  2370.  * @return result of extraction
    2371. 

  2371.  */
    2372. 

  2372. function iri_NewStatPress_TopPosts($limit=5, $showcounts='checked') {
    2373. 

  2373.   global $wpdb;
    2374. 

  2374.   $res="\n<ul>\n";
    2375. 

  2375.   $table_name = $wpdb->prefix . "statpress";
    2376. 

  2376.   $qry = $wpdb->get_results(
    2377. 

  2377.     "SELECT urlrequested,count(*) as totale 
    2378. 

  2378.      FROM $table_name 
    2379. 

  2379.      WHERE 
    2380. 

  2380.        spider='' AND 
    2381. 

  2381.        feed='' AND 
    2382. 

  2382.        urlrequested LIKE '%p=%' 
    2383. 

  2383.      GROUP BY urlrequested 
    2384. 

  2384.      ORDER BY totale DESC LIMIT $limit;
    2385. 

  2385.     ");
    2386. 

    2387. 

  2387.   foreach ($qry as $rk) {
    2388. 

  2388.     $res.="<li><a href='?".$rk->urlrequested."' target='_blank'>".iri_NewStatPress_Decode($rk->urlrequested)."</a></li>\n";
    2389. 

  2389.     if(strtolower($showcounts) == 'checked') { $res.=" (".$rk->totale.")"; }
    2390. 

  2390.   }
    2391. 

  2391.   return "$res</ul>\n";
    2392. 

  2392. }
    2393. 

  2393. 

  2394. 

  2395. function widget_newstatpress_init($args) {
    2396. 

  2396.   if ( !function_exists('wp_register_sidebar_widget') || !function_exists('wp_register_widget_control') ) return;
    2397. 

  2397. 

  2398.   // Multifunctional StatPress pluging
    2399. 

  2399.   function widget_newstatpress_control() {
    2400. 

  2400.     $options = get_option('widget_newstatpress');
    2401. 

  2401.     if ( !is_array($options) ) $options = array('title'=>'NewStatPress', 'body'=>'Visits today: %visits%');
    2402. 

  2402.     if ( isset($_POST['newstatpress-submit']) && $_POST['newstatpress-submit'] ) {
    2403. 

  2403.       $options['title'] = strip_tags(stripslashes($_POST['newstatpress-title']));
    2404. 

  2404.       $options['body'] = stripslashes($_POST['newstatpress-body']);
    2405. 

  2405.       update_option('widget_newstatpress', $options);
    2406. 

  2406.     }
    2407. 

  2407.     $title = htmlspecialchars($options['title'], ENT_QUOTES);
    2408. 

  2408.     $body = htmlspecialchars($options['body'], ENT_QUOTES);
    2409. 

  2409.      // the form
    2410. 

  2410.     echo '<p style="text-align:right;"><label for="newstatpress-title">' . __('Title:') . ' <input style="width: 250px;" id="newstatpress-title" name="newstatpress-title" type="text" value="'.$title.'" /></label></p>';
    2411. 

  2411.     echo '<p style="text-align:right;"><label for="newstatpress-body"><div>' . __('Body:', 'widgets') . '</div><textarea style="width: 288px;height:100px;" id="newstatpress-body" name="newstatpress-body" type="textarea">'.$body.'</textarea></label></p>';
    2412. 

  2412.     echo '<input type="hidden" id="newstatpress-submit" name="newstatpress-submit" value="1" /><div style="font-size:7pt;">%totalvisits% %visits% %thistotalvisits% %os% %browser% %ip% %since% %visitorsonline% %usersonline% %toppost% %topbrowser% %topos%</div>';
    2413. 

  2413.   }
    2414. 

  2414.   function widget_newstatpress($args) {
    2415. 

  2415.     extract($args);
    2416. 

  2416.     $options = get_option('widget_newstatpress');
    2417. 

  2417.     $title = $options['title'];
    2418. 

  2418.     $body = $options['body'];
    2419. 

  2419.     echo $before_widget;
    2420. 

  2420.     print($before_title . $title . $after_title);
    2421. 

  2421.     print iri_NewStatPress_Vars($body);
    2422. 

  2422.     echo $after_widget;
    2423. 

  2423.   }
    2424. 

  2424.   wp_register_sidebar_widget('NewStatPress', 'NewStatPress', 'widget_newstatpress');
    2425. 

  2425.   wp_register_widget_control('NewStatPress', array('NewStatPress','widgets'), 'widget_newstatpress_control', 300, 210);
    2426. 

  2426. 

  2427.   // Top posts
    2428. 

  2428.   function widget_newstatpresstopposts_control() {
    2429. 

  2429.     $options = get_option('widget_newstatpresstopposts');
    2430. 

  2430.     if ( !is_array($options) ) {
    2431. 

  2431.       $options = array('title'=>'NewStatPress TopPosts', 'howmany'=>'5', 'showcounts'=>'checked');
    2432. 

  2432.     }
    2433. 

  2433.     if ( isset($_POST['newstatpresstopposts-submit']) && $_POST['newstatpresstopposts-submit'] ) {
    2434. 

  2434.       $options['title'] = strip_tags(stripslashes($_POST['newstatpresstopposts-title']));
    2435. 

  2435.       $options['howmany'] = stripslashes($_POST['newstatpresstopposts-howmany']);
    2436. 

  2436.       $options['showcounts'] = stripslashes($_POST['newstatpresstopposts-showcounts']);
    2437. 

  2437.       if($options['showcounts'] == "1") {
    2438. 

  2438.         $options['showcounts']='checked';  
    2439. 

  2439.       }
    2440. 

  2440.       update_option('widget_newstatpresstopposts', $options);
    2441. 

  2441.     }
    2442. 

  2442.     $title = htmlspecialchars($options['title'], ENT_QUOTES);
    2443. 

  2443.     $howmany = htmlspecialchars($options['howmany'], ENT_QUOTES);
    2444. 

  2444.     $showcounts = htmlspecialchars($options['showcounts'], ENT_QUOTES);
    2445. 

  2445.     // the form
    2446. 

  2446.     echo '<p style="text-align:right;"><label for="newstatpresstopposts-title">' . __('Title','newstatpress') . ' <input style="width: 250px;" id="newstatpress-title" name="newstatpresstopposts-title" type="text" value="'.$title.'" /></label></p>';
    2447. 

  2447.     echo '<p style="text-align:right;"><label for="newstatpresstopposts-howmany">' . __('Limit results to','newstatpress') . ' <input style="width: 100px;" id="newstatpresstopposts-howmany" name="newstatpresstopposts-howmany" type="text" value="'.$howmany.'" /></label></p>';
    2448. 

  2448.     echo '<p style="text-align:right;"><label for="newstatpresstopposts-showcounts">' . __('Visits','newstatpress') . ' <input id="newstatpresstopposts-showcounts" name="newstatpresstopposts-showcounts" type=checkbox value="checked" '.$showcounts.' /></label></p>';
    2449. 

  2449.     echo '<input type="hidden" id="newstatpress-submitTopPosts" name="newstatpresstopposts-submit" value="1" />';
    2450. 

  2450.   }
    2451. 

  2451.   function widget_newstatpresstopposts($args) {
    2452. 

  2452.     extract($args);
    2453. 

  2453.     $options = get_option('widget_newstatpresstopposts');
    2454. 

  2454.     $title = htmlspecialchars($options['title'], ENT_QUOTES);
    2455. 

  2455.     $howmany = htmlspecialchars($options['howmany'], ENT_QUOTES);
    2456. 

  2456.     $showcounts = htmlspecialchars($options['showcounts'], ENT_QUOTES);
    2457. 

  2457.     echo $before_widget;
    2458. 

  2458.     print($before_title . $title . $after_title);
    2459. 

  2459.     print iri_NewStatPress_TopPosts($howmany,$showcounts);
    2460. 

  2460.     echo $after_widget;
    2461. 

  2461.   }
    2462. 

  2462.   wp_register_sidebar_widget('NewStatPress TopPosts', 'NewStatPress TopPosts', 'widget_newstatpresstopposts');
    2463. 

  2463.   wp_register_widget_control('NewStatPress TopPosts', array('NewStatPress TopPosts','widgets'), 'widget_newstatpresstopposts_control', 300, 110);
    2464. 

  2464. }
    2465. 

  2465. 

  2466. /**
    2467. 

  2467.  * Replace a content in page with NewStatPress output
    2468. 

  2468.  * Used format is: [NewStatPress: type]
    2469. 

  2469.  * Type can be:
    2470. 

  2470.  *  [NewStatPress: Overview]
    2471. 

  2471.  *  [NewStatPress: Top days]
    2472. 

  2472.  *  [NewStatPress: O.S.] 
    2473. 

  2473.  *  [NewStatPress: Browser]
    2474. 

  2474.  *  [NewStatPress: Feeds]
    2475. 

  2475.  *  [NewStatPress: Search Engine]
    2476. 

  2476.  *  [NewStatPress: Search terms]
    2477. 

  2477.  *  [NewStatPress: Top referrer]
    2478. 

  2478.  *  [NewStatPress: Languages]
    2479. 

  2479.  *  [NewStatPress: Spider]
    2480. 

  2480.  *  [NewStatPress: Top Pages]
    2481. 

  2481.  *  [NewStatPress: Top Days - Unique visitors]
    2482. 

  2482.  *  [NewStatPress: Top Days - Pageviews]
    2483. 

  2483.  *  [NewStatPress: Top IPs - Pageviews]
    2484. 

  2484.  * 
    2485. 

  2485.  * @param content the content of page
    2486. 

  2486.  */
    2487. 

  2487. function content_newstatpress($content = '') {
    2488. 

  2488.   ob_start();
    2489. 

  2489.   $TYPEs = array();
    2490. 

  2490.   $TYPE = preg_match_all('/\[NewStatPress: (.*)\]/Ui', $content, $TYPEs);
    2491. 

  2491. 

  2492.   foreach ($TYPEs[1] as $k => $TYPE) {
    2493. 

  2493.     switch ($TYPE) {
    2494. 

  2494.       case "Overview":
    2495. 

  2495.         $replacement=iriOverview(FALSE);
    2496. 

  2496.         break;
    2497. 

  2497.       case "Top days":
    2498. 

  2498.         $replacement=iriValueTable2("date","Top days", (get_option('newstatpress_el_top_days')=='') ? 5:get_option('newstatpress_el_top_days'), FALSE);
    2499. 

  2499.         break;
    2500. 

  2500.       case "O.S.":
    2501. 

  2501.         $replacement=iriValueTable2("os","O.S.",(get_option('newstatpress_el_os')=='') ? 10:get_option('newstatpress_el_os'),"","","AND feed='' AND spider='' AND os<>''", FALSE);
    2502. 

  2502.         break;
    2503. 

  2503.       case "Browser":
    2504. 

  2504.         $replacement=iriValueTable2("browser","Browser",(get_option('newstatpress_el_browser')=='') ? 10:get_option('newstatpress_el_browser'),"","","AND feed='' AND spider='' AND browser<>''", FALSE);
    2505. 

  2505.         break;
    2506. 

  2506.       case "Feeds":
    2507. 

  2507.         $replacement=iriValueTable2("feed","Feeds",(get_option('newstatpress_el_feed')=='') ? 5:get_option('newstatpress_el_feed'),"","","AND feed<>''", FALSE);
    2508. 

  2508.         break;
    2509. 

  2509.       case "Search Engine":
    2510. 

  2510.         $replacement=iriValueTable2("searchengine","Search engines",(get_option('newstatpress_el_searchengine')=='') ? 10:get_option('newstatpress_el_searchengine'),"","","AND searchengine<>''", FALSE);
    2511. 

  2511.         break;
    2512. 

  2512.       case "Search terms":
    2513. 

  2513.         $replacement=iriValueTable2("search","Top search terms",(get_option('newstatpress_el_search')=='') ? 20:get_option('newstatpress_el_search'),"","","AND search<>''", FALSE);
    2514. 

  2514.         break;
    2515. 

  2515.       case "Top referrer":
    2516. 

  2516.         $replacement= iriValueTable2("referrer","Top referrer",(get_option('newstatpress_el_referrer')=='') ? 10:get_option('newstatpress_el_referrer'),"","","AND referrer<>'' AND referrer NOT LIKE '%".get_bloginfo('url')."%'", FALSE);
    2517. 

  2517.         break;
    2518. 

  2518.       case "Languages":
    2519. 

  2519.         $replacement=iriValueTable2("nation","Countries/Languages",(get_option('newstatpress_el_languages')=='') ? 20:get_option('newstatpress_el_languages'),"","","AND nation<>'' AND spider=''", FALSE);
    2520. 

  2520.         break;
    2521. 

  2521.       case "Spider":
    2522. 

  2522.         $replacement=iriValueTable2("spider","Spiders",(get_option('newstatpress_el_spiders')=='') ? 10:get_option('newstatpress_el_spiders'),"","","AND spider<>''", FALSE);
    2523. 

  2523.         break;
    2524. 

  2524.       case "Top Pages":
    2525. 

  2525.         $replacement=iriValueTable2("urlrequested","Top pages",(get_option('newstatpress_el_pages')=='') ? 5:get_option('newstatpress_el_pages'),"","urlrequested","AND feed='' and spider=''", FALSE);
    2526. 

  2526.         break;
    2527. 

  2527.       case "Top Days - Unique visitors":
    2528. 

  2528.         $replacement=iriValueTable2("date","Top Days - Unique visitors",(get_option('newstatpress_el_visitors')=='') ? 5:get_option('newstatpress_el_visitors'),"distinct","ip","AND feed='' and spider=''", FALSE); 
    2529. 

  2529.         break;
    2530. 

  2530.       case "Top Days - Pageviews":
    2531. 

  2531.         $replacement=iriValueTable2("date","Top Days - Pageviews",(get_option('newstatpress_el_daypages')=='') ? 5:get_option('newstatpress_el_daypages'),"","urlrequested","AND feed='' and spider=''", FALSE); 
    2532. 

  2532.         break;
    2533. 

  2533.       case "Top IPs - Pageviews":
    2534. 

  2534.         $replacement=iriValueTable2("ip","Top IPs - Pageviews",(get_option('newstatpress_el_ippages')=='') ? 5:get_option('newstatpress_el_ippages'),"","urlrequested","AND feed='' and spider=''", FALSE); 
    2535. 

  2535.         break;
    2536. 

  2536.       default:
    2537. 

  2537.         $replacement="";
    2538. 

  2538.     }
    2539. 

  2539.     $content = str_replace($TYPEs[0][$k], $replacement, $content);
    2540. 

  2540.   }
    2541. 

  2541.   ob_get_clean();
    2542. 

  2542.   return $content;
    2543. 

  2543. }
    2544. 

  2544. 

  2545. 

  2546. /**
    2547. 

  2547.  * Show statistics in dashboard
    2548. 

  2548.  */
    2549. 

  2549. function iri_dashboard_widget_function() {
    2550. 

  2550.   global $wpdb;
    2551. 

  2551.   $table_name = $wpdb->prefix . "statpress";
    2552. 

  2552. 

  2553.   # Tabella OVERVIEW
    2554. 

  2554.   $unique_color="#114477";
    2555. 

  2555.   $web_color="#3377B6";
    2556. 

  2556.   $rss_color="#f38f36";
    2557. 

  2557.   $spider_color="#83b4d8";
    2558. 

  2558.   $lastmonth = iri_NewStatPress_lastmonth();
    2559. 

  2559.   $thismonth = gmdate('Ym', current_time('timestamp'));
    2560. 

  2560.   $yesterday = gmdate('Ymd', current_time('timestamp')-86400);
    2561. 

  2561.   $today = gmdate('Ymd', current_time('timestamp'));
    2562. 

  2562.   $tlm[0]=substr($lastmonth,0,4); $tlm[1]=substr($lastmonth,4,2);
    2563. 

  2563. 

  2564.   //print "<div class='wrap'><h2>". __('Overview','NewStatPress'). "</h2>";
    2565. 

  2565.   print "<table class='widefat'><thead><tr>
    2566. 

  2566.   <th scope='col'></th>
    2567. 

  2567.   <th scope='col'>". __('Total since','newstatpress'). "<br /><font size=1>";
    2568. 

  2568.   print NewStatPress_Print('%since%');
    2569. 

  2569.   print "</font></th>
    2570. 

  2570.   <th scope='col'>". __('Last month','newstatpress'). "<br /><font size=1>" . gmdate('M, Y',gmmktime(0,0,0,$tlm[1],1,$tlm[0])) ."</font></th>
    2571. 

  2571.   <th scope='col'>". __('This month','newstatpress'). "<br /><font size=1>" . gmdate('M, Y', current_time('timestamp')) ."</font></th>
    2572. 

  2572.   <th scope='col'>Target ". __('This month','newstatpress'). "<br /><font size=1>" . gmdate('M, Y', current_time('timestamp')) ."</font></th>
    2573. 

  2573.   <th scope='col'>". __('Yesterday','newstatpress'). "<br /><font size=1>" . gmdate('d M, Y', current_time('timestamp')-86400) ."</font></th>
    2574. 

  2574.   <th scope='col'>". __('Today','newstatpress'). "<br /><font size=1>" . gmdate('d M, Y', current_time('timestamp')) ."</font></th>
    2575. 

  2575.   </tr></thead>
    2576. 

  2576.   <tbody id='the-list'>";
    2577. 

  2577.   ################################################################################################
    2578. 

  2578.   # VISITORS ROW
    2579. 

  2579.   print "<tr><td><div style='background:$unique_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>". __('Visitors','newstatpress'). "</td>";
    2580. 

  2580. 

  2581.   #TOTAL
    2582. 

  2582.   $qry_total = $wpdb->get_row("
    2583. 

  2583.     SELECT count(DISTINCT ip) AS visitors
    2584. 

  2584.     FROM $table_name
    2585. 

  2585.     WHERE  
    2586. 

  2586.       feed='' AND 
    2587. 

  2587.       spider=''
    2588. 

  2588.   ");
    2589. 

  2589.   print "<td>" . $qry_total->visitors . "</td>\n";
    2590. 

  2590. 

  2591.   #LAST MONTH
    2592. 

  2592.   $qry_lmonth = $wpdb->get_row("
    2593. 

  2593.    SELECT count(DISTINCT ip) AS visitors
    2594. 

  2594.    FROM $table_name
    2595. 

  2595.    WHERE 
    2596. 

  2596.      feed='' AND 
    2597. 

  2597.      spider='' AND 
    2598. 

  2598.      date LIKE '" . $lastmonth . "%'
    2599. 

  2599.   ");
    2600. 

  2600.   print "<td>" . $qry_lmonth->visitors . "</td>\n";
    2601. 

  2601. 

  2602.   #THIS MONTH
    2603. 

  2603.   $qry_tmonth = $wpdb->get_row("
    2604. 

  2604.     SELECT count(DISTINCT ip) AS visitors
    2605. 

  2605.     FROM $table_name
    2606. 

  2606.     WHERE 
    2607. 

  2607.       feed='' AND 
    2608. 

  2608.       spider='' AND 
    2609. 

  2609.       date LIKE '" . $thismonth . "%'
    2610. 

  2610.   ");
    2611. 

  2611.   $qry_tmonth->change = null;
    2612. 

  2612.   $qry_tmonth->added = null;
    2613. 

  2613.   if($qry_lmonth->visitors <> 0) {
    2614. 

  2614.     $pc = round( 100 * ($qry_tmonth->visitors / $qry_lmonth->visitors ) - 100,1);
    2615. 

  2615.     if($pc >= 0) $pc = "+" . $pc;
    2616. 

  2616.     $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
    2617. 

  2617.   }
    2618. 

  2618.   print "<td>" . $qry_tmonth->visitors . $qry_tmonth->change . "</td>\n";
    2619. 

  2619. 

  2620.   #TARGET
    2621. 

  2621.   $qry_tmonth->target = round($qry_tmonth->visitors / date("d", current_time('timestamp')) * 30);
    2622. 

  2622.   if($qry_lmonth->visitors <> 0) {
    2623. 

  2623.     $pt = round( 100 * ($qry_tmonth->target / $qry_lmonth->visitors ) - 100,1);
    2624. 

  2624.     if($pt >= 0) $pt = "+" . $pt;
    2625. 

  2625.     $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
    2626. 

  2626.   }
    2627. 

  2627.   print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
    2628. 

  2628. 

  2629.   #YESTERDAY
    2630. 

  2630.   $qry_y = $wpdb->get_row("
    2631. 

  2631.     SELECT count(DISTINCT ip) AS visitors
    2632. 

  2632.     FROM $table_name
    2633. 

  2633.     WHERE 
    2634. 

  2634.       feed='' AND 
    2635. 

  2635.       spider='' AND 
    2636. 

  2636.       date = '$yesterday'
    2637. 

  2637.   ");
    2638. 

  2638.   print "<td>" . $qry_y->visitors . "</td>\n";
    2639. 

  2639. 

  2640.   #TODAY
    2641. 

  2641.   $qry_t = $wpdb->get_row("
    2642. 

  2642.     SELECT count(DISTINCT ip) AS visitors
    2643. 

  2643.     FROM $table_name
    2644. 

  2644.     WHERE 
    2645. 

  2645.       feed='' AND 
    2646. 

  2646.       spider='' AND 
    2647. 

  2647.       date = '$today'
    2648. 

  2648.   ");
    2649. 

  2649.   print "<td>" . $qry_t->visitors . "</td>\n";
    2650. 

  2650.   print "</tr>";
    2651. 

  2651. 

  2652.   ################################################################################################
    2653. 

  2653.   # PAGEVIEWS ROW
    2654. 

  2654.   print "<tr><td><div style='background:$web_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>". __('Pageviews','newstatpress'). "</td>";
    2655. 

  2655. 

  2656.   #TOTAL
    2657. 

  2657.   $qry_total = $wpdb->get_row("
    2658. 

  2658.     SELECT count(date) as pageview
    2659. 

  2659.     FROM $table_name
    2660. 

  2660.     WHERE 
    2661. 

  2661.       feed='' AND 
    2662. 

  2662.       spider=''
    2663. 

  2663.   ");
    2664. 

  2664.   print "<td>" . $qry_total->pageview . "</td>\n";
    2665. 

  2665. 

  2666.   #LAST MONTH
    2667. 

  2667.   $prec=0;
    2668. 

  2668.   $qry_lmonth = $wpdb->get_row("
    2669. 

  2669.     SELECT count(date) as pageview
    2670. 

  2670.     FROM $table_name
    2671. 

  2671.     WHERE 
    2672. 

  2672.       feed='' AND 
    2673. 

  2673.       spider='' AND 
    2674. 

  2674.       date LIKE '" . $lastmonth . "%'
    2675. 

  2675.   ");
    2676. 

  2676.   print "<td>".$qry_lmonth->pageview."</td>\n";
    2677. 

  2677. 

  2678.   #THIS MONTH
    2679. 

  2679.   $qry_tmonth = $wpdb->get_row("
    2680. 

  2680.     SELECT count(date) as pageview
    2681. 

  2681.     FROM $table_name
    2682. 

  2682.     WHERE 
    2683. 

  2683.       feed='' AND 
    2684. 

  2684.       spider='' AND 
    2685. 

  2685.       date LIKE '" . $thismonth . "%'
    2686. 

  2686.   ");
    2687. 

  2687.   $qry_tmonth->change = null;
    2688. 

  2688.   $qry_tmonth->added = null;
    2689. 

  2689.   if($qry_lmonth->pageview <> 0) {
    2690. 

  2690.     $pc = round( 100 * ($qry_tmonth->pageview / $qry_lmonth->pageview ) - 100,1);
    2691. 

  2691.     if($pc >= 0) $pc = "+" . $pc;
    2692. 

  2692.     $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
    2693. 

  2693.   }
    2694. 

  2694.   print "<td>" . $qry_tmonth->pageview . $qry_tmonth->change . "</td>\n";
    2695. 

  2695. 

  2696.   #TARGET
    2697. 

  2697.   $qry_tmonth->target = round($qry_tmonth->pageview / date("d", current_time('timestamp')) * 30);
    2698. 

  2698.   if($qry_lmonth->pageview <> 0) {
    2699. 

  2699.     $pt = round( 100 * ($qry_tmonth->target / $qry_lmonth->pageview ) - 100,1);
    2700. 

  2700.     if($pt >= 0) $pt = "+" . $pt;
    2701. 

  2701.       $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
    2702. 

  2702.   }
    2703. 

  2703.   print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
    2704. 

  2704. 

  2705.   #YESTERDAY
    2706. 

  2706.   $qry_y = $wpdb->get_row("
    2707. 

  2707.     SELECT count(date) as pageview
    2708. 

  2708.     FROM $table_name
    2709. 

  2709.     WHERE 
    2710. 

  2710.       feed='' AND 
    2711. 

  2711.       spider='' AND 
    2712. 

  2712.       date = '$yesterday'
    2713. 

  2713.   ");
    2714. 

  2714.   print "<td>" . $qry_y->pageview . "</td>\n";
    2715. 

  2715. 

  2716.   #TODAY
    2717. 

  2717.   $qry_t = $wpdb->get_row("
    2718. 

  2718.     SELECT count(date) as pageview
    2719. 

  2719.     FROM $table_name
    2720. 

  2720.     WHERE 
    2721. 

  2721.       feed='' AND 
    2722. 

  2722.       spider='' AND 
    2723. 

  2723.       date = '$today'
    2724. 

  2724.   ");
    2725. 

  2725.   print "<td>" . $qry_t->pageview . "</td>\n";
    2726. 

  2726.   print "</tr>";
    2727. 

  2727. 

  2728.   ################################################################################################
    2729. 

  2729.   # SPIDERS ROW
    2730. 

  2730.   print "<tr><td><div style='background:$spider_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>Spiders</td>";
    2731. 

  2731.   #TOTAL
    2732. 

  2732.   $qry_total = $wpdb->get_row("
    2733. 

  2733.     SELECT count(date) as spiders
    2734. 

  2734.     FROM $table_name
    2735. 

  2735.     WHERE 
    2736. 

  2736.       feed='' AND 
    2737. 

  2737.       spider<>''
    2738. 

  2738.   ");
    2739. 

  2739.   print "<td>" . $qry_total->spiders . "</td>\n";
    2740. 

  2740. 

  2741.   #LAST MONTH
    2742. 

  2742.   $prec=0;
    2743. 

  2743.   $qry_lmonth = $wpdb->get_row("
    2744. 

  2744.     SELECT count(date) as spiders
    2745. 

  2745.     FROM $table_name
    2746. 

  2746.     WHERE 
    2747. 

  2747.       feed='' AND 
    2748. 

  2748.       spider<>'' AND 
    2749. 

  2749.       date LIKE '" . $lastmonth . "%'
    2750. 

  2750.   ");
    2751. 

  2751.   print "<td>" . $qry_lmonth->spiders. "</td>\n";
    2752. 

  2752. 

  2753.   #THIS MONTH
    2754. 

  2754.   $prec=$qry_lmonth->spiders;
    2755. 

  2755.   $qry_tmonth = $wpdb->get_row("
    2756. 

  2756.     SELECT count(date) as spiders
    2757. 

  2757.     FROM $table_name
    2758. 

  2758.     WHERE 
    2759. 

  2759.       feed='' AND 
    2760. 

  2760.       spider<>'' AND 
    2761. 

  2761.       date LIKE '" . $thismonth . "%'
    2762. 

  2762.   ");
    2763. 

  2763.   $qry_tmonth->change = null;
    2764. 

  2764.   $qry_tmonth->added = null;
    2765. 

  2765.   if($qry_lmonth->spiders <> 0) {
    2766. 

  2766.     $pc = round( 100 * ($qry_tmonth->spiders / $qry_lmonth->spiders ) - 100,1);
    2767. 

  2767.     if($pc >= 0) $pc = "+" . $pc;
    2768. 

  2768.     $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
    2769. 

  2769.   }
    2770. 

  2770.   print "<td>" . $qry_tmonth->spiders . $qry_tmonth->change . "</td>\n";
    2771. 

  2771. 

  2772.   #TARGET
    2773. 

  2773.   $qry_tmonth->target = round($qry_tmonth->spiders / date("d", current_time('timestamp')) * 30);
    2774. 

  2774.   if($qry_lmonth->spiders <> 0) {
    2775. 

  2775.     $pt = round( 100 * ($qry_tmonth->target / $qry_lmonth->spiders ) - 100,1);
    2776. 

  2776.     if($pt >= 0) $pt = "+" . $pt;
    2777. 

  2777.     $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
    2778. 

  2778.   }
    2779. 

  2779.   print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
    2780. 

  2780. 

  2781.   #YESTERDAY
    2782. 

  2782.   $qry_y = $wpdb->get_row("
    2783. 

  2783.     SELECT count(date) as spiders
    2784. 

  2784.     FROM $table_name
    2785. 

  2785.     WHERE 
    2786. 

  2786.       feed='' AND 
    2787. 

  2787.       spider<>'' AND 
    2788. 

  2788.       date = '$yesterday'
    2789. 

  2789.   ");
    2790. 

  2790.   print "<td>" . $qry_y->spiders . "</td>\n";
    2791. 

  2791. 

  2792.   #TODAY
    2793. 

  2793.   $qry_t = $wpdb->get_row("
    2794. 

  2794.     SELECT count(date) as spiders
    2795. 

  2795.     FROM $table_name
    2796. 

  2796.     WHERE 
    2797. 

  2797.       feed='' AND 
    2798. 

  2798.       spider<>'' AND 
    2799. 

  2799.       date = '$today'
    2800. 

  2800.   ");
    2801. 

  2801.   print "<td>" . $qry_t->spiders . "</td>\n";
    2802. 

  2802.   print "</tr>";
    2803. 

  2803. 

  2804.   ################################################################################################
    2805. 

  2805.   # FEEDS ROW
    2806. 

  2806.   print "<tr><td><div style='background:$rss_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>Feeds</td>";
    2807. 

  2807.   #TOTAL
    2808. 

  2808.   $qry_total = $wpdb->get_row("
    2809. 

  2809.     SELECT count(date) as feeds
    2810. 

  2810.     FROM $table_name
    2811. 

  2811.     WHERE 
    2812. 

  2812.       feed<>'' AND 
    2813. 

  2813.       spider='' 
    2814. 

  2814.   ");
    2815. 

  2815.   print "<td>".$qry_total->feeds."</td>\n";
    2816. 

  2816. 

  2817.   #LAST MONTH
    2818. 

  2818.   $qry_lmonth = $wpdb->get_row("
    2819. 

  2819.     SELECT count(date) as feeds
    2820. 

  2820.     FROM $table_name
    2821. 

  2821.     WHERE 
    2822. 

  2822.       feed<>'' AND 
    2823. 

  2823.       spider='' AND 
    2824. 

  2824.       date LIKE '" . $lastmonth . "%'
    2825. 

  2825.   ");
    2826. 

  2826.   print "<td>".$qry_lmonth->feeds."</td>\n";
    2827. 

  2827. 

  2828.   #THIS MONTH
    2829. 

  2829.   $qry_tmonth = $wpdb->get_row("
    2830. 

  2830.    SELECT count(date) as feeds
    2831. 

  2831.    FROM $table_name
    2832. 

  2832.    WHERE 
    2833. 

  2833.      feed<>'' AND 
    2834. 

  2834.      spider='' AND 
    2835. 

  2835.      date LIKE '" . $thismonth . "%'
    2836. 

  2836.   ");
    2837. 

  2837.   $qry_tmonth->change = null;
    2838. 

  2838.   $qry_tmonth->added = null;
    2839. 

  2839.   if($qry_lmonth->feeds <> 0) {
    2840. 

  2840.     $pc = round( 100 * ($qry_tmonth->feeds / $qry_lmonth->feeds ) - 100,1);
    2841. 

  2841.     if($pc >= 0) $pc = "+" . $pc;
    2842. 

  2842.     $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
    2843. 

  2843.   }
    2844. 

  2844.   print "<td>" . $qry_tmonth->feeds . $qry_tmonth->change . "</td>\n";
    2845. 

  2845. 

  2846.   #TARGET
    2847. 

  2847.   $qry_tmonth->target = round($qry_tmonth->feeds / date("d", current_time('timestamp')) * 30);
    2848. 

  2848.   if($qry_lmonth->feeds <> 0) {
    2849. 

  2849.     $pt = round( 100 * ($qry_tmonth->target / $qry_lmonth->feeds ) - 100,1);
    2850. 

  2850.     if($pt >= 0) $pt = "+" . $pt;
    2851. 

  2851.     $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
    2852. 

  2852.   }
    2853. 

  2853.   print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
    2854. 

  2854. 

  2855.   $qry_y = $wpdb->get_row("
    2856. 

  2856.     SELECT count(date) as feeds
    2857. 

  2857.     FROM $table_name
    2858. 

  2858.     WHERE 
    2859. 

  2859.       feed<>'' AND 
    2860. 

  2860.       spider='' AND 
    2861. 

  2861.       date = '".$yesterday."'
    2862. 

  2862.   ");
    2863. 

  2863.   print "<td>".$qry_y->feeds."</td>\n";
    2864. 

  2864. 

  2865.   $qry_t = $wpdb->get_row("
    2866. 

  2866.     SELECT count(date) as feeds
    2867. 

  2867.     FROM $table_name
    2868. 

  2868.     WHERE 
    2869. 

  2869.       feed<>'' AND 
    2870. 

  2870.       spider='' AND 
    2871. 

  2871.       date = '$today'
    2872. 

  2872.   ");
    2873. 

  2873.   print "<td>".$qry_t->feeds."</td>\n";
    2874. 

  2874.   print "</tr></table><br />\n\n";
    2875. 

  2875.   print '</tr></table>';
    2876. 

  2876.   print '</div>';
    2877. 

  2877.   # END OF OVERVIEW
    2878. 

  2878.   ####################################################################################################
    2879. 

  2879. 

  2880.   print "<div class='wrap'><h4><a href='admin.php?page=newstatpress/newstatpress.php'>". __('More details','newstatpress'). " &raquo;</a></h4>";
    2881. 

  2881. }
    2882. 

  2882. 

  2883. /**
    2884. 

  2884.  * Make the overwiew
    2885. 

  2885.  *
    2886. 

  2886.  * @param print true if to print
    2887. 

  2887.  * @return the printing represetnation if print is false
    2888. 

  2888.  */
    2889. 

  2889. function iriOverview($print = TRUE) {
    2890. 

  2890.   global $wpdb;
    2891. 

  2891.   $table_name = $wpdb->prefix . "statpress";
    2892. 

  2892. 

  2893.   $result="";
    2894. 

  2894. 

  2895.   # Tabella OVERVIEW
    2896. 

  2896.   $unique_color="#114477";
    2897. 

  2897.   $web_color="#3377B6";
    2898. 

  2898.   $rss_color="#f38f36";
    2899. 

  2899.   $spider_color="#83b4d8";
    2900. 

  2900.   $lastmonth = iri_NewStatPress_lastmonth();
    2901. 

  2901.   $thismonth = gmdate('Ym', current_time('timestamp'));
    2902. 

  2902.   $yesterday = gmdate('Ymd', current_time('timestamp')-86400);
    2903. 

  2903.   $today = gmdate('Ymd', current_time('timestamp'));
    2904. 

  2904.   $tlm[0]=substr($lastmonth,0,4); $tlm[1]=substr($lastmonth,4,2);
    2905. 

  2905. 

  2906.   $result = $result. "<div class='wrap'><h2>". __('Overview','newstatpress'). "</h2>";
    2907. 

  2907.   $result = $result. "<table class='widefat'><thead><tr>
    2908. 

  2908.          <th scope='col'></th>
    2909. 

  2909.          <th scope='col'>". __('Total since','newstatpress'). "<br /><font size=1>";
    2910. 

  2910.   $result = $result. NewStatPress_Print('%since%');
    2911. 

  2911.   $result = $result. "</font></th>
    2912. 

  2912.          <th scope='col'>". __('Last month','newstatpress'). "<br /><font size=1>" . gmdate('M, Y',gmmktime(0,0,0,$tlm[1],1,$tlm[0])) ."</font></th>
    2913. 

  2913.          <th scope='col'>". __('This month','newstatpress'). "<br /><font size=1>" . gmdate('M, Y', current_time('timestamp')) ."</font></th>
    2914. 

  2914.          <th scope='col'>Target ". __('This month','newstatpress'). "<br /><font size=1>" . gmdate('M, Y', current_time('timestamp')) ."</font></th>
    2915. 

  2915.          <th scope='col'>". __('Yesterday','newstatpress'). "<br /><font size=1>" . gmdate('d M, Y', current_time('timestamp')-86400) ."</font></th>
    2916. 

  2916.          <th scope='col'>". __('Today','newstatpress'). "<br /><font size=1>" . gmdate('d M, Y', current_time('timestamp')) ."</font></th>
    2917. 

  2917.          </tr></thead>
    2918. 

  2918.          <tbody id='the-list'>";
    2919. 

    2920. 

  2920.   ################################################################################################
    2921. 

  2921.   # VISITORS ROW
    2922. 

  2922.   $result = $result. "<tr><td><div style='background:$unique_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>". __('Visitors','newstatpress'). "</td>";
    2923. 

  2923. 

  2924.   #TOTAL
    2925. 

  2925.   $qry_total = $wpdb->get_row("
    2926. 

  2926.     SELECT count(DISTINCT ip) AS visitors
    2927. 

  2927.     FROM $table_name
    2928. 

  2928.     WHERE 
    2929. 

  2929.       feed='' AND 
    2930. 

  2930.       spider=''
    2931. 

  2931.   ");
    2932. 

  2932.   $result = $result. "<td>" . $qry_total->visitors . "</td>\n";
    2933. 

  2933. 

  2934.   #LAST MONTH
    2935. 

  2935.   $qry_lmonth = $wpdb->get_row("
    2936. 

  2936.     SELECT count(DISTINCT ip) AS visitors
    2937. 

  2937.     FROM $table_name
    2938. 

  2938.     WHERE  
    2939. 

  2939.       feed='' AND 
    2940. 

  2940.       spider='' AND 
    2941. 

  2941.       date LIKE '" . $lastmonth . "%'
    2942. 

  2942.   ");
    2943. 

  2943.   $result = $result. "<td>" . $qry_lmonth->visitors . "</td>\n";
    2944. 

  2944. 

  2945.   #THIS MONTH
    2946. 

  2946.   $qry_tmonth = $wpdb->get_row("
    2947. 

  2947.     SELECT count(DISTINCT ip) AS visitors
    2948. 

  2948.     FROM $table_name
    2949. 

  2949.     WHERE 
    2950. 

  2950.       feed='' AND 
    2951. 

  2951.       spider='' AND 
    2952. 

  2952.       date LIKE '" . $thismonth . "%'
    2953. 

  2953.   ");
    2954. 

  2954.   $qry_tmonth->change = null;
    2955. 

  2955.   $qry_tmonth->added = null;
    2956. 

  2956.   if($qry_lmonth->visitors <> 0) {
    2957. 

  2957.     $pc = round( 100 * ($qry_tmonth->visitors / $qry_lmonth->visitors ) - 100,1);
    2958. 

  2958.     if($pc >= 0) $pc = "+" . $pc;
    2959. 

  2959.     $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
    2960. 

  2960.   }
    2961. 

  2961.   $result = $result. "<td>" . $qry_tmonth->visitors . $qry_tmonth->change . "</td>\n";
    2962. 

  2962. 

  2963.   #TARGET
    2964. 

  2964.   $qry_tmonth->target = round($qry_tmonth->visitors / date("d", current_time('timestamp')) * 30);
    2965. 

  2965.   if($qry_lmonth->visitors <> 0) {
    2966. 

  2966.     $pt = round( 100 * ($qry_tmonth->target / $qry_lmonth->visitors ) - 100,1);
    2967. 

  2967.     if($pt >= 0) $pt = "+" . $pt;
    2968. 

  2968.       $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
    2969. 

  2969.     }
    2970. 

  2970.   $result = $result. "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
    2971. 

  2971. 

  2972.   #YESTERDAY
    2973. 

  2973.   $qry_y = $wpdb->get_row("
    2974. 

  2974.      SELECT count(DISTINCT ip) AS visitors
    2975. 

  2975.      FROM $table_name
    2976. 

  2976.      WHERE 
    2977. 

  2977.        feed='' AND 
    2978. 

  2978.        spider='' AND 
    2979. 

  2979.        date = '$yesterday'
    2980. 

  2980.   ");
    2981. 

  2981.   $result = $result. "<td>" . $qry_y->visitors . "</td>\n";
    2982. 

  2982. 

  2983.   #TODAY
    2984. 

  2984.   $qry_t = $wpdb->get_row("
    2985. 

  2985.     SELECT count(DISTINCT ip) AS visitors
    2986. 

  2986.     FROM $table_name
    2987. 

  2987.     WHERE 
    2988. 

  2988.       feed='' AND 
    2989. 

  2989.       spider='' AND 
    2990. 

  2990.       date = '$today'
    2991. 

  2991.   ");
    2992. 

  2992.   $result = $result. "<td>" . $qry_t->visitors . "</td>\n";
    2993. 

  2993.   $result = $result. "</tr>";
    2994. 

  2994. 

  2995.   ################################################################################################
    2996. 

  2996.   # PAGEVIEWS ROW
    2997. 

  2997.   $result = $result. "<tr><td><div style='background:$web_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>". __('Pageviews','newstatpress'). "</td>";
    2998. 

  2998. 

  2999.   #TOTAL
    3000. 

  3000.   $qry_total = $wpdb->get_row("
    3001. 

  3001.     SELECT count(date) as pageview
    3002. 

  3002.     FROM $table_name
    3003. 

  3003.     WHERE 
    3004. 

  3004.       feed='' AND 
    3005. 

  3005.       spider=''
    3006. 

  3006.   ");
    3007. 

  3007.   $result = $result. "<td>" . $qry_total->pageview . "</td>\n";
    3008. 

  3008. 

  3009.   #LAST MONTH
    3010. 

  3010.   $prec=0;
    3011. 

  3011.   $qry_lmonth = $wpdb->get_row("
    3012. 

  3012.     SELECT count(date) as pageview
    3013. 

  3013.     FROM $table_name
    3014. 

  3014.     WHERE 
    3015. 

  3015.       feed='' AND 
    3016. 

  3016.       spider='' AND 
    3017. 

  3017.       date LIKE '" . $lastmonth . "%'
    3018. 

  3018.     ");
    3019. 

  3019.   $result = $result. "<td>".$qry_lmonth->pageview."</td>\n";
    3020. 

  3020. 

  3021.   #THIS MONTH
    3022. 

  3022.   $qry_tmonth = $wpdb->get_row("
    3023. 

  3023.     SELECT count(date) as pageview
    3024. 

  3024.     FROM $table_name
    3025. 

  3025.     WHERE 
    3026. 

  3026.       feed='' AND 
    3027. 

  3027.       spider='' AND 
    3028. 

  3028.       date LIKE '" . $thismonth . "%'
    3029. 

  3029.   ");
    3030. 

  3030.   $qry_tmonth->change = null;
    3031. 

  3031.   $qry_tmonth->added = null;
    3032. 

  3032.   if($qry_lmonth->pageview <> 0) {
    3033. 

  3033.     $pc = round( 100 * ($qry_tmonth->pageview / $qry_lmonth->pageview ) - 100,1);
    3034. 

  3034.     if($pc >= 0) $pc = "+" . $pc;
    3035. 

  3035.     $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
    3036. 

  3036.   }
    3037. 

  3037.   $result = $result. "<td>" . $qry_tmonth->pageview . $qry_tmonth->change . "</td>\n";
    3038. 

  3038. 

  3039.   #TARGET
    3040. 

  3040.   $qry_tmonth->target = round($qry_tmonth->pageview / date("d", current_time('timestamp')) * 30);
    3041. 

  3041.   if($qry_lmonth->pageview <> 0) {
    3042. 

  3042.     $pt = round( 100 * ($qry_tmonth->target / $qry_lmonth->pageview ) - 100,1);
    3043. 

  3043.     if($pt >= 0) $pt = "+" . $pt;
    3044. 

  3044.     $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
    3045. 

  3045.   }
    3046. 

  3046.   $result = $result. "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
    3047. 

  3047. 

  3048.   #YESTERDAY
    3049. 

  3049.   $qry_y = $wpdb->get_row("
    3050. 

  3050.    SELECT count(date) as pageview
    3051. 

  3051.    FROM $table_name
    3052. 

  3052.    WHERE 
    3053. 

  3053.      feed='' AND 
    3054. 

  3054.      spider='' AND 
    3055. 

  3055.      date = '$yesterday'
    3056. 

  3056.    ");
    3057. 

  3057.   $result = $result."<td>" . $qry_y->pageview . "</td>\n";
    3058. 

  3058. 

  3059.   #TODAY
    3060. 

  3060.   $qry_t = $wpdb->get_row("
    3061. 

  3061.     SELECT count(date) as pageview
    3062. 

  3062.     FROM $table_name
    3063. 

  3063.     WHERE 
    3064. 

  3064.       feed='' AND 
    3065. 

  3065.       spider='' AND 
    3066. 

  3066.       date = '$today'
    3067. 

  3067.     ");
    3068. 

  3068.   $result = $result."<td>" . $qry_t->pageview . "</td>\n";
    3069. 

  3069.   $result = $result."</tr>";
    3070. 

  3070. 

  3071.   ################################################################################################
    3072. 

  3072.   # SPIDERS ROW
    3073. 

  3073.   $result = $result."<tr><td><div style='background:$spider_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>Spiders</td>";
    3074. 

  3074. 

  3075.   #TOTAL
    3076. 

  3076.   $qry_total = $wpdb->get_row("
    3077. 

  3077.     SELECT count(date) as spiders
    3078. 

  3078.     FROM $table_name
    3079. 

  3079.     WHERE 
    3080. 

  3080.       feed='' AND 
    3081. 

  3081.       spider<>''
    3082. 

  3082.   ");
    3083. 

  3083.   $result = $result."<td>" . $qry_total->spiders . "</td>\n";
    3084. 

  3084. 

  3085.   #LAST MONTH
    3086. 

  3086.   $prec=0;
    3087. 

  3087.   $qry_lmonth = $wpdb->get_row("
    3088. 

  3088.     SELECT count(date) as spiders
    3089. 

  3089.     FROM $table_name
    3090. 

  3090.     WHERE 
    3091. 

  3091.       feed='' AND 
    3092. 

  3092.       spider<>'' AND 
    3093. 

  3093.       date LIKE '" . $lastmonth . "%'
    3094. 

  3094.   ");
    3095. 

  3095.   $result = $result. "<td>" . $qry_lmonth->spiders. "</td>\n";
    3096. 

  3096. 

  3097.   #THIS MONTH
    3098. 

  3098.   $prec=$qry_lmonth->spiders;
    3099. 

  3099.   $qry_tmonth = $wpdb->get_row("
    3100. 

  3100.     SELECT count(date) as spiders
    3101. 

  3101.     FROM $table_name
    3102. 

  3102.     WHERE 
    3103. 

  3103.       feed='' AND 
    3104. 

  3104.       spider<>'' AND 
    3105. 

  3105.       date LIKE '" . $thismonth . "%'
    3106. 

  3106.   ");
    3107. 

  3107.   $qry_tmonth->change = null;
    3108. 

  3108.   $qry_tmonth->added = null;
    3109. 

  3109.   if($qry_lmonth->spiders <> 0) {
    3110. 

  3110.     $pc = round( 100 * ($qry_tmonth->spiders / $qry_lmonth->spiders ) - 100,1);
    3111. 

  3111.     if($pc >= 0) $pc = "+" . $pc;
    3112. 

  3112.     $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
    3113. 

  3113.   }
    3114. 

  3114.   $result = $result. "<td>" . $qry_tmonth->spiders . $qry_tmonth->change . "</td>\n";
    3115. 

  3115. 

  3116.   #TARGET
    3117. 

  3117.   $qry_tmonth->target = round($qry_tmonth->spiders / date("d", current_time('timestamp')) * 30);
    3118. 

  3118.   if($qry_lmonth->spiders <> 0) {
    3119. 

  3119.     $pt = round( 100 * ($qry_tmonth->target / $qry_lmonth->spiders ) - 100,1);
    3120. 

  3120.     if($pt >= 0) $pt = "+" . $pt;
    3121. 

  3121.     $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
    3122. 

  3122.   }
    3123. 

  3123.   $result = $result. "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
    3124. 

  3124. 

  3125.   #YESTERDAY
    3126. 

  3126.   $qry_y = $wpdb->get_row("
    3127. 

  3127.     SELECT count(date) as spiders
    3128. 

  3128.     FROM $table_name
    3129. 

  3129.     WHERE 
    3130. 

  3130.       feed='' AND 
    3131. 

  3131.       spider<>'' AND 
    3132. 

  3132.       date = '$yesterday'
    3133. 

  3133.   ");
    3134. 

  3134.   $result = $result. "<td>" . $qry_y->spiders . "</td>\n";
    3135. 

  3135. 

  3136.   #TODAY
    3137. 

  3137.   $qry_t = $wpdb->get_row("
    3138. 

  3138.     SELECT count(date) as spiders
    3139. 

  3139.     FROM $table_name
    3140. 

  3140.     WHERE 
    3141. 

  3141.      feed='' AND 
    3142. 

  3142.      spider<>'' AND 
    3143. 

  3143.      date = '$today'
    3144. 

  3144.   ");
    3145. 

  3145.   $result = $result. "<td>" . $qry_t->spiders . "</td>\n";
    3146. 

  3146.   $result = $result. "</tr>";
    3147. 

  3147. 

  3148.   ################################################################################################
    3149. 

  3149.   # FEEDS ROW
    3150. 

  3150.   $result = $result. "<tr><td><div style='background:$rss_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>Feeds</td>";
    3151. 

  3151.   #TOTAL
    3152. 

  3152.   $qry_total = $wpdb->get_row("
    3153. 

  3153.     SELECT count(date) as feeds
    3154. 

  3154.     FROM $table_name
    3155. 

  3155.     WHERE 
    3156. 

  3156.       feed<>'' AND spider=''
    3157. 

  3157.     ");
    3158. 

  3158.   $result = $result. "<td>".$qry_total->feeds."</td>\n";
    3159. 

  3159. 

  3160.   #LAST MONTH
    3161. 

  3161.   $qry_lmonth = $wpdb->get_row("
    3162. 

  3162.     SELECT count(date) as feeds
    3163. 

  3163.     FROM $table_name
    3164. 

  3164.     WHERE 
    3165. 

  3165.       feed<>'' AND 
    3166. 

  3166.       spider='' AND 
    3167. 

  3167.       date LIKE '" . $lastmonth . "%'
    3168. 

  3168.   ");
    3169. 

  3169.   $result = $result. "<td>".$qry_lmonth->feeds."</td>\n";
    3170. 

  3170. 

  3171.   #THIS MONTH
    3172. 

  3172.   $qry_tmonth = $wpdb->get_row("
    3173. 

  3173.     SELECT count(date) as feeds
    3174. 

  3174.     FROM $table_name
    3175. 

  3175.     WHERE 
    3176. 

  3176.       feed<>'' AND 
    3177. 

  3177.       spider='' AND 
    3178. 

  3178.       date LIKE '" . $thismonth . "%'
    3179. 

  3179.   ");
    3180. 

  3180.   $qry_tmonth->change = null;
    3181. 

  3181.   $qry_tmonth->added = null;
    3182. 

  3182.   if($qry_lmonth->feeds <> 0) {
    3183. 

  3183.     $pc = round( 100 * ($qry_tmonth->feeds / $qry_lmonth->feeds ) - 100,1);
    3184. 

  3184.     if($pc >= 0) $pc = "+" . $pc;
    3185. 

  3185.     $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
    3186. 

  3186.   }
    3187. 

  3187.   $result = $result. "<td>" . $qry_tmonth->feeds . $qry_tmonth->change . "</td>\n";
    3188. 

  3188. 

  3189.   #TARGET
    3190. 

  3190.   $qry_tmonth->target = round($qry_tmonth->feeds / date("d", current_time('timestamp')) * 30);
    3191. 

  3191.   if($qry_lmonth->feeds <> 0) {
    3192. 

  3192.     $pt = round( 100 * ($qry_tmonth->target / $qry_lmonth->feeds ) - 100,1);
    3193. 

  3193.     if($pt >= 0) $pt = "+" . $pt;
    3194. 

  3194.     $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
    3195. 

  3195.   }
    3196. 

  3196.   $result = $result. "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
    3197. 

  3197. 

  3198.   $qry_y = $wpdb->get_row("
    3199. 

  3199.     SELECT count(date) as feeds
    3200. 

  3200.     FROM $table_name
    3201. 

  3201.     WHERE 
    3202. 

  3202.       feed<>'' AND 
    3203. 

  3203.       spider='' AND 
    3204. 

  3204.       date = '".$yesterday."'
    3205. 

  3205.   ");
    3206. 

  3206.   $result = $result. "<td>".$qry_y->feeds."</td>\n";
    3207. 

  3207. 

  3208.   $qry_t = $wpdb->get_row("
    3209. 

  3209.     SELECT count(date) as feeds
    3210. 

  3210.     FROM $table_name
    3211. 

  3211.     WHERE 
    3212. 

  3212.       feed<>'' AND 
    3213. 

  3213.       spider='' AND 
    3214. 

  3214.       date = '$today'
    3215. 

  3215.   ");
    3216. 

  3216.   $result = $result. "<td>".$qry_t->feeds."</td>\n";
    3217. 

  3217. 

  3218.   $result = $result. "</tr></table><br />\n\n";
    3219. 

  3219.     
    3220. 

  3220.   ################################################################################################
    3221. 

  3221.   ################################################################################################
    3222. 

  3222.   # THE GRAPHS
    3223. 

  3223. 

  3224.   # last "N" days graph  NEW
    3225. 

  3225.   $gdays=get_option('newstatpress_daysinoverviewgraph'); if($gdays == 0) { $gdays=20; }
    3226. 

  3226.   $start_of_week = get_option('start_of_week');
    3227. 

  3227.   $result = $result. '<table width="100%" border="0"><tr>';
    3228. 

  3228.   $qry = $wpdb->get_row("
    3229. 

  3229.     SELECT count(date) as pageview, date
    3230. 

  3230.     FROM $table_name
    3231. 

  3231.     GROUP BY date HAVING date >= '".gmdate('Ymd', current_time('timestamp')-86400*$gdays)."'
    3232. 

  3232.     ORDER BY pageview DESC
    3233. 

  3233.     LIMIT 1
    3234. 

  3234.   ");
    3235. 

  3235.   $maxxday=$qry->pageview;
    3236. 

  3236.   if($maxxday == 0) { $maxxday = 1; }
    3237. 

  3237.   # Y
    3238. 

  3238.   $gd=(90/$gdays).'%';
    3239. 

  3239.   for($gg=$gdays-1;$gg>=0;$gg--) {
    3240. 

  3240.     #TOTAL VISITORS
    3241. 

  3241.     $qry_visitors = $wpdb->get_row("
    3242. 

  3242.       SELECT count(DISTINCT ip) AS total
    3243. 

  3243.       FROM $table_name
    3244. 

  3244.       WHERE 
    3245. 

  3245.         feed='' AND 
    3246. 

  3246.         spider='' AND 
    3247. 

  3247.         date = '".gmdate('Ymd', current_time('timestamp')-86400*$gg)."'
    3248. 

  3248.     ");
    3249. 

  3249.     $px_visitors = round($qry_visitors->total*100/$maxxday);
    3250. 

  3250. 

  3251.     #TOTAL PAGEVIEWS (we do not delete the uniques, this is falsing the info.. uniques are not different visitors!)
    3252. 

  3252.     $qry_pageviews = $wpdb->get_row("
    3253. 

  3253.       SELECT count(date) as total
    3254. 

  3254.       FROM $table_name
    3255. 

  3255.       WHERE 
    3256. 

  3256.         feed='' AND 
    3257. 

  3257.         spider='' AND 
    3258. 

  3258.         date = '".gmdate('Ymd', current_time('timestamp')-86400*$gg)."'
    3259. 

  3259.     ");
    3260. 

  3260.     $px_pageviews = round($qry_pageviews->total*100/$maxxday);
    3261. 

  3261. 

  3262.     #TOTAL SPIDERS
    3263. 

  3263.     $qry_spiders = $wpdb->get_row("
    3264. 

  3264.       SELECT count(ip) AS total
    3265. 

  3265.       FROM $table_name
    3266. 

  3266.       WHERE 
    3267. 

  3267.         feed='' AND 
    3268. 

  3268.         spider<>'' AND 
    3269. 

  3269.         date = '".gmdate('Ymd', current_time('timestamp')-86400*$gg)."'
    3270. 

  3270.       ");
    3271. 

  3271.     $px_spiders = round($qry_spiders->total*100/$maxxday);
    3272. 

  3272. 

  3273.     #TOTAL FEEDS
    3274. 

  3274.     $qry_feeds = $wpdb->get_row("
    3275. 

  3275.       SELECT count(ip) AS total
    3276. 

  3276.       FROM $table_name
    3277. 

  3277.       WHERE 
    3278. 

  3278.         feed<>'' AND 
    3279. 

  3279.         spider='' AND 
    3280. 

  3280.         date = '".gmdate('Ymd', current_time('timestamp')-86400*$gg)."'
    3281. 

  3281.     ");
    3282. 

  3282.     $px_feeds = round($qry_feeds->total*100/$maxxday);
    3283. 

  3283. 

  3284.     $px_white = 100 - $px_feeds - $px_spiders - $px_pageviews - $px_visitors;
    3285. 

  3285. 

  3286.     $result = $result.'<td width="'.$gd.'" valign="bottom"';
    3287. 

  3287.     if($start_of_week == gmdate('w',current_time('timestamp')-86400*$gg)) { 
    3288. 

  3288.       $result = $result.' style="border-left:2px dotted gray;"'; 
    3289. 

  3289.     }  # week-cut
    3290. 

  3290.     $result = $result. "><div style='float:left;height: 100%;width:100%;font-family:Helvetica;font-size:7pt;text-align:center;border-right:1px solid white;color:black;'>
    3291. 

  3291.        <div style='background:#ffffff;width:100%;height:".$px_white."px;'></div>
    3292. 

  3292.        <div style='background:$unique_color;width:100%;height:".$px_visitors."px;' title='".$qry_visitors->total." visitors'></div>
    3293. 

  3293.        <div style='background:$web_color;width:100%;height:".$px_pageviews."px;' title='".$qry_pageviews->total." pageviews'></div>
    3294. 

  3294.        <div style='background:$spider_color;width:100%;height:".$px_spiders."px;' title='".$qry_spiders->total." spiders'></div>
    3295. 

  3295.        <div style='background:$rss_color;width:100%;height:".$px_feeds."px;' title='".$qry_feeds->total." feeds'></div>
    3296. 

  3296.        <div style='background:gray;width:100%;height:1px;'></div>
    3297. 

  3297.        <br />".gmdate('d', current_time('timestamp')-86400*$gg) . ' ' . gmdate('M', current_time('timestamp')-86400*$gg) . "</div></td>\n";
    3298. 

  3298.   }
    3299. 

  3299.   $result = $result.'</tr></table>';
    3300. 

  3300. 

  3301.   $result = $result.'</div>';
    3302. 

  3302.   # END OF OVERVIEW
    3303. 

  3303.   ####################################################################################################
    3304. 

  3304. 

  3305.   if ($print) print $result;
    3306. 

  3306.   else return $result;
    3307. 

  3307. }
    3308. 

  3308. 

  3309. // Create the function use in the action hook
    3310. 

  3310. 

  3311. function iri_add_dashboard_widgets() {
    3312. 

  3312.   global $wp_meta_boxes;
    3313. 

  3313. 

  3314.   if (get_option('newstatpress_dashboard')=='checked') {
    3315. 

  3315.     wp_add_dashboard_widget('iri_dashboard_widget', 'NewStatPress Overview', 'iri_dashboard_widget_function');	
    3316. 

  3316.   } else unset($wp_meta_boxes['dashboard']['side']['core']['wp_dashboard_setup']);
    3317. 

  3317. } 
    3318. 

  3318. 

  3319. 

  3320. load_plugin_textdomain('newstatpress', 'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/locale', '/'.dirname(plugin_basename(__FILE__)).'/locale');
    3321. 

  3321. 

  3322. add_action('admin_menu', 'iri_add_pages');
    3323. 

  3323. add_action('plugins_loaded', 'widget_newstatpress_init');
    3324. 

  3324. add_action('send_headers', 'iriStatAppend');  //add_action('wp_head', 'iriStatAppend');
    3325. 

  3325. add_action('init','iri_checkExport');
    3326. 

  3326. 

  3327. // Hoook into the 'wp_dashboard_setup' action to register our other functions
    3328. 

  3328. add_action('wp_dashboard_setup', 'iri_add_dashboard_widgets' );
    3329. 

  3329. 

  3330. add_filter('the_content', 'content_newstatpress');
    3331. 

  3331. 

  3332. register_activation_hook(__FILE__,'iri_NewStatPress_CreateTable');
    3333. 

  3333. 

  3334. ?>
    3335.