PageRenderTime 95ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 1ms

/wp-content/plugins/statpress-reloaded/statpress.php

https://bitbucket.org/openfarmtech/weblog-content
PHP | 2143 lines | 1802 code | 196 blank | 145 comment | 297 complexity | dc13578254ba6f93217fd565059f1d82 MD5 | raw file
Possible License(s): GPL-2.0, AGPL-1.0, LGPL-2.0, LGPL-3.0, BSD-3-Clause, GPL-3.0, LGPL-2.1, AGPL-3.0, CC-BY-SA-3.0 
    

  1. <?php

    2. 

  2.   /*

    3. 

  3.    Plugin Name: StatPress Reloaded

    4. 

  4.    Plugin URI: http://blog.matrixagents.org/wp-plugins/

    5. 

  5.    Description: Improved real time stats for your blog

    6. 

  6.    Version: 1.5.21

    7. 

  7.    Author: Manuel Grabowski

    8. 

  8.    Author URI: http://blog.matrixagents.org/

    9. 

  9.    */

    10. 

  10.   

    11. 

  11.   $_STATPRESS['version'] = '1.5.21';

    12. 

  12.   $_STATPRESS['feedtype'] = '';

    13. 

  13.   

    14. 

  14.   

    15. 

  15.   if ($_GET['statpress_action'] == 'exportnow')

    16. 

  16.   {

    17. 

  17.       iriStatPressExportNow();

    18. 

  18.   }

    19. 

  19.   

    20. 

  20.   function iri_add_pages()

    21. 

  21.   {

    22. 

  22.       // Create table if it doesn't exist

    23. 

  23.       global $wpdb;

    24. 

  24.       $table_name = $wpdb->prefix . 'statpress';

    25. 

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

    26. 

  26.       {

    27. 

  27.           iri_StatPress_CreateTable();

    28. 

  28.       }

    29. 

  29.       

    30. 

  30.       // add submenu

    31. 

  31.       $mincap = get_option('statpress_mincap');

    32. 

  32.       if ($mincap == '')

    33. 

  33.       {

    34. 

  34.           $mincap = 'level_8';

    35. 

  35.       }

    36. 

  36. 

    37. 

  37. 

    38. 

  38.       add_menu_page('StatPress Reloaded', 'StatPress', $mincap, __FILE__, 'iriStatPress');

    39. 

  39.       add_submenu_page(__FILE__, __('Details', 'statpress'), __('Details', 'statpress'), $mincap, __FILE__ . '&statpress_action=details', 'iriStatPressDetails');

    40. 

  40.       add_submenu_page(__FILE__, __('Spy', 'statpress'), __('Spy', 'statpress'), $mincap, __FILE__ . '&statpress_action=spy', 'iriStatPressSpy');

    41. 

  41.       add_submenu_page(__FILE__, __('Search', 'statpress'), __('Search', 'statpress'), $mincap, __FILE__ . '&statpress_action=search', 'iriStatPressSearch');

    42. 

  42.       add_submenu_page(__FILE__, __('Export', 'statpress'), __('Export', 'statpress'), $mincap, __FILE__ . '&statpress_action=export', 'iriStatPressExport');

    43. 

  43.       add_submenu_page(__FILE__, __('Options', 'statpress'), __('Options', 'statpress'), $mincap, __FILE__ . '&statpress_action=options', 'iriStatPressOptions');

    44. 

  44.       add_submenu_page(__FILE__, __('User Agents', 'statpress'), __('User Agents', 'statpress'), $mincap, __FILE__ . '&statpress_action=agents', 'iriStatPressAgents');

    45. 

  45.       add_submenu_page(__FILE__, __('StatPressUpdate', 'statpress'), __('StatPressUpdate', 'statpress'), $mincap, __FILE__ . '&statpress_action=up', 'iriStatPressUpdate');

    46. 

  46.       //add_submenu_page(__FILE__, __('Support','statpress'), __('Support','statpress'), $mincap, 'http://matrixagents.org/phpBB/viewforum.php?f=3');

    47. 

  47.   }

    48. 

  48.   

    49. 

  49.   function permalinksEnabled()

    50. 

  50.   {

    51. 

  51.       global $wpdb;

    52. 

  52.       

    53. 

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

    54. 

  54.       if ($result->option_value != '')

    55. 

  55.       {

    56. 

  56.           return true;

    57. 

  57.       }

    58. 

  58.       else

    59. 

  59.       {

    60. 

  60.           return false;

    61. 

  61.       }

    62. 

  62.   }

    63. 

  63.   

    64. 

  64.   function my_substr($str, $x, $y = 0)

    65. 

  65.   {

    66. 

  66.   	if($y == 0)

    67. 

  67.   	{

    68. 

  68.   		$y = strlen($str) - $x;

    69. 

  69.   	}

    70. 

  70.  	if(function_exists('mb_substr'))

    71. 

  71.  	{

    72. 

  72.  		return mb_substr($str, $x, $y);

    73. 

  73.  	}

    74. 

  74.  	else

    75. 

  75.  	{

    76. 

  76.  		return substr($str, $x, $y);

    77. 

  77.  	}

    78. 

  78.   }

    79. 

  79.   

    80. 

  80.   

    81. 

  81.   function iriStatPress()

    82. 

  82.   {

    83. 

  83.       if ($_GET['statpress_action'] == 'export')

    84. 

  84.       {

    85. 

  85.           iriStatPressExport();

    86. 

  86.       }

    87. 

  87.       elseif ($_GET['statpress_action'] == 'up')

    88. 

  88.       {

    89. 

  89.           iriStatPressUpdate();

    90. 

  90.       }

    91. 

  91.       elseif ($_GET['statpress_action'] == 'spy')

    92. 

  92.       {

    93. 

  93.           iriStatPressSpy();

    94. 

  94.       }

    95. 

  95.       elseif ($_GET['statpress_action'] == 'search')

    96. 

  96.       {

    97. 

  97.           iriStatPressSearch();

    98. 

  98.       }

    99. 

  99.       elseif ($_GET['statpress_action'] == 'details')

    100. 

  100.       {

    101. 

  101.           iriStatPressDetails();

    102. 

  102.       }

    103. 

  103.       elseif ($_GET['statpress_action'] == 'options')

    104. 

  104.       {

    105. 

  105.           iriStatPressOptions();

    106. 

  106.       }

    107. 

  107.       elseif ($_GET['statpress_action'] == 'overview')

    108. 

  108.       {

    109. 

  109.           iriStatPressMain();

    110. 

  110.       }

    111. 

  111.       elseif ($_GET['statpress_action'] == 'agents')

    112. 

  112.       {

    113. 

  113.           iriStatPressAgents();

    114. 

  114.       }

    115. 

  115.       else

    116. 

  116.       {

    117. 

  117.           iriStatPressMain();

    118. 

  118.       }

    119. 

  119.   }

    120. 

  120.   

    121. 

  121.   function iriStatPressOptions()

    122. 

  122.   {

    123. 

  123.       if ($_POST['saveit'] == 'yes')

    124. 

  124.       {

    125. 

  125.           update_option('statpress_collectloggeduser', $_POST['statpress_collectloggeduser']);

    126. 

  126.           update_option('statpress_autodelete', $_POST['statpress_autodelete']);

    127. 

  127.           update_option('statpress_daysinoverviewgraph', $_POST['statpress_daysinoverviewgraph']);

    128. 

  128.           update_option('statpress_mincap', $_POST['statpress_mincap']);

    129. 

  129.           update_option('statpress_donotcollectspider', $_POST['statpress_donotcollectspider']);

    130. 

  130.           update_option('statpress_autodelete_spider', $_POST['statpress_autodelete_spider']);

    131. 

  131.           

    132. 

  132.           // update database too

    133. 

  133.           iri_StatPress_CreateTable();

    134. 

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

    135. 

  135.       }

    136. 

  136.       else

    137. 

  137.       {

    138. 

  138. ?>

    139. 

  139.   <div class='wrap'><h2><?php

    140. 

  140.           _e('Options', 'statpress');

    141. 

  141. ?></h2>

    142. 

  142.   <form method=post><table width=100%>

    143. 

  143. <?php

    144. 

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

    145. 

  145.           print "<tr><td><input type=checkbox name='statpress_donotcollectspider' value='checked' " . get_option('statpress_donotcollectspider') . "> " . __('Do not collect spiders visits', 'statpress') . "</td></tr>";

    146. 

  146. ?>

    147. 

  147.   <tr><td><?php

    148. 

  148.           _e('Automatically delete visits older than', 'statpress');

    149. 

  149. ?>

    150. 

  150.   <select name="statpress_autodelete">

    151. 

  151.   <option value="" <?php

    152. 

  152.           if (get_option('statpress_autodelete') == '')

    153. 

  153.               print "selected";

    154. 

  154. ?>><?php

    155. 

  155.           _e('Never delete!', 'statpress');

    156. 

  156. ?></option>

    157. 

  157.   <option value="1 month" <?php

    158. 

  158.           if (get_option('statpress_autodelete') == "1 month")

    159. 

  159.               print "selected";

    160. 

  160. ?>>1 <?php

    161. 

  161.           _e('month', 'statpress');

    162. 

  162. ?></option>

    163. 

  163.   <option value="3 months" <?php

    164. 

  164.           if (get_option('statpress_autodelete') == "3 months")

    165. 

  165.               print "selected";

    166. 

  166. ?>>3 <?php

    167. 

  167.           _e('months', 'statpress');

    168. 

  168. ?></option>

    169. 

  169.   <option value="6 months" <?php

    170. 

  170.           if (get_option('statpress_autodelete') == "6 months")

    171. 

  171.               print "selected";

    172. 

  172. ?>>6 <?php

    173. 

  173.           _e('months', 'statpress');

    174. 

  174. ?></option>

    175. 

  175.   <option value="1 year" <?php

    176. 

  176.           if (get_option('statpress_autodelete') == "1 year")

    177. 

  177.               print "selected";

    178. 

  178. ?>>1 <?php

    179. 

  179.           _e('year', 'statpress');

    180. 

  180. ?></option>

    181. 

  181.   </select></td></tr>

    182. 

  182.   

    183. 

  183.   <tr><td><?php _e('Automatically delete spider visits older than','statpress'); ?>

    184. 

  184.   <select name="statpress_autodelete_spider">

    185. 

  185.   <option value="" <?php if(get_option('statpress_autodelete_spider') =='' ) print "selected"; ?>><?php _e('Never delete!','statpress'); ?></option>

    186. 

  186.   <option value="1 day" <?php if(get_option('statpress_autodelete_spider') == "1 day") print "selected"; ?>>1 <?php _e('day','statpress'); ?></option>

    187. 

  187.   <option value="1 week" <?php if(get_option('statpress_autodelete_spider') == "1 week") print "selected"; ?>>1 <?php _e('week','statpress'); ?></option>

    188. 

  188.   <option value="1 month" <?php if(get_option('statpress_autodelete_spider') == "1 month") print "selected"; ?>>1 <?php _e('month','statpress'); ?></option>

    189. 

  189.   <option value="1 year" <?php if(get_option('statpress_autodelete_spider') == "1 year") print "selected"; ?>>1 <?php _e('year','statpress'); ?></option>

    190. 

  190.   </select></td></tr>

    191. 

  191. 

    192. 

  192.   <tr><td><?php

    193. 

  193.           _e('Days in Overview graph', 'statpress');

    194. 

  194. ?>

    195. 

  195.   <select name="statpress_daysinoverviewgraph">

    196. 

  196.   <option value="7" <?php

    197. 

  197.           if (get_option('statpress_daysinoverviewgraph') == 7)

    198. 

  198.               print "selected";

    199. 

  199. ?>>7</option>

    200. 

  200.   <option value="10" <?php

    201. 

  201.           if (get_option('statpress_daysinoverviewgraph') == 10)

    202. 

  202.               print "selected";

    203. 

  203. ?>>10</option>

    204. 

  204.   <option value="20" <?php

    205. 

  205.           if (get_option('statpress_daysinoverviewgraph') == 20)

    206. 

  206.               print "selected";

    207. 

  207. ?>>20</option>

    208. 

  208.   <option value="30" <?php

    209. 

  209.           if (get_option('statpress_daysinoverviewgraph') == 30)

    210. 

  210.               print "selected";

    211. 

  211. ?>>30</option>

    212. 

  212.   <option value="50" <?php

    213. 

  213.           if (get_option('statpress_daysinoverviewgraph') == 50)

    214. 

  214.               print "selected";

    215. 

  215. ?>>50</option>

    216. 

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

    217. 

  217. 

    218. 

  218.   <tr><td><?php

    219. 

  219.           _e('Minimum capability to view stats', 'statpress');

    220. 

  220. ?>

    221. 

  221.   <select name="statpress_mincap">

    222. 

  222. <?php

    223. 

  223.           iri_dropdown_caps(get_option('statpress_mincap'));

    224. 

  224. ?>

    225. 

  225.   </select> 

    226. 

  226.   <a href="http://codex.wordpress.org/Roles_and_Capabilities" target="_blank"><?php

    227. 

  227.           _e("more info", 'statpress');

    228. 

  228. ?></a>

    229. 

  229.   </td></tr>

    230. 

  230.   

    231. 

  231.   <tr><td><br><input type=submit value="<?php

    232. 

  232.           _e('Save options', 'statpress');

    233. 

  233. ?>"></td></tr>

    234. 

  234.   </tr>

    235. 

  235.   </table>

    236. 

  236.   <input type=hidden name=saveit value=yes>

    237. 

  237.   <input type=hidden name=page value=statpress><input type=hidden name=statpress_action value=options>

    238. 

  238.   </form>

    239. 

  239.   </div>

    240. 

  240. <?php

    241. 

  241.           } // chiude saveit

    242. 

  242.       }

    243. 

  243.       

    244. 

  244.       

    245. 

  245.       function iri_dropdown_caps($default = false)

    246. 

  246.       {

    247. 

  247.           global $wp_roles;

    248. 

  248.           $role = get_role('administrator');

    249. 

  249.           foreach ($role->capabilities as $cap => $grant)

    250. 

  250.           {

    251. 

  251.               print "<option ";

    252. 

  252.               if ($default == $cap)

    253. 

  253.               {

    254. 

  254.                   print "selected ";

    255. 

  255.               }

    256. 

  256.               print ">$cap</option>";

    257. 

  257.           }

    258. 

  258.       }

    259. 

  259.       

    260. 

  260.       

    261. 

  261.       function iriStatPressExport()

    262. 

  262.       {

    263. 

  263. ?>

    264. 

  264.   <div class='wrap'><h2><?php

    265. 

  265.           _e('Export stats to text file', 'statpress');

    266. 

  266. ?> (csv)</h2>

    267. 

  267.   <form method=get><table>

    268. 

  268.   <tr><td><?php

    269. 

  269.           _e('From', 'statpress');

    270. 

  270. ?></td><td><input type=text name=from> (YYYYMMDD)</td></tr>

    271. 

  271.   <tr><td><?php

    272. 

  272.           _e('To', 'statpress');

    273. 

  273. ?></td><td><input type=text name=to> (YYYYMMDD)</td></tr>

    274. 

  274.   <tr><td><?php

    275. 

  275.           _e('Fields delimiter', 'statpress');

    276. 

  276. ?></td><td><select name=del><option>,</option><option>;</option><option>|</option></select></tr>

    277. 

  277.   <tr><td></td><td><input type=submit value=<?php

    278. 

  278.           _e('Export', 'statpress');

    279. 

  279. ?>></td></tr>

    280. 

  280.   <input type=hidden name=page value=statpress><input type=hidden name=statpress_action value=exportnow>

    281. 

  281.   </table></form>

    282. 

  282.   </div>

    283. 

  283. <?php

    284. 

  284.       }

    285. 

  285.       

    286. 

  286.       

    287. 

  287.       function iriStatPressExportNow()

    288. 

  288.       {

    289. 

  289.           global $wpdb;

    290. 

  290.           $table_name = $wpdb->prefix . "statpress";

    291. 

  291.           $filename = get_bloginfo('title') . "-statpress_" . $_GET['from'] . "-" . $_GET['to'] . ".csv";

    292. 

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

    293. 

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

    294. 

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

    295. 

  295.           $qry = $wpdb->get_results("SELECT * FROM $table_name WHERE date>='" . (date("Ymd", strtotime(my_substr($_GET['from'], 0, 8)))) . "' AND date<='" . (date("Ymd", strtotime(my_substr($_GET['to'], 0, 8)))) . "';");

    296. 

  296.           $del = my_substr($_GET['del'], 0, 1);

    297. 

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

    298. 

  298.           foreach ($qry as $rk)

    299. 

  299.           {

    300. 

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

    301. 

  301.           }

    302. 

  302.           die();

    303. 

  303.       }

    304. 

  304.       

    305. 

  305.       function iriStatPressMain()

    306. 

  306.       {

    307. 

  307.           global $wpdb;

    308. 

  308.           $table_name = $wpdb->prefix . "statpress";

    309. 

  309.           

    310. 

  310.           // OVERVIEW table

    311. 

  311.           $unique_color = "#114477";

    312. 

  312.           $web_color = "#3377B6";

    313. 

  313.           $rss_color = "#f38f36";

    314. 

  314.           $spider_color = "#83b4d8";

    315. 

  315.           $lastmonth = iri_StatPress_lastmonth();

    316. 

  316.           $thismonth = gmdate('Ym', current_time('timestamp'));

    317. 

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

    318. 

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

    319. 

  319.           $tlm[0] = my_substr($lastmonth, 0, 4);

    320. 

  320.           $tlm[1] = my_substr($lastmonth, 4, 2);

    321. 

  321.           

    322. 

  322.           print "<div class='wrap'><h2>" . __('Overview', 'statpress') . "</h2>";

    323. 

  323.           print "<table class='widefat'><thead><tr>

    324. 

  324.   <th scope='col'></th>

    325. 

  325.   <th scope='col'>" . __('Total', 'statpress') . "</th>

    326. 

  326.   <th scope='col'>" . __('Last month', 'statpress') . "<br /><font size=1>" . gmdate('M, Y', gmmktime(0, 0, 0, $tlm[1], 1, $tlm[0])) . "</font></th>

    327. 

  327.   <th scope='col'>" . __('This month', 'statpress') . "<br /><font size=1>" . gmdate('M, Y', current_time('timestamp')) . "</font></th>

    328. 

  328.   <th scope='col'>" . __('Target', 'statpress') . " " . __('This month', 'statpress') . "<br /><font size=1>" . gmdate('M, Y', current_time('timestamp')) . "</font></th>

    329. 

  329.   <th scope='col'>" . __('Yesterday', 'statpress') . "<br /><font size=1>" . gmdate('d M, Y', current_time('timestamp') - 86400) . "</font></th>

    330. 

  330.   <th scope='col'>" . __('Today', 'statpress') . "<br /><font size=1>" . gmdate('d M, Y', current_time('timestamp')) . "</font></th>

    331. 

  331.   </tr></thead>

    332. 

  332.   <tbody id='the-list'>";

    333. 

  333.           

    334. 

  334.           //###############################################################################################

    335. 

  335.           // VISITORS ROW

    336. 

  336.           print "<tr><td><div style='background:$unique_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>" . __('Visitors', 'statpress') . "</td>";

    337. 

  337.           

    338. 

  338.           //TOTAL

    339. 

  339.           $qry_total = $wpdb->get_row("

    340. 

  340.     SELECT count(DISTINCT ip) AS visitors

    341. 

  341.     FROM $table_name

    342. 

  342.     WHERE feed=''

    343. 

  343.     AND spider=''

    344. 

  344.   ");

    345. 

  345.           print "<td>" . $qry_total->visitors . "</td>\n";

    346. 

  346.           

    347. 

  347.           //LAST MONTH

    348. 

  348.           $qry_lmonth = $wpdb->get_row("

    349. 

  349.     SELECT count(DISTINCT ip) AS visitors

    350. 

  350.     FROM $table_name

    351. 

  351.     WHERE feed=''

    352. 

  352.     AND spider=''

    353. 

  353.     AND date LIKE '" . mysql_real_escape_string($lastmonth) . "%'

    354. 

  354.   ");

    355. 

  355.           print "<td>" . $qry_lmonth->visitors . "</td>\n";

    356. 

  356.           

    357. 

  357.           //THIS MONTH

    358. 

  358.           $qry_tmonth = $wpdb->get_row("

    359. 

  359.     SELECT count(DISTINCT ip) AS visitors

    360. 

  360.     FROM $table_name

    361. 

  361.     WHERE feed=''

    362. 

  362.     AND spider=''

    363. 

  363.     AND date LIKE '" . mysql_real_escape_string($thismonth) . "%'

    364. 

  364.   ");

    365. 

  365.           if ($qry_lmonth->visitors <> 0)

    366. 

  366.           {

    367. 

  367.               $pc = round(100 * ($qry_tmonth->visitors / $qry_lmonth->visitors) - 100, 1);

    368. 

  368.               if ($pc >= 0)

    369. 

  369.                   $pc = "+" . $pc;

    370. 

  370.               $qry_tmonth->change = "<code> (" . $pc . "%)</code>";

    371. 

  371.           }

    372. 

  372.           print "<td>" . $qry_tmonth->visitors . $qry_tmonth->change . "</td>\n";

    373. 

  373.           

    374. 

  374.           //TARGET

    375. 

  375.           

    376. 

  376.           $qry_tmonth->target = round($qry_tmonth->visitors / (time() - mktime(0,0,0,date('m'),date('1'),date('Y'))) * (86400 * date('t')));

    377. 

  377.           if ($qry_lmonth->visitors <> 0)

    378. 

  378.           {

    379. 

  379.               $pt = round(100 * ($qry_tmonth->target / $qry_lmonth->visitors) - 100, 1);

    380. 

  380.               if ($pt >= 0)

    381. 

  381.                   $pt = "+" . $pt;

    382. 

  382.               $qry_tmonth->added = "<code> (" . $pt . "%)</code>";

    383. 

  383.           }

    384. 

  384.           print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";

    385. 

  385.           

    386. 

  386.           //YESTERDAY

    387. 

  387.           $qry_y = $wpdb->get_row("

    388. 

  388.     SELECT count(DISTINCT ip) AS visitors

    389. 

  389.     FROM $table_name

    390. 

  390.     WHERE feed=''

    391. 

  391.     AND spider=''

    392. 

  392.     AND date = '" . mysql_real_escape_string($yesterday) . "'

    393. 

  393.   ");

    394. 

  394.           print "<td>" . $qry_y->visitors . "</td>\n";

    395. 

  395.           

    396. 

  396.           //TODAY

    397. 

  397.           $qry_t = $wpdb->get_row("

    398. 

  398.     SELECT count(DISTINCT ip) AS visitors

    399. 

  399.     FROM $table_name

    400. 

  400.     WHERE feed=''

    401. 

  401.     AND spider=''

    402. 

  402.     AND date = '" . mysql_real_escape_string($today) . "'

    403. 

  403.   ");

    404. 

  404.           print "<td>" . $qry_t->visitors . "</td>\n";

    405. 

  405.           print "</tr>";

    406. 

  406.           

    407. 

  407.           //###############################################################################################

    408. 

  408.           // PAGEVIEWS ROW

    409. 

  409.           print "<tr><td><div style='background:$web_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>" . __('Pageviews', 'statpress') . "</td>";

    410. 

  410.           

    411. 

  411.           //TOTAL

    412. 

  412.           $qry_total = $wpdb->get_row("

    413. 

  413.     SELECT count(date) as pageview

    414. 

  414.     FROM $table_name

    415. 

  415.     WHERE feed=''

    416. 

  416.     AND spider=''

    417. 

  417.   ");

    418. 

  418.           print "<td>" . $qry_total->pageview . "</td>\n";

    419. 

  419.           

    420. 

  420.           //LAST MONTH

    421. 

  421.           $prec = 0;

    422. 

  422.           $qry_lmonth = $wpdb->get_row("

    423. 

  423.     SELECT count(date) as pageview

    424. 

  424.     FROM $table_name

    425. 

  425.     WHERE feed=''

    426. 

  426.     AND spider=''

    427. 

  427.     AND date LIKE '" . mysql_real_escape_string($lastmonth) . "%'

    428. 

  428.   ");

    429. 

  429.           print "<td>" . $qry_lmonth->pageview . "</td>\n";

    430. 

  430.           

    431. 

  431.           //THIS MONTH

    432. 

  432.           $qry_tmonth = $wpdb->get_row("

    433. 

  433.     SELECT count(date) as pageview

    434. 

  434.     FROM $table_name

    435. 

  435.     WHERE feed=''

    436. 

  436.     AND spider=''

    437. 

  437.     AND date LIKE '" . mysql_real_escape_string($thismonth) . "%'

    438. 

  438.   ");

    439. 

  439.           if ($qry_lmonth->pageview <> 0)

    440. 

  440.           {

    441. 

  441.               $pc = round(100 * ($qry_tmonth->pageview / $qry_lmonth->pageview) - 100, 1);

    442. 

  442.               if ($pc >= 0)

    443. 

  443.                   $pc = "+" . $pc;

    444. 

  444.               $qry_tmonth->change = "<code> (" . $pc . "%)</code>";

    445. 

  445.           }

    446. 

  446.           print "<td>" . $qry_tmonth->pageview . $qry_tmonth->change . "</td>\n";

    447. 

  447.           

    448. 

  448.           //TARGET

    449. 

  449.           $qry_tmonth->target = round($qry_tmonth->pageview / (time() - mktime(0,0,0,date('m'),date('1'),date('Y'))) * (86400 * date('t')));

    450. 

  450.           if ($qry_lmonth->pageview <> 0)

    451. 

  451.           {

    452. 

  452.               $pt = round(100 * ($qry_tmonth->target / $qry_lmonth->pageview) - 100, 1);

    453. 

  453.               if ($pt >= 0)

    454. 

  454.                   $pt = "+" . $pt;

    455. 

  455.               $qry_tmonth->added = "<code> (" . $pt . "%)</code>";

    456. 

  456.           }

    457. 

  457.           print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";

    458. 

  458.           

    459. 

  459.           //YESTERDAY

    460. 

  460.           $qry_y = $wpdb->get_row("

    461. 

  461.     SELECT count(date) as pageview

    462. 

  462.     FROM $table_name

    463. 

  463.     WHERE feed=''

    464. 

  464.     AND spider=''

    465. 

  465.     AND date = '" . mysql_real_escape_string($yesterday) . "'

    466. 

  466.   ");

    467. 

  467.           print "<td>" . $qry_y->pageview . "</td>\n";

    468. 

  468.           

    469. 

  469.           //TODAY

    470. 

  470.           $qry_t = $wpdb->get_row("

    471. 

  471.     SELECT count(date) as pageview

    472. 

  472.     FROM $table_name

    473. 

  473.     WHERE feed=''

    474. 

  474.     AND spider=''

    475. 

  475.     AND date = '" . mysql_real_escape_string($today) . "'

    476. 

  476.   ");

    477. 

  477.           print "<td>" . $qry_t->pageview . "</td>\n";

    478. 

  478.           print "</tr>";

    479. 

  479.           //###############################################################################################

    480. 

  480.           // SPIDERS ROW

    481. 

  481.           print "<tr><td><div style='background:$spider_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>" . __('Spiders', 'statpress') . "</td>";

    482. 

  482.           //TOTAL

    483. 

  483.           $qry_total = $wpdb->get_row("

    484. 

  484.     SELECT count(date) as spiders

    485. 

  485.     FROM $table_name

    486. 

  486.     WHERE feed=''

    487. 

  487.     AND spider<>''

    488. 

  488.   ");

    489. 

  489.           print "<td>" . $qry_total->spiders . "</td>\n";

    490. 

  490.           //LAST MONTH

    491. 

  491.           $prec = 0;

    492. 

  492.           $qry_lmonth = $wpdb->get_row("

    493. 

  493.     SELECT count(date) as spiders

    494. 

  494.     FROM $table_name

    495. 

  495.     WHERE feed=''

    496. 

  496.     AND spider<>''

    497. 

  497.     AND date LIKE '" . mysql_real_escape_string($lastmonth) . "%'

    498. 

  498.   ");

    499. 

  499.           print "<td>" . $qry_lmonth->spiders . "</td>\n";

    500. 

  500.           

    501. 

  501.           //THIS MONTH

    502. 

  502.           $prec = $qry_lmonth->spiders;

    503. 

  503.           $qry_tmonth = $wpdb->get_row("

    504. 

  504.     SELECT count(date) as spiders

    505. 

  505.     FROM $table_name

    506. 

  506.     WHERE feed=''

    507. 

  507.     AND spider<>''

    508. 

  508.     AND date LIKE '" . mysql_real_escape_string($thismonth) . "%'

    509. 

  509.   ");

    510. 

  510.           if ($qry_lmonth->spiders <> 0)

    511. 

  511.           {

    512. 

  512.               $pc = round(100 * ($qry_tmonth->spiders / $qry_lmonth->spiders) - 100, 1);

    513. 

  513.               if ($pc >= 0)

    514. 

  514.                   $pc = "+" . $pc;

    515. 

  515.               $qry_tmonth->change = "<code> (" . $pc . "%)</code>";

    516. 

  516.           }

    517. 

  517.           print "<td>" . $qry_tmonth->spiders . $qry_tmonth->change . "</td>\n";

    518. 

  518.           

    519. 

  519.           //TARGET

    520. 

  520.           $qry_tmonth->target = round($qry_tmonth->spiders / (time() - mktime(0,0,0,date('m'),date('1'),date('Y'))) * (86400 * date('t')));

    521. 

  521.           if ($qry_lmonth->spiders <> 0)

    522. 

  522.           {

    523. 

  523.               $pt = round(100 * ($qry_tmonth->target / $qry_lmonth->spiders) - 100, 1);

    524. 

  524.               if ($pt >= 0)

    525. 

  525.                   $pt = "+" . $pt;

    526. 

  526.               $qry_tmonth->added = "<code> (" . $pt . "%)</code>";

    527. 

  527.           }

    528. 

  528.           print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";

    529. 

  529.           

    530. 

  530.           //YESTERDAY

    531. 

  531.           $qry_y = $wpdb->get_row("

    532. 

  532.     SELECT count(date) as spiders

    533. 

  533.     FROM $table_name

    534. 

  534.     WHERE feed=''

    535. 

  535.     AND spider<>''

    536. 

  536.     AND date = '" . mysql_real_escape_string($yesterday) . "'

    537. 

  537.   ");

    538. 

  538.           print "<td>" . $qry_y->spiders . "</td>\n";

    539. 

  539.           

    540. 

  540.           //TODAY

    541. 

  541.           $qry_t = $wpdb->get_row("

    542. 

  542.     SELECT count(date) as spiders

    543. 

  543.     FROM $table_name

    544. 

  544.     WHERE feed=''

    545. 

  545.     AND spider<>''

    546. 

  546.     AND date = '" . mysql_real_escape_string($today) . "'

    547. 

  547.   ");

    548. 

  548.           print "<td>" . $qry_t->spiders . "</td>\n";

    549. 

  549.           print "</tr>";

    550. 

  550.           //###############################################################################################

    551. 

  551.           // FEEDS ROW

    552. 

  552.           print "<tr><td><div style='background:$rss_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>" . __('Feeds', 'statpress') . "</td>";

    553. 

  553.           //TOTAL

    554. 

  554.           $qry_total = $wpdb->get_row("

    555. 

  555.     SELECT count(date) as feeds

    556. 

  556.     FROM $table_name

    557. 

  557.     WHERE feed<>''

    558. 

  558.     AND spider=''

    559. 

  559.   ");

    560. 

  560.           print "<td>" . $qry_total->feeds . "</td>\n";

    561. 

  561.           

    562. 

  562.           //LAST MONTH

    563. 

  563.           $qry_lmonth = $wpdb->get_row("

    564. 

  564.     SELECT count(date) as feeds

    565. 

  565.     FROM $table_name

    566. 

  566.     WHERE feed<>''

    567. 

  567.     AND spider=''

    568. 

  568.     AND date LIKE '" . mysql_real_escape_string($lastmonth) . "%'

    569. 

  569.   ");

    570. 

  570.           print "<td>" . $qry_lmonth->feeds . "</td>\n";

    571. 

  571.           

    572. 

  572.           //THIS MONTH

    573. 

  573.           $qry_tmonth = $wpdb->get_row("

    574. 

  574.     SELECT count(date) as feeds

    575. 

  575.     FROM $table_name

    576. 

  576.     WHERE feed<>''

    577. 

  577.     AND spider=''

    578. 

  578.     AND date LIKE '" . mysql_real_escape_string($thismonth) . "%'

    579. 

  579.   ");

    580. 

  580.           if ($qry_lmonth->feeds <> 0)

    581. 

  581.           {

    582. 

  582.               $pc = round(100 * ($qry_tmonth->feeds / $qry_lmonth->feeds) - 100, 1);

    583. 

  583.               if ($pc >= 0)

    584. 

  584.                   $pc = "+" . $pc;

    585. 

  585.               $qry_tmonth->change = "<code> (" . $pc . "%)</code>";

    586. 

  586.           }

    587. 

  587.           print "<td>" . $qry_tmonth->feeds . $qry_tmonth->change . "</td>\n";

    588. 

  588.           

    589. 

  589.           //TARGET

    590. 

  590.           $qry_tmonth->target = round($qry_tmonth->feeds / (time() - mktime(0,0,0,date('m'),date('1'),date('Y'))) * (86400 * date('t')));

    591. 

  591.           if ($qry_lmonth->feeds <> 0)

    592. 

  592.           {

    593. 

  593.               $pt = round(100 * ($qry_tmonth->target / $qry_lmonth->feeds) - 100, 1);

    594. 

  594.               if ($pt >= 0)

    595. 

  595.                   $pt = "+" . $pt;

    596. 

  596.               $qry_tmonth->added = "<code> (" . $pt . "%)</code>";

    597. 

  597.           }

    598. 

  598.           print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";

    599. 

  599.           

    600. 

  600.           $qry_y = $wpdb->get_row("

    601. 

  601.     SELECT count(date) as feeds

    602. 

  602.     FROM $table_name

    603. 

  603.     WHERE feed<>''

    604. 

  604.     AND spider=''

    605. 

  605.     AND date = '" . mysql_real_escape_string($yesterday) . "'

    606. 

  606.   ");

    607. 

  607.           print "<td>" . $qry_y->feeds . "</td>\n";

    608. 

  608.           

    609. 

  609.           $qry_t = $wpdb->get_row("

    610. 

  610.     SELECT count(date) as feeds

    611. 

  611.     FROM $table_name

    612. 

  612.     WHERE feed<>''

    613. 

  613.     AND spider=''

    614. 

  614.     AND date = '" . mysql_real_escape_string($today) . "'

    615. 

  615.   ");

    616. 

  616.           print "<td>" . $qry_t->feeds . "</td>\n";

    617. 

  617.           

    618. 

  618.           print "</tr></table><br />\n\n";

    619. 

  619.           

    620. 

  620.           //###############################################################################################

    621. 

  621.           //###############################################################################################

    622. 

  622.           // THE GRAPHS

    623. 

  623.           

    624. 

  624.           // last "N" days graph  NEW

    625. 

  625.           $gdays = get_option('statpress_daysinoverviewgraph');

    626. 

  626.           if ($gdays == 0)

    627. 

  627.           {

    628. 

  628.               $gdays = 20;

    629. 

  629.           }

    630. 

  630.           //  $start_of_week = get_settings('start_of_week');

    631. 

  631.           $start_of_week = get_option('start_of_week');

    632. 

  632.           print '<table width="100%" border="0"><tr>';

    633. 

  633.           $qry = $wpdb->get_row("

    634. 

  634.     SELECT count(date) as pageview, date

    635. 

  635.     FROM $table_name

    636. 

  636.     GROUP BY date HAVING date >= '" . gmdate('Ymd', current_time('timestamp') - 86400 * $gdays) . "'

    637. 

  637.     ORDER BY pageview DESC

    638. 

  638.     LIMIT 1

    639. 

  639.   ");

    640. 

  640.           $maxxday = $qry->pageview;

    641. 

  641.           if ($maxxday == 0)

    642. 

  642.           {

    643. 

  643.               $maxxday = 1;

    644. 

  644.           }

    645. 

  645.           // Y

    646. 

  646.           $gd = (90 / $gdays) . '%';

    647. 

  647.           for ($gg = $gdays - 1; $gg >= 0; $gg--)

    648. 

  648.           {

    649. 

  649.               //TOTAL VISITORS

    650. 

  650.               $qry_visitors = $wpdb->get_row("

    651. 

  651.       SELECT count(DISTINCT ip) AS total

    652. 

  652.       FROM $table_name

    653. 

  653.       WHERE feed=''

    654. 

  654.       AND spider=''

    655. 

  655.       AND date = '" . gmdate('Ymd', current_time('timestamp') - 86400 * $gg) . "'

    656. 

  656.     ");

    657. 

  657.               $px_visitors = round($qry_visitors->total * 100 / $maxxday);

    658. 

  658.               

    659. 

  659.               //TOTAL PAGEVIEWS (we do not delete the uniques, this is falsing the info.. uniques are not different visitors!)

    660. 

  660.               $qry_pageviews = $wpdb->get_row("

    661. 

  661.       SELECT count(date) as total

    662. 

  662.       FROM $table_name

    663. 

  663.       WHERE feed=''

    664. 

  664.       AND spider=''

    665. 

  665.       AND date = '" . gmdate('Ymd', current_time('timestamp') - 86400 * $gg) . "'

    666. 

  666.     ");

    667. 

  667.               $px_pageviews = round($qry_pageviews->total * 100 / $maxxday);

    668. 

  668.               

    669. 

  669.               //TOTAL SPIDERS

    670. 

  670.               $qry_spiders = $wpdb->get_row("

    671. 

  671.       SELECT count(ip) AS total

    672. 

  672.       FROM $table_name

    673. 

  673.       WHERE feed=''

    674. 

  674.       AND spider<>''

    675. 

  675.       AND date = '" . gmdate('Ymd', current_time('timestamp') - 86400 * $gg) . "'

    676. 

  676.     ");

    677. 

  677.               $px_spiders = round($qry_spiders->total * 100 / $maxxday);

    678. 

  678.               

    679. 

  679.               //TOTAL FEEDS

    680. 

  680.               $qry_feeds = $wpdb->get_row("

    681. 

  681.       SELECT count(ip) AS total

    682. 

  682.       FROM $table_name

    683. 

  683.       WHERE feed<>''

    684. 

  684.       AND spider=''

    685. 

  685.       AND date = '" . gmdate('Ymd', current_time('timestamp') - 86400 * $gg) . "'

    686. 

  686.     ");

    687. 

  687.               $px_feeds = round($qry_feeds->total * 100 / $maxxday);

    688. 

  688.               

    689. 

  689.               $px_white = 100 - $px_feeds - $px_spiders - $px_pageviews - $px_visitors;

    690. 

  690.               

    691. 

  691.               print '<td width="' . $gd . '" valign="bottom"';

    692. 

  692.               if ($start_of_week == gmdate('w', current_time('timestamp') - 86400 * $gg))

    693. 

  693.               {

    694. 

  694.                   print ' style="border-left:2px dotted gray;"';

    695. 

  695.               }

    696. 

  696.               // week-cut

    697. 

  697.               print "><div style='float:left;height: 100%;width:100%;font-family:Helvetica;font-size:7pt;text-align:center;border-right:1px solid white;color:black;'>

    698. 

  698.     <div style='background:#ffffff;width:100%;height:" . $px_white . "px;'></div>

    699. 

  699.     <div style='background:$unique_color;width:100%;height:" . $px_visitors . "px;' title='" . $qry_visitors->total . " " . __('visitors', 'statpress')."'></div>

    700. 

  700.     <div style='background:$web_color;width:100%;height:" . $px_pageviews . "px;' title='" . $qry_pageviews->total . " " . __('pageviews', 'statpress')."'></div>

    701. 

  701.     <div style='background:$spider_color;width:100%;height:" . $px_spiders . "px;' title='" . $qry_spiders->total . " " . __('spiders', 'statpress')."'></div>

    702. 

  702.     <div style='background:$rss_color;width:100%;height:" . $px_feeds . "px;' title='" . $qry_feeds->total . " " . __('feeds', 'statpress')."'></div>

    703. 

  703.     <div style='background:gray;width:100%;height:1px;'></div>

    704. 

  704.     <br />" . gmdate('d', current_time('timestamp') - 86400 * $gg) . ' ' . gmdate('M', current_time('timestamp') - 86400 * $gg) . "</div></td>\n";

    705. 

  705.           }

    706. 

  706.           print '</tr></table>';

    707. 

  707.           

    708. 

  708.           print '</div>';

    709. 

  709.           // END OF OVERVIEW

    710. 

  710.           //###################################################################################################

    711. 

  711.           

    712. 

  712.           

    713. 

  713.           

    714. 

  714.           

    715. 

  715.           $querylimit = "LIMIT 20";

    716. 

  716.           

    717. 

  717.           // Tabella Last hits

    718. 

  718.           print "<div class='wrap'><h2>" . __('Last hits', 'statpress') . "</h2><table class='widefat'><thead><tr><th scope='col'>" . __('Date', 'statpress') . "</th><th scope='col'>" . __('Time', 'statpress') . "</th><th scope='col'>" . __('IP', 'statpress') . "</th><th scope='col'>" . __('Threat', 'statpress') . "</th><th scope='col'>" . __('Domain', 'statpress') . "</th><th scope='col'>" . __('Page', 'statpress') . "</th><th scope='col'>" . __('OS', 'statpress') . "</th><th scope='col'>" . __('Browser', 'statpress') . "</th><th scope='col'>" . __('Feed', 'statpress') . "</th></tr></thead>";

    719. 

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

    720. 

  720.           

    721. 

  721.           $fivesdrafts = $wpdb->get_results("SELECT * FROM $table_name WHERE (os<>'' OR feed<>'') order by id DESC $querylimit");

    722. 

  722.           foreach ($fivesdrafts as $fivesdraft)

    723. 

  723.           {

    724. 

  724.               print "<tr>";

    725. 

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

    726. 

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

    727. 

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

    728. 

  728.               print "<td>" . $fivesdraft->threat_score;

    729. 

  729.               if ($fivesdraft->threat_score > 0)

    730. 

  730.               {

    731. 

  731.                   print "/";

    732. 

  732.                   if ($fivesdraft->threat_type == 0)

    733. 

  733.                       print "Sp"; // Spider

    734. 

  734.                   else

    735. 

  735.                   {

    736. 

  736.                       if (($fivesdraft->threat_type & 1) == 1)

    737. 

  737.                           print "S"; // Suspicious

    738. 

  738.                       if (($fivesdraft->threat_type & 2) == 2)

    739. 

  739.                           print "H"; // Harvester

    740. 

  740.                       if (($fivesdraft->threat_type & 4) == 4)

    741. 

  741.                           print "C"; // Comment spammer

    742. 

  742.                   }

    743. 

  743.               }

    744. 

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

    745. 

  745.               print "<td>" . iri_StatPress_Abbrevia(iri_StatPress_Decode($fivesdraft->urlrequested), 30) . "</td>";

    746. 

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

    747. 

  747.               print "<td>" . $fivesdraft->browser . "</td>";

    748. 

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

    749. 

  749.               print "</tr>";

    750. 

  750.           }

    751. 

  751.           print "</table></div>";

    752. 

  752.           

    753. 

  753.           

    754. 

  754.           // Last Search terms

    755. 

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

    756. 

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

    757. 

  757.           $qry = $wpdb->get_results("SELECT date,time,referrer,urlrequested,search,searchengine FROM $table_name WHERE search<>'' ORDER BY id DESC $querylimit");

    758. 

  758.           foreach ($qry as $rk)

    759. 

  759.           {

    760. 

  760.               print "<tr><td>" . irihdate($rk->date) . "</td><td>" . $rk->time . "</td><td><a href='" . $rk->referrer . "'>" . urldecode($rk->search) . "</a></td><td>" . $rk->searchengine . "</td><td><a href='" . irigetblogurl() . ((strpos($rk->urlrequested, 'index.php') === FALSE) ? $rk->urlrequested : '') . "'>" . __('page viewed', 'statpress') . "</a></td></tr>\n";

    761. 

  761.           }

    762. 

  762.           print "</table></div>";

    763. 

  763.           

    764. 

  764.           // Referrer

    765. 

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

    766. 

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

    767. 

  767.           $qry = $wpdb->get_results("SELECT date,time,referrer,urlrequested FROM $table_name WHERE ((referrer NOT LIKE '" . get_option('home') . "%') AND (referrer <>'') AND (searchengine='')) ORDER BY id DESC $querylimit");

    768. 

  768.           foreach ($qry as $rk)

    769. 

  769.           {

    770. 

  770.               print "<tr><td>" . irihdate($rk->date) . "</td><td>" . $rk->time . "</td><td><a href='" . $rk->referrer . "'>" . iri_StatPress_Abbrevia($rk->referrer, 80) . "</a></td><td><a href='" . irigetblogurl() . ((strpos($rk->urlrequested, 'index.php') === FALSE) ? $rk->urlrequested : '') . "'>" . __('page viewed', 'statpress') . "</a></td></tr>\n";

    771. 

  771.           }

    772. 

  772.           print "</table></div>";

    773. 

  773.           

    774. 

  774.           // Last Agents

    775. 

  775.           print "<div class='wrap'><h2>" . __('Last agents', 'statpress') . "</h2><table class='widefat'><thead><tr><th scope='col'>" . __('Date', 'statpress') . "</th><th scope='col'>" . __('Time', 'statpress') . "</th><th scope='col'>" . __('Agent', 'statpress') . "</th><th scope='col'>" . __('What', 'statpress') . "</th></tr></thead>";

    776. 

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

    777. 

  777.           $qry = $wpdb->get_results("SELECT date,time,agent,os,browser,spider FROM $table_name WHERE (agent <>'') ORDER BY id DESC $querylimit");

    778. 

  778.           foreach ($qry as $rk)

    779. 

  779.           {

    780. 

  780.               print "<tr><td>" . irihdate($rk->date) . "</td><td>" . $rk->time . "</td><td>" . $rk->agent . "</td><td> " . $rk->os . " " . $rk->browser . " " . $rk->spider . "</td></tr>\n";

    781. 

  781.           }

    782. 

  782.           print "</table></div>";

    783. 

  783.           

    784. 

  784.           // Last pages

    785. 

  785.           print "<div class='wrap'><h2>" . __('Last pages', 'statpress') . "</h2><table class='widefat'><thead><tr><th scope='col'>" . __('Date', 'statpress') . "</th><th scope='col'>" . __('Time', 'statpress') . "</th><th scope='col'>" . __('Page', 'statpress') . "</th><th scope='col'>" . __('What', 'statpress') . "</th></tr></thead>";

    786. 

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

    787. 

  787.           $qry = $wpdb->get_results("SELECT date,time,urlrequested,os,browser,spider FROM $table_name WHERE (spider='' AND feed='') ORDER BY id DESC $querylimit");

    788. 

  788.           foreach ($qry as $rk)

    789. 

  789.           {

    790. 

  790.               print "<tr><td>" . irihdate($rk->date) . "</td><td>" . $rk->time . "</td><td>" . iri_StatPress_Abbrevia(iri_StatPress_Decode($rk->urlrequested), 60) . "</td><td> " . $rk->os . " " . $rk->browser . " " . $rk->spider . "</td></tr>\n";

    791. 

  791.           }

    792. 

  792.           print "</table></div>";

    793. 

  793.           

    794. 

  794.           // Last Spiders

    795. 

  795.           print "<div class='wrap'><h2>" . __('Last spiders', 'statpress') . "</h2>";

    796. 

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

    797. 

  797.           print "<th scope='col'>" . __('Date', 'statpress') . "</th>";

    798. 

  798.           print "<th scope='col'>" . __('Time', 'statpress') . "</th>";

    799. 

  799.           print "<th scope='col'>" . __('Spider', 'statpress') . "</th>";

    800. 

  800.           print "<th scope='col'>" . __('Page', 'statpress') . "</th>";

    801. 

  801.           print "<th scope='col'>" . __('Agent', 'statpress') . "</th>";

    802. 

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

    803. 

  803.           $qry = $wpdb->get_results("SELECT date,time,agent,spider,urlrequested,agent FROM $table_name WHERE (spider<>'') ORDER BY id DESC $querylimit");

    804. 

  804.           foreach ($qry as $rk)

    805. 

  805.           {

    806. 

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

    807. 

  807.               print "<td>" . $rk->time . "</td>";

    808. 

  808.               print "<td>" . $rk->spider . "</td>";

    809. 

  809.               print "<td>" . iri_StatPress_Abbrevia(iri_StatPress_Decode($rk->urlrequested), 30) . "</td>";

    810. 

  810.               print "<td> " . $rk->agent . "</td></tr>\n";

    811. 

  811.           }

    812. 

  812.           print "</table></div>";

    813. 

  813.           

    814. 

  814.           

    815. 

  815.           print "<br />";

    816. 

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

    817. 

  817.           print "&nbsp;<i>" . __('StatPress current time', 'statpress') . ": <b>" . current_time('mysql') . "</b></i><br />";

    818. 

  818.           print "&nbsp;<i>" . __('RSS2 url', 'statpress') . ": <b>" . get_bloginfo('rss2_url') . ' (' . iri_StatPress_extractfeedreq(get_bloginfo('rss2_url')) . ")</b></i><br />";

    819. 

  819.           print "&nbsp;<i>" . __('ATOM url', 'statpress') . ": <b>" . get_bloginfo('atom_url') . ' (' . iri_StatPress_extractfeedreq(get_bloginfo('atom_url')) . ")</b></i><br />";

    820. 

  820.           print "&nbsp;<i>" . __('RSS url', 'statpress') . ": <b>" . get_bloginfo('rss_url') . ' (' . iri_StatPress_extractfeedreq(get_bloginfo('rss_url')) . ")</b></i><br />";

    821. 

  821.           print "&nbsp;<i>" . __('COMMENT RSS2 url', 'statpress') . ": <b>" . get_bloginfo('comments_rss2_url') . ' (' . iri_StatPress_extractfeedreq(get_bloginfo('comments_rss2_url')) . ")</b></i><br />";

    822. 

  822.           print "&nbsp;<i>" . __('COMMENT ATOM url', 'statpress') . ": <b>" . get_bloginfo('comments_atom_url') . ' (' . iri_StatPress_extractfeedreq(get_bloginfo('comments_atom_url')) . ")</b></i><br />";

    823. 

  823.       }

    824. 

  824.       

    825. 

  825.       function iriStatPressDetails()

    826. 

  826.       {

    827. 

  827.           global $wpdb;

    828. 

  828.           $table_name = $wpdb->prefix . "statpress";

    829. 

  829.           

    830. 

  830.           $querylimit = "LIMIT 10";

    831. 

  831.           

    832. 

  832.           // Top days

    833. 

  833.           iriValueTable("date", __('Top days', 'statpress'), 5);

    834. 

  834.           

    835. 

  835.           // O.S.

    836. 

  836.           iriValueTable("os", __('O.S.', 'statpress'), 0, "", "", "AND feed='' AND spider='' AND os<>''");

    837. 

  837.           

    838. 

  838.           // Browser

    839. 

  839.           iriValueTable("browser", __('Browser', 'statpress'), 0, "", "", "AND feed='' AND spider='' AND browser<>''");

    840. 

  840.           

    841. 

  841.           // Feeds

    842. 

  842.           iriValueTable("feed", __('Feeds', 'statpress'), 5, "", "", "AND feed<>''");

    843. 

  843.           

    844. 

  844.           // SE

    845. 

  845.           iriValueTable("searchengine", __('Search engines', 'statpress'), 10, "", "", "AND searchengine<>''");

    846. 

  846.           

    847. 

  847.           // Search terms

    848. 

  848.           iriValueTable("search", __('Top search terms', 'statpress'), 20, "", "", "AND search<>''");

    849. 

  849.           

    850. 

  850.           // Top referrer

    851. 

  851.           iriValueTable("referrer", __('Top referrer', 'statpress'), 10, "", "", "AND referrer<>'' AND referrer NOT LIKE '%" . get_bloginfo('url') . "%'");

    852. 

  852.           

    853. 

  853.           // Countries

    854. 

  854.           iriValueTable("nation", __('Countries (domains)', 'statpress'), 10, "", "", "AND nation<>'' AND spider=''");

    855. 

  855.           

    856. 

  856.           // Spider

    857. 

  857.           iriValueTable("spider", __('Spiders', 'statpress'), 10, "", "", "AND spider<>''");

    858. 

  858.           

    859. 

  859.           // Top Pages

    860. 

  860.           iriValueTable("urlrequested", __('Top pages', 'statpress'), 5, "", "urlrequested", "AND feed='' and spider=''");

    861. 

  861.           

    862. 

  862.           

    863. 

  863.           // Top Days - Unique visitors

    864. 

  864.           iriValueTable("date", __('Top Days - Unique visitors', 'statpress'), 5, "distinct", "ip", "AND feed='' and spider=''");

    865. 

  865.           /* Maddler 04112007: required patching iriValueTable */

    866. 

  866.           

    867. 

  867.           // Top Days - Pageviews

    868. 

  868.           iriValueTable("date", __('Top Days - Pageviews', 'statpress'), 5, "", "urlrequested", "AND feed='' and spider=''");

    869. 

  869.           /* Maddler 04112007: required patching iriValueTable */

    870. 

  870.           

    871. 

  871.           // Top IPs - Pageviews

    872. 

  872.           iriValueTable("ip", __('Top IPs - Pageviews', 'statpress'), 5, "", "urlrequested", "AND feed='' and spider=''");

    873. 

  873.           /* Maddler 04112007: required patching iriValueTable */

    874. 

  874.       }

    875. 

  875.       

    876. 

  876.       

    877. 

  877.       function iriStatPressSpy()

    878. 

  878.       {

    879. 

  879.           global $wpdb;

    880. 

  880.           $table_name = $wpdb->prefix . "statpress";

    881. 

  881.           

    882. 

  882.           $LIMIT = 20;

    883. 

  883.           

    884. 

  884.           if(isset($_GET['pn']))

    885. 

  885.           {

    886. 

  886.           	// Get Current page from URL

    887. 

  887.           	$page = $_GET['pn'];

    888. 

  888.           	if($page <= 0)

    889. 

  889.           	{

    890. 

  890.           		// Page is less than 0 then set it to 1

    891. 

  891.           		$page = 1;

    892. 

  892.           	}

    893. 

  893.           }

    894. 

  894.           else

    895. 

  895.           {

    896. 

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

    897. 

  897.           	$page = 1;

    898. 

  898.           }

    899. 

  899.           

    900. 

  900.           	// Create MySQL Query String

    901. 

  901. 			$strqry = "SELECT id FROM $table_name WHERE (spider='' AND feed='') GROUP BY ip";

    902. 

  902. 			$query = $wpdb->get_results($strqry);

    903. 

  903. 			$TOTALROWS = $wpdb->num_rows;

    904. 

  904. 			$NumOfPages = $TOTALROWS / $LIMIT;

    905. 

  905. 			$LimitValue = ($page * $LIMIT) - $LIMIT;

    906. 

  906. 			

    907. 

  907. 			

    908. 

  908.           // Spy

    909. 

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

    910. 

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

    911. 

  911.           print "<div class='wrap'><h2>" . __('Spy', 'statpress') . "</h2>";

    912. 

  912.           $sql = "SELECT ip,nation,os,browser,agent FROM $table_name WHERE (spider='' AND feed='') GROUP BY ip ORDER BY id DESC LIMIT $LimitValue, $LIMIT";

    913. 

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

    914. 

  914. ?>

    915. 

  915. <script>

    916. 

  916. function ttogle(thediv){

    917. 

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

    918. 

  918. document.getElementById(thediv).style.display="none"

    919. 

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

    920. 

  920. }

    921. 

  921. </script>

    922. 

  922. <div align="center">

    923. 

  923. <div id="paginating" align="center">Pages:

    924. 

  924. <?php

    925. 

  925. 

    926. 

  926. // Check to make sure we&#x2019;re not on page 1 or Total number of pages is not 1

    927. 

  927. if($page == ceil($NumOfPages) && $page != 1) {

    928. 

  928.   for($i = 1; $i <= ceil($NumOfPages)-1; $i++) {

    929. 

  929.     // Loop through the number of total pages

    930. 

  930.     if($i > 0) {

    931. 

  931.       // if $i greater than 0 display it as a hyperlink

    932. 

  932.       echo '<a href="' . $_SERVER['SCRIPT_NAME'] . '?page=statpress-reloaded/statpress.php&statpress_action=spy&pn=' . $i . '">' . $i . '</a> ';

    933. 

  933.       }

    934. 

  934.     }

    935. 

  935. }

    936. 

  936. if($page == ceil($NumOfPages) ) {

    937. 

  937.   $startPage = $page;

    938. 

  938. } else {

    939. 

  939.   $startPage = 1;

    940. 

  940. }

    941. 

  941. for ($i = $startPage; $i <= $page+6; $i++) {

    942. 

  942.   // Display first 7 pages

    943. 

  943.   if ($i <= ceil($NumOfPages)) {

    944. 

  944.     // $page is not the last page

    945. 

  945.     if($i == $page) {

    946. 

  946.       // $page is current page

    947. 

  947.       echo " [{$i}] ";

    948. 

  948.     } else {

    949. 

  949.       // Not the current page Hyperlink them

    950. 

  950.       echo '<a href="' . $_SERVER['SCRIPT_NAME'] . '?page=statpress-reloaded/statpress.php&statpress_action=spy&pn=' . $i . '">' . $i . '</a> ';

    951. 

  951.     }

    952. 

  952.   }

    953. 

  953. }

    954. 

  954. ?>

    955. 

  955. </div>

    956. 

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

    957. 

  957. <?php

    958. 

  958.           foreach ($qry as $rk)

    959. 

  959.           {

    960. 

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

    961. 

  961.               print "<IMG SRC='http://api.hostip.info/flag.php?ip=" . $rk->ip . "' border=0 width=18 height=12>";

    962. 

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

    963. 

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

    964. 

  964.               print "<div id='" . $rk->ip . "' name='" . $rk->ip . "'>" . $rk->os . ", " . $rk->browser;

    965. 

  965.               //    print "<br><iframe style='overflow:hide;border:0px;width:100%;height:15px;font-family:helvetica;paddng:0;' scrolling='no' marginwidth=0 marginheight=0 src=http://showip.fakap.net/txt/".$rk->ip."></iframe>";

    966. 

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

    967. 

  967.               if ($rk->nation)

    968. 

  968.               {

    969. 

  969.                   print "<br><small>" . gethostbyaddr($rk->ip) . "</small>";

    970. 

  970.               }

    971. 

  971.               print "<br><small>" . $rk->agent . "</small>";

    972. 

  972.               print "</div>";

    973. 

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

    974. 

  974.               print "</td></tr>";

    975. 

  975.               $qry2 = $wpdb->get_results("SELECT * FROM $table_name WHERE ip='" . $rk->ip . "' AND (date BETWEEN '$yesterday' AND '$today') order by id LIMIT 10");

    976. 

  976.               foreach ($qry2 as $details)

    977. 

  977.               {

    978. 

  978.                   print "<tr>";

    979. 

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

    980. 

  980.                   print "<td><div><a href='" . irigetblogurl() . ((strpos($details->urlrequested, 'index.php') === FALSE) ? $details->urlrequested : '') . "' target='_blank'>" . iri_StatPress_Decode($details->urlrequested) . "</a>";

    981. 

  981.                   if ($details->searchengine != '')

    982. 

  982.                   {

    983. 

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

    984. 

  984.                   }

    985. 

  985.                   elseif ($details->referrer != '' && strpos($details->referrer, get_option('home')) === false)

    986. 

  986.                   {

    987. 

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

    988. 

  988.                   }

    989. 

  989.                   print "</div></td>";

    990. 

  990.                   print "</tr>\n";

    991. 

  991.               }

    992. 

  992.           }

    993. 

  993. ?>

    994. 

  994. </table>

    995. 

  995. </div>

    996. 

  996. <?php

    997. 

  997.       }

    998. 

  998.       

    999. 

  999.       

    1000. 

  1000.       function iriStatPressSearch($what = '')

    1001. 

  1001.       {

    1002. 

  1002.           global $wpdb;

    1003. 

  1003.           $table_name = $wpdb->prefix . "statpress";

    1004. 

  1004.           

    1005. 

  1005.           $f['urlrequested'] = __('URL Requested', 'statpress');

    1006. 

  1006.           $f['agent'] = __('Agent', 'statpress');

    1007. 

  1007.           $f['referrer'] = __('Referrer', 'statpress');

    1008. 

  1008.           $f['search'] = __('Search terms', 'statpress');

    1009. 

  1009.           $f['searchengine'] = __('Search engine', 'statpress');

    1010. 

  1010.           $f['os'] = __('Operative system', 'statpress');

    1011. 

  1011.           $f['browser'] = __('Browser', 'statpress');

    1012. 

  1012.           $f['spider'] = __('Spider', 'statpress');

    1013. 

  1013.           $f['ip'] = __('IP', 'statpress');

    1014. 

  1014. ?>

    1015. 

  1015.   <div class='wrap'><h2><?php

    1016. 

  1016.           _e('Search', 'statpress');

    1017. 

  1017. ?></h2>

    1018. 

  1018.   <form method=get><table>

    1019. 

  1019.   <?php

    1020. 

  1020.           for ($i = 1; $i <= 3; $i++)

    1021. 

  1021.           {

    1022. 

  1022.               print "<tr>";

    1023. 

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

    1024. 

  1024.               foreach (array_keys($f) as $k)

    1025. 

  1025.               {

    1026. 

  1026.                   print "<option value='$k'";

    1027. 

  1027.                   if ($_GET["where$i"] == $k)

    1028. 

  1028.                   {

    1029. 

  1029.                       print " SELECTED ";

    1030. 

  1030.                   }

    1031. 

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

    1032. 

  1032.               }

    1033. 

  1033.               print "</select></td>";

    1034. 

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

    1035. 

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

    1036. 

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

    1037. 

  1037.               print "</tr>";

    1038. 

  1038.           }

    1039. 

  1039. ?>

    1040. 

  1040.   </table>

    1041. 

  1041.   <br>

    1042. 

  1042.   <table>

    1043. 

  1043.   <tr>

    1044. 

  1044.     <td>

    1045. 

  1045.       <table>

    1046. 

  1046.         <tr><td><input type=checkbox name=oderbycount value=checked <?php

    1047. 

  1047.           print $_GET['oderbycount']

    1048. 

  1048. ?>> <?php

    1049. 

  1049.           _e('sort by count if grouped', 'statpress');

    1050. 

  1050. ?></td></tr>

    1051. 

  1051.         <tr><td><input type=checkbox name=spider value=checked <?php

    1052. 

  1052.           print $_GET['spider']

    1053. 

  1053. ?>> <?php

    1054. 

  1054.           _e('include spiders/crawlers/bot', 'statpress');

    1055. 

  1055. ?></td></tr>

    1056. 

  1056.         <tr><td><input type=checkbox name=feed value=checked <?php

    1057. 

  1057.           print $_GET['feed']

    1058. 

  1058. ?>> <?php

    1059. 

  1059.           _e('include feed', 'statpress');

    1060. 

  1060. ?></td></tr>

    1061. 

  1061. <tr><td><input type=checkbox name=distinct value=checked <?php

    1062. 

  1062.           print $_GET['distinct']

    1063. 

  1063. ?>> <?php

    1064. 

  1064.           _e('SELECT DISTINCT', 'statpress');

    1065. 

  1065. ?></td></tr>

    1066. 

  1066.       </table>

    1067. 

  1067.     </td>

    1068. 

  1068.     <td width=15> </td>

    1069. 

  1069.     <td>

    1070. 

  1070.       <table>

    1071. 

  1071.         <tr>

    1072. 

  1072.           <td><?php

    1073. 

  1073.           _e('Limit results to', 'statpress');

    1074. 

  1074. ?>

    1075. 

  1075.             <select name=limitquery><?php

    1076. 

  1076.           if ($_GET['limitquery'] > 0)

    1077. 

  1077.           {

    1078. 

  1078.               print "<option>" . $_GET['limitquery'] . "</option>";

    1079. 

  1079.           }

    1080. 

  1080. ?><option>1</option><option>5</option><option>10</option><option>20</option><option>50</option><option>100</option><option>250</option><option>500</option></select>

    1081. 

  1081.           </td>

    1082. 

  1082.         </tr>

    1083. 

  1083.         <tr><td>&nbsp;</td></tr>

    1084. 

  1084.         <tr>

    1085. 

  1085.           <td align=right><input type=submit value=<?php

    1086. 

  1086.           _e('Search', 'statpress');

    1087. 

  1087. ?> name=searchsubmit></td>

    1088. 

  1088.         </tr>

    1089. 

  1089.       </table>

    1090. 

  1090.     </td>

    1091. 

  1091.   </tr>    

    1092. 

  1092.   </table>  

    1093. 

  1093.   <input type=hidden name=page value='statpress-reloaded/statpress.php'><input type=hidden name=statpress_action value=search>

    1094. 

  1094.   </form><br>

    1095. 

  1095. <?php

    1096. 

  1096.           if (isset($_GET['searchsubmit']))

    1097. 

  1097.           {

    1098. 

  1098.               // query builder

    1099. 

  1099.               $qry = "";

    1100. 

  1100.               // FIELDS

    1101. 

  1101.               $fields = "";

    1102. 

  1102.               for ($i = 1; $i <= 3; $i++)

    1103. 

  1103.               {

    1104. 

  1104.                   if ($_GET["where$i"] != '')

    1105. 

  1105.                   {

    1106. 

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

    1107. 

  1107.                   }

    1108. 

  1108.               }

    1109. 

  1109.               $fields = rtrim($fields, ",");

    1110. 

  1110.               // WHERE

    1111. 

  1111.               $where = "WHERE 1=1";

    1112. 

  1112.               if ($_GET['spider'] != 'checked')

    1113. 

  1113.               {

    1114. 

  1114.                   $where .= " AND spider=''";

    1115. 

  1115.               }

    1116. 

  1116.               if ($_GET['feed'] != 'checked')

    1117. 

  1117.               {

    1118. 

  1118.                   $where .= " AND feed=''";

    1119. 

  1119.               }

    1120. 

  1120.               for ($i = 1; $i <= 3; $i++)

    1121. 

  1121.               {

    1122. 

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

    1123. 

  1123.                   {

    1124. 

  1124.                       $where .= " AND " . $_GET["where$i"] . " LIKE '%" . mysql_real_escape_string($_GET["what$i"]) . "%'";

    1125. 

  1125.                   }

    1126. 

  1126.               }

    1127. 

  1127.               // ORDER BY

    1128. 

  1128.               $orderby = "";

    1129. 

  1129.               for ($i = 1; $i <= 3; $i++)

    1130. 

  1130.               {

    1131. 

  1131.                   if (($_GET["sortby$i"] == 'checked') && ($_GET["where$i"] != ''))

    1132. 

  1132.                   {

    1133. 

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

    1134. 

  1134.                   }

    1135. 

  1135.               }

    1136. 

  1136.               

    1137. 

  1137.               // GROUP BY

    1138. 

  1138.               $groupby = "";

    1139. 

  1139.               for ($i = 1; $i <= 3; $i++)

    1140. 

  1140.               {

    1141. 

  1141.                   if (($_GET["groupby$i"] == 'checked') && ($_GET["where$i"] != ''))

    1142. 

  1142.                   {

    1143. 

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

    1144. 

  1144.                   }

    1145. 

  1145.               }

    1146. 

  1146.               if ($groupby != '')

    1147. 

  1147.               {

    1148. 

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

    1149. 

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

    1150. 

  1150.                   if ($_GET['oderbycount'] == 'checked')

    1151. 

  1151.                   {

    1152. 

  1152.                       $orderby = "totale DESC," . $orderby;

    1153. 

  1153.                   }

    1154. 

  1154.               }

    1155. 

  1155.               

    1156. 

  1156.               if ($orderby != '')

    1157. 

  1157.               {

    1158. 

  1158.                   $orderby = "ORDER BY " . rtrim($orderby, ',');

    1159. 

  1159.               }

    1160. 

  1160.               

    1161. 

  1161.               

    1162. 

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

    1163. 

  1163.               

    1164. 

  1164.               if ($_GET['distinct'] == 'checked')

    1165. 

  1165. {

    1166. 

  1166.    $fields = " DISTINCT " . $fields;

    1167. 

  1167. }

    1168. 

  1168.               

    1169. 

  1169.               // Results

    1170. 

  1170.               print "<h2>" . __('Results', 'statpress') . "</h2>";

    1171. 

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

    1172. 

  1172.               //  print "$sql<br>";

    1173. 

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

    1174. 

  1174.               for ($i = 1; $i <= 3; $i++)

    1175. 

  1175.               {

    1176. 

  1176.                   if ($_GET["where$i"] != '')

    1177. 

  1177.                   {

    1178. 

  1178.                       print "<th scope='col'>" . ucfirst($_GET["where$i"]) . "</th>";

    1179. 

  1179.                   }

    1180. 

  1180.               }

    1181. 

  1181.               if ($groupby != '')

    1182. 

  1182.               {

    1183. 

  1183.                   print "<th scope='col'>" . __('Count', 'statpress') . "</th>";

    1184. 

  1184.               }

    1185. 

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

    1186. 

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

    1187. 

  1187.               foreach ($qry as $rk)

    1188. 

  1188.               {

    1189. 

  1189.                   print "<tr>";

    1190. 

  1190.                   for ($i = 1; $i <= 3; $i++)

    1191. 

  1191.                   {

    1192. 

  1192.                       print "<td>";

    1193. 

  1193.                       if ($_GET["where$i"] == 'urlrequested')

    1194. 

  1194.                       {

    1195. 

  1195.                           print iri_StatPress_Decode($rk[$i - 1]);

    1196. 

  1196.                       }

    1197. 

  1197.                       else

    1198. 

  1198.                       {

    1199. 

  1199.                           print $rk[$i - 1];

    1200. 

  1200.                       }

    1201. 

  1201.                       print "</td>";

    1202. 

  1202.                   }

    1203. 

  1203.                   print "</tr>";

    1204. 

  1204.               }

    1205. 

  1205.               print "</table>";

    1206. 

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

    1207. 

  1207.           }

    1208. 

  1208.       }

    1209. 

  1209.       

    1210. 

  1210.       function iri_StatPress_Abbrevia($s, $c)

    1211. 

  1211.       {

    1212. 

  1212.           $res = "";

    1213. 

  1213.           if (strlen($s) > $c)

    1214. 

  1214.           {

    1215. 

  1215.               $res = "...";

    1216. 

  1216.           }

    1217. 

  1217.           return my_substr($s, 0, $c) . $res;

    1218. 

  1218.       }

    1219. 

  1219.       

    1220. 

  1220.       function iri_StatPress_Where($ip)

    1221. 

  1221.       {

    1222. 

  1222.           $url = "http://api.hostip.info/get_html.php?ip=$ip";

    1223. 

  1223.           $res = file_get_contents($url);

    1224. 

  1224.           if ($res === false)

    1225. 

  1225.           {

    1226. 

  1226.               return(array('', ''));

    1227. 

  1227.           }

    1228. 

  1228.           $res = str_replace("Country: ", "", $res);

    1229. 

  1229.           $res = str_replace("\nCity: ", ", ", $res);

    1230. 

  1230.           $nation = preg_split('/\(|\)/', $res);

    1231. 

  1231.           print "( $ip $res )";

    1232. 

  1232.           return(array($res, $nation[1]));

    1233. 

  1233.       }

    1234. 

  1234.       

    1235. 

  1235.       

    1236. 

  1236.       function iri_StatPress_Decode($out_url)

    1237. 

  1237.       {

    1238. 

  1238.       	if(!permalinksEnabled())

    1239. 

  1239.       	{

    1240. 

  1240. 	          if ($out_url == '')

    1241. 

  1241. 	          {

    1242. 

  1242. 	              $out_url = __('Page', 'statpress') . ": Home";

    1243. 

  1243. 	          }

    1244. 

  1244. 	          if (my_substr($out_url, 0, 4) == "cat=")

    1245. 

  1245. 	          {

    1246. 

  1246. 	              $out_url = __('Category', 'statpress') . ": " . get_cat_name(my_substr($out_url, 4));

    1247. 

  1247. 	          }

    1248. 

  1248. 	          if (my_substr($out_url, 0, 2) == "m=")

    1249. 

  1249. 	          {

    1250. 

  1250. 	              $out_url = __('Calendar', 'statpress') . ": " . my_substr($out_url, 6, 2) . "/" . my_substr($out_url, 2, 4);

    1251. 

  1251. 	          }

    1252. 

  1252. 	          if (my_substr($out_url, 0, 2) == "s=")

    1253. 

  1253. 	          {

    1254. 

  1254. 	              $out_url = __('Search', 'statpress') . ": " . my_substr($out_url, 2);

    1255. 

  1255. 	          }

    1256. 

  1256. 	          if (my_substr($out_url, 0, 2) == "p=")

    1257. 

  1257. 	          {

    1258. 

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

    1259. 

  1259. 	              $out_url = $post_id_7['post_title'];

    1260. 

  1260. 	          }

    1261. 

  1261. 	          if (my_substr($out_url, 0, 8) == "page_id=")

    1262. 

  1262. 	          {

    1263. 

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

    1264. 

  1264. 	              $out_url = __('Page', 'statpress') . ": " . $post_id_7['post_title'];

    1265. 

  1265. 	          }

    1266. 

  1266. 	        }

    1267. 

  1267. 	        else

    1268. 

  1268. 	        {

    1269. 

  1269. 	        	if ($out_url == '')

    1270. 

  1270. 	          {

    1271. 

  1271. 	              $out_url = __('Page', 'statpress') . ": Home";

    1272. 

  1272. 	          }

    1273. 

  1273. 	          else if (my_substr($out_url, 0, 9) == "category/")

    1274. 

  1274. 	          {

    1275. 

  1275. 	              $out_url = __('Category', 'statpress') . ": " . get_cat_name(my_substr($out_url, 9));

    1276. 

  1276. 	          }

    1277. 

  1277. 	          else if (my_substr($out_url, 0, 8) == "//") // not working yet

    1278. 

  1278. 	          {

    1279. 

  1279. 	              //$out_url = __('Calendar', 'statpress') . ": " . my_substr($out_url, 4, 0) . "/" . my_substr($out_url, 6, 7);

    1280. 

  1280. 	          }

    1281. 

  1281. 	          else if (my_substr($out_url, 0, 2) == "s=")

    1282. 

  1282. 	          {

    1283. 

  1283. 	              $out_url = __('Search', 'statpress') . ": " . my_substr($out_url, 2);

    1284. 

  1284. 	          }

    1285. 

  1285. 	          else if (my_substr($out_url, 0, 2) == "p=") // not working yet 

    1286. 

  1286. 	          {

    1287. 

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

    1288. 

  1288. 	              $out_url = $post_id_7['post_title'];

    1289. 

  1289. 	          }

    1290. 

  1290. 	          else if (my_substr($out_url, 0, 8) == "page_id=") // not working yet

    1291. 

  1291. 	          {

    1292. 

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

    1293. 

  1293. 	              $out_url = __('Page', 'statpress') . ": " . $post_id_7['post_title'];

    1294. 

  1294. 	          }

    1295. 

  1295. 	        }

    1296. 

  1296.           return $out_url;

    1297. 

  1297.       }

    1298. 

  1298.       

    1299. 

  1299.       

    1300. 

  1300.       function iri_StatPress_URL()

    1301. 

  1301.       {

    1302. 

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

    1303. 

  1303.           if ($urlRequested == "")

    1304. 

  1304.           {

    1305. 

  1305.               // SEO problem!

    1306. 

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

    1307. 

  1307.           }

    1308. 

  1308.           if (my_substr($urlRequested, 0, 2) == '/?')

    1309. 

  1309.           {

    1310. 

  1310.               $urlRequested = my_substr($urlRequested, 2);

    1311. 

  1311.           }

    1312. 

  1312.           if ($urlRequested == '/')

    1313. 

  1313.           {

    1314. 

  1314.               $urlRequested = '';

    1315. 

  1315.           }

    1316. 

  1316.           return $urlRequested;

    1317. 

  1317.       }

    1318. 

  1318.       

    1319. 

  1319.       function irigetblogurl()

    1320. 

  1320.       {

    1321. 

  1321.       	$prsurl = parse_url(get_bloginfo('url'));

    1322. 

  1322.       	return $prsurl['scheme'] . '://' . $prsurl['host'] . ((!permalinksEnabled()) ? $prsurl['path'] . '/?' : '');

    1323. 

  1323.       }

    1324. 

  1324.       

    1325. 

  1325.       // Converte da data us to default format di Wordpress

    1326. 

  1326.       function irihdate($dt = "00000000")

    1327. 

  1327.       {

    1328. 

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

    1329. 

  1329.       }

    1330. 

  1330.       

    1331. 

  1331.       

    1332. 

  1332.       function iritablesize($table)

    1333. 

  1333.       {

    1334. 

  1334.           global $wpdb;

    1335. 

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

    1336. 

  1336.           foreach ($res as $fstatus)

    1337. 

  1337.           {

    1338. 

  1338.               $data_lenght = $fstatus->Data_length;

    1339. 

  1339.               $data_rows = $fstatus->Rows;

    1340. 

  1340.           }

    1341. 

  1341.           return number_format(($data_lenght / 1024 / 1024), 2, ",", " ") . " MB ($data_rows records)";

    1342. 

  1342.       }

    1343. 

  1343.       

    1344. 

  1344.       

    1345. 

  1345.       function irirgbhex($red, $green, $blue)

    1346. 

  1346.       {

    1347. 

  1347.           $red = 0x10000 * max(0, min(255, $red + 0));

    1348. 

  1348.           $green = 0x100 * max(0, min(255, $green + 0));

    1349. 

  1349.           $blue = max(0, min(255, $blue + 0));

    1350. 

  1350.           // convert the combined value to hex and zero-fill to 6 digits

    1351. 

  1351.           return "#" . str_pad(strtoupper(dechex($red + $green + $blue)), 6, "0", STR_PAD_LEFT);

    1352. 

  1352.       }

    1353. 

  1353.       

    1354. 

  1354.       

    1355. 

  1355.       function iriValueTable($fld, $fldtitle, $limit = 0, $param = "", $queryfld = "", $exclude = "")

    1356. 

  1356.       {

    1357. 

  1357.           /* Maddler 04112007: param addedd */

    1358. 

  1358.           global $wpdb;

    1359. 

  1359.           $table_name = $wpdb->prefix . "statpress";

    1360. 

  1360.           

    1361. 

  1361.           if ($queryfld == '')

    1362. 

  1362.           {

    1363. 

  1363.               $queryfld = $fld;

    1364. 

  1364.           }

    1365. 

  1365.           print "<div class='wrap'><h2>$fldtitle</h2><table style='width:100%;padding:0px;margin:0px;' cellpadding=0 cellspacing=0><thead><tr><th style='width:400px;background-color:white;'></th><th style='width:150px;background-color:white;'><u>" . __('Visits', 'statpress') . "</u></th><th style='background-color:white;'></th></tr></thead>";

    1366. 

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

    1367. 

  1367.           $rks = $wpdb->get_var("SELECT count($param $queryfld) as rks FROM $table_name WHERE 1=1 $exclude;");

    1368. 

  1368.           if ($rks > 0)

    1369. 

  1369.           {

    1370. 

  1370.               $sql = "SELECT count($param $queryfld) as pageview, $fld FROM $table_name WHERE 1=1 $exclude  GROUP BY $fld ORDER BY pageview DESC";

    1371. 

  1371.               if ($limit > 0)

    1372. 

  1372.               {

    1373. 

  1373.                   $sql = $sql . " LIMIT $limit";

    1374. 

  1374.               }

    1375. 

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

    1376. 

  1376.               $tdwidth = 450;

    1377. 

  1377.               $red = 131;

    1378. 

  1378.               $green = 180;

    1379. 

  1379.               $blue = 216;

    1380. 

  1380.               $deltacolor = round(250 / count($qry), 0);

    1381. 

  1381.               //      $chl="";

    1382. 

  1382.               //      $chd="t:";

    1383. 

  1383.               foreach ($qry as $rk)

    1384. 

  1384.               {

    1385. 

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

    1386. 

  1386.                   if ($fld == 'date')

    1387. 

  1387.                   {

    1388. 

  1388.                       $rk->$fld = irihdate($rk->$fld);

    1389. 

  1389.                   }

    1390. 

  1390.                   if ($fld == 'urlrequested')

    1391. 

  1391.                   {

    1392. 

  1392.                       $rk->$fld = iri_StatPress_Decode($rk->$fld);

    1393. 

  1393.                   }

    1394. 

  1394.                   

    1395. 

  1395.                   if ($fld == 'search')

    1396. 

  1396.                   {

    1397. 

  1397.                   	$rk->$fld = urldecode($rk->$fld);

    1398. 

  1398.                   }

    1399. 

  1399.                   

    1400. 

  1400.                   //      $chl.=urlencode(my_substr($rk->$fld,0,50))."|";

    1401. 

  1401.                   //      $chd.=($tdwidth*$pc/100)."|";

    1402. 

  1402.                   print "<tr><td style='width:400px;overflow: hidden; white-space: nowrap; text-overflow: ellipsis;'>" . my_substr($rk->$fld, 0, 50);

    1403. 

  1403.                   if (strlen("$rk->fld") >= 50)

    1404. 

  1404.                   {

    1405. 

  1405.                       print "...";

    1406. 

  1406.                   }

    1407. 

  1407.                   // <td style='text-align:right'>$pc%</td>";

    1408. 

  1408.                   print "</td><td style='text-align:center;'>" . $rk->pageview . "</td>";

    1409. 

  1409.                   print "<td><div style='text-align:right;padding:2px;font-family:helvetica;font-size:7pt;font-weight:bold;height:16px;width:" . number_format(($tdwidth * $pc / 100), 1, '.', '') . "px;background:" . irirgbhex($red, $green, $blue) . ";border-top:1px solid " . irirgbhex($red + 20, $green + 20, $blue) . ";border-right:1px solid " . irirgbhex($red + 30, $green + 30, $blue) . ";border-bottom:1px solid " . irirgbhex($red - 20, $green - 20, $blue) . ";'>$pc%</div>";

    1410. 

  1410.                   print "</td></tr>\n";

    1411. 

  1411.                   $red = $red + $deltacolor;

    1412. 

  1412.                   $blue = $blue - ($deltacolor / 2);

    1413. 

  1413.               }

    1414. 

  1414.           }

    1415. 

  1415.           print "</table>\n";

    1416. 

  1416.           //  $chl=my_substr($chl,0,strlen($chl)-1);

    1417. 

  1417.           //  $chd=my_substr($chd,0,strlen($chd)-1);

    1418. 

  1418.           //  print "<img src=http://chart.apis.google.com/chart?cht=p3&chd=".($chd)."&chs=400x200&chl=".($chl)."&chco=1B75DF,92BF23>\n";

    1419. 

  1419.           print "</div>\n";

    1420. 

  1420.       }

    1421. 

  1421.       

    1422. 

  1422.       

    1423. 

  1423.       

    1424. 

  1424.       function iriDomain($ip)

    1425. 

  1425.       {

    1426. 

  1426.           $host = gethostbyaddr($ip);

    1427. 

  1427.           if (ereg('^([0-9]{1,3}\.){3}[0-9]{1,3}$', $host))

    1428. 

  1428.           {

    1429. 

  1429.               return "";

    1430. 

  1430.           }

    1431. 

  1431.           else

    1432. 

  1432.           {

    1433. 

  1433.               return my_substr(strrchr($host, "."), 1);

    1434. 

  1434.           }

    1435. 

  1435.       }

    1436. 

  1436.       

    1437. 

  1437.       function iriGetQueryPairs($url)

    1438. 

  1438.       {

    1439. 

  1439.           $parsed_url = parse_url($url);

    1440. 

  1440.           $tab = parse_url($url);

    1441. 

  1441.           $host = $tab['host'];

    1442. 

  1442.           if (key_exists("query", $tab))

    1443. 

  1443.           {

    1444. 

  1444.               $query = $tab["query"];

    1445. 

  1445.               $query = str_replace("&amp;", "&", $query);

    1446. 

  1446.               $query = urldecode($query);

    1447. 

  1447.               $query = str_replace("?", "&", $query);

    1448. 

  1448.               return explode("&", $query);

    1449. 

  1449.           }

    1450. 

  1450.           else

    1451. 

  1451.           {

    1452. 

  1452.               return null;

    1453. 

  1453.           }

    1454. 

  1454.       }

    1455. 

  1455.       

    1456. 

  1456.       

    1457. 

  1457.       function iriGetOS($arg)

    1458. 

  1458.       {

    1459. 

  1459.           $arg = str_replace(" ", "", $arg);

    1460. 

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

    1461. 

  1461.           foreach ($lines as $line_num => $os)

    1462. 

  1462.           {

    1463. 

  1463.               list($nome_os, $id_os) = explode("|", $os);

    1464. 

  1464.               if (strpos($arg, $id_os) === false)

    1465. 

  1465.                   continue;

    1466. 

  1466.               // riconosciuto

    1467. 

  1467.               return $nome_os;

    1468. 

  1468.           }

    1469. 

  1469.           return '';

    1470. 

  1470.       }

    1471. 

  1471.       

    1472. 

  1472.       

    1473. 

  1473.       function iriGetBrowser($arg)

    1474. 

  1474.       {

    1475. 

  1475.           $arg = str_replace(" ", "", $arg);

    1476. 

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

    1477. 

  1477.           foreach ($lines as $line_num => $browser)

    1478. 

  1478.           {

    1479. 

  1479.               list($nome, $id) = explode("|", $browser);

    1480. 

  1480.               if (strpos($arg, $id) === false)

    1481. 

  1481.                   continue;

    1482. 

  1482.               // riconosciuto

    1483. 

  1483.               return $nome;

    1484. 

  1484.           }

    1485. 

  1485.           return '';

    1486. 

  1486.       }

    1487. 

  1487.       

    1488. 

  1488. 	  function iriCheckBanIP($arg)

    1489. 

  1489.       {

    1490. 

  1490.           if (file_exists(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '-custom/banips.dat'))

    1491. 

  1491.               $lines = file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '-custom/banips.dat');

    1492. 

  1492.           else

    1493. 

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

    1494. 

  1494.          

    1495. 

  1495.         if ($lines !== false)

    1496. 

  1496.         {

    1497. 

  1497.             foreach ($lines as $banip)

    1498. 

  1498.               {

    1499. 

  1499.                if (@preg_match('/^' . rtrim($banip, "\r\n") . '$/', $arg)){

    1500. 

  1500.                    return true;

    1501. 

  1501.                }

    1502. 

  1502.                   // riconosciuto, da scartare

    1503. 

  1503.               }

    1504. 

  1504.           }

    1505. 

  1505.           return false;

    1506. 

  1506.       }

    1507. 

  1507.       

    1508. 

  1508.       function iriGetSE($referrer = null)

    1509. 

  1509.       {

    1510. 

  1510.           $key = null;

    1511. 

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

    1512. 

  1512.           foreach ($lines as $line_num => $se)

    1513. 

  1513.           {

    1514. 

  1514.               list($nome, $url, $key) = explode("|", $se);

    1515. 

  1515.               if (strpos($referrer, $url) === false)

    1516. 

  1516.                   continue;

    1517. 

  1517.               // trovato se

    1518. 

  1518.               $variables = iriGetQueryPairs($referrer);

    1519. 

  1519.               $i = count($variables);

    1520. 

  1520.               while ($i--)

    1521. 

  1521.               {

    1522. 

  1522.                   $tab = explode("=", $variables[$i]);

    1523. 

  1523.                   if ($tab[0] == $key)

    1524. 

  1524.                   {

    1525. 

  1525.                       return($nome . "|" . urlencode($tab[1]));

    1526. 

  1526.                   }

    1527. 

  1527.               }

    1528. 

  1528.           }

    1529. 

  1529.           return null;

    1530. 

  1530.       }

    1531. 

  1531.       

    1532. 

  1532.       function iriGetSpider($agent = null)

    1533. 

  1533.       {

    1534. 

  1534.           $agent = str_replace(" ", "", $agent);

    1535. 

  1535.           $key = null;

    1536. 

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

    1537. 

  1537.           if (file_exists(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '-custom/spider.dat'))

    1538. 

  1538.               $lines = array_merge($lines, file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '-custom/spider.dat'));

    1539. 

  1539.           foreach ($lines as $line_num => $spider)

    1540. 

  1540.           {

    1541. 

  1541.               list($nome, $key) = explode("|", $spider);

    1542. 

  1542.               if (strpos($agent, $key) === false)

    1543. 

  1543.                   continue;

    1544. 

  1544.               // trovato

    1545. 

  1545.               return $nome;

    1546. 

  1546.           }

    1547. 

  1547.           return null;

    1548. 

  1548.       }

    1549. 

  1549.       

    1550. 

  1550.       

    1551. 

  1551.       function iri_StatPress_lastmonth()

    1552. 

  1552.       {

    1553. 

  1553.           $ta = getdate(current_time('timestamp'));

    1554. 

  1554.           

    1555. 

  1555.           $year = $ta['year'];

    1556. 

  1556.           $month = $ta['mon'];

    1557. 

  1557.           

    1558. 

  1558.           // go back 1 month;

    1559. 

  1559.           $month = $month - 1;

    1560. 

  1560.           

    1561. 

  1561.           if ($month === 0)

    1562. 

  1562.           {

    1563. 

  1563.           	// if this month is Jan

    1564. 

  1564.             // go back a year

    1565. 

  1565.             $year  = $year - 1;

    1566. 

  1566.           	$month = 12;

    1567. 

  1567.           }

    1568. 

  1568.           

    1569. 

  1569.           // return in format 'YYYYMM'

    1570. 

  1570.           return sprintf($year . '%02d', $month);

    1571. 

  1571.       }

    1572. 

  1572.       

    1573. 

  1573.       

    1574. 

  1574.       function iri_StatPress_CreateTable()

    1575. 

  1575.       {

    1576. 

  1576.           global $wpdb;

    1577. 

  1577.           global $wp_db_version;

    1578. 

  1578.           $table_name = $wpdb->prefix . "statpress";

    1579. 

  1579.           $sql_createtable = "CREATE TABLE " . $table_name . " (

    1580. 

  1580.   id MEDIUMINT(9) NOT NULL AUTO_INCREMENT,

    1581. 

  1581.   date TINYTEXT,

    1582. 

  1582.   time TINYTEXT,

    1583. 

  1583.   ip TINYTEXT,

    1584. 

  1584.   urlrequested TEXT,

    1585. 

  1585.   agent TEXT,

    1586. 

  1586.   referrer TEXT,

    1587. 

  1587.   search TEXT,

    1588. 

  1588.   nation TINYTEXT,

    1589. 

  1589.   os TINYTEXT,

    1590. 

  1590.   browser TINYTEXT,

    1591. 

  1591.   searchengine TINYTEXT,

    1592. 

  1592.   spider TINYTEXT,

    1593. 

  1593.   feed TINYTEXT,

    1594. 

  1594.   user TINYTEXT,

    1595. 

  1595.   timestamp TINYTEXT,

    1596. 

  1596.   threat_score SMALLINT,

    1597. 

  1597.   threat_type SMALLINT,

    1598. 

  1598.   UNIQUE KEY id (id)

    1599. 

  1599.   );";

    1600. 

  1600.           if ($wp_db_version >= 5540)

    1601. 

  1601.               $page = 'wp-admin/includes/upgrade.php';

    1602. 

  1602.           else

    1603. 

  1603.               $page = 'wp-admin/upgrade-functions.php';

    1604. 

  1604.           require_once(ABSPATH . $page);

    1605. 

  1605.           dbDelta($sql_createtable);

    1606. 

  1606.       }

    1607. 

  1607.       

    1608. 

  1608. function iri_StatPress_is_feed($url) {

    1609. 

  1609.    if (stristr($url,get_bloginfo('comments_atom_url')) != FALSE) { return 'COMMENT ATOM'; }

    1610. 

  1610.    elseif (stristr($url,get_bloginfo('comments_rss2_url')) != FALSE) { return 'COMMENT RSS'; }

    1611. 

  1611.    elseif (stristr($url,get_bloginfo('rdf_url')) != FALSE) { return 'RDF'; }

    1612. 

  1612.    elseif (stristr($url,get_bloginfo('atom_url')) != FALSE) { return 'ATOM'; }

    1613. 

  1613.    elseif (stristr($url,get_bloginfo('rss_url')) != FALSE) { return 'RSS'; }

    1614. 

  1614.    elseif (stristr($url,get_bloginfo('rss2_url')) != FALSE) { return 'RSS2'; }

    1615. 

  1615.    elseif (stristr($url,'wp-feed.php') != FALSE) { return 'RSS2'; }

    1616. 

  1616.    elseif (stristr($url,'/feed') != FALSE) { return 'RSS2'; }

    1617. 

  1617.    return '';

    1618. 

  1618. }

    1619. 

  1619. 

    1620. 

  1620. 

    1621. 

  1621. 

    1622. 

  1622. function iriStatPressAgents()

    1623. 

  1623.       {

    1624. 

  1624.           global $wpdb;

    1625. 

  1625.           $table_name = $wpdb->prefix . "statpress";

    1626. 

  1626.           $query = "SELECT date, MAX(time), ip, COUNT(*) as count, agent";

    1627. 

  1627.           $query .= " FROM " . $table_name;

    1628. 

  1628.           $query .= " WHERE spider = '' AND browser = ''";

    1629. 

  1629.           $query .= " GROUP BY date, ip, agent";

    1630. 

  1630.           $query .= " ORDER BY date DESC";

    1631. 

  1631.           $result = $wpdb->get_results($query);

    1632. 

  1632. 

    1633. 

  1633.           print "<div class='wrap'><h2>" . __('Unknown User Agents', 'statpress') . "</h2>";

    1634. 

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

    1635. 

  1635.           print "<th scope='col'>" . __('Date', 'statpress') . "</th>";

    1636. 

  1636.           print "<th scope='col'>" . __('Last Time', 'statpress') . "</th>";

    1637. 

  1637.           print "<th scope='col'>" . __('IP', 'statpress') . "</th>";

    1638. 

  1638.           print "<th scope='col'>" . __('Count', 'statpress') . "</th>";

    1639. 

  1639.           print "<th scope='col'>" . __('User Agent', 'statpress') . "</th>";

    1640. 

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

    1641. 

  1641. 

    1642. 

  1642.           foreach ($result as $line)

    1643. 

  1643.           {   

    1644. 

  1644.             $col = 0;

    1645. 

  1645.             print '<tr>';

    1646. 

  1646.             foreach ($line as $col_value)

    1647. 

  1647. {

    1648. 

  1648.     $col++;

    1649. 

  1649.     if ($col == 1)

    1650. 

  1650.         print '<td>' . irihdate($col_value) . '</td>';

    1651. 

  1651.     else if ($col == 3)

    1652. 

  1652.         print "<td><a href='http://www.projecthoneypot.org/ip_" . $col_value . "' target='_blank'>" . $col_value . "</a></td>";

    1653. 

  1653.     else

    1654. 

  1654.         print '<td>' . $col_value . '</td>';

    1655. 

  1655. }

    1656. 

  1656.             print '</tr>';

    1657. 

  1657.           }

    1658. 

  1658.           print '</table></div>';

    1659. 

  1659.       }

    1660. 

  1660. 

    1661. 

  1661. 

    1662. 

  1662. function iri_StatPress_extractfeedreq($url)

    1663. 

  1663. {

    1664. 

  1664. 		if(!strpos($url, '?') === FALSE)

    1665. 

  1665. 		{

    1666. 

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

    1667. 

  1667.     		list($res, $null) = explode("&", $q);

    1668. 

  1668.     }

    1669. 

  1669.     else

    1670. 

  1670.     {

    1671. 

  1671.     	$prsurl = parse_url($url);

    1672. 

  1672.     	$res = $prsurl['path'] . $$prsurl['query'];

    1673. 

  1673.     }

    1674. 

  1674.     

    1675. 

  1675.     return $res;

    1676. 

  1676. }

    1677. 

  1677.       

    1678. 

  1678.       function iriStatAppend()

    1679. 

  1679.       {

    1680. 

  1680.           global $wpdb;

    1681. 

  1681.           $table_name = $wpdb->prefix . "statpress";

    1682. 

  1682.           global $userdata;

    1683. 

  1683.           global $_STATPRESS;

    1684. 

  1684.           get_currentuserinfo();

    1685. 

  1685.           $feed = '';

    1686. 

  1686.           

    1687. 

  1687.           // Time

    1688. 

  1688.           $timestamp = current_time('timestamp');

    1689. 

  1689.           $vdate = gmdate("Ymd", $timestamp);

    1690. 

  1690.           $vtime = gmdate("H:i:s", $timestamp);

    1691. 

  1691.           

    1692. 

  1692.           // IP

    1693. 

  1693.           $ipAddress = $_SERVER['REMOTE_ADDR'];

    1694. 

  1694.           if (iriCheckBanIP($ipAddress) === true)

    1695. 

  1695.           {

    1696. 

  1696.               return '';

    1697. 

  1697.           }

    1698. 

  1698.           

    1699. 

  1699.           // Determine Threats if http:bl installed

    1700. 

  1700.           $threat_score = 0;

    1701. 

  1701.           $threat_type = 0;

    1702. 

  1702.           $httpbl_key = get_option("httpbl_key");

    1703. 

  1703.           if ($httpbl_key !== false)

    1704. 

  1704.           {

    1705. 

  1705.               $result = explode( ".", gethostbyname( $httpbl_key . "." .

    1706. 

  1706.                   implode ( ".", array_reverse( explode( ".",

    1707. 

  1707.                   $ipAddress ) ) ) .

    1708. 

  1708.                   ".dnsbl.httpbl.org" ) );

    1709. 

  1709.               // If the response is positive

    1710. 

  1710.               if ($result[0] == 127)

    1711. 

  1711.               {

    1712. 

  1712.                   $threat_score = $result[2];

    1713. 

  1713.                   $threat_type = $result[3];

    1714. 

  1714.               }

    1715. 

  1715.           }

    1716. 

  1716.           

    1717. 

  1717.           // URL (requested)

    1718. 

  1718.           $urlRequested = iri_StatPress_URL();

    1719. 

  1719.           if (eregi(".ico$", $urlRequested))

    1720. 

  1720.           {

    1721. 

  1721.               return '';

    1722. 

  1722.           }

    1723. 

  1723.           if (eregi("favicon.ico", $urlRequested))

    1724. 

  1724.           {

    1725. 

  1725.               return '';

    1726. 

  1726.           }

    1727. 

  1727.           if (eregi(".css$", $urlRequested))

    1728. 

  1728.           {

    1729. 

  1729.               return '';

    1730. 

  1730.           }

    1731. 

  1731.           if (eregi(".js$", $urlRequested))

    1732. 

  1732.           {

    1733. 

  1733.               return '';

    1734. 

  1734.           }

    1735. 

  1735.           if (stristr($urlRequested, "/wp-content/plugins") != false)

    1736. 

  1736.           {

    1737. 

  1737.               return '';

    1738. 

  1738.           }

    1739. 

  1739.           if (stristr($urlRequested, "/wp-content/themes") != false)

    1740. 

  1740.           {

    1741. 

  1741.               return '';

    1742. 

  1742.           }

    1743. 

  1743.           

    1744. 

  1744.           $referrer = (isset($_SERVER['HTTP_REFERER']) ? htmlentities($_SERVER['HTTP_REFERER']) : '');

    1745. 

  1745.           $userAgent = (isset($_SERVER['HTTP_USER_AGENT']) ? htmlentities($_SERVER['HTTP_USER_AGENT']) : '');

    1746. 

  1746.           $spider = iriGetSpider($userAgent);

    1747. 

  1747.           

    1748. 

  1748.           if (($spider != '') and (get_option('statpress_donotcollectspider') == 'checked'))

    1749. 

  1749.           {

    1750. 

  1750.               return '';

    1751. 

  1751.           }

    1752. 

  1752.           

    1753. 

  1753.           if ($spider != '')

    1754. 

  1754.           {

    1755. 

  1755.               $os = '';

    1756. 

  1756.               $browser = '';

    1757. 

  1757.           }

    1758. 

  1758.           else

    1759. 

  1759.           {

    1760. 

  1760.               // Trap feeds

    1761. 

  1761.               $prsurl = parse_url(get_bloginfo('url'));

    1762. 

  1762.               $feed = iri_StatPress_is_feed($prsurl['scheme'] . '://' . $prsurl['host'] . $_SERVER['REQUEST_URI']);

    1763. 

  1763.               // Get OS and browser

    1764. 

  1764.               $os = iriGetOS($userAgent);

    1765. 

  1765.               $browser = iriGetBrowser($userAgent);

    1766. 

  1766.               list($searchengine, $search_phrase) = explode("|", iriGetSE($referrer));

    1767. 

  1767.           }

    1768. 

  1768.           // Auto-delete visits if...

    1769. 

  1769.           if (get_option('statpress_autodelete_spider') != '') 

    1770. 

  1770.           {

    1771. 

  1771.               $t = gmdate("Ymd", strtotime('-' . get_option('statpress_autodelete_spider')));

    1772. 

  1772.               $results = $wpdb->query("DELETE FROM " . $table_name . " WHERE date < '" . $t . "' AND spider <> ''");

    1773. 

  1773.           }

    1774. 

  1774.           if (get_option('statpress_autodelete') != '')

    1775. 

  1775.           {

    1776. 

  1776.               $t = gmdate("Ymd", strtotime('-' . get_option('statpress_autodelete')));

    1777. 

  1777.               $results = $wpdb->query("DELETE FROM " . $table_name . " WHERE date < '" . $t . "'");

    1778. 

  1778.           }

    1779. 

  1779.           if ((!is_user_logged_in()) or (get_option('statpress_collectloggeduser') == 'checked'))

    1780. 

  1780.           {

    1781. 

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

    1782. 

  1782.               {

    1783. 

  1783.                   iri_StatPress_CreateTable();

    1784. 

  1784.               }

    1785. 

  1785.               

    1786. 

  1786.               $insert = "INSERT INTO " . $table_name . " (date, time, ip, urlrequested, agent, referrer, search,nation,os,browser,searchengine,spider,feed,user,threat_score,threat_type,timestamp) " . "VALUES ('$vdate','$vtime','$ipAddress','" . mysql_real_escape_string($urlRequested) . "','" . mysql_real_escape_string(strip_tags($userAgent)) . "','" . mysql_real_escape_string($referrer) . "','" . mysql_real_escape_string(strip_tags($search_phrase)) . "','" . iriDomain($ipAddress) . "','" . mysql_real_escape_string($os) . "','" . mysql_real_escape_string($browser) . "','$searchengine','$spider','$feed','$userdata->user_login',$threat_score,$threat_type,'$timestamp')";

    1787. 

  1787.               $results = $wpdb->query($insert);

    1788. 

  1788.           }

    1789. 

  1789.       }

    1790. 

  1790.       

    1791. 

  1791.       

    1792. 

  1792.       function iriStatPressUpdate()

    1793. 

  1793.       {

    1794. 

  1794.           global $wpdb;

    1795. 

  1795.           $table_name = $wpdb->prefix . "statpress";

    1796. 

  1796.           

    1797. 

  1797.           $wpdb->show_errors();

    1798. 

  1798.           // update table

    1799. 

  1799.           print "" . __('Updating table struct', 'statpress') . " $table_name... ";

    1800. 

  1800.           iri_StatPress_CreateTable();

    1801. 

  1801.           print "" . __('done', 'statpress') . "<br>";

    1802. 

  1802.           

    1803. 

  1803.           // Update Feed

    1804. 

  1804.           print "" . __('Updating Feeds', 'statpress') . "... ";

    1805. 

  1805.           $wpdb->query("UPDATE $table_name SET feed='';");

    1806. 

  1806.           

    1807. 

  1807.           // standard blog info urls

    1808. 

  1808.           $s = iri_StatPress_extractfeedreq(get_bloginfo('comments_atom_url'));

    1809. 

  1809.           if ($s != '')

    1810. 

  1810.           {

    1811. 

  1811.               $wpdb->query("UPDATE $table_name SET feed='COMMENT ATOM' WHERE INSTR(urlrequested,'$s')>0 AND feed='';");

    1812. 

  1812.           }

    1813. 

  1813.           $s = iri_StatPress_extractfeedreq(get_bloginfo('comments_rss2_url'));

    1814. 

  1814.           if ($s != '')

    1815. 

  1815.           {

    1816. 

  1816.               $wpdb->query("UPDATE $table_name SET feed='COMMENT RSS' WHERE INSTR(urlrequested,'$s')>0 AND feed='';");

    1817. 

  1817.           }

    1818. 

  1818.           $s = iri_StatPress_extractfeedreq(get_bloginfo('atom_url'));

    1819. 

  1819.           if ($s != '')

    1820. 

  1820.           {

    1821. 

  1821.               $wpdb->query("UPDATE $table_name SET feed='ATOM' WHERE INSTR(urlrequested,'$s')>0 AND feed='';");

    1822. 

  1822.           }

    1823. 

  1823.           $s = iri_StatPress_extractfeedreq(get_bloginfo('rdf_url'));

    1824. 

  1824.           if ($s != '')

    1825. 

  1825.           {

    1826. 

  1826.               $wpdb->query("UPDATE $table_name SET feed='RDF'  WHERE INSTR(urlrequested,'$s')>0 AND feed='';");

    1827. 

  1827.           }

    1828. 

  1828.           $s = iri_StatPress_extractfeedreq(get_bloginfo('rss_url'));

    1829. 

  1829.           if ($s != '')

    1830. 

  1830.           {

    1831. 

  1831.               $wpdb->query("UPDATE $table_name SET feed='RSS'  WHERE INSTR(urlrequested,'$s')>0 AND feed='';");

    1832. 

  1832.           }

    1833. 

  1833.           $s = iri_StatPress_extractfeedreq(get_bloginfo('rss2_url'));

    1834. 

  1834.           if ($s != '')

    1835. 

  1835.           {

    1836. 

  1836.               $wpdb->query("UPDATE $table_name SET feed='RSS2' WHERE INSTR(urlrequested,'$s')>0 AND feed='';");

    1837. 

  1837.           }

    1838. 

  1838.           

    1839. 

  1839.           // not standard

    1840. 

  1840.           $wpdb->query("UPDATE $table_name SET feed='RSS2' WHERE urlrequested LIKE '%/feed%' AND feed='';");

    1841. 

  1841.           $wpdb->query("UPDATE $table_name SET feed='RSS2' WHERE urlrequested LIKE '%wp-feed.php%' AND feed='';");

    1842. 

  1842.          

    1843. 

  1843.           

    1844. 

  1844.           print "" . __('done', 'statpress') . "<br>";

    1845. 

  1845.           

    1846. 

  1846.           // Update OS

    1847. 

  1847.           print "" . __('Updating OS', 'statpress') . "... ";

    1848. 

  1848.           $wpdb->query("UPDATE $table_name SET os = '';");

    1849. 

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

    1850. 

  1850.           foreach ($lines as $line_num => $os)

    1851. 

  1851.           {

    1852. 

  1852.               list($nome_os, $id_os) = explode("|", $os);

    1853. 

  1853.               $qry = "UPDATE $table_name SET os = '$nome_os' WHERE os='' AND replace(agent,' ','') LIKE '%" . $id_os . "%';";

    1854. 

  1854.               $wpdb->query($qry);

    1855. 

  1855.           }

    1856. 

  1856.           print "" . __('done', 'statpress') . "<br>";

    1857. 

  1857.           

    1858. 

  1858.           // Update Browser

    1859. 

  1859.           print "". __('Updating Browsers', 'statpress') ."... ";

    1860. 

  1860.           $wpdb->query("UPDATE $table_name SET browser = '';");

    1861. 

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

    1862. 

  1862.           foreach ($lines as $line_num => $browser)

    1863. 

  1863.           {

    1864. 

  1864.               list($nome, $id) = explode("|", $browser);

    1865. 

  1865.               $qry = "UPDATE $table_name SET browser = '$nome' WHERE browser='' AND replace(agent,' ','') LIKE '%" . $id . "%';";

    1866. 

  1866.               $wpdb->query($qry);

    1867. 

  1867.           }

    1868. 

  1868.           print "" . __('done', 'statpress') . "<br>";

    1869. 

  1869.           

    1870. 

  1870.           print "" . __('Updating Spiders', 'statpress') . "... ";

    1871. 

  1871.           $wpdb->query("UPDATE $table_name SET spider = '';");

    1872. 

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

    1873. 

  1873.           if (file_exists(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '-custom/spider.dat'))

    1874. 

  1874.               $lines = array_merge($lines, file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '-custom/spider.dat'));

    1875. 

  1875.           foreach ($lines as $line_num => $spider)

    1876. 

  1876.           {

    1877. 

  1877.               list($nome, $id) = explode("|", $spider);

    1878. 

  1878.               $qry = "UPDATE $table_name SET spider = '$nome',os='',browser='' WHERE spider='' AND replace(agent,' ','') LIKE '%" . $id . "%';";

    1879. 

  1879.               $wpdb->query($qry);

    1880. 

  1880.           }

    1881. 

  1881.           print "" . __('done', 'statpress') . "<br>";

    1882. 

  1882.           

    1883. 

  1883.           // Update feed to ''

    1884. 

  1884.           print "" . __('Updating Feeds', 'statpress') . "... ";

    1885. 

  1885.           $wpdb->query("UPDATE $table_name SET feed = '' WHERE isnull(feed);");

    1886. 

  1886.           print "" . __('done', 'statpress') . "<br>";

    1887. 

  1887.           

    1888. 

  1888.           // Update Search engine

    1889. 

  1889.           print "" . __('Updating Search engines', 'statpress') . "... ";

    1890. 

  1890.           print "<br>";

    1891. 

  1891.           $wpdb->query("UPDATE $table_name SET searchengine = '', search='';");

    1892. 

  1892.           print "..." . __('null-ed', 'statpress') . "!<br>";

    1893. 

  1893.           $qry = $wpdb->get_results("SELECT id, referrer FROM $table_name WHERE referrer !=''");

    1894. 

  1894.           print "..." . __('select-ed', 'statpress') . "!<br>";

    1895. 

  1895.           foreach ($qry as $rk)

    1896. 

  1896.           {

    1897. 

  1897.               list($searchengine, $search_phrase) = explode("|", iriGetSE($rk->referrer));

    1898. 

  1898.               if ($searchengine <> '')

    1899. 

  1899.               {

    1900. 

  1900.                   $q = "UPDATE $table_name SET searchengine = '$searchengine', search='" . addslashes($search_phrase) . "' WHERE id=" . $rk->id;

    1901. 

  1901.                   $wpdb->query($q);

    1902. 

  1902.               }

    1903. 

  1903.           }

    1904. 

  1904.           print "" . __('done', 'statpress') . "<br>";

    1905. 

  1905.           

    1906. 

  1906.           $wpdb->hide_errors();

    1907. 

  1907.           

    1908. 

  1908.           print "<br>&nbsp;<h1>" . __('Updated', 'statpress') . "!</h1>";

    1909. 

  1909.       }

    1910. 

  1910.       

    1911. 

  1911.       function StatPress_Widget($w = '')

    1912. 

  1912.       {

    1913. 

  1913.       }

    1914. 

  1914.       

    1915. 

  1915.       function StatPress_Print($body = '')

    1916. 

  1916.       {

    1917. 

  1917.           print iri_StatPress_Vars($body);

    1918. 

  1918.       }

    1919. 

  1919.       

    1920. 

  1920.       

    1921. 

  1921.       function iri_StatPress_Vars($body)

    1922. 

  1922.       {

    1923. 

  1923.           global $wpdb;

    1924. 

  1924.           $table_name = $wpdb->prefix . "statpress";

    1925. 

  1925.           

    1926. 

  1926.           if (strpos(strtolower($body), "%visits%") !== false)

    1927. 

  1927.           {

    1928. 

  1928.               $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM $table_name WHERE date = '" . gmdate("Ymd", current_time('timestamp')) . "' and spider='' and feed='';");

    1929. 

  1929.               $body = str_replace("%visits%", $qry[0]->pageview, $body);

    1930. 

  1930.           }

    1931. 

  1931.           if (strpos(strtolower($body), "%totalvisits%") !== false)

    1932. 

  1932.           {

    1933. 

  1933.               $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM $table_name WHERE spider='' and feed='';");

    1934. 

  1934.               $body = str_replace("%totalvisits%", $qry[0]->pageview, $body);

    1935. 

  1935.           }

    1936. 

  1936.           if (strpos(strtolower($body), "%thistotalvisits%") !== false)

    1937. 

  1937.           {

    1938. 

  1938.               $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM $table_name WHERE spider='' and feed='' AND urlrequested='" . mysql_real_escape_string(iri_StatPress_URL()) . "';");

    1939. 

  1939.               $body = str_replace("%thistotalvisits%", $qry[0]->pageview, $body);

    1940. 

  1940.           }

    1941. 

  1941.           if (strpos(strtolower($body), "%since%") !== false)

    1942. 

  1942.           {

    1943. 

  1943.               $qry = $wpdb->get_results("SELECT date FROM $table_name ORDER BY date LIMIT 1;");

    1944. 

  1944.               $body = str_replace("%since%", irihdate($qry[0]->date), $body);

    1945. 

  1945.           }

    1946. 

  1946.           if (strpos(strtolower($body), "%os%") !== false)

    1947. 

  1947.           {

    1948. 

  1948.               $userAgent = (isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '');

    1949. 

  1949.               $os = iriGetOS($userAgent);

    1950. 

  1950.               $body = str_replace("%os%", $os, $body);

    1951. 

  1951.           }

    1952. 

  1952.           if (strpos(strtolower($body), "%browser%") !== false)

    1953. 

  1953.           {

    1954. 

  1954.               $userAgent = (isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '');

    1955. 

  1955.               $browser = iriGetBrowser($userAgent);

    1956. 

  1956.               $body = str_replace("%browser%", $browser, $body);

    1957. 

  1957.           }

    1958. 

  1958.           if (strpos(strtolower($body), "%ip%") !== false)

    1959. 

  1959.           {

    1960. 

  1960.               $ipAddress = $_SERVER['REMOTE_ADDR'];

    1961. 

  1961.               $body = str_replace("%ip%", $ipAddress, $body);

    1962. 

  1962.           }

    1963. 

  1963.           if (strpos(strtolower($body), "%visitorsonline%") !== false)

    1964. 

  1964.           {

    1965. 

  1965.               $to_time = current_time('timestamp');

    1966. 

  1966.               $from_time = strtotime('-4 minutes', $to_time);

    1967. 

  1967.               $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as visitors FROM $table_name WHERE spider='' and feed='' AND timestamp BETWEEN $from_time AND $to_time;");

    1968. 

  1968.               $body = str_replace("%visitorsonline%", $qry[0]->visitors, $body);

    1969. 

  1969.           }

    1970. 

  1970.           if (strpos(strtolower($body), "%usersonline%") !== false)

    1971. 

  1971.           {

    1972. 

  1972.               $to_time = current_time('timestamp');

    1973. 

  1973.               $from_time = strtotime('-4 minutes', $to_time);

    1974. 

  1974.               $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as users FROM $table_name WHERE spider='' and feed='' AND user<>'' AND timestamp BETWEEN $from_time AND $to_time;");

    1975. 

  1975.               $body = str_replace("%usersonline%", $qry[0]->users, $body);

    1976. 

  1976.           }

    1977. 

  1977.           if (strpos(strtolower($body), "%toppost%") !== false)

    1978. 

  1978.           {

    1979. 

  1979.               $qry = $wpdb->get_results("SELECT urlrequested,count(*) as totale FROM $table_name WHERE spider='' AND feed='' AND urlrequested LIKE '%p=%' GROUP BY urlrequested ORDER BY totale DESC LIMIT 1;");

    1980. 

  1980.               $body = str_replace("%toppost%", iri_StatPress_Decode($qry[0]->urlrequested), $body);

    1981. 

  1981.           }

    1982. 

  1982.           if (strpos(strtolower($body), "%topbrowser%") !== false)

    1983. 

  1983.           {

    1984. 

  1984.               $qry = $wpdb->get_results("SELECT browser,count(*) as totale FROM $table_name WHERE spider='' AND feed='' GROUP BY browser ORDER BY totale DESC LIMIT 1;");

    1985. 

  1985.               $body = str_replace("%topbrowser%", iri_StatPress_Decode($qry[0]->browser), $body);

    1986. 

  1986.           }

    1987. 

  1987.           if (strpos(strtolower($body), "%topos%") !== false)

    1988. 

  1988.           {

    1989. 

  1989.               $qry = $wpdb->get_results("SELECT os,count(*) as totale FROM $table_name WHERE spider='' AND feed='' GROUP BY os ORDER BY totale DESC LIMIT 1;");

    1990. 

  1990.               $body = str_replace("%topos%", iri_StatPress_Decode($qry[0]->os), $body);

    1991. 

  1991.           }

    1992. 

  1992.           if(strpos(strtolower($body),"%pagestoday%") !== false)

    1993. 

  1993.           {

    1994. 

  1994.       				$qry = $wpdb->get_results("SELECT count(ip) as pageview FROM $table_name WHERE date = '".gmdate("Ymd",current_time('timestamp'))."' and spider='' and feed='';");

    1995. 

  1995.       				$body = str_replace("%pagestoday%", $qry[0]->pageview, $body);

    1996. 

  1996.    				}

    1997. 

  1997.    				

    1998. 

  1998.    				if(strpos(strtolower($body),"%thistotalpages%") !== FALSE)

    1999. 

  1999.    				{

    2000. 

  2000.       				$qry = $wpdb->get_results("SELECT count(ip) as pageview FROM $table_name WHERE spider='' and feed='';");

    2001. 

  2001.       				$body = str_replace("%thistotalpages%", $qry[0]->pageview, $body);

    2002. 

  2002.       		}

    2003. 

  2003.       		

    2004. 

  2004.       		if (strpos(strtolower($body), "%latesthits%") !== false)

    2005. 

  2005. 			{

    2006. 

  2006. 				$qry = $wpdb->get_results("SELECT search FROM $table_name WHERE search <> '' ORDER BY id DESC LIMIT 10");

    2007. 

  2007. 				$body = str_replace("%latesthits%", urldecode($qry[0]->search), $body);

    2008. 

  2008. 				for ($counter = 0; $counter < 10; $counter += 1)

    2009. 

  2009. 				{

    2010. 

  2010. 					$body .= "<br>". urldecode($qry[$counter]->search);

    2011. 

  2011. 				}

    2012. 

  2012. 			}

    2013. 

  2013. 			

    2014. 

  2014. 			if (strpos(strtolower($body), "%pagesyesterday%") !== false)

    2015. 

  2015. 			{

    2016. 

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

    2017. 

  2017. 				$qry = $wpdb->get_row("SELECT count(DISTINCT ip) AS visitsyesterday FROM $table_name WHERE feed='' AND spider='' AND date = '" . $yesterday . "'");

    2018. 

  2018. 				$body = str_replace("%pagesyesterday%", (is_array($qry) ? $qry[0]->visitsyesterday : 0), $body);

    2019. 

  2019. 			}

    2020. 

  2020.           

    2021. 

  2021. 			

    2022. 

  2022.           return $body;

    2023. 

  2023.       }

    2024. 

  2024.       

    2025. 

  2025.       

    2026. 

  2026.       function iri_StatPress_TopPosts($limit = 5, $showcounts = 'checked')

    2027. 

  2027.       {

    2028. 

  2028.           global $wpdb;

    2029. 

  2029.           $res = "\n<ul>\n";

    2030. 

  2030.           $table_name = $wpdb->prefix . "statpress";

    2031. 

  2031.           $qry = $wpdb->get_results("SELECT urlrequested,count(*) as totale FROM $table_name WHERE spider='' AND feed='' GROUP BY urlrequested ORDER BY totale DESC LIMIT $limit;");

    2032. 

  2032.           foreach ($qry as $rk)

    2033. 

  2033.           {

    2034. 

  2034.               $res .= "<li><a href='" . irigetblogurl() . ((strpos($rk->urlrequested, 'index.php') === FALSE) ? $rk->urlrequested : '') . "'>" . iri_StatPress_Decode($rk->urlrequested) . "</a></li>\n";

    2035. 

  2035.               if (strtolower($showcounts) == 'checked')

    2036. 

  2036.               {

    2037. 

  2037.                   $res .= " (" . $rk->totale . ")";

    2038. 

  2038.               }

    2039. 

  2039.           }

    2040. 

  2040.           return "$res</ul>\n";

    2041. 

  2041.       }

    2042. 

  2042.       

    2043. 

  2043.       

    2044. 

  2044.       function widget_statpress_init($args)

    2045. 

  2045.       {

    2046. 

  2046.           if (!function_exists('register_sidebar_widget') || !function_exists('register_widget_control'))

    2047. 

  2047.               return;

    2048. 

  2048.           // Multifunctional StatPress pluging

    2049. 

  2049.           function widget_statpress_control()

    2050. 

  2050.           {

    2051. 

  2051.               $options = get_option('widget_statpress');

    2052. 

  2052.               if (!is_array($options))

    2053. 

  2053.                   $options = array('title' => 'StatPress', 'body' => 'Visits today: %visits%');

    2054. 

  2054.               if ($_POST['statpress-submit'])

    2055. 

  2055.               {

    2056. 

  2056.                   $options['title'] = strip_tags(stripslashes($_POST['statpress-title']));

    2057. 

  2057.                   $options['body'] = stripslashes($_POST['statpress-body']);

    2058. 

  2058.                   update_option('widget_statpress', $options);

    2059. 

  2059.               }

    2060. 

  2060.               $title = htmlspecialchars($options['title'], ENT_QUOTES);

    2061. 

  2061.               $body = htmlspecialchars($options['body'], ENT_QUOTES);

    2062. 

  2062.               // the form

    2063. 

  2063.               echo '<p style="text-align:right;"><label for="statpress-title">' . __('Title:') . ' <input style="width: 250px;" id="statpress-title" name="statpress-title" type="text" value="' . $title . '" /></label></p>';

    2064. 

  2064.               echo '<p style="text-align:right;"><label for="statpress-body"><div>' . __('Body:', 'widgets') . '</div><textarea style="width: 288px;height:100px;" id="statpress-body" name="statpress-body" type="textarea">' . $body . '</textarea></label></p>';

    2065. 

  2065.               echo '<input type="hidden" id="statpress-submit" name="statpress-submit" value="1" /><div style="font-size:7pt;">%totalvisits% %visits% %thistotalvisits% %os% %browser% %ip% %since% %visitorsonline% %usersonline% %toppost% %topbrowser% %topos%</div>';

    2066. 

  2066.           }

    2067. 

  2067.           function widget_statpress($args)

    2068. 

  2068.           {

    2069. 

  2069.               extract($args);

    2070. 

  2070.               $options = get_option('widget_statpress');

    2071. 

  2071.               $title = $options['title'];

    2072. 

  2072.               $body = $options['body'];

    2073. 

  2073.               echo $before_widget;

    2074. 

  2074.               print($before_title . $title . $after_title);

    2075. 

  2075.               print iri_StatPress_Vars($body);

    2076. 

  2076.               echo $after_widget;

    2077. 

  2077.           }

    2078. 

  2078.           register_sidebar_widget('StatPress', 'widget_statpress');

    2079. 

  2079.           register_widget_control(array('StatPress', 'widgets'), 'widget_statpress_control', 300, 210);

    2080. 

  2080.           

    2081. 

  2081.           // Top posts

    2082. 

  2082.           function widget_statpresstopposts_control()

    2083. 

  2083.           {

    2084. 

  2084.               $options = get_option('widget_statpresstopposts');

    2085. 

  2085.               if (!is_array($options))

    2086. 

  2086.               {

    2087. 

  2087.                   $options = array('title' => 'StatPress TopPosts', 'howmany' => '5', 'showcounts' => 'checked');

    2088. 

  2088.               }

    2089. 

  2089.               if ($_POST['statpresstopposts-submit'])

    2090. 

  2090.               {

    2091. 

  2091.                   $options['title'] = strip_tags(stripslashes($_POST['statpresstopposts-title']));

    2092. 

  2092.                   $options['howmany'] = stripslashes($_POST['statpresstopposts-howmany']);

    2093. 

  2093.                   $options['showcounts'] = stripslashes($_POST['statpresstopposts-showcounts']);

    2094. 

  2094.                   if ($options['showcounts'] == "1")

    2095. 

  2095.                   {

    2096. 

  2096.                       $options['showcounts'] = 'checked';

    2097. 

  2097.                   }

    2098. 

  2098.                   update_option('widget_statpresstopposts', $options);

    2099. 

  2099.               }

    2100. 

  2100.               $title = htmlspecialchars($options['title'], ENT_QUOTES);

    2101. 

  2101.               $howmany = htmlspecialchars($options['howmany'], ENT_QUOTES);

    2102. 

  2102.               $showcounts = htmlspecialchars($options['showcounts'], ENT_QUOTES);

    2103. 

  2103.               // the form

    2104. 

  2104.               echo '<p style="text-align:right;"><label for="statpresstopposts-title">' . __('Title', 'statpress') . ' <input style="width: 250px;" id="statpress-title" name="statpresstopposts-title" type="text" value="' . $title . '" /></label></p>';

    2105. 

  2105.               echo '<p style="text-align:right;"><label for="statpresstopposts-howmany">' . __('Limit results to', 'statpress') . ' <input style="width: 100px;" id="statpresstopposts-howmany" name="statpresstopposts-howmany" type="text" value="' . $howmany . '" /></label></p>';

    2106. 

  2106.               echo '<p style="text-align:right;"><label for="statpresstopposts-showcounts">' . __('Visits', 'statpress') . ' <input id="statpresstopposts-showcounts" name="statpresstopposts-showcounts" type=checkbox value="checked" ' . $showcounts . ' /></label></p>';

    2107. 

  2107.               echo '<input type="hidden" id="statpress-submitTopPosts" name="statpresstopposts-submit" value="1" />';

    2108. 

  2108.           }

    2109. 

  2109.           function widget_statpresstopposts($args)

    2110. 

  2110.           {

    2111. 

  2111.               extract($args);

    2112. 

  2112.               $options = get_option('widget_statpresstopposts');

    2113. 

  2113.               $title = htmlspecialchars($options['title'], ENT_QUOTES);

    2114. 

  2114.               $howmany = htmlspecialchars($options['howmany'], ENT_QUOTES);

    2115. 

  2115.               $showcounts = htmlspecialchars($options['showcounts'], ENT_QUOTES);

    2116. 

  2116.               echo $before_widget;

    2117. 

  2117.               print($before_title . $title . $after_title);

    2118. 

  2118.               print iri_StatPress_TopPosts($howmany, $showcounts);

    2119. 

  2119.               echo $after_widget;

    2120. 

  2120.           }

    2121. 

  2121.           register_sidebar_widget('StatPress TopPosts', 'widget_statpresstopposts');

    2122. 

  2122.           register_widget_control(array('StatPress TopPosts', 'widgets'), 'widget_statpresstopposts_control', 300, 110);

    2123. 

  2123.       }

    2124. 

  2124.       

    2125. 

  2125.       

    2126. 

  2126. 		// a custom function for loading localization

    2127. 

  2127. 		function statpress_load_textdomain() {

    2128. 

  2128. 		//check whether necessary core function exists

    2129. 

  2129. 		if ( function_exists('load_plugin_textdomain') ) {

    2130. 

  2130. 		//load the plugin textdomain

    2131. 

  2131. 		load_plugin_textdomain('statpress', 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '/locale');

    2132. 

  2132. 		}

    2133. 

  2133. 		}

    2134. 

  2134. 		// call the custom function on the init hook

    2135. 

  2135. 		add_action('init', 'statpress_load_textdomain');

    2136. 

  2136.       

    2137. 

  2137.       add_action('admin_menu', 'iri_add_pages');

    2138. 

  2138.       add_action('plugins_loaded', 'widget_statpress_init');

    2139. 

  2139.       //add_action('wp_head', 'iriStatAppend');

    2140. 

  2140.       add_action('send_headers', 'iriStatAppend');

    2141. 

  2141.       

    2142. 

  2142.       register_activation_hook(__FILE__, 'iri_StatPress_CreateTable');

    2143. 

  2143. ?>
    2144.