PageRenderTime 69ms CodeModel.GetById 19ms RepoModel.GetById 1ms app.codeStats 0ms

/wp-content/plugins/wassup/wassup.php

https://github.com/alx/alexgirard.com-blog
PHP | 2990 lines | 2137 code | 177 blank | 676 comment | 628 complexity | 5fff4a73495c4af5560905cd16522219 MD5 | raw file
Possible License(s): GPL-2.0, LGPL-2.1 
    

  1. <?php
    2. 

  2. /*
    3. 

  3. Plugin Name: WassUp
    4. 

  4. Plugin URI: http://www.wpwp.org
    5. 

  5. Description: Wordpress plugin to analyze your visitors traffic with real time stats, chart and a lot of chronological informations. It has sidebar Widget support to show current online visitors and other statistics.
    6. 

  6. Version: 1.6.2
    7. 

  7. Author: Michele Marcucci, Helene D.
    8. 

  8. Author URI: http://www.michelem.org/
    9. 

    10. 

  10. Copyright (c) 2007 Michele Marcucci
    11. 

  11. Released under the GNU General Public License (GPL)
    12. 

  12. http://www.gnu.org/licenses/gpl.txt
    13. 

  13. */
    14. 

  14. 

  15. //# Stop any attempt to call wassup.php directly.  -Helene D. 1/27/08.
    16. 

  16. if (preg_match('#'.basename(__FILE__) .'#', $_SERVER['PHP_SELF'])) { 
    17. 

  17. 	die('Permission Denied! You are not allowed to call this page directly.');
    18. 

  18. }
    19. 

  19. $version = "1.6.2";
    20. 

  20. define('WASSUPFOLDER', dirname(plugin_basename(__FILE__)), TRUE);
    21. 

  21. require_once(dirname(__FILE__).'/lib/wassup.class.php');
    22. 

  22. require_once(dirname(__FILE__).'/lib/main.php');
    23. 

  23. $wpurl = get_bloginfo('wpurl');	//global
    24. 

  24. 

  25. if (isset($_GET['export'])) {
    26. 

  26. 	export_wassup();
    27. 

  27. }
    28. 

  28. 

  29. global $wp_version;
    30. 

  30. 

  31. //#This works only in WP2.2 or higher
    32. 

  32. if (version_compare($wp_version, '2.2', '<')) {
    33. 

  33. 	wp_die( '<strong style="color:#c00;background-color:#dff;padding:5px;">'.__("Sorry, Wassup requires WordPress 2.2 or higher to work","wassup").'.</strong>');
    34. 

  34. } elseif (function_exists('wp_cache_flush')) {
    35. 

  35. 	//clear the WP cache
    36. 

  36. 	wp_cache_flush();	//to prevent "cannot redeclare" errors???
    37. 

  37. }
    38. 

  38. //#add initial options and create table when Wassup activated 
    39. 

  39. //  -Helene D. 2/26/08.
    40. 

  40. function wassup_install() {
    41. 

  41. 	global $wpdb;
    42. 

  42. 	$table_name = $wpdb->prefix . "wassup";
    43. 

  43. 	$table_tmp_name = $wpdb->prefix . "wassup_tmp";
    44. 

  44. 

  45. 	//### Add/update wassup settings in Wordpress options table
    46. 

  46. 	$wassup_options = new wassupOptions; //#settings initialized here
    47. 

  47. 

  48. 	//# set hash
    49. 

  49. 	$whash = $wassup_options->get_wp_hash();
    50. 

  50. 	if (!empty($whash)) {
    51. 

  51. 		$wassup_options->whash = $whash;
    52. 

  52. 	}
    53. 

  53. 	//# Add timestamp to optimize table once a day
    54. 

  54. 	$wassup_options->wassup_optimize = wassup_get_time();
    55. 

  55. 

  56.         //# set wmark and wip to null  
    57. 

  57.         $wassup_options->wmark = 0;     //#no preservation of delete/mark
    58. 

  58.         $wassup_options->wip = null;
    59. 

  59. 

  60. 	//### For upgrade of Wassup, manually initialize new settings
    61. 

  61. 	//# initialize settings for 'spamcheck', 'refspam', and 'spam'
    62. 

  62. 	if (!isset($wassup_options->wassup_spamcheck)) {
    63. 

  63. 		$wassup_options->wassup_spamcheck = "0";
    64. 

  64. 		//#set wassup_spamcheck=0 if wassup_refspam=0 and wassup_spam=0
    65. 

  65. 		if (!isset($wassup_options->wassup_spam) && !isset($wassup_options->wassup_refspam)) {
    66. 

  66. 			$wassup_options->wassup_spam = "1";
    67. 

  67. 			$wassup_options->wassup_refspam = "1";
    68. 

  68. 		} elseif ( $wassup_options->wassup_spam == "0" && $wassup_options->wassup_refspam == "0" ) { 
    69. 

  69. 	   		$wassup_options->wassup_spamcheck = "0";
    70. 

  70. 	   	}
    71. 

  71. 	}
    72. 

  72. 	
    73. 

  73. 	//# update wassup settings for 'savepath' (default is null)
    74. 

  74. 	//$wassup_options->wassup_savepath = "/fakedirectory"; //#debug
    75. 

  75.    	if (!isset($wassup_options->wassup_savepath)) {
    76. 

  76.   		$wassup_options->wassup_savepath = null;
    77. 

  77. 	}
    78. 

  78. 	//# display google chart by default for upgrades from 1.4.4
    79. 

  79. 	if (!isset($wassup_options->wassup_chart)) {
    80. 

  80. 		$wassup_options->wassup_chart = 1;
    81. 

  81. 	}
    82. 

  82.         //# assign top ten items for upgrades from 1.4.9 or less
    83. 

  83. 	if (empty($wassup_options->wassup_top10)) {
    84. 

  84. 		$wassup_options->wassup_top10 = serialize(array("topsearch"=>"1",
    85. 

  85. 						"topreferrer"=>"1",
    86. 

  86. 						"toprequest"=>"1",
    87. 

  87. 						"topbrowser"=>"1",
    88. 

  88. 						"topos"=>"1",
    89. 

  89. 						"toplocale"=>"0",
    90. 

  90. 						"topfeed"=>"0",
    91. 

  91. 						"topcrawler"=>"0",
    92. 

  92. 						"topvisitor"=>"0",
    93. 

  93. 						"topreferrer_exclude"=>""));
    94. 

  94. 	}
    95. 

  95. 	//#upgrade from 1.6: new options wassup_time_format and wassup_hack
    96. 

  96. 	if (!isset($wassup_options->wassup_time_format)) {
    97. 

  97. 		$wassup_options->wassup_time_format = 24;
    98. 

  98. 	}
    99. 

  99. 	if (!isset($wassup_options->wassup_hack)) {
    100. 

  100. 		$wassup_options->wassup_hack = 1;
    101. 

  101. 	}
    102. 

  102. 	$wassup_options->saveSettings();
    103. 

  103. 

  104. 	//### Detect problems with WassUp install and show warning
    105. 

  105. 	//# 
    106. 

  106. 	//#Check for problems with 'session_savepath' and disable 
    107. 

  107. 	//#  recording, if found.  -Helene D. 2/24/08
    108. 

  108. 	/*
    109. 

  109. 	$sessionpath = $wassup_options->wassup_savepath;
    110. 

  110. 	if (empty($sessionpath)) { $sessionpath = getSessionpath(); }
    111. 

  111. 	//default to "/tmp" if no sessionpath value
    112. 

  112. 	if (empty($sessionpath)) { 
    113. 

  113. 		$sessionpath = "/tmp";
    114. 

  114. 		$wassup_options->wassup_savepath = $sessionpath;
    115. 

  115. 	}
    116. 

  116. 	if ($wassup_options->isWritableFolder($sessionpath) == false) {
    117. 

  117. 		if ($wassup_options->wassup_active == "1") {
    118. 

  118. 			$wassup_options->wassup_active = "0";
    119. 

  119.   			$wassup_options->wassup_alert_message = __('WassUp has detected a problem with "session.save_path" setting in your Wordpress/PHP configuration. Statistics logging has been disabled as a result. To fix, go to admin menu, "Wassup-->Options-->Manage Files & Database" and modify "Temporary files location folder".','wassup');
    120. 

  120. 		} else {
    121. 

  121.   			$wassup_options->wassup_alert_message = __('WassUp has detected a problem with "session.save_path" setting in your Wordpress/PHP configuration. Please fix by modifying "Temporary files location folder" in admin menu, "Wassup-->Options-->Manage Files & Database".','wassup');
    122. 

  122. 		}
    123. 

  123. 	}
    124. 

  124. 	$wassup_options->saveSettings();
    125. 

  125. 	unset($sessionpath); //because "install" works in global scope
    126. 

  126. 	*/
    127. 

  127. 	//# TODO:
    128. 

  128. 	//###Detect known incompatible plugins like "wp_cache" and disable 
    129. 

  129. 	//#  recordings and show warning message...
    130. 

  130. 

  131. 	//### Create/upgrade wassup MAIN table
    132. 

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

  133. 		CreateTable($table_name);
    134. 

  134. 		CreateTable($table_tmp_name);
    135. 

  135. 	} else {
    136. 

  136. 		UpdateTable(); //<== wassup_tmp is added here, if missing
    137. 

  137. 	}
    138. 

  138. } //#end function wassup_install
    139. 

  139. 

  140. //set global variables that are dependent on Wassup's wp_options values
    141. 

  141. $wassup_settings = get_option('wassup_settings'); //temp only..
    142. 

  142. $wassup_options = new wassupOptions; 
    143. 

  143. //$wassup_options->loadSettings();	//done automatically 
    144. 

  144. $whash = $wassup_options->whash;	//global...
    145. 

  145. 

  146. //#Completely remove all wassup tables and options from Wordpress when
    147. 

  147. //# the 'wassup_uninstall' option is set and plugin is deactivated.
    148. 

  148. //#  -Helene D. 2/26/08
    149. 

  149. function wassup_uninstall() {
    150. 

  150. 	global $wassup_options, $wpdb;
    151. 

  151. 	if ($wassup_options->wassup_uninstall == "1") {
    152. 

  152. 		$table_name = $wpdb->prefix . "wassup";
    153. 

  153. 		$table_tmp_name = $wpdb->prefix . "wassup_tmp";
    154. 

  154. 		//$wpdb->query("DROP TABLE IF EXISTS $table_name"); //incorrectly causes an activation error in Wordpress
    155. 

  155. 		//$wpdb->query("DROP TABLE IF EXISTS $table_tmp_name"); //incorrectly causes an activation error in Wordpress
    156. 

  156. 		mysql_query("DROP TABLE IF EXISTS $table_tmp_name");
    157. 

  157. 		mysql_query("DROP TABLE IF EXISTS $table_name");
    158. 

  158. 		$wassup_options->deleteSettings(); 
    159. 

  159. 	}
    160. 

  160. } //#end function wassup_uninstall
    161. 

  161. 

  162. function add_wassup_meta_info() {
    163. 

  163. 	global $version;
    164. 

  164. 	print '<meta name="wassup-version" content="'.$version.'" />';
    165. 

  165. }
    166. 

  166. 

  167. //# Wassup init hook actions performed before headers are sent: 
    168. 

  168. //#   -Load jquery AJAX library and dependent javascripts for admin menus
    169. 

  169. //#   -Load language/localization files for admin menus and widget
    170. 

  170. //#   -Set 'wassup' cookie for new visitor hits
    171. 

  171. function wassup_init() {
    172. 

  172. 	global $wpurl;
    173. 

  173. 

  174. 	//### Add wassup scripts to Wassup Admin pages...
    175. 

  175. 	if (stristr($_GET['page'],'wassup') !== FALSE) {
    176. 

  176. 		if ( function_exists('wp_deregister_script')) {
    177. 

  177. 			//removes old jquery vers.
    178. 

  178. 			wp_deregister_script('jquery');	
    179. 

  179. 		}
    180. 

  180. 		// the safe way to load jquery into WP
    181. 

  181. 		wp_register_script('jquery', $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/js/jquery.js',FALSE,'1.2.6');
    182. 

  182. 		if ($_GET['page'] == "wassup-spy") {
    183. 

  183. 			//the safe way to load a jquery dependent script
    184. 

  184. 			wp_enqueue_script('spy', $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/js/spy.js', array('jquery'), '1.4');
    185. 

  185. 		} elseif($_GET['page'] == "wassup-options") {
    186. 

  186. 			wp_enqueue_script('ui.base', $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/js/ui.base.js', array('jquery'), '3');
    187. 

  187. 			wp_enqueue_script('ui.tabs', $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/js/ui.tabs.js', array('jquery'), '3');
    188. 

  188. 		} else {
    189. 

  189. 			//the safe way to load a jquery dependent script
    190. 

  190. 			wp_enqueue_script('thickbox', $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/thickbox/thickbox.js', array('jquery'), '3');
    191. 

  191. 		} 
    192. 

  192. 	}
    193. 

  193. 

  194. 	//Loading language file...
    195. 

  195. 	//Doesn't work if the plugin file has its own directory.
    196. 

  196. 	//Let's make it our way... load_plugin_textdomain() searches only in the wp-content/plugins dir.
    197. 

  197. 	$currentLocale = get_locale();
    198. 

  198. 	if(!empty($currentLocale)) {
    199. 

  199. 		$moFile = dirname(__FILE__) . "/language/" . $currentLocale . ".mo";
    200. 

  200. 		if(@file_exists($moFile) && is_readable($moFile)) load_textdomain('wassup', $moFile);
    201. 

  201. 	}
    202. 

  202. 

  203. 	//Set Wassup cookie for visitor hits before headers are sent
    204. 

  204. 	//add_action('init', 'wassupPrepend');
    205. 

  205. 	if (!is_admin()) {	//exclude wordpress admin page visits
    206. 

  206. 		wassupPrepend();
    207. 

  207. 	}
    208. 

  208. } // end function wassup_init
    209. 

  209. 

  210. //Add the wassup stylesheet and other javascripts...
    211. 

  211. function add_wassup_css() {
    212. 

  212.         global $wpurl, $wassup_options, $whash;
    213. 

  213. 

  214. 	//assign a value to whash, if none
    215. 

  215.         if ($whash == "") {
    216. 

  216. 		$whash = $wassup_options->get_wp_hash();
    217. 

  217. 		$wassup_options->whash = $whash;	//save new hash
    218. 

  218. 		$wassup_options->saveSettings();
    219. 

  219. 	}
    220. 

  220. 

  221.         $plugin_page = attribute_escape($_GET['page']);
    222. 

  222. 

  223.         if (stristr($plugin_page,'wassup') !== FALSE) { $plugin_page="wassup"; }
    224. 

  224.         //Add css and javascript to wassup menu pages only...
    225. 

  225.         if ($plugin_page == "wassup") {
    226. 

  226.                 //$wassup_settings = get_option('wassup_settings');
    227. 

  227. 		echo "\n".'<script type="text/javascript">var tb_pathToImage = "'.$wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/thickbox/loadingAnimation.gif";</script>';
    228. 

  228.                 echo "\n".'<link rel="stylesheet" href="'.$wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/thickbox/thickbox.css'.'" type="text/css" />';
    229. 

  229.                 echo "\n".'<link rel="stylesheet" href="'.$wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/ui.tabs.css'.'" type="text/css" />';
    230. 

  230.                 echo "\n".'<link rel="stylesheet" href="'.$wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/wassup.css'.'" type="text/css" />'."\n";
    231. 

  231. 

  232. if ($_GET['page'] != "wassup-options" AND $_GET['page'] != "wassup-spy") { ?>
    233. 

  233. <script type='text/javascript'>
    234. 

  234.   //<![CDATA[
    235. 

  235.   function selfRefresh(){
    236. 

  236.  	location.href='?<?php print $_SERVER['QUERY_STRING']; ?>';
    237. 

  237.   }
    238. 

  238.   setTimeout('selfRefresh()', <?php print ($wassup_options->wassup_refresh * 60000); ?>);
    239. 

  239.   //]]>
    240. 

  240. </script>
    241. 

  241. 

  242. <script type='text/javascript'>
    243. 

  243.   //<![CDATA[
    244. 

  244.   var _countDowncontainer="0";
    245. 

  245.   var _currentSeconds="0";
    246. 

  246.   function ActivateCountDown(strContainerID, initialValue) {
    247. 

  247.   	_countDowncontainer = document.getElementById(strContainerID);
    248. 

  248.   	SetCountdownText(initialValue);
    249. 

  249.   	window.setTimeout("CountDownTick()", 1000);
    250. 

  250.   }
    251. 

  251.   function CountDownTick() {
    252. 

  252.   	SetCountdownText(_currentSeconds-1);
    253. 

  253.   	window.setTimeout("CountDownTick()", 1000);
    254. 

  254.   }
    255. 

  255.   function SetCountdownText(seconds) {
    256. 

  256.   	//store:
    257. 

  257.   	_currentSeconds = seconds;
    258. 

  258.   	//build text:
    259. 

  259.   	var strText = AddZero(seconds);
    260. 

  260.   	//apply:
    261. 

  261.   	if (_countDowncontainer) {	//prevents error in "Options" submenu
    262. 

  262.   		_countDowncontainer.innerHTML = strText;
    263. 

  263.   	}
    264. 

  264.   }
    265. 

  265.   function AddZero(num) {
    266. 

  266.   	return ((num >= "0")&&(num < 10))?"0"+num:num+"";
    267. 

  267.   }
    268. 

  268.   //]]>
    269. 

  269. </script>
    270. 

  270. <script type="text/javascript">
    271. 

  271.   //<![CDATA[
    272. 

  272.   window.onload=WindowLoad;
    273. 

  273.   function WindowLoad(event) {
    274. 

  274.   	ActivateCountDown("CountDownPanel", <?php print ($wassup_options->wassup_refresh * 60); ?>);
    275. 

  275.   }
    276. 

  276.   //]]>
    277. 

  277. </script>
    278. 

  278. 

  279. <script type="text/javascript">
    280. 

  280.   //<![CDATA[
    281. 

  281.   jQuery(document).ready(function($){
    282. 

  282.   	$("a.showhide").click(function(){
    283. 

  283.   	   var id = $(this).attr('id');
    284. 

  284.   	   $("div.navi" + id).toggle("slow");
    285. 

  285.   	   return false;
    286. 

  286.   	});
    287. 

  287.   	$("a.toggleagent").click(function(){
    288. 

  288.   	   var id = $(this).attr('id');
    289. 

  289.   	   $("div.naviagent" + id).slideToggle("slow");
    290. 

  290.   	   return false;
    291. 

  291.   	});
    292. 

  292.         $("a.deleteID").click(function(){
    293. 

  293.            var id = $(this).attr('id');
    294. 

  294.                  $.ajax({
    295. 

  295. 		  url: "<?php echo $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/lib/action.php?action=delete&whash='.$whash; ?>&id=" + id,
    296. 

  296.                   async: false
    297. 

  297.                  })
    298. 

  298.            $("div.delID" + id).fadeOut("slow");
    299. 

  299.            return false;
    300. 

  300.         });
    301. 

  301.   	$("a.show-search").toggle(function(){
    302. 

  302.   	   $("div.search-ip").slideDown("slow");
    303. 

  303.   	     $("a.show-search").html("<a href='#' class='show-search'><?php _e("Hide Search", "wassup") ?></a>");
    304. 

  304.   	    },function() {
    305. 

  305.   	   $("div.search-ip").slideUp("slow");
    306. 

  306.   	     $("a.show-search").html("<a href='#' class='show-search'><?php _e("Search", "wassup") ?></a>");
    307. 

  307.   	   return false;
    308. 

  308.   	   });
    309. 

  309.   	$("a.show-topten").toggle(function(){
    310. 

  310.   	   $("div.topten").slideDown("slow");
    311. 

  311.   	     $("a.show-topten").html("<a href='#' class='show-topten'><?php _e("Hide TopTen", "wassup") ?></a>");
    312. 

  312.   	    },function() {
    313. 

  313.   	   $("div.topten").slideUp("slow");
    314. 

  314.   	     $("a.show-topten").html("<a href='#' class='show-topten'><?php _e("Show TopTen", "wassup") ?></a>");
    315. 

  315.   	   return false;
    316. 

  316.   	   });
    317. 

  317. 

  318.   	$("a.toggle-all").toggle(function() {
    319. 

  319.   	     $("div.togglenavi").slideDown("slow");
    320. 

  320.   	     $("a.toggle-all").html("<a href='#' class='toggle-all'><?php _e("Collapse All", "wassup") ?></a>");
    321. 

  321.   	    },function() {
    322. 

  322.   	     $("div.togglenavi").slideUp("slow");
    323. 

  323.   	     $("a.toggle-all").html("<a href='#' class='toggle-all'><?php _e("Expand All", "wassup") ?></a>");
    324. 

  324.   	   return false;
    325. 

  325.   	    });
    326. 

  326.   	$("a.toggle-allcrono").toggle(function() {
    327. 

  327.   	     $("div.togglecrono").slideUp("slow");
    328. 

  328.   	     $("a.toggle-allcrono").html("<a href='#' class='toggle-allcrono'><?php _e("Expand Cronology", "wassup") ?></a>");
    329. 

  329.   	  },function() {
    330. 

  330.   	     $("div.togglecrono").slideDown("slow");
    331. 

  331.   	     $("a.toggle-allcrono").html("<a href='#' class='toggle-allcrono'><?php _e("Collapse Cronology", "wassup") ?></a>");
    332. 

  332.   	  return false;
    333. 

  333.   	  });
    334. 

  334.   });	//end jQuery(document).ready
    335. 

  335.   //]]>
    336. 

  336. </script>
    337. 

  337. <?php } //end if page != wassup-options ?>
    338. 

  338. 

  339. <script type='text/javascript'>
    340. 

  340.   //<![CDATA[
    341. 

  341.   function go()
    342. 

  342.   {
    343. 

  343.   	box = document.forms["0"].navi;
    344. 

  344.   	destination = box.options[box.selectedindex].value;
    345. 

  345.   	if (destination) location.href = destination;
    346. 

  346.   }
    347. 

  347.   function go2()
    348. 

  348.   {
    349. 

  349.   	box2 = document.forms["0"].type;
    350. 

  350.   	destination2 = box2.options[box2.selectedindex].value;
    351. 

  351.   	if (destination2) location.href = destination2;
    352. 

  352.   }
    353. 

  353.   //]]>
    354. 

  354. </script>
    355. 

  355. 

  356. <?php
    357. 

  357. if ($_GET['page'] == "wassup-options") {
    358. 

  358.         //#Current active tabs are indentified after page reload with 
    359. 

  359.         //#  either $_GET['tab']=N or $_POST['submit-optionsN'] where 
    360. 

  360.         //#  N=tab number. The tab is then activated directly in 
    361. 

  361.         //#  "settings.php" with <li class="ui-tabs-selected">
    362. 

  362. ?>
    363. 

  363. <script type="text/javascript">
    364. 

  364.   //<![CDATA[
    365. 

  365.   jQuery(document).ready(function($) {
    366. 

  366.         $('#tabcontainer > ul').tabs({ fx: { opacity: 'toggle' } });
    367. 

  367.   });
    368. 

  368.   //]]>
    369. 

  369. </script>
    370. 

  370. <?php
    371. 

  371. } elseif ($_GET['page'] == "wassup-spy") {
    372. 

  372. 	//## Filter detail lists by visitor type...
    373. 

  373. 	if (isset($_GET['spytype'])) {
    374. 

  374. 		$spytype = htmlentities(attribute_escape($_GET['spytype']));
    375. 

  375. 		$wassup_options->wassup_default_spy_type = $spytype;
    376. 

  376. 	} elseif ($wassup_options->wassup_default_spy_type != '') {
    377. 

  377. 		$spytype = $wassup_options->wassup_default_spy_type;
    378. 

  378. 	}
    379. 

  379. 	$wassup_options->saveSettings();
    380. 

  380. ?>
    381. 

  381. <script type="text/javascript">
    382. 

  382.   //<![CDATA[
    383. 

  383.   jQuery(document).ready(function($){
    384. 

  384.   	$('#spyContainer > div:gt(4)').fadeEachDown(); // initial fade
    385. 

  385.   	$('#spyContainer').spy({ 
    386. 

  386.   		limit: 10, 
    387. 

  387.   		fadeLast: 5, 
    388. 

  388. 		ajax: '<?php echo $wpurl."/wp-content/plugins/".WASSUPFOLDER."/lib/action.php?action=spy&whash=$whash&spytype=$spytype"; ?>',
    389. 

  389.   		timeout: 2000, 
    390. 

  390.   		'timestamp': myTimestamp, 
    391. 

  391. 		fadeInSpeed: 1100 });
    392. 

  392.   });
    393. 

  393. 	
    394. 

  394.   function myTimestamp() {
    395. 

  395.   	var d = new Date();
    396. 

  396.   	var timestamp = d.getFullYear() + '-' + pad(d.getMonth()) + '-' + pad(d.getDate());
    397. 

  397.   	timestamp += ' ';
    398. 

  398.   	timestamp += pad(d.getHours()) + ':' + pad(d.getMinutes()) + ':' + pad(d.getSeconds());
    399. 

  399.   	return timestamp;
    400. 

  400.   }
    401. 

  401. 

  402.   // pad ensures the date looks like 2006-09-13 rather than 2006-9-13
    403. 

  403.   function pad(n) {
    404. 

  404.   	n = n.toString();
    405. 

  405.   	return (n.length == 1 ? '0' + n : n);
    406. 

  406.   }
    407. 

  407. 

  408.   //]]>
    409. 

  409. </script>
    410. 

  410. <?php } //end if page == "wassup-spy"
    411. 

  411. 

  412. } //end if plugin_page == "wassup"
    413. 

  413. } //end function add_wassup_css()
    414. 

  414. 

  415. //put WassUp in the top-level admin menu and add submenus....
    416. 

  416. function wassup_add_pages() {
    417. 

  417. 	global $wassup_options;
    418. 

  418. 	$userlevel = $wassup_options->wassup_userlevel;
    419. 

  419. 	if (empty($userlevel)) { $userlevel = 8; }
    420. 

  420. 	// add the default submenu first (important!)...
    421. 

  421. 	add_submenu_page(WASSUPFOLDER, __('Visitor Details', 'wassup'), __('Visitor Details', 'wassup'), $userlevel, WASSUPFOLDER, 'WassUp'); //<-- WASSUPFOLDER needed here for directory names that include a version number...
    422. 

  422. 	// then add top menu and other submenus...
    423. 

  423. 	add_menu_page('Wassup', 'WassUp', $userlevel, WASSUPFOLDER, 'Wassup');
    424. 

  424. 	add_submenu_page(WASSUPFOLDER, __('Spy Visitors', 'wassup'), __('SPY Visitors', 'wassup'), $userlevel, 'wassup-spy', 'WassUp');
    425. 

  425. 	add_submenu_page(WASSUPFOLDER, __('Current Visitors Online', 'wassup'), __('Current Visitors Online', 'wassup'), $userlevel, 'wassup-online', 'WassUp');
    426. 

  426. 	add_submenu_page(WASSUPFOLDER, __('Options', 'wassup'), __('Options', 'wassup'), $userlevel, 'wassup-options', 'WassUp');
    427. 

  427. }
    428. 

  428. 

  429. function WassUp() {
    430. 

  430.         global $wpdb, $wp_version, $version, $wpurl, $wassup_options, $whash;
    431. 

  431. 	
    432. 

  432. 	// Start getting time of execution to debug SQL query
    433. 

  433. 	$mtime = microtime();
    434. 

  434. 	$mtime = explode(" ",$mtime);
    435. 

  435. 	$mtime = $mtime[1] + $mtime[0];
    436. 

  436. 	$starttime = $mtime;
    437. 

  437. 	// This could be commented out
    438. 

  438. 

  439. 	//#debug...
    440. 

  440. 	//error_reporting(E_ALL | E_STRICT);	//debug, E_STRICT=php5 only
    441. 

  441. 	//ini_set('display_errors','On');	//debug
    442. 

  442. 	//$wpdb->show_errors();	//debug
    443. 

  443. 

  444.         $table_name = $wpdb->prefix . "wassup";
    445. 

  445.         $table_tmp_name = $wpdb->prefix . "wassup_tmp";
    446. 

  446. 	$wassup_options->loadSettings();	//needed in case "update_option is run elsewhere in wassup (widget)
    447. 

  447. 

  448. 	// RUN THE SAVE/RESET OPTIONS
    449. 

  449. 	$admin_message="";
    450. 

  450. 	if (isset($_POST['submit-options']) || 
    451. 

  451. 	    isset($_POST['submit-options2']) || 
    452. 

  452. 	    isset($_POST['submit-options3'])) {
    453. 

  453. 		if ($_POST['wassup_remind_flag'] == 1 AND $_POST['wassup_remind_mb'] == "") {
    454. 

  454. 			$wassup_options->wassup_remind_flag = $_POST['wassup_remind_flag'];
    455. 

  455. 			$wassup_options->wassup_remind_mb = 10;
    456. 

  456. 		} else {
    457. 

  457. 			$wassup_options->wassup_remind_flag = $_POST['wassup_remind_flag'];
    458. 

  458. 			$wassup_options->wassup_remind_mb = $_POST['wassup_remind_mb'];
    459. 

  459. 		}
    460. 

  460. 		$wassup_options->wassup_active = $_POST['wassup_active'];
    461. 

  461. 		$wassup_options->wassup_chart_type = $_POST['wassup_chart_type'];
    462. 

  462. 		$wassup_options->wassup_loggedin = $_POST['wassup_loggedin'];
    463. 

  463. 		$wassup_options->wassup_spider = $_POST['wassup_spider'];
    464. 

  464. 		$wassup_options->wassup_attack = $_POST['wassup_attack'];
    465. 

  465. 		$wassup_options->wassup_hack = $_POST['wassup_hack'];
    466. 

  466. 		$wassup_options->wassup_spamcheck = $_POST['wassup_spamcheck'];
    467. 

  467. 		$wassup_options->wassup_spam = $_POST['wassup_spam'];
    468. 

  468. 		$wassup_options->wassup_refspam = $_POST['wassup_refspam'];
    469. 

  469. 		$wassup_options->wassup_exclude = $_POST['wassup_exclude'];
    470. 

  470. 		$wassup_options->wassup_exclude_url = $_POST['wassup_exclude_url'];
    471. 

  471. 		$wassup_options->delete_auto = $_POST['delete_auto'];
    472. 

  472. 		$wassup_options->delete_auto_size = $_POST['delete_auto_size'];
    473. 

  473. 		$wassup_options->wassup_screen_res = $_POST['wassup_screen_res'];
    474. 

  474. 		$wassup_options->wassup_refresh = $_POST['wassup_refresh'];
    475. 

  475. 		$wassup_options->wassup_userlevel = $_POST['wassup_userlevel'];
    476. 

  476. 		$wassup_options->wassup_dashboard_chart = $_POST['wassup_dashboard_chart'];
    477. 

  477. 		$wassup_options->wassup_geoip_map = $_POST['wassup_geoip_map'];
    478. 

  478. 		$wassup_options->wassup_googlemaps_key = $_POST['wassup_googlemaps_key'];
    479. 

  479. 		$wassup_options->wassup_time_format = $_POST['wassup_time_format'];
    480. 

  480. 		$wassup_options->wassup_default_type = $_POST['wassup_default_type'];
    481. 

  481. 		$wassup_options->wassup_default_limit = $_POST['wassup_default_limit'];
    482. 

  482.                 $top_ten = array("topsearch" => $_POST['topsearch'],
    483. 

  483.                                 "topreferrer" => $_POST['topreferrer'],
    484. 

  484.                                 "toprequest" => $_POST['toprequest'],
    485. 

  485.                                 "topbrowser" => $_POST['topbrowser'],
    486. 

  486.                                 "topos" => $_POST['topos'],
    487. 

  487.                                 "toplocale" => $_POST['toplocale'],
    488. 

  488. 				"topvisitor" => $_POST['topvisitor'],
    489. 

  489.                                 "topfeed" => "0",
    490. 

  490.                                 "topcrawler" => "0",
    491. 

  491.                                 "topreferrer_exclude" => $_POST['topreferrer_exclude']);
    492. 

  492.                 $wassup_options->wassup_top10 = serialize($top_ten);
    493. 

  493. 		/* if ( $_POST['wassup_savepath'] != $wassup_options->wassup_savepath ) {
    494. 

  494. 			if (empty($_POST['wassup_savepath']) || rtrim($_POST['wassup_savepath'],"/") == getSessionpath()) {
    495. 

  495. 				$wassup_options->wassup_savepath = NULL;
    496. 

  496. 			} else {
    497. 

  497. 				$wassup_options->setSavepath($_POST['wassup_savepath']);
    498. 

  498. 			}
    499. 

  499. 		} */
    500. 

  500. 		if ($wassup_options->saveSettings()) {
    501. 

  501. 			$admin_message = __("Wassup options updated successfully","wassup")."." ;
    502. 

  502. 		}
    503. 

  503. 	} elseif (isset($_POST['submit-options4'])) {	//uninstall checkbox
    504. 

  504. 		$wassup_options->wassup_uninstall = $_POST['wassup_uninstall'];
    505. 

  505. 		if ($wassup_options->saveSettings()) {
    506. 

  506. 			$admin_message = __("Wassup uninstall option updated successfully","wassup")."." ;
    507. 

  507. 		}
    508. 

  508. 	} elseif (isset($_POST['submit-spam'])) {
    509. 

  509. 		$wassup_options->wassup_spamcheck = $_POST['wassup_spamcheck'];
    510. 

  510. 		$wassup_options->wassup_spam = $_POST['wassup_spam'];
    511. 

  511. 		$wassup_options->wassup_refspam = $_POST['wassup_refspam'];
    512. 

  512. 		if ($wassup_options->saveSettings()) {
    513. 

  513. 			$admin_message = __("Wassup spam options updated successfully","wassup")."." ;
    514. 

  514. 		}
    515. 

  515. 	} elseif (isset($_POST['reset-to-default'])) {
    516. 

  516. 		$wassup_options->loadDefaults();
    517. 

  517. 		if ($wassup_options->saveSettings()) {
    518. 

  518. 			$admin_message = __("Wassup options updated successfully","wassup")."." ;
    519. 

  519. 		}
    520. 

  520. 	}
    521. 

  521. 

  522. 	//#sets current tab style for Wassup admin submenu?
    523. 

  523. 	if ($_GET['page'] == "wassup-spy") {
    524. 

  524. 		$class_spy="class='current'";
    525. 

  525. 	} elseif ($_GET['page'] == "wassup-options") {
    526. 

  526. 		$class_opt="class='current'";
    527. 

  527. 	} elseif ($_GET['page'] == "wassup-online") {
    528. 

  528. 		$class_ol="class='current'";
    529. 

  529. 	} else {
    530. 

  530. 		$class_sub="class='current'";
    531. 

  531. 	}
    532. 

  532. 

  533. 	//for stringShortener calculated values and max-width...-Helene D. 11/27/07, 12/6/07
    534. 

  534. 	if (!empty($wassup_options->wassup_screen_res)) {
    535. 

  535. 		$screen_res_size = (int) $wassup_options->wassup_screen_res;
    536. 

  536. 	} else { 
    537. 

  537. 		$screen_res_size = 670;
    538. 

  538. 	}
    539. 

  539. 	$max_char_len = ($screen_res_size)/10;
    540. 

  540. 	$screen_res_size = $screen_res_size+20; //for wrap margins...
    541. 

  541. 

  542. 	//for generating page link urls....
    543. 

  543. 	//$wpurl =  get_bloginfo('wpurl');	//global
    544. 

  544. 	$siteurl =  get_bloginfo('siteurl');
    545. 

  545. 

  546. 	//#display an admin message or an alert. This must be above "wrap"
    547. 

  547. 	//# div. -Helene D. 2/26/08.
    548. 

  548. 	if (!empty($admin_message)) {
    549. 

  549. 		$wassup_options->showMessage($admin_message);
    550. 

  550. 	} elseif (!empty($wassup_options->wassup_alert_message)) {
    551. 

  551. 		$wassup_options->showMessage();
    552. 

  552. 		//#show alert message only once, so remove it here...
    553. 

  553. 		$wassup_options->wassup_alert_message = "";
    554. 

  554. 		$wassup_options->saveSettings();
    555. 

  555. 	}
    556. 

  556. 	//#debug - display MySQL errors/warnings
    557. 

  557. 	//$mysqlerror = $wpdb->print_error();	//debug
    558. 

  558. 	//if (!empty($mysqlerror)) { $wassup_options->showMessage($mysqlerror); }	//debug
    559. 

  559. 

  560. 	//moved max-width to single "wrap" div and removed it from 
    561. 

  561. 	//  the individual spans and divs in style.php... ?>
    562. 

  562. 	<div class="wrap" style="max-width:<?php echo $screen_res_size; ?>px;" >
    563. 

  563. 

  564. <?php	// HERE IS THE VISITORS ONLINE VIEW
    565. 

  565. 	if ($_GET['page'] == "wassup-online") { ?>
    566. 

  566. 		<h2><?php _e("Current Visitors Online", "wassup"); ?></h2>
    567. 

  567. 		<p class="legend"><?php echo __("Legend", "wassup").': <span class="box-log">&nbsp;&nbsp;</span> '.__("Logged-in Users", "wassup").' <span class="box-aut">&nbsp;&nbsp;</span> '.__("Comments Authors", "wassup").' <span class="box-spider">&nbsp;&nbsp;</span> '.__("Spiders/bots", "wassup"); ?></p><br />
    568. 

  568. 		<p class="legend"><a href="#" class="toggle-all"><?php _e("Expand All","wassup"); ?></a></p>
    569. 

  569. 		<?php
    570. 

  570. 		$to_date = wassup_get_time();
    571. 

  571. 		$from_date = strtotime('-3 minutes', $to_date);
    572. 

  572. 		$currenttot = $wpdb->get_var("SELECT COUNT(DISTINCT wassup_id) as currenttot FROM $table_tmp_name WHERE `timestamp` BETWEEN $from_date AND $to_date");
    573. 

  573. 		$currenttot = $currenttot+0;	//set to integer
    574. 

  574. 		print "<p class='legend'>".__("Visitors online", "wassup").": <strong>".$currenttot."</strong></p><br />";
    575. 

  575. 		if ($currenttot > 0) {
    576. 

  576. 			$qryC = $wpdb->get_results("SELECT id, wassup_id, max(timestamp) as max_timestamp, ip, hostname, searchengine, urlrequested, agent, referrer, spider, username, comment_author FROM $table_tmp_name WHERE `timestamp` BETWEEN $from_date AND $to_date GROUP BY ip ORDER BY max_timestamp DESC");
    577. 

  577. 		foreach ($qryC as $cv) {
    578. 

  578. 		if ($wassup_options->wassup_time_format == 24) {
    579. 

  579. 			$timed = gmdate("H:i:s", $cv->max_timestamp);
    580. 

  580. 		} else {
    581. 

  581. 			$timed = gmdate("h:i:s a", $cv->max_timestamp);
    582. 

  582. 		}
    583. 

  583. 		$ip_proxy = strpos($cv->ip,",");
    584. 

  584. 		//if proxy, get 2nd ip...
    585. 

  585. 		if ($ip_proxy !== false) {
    586. 

  586. 			$ip = substr($cv->ip,(int)$ip_proxy+1);
    587. 

  587. 		} else { 
    588. 

  588. 			$ip = $cv->ip;
    589. 

  589. 		}
    590. 

  590. 		if ($cv->referrer != '') {
    591. 

  591. 			if (!eregi($wpurl, $cv->referrer) OR $cv->searchengine != "") { 
    592. 

  592. 				if (!eregi($wpurl, $cv->referrer) AND $cv->searchengine == "") {
    593. 

  593. 				$referrer = '<a href="'.$cv->referrer.'" target=_"BLANK"><span style="font-weight: bold;">'.stringShortener($cv->referrer, round($max_char_len*.8,0)).'</span></a>';
    594. 

  594. 				} else {
    595. 

  595. 				$referrer = '<a href="'.$cv->referrer.'" target=_"BLANK">'.stringShortener($cv->referrer, round($max_char_len*.9,0)).'</a>';
    596. 

  596. 				}
    597. 

  597. 			} else { 
    598. 

  598. 			$referrer = __("From your blog", "wassup"); 
    599. 

  599. 			} 
    600. 

  600. 		} else { 
    601. 

  601. 			$referrer = __("Direct hit", "wassup"); 
    602. 

  602. 		} 
    603. 

  603. 		$numurl = $wpdb->get_var("SELECT COUNT(DISTINCT id) as numurl FROM $table_tmp_name WHERE wassup_id='".$cv->wassup_id."'");
    604. 

  604. 	?>
    605. 

  605. 			<div class="sum">
    606. 

  606. 			<span class="sum-box"><?php if ($numurl >= 2) { ?><a  href="#" class="showhide" id="<?php echo $cv->id ?>"><?php print $ip; ?></a><?php } else { ?><?php print $ip; ?><?php } ?></span>
    607. 

  607. 			<div class="sum-det"><span class="det1">
    608. 

  608. 			<?php
    609. 

  609. 			//# html_entity_decode() links that were already 
    610. 

  610. 			//#  "htmlentities-encoded" in database to prevent wacky links
    611. 

  611. 			//#  like "/imagegallery/?album=3&amp;amp;amp;gallery=13"
    612. 

  612. 			print '<a href="'.wAddSiteurl(htmlspecialchars(html_entity_decode($cv->urlrequested))).'" target="_BLANK">';
    613. 

  613. 			print stringShortener(urlencode(html_entity_decode($cv->urlrequested)), round($max_char_len*.9,0)); ?></a></span><br />
    614. 

  614. 			<span class="det2"><strong><?php print $timed; ?> - </strong><?php print $referrer ?></span></div>
    615. 

  615. 			</div>
    616. 

  616. 			<?php // User is logged in or is a comment's author
    617. 

  617. 			if ($cv->username != "" OR $cv->comment_author != "") {
    618. 

  618. 				if ($cv->username != "") {
    619. 

  619. 					$Ousername = '<li class="users"><span class="indent-li-agent">'.__("LOGGED IN USER", "wassup").': <strong>'.$cv->username.'</strong></span></li>'; 
    620. 

  620. 					$Ocomment_author = '<li class="users"><span class="indent-li-agent">'.__("COMMENT AUTHOR", "wassup").': <strong>'.$cv->comment_author.'</strong></span></li>'; 
    621. 

  621. 					$unclass = "userslogged";
    622. 

  622. 				} elseif ($cv->comment_author != "") {
    623. 

  623. 					$Ocomment_author = '<li class="users"><span class="indent-li-agent">'.__("COMMENT AUTHOR", "wassup").': <strong>'.$cv->comment_author.'</strong></span></li>'; 
    624. 

  624. 					$unclass = "users";
    625. 

  625. 				}
    626. 

  626. 			?>
    627. 

  627. 			<ul class="<?php print $unclass; ?>">
    628. 

  628. 				<?php print $Ousername; ?>
    629. 

  629. 				<?php print $Ocomment_author; ?>
    630. 

  630. 			</ul>
    631. 

  631. 			<?php  } ?>
    632. 

  632. 			<div style="display: none;" class="togglenavi navi<?php echo $cv->id ?>">
    633. 

  633. 			<ul class="url">
    634. 

  634. 	<?php 
    635. 

  635. 			$qryCD = $wpdb->get_results("SELECT `timestamp`, urlrequested FROM $table_tmp_name WHERE wassup_id='".$cv->wassup_id."' ORDER BY `timestamp` ASC");
    636. 

  636. 			$i=0;
    637. 

  637. 			foreach ($qryCD as $cd) {	
    638. 

  638. 			$time2 = gmdate("H:i:s", $cd->timestamp);
    639. 

  639. 			$num = ($i&1);
    640. 

  640. 			$char_len = round($max_char_len*.9,0);
    641. 

  641. 			if ($num == 0) $classodd = "urlodd"; else  $classodd = "url";
    642. 

  642. 			if ($i >= 1) {
    643. 

  643. 	?>
    644. 

  644. 				<li class="<?php print $classodd; ?> navi<?php echo $cv->id ?>"><span class="indent-li"><?php print $time2; ?> - 
    645. 

  645. 				<?php
    646. 

  646. 				print '<a href="'.wAddSiteurl(htmlspecialchars(html_entity_decode($cd->urlrequested))).'" target="_BLANK">';
    647. 

  647. 				print stringShortener(urlencode(html_entity_decode($cd->urlrequested)), $char_len).'</a></span></li>'."\n";
    648. 

  648. 			}
    649. 

  649. 			$i++;
    650. 

  650. 			} //end foreach qryCD
    651. 

  651. 			print '</ul>';
    652. 

  652. 			print '</div>';
    653. 

  653. 			print '<p class="sum-footer"></p>';
    654. 

  654. 		} //end foreach qryC
    655. 

  655. 		} //end if currenttot ?>
    656. 

  656. 	<br /><p class="legend"><a href="#" class="toggle-all"><?php _e("Expand All", "wassup"); ?></a></p>
    657. 

  657. 	
    658. 

  658. <?php	// HERE IS THE SPY MODE VIEW
    659. 

  659. 	} elseif ($_GET['page'] == "wassup-spy") { 
    660. 

  660. 	?>
    661. 

  661. 		<h2><?php _e("SPY Visitors", "wassup"); ?></h2>
    662. 

  662. 		<p class="legend"><?php echo __("Legend", "wassup").': <span class="box-log">&nbsp;&nbsp;</span> '.__("Logged-in Users", "wassup").' <span class="box-aut">&nbsp;&nbsp;</span> '.__("Comments Authors", "wassup").' <span class="box-spider">&nbsp;&nbsp;</span> '.__("Spiders/bots", "wassup"); ?></p><br />
    663. 

  663. 		<div>
    664. 

  664. 		<a href="#?" onclick="return pauseSpy();"><span id="spy-pause"><?php _e("Pause", "wassup"); ?></span></a>
    665. 

  665. 		<a href="#?" onclick="return playSpy();"><span id="spy-play"><?php _e("Play", "wassup"); ?></span></a>
    666. 

  666.                 - <span style="font-size: 11px;"><?php _e('Spy items by','wassup'); ?>: <select name="navi" style="font-size: 11px;" onChange="window.location.href=this.options[this.selectedIndex].value;">
    667. 

  667.                 <?php
    668. 

  668.                 //## selectable filter by type of record (wassup_default_spy_type)
    669. 

  669. 		if (isset($_GET['spytype'])) {
    670. 

  670. 			$spytype = htmlentities(attribute_escape($_GET['spytype']));
    671. 

  671. 		} elseif ($wassup_options->wassup_default_spy_type != '') {
    672. 

  672. 			$spytype = $wassup_options->wassup_default_spy_type;
    673. 

  673. 		}
    674. 

  674.                 $selected=$spytype;
    675. 

  675.                 $optionargs="?page=wassup-spy&spytype=";
    676. 

  676.                 $wassup_options->showFormOptions("wassup_default_spy_type","$selected","$optionargs");
    677. 

  677.                 ?>
    678. 

  678.                 </select>
    679. 

  679.                 </span>
    680. 

  680. 		<br />&nbsp;<br /></div>
    681. 

  681. 

  682. 	<?php // GEO IP Map
    683. 

  683. 	if ($wassup_options->wassup_geoip_map == 1 AND $wassup_options->wassup_googlemaps_key != "") { ?>
    684. 

  684. 		<script src="http://maps.google.com/maps?file=api&amp;v=2&amp;key=<?php echo $wassup_options->wassup_googlemaps_key; ?>" type="text/javascript"></script>
    685. 

  685. 		<div id="map" style="width: <?php echo ($screen_res_size*95/100); ?>px; height: 220px;border:2px solid #999;"></div>
    686. 

  686. 		    <script type="text/javascript">
    687. 

  687. 		    //<![CDATA[
    688. 

  688. 		    if (GBrowserIsCompatible()) { 
    689. 

  689. 		      // Display the map, with some controls and set the initial location 
    690. 

  690. 		      var map = new GMap2(document.getElementById("map"));
    691. 

  691. 		      map.addControl(new GSmallMapControl());
    692. 

  692. 		      map.addControl(new GMapTypeControl());
    693. 

  693. 		      //map.enableScrollWheelZoom();
    694. 

  694. 		      map.setCenter(new GLatLng(0,0),3);
    695. 

  695. 		    }
    696. 

  696. 		    // display a warning if the browser was not compatible
    697. 

  697. 		    else {
    698. 

  698. 		      alert("Sorry, the Google Maps API is not compatible with this browser");
    699. 

  699. 		    }
    700. 

  700. 		    //]]>
    701. 

  701. 		    </script>
    702. 

  702. 		<p>&nbsp;</p>
    703. 

  703. 	<? } //end if geoip_map 
    704. 

  704. 	?>
    705. 

  705. 		<div id="spyContainer">
    706. 

  706. 		<?php 
    707. 

  707. 		//display the last few hits here. The rest will be added by spy.js
    708. 

  708. 		$to_date = (wassup_get_time()-2);
    709. 

  709. 		$from_date = ($to_date - 12*(60*60)); //display last 10 visits in 12 hours...
    710. 

  710. 		spyview($from_date,$to_date,10,$spytype); ?>
    711. 

  711. 		</div><br />
    712. 

  712. 

  713. <?php	// HERE IS THE OPTIONS VIEW
    714. 

  714. 	} elseif($_GET['page'] == "wassup-options") {
    715. 

  715. 		//#moved content to external include file, "settings.php"
    716. 

  716. 		//#  to make "wassup" code easier to read and modify 
    717. 

  717. 		//#  -Helene D. 1/15/08.
    718. 

  718. 		include(dirname(__FILE__).'/lib/settings.php'); ?>
    719. 

  719. 

  720. <?php	// HERE IS THE MAIN/DETAILS VIEW
    721. 

  721. 	} else { ?>
    722. 

  722. 		<h2><?php _e("Latest hits", "wassup"); ?></h2>
    723. 

  723. 		<?php if ($wassup_options->wassup_active != 1) { ?>
    724. 

  724. 			<p style="color:red; font-weight:bold;"><?php _e("WassUp recording is disabled", "wassup"); ?></p>
    725. 

  725. 		<?php }
    726. 

  726. 

  727. 		$res = (int) $wassup_options->wassup_screen_res;
    728. 

  728. 		if (empty($res)) $res=620;
    729. 

  729. 		elseif ($res < 800) $res=620;
    730. 

  730. 		elseif ($res < 1024) $res=740;
    731. 

  731. 		elseif ($res < 1200) $res=1000;
    732. 

  732. 		else $res=1000;
    733. 

  733. 

  734. 		//## GET parameters that change options settings
    735. 

  735. 		if (isset($_GET['wchart']) || isset($_GET['wmark'])) { 
    736. 

  736. 			if (isset($_GET['wchart'])) { 
    737. 

  737. 			if ($_GET['wchart'] == 0) {
    738. 

  738. 				$wassup_options->wassup_chart = 0;
    739. 

  739. 			} else {
    740. 

  740. 				$wassup_options->wassup_chart = 1;
    741. 

  741. 			}
    742. 

  742. 			}
    743. 

  743. 			if (isset($_GET['wmark'])) {
    744. 

  744. 			if ($_GET['wmark'] == 0) {
    745. 

  745.                 		$wassup_options->wmark = "0";
    746. 

  746. 				$wassup_options->wip = "";
    747. 

  747. 			} else {
    748. 

  748. 				$wassup_options->wmark = "1";
    749. 

  749. 				$wassup_options->wip = attribute_escape($_GET['wip']);
    750. 

  750. 			}
    751. 

  751. 			}
    752. 

  752. 			$wassup_options->saveSettings();
    753. 

  753. 		}
    754. 

  754. 

  755. 		//## GET params that filter detail display 
    756. 

  756. 		//
    757. 

  757. 		//## Filter detail list by date range...
    758. 

  758. 		$to_date = wassup_get_time();
    759. 

  759. 		if (isset($_GET['last']) && $_GET['last'] != "") { 
    760. 

  760. 			$last = htmlentities(attribute_escape($_GET['last']));
    761. 

  761. 		} else {
    762. 

  762. 			$last = 1; 
    763. 

  763. 		}
    764. 

  764. 		$from_date = strtotime('-'.$last.' day', $to_date);
    765. 

  765. 

  766. 		//## Filter detail lists by visitor type...
    767. 

  767. 		if (isset($_GET['type'])) {
    768. 

  768. 			$type = htmlentities(attribute_escape($_GET['type']));
    769. 

  769. 		} elseif ($wassup_options->wassup_default_type != '') {
    770. 

  770. 			$type = $wassup_options->wassup_default_type;
    771. 

  771. 		}
    772. 

  772. 		$whereis="";
    773. 

  773. 		if ($type == 'spider') {
    774. 

  774. 			$whereis = " AND spider!=''";
    775. 

  775. 		} elseif ($type == 'nospider') {
    776. 

  776. 			$whereis = " AND spider=''";
    777. 

  777. 		} elseif ($type == 'spam') {
    778. 

  778. 			$whereis = " AND spam>0";
    779. 

  779. 		} elseif ($type == 'nospam') {
    780. 

  780. 			$whereis = " AND spam=0";
    781. 

  781. 		} elseif ($type == 'nospamspider') {
    782. 

  782. 			$whereis = " AND spam=0 AND spider=''";
    783. 

  783. 		} elseif ($type == 'searchengine') {
    784. 

  784. 			$whereis = " AND searchengine!='' AND search!=''";
    785. 

  785. 		} elseif ($type == 'referrer') {
    786. 

  786. 			$whereis = " AND referrer!='' AND referrer NOT LIKE '%$wpurl%' AND searchengine='' AND search=''";
    787. 

  787. 		} elseif ($type == 'comauthor') {
    788. 

  788. 			$whereis = " AND comment_author!=''";
    789. 

  789. 		} elseif ($type == 'loggedin') {
    790. 

  790. 			$whereis = " AND username!=''";
    791. 

  791. 		}
    792. 

  792. 

  793. 		//## Filter detail lists by a specific page and number
    794. 

  794. 		//#  of items per page...
    795. 

  795. 		$items = 10;	//default
    796. 

  796. 		if (isset($_GET['limit']) && is_numeric($_GET['limit'])) {
    797. 

  797. 			//$items = htmlentities(attribute_escape($_GET['limit'])); 
    798. 

  798. 			$items = $_GET['limit']; 
    799. 

  799. 		} elseif ($wassup_options->wassup_default_limit != '') {
    800. 

  800. 			$items = $wassup_options->wassup_default_limit;
    801. 

  801. 		}
    802. 

  802. 		if ((int)$items < 1 ) { $items = 10; }
    803. 

  803. 		//# current page selections
    804. 

  804. 		if (isset($_GET['pages']) && is_numeric($_GET['pages'])) {
    805. 

  805. 			$pages = (int)$_GET['pages'];
    806. 

  806. 		} else {
    807. 

  807. 			$pages = 1;
    808. 

  808. 		}
    809. 

  809. 		if ( $pages > 1 ) {
    810. 

  810. 			$limit = " LIMIT ".(($pages-1)*$items).",$items";
    811. 

  811. 		} else {
    812. 

  812. 			$limit = " LIMIT $items";
    813. 

  813. 		}
    814. 

  814. 

  815. 		//## Filter detail lists by a searched item
    816. 

  816.                 if (!empty($_GET['search'])) { 
    817. 

  817.                         $search = attribute_escape($_GET['search']);
    818. 

  818.                 } else {
    819. 

  819.                         $search = "";
    820. 

  820.                 }
    821. 

  821. 

  822.                 // DELETE EVERY RECORD MARKED BY IP
    823. 

  823.                 //#  Delete limited to selected date range only. -Helene D. 3/4/08.
    824. 

  824.                 if (!empty($_GET['deleteMARKED']) && $wassup_options->wmark == "1" ) {
    825. 

  825.                         $rec_deleted = $wpdb->get_var("SELECT COUNT(ip) as deleted FROM $table_name WHERE ip='".urlencode(attribute_escape($_GET['dip']))."' AND `timestamp` BETWEEN $from_date AND $to_date");
    826. 

  826.                         if (method_exists($wpdb,'prepare')) {
    827. 

  827.                                 $wpdb->query($wpdb->prepare("DELETE FROM $table_name WHERE ip='%s' AND `timestamp` BETWEEN %s AND %s", urlencode(attribute_escape($_GET['dip'])), $from_date, $to_date));
    828. 

  828.                         } else {
    829. 

  829.                                 $wpdb->query("DELETE FROM $table_name WHERE ip='".urlencode(attribute_escape($_GET['dip']))."' AND `timestamp` BETWEEN $from_date AND $to_date");
    830. 

  830.                         }
    831. 

  831.                         echo '<p><strong>'.$rec_deleted.' '.__('records deleted','wassup').'</strong></p>';
    832. 

  832.                         //reset wmark/deleteMarked after delete and
    833. 

  833.                         //  clean up $_SERVER['QUERY_STRING'] as it is
    834. 

  834.                         //  used in filter selections below...
    835. 

  835.                         $remove_query= array("&dip=".$_GET['dip'],"&deleteMARKED=".$_GET['deleteMARKED'],"&wmark=1","&wip=".$_GET['wip']);
    836. 

  836.                         $new_query = str_replace($remove_query,"",$_SERVER['QUERY_STRING']);
    837. 

  837.                         $_SERVER['QUERY_STRING']=$new_query;
    838. 

  838.                         $wassup_options->wmark = "0";
    839. 

  839.                         $wassup_options->wip = null;
    840. 

  840.                         $wassup_options->saveSettings();
    841. 

  841.                 }
    842. 

  842. 

  843. 		// Instantiate class to count items
    844. 

  844. 		$Tot = New MainItems;
    845. 

  845. 		$Tot->tableName = $table_name;
    846. 

  846. 		$Tot->from_date = $from_date;
    847. 

  847. 		$Tot->to_date = $to_date;
    848. 

  848. 		$Tot->whereis = $whereis;
    849. 

  849. 		$Tot->Limit = $limit;
    850. 

  850. 		$Tot->WpUrl = $wpurl;
    851. 

  851. 

  852. 		$itemstot = $Tot->calc_tot("count", $search, null, "DISTINCT");
    853. 

  853. 		$pagestot = $Tot->calc_tot("count", $search, null, null);
    854. 

  854. 		$spamtot = $Tot->calc_tot("count", $search, "AND spam>0");
    855. 

  855. 		// Check if some records was marked
    856. 

  856. 		if ($wassup_options->wmark == "1") {
    857. 

  857. 			$markedtot = $Tot->calc_tot("count", $search, "AND ip LIKE '%".$wassup_options->wip."%'", "DISTINCT");
    858. 

  858. 		}
    859. 

  859. 		// Check if some records was searched
    860. 

  860. 		if (!empty($search)) {
    861. 

  861. 			$searchtot = $Tot->calc_tot("count", $search, null, "DISTINCT");
    862. 

  862. 		} ?>
    863. 

  863.                 <form><table width="100%">
    864. 

  864.                 <tr>
    865. 

  865.                 <td>
    866. 

  866.                 <p class="legend">
    867. 

  867.                 <?php if ($wassup_options->wassup_chart == "1") { ?>
    868. 

  868.                         <a href="<?php echo '?page='.WASSUPFOLDER.'&wchart=0&last='.$last.'&limit='.$items.'&type='.$_GET['type'].'&search='.$search.'&pages='.$pages; ?>" style="text-decoration:none;">
    869. 

  869.                         <img src="<?php echo $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/img/chart_delete.png" style="padding:0px 6px 0 0;" alt="'.__('hide chart','wassup').'" title="'.__('Hide the chart and site usage','wassup'); ?>" /></a>
    870. 

  870.                 <?php } else { ?>
    871. 

  871.                         <a href="<?php echo '?page='.WASSUPFOLDER.'&wchart=1&last='.$last.'&limit='.$items.'&type='.$_GET['type'].'&search='.$search.'&pages='.$pages; ?>" style="text-decoration:none;">
    872. 

  872.                         <img src="<?php echo $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/img/chart_add.png" style="padding:0px 6px 0 0;" alt="'.__('show chart','wassup').'" title="'.__('Show the chart and site usage','wassup'); ?>" /></a>
    873. 

  873.                 <?php }
    874. 

  874. 

  875. 		//## Show selectable detail filters...
    876. 

  876. 		if (isset($_GET['limit'])) {
    877. 

  877. 			$new_limit = eregi_replace("\&limit=".$_GET['limit']."", "", $_SERVER['QUERY_STRING']);
    878. 

  878. 		} else { 
    879. 

  879. 			$new_limit = $_SERVER['QUERY_STRING'];
    880. 

  880. 		}
    881. 

  881. 		if (isset($_GET['last'])) {
    882. 

  882. 			$new_last = eregi_replace("\&last=".$_GET['last']."", "", $_SERVER['QUERY_STRING']);
    883. 

  883. 		} else {
    884. 

  884. 			$new_last = $_SERVER['QUERY_STRING'];
    885. 

  885. 		}
    886. 

  886.                 _e('Summary for the last','wassup'); ?>
    887. 

  887.                 <select style="font-size: 11px;" name="last" onChange="window.location.href=this.options[this.selectedIndex].value;">
    888. 

  888.                 <?php
    889. 

  889.                 //## selectable filter by date range
    890. 

  890.                 echo "
    891. 

  891.                 <option value='?$new_last&last=1'".($_GET['last'] == 1 ? " SELECTED" : "").">".__('24 hours','wassup')."</option>
    892. 

  892.                 <option value='?$new_last&last=7'".($_GET['last'] == 7 ? " SELECTED" : "").">".__('7 days','wassup')."</option>
    893. 

  893.                 <option value='?$new_last&last=30'".($_GET['last'] == 30 ? " SELECTED" : "").">".__('1 month','wassup')."</option>
    894. 

  894.                 <option value='?$new_last&last=365'".($_GET['last'] == 365 ? " SELECTED" : "").">".__('1 year','wassup')."</option>"; ?>
    895. 

  895.                 </select></p>
    896. 

  896.                 </td>
    897. 

  897.                 <td align="right"><p style="font-size: 11px;"><?php _e('Items per page','wassup'); ?>: <select name="navi" style="font-size: 11px;" onChange="window.location.href=this.options[this.selectedIndex].value;">
    898. 

  898.                 <?php
    899. 

  899.                 //## selectable filter by number of items on page (default_limit)
    900. 

  900.                 $selected=$items;
    901. 

  901.                 $optionargs="?$new_limit&limit=";
    902. 

  902.                 $wassup_options->showFormOptions("wassup_default_limit","$selected","$optionargs");
    903. 

  903.                 ?>
    904. 

  904.                 </select> - <?php _e('Show items by','wassup'); ?>: <select style="font-size: 11px;" name="type" onChange="window.location.href=this.options[this.selectedIndex].value;">
    905. 

  905.                 <?php
    906. 

  906.                 //## selectable filter by type of record (wassup_default_type)
    907. 

  907.                 $selected=$type;
    908. 

  908.                 $optionargs="?page=".WASSUPFOLDER."&type=";
    909. 

  909.                 $wassup_options->showFormOptions("wassup_default_type","$selected","$optionargs");
    910. 

  910.                 ?>
    911. 

  911.                 </select>
    912. 

  912.                 </p>
    913. 

  913.                 </td>
    914. 

  914.                 </tr>
    915. 

  915.                 </table>
    916. 

  916.                 </form>
    917. 

  917. 

  918. 		<?php // Print Site Usage
    919. 

  919.                 if ($wassup_options->wassup_chart == 1) { ?>
    920. 

  920.         <div class='main-tabs'>
    921. 

  921.                 <div id='usage'>
    922. 

  922.                         <ul>
    923. 

  923.                         <li><span style="border-bottom:2px solid #0077CC;"><?php echo $itemstot; ?></span> <small><?php _e('Visits','wassup'); ?></small></li>
    924. 

  924.                         <li><span style="border-bottom:2px dashed #FF6D06;"><?php echo $pagestot; ?></span> <small><?php _e('Pageviews','wassup'); ?></small></li>
    925. 

  925.                         <li><span><?php echo @number_format(($pagestot/$itemstot), 2); ?></span> <small><?php _e('Pages/Visits','wassup'); ?></small></li>
    926. 

  926.                         <?php // Print spam usage only if enabled
    927. 

  927. 			if ($wassup_options->wassup_spamcheck == 1) { ?>
    928. 

  928. 			<li><span><a href="#TB_inline?height=180&width=300&inlineId=hiddenspam" class="thickbox"><?php echo $spamtot; ?></a></span> <span>(<?php echo @number_format(($spamtot*100/$pagestot), 2); ?>%)</span> <small><?php _e('Spams','wassup'); ?></small></li>
    929. 

  929. 			<?php } ?>
    930. 

  930.                         </ul>
    931. 

  931.                 <?php
    932. 

  932.                 // Print the Google chart!
    933. 

  933.                 if ($pagestot > 20) {
    934. 

  934.                         echo $Tot->TheChart($last, $res, "125", $search, $wassup_options->wassup_chart_type, "bg,s,ffffff")."";
    935. 

  935.                 } else {
    936. 

  936.                         echo '<div id="placeholder" align="center"><p style="padding-top:50px;">'.__('Too few records to print chart','wassup').'...</p></div>';
    937. 

  937.                 } ?>
    938. 

  938.                 </div>
    939. 

  939.         </div>
    940. 

  940.         <?php   } //end if wassup_chart == 1
    941. 

  941. 	
    942. 

  942. 		if (!isset($_GET['limit']) OR $_GET['limit'] == 10 OR $_GET['limit'] == 20) { 
    943. 

  943. 		
    944. 

  944. 			$expcol = '
    945. 

  945. 		<table width="100%"><tr>
    946. 

  946. 		<td align="left" class="legend"><a href="#" class="toggle-all">'.__('Expand All','wassup').'</a></td>
    947. 

  947. 		<td align="right" class="legend"><a href="#" class="toggle-allcrono">'.__('Collapse Chronology','wassup').'</a></td>
    948. 

  948. 		</tr></table><br />';
    949. 

  949. 		}
    950. 

  950. 		
    951. 

  951. 		// MAIN QUERY
    952. 

  952. 		$main = $Tot->calc_tot("main", $search);
    953. 

  953. 

  954. 		if ($itemstot > 0) {
    955. 

  955. 		$p=new pagination();
    956. 

  956. 		$p->items($itemstot);
    957. 

  957. 		$p->limit($items);
    958. 

  958. 		$p->currentPage($pages);
    959. 

  959. 		$p->target("admin.php?page=".WASSUPFOLDER."&limit=$items&type=$type&last=$last&search=$search");
    960. 

  960. 		$p->calculate();
    961. 

  961. 		$p->adjacents(5);
    962. 

  962. 		}
    963. 

  963. 

  964. 		// hidden spam options
    965. 

  965.                 ?>
    966. 

  966.                 <div id="hiddenspam" style="display:none;">
    967. 

  967.         <h2><?php _e('Spam Options','wassup'); ?></h2>
    968. 

  968.         <form action="" method="post">
    969. 

  969. 	<p><input type="checkbox" name="wassup_spamcheck" value="1" <?php if($wassup_options->wassup_spamcheck == 1 ) print "CHECKED"; ?> /> <strong><?php _e('Enable/Disable Spam Check on Records','wassup'); ?></strong></p>
    970. 

  970.         <p style="padding-left:30px;"><input type="checkbox" name="wassup_spam" value="1" <?php if($wassup_options->wassup_spam == 1) print "CHECKED"; ?> /> <?php _e('Record Akismet comment spam attempts','wassup'); ?></p>
    971. 

  971.         <p style="padding-left:30px;"><input type="checkbox" name="wassup_refspam" value="1" <?php if($wassup_options->wassup_refspam == 1) print "CHECKED"; ?> /> <?php _e('Record referrer spam attempts','wassup'); ?></p>
    972. 

  972.         <p style="padding-left:0;"><input type="submit" name="submit-spam" value="<?php _e('Save Settings','wassup'); ?>" /></p>
    973. 

  973.         </form>
    974. 

  974.                 </div>
    975. 

  975.                 <table width="100%">
    976. 

  976.                 <tr>
    977. 

  977.                 <td align="left" class="legend">
    978. 

  978.                 <?php
    979. 

  979. 		// Marked items - Refresh
    980. 

  980.                 if ($wassup_options->wmark == 1) echo '<a href="?'.$_SERVER['QUERY_STRING'].'&search='.$wassup_options->wip.'" title="'.__('Filter by marked IP','wassup').'"><strong>'.$markedtot.'</strong> '.__('show marked items','wassup').'</a> - ';
    981. 

  981.                 if (!empty($search)) print "<strong>$searchtot</strong> ".__('Searched for','wassup').": <strong>$search</strong> - ";
    982. 

  982.                 echo __('Auto refresh in','wassup').' <span id="CountDownPanel"></span> '.__('seconds','wassup'); ?>
    983. 

  983. 		</td>
    984. 

  984. 		<td align="right" class="legend"><a href="<?php echo $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/lib/action.php?action=topten&whash='.$whash.'&from_date='.$from_date.'&to_date='.$to_date.'&width='.$res.'&height=400'; ?>" class="thickbox" title="Wassup <?php _e('Top Ten','wassup'); ?>"><?php _e('Show Top Ten','wassup'); ?></a> - <a href="#" class='show-search'><?php _e('Search','wassup'); ?></a></td>
    985. 

  985.                 </tr>
    986. 

  986.                 </table>
    987. 

  987. <div class="search-ip" style="display: none;">
    988. 

  988. 	<table border=0 width="100%">
    989. 

  989. 		<tr valign="top">
    990. 

  990. 		<td align="right">
    991. 

  991.         	<form action="" method="get">
    992. 

  992. 		<input type="hidden" name="page" value="<?php echo WASSUPFOLDER; ?>" />
    993. 

  993. 			<input type="text" size="25" name="search" value="<?php if ($search != "") print $search; ?>" /><input type="submit" name="submit-search" value="search" />
    994. 

  994. 		</form>
    995. 

  995. 		</td>
    996. 

  996. 		</tr>
    997. 

  997. 	</table>
    998. 

  998. </div>
    999. 

  999. <?php
    1000. 

  1000. 	//# Detailed List of Wassup Records...
    1001. 

  1001. 	print $expcol;
    1002. 

  1002.         //# Show Page numbers/Links...
    1003. 

  1003.         if ($itemstot >= 10) {
    1004. 

  1004.                 print "\n".'<div id="pag" align="center">'.$p->show().'</div><br />'."\n";
    1005. 

  1005.         }
    1006. 

  1006. 	if ($itemstot > 0) {
    1007. 

  1007. 	foreach ($main as $rk) {
    1008. 

  1008. 		$timestampF = $rk->max_timestamp;
    1009. 

  1009. 		$dateF = gmdate("d M Y", $timestampF);
    1010. 

  1010. 		if ($wassup_options->wassup_time_format == 24) {
    1011. 

  1011. 			$datetimeF = gmdate('Y-m-d H:i:s', $timestampF);
    1012. 

  1012. 			$timeF = gmdate("H:i:s", $timestampF);
    1013. 

  1013. 		} else {
    1014. 

  1014. 			$datetimeF = gmdate('Y-m-d h:i:s a', $timestampF);
    1015. 

  1015. 			$timeF = gmdate("h:i:s a", $timestampF);
    1016. 

  1016. 		}
    1017. 

  1017. 		//$ip = @explode(",", $rk->ip);
    1018. 

  1018. 		$ip_proxy = strpos($rk->ip,",");
    1019. 

  1019. 		//if proxy, get 2nd ip...
    1020. 

  1020. 		if ($ip_proxy !== false) {
    1021. 

  1021. 			$ip = substr($rk->ip,(int)$ip_proxy+1);
    1022. 

  1022. 		} else { 
    1023. 

  1023. 			$ip = $rk->ip;
    1024. 

  1024. 		}
    1025. 

  1025. 

  1026. 		// Visitor Record - raw data (hidden)
    1027. 

  1027. 		$raw_div="raw-".substr($rk->wassup_id,0,25).rand(0,99);
    1028. 

  1028. 		echo "\n"; ?>
    1029. 

  1029.                 <div id="<?php echo $raw_div; ?>" style="display:none; padding-top:7px;" >
    1030. 

  1030.                 <h2><?php _e("Raw data","wassup"); ?>:</h2>
    1031. 

  1031.                 <style type="text/css">.raw { color: #542; padding-left:5px; }</style>
    1032. 

  1032.                 <ul style="list-style-type:none;padding:20px 0 0 30px;">
    1033. 

  1033. 		<li><?php echo __("Visit type","wassup").': <span class="raw">';
    1034. 

  1034.                 if ($rk->username != "") { 
    1035. 

  1035. 			echo __("Logged-in user","wassup").' - '.$rk->username;
    1036. 

  1036. 		} elseif ($rk->spam == "1" || $rk->spam == "2" ) { 
    1037. 

  1037.                 	_e("Spammer","wassup");
    1038. 

  1038. 		} elseif ($rk->comment_author != "") { 
    1039. 

  1039.                 	echo __("Comment author","wassup").' - '.$rk->comment_author;
    1040. 

  1040. 		} elseif ($rk->feed != "") { 
    1041. 

  1041.                 	echo __("Feed","wassup").' - '.$rk->feed;
    1042. 

  1042. 		} elseif ($rk->spider != "") { 
    1043. 

  1043. 			echo __("Spider","wassup").' - '.$rk->spider;
    1044. 

  1044. 		} else {
    1045. 

  1045. 			 _e("Regular visitor","wassup");
    1046. 

  1046. 		}
    1047. 

  1047. 		echo '</span>'; ?></li>
    1048. 

  1048.                 <li><?php echo __("IP","wassup").': <span class="raw">'.$rk->ip.'</span>'; ?></li>
    1049. 

  1049.                 <li><?php echo __("Hostname","wassup").': <span class="raw">'.$rk->hostname.'</span>'; ?></li>
    1050. 

  1050.                 <li><?php echo __("Url Requested","wassup").': <span class="raw">'.htmlspecialchars(html_entity_decode(clean_url($rk->urlrequested))).'</span>'; ?></li>
    1051. 

  1051.                 <li><?php echo __("User Agent","wassup").': <span class="raw">'.$rk->agent.'</span>'; ?></li>
    1052. 

  1052.                 <li><?php echo __("Referrer","wassup").': <span class="raw">'.urldecode($rk->referrer).'</span>'; ?></li>
    1053. 

  1053.                 <?php if ($rk->search != "") { ?>
    1054. 

  1054.                 <li><?php echo __("Search Engine","wassup").': <span class="raw">'.$rk->searchengine.'</span> &nbsp; &nbsp; ';
    1055. 

  1055. 		echo __("Search","wassup").': <span class="raw">'.$rk->search.'</span>'; ?></li>
    1056. 

  1056.                 <?php }
    1057. 

  1057.                 if ($rk->os != "") { ?>
    1058. 

  1058.                 <li><?php echo __("OS","wassup").': <span class="raw">'.$rk->os.'</span>'; ?></li>
    1059. 

  1059.                 <?php }
    1060. 

  1060.                 if ($rk->browser != "") { ?>
    1061. 

  1061.                 <li><?php echo __("Browser","wassup").': <span class="raw">'.$rk->browser.'</span>'; ?></li>
    1062. 

  1062.                 <?php }
    1063. 

  1063.                 if ($rk->language != "") { ?>
    1064. 

  1064.                 <li><?php echo __("Locale/Language","wassup").': <span class="raw">'.$rk->language.'</span>'; ?></li>
    1065. 

  1065.                 <?php } ?>
    1066. 

  1066.                 <li><?php echo 'Wassup ID'.': <span class="raw">'.$rk->wassup_id.'</span>'; ?></li>
    1067. 

  1067.                 <li><?php echo __("End timestamp","wassup").': <span class="raw">'.$datetimeF.' ( '.$rk->max_timestamp.' )</span>'; ?></li>
    1068. 

  1068.                 </ul>
    1069. 

  1069.                 </div> <!-- raw-wassup_id -->
    1070. 

  1070. 

  1071.                 <?php //Visitor Record - detail listing
    1072. 

  1072. 		if ($rk->referrer != '') {
    1073. 

  1073. 			if (!eregi($wpurl, $rk->referrer) OR $rk->searchengine != "") { 
    1074. 

  1074. 				if (!eregi($wpurl, $rk->referrer) AND $rk->searchengine == "") {
    1075. 

  1075. 				$referrer = '<a href="'.$rk->referrer.'" target="_BLANK"><span style="font-weight: bold;">'.stringShortener($rk->referrer, round($max_char_len*.8,0)).'</span></a>';
    1076. 

  1076. 				} else {
    1077. 

  1077. 				$referrer = '<a href="'.$rk->referrer.'" target="_BLANK">'.stringShortener($rk->referrer, round($max_char_len*.9,0)).'</a>';
    1078. 

  1078. 				}
    1079. 

  1079. 			} else { 
    1080. 

  1080.                         $referrer = __('From your blog','wassup');
    1081. 

  1081.                         }
    1082. 

  1082.                 } else { 
    1083. 

  1083.                         $referrer = __('Direct hit','wassup');
    1084. 

  1084. 		} 
    1085. 

  1085. 		$numurl = $wpdb->get_var("SELECT COUNT(DISTINCT id) as numurl FROM $table_name WHERE wassup_id='".$rk->wassup_id."'");
    1086. 

  1086. 		if ($rk->hostname != "") $hostname = $rk->hostname; else $hostname = "unknown";
    1087. 

  1087. 	?>
    1088. 

  1088. 

  1089. 		<div class="delID<?php echo $rk->wassup_id ?>">
    1090. 

  1090.                 <div class="<?php if ($wassup_options->wmark == 1 AND $wassup_options->wip == $ip) echo "sum-nav-mark"; else echo "sum-nav"; ?>">
    1091. 

  1091. 

  1092.                 <p class="delbut">
    1093. 

  1093.                 <?php // Mark/Unmark IP
    1094. 

  1094.                 if ($wassup_options->wmark == 1 AND $wassup_options->wip ==  $ip) { ?>
    1095. 

  1095.                         <a  href="?<?php echo $_SERVER['QUERY_STRING']; ?>&deleteMARKED=1&dip=<?php print $ip; ?>" style="text-decoration:none;">
    1096. 

  1096.                         <img src="<?php echo $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/img/cross.png" alt="'.__('delete','wassup').'" title="'.__('Delete ALL marked records with this IP','wassup'); ?>" /></a>
    1097. 

  1097.                         <a href="?page=<?php echo WASSUPFOLDER; ?>&wmark=0" style="text-decoration:none;">
    1098. 

  1098.                         <img src="<?php echo $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/img/error_delete.png" alt="'.__('unmark','wassup').'" title="'.__('UnMark IP','wassup'); ?>" /></a>
    1099. 

  1099.                 <?php } else { ?>
    1100. 

  1100.                         <a  href="#" class="deleteID" id="<?php echo $rk->wassup_id ?>" style="text-decoration:none;">
    1101. 

  1101.                         <img src="<?php echo $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/img/cross.png" alt="'.__('delete','wassup').'" title="'.__('Delete this record','wassup'); ?>" /></a>
    1102. 

  1102.                         <a href="?<?php echo $_SERVER['QUERY_STRING']; ?>&wmark=1&wip=<?php print $ip; ?>" style="text-decoration:none;">
    1103. 

  1103.                         <img src="<?php echo $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/img/error_add.png" alt="'.__('mark','wassup').'" title="'.__('Mark IP','wassup'); ?>" /></a>
    1104. 

  1104.                 <?php } ?>
    1105. 

  1105.                 <a href="#TB_inline?height=400&width=<?php echo $res.'&inlineId='.$raw_div; ?>" class="thickbox">
    1106. 

  1106.                 <img src="<?php echo $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/img/database_table.png" alt="'.__('show raw table','wassup').'" title="'.__('Show the items as raw table','wassup'); ?>" /></a>
    1107. 

  1107.                 </p>
    1108. 

  1108. 

  1109. 			<span class="sum-box"><?php if ($numurl >= 2) { ?><a  href="#" class="showhide" id="<?php echo $rk->id ?>"><?php print $ip; ?></a><?php } else { ?><?php print $ip; ?><?php } ?></span>
    1110. 

  1110. 			<span class="sum-date"><?php print $datetimeF; ?></span>
    1111. 

  1111. 			<div class="sum-det"><span class="det1">
    1112. 

  1112. 			<?php 
    1113. 

  1113. 			print '<a href="'.wAddSiteurl(htmlspecialchars(html_entity_decode(clean_url($rk->urlrequested)))).'" target="_BLANK">';
    1114. 

  1114. 			print stringShortener(urlencode(html_entity_decode(clean_url($rk->urlrequested))), round($max_char_len*.8,0)); ?></a>
    1115. 

  1115.                         </span><br />
    1116. 

  1116.                         <span class="det2"><strong><?php _e('Referrer','wassup'); ?>: </strong><?php print $referrer; ?><br /><strong><?php _e('Hostname','wassup'); ?>:</strong> <a  href="#" class="toggleagent" id="<?php echo $rk->id ?>"><?php print $hostname; ?></a></span></div>
    1117. 

  1117.                         </div>
    1118. 

  1118. 			<div style="margin-left: auto; margin-right: auto;">
    1119. 

  1119. 			<div style="display: none;" class="togglenavi naviagent<?php echo $rk->id ?>">
    1120. 

  1120. 			<ul class="useragent">
    1121. 

  1121. 				<li class="useragent"><span class="indent-li-agent"><?php _e('User Agent','wassup'); ?>: <strong><?php print $rk->agent; ?></strong></span></li>
    1122. 

  1122. 			</ul>
    1123. 

  1123. 			</div>
    1124. 

  1124. 			<?php // Referer is search engine
    1125. 

  1125. 			if ($rk->searchengine != "") {
    1126. 

  1126. 				if (eregi("images", $rk->searchengine)) {
    1127. 

  1127. 					$bg = 'style="background: #e5e3ec;"';
    1128. 

  1128. 					$page = (number_format(($rk->searchpage / 19), 0) * 18); 
    1129. 

  1129. 					$Apagenum = explode(".", number_format(($rk->searchpage / 19), 1));
    1130. 

  1130. 					$pagenum = ($Apagenum[0] + 1);
    1131. 

  1131. 					$url = parse_url($rk->referrer); 
    1132. 

  1132. 					$ref = $url['scheme']."://".$url['host']."/images?q=".eregi_replace(" ", "+", $rk->search)."&start=".$page;
    1133. 

  1133. 				} else {
    1134. 

  1134. 					$bg = 'style="background: #e4ecf4;"';
    1135. 

  1135. 					$pagenum = $rk->searchpage;
    1136. 

  1136. 					$ref = $rk->referrer;
    1137. 

  1137. 				}
    1138. 

  1138. 			?>
    1139. 

  1139. 			<ul class="searcheng" <?php print $bg; ?>>
    1140. 

  1140.                                 <li class="searcheng"><span class="indent-li-agent"><?php _e('SEARCH ENGINE','wassup'); ?>: <strong><?php print $rk->searchengine." (".__("page","wassup").": $pagenum)"; ?></strong></span></li>
    1141. 

  1141.                                 <li class="searcheng"><?php _e("KEYWORDS","wassup"); ?>: <strong><a href="<?php print $ref;  ?>" target="_BLANK"><?php print stringShortener($rk->search, round($max_char_len*.52,0)); ?></a></strong></li>
    1142. 

  1142. 			</ul>
    1143. 

  1143. 			<?php 
    1144. 

  1144. 			} ?>
    1145. 

  1145. 			<?php
    1146. 

  1146. 			// User is logged in or is a comment's author
    1147. 

  1147. 			if ($rk->username != "" OR $rk->comment_author != "") {
    1148. 

  1148. 				if ($rk->username != "") {
    1149. 

  1149. 					$Ocomment_author = '<li class="users"><span class="indent-li-agent">'.__("LOGGED IN USER","wassup").': <strong>'.$rk->username.'</strong></span></li>
    1150. 

  1150. 				<li class="users"><span class="indent-li-agent">'.__("COMMENT AUTHOR","wassup").': <strong>'.$rk->comment_author.'</strong></span></li>';
    1151. 

  1151. 					$unclass = "userslogged";
    1152. 

  1152. 				} elseif ($rk->comment_author != "") {
    1153. 

  1153. 					$Ocomment_author = '<li class="users"><span class="indent-li-agent">'.__("COMMENT AUTHOR","wassup").': <strong>'.utf8_decode($rk->comment_author).'</strong></span></li>';
    1154. 

  1154. 					$unclass = "users";
    1155. 

  1155. 				}
    1156. 

  1156. 			?>
    1157. 

  1157. 			<ul class="<?php print $unclass; ?>">
    1158. 

  1158. 				<?php print $Ocomment_author; ?>
    1159. 

  1159. 			</ul>
    1160. 

  1160. 			<?php  } ?>
    1161. 

  1161. 			<?php // Referer is a Spider or Bot
    1162. 

  1162. 			if ($rk->spider != "") {
    1163. 

  1163. 			if ($rk->feed != "") { ?>
    1164. 

  1164. 			<ul style="background:#fdeec8;" class="spider">
    1165. 

  1165.                                 <li class="feed"><span class="indent-li-agent"><?php _e('FEEDREADER','wassup'); ?>: <strong><?php print $rk->spider; ?></strong></span></li>
    1166. 

  1166. 				<?php if (is_numeric($rk->feed)) { ?>
    1167. 

  1167.                                 <li class="feed"><span class="indent-li-agent"><?php _e('SUBSCRIBER(S)','wassup'); ?>: <strong><?php print (int)$rk->feed; ?></strong></span></li>
    1168. 

  1168. 				<?php  } ?>
    1169. 

  1169.                         </ul>
    1170. 

  1170.                         <?php  } else { ?>
    1171. 

  1171.                         <ul class="spider">
    1172. 

  1172.                                 <li class="spider"><span class="indent-li-agent"><?php _e('SPIDER','wassup'); ?>: <strong><?php print $rk->spider; ?></strong></span></li>
    1173. 

  1173. 			</ul>
    1174. 

  1174. 			<?php  }
    1175. 

  1175. 			} ?>
    1176. 

  1176.                         <?php // Referer is a SPAM
    1177. 

  1177.                         if ($rk->spam > 0 && $rk->spam < 3) { ?>
    1178. 

  1178.                         <ul class="spam">
    1179. 

  1179. 			<li class="spam"><span class="indent-li-agent">
    1180. 

  1180. 				<?php _e("Probably SPAM!","wassup"); 
    1181. 

  1181. 				if ($rk->spam==2) { echo '('.__("Referer Spam","wassup").')'; }
    1182. 

  1182. 				else { echo '(Akismet '.__("Spam","wassup").')'; }  ?>
    1183. 

  1183. 				</span></li>
    1184. 

  1184.                         </ul>
    1185. 

  1185.                         <?php  } elseif ($rk->spam == 3) { ?>
    1186. 

  1186.                         <ul class="spam">
    1187. 

  1187. 			<li class="spam"><span class="indent-li-agent">
    1188. 

  1188. 				<?php _e("Probably hack attempt!","wassup"); ?>
    1189. 

  1189.                         </li></ul>
    1190. 

  1190.                         <?php  } ?>
    1191. 

  1191. 			<?php // User os/browser/language
    1192. 

  1192. 			if ($rk->spider == "" AND ($rk->os != "" OR $rk->browser != "")) {
    1193. 

  1193. 			?>
    1194. 

  1194. 			<ul class="agent">
    1195. 

  1195. 			<li class="agent"><span class="indent-li-agent">
    1196. 

  1196. 				<?php if ($rk->language != "") { ?>
    1197. 

  1197. 				<img src="<?php echo $wpurl.'/wp-content/plugins/'.WASSUPFOLDER.'/img/flags/'.strtolower($rk->language).'.png'.'" alt="'.strtolower($rk->language).'" title="'.__("Language","wassup").': '.strtolower($rk->language); ?>" />
    1198. 

  1198. 				<?php }
    1199. 

  1199. 				_e("OS","wassup"); ?>: <strong><?php print $rk->os; ?></strong></span></li>
    1200. 

  1200. 			<li class="agent"><?php _e("BROWSER","wassup"); ?>: <strong><?php print $rk->browser; ?></strong></li>
    1201. 

  1201. 			<?php if ($rk->screen_res != "") { ?>
    1202. 

  1202. 				<li class="agent"><?php _e("RESOLUTION","wassup"); ?>: <strong><?php print $rk->screen_res; ?></strong></li>
    1203. 

  1203. 			<?php } ?>
    1204. 

  1204. 			</ul>
    1205. 

  1205. 			<?php  } ?>
    1206. 

  1206. 			
    1207. 

  1207. 			<div style="display: visible;" class="togglecrono navi<?php echo $rk->id ?>">
    1208. 

  1208. 			<ul class="url">
    1209. 

  1209. 	<?php 
    1210. 

  1210. 			$qryCD = $wpdb->get_results("SELECT `timestamp`, urlrequested FROM $table_name WHERE wassup_id='".$rk->wassup_id."' ORDER BY `timestamp` ASC");
    1211. 

  1211. 			$i=0;
    1212. 

  1212. 			foreach ($qryCD as $cd) {	
    1213. 

  1213. 			//$timestamp2 = $cd->timestamp; //redundant
    1214. 

  1214. 			$time2 = gmdate("H:i:s", $cd->timestamp);
    1215. 

  1215. 			$char_len = round($max_char_len*.92,0);
    1216. 

  1216. 			$num = ($i&1);
    1217. 

  1217. 			if ($num == 0) $classodd = "urlodd"; else  $classodd = "url";
    1218. 

  1218. 			if ($i >= 1) {
    1219. 

  1219. 				print '<li class="'.$classodd.' navi'.$rk->id.'"><span class="indent-li-nav">'.$time2.' ->';
    1220. 

  1220. 				print '<a href="'.wAddSiteurl(htmlspecialchars(html_entity_decode($cd->urlrequested))).'" target="_BLANK">';
    1221. 

  1221. 				print stringShortener(urlencode(html_entity_decode($cd->urlrequested)), $char_len).'</a></span></li>'."\n";
    1222. 

  1222. 			}
    1223. 

  1223. 			$i++;
    1224. 

  1224. 			} //end foreach qryCD
    1225. 

  1225. 			print "</ul>";
    1226. 

  1226. 			?>
    1227. 

  1227. 			</div>
    1228. 

  1228. 			<p class="sum-footer"></p>
    1229. 

  1229. 		</div>
    1230. 

  1230. 	</div>
    1231. 

  1231. <?php	} //end foreach qry
    1232. 

  1232. 

  1233. 	} //end if itemstot > 0
    1234. 

  1234. 		print '<br />';
    1235. 

  1235. 		if ($itemstot >= 10) $p->show();
    1236. 

  1236. 		print '<br />';
    1237. 

  1237. 		if (!isset($_GET['limit']) OR $_GET['limit'] == 10 OR $_GET['limit'] == 20) {
    1238. 

  1238. 		        print $expcol;
    1239. 

  1239. 		}
    1240. 

  1240. 	if($con) mysql_close($con);
    1241. 

  1241. 	} //end MAIN/DETAILS VIEW 
    1242. 

  1242. 

  1243. 	// End calculating execution time of script
    1244. 

  1244. 	$mtime = microtime();
    1245. 

  1245. 	$mtime = explode(" ",$mtime);
    1246. 

  1246. 	$mtime = $mtime[1] + $mtime[0];
    1247. 

  1247. 	$endtime = $mtime;
    1248. 

  1248. 	$totaltime = ($endtime - $starttime);
    1249. 

  1249. 

  1250. ?>
    1251. 

  1251. 

  1252. 	<p><small>WassUp ver: <?php echo $version.' - '.__("Check the official","wassup").' <a href="http://www.wpwp.org" target="_BLANK">WassUp</a> '.__("page for updates, bug reports and your hints to improve it","wassup").' - <a href="http://trac.wpwp.org/wiki/Documentation" title="Wassup '.__("User Guide documentation","wassup").'">Wassup '.__("User Guide documentation","wassup").'</a>'; ?> - Exec time: <?php echo $totaltime ?></small></p>
    1253. 

  1253. 

  1254. 	</div>	<!-- end wrap -->
    1255. 

  1255. <?php 
    1256. 

  1256. } //end function Wassup
    1257. 

  1257. 

  1258. function CreateTable($table_name="",$withcharset=true) {
    1259. 

  1259. 	global $wpdb;
    1260. 

  1260. 	$charset_collate = '';
    1261. 

  1261. 	//#don't do character set/collation if <  MySQL 4.1
    1262. 

  1262. 	if (version_compare(mysql_get_server_info(), '4.1.0', '<')) {
    1263. 

  1263. 		$withcharset=false;
    1264. 

  1264. 	} elseif (!defined('DB_CHARSET')) {  //DB_CHARSET must be defined in wp-config.php
    1265. 

  1265. 		$withcharset=false;
    1266. 

  1266. 	}
    1267. 

  1267. 	if ($withcharset && $wpdb->supports_collation() && !empty($wpdb->charset)) {
    1268. 

  1268. 		$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
    1269. 

  1269. 		//use collate only when charset is specified
    1270. 

  1270. 		if (!empty($wpdb->collate)) {
    1271. 

  1271. 			$charset_collate .= " COLLATE $wpdb->collate";
    1272. 

  1272. 		}
    1273. 

  1273. 	}
    1274. 

  1274. 	if ($table_name == "") {
    1275. 

  1275. 		$table_name = $wpdb->prefix . "wassup";
    1276. 

  1276. 	}
    1277. 

  1277.         $sql_createtable = "CREATE TABLE " . $table_name . " (
    1278. 

  1278.   id mediumint(9) NOT NULL auto_increment,
    1279. 

  1279.   wassup_id varchar(80) NOT NULL,
    1280. 

  1280.   timestamp varchar(20) NOT NULL,
    1281. 

  1281.   ip varchar(35) default NULL,
    1282. 

  1282.   hostname varchar(150) default NULL,
    1283. 

  1283.   urlrequested text,
    1284. 

  1284.   agent varchar(255) default NULL,
    1285. 

  1285.   referrer text default NULL,
    1286. 

  1286.   search varchar(255) default NULL,
    1287. 

  1287.   searchpage int(11) default 0,
    1288. 

  1288.   os varchar(15) default NULL,
    1289. 

  1289.   browser varchar(50) default NULL,
    1290. 

  1290.   language varchar(5) default NULL,
    1291. 

  1291.   screen_res varchar(15) default NULL,
    1292. 

  1292.   searchengine varchar(25) default NULL,
    1293. 

  1293.   spider varchar(50) default NULL,
    1294. 

  1294.   feed varchar(50) default NULL,
    1295. 

  1295.   username  VARCHAR(50) default NULL,
    1296. 

  1296.   comment_author VARCHAR(50) default NULL,
    1297. 

  1297.   spam VARCHAR(5) default 0,
    1298. 

  1298.   UNIQUE KEY id (id),
    1299. 

  1299.   KEY idx_wassup (wassup_id(32),timestamp),
    1300. 

  1300.   INDEX (os),
    1301. 

  1301.   INDEX (browser),
    1302. 

  1302.   INDEX (timestamp)
    1303. 

  1303. ) $charset_collate;";
    1304. 

  1304.         require_once( ABSPATH.'wp-admin/upgrade-functions.php');
    1305. 

  1305. 	dbDelta($sql_createtable);
    1306. 

  1306. 

  1307. 	//#TODO: check for errors or warnings during table creation
    1308. 

  1308. } //end function createTable
    1309. 

  1309. 

  1310. function UpdateTable() {
    1311. 

  1311. 	global $wpdb, $wassup_options;
    1312. 

  1312. 	$table_name = $wpdb->prefix . "wassup";
    1313. 

  1313. 	$table_tmp_name = $wpdb->prefix . "wassup_tmp";
    1314. 

  1314. 	$idx_timestamp = false;	//used for upgrade from <= 1.4.9 
    1315. 

  1315. 	$idx_wassup = false;	//used for upgrade from <= 1.6 
    1316. 

  1316. 

  1317. 	// Upgrade from version < 1.3.9 - add 'spam' column to wassup table
    1318. 

  1318. 	if ($wpdb->get_var("SHOW COLUMNS FROM $table_name LIKE 'spam'") == "") {
    1319. 

  1319.                 $sql_add_spam = "ALTER TABLE {$table_name} ADD COLUMN spam VARCHAR(5) DEFAULT '0'";
    1320. 

  1320.                 $wpdb->query( $sql_add_spam );
    1321. 

  1321.         }
    1322. 

  1322. 

  1323. 	// Upgrade from version <= 1.4.9 - create an index on 'timestamp'
    1324. 

  1324. 	//#$idx_cols = $wpdb->get_col("SHOW INDEX FROM $table_name","Column_name"); //doesn't work
    1325. 

  1325. 	//# look for an index on 'timestamp' and make one if doesn't exist
    1326. 

  1326. 	$result = mysql_query("SHOW INDEX FROM $table_name");
    1327. 

  1327. 	if ($result) {
    1328. 

  1328. 		$row_count = mysql_num_rows($result);
    1329. 

  1329. 		//# look for an index on 'timestamp'
    1330. 

  1330. 		if ($row_count > 0) {
    1331. 

  1331. 			while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
    1332. 

  1332. 				if ($row["Column_name"] == "timestamp") {
    1333. 

  1333. 					$idx_timestamp = true;
    1334. 

  1334. 				} elseif ( $row["Key_name"] == "idx_wassup") {
    1335. 

  1335. 					$idx_wassup = true;
    1336. 

  1336. 				}
    1337. 

  1337.                         }
    1338. 

  1338. 			//# create an index on 'timestamp'
    1339. 

  1339. 			if (!$idx_timestamp) {
    1340. 

  1340. 				$wpdb->query("ALTER TABLE {$table_name} ADD INDEX idx_timestamp (timestamp)");
    1341. 

  1341. 			}
    1342. 

  1342. 		} //end if row_count
    1343. 

  1343. 		mysql_free_result($result);
    1344. 

  1344. 	} //end if result
    1345. 

  1345. 

  1346. 	// Upgrade from version <= 1.5.1 - increase size of wassup_id
    1347. 

  1347. 	$wassup_col = $wpdb->get_results("SHOW COLUMNS FROM $table_name LIKE 'wassup_id'");
    1348. 

  1348. 	foreach ($wassup_col as $wID) {
    1349. 

  1349. 		if ($wID->Type != "varchar(80)") {
    1350. 

  1350. 			$wpdb->query("ALTER TABLE {$table_name} CHANGE wassup_id wassup_id varchar(80) NULL");
    1351. 

  1351. 		}
    1352. 

  1352. 	}
    1353. 

  1353. 

  1354. 	// Upgrade from version <= 1.6 
    1355. 

  1355. 	//  - change wassup_id index to combination (wassup_id,timestamp)
    1356. 

  1356. 	if (!$idx_wassup) {
    1357. 

  1357. 		$wpdb->query("ALTER TABLE {$table_name} DROP KEY wassup_id");
    1358. 

  1358. 		$wpdb->query("ALTER TABLE {$table_name} ADD KEY idx_wassup (wassup_id(32),timestamp)");
    1359. 

  1359. 	}
    1360. 

  1360. 

  1361. 	// For all upgrades 
    1362. 

  1362. 	//  - drop and recreate table "wp_wassup_tmp" and optimize "wp_wassup"
    1363. 

  1363. 	//$wpdb->query("DROP TABLE IF EXISTS $table_tmp_name"); //incorrectly causes an activation error in Wordpress
    1364. 

  1364. 	mysql_query("DROP TABLE IF EXISTS $table_tmp_name");
    1365. 

  1365. 	CreateTable($table_tmp_name);
    1366. 

  1366. 	$wpdb->query("OPTIMIZE TABLE {$table_name}");
    1367. 

  1367. } //end function UpdateTable
    1368. 

  1368. 

  1369. //Set Wassup_id and cookie (before headers sent)
    1370. 

  1370. function wassupPrepend() {
    1371. 

  1371. 	$wassup_id = "";
    1372. 

  1372. 	$session_timeout = 1;
    1373. 

  1373. 	//### Check if this is an ongoing visit or a new hit...
    1374. 

  1374. 	//#visitor tracking with "cookie"...
    1375. 

  1375. 	if (isset($_COOKIE['wassup'])) {
    1376. 

  1376. 		$wassup_cookie = explode('::',$_COOKIE['wassup']);
    1377. 

  1377. 		$wassup_id = $wassup_cookie[0];
    1378. 

  1378. 		if (!empty($wassup_cookie[1])) { 
    1379. 

  1379. 			$wassup_timer = $wassup_cookie[1];
    1380. 

  1380. 			$session_timeout = ((int)$wassup_timer - (int)time());
    1381. 

  1381. 		}
    1382. 

  1382. 	}
    1383. 

  1383. 	if (empty($wassup_id) || $session_timeout < 1) {
    1384. 

  1384. 		$ipAddress = "";
    1385. 

  1385. 		$hostname = "";
    1386. 

  1386. 		//#### Get the visitor's details from http header...
    1387. 

  1387. 		if (isset($_SERVER["REMOTE_ADDR"])) {
    1388. 

  1388. 		if (!empty($_SERVER["HTTP_X_FORWARDED_FOR"])){
    1389. 

  1389. 			//in case of multiple forwarding
    1390. 

  1390. 		        list($IP) = explode(",",$_SERVER["HTTP_X_FORWARDED_FOR"]);
    1391. 

  1391. 		        $proxy = $_SERVER["REMOTE_ADDR"];
    1392. 

  1392. 			$hostname = @gethostbyaddr($IP);
    1393. 

  1393. 			if (empty($hostname) || $hostname == "unknown") {
    1394. 

  1394. 		        	$hostname = @gethostbyaddr($proxy);
    1395. 

  1395. 			}
    1396. 

  1396. 			if (empty($IP) || $IP == "unknown") {
    1397. 

  1397. 				$IP = $proxy;
    1398. 

  1398. 				$ipAddress = $_SERVER["REMOTE_ADDR"];
    1399. 

  1399. 			} else {
    1400. 

  1400. 				$ipAddress = $proxy.",".$IP;
    1401. 

  1401. 			}
    1402. 

  1402. 		}else{
    1403. 

  1403. 		        list($IP) = explode(",",$_SERVER["REMOTE_ADDR"]);
    1404. 

  1404. 		        $hostname = @gethostbyaddr($IP);
    1405. 

  1405. 			$ipAddress = $_SERVER["REMOTE_ADDR"];
    1406. 

  1406. 		} 
    1407. 

  1407. 		}
    1408. 

  1408. 		if (empty($IP)) { $IP = $ipAddress; }
    1409. 

  1409. 		if (empty($hostname)) { $hostname = "unknown"; }
    1410. 

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

  1411. 		$current_user = wp_get_current_user();
    1412. 

  1412. 		$logged_user = $current_user->user_login;
    1413. 

  1413. 		//# Create a new wassup id for this visit from a 
    1414. 

  1414. 		//#  combination of date/hour/min/ip/hostname/useragent/. 
    1415. 

  1415. 		//#  It is not unique so that multiple visits from the 
    1416. 

  1416. 		//#  same ip/userAgent within a 30 minute-period, can be 
    1417. 

  1417. 		//#  tracked, even when session/cookies is disabled. 
    1418. 

  1418. 		$temp_id = sprintf("%-060.60s", date('YmdH').str_replace(array(' ','http://','www.','/','.','\'','"',"\\",'$','-','&','+','_',';',',','>','<',':','#','*','%','!','@',')','(',), '', intval(date('i')/30).$IP.strrev($logged_user).strrev($userAgent).strrev($hostname).intval(date('i')/30)).date('HdmY').$hostname.rand());
    1419. 

  1419. 		//$temp_id = sprintf("%-060.60s", date('YmdH').str_replace(array(' ','http://','www.','/','.','\'','"',"\\",'$','-','&','+','_',';',',','>','<',':','#','*','%','!','@',')','(',), '', intval(date('i')/30).$IP.strrev($userAgent).strrev($hostname).intval(date('i')/30)).date('HdmY').$hostname.rand());
    1420. 

  1420. 

  1421. 		//Work-around for cookie rejection:
    1422. 

  1422. 		//#assign new wassup id from "temp_id" 
    1423. 

  1423. 		//$wassup_id = $temp_id;	//debug
    1424. 

  1424. 		$wassup_id = md5($temp_id);
    1425. 

  1425. 		$wassup_timer=((int)time() + 2700); //use 45 minutes timer
    1426. 

  1426. 

  1427. 		//put the cookie in the oven and set the timer...
    1428. 

  1428. 		//#this must be done before headers sent
    1429. 

  1429. 		$cookieurl = parse_url(get_option('home'));
    1430. 

  1430. 		$cookiedomain = preg_replace('/^www\./','',$cookieurl['host']);
    1431. 

  1431. 		$cookiepath = $cookieurl['path'];
    1432. 

  1432. 		$expire = time()+3000;	//expire based on unix time, not on Wordpress time
    1433. 

  1433. 		$cookievalue = implode('::',array("$wassup_id", "$wassup_timer"));
    1434. 

  1434. 		setcookie("wassup", "$cookievalue", $expire, $cookiepath, $cookiedomain);
    1435. 

  1435. 	}
    1436. 

  1436. } //end function wassupPrepend
    1437. 

  1437. 

  1438. //Track visitors and save record in wassup table, after page is displayed
    1439. 

  1439. function wassupAppend() {
    1440. 

  1440. 	global $wpdb, $wpurl, $wassup_options; //removed unused globals
    1441. 

  1441. 	$siteurl =  get_bloginfo('siteurl');
    1442. 

  1442. 	$table_name = $wpdb->prefix . "wassup";	
    1443. 

  1443. 	$table_tmp_name = $wpdb->prefix . "wassup_tmp";	
    1444. 

  1444. 	$wassup_settings = get_option('wassup_settings');
    1445. 

  1445. 	$current_user = wp_get_current_user();
    1446. 

  1446. 	$logged_user = $current_user->user_login;
    1447. 

  1447. 	$urlRequested = clean_url($_SERVER['REQUEST_URI']);
    1448. 

  1448. 

  1449. 	if (empty($logged_user) && $wassup_setting->wassup_hack == "1") {
    1450. 

  1450. 		$hackercheck = true;
    1451. 

  1451. 	} else {
    1452. 

  1452. 		$hackercheck = false;
    1453. 

  1453. 	}
    1454. 

  1454. 

  1455. 	if ((!is_admin() && stristr($urlRequested,"/wp-admin/") === FALSE) || $hackercheck) {	//exclude valid wordpress admin page visits
    1456. 

  1456. 

  1457. 	//#### Get the visitor's details from http header...
    1458. 

  1458. 	if (isset($_SERVER["REMOTE_ADDR"])) {
    1459. 

  1459. 		if (!empty($_SERVER["HTTP_X_FORWARDED_FOR"])){
    1460. 

  1460. 			//in case of multiple forwarding
    1461. 

  1461. 		        list($IP) = explode(",",$_SERVER["HTTP_X_FORWARDED_FOR"]);
    1462. 

  1462. 		        $proxy = $_SERVER["REMOTE_ADDR"];
    1463. 

  1463. 			$hostname = @gethostbyaddr($IP);
    1464. 

  1464. 			if (empty($hostname) || $hostname == "unknown") {
    1465. 

  1465. 		        	$hostname = @gethostbyaddr($proxy);
    1466. 

  1466. 			}
    1467. 

  1467. 			if (empty($IP) || $IP == "unknown") {
    1468. 

  1468. 				$IP = $proxy;
    1469. 

  1469. 				$ipAddress = $_SERVER["REMOTE_ADDR"];
    1470. 

  1470. 			} else {
    1471. 

  1471. 				$ipAddress = $proxy.",".$IP;
    1472. 

  1472. 			}
    1473. 

  1473. 		}else{
    1474. 

  1474. 		        list($IP) = explode(",",$_SERVER["REMOTE_ADDR"]);
    1475. 

  1475. 		        $hostname = @gethostbyaddr($IP);
    1476. 

  1476. 			$ipAddress = $_SERVER["REMOTE_ADDR"];
    1477. 

  1477. 		} 
    1478. 

  1478. 	}
    1479. 

  1479. 	if (empty($IP)) { $IP = $ipAddress; }
    1480. 

  1480. 	if (empty($hostname)) { $hostname = "unknown"; }
    1481. 

  1481. 

  1482. 	// Get the visitor's resolution, TODO
    1483. 

  1483. 	/*
    1484. 

  1484. 	if(isset($HTTP_COOKIE_VARS["users_resolution"])) {
    1485. 

  1485. 		$screen_res = $HTTP_COOKIE_VARS["users_resolution"];
    1486. 

  1486. 	} else { //means cookie is not found set it using Javascript
    1487. 

  1487. 	?>
    1488. 

  1488. 	<script language="javascript">
    1489. 

  1489. 	<!--
    1490. 

  1490. 	writeCookie();
    1491. 

  1491. 	
    1492. 

  1492. 	function writeCookie() 
    1493. 

  1493. 	{
    1494. 

  1494. 	 var today = new Date();
    1495. 

  1495. 	 var the_date = new Date("December 31, 2023");
    1496. 

  1496. 	 var the_cookie_date = the_date.toGMTString();
    1497. 

  1497. 	 var the_cookie = "users_resolution="+ screen.width +"x"+ screen.height;
    1498. 

  1498. 	 var the_cookie = the_cookie + ";expires=" + the_cookie_date;
    1499. 

  1499. 	 document.cookie=the_cookie
    1500. 

  1500. 		 
    1501. 

  1501. 	 location = '<?php echo $_SERVER['REQUEST_URI']; ?>';
    1502. 

  1502. 	}
    1503. 

  1503. 	//-->
    1504. 

  1504. 	</script>
    1505. 

  1505. 	<?php
    1506. 

  1506. 		$screen_res = $HTTP_COOKIE_VARS["users_resolution"];
    1507. 

  1507. 	}
    1508. 

  1508. 	*/
    1509. 

  1509. 

  1510.     	$referrer = (isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '');
    1511. 

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

  1512.     	$language = (isset($_SERVER['HTTP_ACCEPT_LANGUAGE']) ? attribute_escape($_SERVER['HTTP_ACCEPT_LANGUAGE']) : '');
    1513. 

  1513. 	//$current_user = wp_get_current_user();	//moved up
    1514. 

  1514. 	//$logged_user = $current_user->user_login;	//moved up
    1515. 

  1515.     	$comment_user = (isset($_COOKIE['comment_author_'.COOKIEHASH]) ? utf8_encode($_COOKIE['comment_author_'.COOKIEHASH]) : '');
    1516. 

  1516.    
    1517. 

  1517. 	$timestamp  = wassup_get_time(); //Add a timestamp to visit... 
    1518. 

  1518. 	$flag_exclude_url = 0;
    1519. 

  1519. 

  1520. 	//#####Start recording visit....
    1521. 

  1521. 	//## wassup is activated and IP not on exclusion list... 
    1522. 

  1522. 	if ($wassup_options->wassup_active == 1) {	//(moved)
    1523. 

  1523. 	if (empty($wassup_options->wassup_exclude) ||
    1524. 

  1524. 	     strstr($wassup_options->wassup_exclude,$ipAddress) == FALSE) {
    1525. 

  1525. 	
    1526. 

  1526. 	//## check if url requested is not on exclusion list...
    1527. 

  1527. 	if (!empty($wassup_options->wassup_exclude_url)) {
    1528. 

  1528. 		$exclude_url_list = explode(",", $wassup_options->wassup_exclude_url);
    1529. 

  1529. 		foreach ($exclude_url_list as $exclude_url) {
    1530. 

  1530. 			if (stristr($urlRequested, trim($exclude_url)) !== FALSE) {
    1531. 

  1531. 				$flag_exclude_url = 1;
    1532. 

  1532. 			}
    1533. 

  1533. 		}
    1534. 

  1534. 	}
    1535. 

  1535. 	if ($flag_exclude_url != 1) {
    1536. 

  1536. 	
    1537. 

  1537. 	//### Exclude requests for themes, plugins, and favicon from recordings
    1538. 

  1538. 	if (stristr($urlRequested,"favicon.ico") === FALSE) {		//moved
    1539. 

  1539. 	if (stristr($urlRequested,"/wp-content/plugins") === FALSE || stristr($urlRequested,"forum") !== FALSE || $hackercheck) {	//moved and modified to allow forum requests
    1540. 

  1540. 	if (stristr($urlRequested,"/wp-content/themes") === FALSE || stristr($urlRequested,"comment") !== FALSE) {	//moved and modified to allow comment requests
    1541. 

  1541. 		
    1542. 

  1542. 	//# More recording exclusion controls
    1543. 

  1543. 	if ($wassup_options->wassup_loggedin == 1 || !is_user_logged_in()) {
    1544. 

  1544. 	if ($wassup_options->wassup_attack == 1 || stristr($userAgent,"libwww-perl") === FALSE ) {
    1545. 

  1545. 	if (!is_404() || $hackercheck) {	//don't record 404 pages...
    1546. 

  1546. 

  1547. 		//##### Extract useful visit information from http header..
    1548. 

  1548. 		$browser = "";
    1549. 

  1549. 		$os = "";
    1550. 

  1550. 		list($browser,$os) = wGetBrowser($userAgent);
    1551. 

  1551. 

  1552. 	//#===================================================
    1553. 

  1553. 	//###Start visitor tracking...
    1554. 

  1554. 	//Work-around for cookie rejection:
    1555. 

  1555. 	//# Create a temporary id for this visit from a combination of 
    1556. 

  1556. 	//#  date/hour/min/ip/hostname/useragent/os/browser. 
    1557. 

  1557. 	//#  It is not unique so that multiple visits from the same 
    1558. 

  1558. 	//#  ip/userAgent within a  30 minute-period, can be tracked as 
    1559. 

  1559. 	//#  such, even when session/cookies is disabled. 
    1560. 

  1560. 	//# An md5 encoded version of temp_id is saved as "wassup_id".
    1561. 

  1561. 	$temp_id = sprintf("%-060.60s", date('YmdH').str_replace(array(' ','http://','www.','/','.','\'','"',"\\",'$','-','&','+','_',';',',','>','<',':','#','*','%','!','@',')','(',), '', intval(date('i')/30).$IP.strrev($logged_user).strrev($userAgent).strrev($hostname).intval(date('i')/30)).date('HdmY').$hostname.rand());
    1562. 

  1562. 	$wassup_id = "";
    1563. 

  1563. 	//Read the cookie for wassup_id
    1564. 

  1564. 	if (isset($_COOKIE['wassup'])) {
    1565. 

  1565. 		$wassup_cookie = explode('::',$_COOKIE['wassup']);
    1566. 

  1566. 		$wassup_id = $wassup_cookie[0];
    1567. 

  1567. 	}
    1568. 

  1568. 	/*
    1569. 

  1569. 	$session_timeout = 1;
    1570. 

  1570. 	//### Check if this is an ongoing visit or a new hit...
    1571. 

  1571. 	//#visitor tracking with "session"...
    1572. 

  1572. 	//# Set savepath directory before session_start()
    1573. 

  1573. 	$sessionpath = $wassup_options->wassup_savepath;
    1574. 

  1574. 	if (empty($sessionpath)) { $sessionpath = getSessionpath(); }
    1575. 

  1575. 	if ($sessionpath != "" && $wassup_options->isWritableFolder($sessionpath)) {
    1576. 

  1576. 		session_save_path($sessionpath);
    1577. 

  1577. 	}
    1578. 

  1578. 	session_start();	//required to use/update $_SESSION
    1579. 

  1579. 	   
    1580. 

  1580. 	//#confirm that session is started...
    1581. 

  1581. 	if (isset($_SESSION)) {
    1582. 

  1582. 		// Prevent Session Fixation attack (http://shiflett.org/articles/session-fixation)
    1583. 

  1583. 		if (!isset($_SESSION['initiated'])) { 
    1584. 

  1584. 			session_regenerate_id(); 
    1585. 

  1585. 			$_SESSION['initiated'] = true; 
    1586. 

  1586. 		} 
    1587. 

  1587. 		//Get session variables...
    1588. 

  1588. 		if (isset($_SESSION['wassup_id'])) {
    1589. 

  1589. 			$wassup_id = $_SESSION['wassup_id'];
    1590. 

  1590. 			$session_timeout = ((int)$_SESSION['wassup_timer'] - (int)time());
    1591. 

  1591. 			if (isset($_SESSION['spamresult'])) {
    1592. 

  1592. 				$spamresult = $_SESSION['spamresult'];
    1593. 

  1593. 			}
    1594. 

  1594. 			if ( $_SESSION['urlrequest'] == $urlRequested && (($timestamp - (int)$_SESSION['visittime']) < 5)) {
    1595. 

  1595. 	   			$dup_urlrequest=1;
    1596. 

  1596. 	   		}
    1597. 

  1597. 		} 
    1598. 

  1598. 		//#reset wassup_id for new visitors or when timer is 0...
    1599. 

  1599. 		if (empty($wassup_id) or $session_timeout < 1) {
    1600. 

  1600. 			//# don't "destroy" old session in case it is
    1601. 

  1601. 			//#  in use elsewhere in wordpress ??..
    1602. 

  1602. 			//if (!empty($wassup_id)) {
    1603. 

  1603. 			//	session_destroy();
    1604. 

  1604. 			//	session_start();
    1605. 

  1605. 			//}
    1606. 

  1606. 			$_SESSION['wassup_id'] = md5($temp_id);
    1607. 

  1607. 			//$_SESSION['wassup_id'] = md5(uniqid(rand(), true));
    1608. 

  1608. 			//#timeout session after 24 minutes
    1609. 

  1609. 			$_SESSION['wassup_timer'] = ((int)time() + 1440);
    1610. 

  1610. 			$dup_urlrequest=0;
    1611. 

  1611. 		}
    1612. 

  1612. 		$wassup_id = $_SESSION['wassup_id'];
    1613. 

  1613. 		if ($dup_urlrequest == 0) {	//for dup checks
    1614. 

  1614. 			$_SESSION['visittime'] = $timestamp;	//for dup checks
    1615. 

  1615. 			$_SESSION['urlrequest'] = $urlRequested;
    1616. 

  1616. 		}
    1617. 

  1617. 		//#SID is empty when session uses cookies...
    1618. 

  1618. 		//if (defined('SID') && !empty(SID)) {
    1619. 

  1619. 		//	//#manually add SID to url_rewriter when trans-sid 
    1620. 

  1620. 		//	//#  is disabled (how to test for this???)...
    1621. 

  1621. 		//	output_add_rewrite_var(session_name(), htmlspecialchars(session_id()));
    1622. 

  1622. 		//}
    1623. 

  1623. 		@session_write_close(); 
    1624. 

    1625. 

  1625. 	} */
    1626. 

  1626. 	//### Check if this is an ongoing visit or a new hit...
    1627. 

  1627. 	/* //#visitor tracking with "cookie"...
    1628. 

  1628. 	if (isset($_COOKIE['wassup'])) {
    1629. 

  1629. 		$wassup_cookie = unserialize($_COOKIE['wassup']);
    1630. 

  1630. 		//$wassup_id = $wassup_cookie['wassup_id'];
    1631. 

  1631. 		$wassup_timer = $wassup_cookie['timer'];
    1632. 

  1632. 		if (isset($wassup_cookie['spamresult'])) {
    1633. 

  1633. 			$spamresult = $wassup_cookie['spamresult'];
    1634. 

  1634. 		}
    1635. 

  1635. 		$session_timeout = ((int)$wassup_timer - (int)time());
    1636. 

  1636. 		if ( $session_timeout < 1) {
    1637. 

  1637. 			//#reset cookie values when timer is 0
    1638. 

  1638. 			unset($wassup_cookie);
    1639. 

  1639. 			$wassup_id = ""; //a new id will be assigned
    1640. 

  1640. 		}
    1641. 

  1641. 	} */
    1642. 

  1642. 	//Work-around for cookie rejection:
    1643. 

  1643. 	//#assign new wassup id from "temp_id" and include it in dup check
    1644. 

  1644. 	if (empty($wassup_id)) {
    1645. 

  1645. 		$wassup_id = md5($temp_id);
    1646. 

  1646. 		//$wassup_id = $temp_id;	//debug
    1647. 

  1647. 	}
    1648. 

  1648. 	//### Check for duplicates. 
    1649. 

  1649. 	$dup_urlrequest=0;
    1650. 

  1650. 	// Dup: Hit recorded, ==wassup_id, last visit, <90 secs old, ==URL
    1651. 

  1651. 	$dups = $wpdb->get_results("SELECT wassup_id, urlrequested, spam, `timestamp` AS hit_timestamp FROM ".$table_tmp_name." WHERE wassup_id='".$wassup_id."' AND `timestamp` >".($timestamp-90)." GROUP BY wassup_id ORDER BY hit_timestamp DESC");
    1652. 

  1652. 	if (!empty($dups)) {
    1653. 

  1653. 		$i=0;
    1654. 

  1654. 		foreach ($dups as $dup) {	//check first record only
    1655. 

  1655. 			if ($i == 0) {
    1656. 

  1656. 			       	if ($dup->urlrequested == $urlRequested) {
    1657. 

  1657. 					$dup_urlrequest=1;
    1658. 

  1658. 				}
    1659. 

  1659. 				//retrieve spam check results
    1660. 

  1660. 				$spamresult = $dup->spam;
    1661. 

  1661. 			}
    1662. 

  1662. 			$i=$i+1;
    1663. 

  1663. 		}
    1664. 

  1664. 	}
    1665. 

  1665. 	//
    1666. 

  1666. 	//#End visitor tracking with cookie/session
    1667. 

  1667. 	//#===================================================
    1668. 

  1668. 

  1669. 	//### Exclude duplicates...
    1670. 

  1670. 	if ($dup_urlrequest == 0) {
    1671. 

  1671. 		//##### Extract useful visit information from http header..
    1672. 

  1672. 		if (empty($browser) || strstr($browser,"N/A") || is_feed()) {
    1673. 

  1673. 			list($spider,$feed) = wGetSpider($userAgent,$hostname,$browser);
    1674. 

  1674. 		}
    1675. 

  1675. 		
    1676. 

  1676. 		//#I prefer to see os/browser info. for spiders/bots.
    1677. 

  1677. 

  1678. 	//spider exclusion control
    1679. 

  1679. 	//# Spider exclusion control moved to avoid unneeded tests
    1680. 

  1680. 	if ($wassup_options->wassup_spider == 1 || $spider == '') {
    1681. 

  1681. 	   //
    1682. 

  1682. 	   //#get language/locale info from hostname or referrer data
    1683. 

  1683. 	   $language = wGetLocale($language,$hostname,$referrer);
    1684. 

  1684. 

  1685. 	   //# get search string details from referrer data
    1686. 

  1686. 	   list($searchengine,$search_phrase)=explode("|",wGetSE($referrer));
    1687. 

  1687. 	   $se=seReferer($referrer);
    1688. 

  1688. 	   if ($search_phrase != '')  {
    1689. 

  1689. 	   	if (stristr($searchengine,"images")) {
    1690. 

  1690. 	   		// ATTENTION Position retrieved by referer in Google Images is 
    1691. 

  1691. 	   		// the Position number of image NOT the number of items in the page like web search
    1692. 

  1692. 	   		$searchpage=$se['Pos'];
    1693. 

  1693. 	   		$searchcountry = explode(".", $se['Se']);
    1694. 

  1694. 	   	} else {
    1695. 

  1695. 	   		$searchpage=($se['Pos']/10+1);
    1696. 

  1696. 	   		$searchcountry = explode(".", $se['Se']);
    1697. 

  1697. 	   	}
    1698. 

  1698. 	   	if ($searchcountry[3] != '' ) {
    1699. 

  1699. 	   		$searchengine .= " ".strtoupper($searchcountry[3]);
    1700. 

  1700. 	   	} elseif ($searchcountry[2] != '') {
    1701. 

  1701. 	   		$searchengine .= " ".strtoupper($searchcountry[2]);
    1702. 

  1702. 	   	}
    1703. 

  1703. 	   }
    1704. 

  1704. 	   if ($searchpage == "") {
    1705. 

  1705. 	   	$searchpage = 0;
    1706. 

  1706. 	   }
    1707. 

  1707. 

  1708. 	//### Check for spam...
    1709. 

  1709.         $spam = 0;      //a spam default of 0 is required to add record...
    1710. 

  1710. 

  1711.         if ( $wassup_options->wassup_spamcheck == 1 ) {
    1712. 

  1712.         if ( $wassup_options->wassup_refspam == 1 && !empty($referrer) ) {
    1713. 

  1713.                 //#first check for referrer spam (faster, if positive)
    1714. 

  1714.                 //#...but skip when referrer is own blog ($siteurl/$wpurl)
    1715. 

  1715.                 if (stristr($referrer,$wpurl) === FALSE && stristr($referrer,$siteurl) === FALSE) {
    1716. 

  1716.                         // Do a control if it is Referrer Spam
    1717. 

  1717.                         if (wGetSpamRef($referrer) == 1) {
    1718. 

  1718.                                 $spam = 2;
    1719. 

  1719.                                 $spamresult = $spam;
    1720. 

  1720.                         }
    1721. 

  1721.                 }
    1722. 

  1722.         }
    1723. 

  1723.         if ( $wassup_options->wassup_spam == 1 && $spam == 0 ) {
    1724. 

  1724.                 //# some valid spiders to exclude from spam checking
    1725. 

  1725.                 $goodbot = false;
    1726. 

  1726. 		if ($hostname!="" && !empty($spider)) {
    1727. 

  1727. 			if (preg_match('/^(googlebot|msnbot|yahoo\!\ slurp|technorati)/i',$spider)>0 && preg_match('/\.(googlebot|live|msn|yahoo|technorati)\.(com|net)$/i',$hostname)>0){
    1728. 

  1728. 				$goodbot = true;
    1729. 

  1729. 			}
    1730. 

  1730. 		}
    1731. 

  1731. 

  1732.                 //# No duplicate spam testing in same session unless there 
    1733. 

  1733.                 //#  is a forum page request or comment...
    1734. 

  1734.                 if (isset($spamresult) && stristr($urlRequested,"comment") === FALSE && stristr($urlRequested,"forum") === FALSE && empty($comment_user) && empty($_POST['comment'])) {
    1735. 

  1735.                         $spam = $spamresult;
    1736. 

  1736. 

  1737.                 //# No spam check on known bots (google, yahoo,...) unless
    1738. 

  1738.                 //#  there is a comment or forum page request...
    1739. 

  1739.                 } elseif (empty($spider) || !$goodbot || stristr($urlRequested,"comment") !== FALSE || stristr($urlRequested,"forum") !== FALSE  || !empty($comment_user) ) { 
    1740. 

  1740. 

  1741.                    // Try to search for previous spammer detected by akismet with same IP
    1742. 

  1742.                    if (!empty($ipAddress)) {
    1743. 

  1743.                            $checkauthor = New CheckComment;
    1744. 

  1744.                            $checkauthor->tablePrefix = $wpdb->prefix;
    1745. 

  1745.                            $spammerIP = $checkauthor->isSpammer($ipAddress);
    1746. 

  1746.                            if ( $spammerIP > 0) {
    1747. 

  1747.                                 $spam = 1;
    1748. 

  1748.                                 $spamresult = $spam;
    1749. 

  1749.                            }
    1750. 

  1750.                    }
    1751. 

  1751. 

  1752.                    // search for spammer in badhosts file...
    1753. 

  1753.                    if ( $spam == 0) {
    1754. 

  1754.                         if (!empty($hostname) && $hostname != "unknown") {
    1755. 

  1755.                                 if (wGetSpamRef($hostname) == 1) {
    1756. 

  1756.                                         $spam = 1;
    1757. 

  1757.                                         $spamresult = $spam;
    1758. 

  1758.                                 }
    1759. 

  1759.                         }
    1760. 

  1760.                    }
    1761. 

  1761. 

  1762.                    //#lastly check for comment spammers using Akismet API
    1763. 

  1763.                    //#  Note: this causes "header already sent" errors in some Wordpress configurations
    1764. 

  1764.                    if ($spam == 0) {
    1765. 

  1765.                         $akismet_key = get_option('wordpress_api_key');
    1766. 

  1766.                         $akismet_class = dirname(__FILE__).'/lib/akismet.class.php';
    1767. 

  1767.                         if (file_exists($akismet_class) && !empty($akismet_key)) {
    1768. 

  1768.                                 $comment_user_email = utf8_encode($_COOKIE['comment_author_email_'.COOKIEHASH]);
    1769. 

  1769.                                 $comment_user_url = utf8_encode($_COOKIE['comment_author_url_'.COOKIEHASH]);
    1770. 

  1770.                                 include($akismet_class);
    1771. 

  1771. 

  1772.                                 // load array with comment data 
    1773. 

  1773.                                 $Acomment = array(
    1774. 

  1774.                                         'author' => $comment_user,
    1775. 

  1775.                                         'email' => $comment_user_email,
    1776. 

  1776.                                         'website' => $comment_user_url,
    1777. 

  1777.                                         'body' => $_POST["comment"],
    1778. 

  1778.                                         'permalink' => $urlRequested,
    1779. 

  1779.                                         'user_ip' => $ipAddress,
    1780. 

  1780.                                         'user_agent' => $userAgent
    1781. 

  1781.                                 );
    1782. 

  1782. 

  1783.                                 // instantiate an instance of the class 
    1784. 

  1784.                                 $akismet = new Akismet($wpurl, $akismet_key, $Acomment);
    1785. 

  1785.                                 // Check if it's spam
    1786. 

  1786.                                 if ( $akismet->isSpam() ) {
    1787. 

  1787.                                         $spam = 1;
    1788. 

  1788.                                         $spamresult = $spam;
    1789. 

  1789.                                 }
    1790. 

  1790.                                 // test for errors
    1791. 

  1791.                                 if($akismet->errorsExist()) {
    1792. 

  1792.                                         //#error means don't save result in cookie
    1793. 

  1793.                                         unset($spamresult);
    1794. 

  1794.                                 }
    1795. 

  1795.                         } //end if file_exists(akismet_class)
    1796. 

  1796.                 } //end if $spam == 0 
    1797. 

  1797. 

  1798.            } //end else $spamresult
    1799. 

  1799. 

  1800.         } //end if wassup_spam == 1
    1801. 

  1801.         } //end if wassup_spamcheck == 1
    1802. 

  1802. 

  1803. 	//identify hacker/bad activity attempts and assign spam=3
    1804. 

  1804. 	if ($spam == 0 && $hackercheck) {
    1805. 

  1805. 		if (is_admin() || stristr($urlRequested,"/wp-content/plugins")!==FALSE || stristr($urlRequested,"/wp-admin/")!== FALSE) {
    1806. 

  1806. 			$spam=3;
    1807. 

  1807. 		}
    1808. 

  1808. 	}
    1809. 

  1809. 	// Personally used to debug
    1810. 

  1810. 	if ($current_user->user_email == "michele@befree.it") {
    1811. 

  1811. 	}
    1812. 

  1812. 

  1813.         //## Final exclusion control is spam...
    1814. 

  1814. 	if ($spam == 0 OR ($wassup_options->wassup_spam == 1 AND $spam == 1) OR ($wassup_options->wassup_refspam == 1 AND $spam == 2)) {
    1815. 

  1815. 		/* // #save spam results in session...
    1816. 

  1816.                 if (isset($spamresult)) {
    1817. 

  1817.                         @session_start(); //required to access $_SESSION
    1818. 

  1818.                         $_SESSION['spamresult'] = $spamresult;
    1819. 

  1819.                         @session_write_close();
    1820. 

  1820. 		}
    1821. 

  1821. 		*/
    1822. 

  1822. 		
    1823. 

  1823. 		// #Record visit in wassup tables...	
    1824. 

  1824. 		// Insert the record into the db
    1825. 

  1825. 		insert_into_wp($table_name, $wassup_id, $timestamp, $ipAddress, $hostname, $urlRequested, $userAgent, $referrer, $search_phrase, $searchpage, $os, $browser, $language, $screen_res, $searchengine, $spider, $feed, $logged_user, $comment_user, $spam);
    1826. 

  1826. 		// Insert the record into the wassup_tmp table too
    1827. 

  1827. 		insert_into_wp($table_tmp_name, $wassup_id, $timestamp, $ipAddress, $hostname, $urlRequested, $userAgent, $referrer, $search_phrase, $searchpage, $os, $browser, $language, $screen_res, $searchengine, $spider, $feed, $logged_user, $comment_user, $spam);
    1828. 

  1828. 		// Delete records older then 3 minutes
    1829. 

  1829. 		$wpdb->query("DELETE FROM $table_tmp_name WHERE `timestamp`<'".strtotime("-3 minutes", $timestamp)."'");
    1830. 

  1830. 

  1831.         } //end if $spam == 0
    1832. 

  1832. 

  1833.         } //end if wassup_spider
    1834. 

  1834. 	} //end if dup_urlrequest == 0
    1835. 

  1835. 

  1836.         } //end if !is_404
    1837. 

  1837.         } //end if wassup_attack
    1838. 

  1838.         } //end if wassup_loggedin
    1839. 

  1839. 

  1840.         } //end if !themes
    1841. 

  1841.         } //end if !plugins
    1842. 

  1842.         } //end if !favicon
    1843. 

  1843. 

  1844. 	//### Purge old records from wassup table
    1845. 

  1845. 	//automatic database cleanup of old records...
    1846. 

  1846. 	if ($wassup_options->delete_auto != "") {
    1847. 

  1847. 	   // do purge every few visits to keep wassup fast...
    1848. 

  1848. 	   if ( ((int)$timestamp)%7 == 0 ) {
    1849. 

  1849. 	   	//use visit timestamp instead of current time for
    1850. 

  1850. 	   	//  delete parameter
    1851. 

  1851. 	   	//$to_date = wassup_get_time();
    1852. 

  1852. 		$from_date = strtotime($wassup_options->delete_auto, $timestamp);
    1853. 

  1853. 		//#check before doing delete as it could lock the table...
    1854. 

  1854. 		if ((int)$wpdb->get_var("SELECT COUNT(id) FROM $table_name WHERE `timestamp`<'$from_date'") > 0) {
    1855. 

  1855. 			$wpdb->query("DELETE FROM $table_name WHERE `timestamp`<'$from_date'");
    1856. 

  1856. 		}
    1857. 

  1857. 		// Optimize table once a day
    1858. 

  1858. 		if ($timestamp > strtotime("24 hours", $wassup_options->wassup_optimize)) {
    1859. 

  1859. 			$wpdb->query("OPTIMIZE TABLE $table_name");
    1860. 

  1860. 			$wassup_options->wassup_optimize = wassup_get_time();
    1861. 

  1861.                         $wassup_options->saveSettings();
    1862. 

  1862. 		}
    1863. 

  1863. 	   }
    1864. 

  1864. 	} //end if delete_auto
    1865. 

  1865. 

  1866. 	} //end if wassup_exclude
    1867. 

  1867. 	} //end if wassup_exclude_url
    1868. 

  1868. 	} //end if wassup_active
    1869. 

  1869. 	} //end if !is_admin
    1870. 

  1870. 	
    1871. 

  1871. 	//### Notify admin if alert is set and wassup table > alert
    1872. 

  1872. 	if ($wassup_options->wassup_remind_flag == 1) {
    1873. 

  1873. 	   // check database size every few visits to keep wassup fast...
    1874. 

  1874. 	   if ( (time())%7 == 0 ) {
    1875. 

  1875. 		$table_status = $wpdb->get_results("SHOW TABLE STATUS LIKE '$table_name'");
    1876. 

  1876. 		foreach ($table_status as $fstatus) {
    1877. 

  1877. 			$data_lenght = $fstatus->Data_length;
    1878. 

  1878. 		}
    1879. 

  1879. 		$tusage = ($data_lenght/1024/1024);
    1880. 

  1880. 		if ($tusage > $wassup_options->wassup_remind_mb) {
    1881. 

  1881. 			$recipient = get_bloginfo('admin_email');
    1882. 

  1882. 			$sender = get_bloginfo('name').' <wassup_noreply@'.parse_url(get_bloginfo('siteurl'),PHP_URL_HOST).'>';
    1883. 

  1883.                         $subject = "[ALERT]".__('WassUp Plugin table has reached maximum size!','wassup');
    1884. 

  1884.                         $message = __('Hi','wassup').",\n".__('you have received this email because your WassUp Database table at your Wordpress blog','wassup')." (".get_bloginfo('url').") ".__('has reached the maximum value you set in the options menu','wassup')." (".$wassup_options->wassup_remind_mb." Mb).\n\n";
    1885. 

  1885.                         $message .= __('This is only a reminder, please take the actions you want in the WassUp options menu','wassup')." (".get_bloginfo('url')."/wp-admin/admin.php?page=wassup-options).\n\n".__('This alert now will be removed and you will be able to set a new one','wassup').".\n\n";
    1886. 

  1886.                         $message .= __('Thank you for using WassUp plugin. Check if there is a new version available here:','wassup')." http://wordpress.org/extend/plugins/wassup/\n\n".__('Have a nice day!','wassup')."\n";
    1887. 

  1887.                         mail($recipient, $subject, $message, "From: $sender");
    1888. 

  1888.                         $wassup_options->wassup_remind_flag = 2;
    1889. 

  1889.                         $wassup_options->saveSettings();
    1890. 

  1890. 		}
    1891. 

  1891. 	   }
    1892. 

  1892. 	} //if wassup_remind_flag
    1893. 

  1893. 	//} //if SECRET_KEY
    1894. 

  1894. } //end function wassupAppend()
    1895. 

  1895. 

  1896. // Function to insert the item into the db
    1897. 

  1897. function insert_into_wp($table_name, $wassup_id, $timestamp, $ipAddress, $hostname, $urlRequested, $userAgent, $referrer, $search_phrase, $searchpage, $os, $browser, $language, $screen_res, $searchengine, $spider, $feed, $logged_user, $comment_user, $spam) {
    1898. 

  1898. 	global $wpdb;
    1899. 

  1899.         if (!empty($table_name) && !empty($wassup_id) && !empty($timestamp)) {
    1900. 

  1900. 	//double-check that table exists before doing insert to avoid errors showing up on page
    1901. 

  1901. 	if ($wpdb->get_var("SHOW TABLES LIKE '$table_name'") == $table_name) {
    1902. 

  1902. 

  1903. 		if (method_exists($wpdb,'prepare')) {
    1904. 

  1904. 			$insert = $wpdb->query( $wpdb->prepare("INSERT INTO $table_name (wassup_id, `timestamp`, ip, hostname, urlrequested, agent, referrer, search, searchpage, os, browser, language, screen_res, searchengine, spider, feed, username, comment_author, spam) 
    1905. 

  1905.    		           VALUES ( %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s )",
    1906. 

  1906. 	   		   attribute_escape($wassup_id),
    1907. 

  1907. 		   	   attribute_escape($timestamp),
    1908. 

  1908. 		   	   attribute_escape($ipAddress),
    1909. 

  1909. 	   		   attribute_escape($hostname),
    1910. 

  1910. 		   	   attribute_escape($urlRequested), 
    1911. 

  1911. 		   	   attribute_escape($userAgent),
    1912. 

  1912. 	   		   attribute_escape($referrer),
    1913. 

  1913. 		   	   attribute_escape($search_phrase),
    1914. 

  1914. 		   	   attribute_escape($searchpage), 
    1915. 

  1915. 	   		   attribute_escape($os), 
    1916. 

  1916. 		   	   attribute_escape($browser), 
    1917. 

  1917. 		   	   attribute_escape($language), 
    1918. 

  1918. 	   		   attribute_escape($screen_res), 
    1919. 

  1919. 		   	   attribute_escape($searchengine), 
    1920. 

  1920. 		   	   attribute_escape($spider), 
    1921. 

  1921. 	   		   attribute_escape($feed), 
    1922. 

  1922. 		   	   attribute_escape($logged_user), 
    1923. 

  1923. 		   	   attribute_escape($comment_user), 
    1924. 

  1924. 	   		   attribute_escape($spam)
    1925. 

  1925. 		   	   ));
    1926. 

  1926.                 } else {
    1927. 

  1927. 	                $insert = $wpdb->query("INSERT INTO " . $table_name .
    1928. 

  1928.         	           " (wassup_id, `timestamp`, ip, hostname, urlrequested, agent, referrer, search, searchpage, os, browser, language, screen_res, searchengine, spider, feed, username, comment_author, spam) " .
    1929. 

  1929.                 	   "VALUES (
    1930. 

  1930. 	                   '".attribute_escape($wassup_id)."',
    1931. 

  1931.         	           '".attribute_escape($timestamp)."',
    1932. 

  1932.                 	   '".attribute_escape($ipAddress)."',
    1933. 

  1933. 	                   '".attribute_escape($hostname)."',
    1934. 

  1934.         	           '".attribute_escape($urlRequested)."', 
    1935. 

  1935.                 	   '".attribute_escape($userAgent)."',
    1936. 

  1936. 	                   '".attribute_escape($referrer)."',
    1937. 

  1937.         	           '".attribute_escape($search_phrase)."',
    1938. 

  1938.                 	   '".attribute_escape($searchpage)."', 
    1939. 

  1939. 	                   '".attribute_escape($os)."', 
    1940. 

  1940.         	           '".attribute_escape($browser)."', 
    1941. 

  1941.                 	   '".attribute_escape($language)."', 
    1942. 

  1942. 	                   '".attribute_escape($screen_res)."', 
    1943. 

  1943.         	           '".attribute_escape($searchengine)."', 
    1944. 

  1944.                 	   '".attribute_escape($spider)."', 
    1945. 

  1945. 	                   '".attribute_escape($feed)."', 
    1946. 

  1946.         	           '".attribute_escape($logged_user)."', 
    1947. 

  1947.                 	   '".attribute_escape($comment_user)."', 
    1948. 

  1948. 	                   '".attribute_escape($spam)."'
    1949. 

  1949.         	           )");
    1950. 

  1950. 		} //end else method_exists(prepare)
    1951. 

  1951.         } //end if table exists
    1952. 

  1952.         } //end if !empty($table_name)
    1953. 

  1953. } //end function insert_into_wp
    1954. 

  1954. 

  1955. // This is the function to print out a chart's preview in the dashboard
    1956. 

  1956. function wassupDashChart() {
    1957. 

  1957. 	global $wpdb, $wassup_options;
    1958. 

  1958. 	if ($wassup_options->wassup_dashboard_chart == 1) {
    1959. 

  1959. 	$table_name = $wpdb->prefix . "wassup";
    1960. 

  1960. 	$to_date = wassup_get_time();
    1961. 

  1961. 	$Chart = New MainItems;
    1962. 

  1962. 	$Chart->tableName = $table_name;
    1963. 

  1963. 	$Chart->to_date = $to_date;
    1964. 

  1964. 

  1965. 	echo '<h3>WassUp Stats <cite><a href="admin.php?page=wassup">More &raquo;</a></cite></h3>';
    1966. 

  1966.         echo $Chart->TheChart(1, "400", "125", "", $wassup_options->wassup_chart_type, "bg,s,00000000", "dashboard", "left");
    1967. 

  1967. 	}
    1968. 

  1968. } //end function wassupDashChart
    1969. 

  1969. 

  1970. //#Return current PHP session.save_path value (pathname portion)
    1971. 

  1971. function getSessionpath() {
    1972. 

  1972. 	$sessionpath = session_save_path();
    1973. 

  1973. 	if (strpos($sessionpath, ";") !== FALSE) {
    1974. 

  1974.      		$sessionpath = substr($sessionpath, strpos($sessionpath, ";")+1);
    1975. 

  1975. 	}
    1976. 

  1976. 	$sessionpath = rtrim($sessionpath,"/");
    1977. 

  1977. 	return $sessionpath;
    1978. 

  1978. }
    1979. 

  1979. 

  1980. function wGetQueryPairs($url){
    1981. 

  1981. 	$parsed_url = parse_url($url);
    1982. 

  1982. 	$tab=parse_url($url);
    1983. 

  1983. 	$host = $tab['host'];
    1984. 

  1984. 	if(key_exists("query",$tab)){
    1985. 

  1985. 	 $query=$tab["query"];
    1986. 

  1986. 	 return explode("&",$query);
    1987. 

  1987. 	} else {
    1988. 

  1988. 	 return null;
    1989. 

  1989. 	}
    1990. 

  1990. }
    1991. 

  1991. 

  1992. function array_search_extended($file,$str_search) {
    1993. 

  1993. 	foreach($file as $key => $line) {
    1994. 

  1994. 		if (strpos($line, $str_search)!== FALSE) {
    1995. 

  1995. 			return $key;
    1996. 

  1996. 		}
    1997. 

  1997. 	}
    1998. 

  1998. 	return false;
    1999. 

  1999. }
    2000. 

  2000. 

  2001. function seReferer($ref = false){
    2002. 

  2002.     $SeReferer = (is_string($ref) ? $ref : mb_convert_encoding(strip_tags($_SERVER['HTTP_REFERER']), "HTML-ENTITIES", "auto"));
    2003. 

  2003.     if( //Check against Google, Yahoo, MSN, Ask and others
    2004. 

  2004.         preg_match(
    2005. 

  2005.         "/[&\?](prev|q|p|w|searchfor|as_q|as_epq|s|query)=([^&]+)/i",
    2006. 

  2006.         $SeReferer,$pcs)
    2007. 

  2007.     ){
    2008. 

  2008.         if(preg_match("/https?:\/\/([^\/]+)\//i",$SeReferer,$SeDomain)){
    2009. 

  2009.             $SeDomain    = trim(strtolower($SeDomain[1]));
    2010. 

  2010.             $SeQuery    = $pcs[2];
    2011. 

  2011.             if(preg_match("/[&\?](start|b|first|stq)=([0-9]*)/i",$SeReferer,$pcs)){
    2012. 

  2012.                 $SePos    = (int)trim($pcs[2]);
    2013. 

  2013.             }
    2014. 

  2014.         }
    2015. 

  2015.     }
    2016. 

  2016.     if(!isset($SeQuery)){
    2017. 

  2017.         if( //Check against DogPile
    2018. 

  2018.             preg_match(
    2019. 

  2019.             "/\/search\/web\/([^\/]+)\//i",
    2020. 

  2020.             $SeReferer,$pcs)
    2021. 

  2021.         ){
    2022. 

  2022.             if(preg_match("/https?:\/\/([^\/]+)\//i",$SeReferer,$SeDomain)){
    2023. 

  2023.                 $SeDomain    = trim(strtolower($SeDomain[1]));
    2024. 

  2024.                 $SeQuery    = $pcs[1];
    2025. 

  2025.             }
    2026. 

  2026.         }
    2027. 

  2027.     }
    2028. 

  2028.     // We Do Not have a query
    2029. 

  2029.     if(!isset($SeQuery)){ return false; }
    2030. 

  2030.     $OldQ=$SeQuery;
    2031. 

  2031.     $SeQuery=urldecode($SeQuery);
    2032. 

  2032.     // The Multiple URLDecode Trick to fix DogPile %XXXX Encodes
    2033. 

  2033.     while($SeQuery != $OldQ){
    2034. 

  2034.         $OldQ=$SeQuery; $SeQuery=urldecode($SeQuery);
    2035. 

  2035.     }
    2036. 

  2036.     //-- We have a query
    2037. 

  2037.     return array(
    2038. 

  2038.         "Se"=>$SeDomain,
    2039. 

  2039.         "Query"=>$SeQuery,
    2040. 

  2040.         "Pos"=>(int)$SePos,
    2041. 

  2041.         "Referer"=>$SeReferer
    2042. 

  2042.     );
    2043. 

  2043. }
    2044. 

  2044. 

  2045. function wGetSE($referrer = null){
    2046. 

  2046. 	$key = null;
    2047. 

  2047. 	$lines = array("Alice|search.alice.it|qs|", "Google|www.google.|as_q|", "Google|www.google.|q|", "Google Groups|groups.google.|q|", 
    2048. 

  2048. 			"Google Images|images.google.|prev|", "Yahoo|search.yahoo.com|p|", "Google Blog|blogsearch.google.|as_q|", "Google Blog|blogsearch.google.|q|",
    2049. 

  2049. 			"Virgilio|search.virgilio.it|qs|","Arianna|arianna.libero.it|query|","Altavista|.altavista.com|q|","Kataweb|kataweb.it|q|",
    2050. 

  2050. 			"Il Trovatore|categorie.iltrovatore.it|query|","Il Trovatore|search.iltrovatore.it|q|","2020Search|2020search.c|us|st|pn|1|",
    2051. 

  2051. 			"abcsearch.com|abcsearch.com|terms|","100Links|100links.supereva.it|q|","Alexa|alexa.com|q|","Alltheweb|alltheweb.com|q|",
    2052. 

  2052. 			"Aol|.aol.|query|","Aol|aolrecherches.aol.fr|query|","Ask|ask.com|ask|","Ask|ask.com|q|","DMOZ|search.dmoz.org|search|",
    2053. 

  2053. 			"Dogpile|dogpile.com|q|","Excite|excite.|q|","Godago|.godago.com|keywords|","HotBot|hotbot.*|query|","ixquick|ixquick.com|query|",
    2054. 

  2054. 			"Lycos|cerca.lycos.it|query|","Lycos|lycos.|q|","Windows Live|search.live.com|q|mkt|","My Search|mysearch.com|searchfor|",
    2055. 

  2055. 			"My Way|mysearch.myway.com|searchfor|","Metacrawler|metacrawler.|q|","Netscape Search|search.netscape.com|query|","MSN|msn.|q|",
    2056. 

  2056. 			"Overture|overture.com|Keywords|","Supereva|supereva.it|q|","Teoma|teoma.com|q|","Tiscali|search-dyn.tiscali.|key|","Voil|voila.fr|kw|",
    2057. 

  2057. 			"Web|web.de|su|","Clarence|search.clarence.com|q|","Gazzetta|search.gazzetta.it|q|","PagineGialle|paginegialle.it|qs|",
    2058. 

  2058. 			"Jumpy|servizi.mediaset.it|searchWord|","ItaliaPuntoNet|italiapuntonet.net|search|","StartNow|search.startnow.|q|","Search|search.it|srctxt|",
    2059. 

  2059. 			"Search|search.com|q|", "Good Search|goodsearch.com|Keywords|", "ABC Sok|verden.abcsok.no|q|", "Kvasir|kvasir.no|searchExpr|", 
    2060. 

  2060. 			"Start.no|start.no|q|", "bluewin.ch|bluewin.ch|query|", "Google Translate|translate.google.|u|");
    2061. 

  2061. 	foreach($lines as $line_num => $se) {
    2062. 

  2062. 		list($nome,$url,$key,$lang)=explode("|",$se);
    2063. 

  2063. 		if(@strpos($referrer,$url)===FALSE) continue;
    2064. 

  2064. 		// found it!
    2065. 

  2065. 		// The SE is Google Images
    2066. 

  2066. 		if ($nome == "Google Images") {
    2067. 

  2067. 			$variables = wGetQueryPairs($referrer);
    2068. 

  2068. 			$rightkey = array_search_extended($variables, "images");
    2069. 

  2069. 			$variables = eregi_replace("prev=/images\?q=", "", urldecode($variables[$rightkey]));
    2070. 

  2070. 			$variables = explode("&",$variables);
    2071. 

  2071. 			return ($nome."|".urldecode($variables[0]));
    2072. 

  2072. 		} else {
    2073. 

  2073. 			$variables = wGetQueryPairs($referrer);
    2074. 

  2074. 			$i = count($variables);
    2075. 

  2075. 			while($i--){
    2076. 

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

  2077. 			   if($tab[0] == $key){return ($nome."|".urldecode($tab[1]));}
    2078. 

  2078. 			}
    2079. 

  2079. 		}
    2080. 

  2080. 	}
    2081. 

  2081. 	return null;
    2082. 

  2082. }
    2083. 

  2083. 

  2084. //extract browser and platform info from a user agent string and
    2085. 

  2085. // return the values in an array: 0->browser 1->os. -Helene D. 6/7/08.
    2086. 

  2086. function wGetBrowser($agent="") {
    2087. 

  2087. 	if (empty($agent)) { $agent = $_SERVER['HTTP_USER_AGENT']; }
    2088. 

  2088. 	$browsercap = array();
    2089. 

  2089. 	$browscapbrowser = "";
    2090. 

  2090. 	$browser = "";
    2091. 

  2091. 	$os = "";
    2092. 

  2092. 	//check PHP browscap data for browser and platform, when available
    2093. 

  2093. 	if (ini_get("browscap") != "" ) {
    2094. 

  2094. 		$browsercap = get_browser($agent,true);
    2095. 

  2095. 		if (!empty($browsercap['platform'])) {
    2096. 

  2096. 		if (stristr($browsercap['platform'],"unknown") === false) {
    2097. 

  2097. 			$os = $browsercap['platform'];
    2098. 

  2098. 			if (!empty($browsercap['browser'])) {
    2099. 

  2099. 				$browser = $browsercap['browser'];
    2100. 

  2100. 			} else {
    2101. 

  2101. 				$browser = $browsercap['parent'];
    2102. 

  2102. 			}
    2103. 

  2103. 			if (!empty($browsercap['version'])) {
    2104. 

  2104. 				$browser = $browser." ".$browsercap['version'];
    2105. 

  2105. 			}
    2106. 

  2106. 		} }
    2107. 

  2107. 		//reject generic browscap browsers (ex: mozilla, default)
    2108. 

  2108. 		if (preg_match('/^(mozilla|default|unknown)/i',$browser) > 0) {
    2109. 

  2109. 			$browscapbrowser = "$browser";	//save just in case
    2110. 

  2110. 			$browser = "";
    2111. 

  2111. 		}
    2112. 

  2112. 	}
    2113. 

  2113. 	$os = trim($os); 
    2114. 

  2114. 	$browser = trim($browser);
    2115. 

  2115. 

  2116. 	//use Detector class when browscap is missing or browser is unknown
    2117. 

  2117. 	if ( $os == "" || $browser == "") {
    2118. 

  2118. 		$dip = &new Detector("", $agent);
    2119. 

  2119. 		$browser =  trim($dip->browser." ".$dip->browser_version);
    2120. 

  2120. 		$os = trim($dip->os." ".$dip->os_version);
    2121. 

  2121. 

  2122. 		//use saved browscap data, if Detector had no results
    2123. 

  2123. 		if (!empty($browscapbrowser) && ($browser == "" || $browser == "N/A")) {
    2124. 

  2124. 			if ($os != "" && $os != "N/A") {
    2125. 

  2125. 				$browser = $browscapbrowser;
    2126. 

  2126. 			}
    2127. 

  2127. 		}
    2128. 

  2128. 	}
    2129. 

  2129. 	return array($browser,$os);
    2130. 

  2130. } //end function wGetBrowser
    2131. 

  2131. 

  2132. //extract spider and feed info from a user agent string and
    2133. 

  2133. // return the values in an array: 0->spider 1->feed
    2134. 

  2134. function wGetSpider($agent="",$hostname="", $browser=""){
    2135. 

  2135. 	if (empty($agent)) { $agent = $_SERVER['HTTP_USER_AGENT']; }
    2136. 

  2136. 	$ua = $agent;
    2137. 

  2137. 	$crawler = "";
    2138. 

  2138. 	$feed = "";
    2139. 

  2139. 	$os = "";
    2140. 

  2140. 	//check browscap data for crawler info., when available
    2141. 

  2141. 	if (ini_get("browscap") != "" ) {
    2142. 

  2142. 		$browsercap = get_browser($agent,true);
    2143. 

  2143. 		//if no platform(os), assume crawler...
    2144. 

  2144. 		if (!empty($browsercap['platform'])) {
    2145. 

  2145. 			if ( $browsercap['platform'] != "unknown") {
    2146. 

  2146. 				$os = $browsercap['platform'];
    2147. 

  2147. 			}
    2148. 

  2148. 		}
    2149. 

  2149. 		if (!empty($browsercap['crawler']) || !empty($browsercap['stripper']) || $os == "") {
    2150. 

  2150. 			if (!empty($browsercap['browser'])) {
    2151. 

  2151. 				$crawler = $browsercap['browser'];
    2152. 

  2152. 			} else {
    2153. 

  2153. 				$crawler = $browsercap['parent'];
    2154. 

  2154. 			}
    2155. 

  2155. 			if (!empty($browsercap['version'])) {
    2156. 

  2156. 				$crawler = $crawler." ".$browsercap['version'];
    2157. 

  2157. 			}
    2158. 

  2158. 		}
    2159. 

  2159. 		//reject unknown browscap crawlers (ex: default)
    2160. 

  2160. 		if (preg_match('/^(default|unknown)/i',$crawler) > 0) {
    2161. 

  2161. 			$crawler = "";
    2162. 

  2162. 		}
    2163. 

  2163. 	}
    2164. 

  2164. 

  2165. 	//get crawler info. from a known list
    2166. 

  2166. 	$crawler = trim($crawler);
    2167. 

  2167. 	$agent=str_replace(" ","",$agent);
    2168. 

  2168. 	if (empty($crawler)) {
    2169. 

  2169. 		$key = null;
    2170. 

  2170. 	//# query list to identify some feedreaders and bots that don't show their name first in UA string
    2171. 

  2171. 	//#   format: "Bot Name"|"UserAgent keyword" (no spaces)|(F=feedreader or R=robot)
    2172. 

  2172. 	$lines = array( "AboutUsBot|AboutUsBot/|R|", 
    2173. 

  2173. 			"Aggrevator|Aggrevator/0.|F|", 
    2174. 

  2174. 			"AlestiFeedBot|AlestiFeedBot||", 
    2175. 

  2175. 			"Alexa|ia_archiver|R|", "AltaVista|Scooter-|R|", 
    2176. 

  2176. 			"AltaVista|Scooter/|R|", "AltaVista|Scooter_|R|", 
    2177. 

  2177. 			"AMZNKAssocBot|AMZNKAssocBot/|R|",
    2178. 

  2178. 			"AppleSyndication|AppleSyndication/|F|",
    2179. 

  2179. 			"Apple-PubSub|Apple-PubSub/|F|",
    2180. 

  2180. 			"Ask.com/Teoma|AskJeeves/Teoma)|R|",
    2181. 

  2181. 			"Ask Jeeves/Teoma|ask.com|R|",
    2182. 

  2182. 			"AskJeeves|AskJeeves|R|", 
    2183. 

  2183. 			"BlogBot|BlogBot/|F|", "Bloglines|Bloglines/|F|",
    2184. 

  2184. 			"Blogslive|Blogslive|F|",
    2185. 

  2185. 			"BlogsNowBot|BlogsNowBot|F|",
    2186. 

  2186. 			"BlogPulseLive|BlogPulseLive|F|",
    2187. 

  2187. 			"IceRocket BlogSearch|BlogSearch/|F|",
    2188. 

  2188. 			"Charlotte|Charlotte/|R|", 
    2189. 

  2189. 			"Xyleme|cosmos/0.|R|", "cURL|curl/|R|",
    2190. 

  2190. 			"Die|die-kraehe.de|R|", 
    2191. 

  2191. 			"Diggit! Robot|Digger/|R|", 
    2192. 

  2192. 			"disco/Nutch|disco/Nutch|R|",
    2193. 

  2193. 			"Emacs-w3|Emacs-w3/v[0-9\.]+|", 
    2194. 

  2194. 			"ananzi|EMC|", 
    2195. 

  2195. 			"EnaBot|EnaBot|", 
    2196. 

  2196. 			"esculapio|esculapio/1.1|", "Esther|esther|", 
    2197. 

  2197. 			"everyfeed-spider|everyfeed-spider|F|", 
    2198. 

  2198. 			"Evliya|Evliya|", "nzexplorer|explorersearch|", 
    2199. 

  2199. 			"eZ publish Validator|eZpublishLinkValidator|",
    2200. 

  2200. 			"FastCrawler|FastCrawler|R|", 
    2201. 

  2201. 			"FDSE|(compatible;FDSErobot)|R|", 
    2202. 

  2202. 			"Feed::Find|Feed::Find|",
    2203. 

  2203. 			"FeedBurner|FeedBurner|F|",
    2204. 

  2204. 			"FeedDemon|FeedDemon/|F|",
    2205. 

  2205. 			"FeedHub FeedFetcher|FeedHub|F|", 
    2206. 

  2206. 			"Feedreader|Feedreader|F|", 
    2207. 

  2207. 			"Feedshow|Feedshow|F|", 
    2208. 

  2208. 			"Feedster|Feedster|F|",
    2209. 

  2209. 			"FeedTools|feedtools|F|",
    2210. 

  2210. 			"Feedfetcher-Google|Feedfetcher-google|F|", 
    2211. 

  2211. 			"Felix|FelixIDE/1.0|", "Wild|Hazel's|", "FetchRover|ESIRover|", 
    2212. 

  2212. 			"fido|fido/0.9|", 
    2213. 

  2213. 			"Fish|Fish-Search-Robot|", "Fouineur|Fouineur|", 
    2214. 

  2214. 			"Freecrawl|Freecrawl|R|", "FunnelWeb|FunnelWeb-1.0|", 
    2215. 

  2215. 			"gammaSpider|gammaSpider|", "gazz|gazz/1.0|", "GCreep|gcreep/1.0|", 
    2216. 

  2216. 			"GetRight|GetRight|R|", 
    2217. 

  2217. 			"GetterroboPlus|straight|", 
    2218. 

  2218. 			"GetURL|GetURL.rexx|", "Golem|Golem/1.1|", 
    2219. 

  2219. 			"Googlebot|Googlebot/|R|", 
    2220. 

  2220. 			"Google|googlebot/|R|","Google Images|Googlebot-Image|R|",
    2221. 

  2221. 			"Google AdSense|Mediapartners-Google|R|", 
    2222. 

  2222. 			"Google Desktop|GoogleDesktop|F|", 
    2223. 

  2223. 			"GreatNews|GreatNews|F|", 
    2224. 

  2224. 			"Gregarius|Gregarius/|F|",
    2225. 

  2225. 			"Gromit|Gromit/1.0|", 
    2226. 

  2226. 			"gsinfobot|gsinfobot|", 
    2227. 

  2227. 			"Northern|Gulliver/1.1|", "Gulper|Gulper|", 
    2228. 

  2228. 			"GurujiBot|GurujiBot|", 
    2229. 

  2229. 			"Harvest|yes|", "havIndex|havIndex/X.xx[bxx]|",
    2230. 

  2230. 			"heritrix|heritrix/|",
    2231. 

  2231. 			"HI|AITCSRobot/1.1|",
    2232. 

  2232. 			"HKU|HKU|", 
    2233. 

  2233. 			"Hometown|Hometown|", 
    2234. 

  2234. 			"ht://Dig|htdig/3|R|", "HTMLgobble|HTMLgobble|", "Hyper-Decontextualizer|Hyper|", 
    2235. 

  2235. 			"iajaBot|iajaBot/0.1|", "IBM_Planetwide|IBM_Planetwide,|", 
    2236. 

  2236. 			"ichiro|ichiro|", 
    2237. 

  2237. 			"Popular|gestaltIconoclast/1.0|", 
    2238. 

  2238. 			"Ingrid|INGRID/0.1|", "Imagelock|Imagelock|", "IncyWincy|IncyWincy/1.0b1|", "Informant|Informant|", 
    2239. 

  2239. 			"InfoSeek|InfoSeek|", 
    2240. 

  2240. 			"InfoSpiders|InfoSpiders/0.1|", "Inspector|inspectorwww/1.0|", "IntelliAgent|'IAGENT/1.0'|", 
    2241. 

  2241. 			"ISC Systems iRc Search|ISCSystemsiRcSearch|", 
    2242. 

  2242. 			"Israeli-search|IsraeliSearch/1.0|", 
    2243. 

  2243. 			"IRLIRLbot/|IRLIRLbot|",
    2244. 

  2244. 			"Italian Blog Rankings|blogbabel|F|", 
    2245. 

  2245. 			"Jakarta|Jakarta|", 
    2246. 

  2246. 			"Java|Java/|",
    2247. 

  2247. 			"JBot|JBot|", 
    2248. 

  2248. 			"JCrawler|JCrawler/0.2|", 
    2249. 

  2249. 			"JoBo|JoBo|", "Jobot|Jobot/0.1alpha|", "JoeBot|JoeBot/x.x,|", "The|JubiiRobot/version#|", "JumpStation|jumpstation|", 
    2250. 

  2250. 			"image.kapsi.net|image.kapsi.net/1.0|R|", 
    2251. 

  2251. 			"Internet|User-Agent:|", 
    2252. 

  2252. 			"kalooga/kalooga|kalooga/kalooga|", 
    2253. 

  2253. 			"Katipo|Katipo/1.0|", "KDD-Explorer|KDD-Explorer/0.1|", 
    2254. 

  2254. 			"KIT-Fireball|KIT-Fireball/2.0|", 
    2255. 

  2255. 			"KindOpener|KindOpener|", 
    2256. 

  2256. 			"kinjabot|kinjabot|", 
    2257. 

  2257. 			"KO_Yappo_Robot|KO_Yappo_Robot/1.0.4(http://yappo.com/info/robot.html)|", 
    2258. 

  2258. 			"Krugle|Krugle|", 
    2259. 

  2259. 			"LabelGrabber|LabelGrab/1.1|",
    2260. 

  2260. 			"Larbin|larbin_|", "legs|legs|", 
    2261. 

  2261. 			"libwww-perl|libwww-perl|", 
    2262. 

  2262. 			"lilina|Lilina|", 
    2263. 

  2263. 			"Link|Linkidator/0.93|", "LinkWalker|LinkWalker|", 
    2264. 

  2264. 			"LiteFinder|LiteFinder|", 
    2265. 

  2265. 			"logo.gif|logo.gif|", 
    2266. 

  2266. 			"LookSmart|grub-client|",
    2267. 

  2267. 			"Lsearch/sondeur|Lsearch/sondeur|", 
    2268. 

  2268. 			"Lycos|Lycos/x.x|", 
    2269. 

  2269. 			"Magpie|Magpie/1.0|", 
    2270. 

  2270. 			"MagpieRSS|MagpieRSS|", 
    2271. 

  2271. 			"Mail.ru|Mail.ru|", 
    2272. 

  2272. 			"marvin/infoseek|marvin/infoseek|", 
    2273. 

  2273. 			"Mattie|M/3.8|", 
    2274. 

  2274. 			"MediaFox|MediaFox/x.y|", 
    2275. 

  2275. 			"Megite2.0|Megite.com|", 
    2276. 

  2276. 			"NEC-MeshExplorer|NEC-MeshExplorer|", 
    2277. 

  2277. 			"MindCrawler|MindCrawler|", 
    2278. 

  2278. 			"Missigua Locator|Missigua Locator|", 
    2279. 

  2279. 			"MJ12bot|MJ12bot|", 
    2280. 

  2280. 			"mnoGoSearch|UdmSearch|", 
    2281. 

  2281. 			"MOMspider|MOMspider/1.00|", 
    2282. 

  2282. 			"Monster|Monster/vX.X.X|", 
    2283. 

  2283. 			"Moreover|Moreoverbot|",
    2284. 

  2284. 			"Motor|Motor/0.2|", 
    2285. 

  2285. 			"MSNBot|MSNBOT/0.1|R|", 
    2286. 

  2286. 			"MSN|msnbot|R|",
    2287. 

  2287. 			"MSRBOT|MSRBOT|R|", 
    2288. 

  2288. 			"Muninn|Muninn/0.1|", 
    2289. 

  2289. 			"Muscat|MuscatFerret/<version>|", 
    2290. 

  2290. 			"Mwd.Search|MwdSearch/0.1|", 
    2291. 

  2291. 			"Naver|NaverBot|","Naver|Cowbot|",
    2292. 

  2292. 			"NDSpider|NDSpider/1.5|", 
    2293. 

  2293. 			"Nederland.zoek|Nederland.zoek|", 
    2294. 

  2294. 			"NetCarta|NetCarta|", "NetMechanic|NetMechanic|", 
    2295. 

  2295. 			"NetScoop|NetScoop/1.0|", 
    2296. 

  2296. 			"NetNewsWire|NetNewsWire|", 
    2297. 

  2297. 			"NewsAlloy|NewsAlloy|",
    2298. 

  2298. 			"newscan-online|newscan-online/1.1|", 
    2299. 

  2299. 			"NewsGatorOnline|NewsGatorOnline|", 
    2300. 

  2300. 			"NG/2.0|NG/2.0|", 
    2301. 

  2301. 			"NHSE|NHSEWalker/3.0|", "Nomad|Nomad-V2.x|", 
    2302. 

  2302. 			"Nutch/Nutch|Nutch/Nutch|", 
    2303. 

  2303. 			"ObjectsSearch|ObjectsSearch/0.01|", 
    2304. 

  2304. 			"Occam|Occam/1.0|", 
    2305. 

  2305. 			"Openfind|Openfind|", 
    2306. 

  2306. 			"OpiDig|OpiDig|", 
    2307. 

  2307. 			"Orb|Orbsearch/1.0|", 
    2308. 

  2308. 			"OSSE Scanner|OSSE Scanner|", 
    2309. 

  2309. 			"OWPBot|OWPBot|", 
    2310. 

  2310. 			"Pack|PackRat/1.0|", "ParaSite|ParaSite/0.21|", 
    2311. 

  2311. 			"Patric|Patric/0.01a|", 
    2312. 

  2312. 			"PECL::HTTP|PECL::HTTP|", 
    2313. 

  2313. 			"PerlCrawler|PerlCrawler/1.0|", 
    2314. 

  2314. 			"Phantom|Duppies|", "PhpDig|phpdig/x.x.x|", 
    2315. 

  2315. 			"PiltdownMan|PiltdownMan/1.0|", 
    2316. 

  2316. 			"Pimptrain.com's|Pimptrain|", "Pioneer|Pioneer|", 
    2317. 

  2317. 			"Portal|PortalJuice.com/4.0|", "PGP|PGP-KA/1.2|", 
    2318. 

  2318. 			"PlumtreeWebAccessor|PlumtreeWebAccessor/0.9|", 
    2319. 

  2319. 			"Poppi|Poppi/1.0|", "PortalB|PortalBSpider/1.0|", 
    2320. 

  2320. 			"psbot|psbot/|", 
    2321. 

  2321. 			"R6_CommentReade|R6_CommentReade|", 
    2322. 

  2322. 			"R6_FeedFetcher|R6_FeedFetcher|", 
    2323. 

  2323. 			"radianrss|RadianRSS|", 
    2324. 

  2324. 			"Raven|Raven-v2|", 
    2325. 

  2325. 			"relevantNOISE|www.relevantnoise.com|",
    2326. 

  2326. 			"Resume|Resume|", "RoadHouse|RHCS/1.0a|", 
    2327. 

  2327. 			"RixBot|RixBot|", "Road|Road|", 
    2328. 

  2328. 			"Robbie|Robbie/0.1|", "RoboCrawl|RoboCrawl|", 
    2329. 

  2329. 			"RoboFox|Robofox|", "Robot|Robot|", 
    2330. 

  2330. 			"Robozilla|Robozilla/1.0|", 
    2331. 

  2331. 			"Rojo|rojo|F|", 
    2332. 

  2332. 			"Roverbot|Roverbot|", 
    2333. 

  2333. 			"RssBandit|RssBandit|", 
    2334. 

  2334. 			"RSSMicro|RSSMicro.com|F|",
    2335. 

  2335. 			"Ruby|Rfeedfinder|", 
    2336. 

  2336. 			"RuLeS|RuLeS/1.0|", 
    2337. 

  2337. 			"Runnk RSS aggregator|Runnk|", 
    2338. 

  2338. 			"SafetyNet|SafetyNet|", 
    2339. 

  2339. 			"Sage|(Sage)|F|",
    2340. 

  2340. 			"SBIder|Site|", 
    2341. 

  2341. 			"Scooter|Scooter/2.0|", 
    2342. 

  2342. 			"ScoutJet|ScoutJet|",
    2343. 

  2343. 			"Search.Aus-AU.COM|not|", 
    2344. 

  2344. 			"SearchProcess|searchprocess/0.9|", 
    2345. 

  2345. 			"Seekbot|HTTPFetcher|", 
    2346. 

  2346. 			"wp-autoblogSimplePie|SimplePie|", 
    2347. 

  2347. 			"Sitemap Generator|SitemapGenerator|", 
    2348. 

  2348. 			"Senrigan|Senrigan/xxxxxx|", 
    2349. 

  2349. 			"SG-Scout|SG-Scout|", "Shai'Hulud|Shai'Hulud|", 
    2350. 

  2350. 			"Simmany|SimBot/1.0|", 
    2351. 

  2351. 			"SiteTech-Rover|SiteTech-Rover|", 
    2352. 

  2352. 			"shelob|shelob|", 
    2353. 

  2353. 			"Skymob.com|aWapClient|", 
    2354. 

  2354. 			"Sleek|Sleek|", 
    2355. 

  2355. 			"Inktomi|Slurp/2.0|", 
    2356. 

  2356. 			"Snapbot|Snap|",
    2357. 

  2357. 			"Smart|ESISmartSpider/2.0|", 
    2358. 

  2358. 			"Snooper|Snooper/b97_01|", "Solbot|Solbot/1.0|", 
    2359. 

  2359. 			"Sphere Scout|SphereScout|", 
    2360. 

  2360. 			"Spider|Spider|", "spider_monkey|mouse.house/7.1|", "SpiderBot|SpiderBot/1.0|", "Spiderline|spiderline/3.1.3|", "SpiderView(tm)|SpiderView|", "Site|ssearcher100|", 
    2361. 

  2361. 			"StackRambler|StackRambler|", 
    2362. 

  2362. 			"Strategic Board Bot|StrategicBoardBot|", 
    2363. 

  2363. 			"Suke|suke/*.*|", 
    2364. 

  2364. 			"SummizeFeedReader|SummizeFeedReader|", 
    2365. 

  2365. 			"suntek|suntek/1.0|", 
    2366. 

  2366. 			"SurveyBot|SurveyBot|", 
    2367. 

  2367. 			"Sygol|http://www.sygol.com|", 
    2368. 

  2368. 			"Syndic8|Syndic8|F|", 
    2369. 

  2369. 			"TACH|TACH|", "Tarantula|Tarantula/1.0|",
    2370. 

  2370. 			"tarspider|tarspider|", "Tcl|dlw3robot/x.y|", 
    2371. 

  2371. 			"TechBOT|TechBOT|", 
    2372. 

  2372. 			"Technorati|Technoratibot|",
    2373. 

  2373. 			"Teemer|Teemer|", 
    2374. 

  2374. 			"Templeton|Templeton/{version}|",
    2375. 

  2375. 			"TitIn|TitIn/0.2|", "TITAN|TITAN/0.1|", 
    2376. 

  2376. 			"Twiceler|cuill.com/twiceler/|R|",
    2377. 

  2377. 			"UCSD|UCSD-Crawler|", "UdmSearch|UdmSearch/2.1.1|",
    2378. 

  2378. 			"UniversalFeedParser|UniversalFeedParser|", 
    2379. 

  2379. 			"UptimeBot|uptimebot|", 
    2380. 

  2380. 			"URL|urlck/1.2.3|", "URL|URL|", 
    2381. 

  2381. 			"VadixBot|VadixBot|", 
    2382. 

  2382. 			"Valkyrie|Valkyrie/1.0|", "Verticrawl|Verticrawlbot|", "Victoria|Victoria/1.0|", "vision-search|vision-search/3.0'|", 
    2383. 

  2383. 			"void-bot|void-bot/0.1|", 
    2384. 

  2384. 			"Voila|VoilaBot|",
    2385. 

  2385. 			"Voyager|Voyager/0.0|", "VWbot|VWbot_K/4.2|", 
    2386. 

  2386. 			"W3C_Validator|W3C_Validator|",
    2387. 

  2387. 			"The|w3index|", "W3M2|W3M2/x.xxx|", 
    2388. 

  2388. 			"w3mir|w3mir|", 
    2389. 

  2389. 			"w@pSpider|w@pSpider/xxx|", 
    2390. 

  2390. 			"WallPaper|CrawlPaper/n.n.n|", "the|WWWWanderer|", 
    2391. 

  2391. 			"Web|root/0.1|", 
    2392. 

  2392. 			"WebCatcher|WebCatcher/1.0|", 
    2393. 

  2393. 			"webcollage|webcollage|", 
    2394. 

  2394. 			"WebCopier|WebCopier|", 
    2395. 

  2395. 			"WebCopy|WebCopy/(version)|", 
    2396. 

  2396. 			"webfetcher|WebFetcher/0.8,|", 
    2397. 

  2397. 			"WebGenBot|WebGenBot|", 
    2398. 

  2398. 			"Webinator|weblayers|", 
    2399. 

  2399. 			"weblayers/0.0|WebLinker|", 
    2400. 

  2400. 			"WebLinker/0.0|WebMirror|", 
    2401. 

  2401. 			"webLyzard|webLyzard|", 
    2402. 

  2402. 			"Weblog|wlm-1.1|", 
    2403. 

  2403. 			"Digimarc|WebReaper|", "WebReaper|webs|", "webs@recruit.co.jp|Websnarf|", "WebVac|webvac/1.0|", "webwalk|webwalk|", 
    2404. 

  2404. 			"WebWalker|WebWalker/1.10|", "WebWatch|WebWatch|", 
    2405. 

  2405. 			"WebStolperer|WOLP/1.0|", 
    2406. 

  2406. 			"WebZinger|none|", 
    2407. 

  2407. 			"Wells Search II|WellsSearchII|", 
    2408. 

  2408. 			"Wget|Wget/1.4.0|", 
    2409. 

  2409. 			"Wget|Wget/1.|",
    2410. 

  2410. 			"whatUseek|whatUseek_winona/3.0|", 
    2411. 

  2411. 			"whiteiexpres/Nutch|whiteiexpres/Nutch|",
    2412. 

  2412. 			"wikioblogs|wikioblogs|", 
    2413. 

  2413. 			"WikioFeedBot|WikioFeedBot|", 
    2414. 

  2414. 			"WikioPxyFeedBo|WikioPxyFeedBo|",
    2415. 

  2415. 			"Wired|wired-digital-newsbot/1.5|", 
    2416. 

  2416. 			"Wordpress Pingback/Trackback|Wordpress|", 
    2417. 

  2417. 			"WWWC|WWWC/0.25|", 
    2418. 

  2418. 			"XGET|XGET/0.7|", 
    2419. 

  2419. 			"yacybot|yacybot|",
    2420. 

  2420. 			"MyBlogLog|Yahoo!MyBlogLogAPIClient|F|",
    2421. 

  2421. 			"Yahoo!|slurp@inktomi|","Yahoo!|Yahoo!Slurp|","Yahoo!|MMCrawler|",
    2422. 

  2422. 			"Yahoo FeedSeeker|YahooFeedSeeker|",
    2423. 

  2423. 			"Tailrank|Spinn3r|F|",
    2424. 

  2424. 			"Yandex|Yandex|");
    2425. 

  2425. 		foreach($lines as $line_num => $spider) {
    2426. 

  2426. 			list($nome,$key,$typebot)=explode("|",$spider);
    2427. 

  2427. 			if ($key != "") {
    2428. 

  2428. 				if(strstr($agent,$key)===FALSE) { 
    2429. 

  2429. 					continue; 
    2430. 

  2430. 				} else { 
    2431. 

  2431. 					$crawler = trim($nome);
    2432. 

  2432. 					if (!empty($typebot) && $typebot == "F") {
    2433. 

  2433. 						$feed = $crawler;
    2434. 

  2434. 					}
    2435. 

  2435. 				}
    2436. 

  2436. 			}
    2437. 

  2437. 		}
    2438. 

  2438. 	} // end if crawler
    2439. 

  2439. 

  2440. 	//#If crawler not in list, use first word in user agent for crawler name
    2441. 

  2441. 	if (empty($crawler)) { 
    2442. 

  2442. 		if (preg_match("/^(\w+)[\/\ \-\:_\.]/",$ua,$matches) > 0) {
    2443. 

  2443. 			if (strlen($matches[1]) > 1 && $matches[1] != "Mozilla") { 
    2444. 

  2444. 				$crawler = $matches[1];
    2445. 

  2445. 			}
    2446. 

  2446. 		}
    2447. 

  2447. 		if (empty($crawler) && !empty($browser)) { 
    2448. 

  2448. 			$crawler = $browser;
    2449. 

  2449. 		}
    2450. 

  2450. 	}
    2451. 

  2451. 

  2452. 	//#do a feed check and get feed subcribers, if available
    2453. 

  2453. 	if (preg_match("/([0-9]{1,10})(subscriber)/i",$agent,$subscriber) > 0) {
    2454. 

  2454. 		// It's a feedreader with some subscribers
    2455. 

  2455. 		$feed = $subscriber[1];
    2456. 

  2456. 		if (empty($crawler)) { 
    2457. 

  2457. 			$crawler = "Feed Reader";
    2458. 

  2458. 		}
    2459. 

  2459. 	} elseif (is_feed() || (empty($feed) && preg_match("/(feed|rss)/i",$agent)>0)) {
    2460. 

  2460. 		if (!empty($crawler)) { 
    2461. 

  2461. 			$feed = $crawler;
    2462. 

  2462. 		} else {
    2463. 

  2463. 			$crawler = "Feed Reader";
    2464. 

  2464. 			$feed = "feed reader";
    2465. 

  2465. 		}
    2466. 

  2466. 	} //end else preg_match subscriber
    2467. 

  2467. 

  2468. 	//check for spoofers of Google/Yahoo crawlers...
    2469. 

  2469. 	if ($hostname!="") {
    2470. 

  2470. 		if (preg_match('/^(googlebot|yahoo\!\ slurp)/i',$crawler)>0 && preg_match('/\.(googlebot|yahoo)\./i',$hostname)==0){
    2471. 

  2471. 			$crawler = "Spoofer bot";
    2472. 

  2472. 		}
    2473. 

  2473. 	} //end if hostname
    2474. 

  2474. 

  2475. 	return array($crawler,trim($feed));
    2476. 

  2476. } //end function wGetSpider
    2477. 

  2477. 

  2478. //#get the visitor locale/language
    2479. 

  2479. function wGetLocale($language="",$hostname="",$referrer="") {
    2480. 

  2480. 	//#use country code for language, if it exists in hostname
    2481. 

  2481. 	if (!empty($hostname) && preg_match("/\.[a-zA-Z]{2}$/", $hostname) > 0) {
    2482. 

  2482. 		$country = strtolower(substr($hostname,-2));
    2483. 

  2483. 		if ($country == "uk") { $country = "gb"; } //change UK to GB for consistent language codes
    2484. 

  2484. 		$language = $country;
    2485. 

  2485. 	} elseif (strlen($language) >2) {
    2486. 

  2486. 	   	$langarray = @explode("-", $language);
    2487. 

  2487. 	   	$langarray = @explode(",", $langarray[1]);
    2488. 

  2488. 	   	list($language) = @explode(";", strtolower($langarray[0]));
    2489. 

  2489. 	}
    2490. 

  2490. 	//#check referrer search string for language/locale code, if any
    2491. 

  2491. 	if ((empty($language) || $language=="us" || $language=="en") && !empty($referrer)) {
    2492. 

  2492. 		$country = $language;
    2493. 

  2493. 		// google referrer syntax: google.com[.country],hl=language
    2494. 

  2494. 		if (preg_match('/\.google(\.com)?\.(com|([a-z]{2}))?\/.*[&?]hl\=(\w{2})\-?(\w{2})?/',$referrer,$matches)>0) {
    2495. 

  2495. 			if (!empty($matches[5])) {
    2496. 

  2496. 				$country = strtolower($matches[5]);
    2497. 

  2497. 			} elseif (!empty($matches[3])) {
    2498. 

  2498. 				$country = strtolower($matches[3]);
    2499. 

  2499. 			} elseif (!empty($matches[4])) {
    2500. 

  2500. 				$country = strtolower($matches[4]);
    2501. 

  2501. 			}
    2502. 

  2502. 		}
    2503. 

  2503. 		$language = $country;
    2504. 

  2504. 	}
    2505. 

  2505. 	//default to "US" if language==en (english)
    2506. 

  2506. 	if ($language == "en") {
    2507. 

  2507. 		$language = "us";
    2508. 

  2508. 	}
    2509. 

  2509. 	return $language;
    2510. 

  2510. } //end function wGetLocale
    2511. 

  2511. 

  2512. //# Check input, $referrer against a list of known spammers and 
    2513. 

  2513. //#   return "1" if match found. 
    2514. 

  2514. //#   All comparisons are case-insensistive and uses the faster string 
    2515. 

  2515. //#   functions (stristr) instead of "regular expression" functions.
    2516. 

  2516. function wGetSpamRef($referrer) {
    2517. 

  2517. 	$referrer=htmlentities(strip_tags(str_replace(" ","",html_entity_decode($referrer))));
    2518. 

  2518. 	$badhostfile= dirname(__FILE__).'/badhosts.txt';
    2519. 

  2519.         $key = null;
    2520. 

  2520. 	if (empty($referrer)) { return null; }	//nothing to check...
    2521. 

  2521. 

  2522. 	//#Assume any referrer name similar to "viagra/zanax/.."
    2523. 

  2523. 	//#  is spam and mark as such...
    2524. 

  2524. 	$lines = array("cialis","viagra","zanax","phentermine");
    2525. 

  2525. 	foreach ($lines as $badreferrer) {
    2526. 

  2526. 		if (stristr($referrer, $badreferrer) !== FALSE) { 
    2527. 

  2527. 			return 1;
    2528. 

  2528. 		}
    2529. 

  2529. 	}
    2530. 

  2530. 	$lines = array("1clickholdem.com", "1ps.biz", "24h.to", "4all-credit.com", "4all-prescription.com", "4u-money.com", "6q.org", "88.to", "always-casino.com",
    2531. 

  2531.         "always-credit.com", "andipink.com", "antiquemarketplace.net", "artmedia.com.ru", "asstraffic.com", "at.cx", "available-casino.com", "available-credit.com",
    2532. 

  2532.         "available-prescription.com", "base-poker.com", "bayfronthomes.net", "bitlocker.net", "black-poker.com", "blest-money.com", "budgethawaii.net", "bwdow.com",
    2533. 

  2533.         "cafexml.com", "cameralover.net", "capillarychromatogr.org", "cash-2u.com", "casino-500.com", "casino-bu.com", "casinos4spain.com", "cheat-elite.com", "clan.ws",
    2534. 

  2534.         "computerxchange.com", "conjuratia.com", "credit-4me.com", "credit-dreams.com", "cups.cs.cmu.edu", "de.tc", "dietfacts.com", "doctor-here.com", "doctor-test.com",
    2535. 

  2535.         "eu.cx", "fidelityfunding.net", "finance-4all.com", "finestrealty.net", "fortexasholdem.com", "freewarechannel.de", "gb.com", "golfshoot.com", "great-finance.com",
    2536. 

  2536.         "great-money.com", "health-livening.com", "here.ws", "hu.tc", "iepills.com", "ihomebroker.com", "including-poker.com", "internettexashold.com", "isdrin.de",
    2537. 

  2537.         "iwebtool.com", "jaja-jak-globusy.com", "jobruler.com", "jpe.com", "js4.de", "just-pharmacy.com", "learnhowtoplay.com", "mine-betting.com", "new-doctor.com",
    2538. 

  2538.         "nonews.ru", "now-cash.com", "online-pills.us", "online.cx", "only-casino.com", "ourtexasholdem.com", "p.cx", "partyshopcentral.com", "petsellers.net",
    2539. 

  2539.         "pharmacy-here.com", "pills-only.com", "plenty-cash.com", "poker-check.com", "poker-spanish.com", "pressemitteilung.ws", "quality-poker.com", "reale-amateure.com",
    2540. 

  2540.         "realtorx2.com", "rulen.de", "shop.tc", "sp.st", "spanish-casino-4u.com", "standard-poker.com", "start.bg", "take-mortgage.com", "texasholdfun.com",
    2541. 

  2541.         "the-discount-store.com", "unique-pills.com", "unixlover.com", "us.tc", "useful-pills.com", "vadoptions.com", "vcats.com", "vinsider.com", "vjackpot.com",
    2542. 

  2542.         "vmousetrap.com", "vplaymate.com", "vselling.com", "vsymphony.com", "vthought.com", "walnuttownfireco.org", "white-pills.com", "wkelleylucas.com", "yourpsychic.net",
    2543. 

  2543.         "mature-lessons.com", "wrongsideoftown.com", "wildpass.com", "collegefuckfest.com", "brutalblowjobs.com", "livemarket.com.ua", "allinternal.com", "asstraffic.com",
    2544. 

  2544.         "progressiveupdate.net","dating-s.net","ua-princeton.com","royalfreehost.com", "www.texas-va-loan.com", "jmhic.com", "whvc.net", "vegas-hair.com", "owned.com",
    2545. 

  2545.         "sml338.org", "kredite-kredit", "buy-2005.com", "vrajitor.com", "ro7kalbe.com", "ca-america.com", "udcorp.com", "walnuttownfireco.org", "yx-colorweaving.com",
    2546. 

  2546.         "terashells.com", "chat-nett.com", "exitq.com", "cxa.de", "sysrem03.com", "pharmacy.info", "guide.info", "drugstore.info","vpshs.com", "vp888.net", "coresat.com",
    2547. 

  2547.         "psxtreme.com", "freakycheats.com", "cool-extreme.com", "pervertedtaboo.com", "crescentarian.net", "texas-holdem", "yelucie.com", "poker-online.com",  
    2548. 

  2548.         "findwebhostingnow.com", "smsportali.net", "6q.org", "flowersdeliveredquick.com", "trackerom.com", "andrewsaluk.com", "4u.net", "4u.com", "doobu.com", "isacommie.com",
    2549. 

  2549.         "musicbox1.com", "roody.com", "zoomgirls.net", "cialis-gl-pills.com", "fickenfetzt.com");
    2550. 

  2550. 	foreach($lines as $line_num => $spammer) {
    2551. 

  2551.                 if(stristr($referrer,$spammer) !== FALSE) {
    2552. 

  2552.                         // find it!
    2553. 

  2553.                         return 1;
    2554. 

  2554.                 }
    2555. 

  2555.         }
    2556. 

  2556. 	//#check for a customized spammer list...
    2557. 

  2557. 	if (file_exists($badhostfile)) {
    2558. 

  2558. 		$lines = file($badhostfile,FILE_IGNORE_NEW_LINES);
    2559. 

  2559. 		foreach($lines as $line_num => $spammer) {
    2560. 

  2560. 			if(stristr($referrer,trim($spammer)) !== FALSE) {
    2561. 

  2561.                         // find it!
    2562. 

  2562. 			return 1;
    2563. 

  2563. 			}
    2564. 

  2564. 		}
    2565. 

  2565. 	}
    2566. 

  2566. 	return null;
    2567. 

  2567. } //end function wGetSpamRef()
    2568. 

  2568. 

  2569. function export_wassup() {
    2570. 

  2570. global $wpdb, $table_name;
    2571. 

  2571. $table_name = $wpdb->prefix . "wassup";
    2572. 

  2572. $filename = 'wassup.' . gmdate('Y-m-d') . '.sql';
    2573. 

  2573. 

  2574. //# check for records before exporting...
    2575. 

  2575. $numrecords = $wpdb->get_var("SELECT COUNT(wassup_id) FROM $table_name");
    2576. 

  2576. if ( $numrecords > 0 ) {
    2577. 

  2577. 	//TODO: use compressed file transfer when zlib available...
    2578. 

  2578. 	do_action('export_wassup');
    2579. 

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

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

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

  2582. 

  2583. 	// Function is below
    2584. 

  2584. 	backup_table($table_name);
    2585. 

  2585. 

  2586. 	die(); 	//sends output and flushes buffer
    2587. 

  2587. } //end if numrecords > 0
    2588. 

  2588. } //end function export_wassup()
    2589. 

  2589. 

  2590. /**
    2591. 

  2591. * Taken partially from wp-db-backup plugin
    2592. 

  2592. * Alain Wolf, Zurich - Switzerland
    2593. 

  2593. * Website: http://www.ilfilosofo.com/blog/wp-db-backup/
    2594. 

  2594. * @param string $table
    2595. 

  2595. * @param string $segment
    2596. 

  2596. * @return void
    2597. 

  2597. */
    2598. 

  2598. function backup_table($table, $segment = 'none') {
    2599. 

  2599. 	global $wpdb;
    2600. 

  2600. 	define('ROWS_PER_SEGMENT', 100);
    2601. 

  2601. 

  2602. 	$table_structure = $wpdb->get_results("DESCRIBE $table");
    2603. 

  2603. 	if (! $table_structure) {
    2604. 

  2604. 		$this->error(__('Error getting table details','wassup') . ": $table");
    2605. 

  2605. 		return FALSE;
    2606. 

  2606. 	}
    2607. 

  2607. 

  2608. 	if(($segment == 'none') || ($segment == 0)) {
    2609. 

  2609. 		// Add SQL statement to drop existing table
    2610. 

  2610. 		$sql .= "\n\n";
    2611. 

  2611. 		$sql .= "#\n";
    2612. 

  2612. 		$sql .= "# " . sprintf(__('Delete any existing table %s','wassup'),$table) . "\n";
    2613. 

  2613. 		$sql .= "#\n";
    2614. 

  2614. 		$sql .= "\n";
    2615. 

  2615. 		$sql .= "#\n";
    2616. 

  2616. 		$sql .= "# Uncomment if you need\n";
    2617. 

  2617. 		$sql .= "#DROP TABLE IF EXISTS " . $table . ";\n";
    2618. 

  2618. 		
    2619. 

  2619. 		// Table structure
    2620. 

  2620. 		// Comment in SQL-file
    2621. 

  2621. 		$sql .= "\n\n";
    2622. 

  2622. 		$sql .= "#\n";
    2623. 

  2623. 		$sql .= "# " . sprintf(__('Table structure of table %s','wassup'),$table) . "\n";
    2624. 

  2624. 		$sql .= "#\n";
    2625. 

  2625. 		$sql .= "\n";
    2626. 

  2626. 		$sql .= "#\n";
    2627. 

  2627. 		$sql .= "# Uncomment if you need\n";
    2628. 

  2628. 		
    2629. 

  2629. 		$create_table = $wpdb->get_results("SHOW CREATE TABLE $table", ARRAY_N);
    2630. 

  2630. 		if (FALSE === $create_table) {
    2631. 

  2631. 			$err_msg = sprintf(__('Error with SHOW CREATE TABLE for %s.','wassup'), $table);
    2632. 

  2632. 			print $err_msg;
    2633. 

  2633. 			$sql .= "#\n# $err_msg\n#\n";
    2634. 

  2634. 		}
    2635. 

  2635. 		$sql .= $create_table[0][1] . ' ;';
    2636. 

  2636. 		
    2637. 

  2637. 		if (FALSE === $table_structure) {
    2638. 

  2638. 			$err_msg = sprintf(__('Error getting table structure of %s','wassup'), $table);
    2639. 

  2639. 			print $err_msg;
    2640. 

  2640. 			$sql .= "#\n# $err_msg\n#\n";
    2641. 

  2641. 		}
    2642. 

  2642. 	
    2643. 

  2643. 		// Comment in SQL-file
    2644. 

  2644. 		$sql .= "\n\n";
    2645. 

  2645. 		$sql .= "#\n";
    2646. 

  2646. 		$sql .= '# ' . sprintf(__('Data contents of table %s','wassup'),$table) . "\n";
    2647. 

  2647. 		$sql .= "#\n";
    2648. 

  2648. 	}
    2649. 

  2649. 	
    2650. 

  2650. 	if(($segment == 'none') || ($segment >= 0)) {
    2651. 

  2651. 		$defs = array();
    2652. 

  2652. 		$ints = array();
    2653. 

  2653. 		foreach ($table_structure as $struct) {
    2654. 

  2654. 			if ( (0 === strpos($struct->Type, 'tinyint')) ||
    2655. 

  2655. 				(0 === strpos(strtolower($struct->Type), 'smallint')) ||
    2656. 

  2656. 				(0 === strpos(strtolower($struct->Type), 'mediumint')) ||
    2657. 

  2657. 				(0 === strpos(strtolower($struct->Type), 'int')) ||
    2658. 

  2658. 				(0 === strpos(strtolower($struct->Type), 'bigint')) ||
    2659. 

  2659. 				(0 === strpos(strtolower($struct->Type), 'timestamp')) ) {
    2660. 

  2660. 					$defs[strtolower($struct->Field)] = $struct->Default;
    2661. 

  2661. 					$ints[strtolower($struct->Field)] = "1";
    2662. 

  2662. 			}
    2663. 

  2663. 		}
    2664. 

  2664. 		
    2665. 

  2665. 		// Batch by $row_inc
    2666. 

  2666. 		
    2667. 

  2667. 		if($segment == 'none') {
    2668. 

  2668. 			$row_start = 0;
    2669. 

  2669. 			$row_inc = ROWS_PER_SEGMENT;
    2670. 

  2670. 		} else {
    2671. 

  2671. 			$row_start = $segment * ROWS_PER_SEGMENT;
    2672. 

  2672. 			$row_inc = ROWS_PER_SEGMENT;
    2673. 

  2673. 		}
    2674. 

  2674. 		
    2675. 

  2675. 		do {	
    2676. 

  2676. 			if ( !ini_get('safe_mode')) @set_time_limit(15*60);
    2677. 

  2677. 			$table_data = $wpdb->get_results("SELECT * FROM $table LIMIT {$row_start}, {$row_inc}", ARRAY_A);
    2678. 

  2678. 

  2679. 			$entries = 'INSERT INTO ' . $table . ' VALUES (';	
    2680. 

  2680. 			//    \x08\\x09, not required
    2681. 

  2681. 			$search = array("\x00", "\x0a", "\x0d", "\x1a");
    2682. 

  2682. 			$replace = array('\0', '\n', '\r', '\Z');
    2683. 

  2683. 			if($table_data) {
    2684. 

  2684. 				foreach ($table_data as $row) {
    2685. 

  2685. 					$values = array();
    2686. 

  2686. 					foreach ($row as $key => $value) {
    2687. 

  2687. 						if ($ints[strtolower($key)]) {
    2688. 

  2688. 							// make sure there are no blank spots in the insert syntax,
    2689. 

  2689. 							// yet try to avoid quotation marks around integers
    2690. 

  2690. 							$value = ( '' === $value) ? $defs[strtolower($key)] : $value;
    2691. 

  2691. 							$values[] = ( '' === $value ) ? "''" : $value;
    2692. 

  2692. 						} else {
    2693. 

  2693. 							$values[] = "'" . str_replace($search, $replace, addslashes($value)) . "'";
    2694. 

  2694. 						}
    2695. 

  2695. 					}
    2696. 

  2696. 					$sql .= " \n" . $entries . implode(', ', $values) . ') ;';
    2697. 

  2697. 				}
    2698. 

  2698. 				$row_start += $row_inc;
    2699. 

  2699. 			}
    2700. 

  2700. 		} while((count($table_data) > 0) and ($segment=='none'));
    2701. 

  2701. 	}
    2702. 

  2702. 	
    2703. 

  2703. 	if(($segment == 'none') || ($segment < 0)) {
    2704. 

  2704. 		// Create footer/closing comment in SQL-file
    2705. 

  2705. 		$sql .= "\n";
    2706. 

  2706. 		$sql .= "#\n";
    2707. 

  2707. 		$sql .= "# " . sprintf(__('End of data contents of table %s','wp-db-backup'),$table) . "\n";
    2708. 

  2708. 		$sql .= "# --------------------------------------------------------\n";
    2709. 

  2709. 		$sql .= "\n";
    2710. 

  2710. 	}
    2711. 

  2711. 	print $sql;
    2712. 

  2712. } // end backup_table()
    2713. 

  2713. 

  2714. // START initializing Widget
    2715. 

  2715. function wassup_widget_init() {
    2716. 

  2716. 

  2717.         if ( !function_exists('register_sidebar_widget') )
    2718. 

  2718.                 return;
    2719. 

  2719. 

  2720. function wassup_widget($wargs) {
    2721. 

  2721. 	global $wpdb;
    2722. 

  2722. 	extract($wargs);
    2723. 

  2723. 	$wassup_settings = get_option('wassup_settings');
    2724. 

  2724. 	$wpurl =  get_bloginfo('wpurl');
    2725. 

  2725. 	$siteurl =  get_bloginfo('siteurl');
    2726. 

  2726. 	if ($wassup_settings['wassup_widget_title'] != "") $title = $wassup_settings['wassup_widget_title']; else $title = "Visitors Online";
    2727. 

  2727. 	if ($wassup_settings['wassup_widget_ulclass'] != "") $ulclass = $wassup_settings['wassup_widget_ulclass']; else $ulclass = "links";
    2728. 

  2728. 	if ($wassup_settings['wassup_widget_chars'] != "") $chars = $wassup_settings['wassup_widget_chars']; else $chars = "18";
    2729. 

  2729. 	if ($wassup_settings['wassup_widget_searchlimit'] != "") $searchlimit = $wassup_settings['wassup_widget_searchlimit']; else $searchlimit = "5";
    2730. 

  2730. 	if ($wassup_settings['wassup_widget_reflimit'] != "") $reflimit = $wassup_settings['wassup_widget_reflimit']; else $reflimit = "5";
    2731. 

  2731. 	if ($wassup_settings['wassup_widget_topbrlimit'] != "") $topbrlimit = $wassup_settings['wassup_widget_topbrlimit']; else $topbrlimit = "5";
    2732. 

  2732. 	if ($wassup_settings['wassup_widget_toposlimit'] != "") $toposlimit = $wassup_settings['wassup_widget_toposlimit']; else $toposlimit = "5";
    2733. 

  2733. 	$table_name = $wpdb->prefix . "wassup";
    2734. 

  2734. 	$table_tmp_name = $wpdb->prefix . "wassup_tmp";
    2735. 

  2735. 	$to_date = wassup_get_time();
    2736. 

  2736. 	$from_date = strtotime('-3 minutes', $to_date);
    2737. 

  2737. 

  2738.         print $before_widget;
    2739. 

  2739. 

  2740. 	// Widget Latest Searches
    2741. 

  2741. 	if ($wassup_settings['wassup_widget_search'] == 1) {
    2742. 

  2742. 	$query_det = $wpdb->get_results("SELECT search, referrer FROM $table_tmp_name WHERE search!='' GROUP BY search ORDER BY `timestamp` DESC LIMIT ".attribute_escape($searchlimit)."");
    2743. 

  2743. 	if (count($query_det) > 0) {
    2744. 

  2744. 		print "$before_title ".__('Last searched terms','wassup')." $after_title";
    2745. 

  2745. 		print "<ul class='$ulclass'>";
    2746. 

  2746. 		foreach ($query_det as $sref) {
    2747. 

  2747. 			print "<li>- <a href='".attribute_escape($sref->referrer)."' target='_blank' rel='nofollow'>".stringShortener(attribute_escape($sref->search), $chars)."</a></li>";
    2748. 

  2748. 		}
    2749. 

  2749. 		print "</ul>";
    2750. 

  2750. 	}
    2751. 

  2751. 	}
    2752. 

  2752. 

  2753. 	// Widget Latest Referers
    2754. 

  2754. 	if ($wassup_settings['wassup_widget_ref'] == 1) {
    2755. 

  2755. 	$query_ref = $wpdb->get_results("SELECT referrer FROM $table_tmp_name WHERE searchengine='' AND referrer!='' AND referrer NOT LIKE '$wpurl%' GROUP BY referrer ORDER BY `timestamp` DESC LIMIT ".attribute_escape($reflimit)."");
    2756. 

  2756. 	if (count($query_ref) > 0) {
    2757. 

  2757. 		print "$before_title ".__('Last referers','wassup')." $after_title";
    2758. 

  2758. 		print "<ul class='$ulclass'>";
    2759. 

  2759. 		foreach ($query_ref as $eref) {
    2760. 

  2760. 			print "<li>- <a href='".attribute_escape($eref->referrer)."' target='_blank' rel='nofollow'>".stringShortener(eregi_replace("#https?://#", "", attribute_escape($eref->referrer)), $chars)."</a></li>";
    2761. 

  2761. 		}
    2762. 

  2762. 		print "</ul>";
    2763. 

  2763. 	}
    2764. 

  2764. 	}
    2765. 

  2765. 

  2766.         // Widget TOP Browsers
    2767. 

  2767.         if ($wassup_settings['wassup_widget_topbr'] == 1) {
    2768. 

  2768. 	$query_topbr = $wpdb->get_results("SELECT count(browser) as top_browser, browser FROM $table_name WHERE browser!='' AND browser NOT LIKE 'N/A%' GROUP BY browser ORDER BY top_browser DESC LIMIT ".attribute_escape($topbrlimit)."");
    2769. 

  2769.         if (count($query_topbr) > 0) {
    2770. 

  2770.                 print "$before_title ".__('Top Browsers','wassup')." $after_title";
    2771. 

  2771.                 print "<ul class='$ulclass'>";
    2772. 

  2772.                 foreach ($query_topbr as $etopbr) {
    2773. 

  2773.                         print "<li>- ".stringShortener($etopbr->browser, $chars)."</li>";
    2774. 

  2774.                 }
    2775. 

  2775.                 print "</ul>";
    2776. 

  2776.         }
    2777. 

  2777.         }
    2778. 

  2778. 

  2779.         // Widget TOP Oses
    2780. 

  2780.         if ($wassup_settings['wassup_widget_topos'] == 1) {
    2781. 

  2781. 	$query_topos = $wpdb->get_results("SELECT count(os) as top_os, os FROM $table_name WHERE os!='' AND os NOT LIKE 'N/A%' GROUP BY os ORDER BY top_os DESC LIMIT ".attribute_escape($toposlimit)."");
    2782. 

  2782.         if (count($query_topos) > 0) {
    2783. 

  2783.                 print "$before_title ".__('Top OS','wassup')." $after_title";
    2784. 

  2784.                 print "<ul class='$ulclass'>";
    2785. 

  2785.                 foreach ($query_topos as $etopos) {
    2786. 

  2786.                         print "<li>- ".stringShortener($etopos->os, $chars)."</li>";
    2787. 

  2787.                 }
    2788. 

  2788.                 print "</ul>";
    2789. 

  2789.         }
    2790. 

  2790.         }
    2791. 

  2791. 

  2792.         // Widget Visitors Online
    2793. 

  2793. 	$TotWid = New MainItems;
    2794. 

  2794. 	$TotWid->tableName = $table_tmp_name;
    2795. 

  2795. 	$TotWid->from_date = $from_date;
    2796. 

  2796. 	$TotWid->to_date = $to_date;
    2797. 

  2797. 

  2798. 	$currenttot = $TotWid->calc_tot("count", null, null, "DISTINCT");
    2799. 

  2799. 	$currentlogged = $TotWid->calc_tot("count", null, "AND  username!=''", "DISTINCT");
    2800. 

  2800. 	$currentauth = $TotWid->calc_tot("count", null, "AND  comment_author!='' AND username=''", "DISTINCT");
    2801. 

  2801. 

  2802.         print $before_title . $title . $after_title;
    2803. 

  2803.         print "<ul class='$ulclass'>";
    2804. 

  2804.         if ((int)$currenttot < 10) $currenttot = "0".$currenttot;
    2805. 

  2805.         print "<li><strong style='padding:0 4px 0 4px;background:#ddd;color:#777'>".$currenttot."</strong> ".__('visitor(s) online','wassup')."</li>";
    2806. 

  2806.         if ((int)$currentlogged > 0 AND $wassup_settings['wassup_widget_loggedin'] == 1) {
    2807. 

  2807.         if ((int)$currentlogged < 10) $currentlogged = "0".$currentlogged;
    2808. 

  2808.                 print "<li><strong style='padding:0 4px 0 4px;background:#e7f1c8;color:#777'>".$currentlogged."</strong> ".__('logged-in user(s)','wassup')."</li>";
    2809. 

  2809.         }
    2810. 

  2810.         if ((int)$currentauth > 0 AND $wassup_settings['wassup_widget_comauth'] == 1) {
    2811. 

  2811.         if ((int)$currentauth < 10) $currentauth = "0".$currentauth;
    2812. 

  2812.                 print "<li><strong style='padding:0 4px 0 4px;background:#fbf9d3;color:#777'>".$currentauth."</strong> ".__('comment author(s)','wassup')."</li>";
    2813. 

  2813. 	}
    2814. 

  2814. 	print "<li style='font-size:6pt; color:#bbb;'>".__("powered by", "wassup")." <a style='color:#777;' href='http://www.wpwp.org' title='WassUp - Real Time Visitors Tracking'>WassUp</a></li>";
    2815. 

  2815. 	print "</ul>";
    2816. 

  2816. 	print $after_widget;
    2817. 

  2817. } //end function wassup_widget
    2818. 

  2818. 

  2819. function wassup_widget_control() {
    2820. 

  2820. 	//global $_POST;
    2821. 

  2821. 	$wassup_settings = get_option('wassup_settings');
    2822. 

  2822. 	
    2823. 

  2823. 	if (isset($_POST['wassup-submit'])) {
    2824. 

  2824. 		$wassup_settings['wassup_widget_title'] = $_POST['wassup_widget_title'];
    2825. 

  2825. 		$wassup_settings['wassup_widget_ulclass'] = $_POST['wassup_widget_ulclass'];
    2826. 

  2826. 		$wassup_settings['wassup_widget_chars'] = $_POST['wassup_widget_chars'];
    2827. 

  2827. 		$wassup_settings['wassup_widget_loggedin'] = $_POST['wassup_widget_loggedin'];
    2828. 

  2828. 		$wassup_settings['wassup_widget_comauth'] = $_POST['wassup_widget_comauth'];
    2829. 

  2829. 		$wassup_settings['wassup_widget_search'] = $_POST['wassup_widget_search'];
    2830. 

  2830. 		$wassup_settings['wassup_widget_searchlimit'] = $_POST['wassup_widget_searchlimit'];
    2831. 

  2831. 		$wassup_settings['wassup_widget_ref'] = $_POST['wassup_widget_ref'];
    2832. 

  2832. 		$wassup_settings['wassup_widget_reflimit'] = $_POST['wassup_widget_reflimit'];
    2833. 

  2833. 		$wassup_settings['wassup_widget_topbr'] = $_POST['wassup_widget_topbr'];
    2834. 

  2834. 		$wassup_settings['wassup_widget_topbrlimit'] = $_POST['wassup_widget_topbrlimit'];
    2835. 

  2835. 		$wassup_settings['wassup_widget_topos'] = $_POST['wassup_widget_topos'];
    2836. 

  2836. 		$wassup_settings['wassup_widget_toposlimit'] = $_POST['wassup_widget_toposlimit'];
    2837. 

  2837. 		
    2838. 

  2838. 		update_option('wassup_settings', $wassup_settings);
    2839. 

  2839. 		$wassup_settings = get_option('wassup_settings');
    2840. 

  2840. 	}
    2841. 

  2841. 	
    2842. 

  2842. 	?>
    2843. 

  2843. 	<div class="wrap" style="text-align:left">
    2844. 

  2844.         <h3>Wassup Widget</h3>
    2845. 

  2845.         <p style="text-align:left"><input type="text" name="wassup_widget_title" size="20" value="<?php echo $wassup_settings['wassup_widget_title'] ?>" /> <?php _e("What title for the widget (default \"Visitors Online\")", "wassup") ?></p>
    2846. 

  2846.         <p style="text-align:left"><input type="text" name="wassup_widget_ulclass" size="3" value="<?php echo $wassup_settings['wassup_widget_ulclass'] ?>" /> <?php _e("What style sheet class for &lt;ul&gt; attribute (default \"links\")", "wassup") ?></p>
    2847. 

  2847.         <p style="text-align:left"><input type="text" name="wassup_widget_chars" size="3" value="<?php echo $wassup_settings['wassup_widget_chars'] ?>" /> <?php _e("How many characters left? (For template compatibility - default 18)", "wassup") ?></p>
    2848. 

  2848.         <p style="text-align:left"><input type="checkbox" name="wassup_widget_loggedin" value="1"<?php if ($wassup_settings['wassup_widget_loggedin'] == 1) echo "CHECKED"; ?> /> <?php _e("Check if you want to show logged-in online users (default Yes)", "wassup") ?></p>
    2849. 

  2849.         <p style="text-align:left"><input type="checkbox" name="wassup_widget_comauth" value="1" <?php if ($wassup_settings['wassup_widget_comauth'] == 1) echo "CHECKED"; ?> /> <?php _e("Check if you want to show comment-author online users (default Yes)", "wassup") ?></p>
    2850. 

  2850.         <p style="text-align:left"><input type="checkbox" name="wassup_widget_search" value="1" <?php if ($wassup_settings['wassup_widget_search'] == 1) echo "CHECKED"; ?> /> <?php _e("Check if you want to show some last search referers (default Yes)", "wassup") ?></p>
    2851. 

  2851.         <p style="text-align:left"><input type="text" name="wassup_widget_searchlimit" size="3" value="<?php echo $wassup_settings['wassup_widget_searchlimit'] ?>" /> <?php _e("How many search referers want to show (default 5)", "wassup") ?></p>
    2852. 

  2852.         <p style="text-align:left"><input type="checkbox" name="wassup_widget_ref" value="1" <?php if ($wassup_settings['wassup_widget_ref'] == 1) echo "CHECKED"; ?> /> <?php _e("Check if you want to show some last external referers (default Yes)", "wassup") ?></p>
    2853. 

  2853.         <p style="text-align:left"><input type="text" name="wassup_widget_reflimit" size="3" value="<?php echo $wassup_settings['wassup_widget_reflimit'] ?>" /> <?php _e("How many external referers want to show (default 5)", "wassup") ?></p>
    2854. 

  2854.         <p style="text-align:left"><input type="checkbox" name="wassup_widget_topbr" value="1" <?php if ($wassup_settings['wassup_widget_topbr'] == 1) echo "CHECKED"; ?> /> <?php _e("Check if you want to show top browsers (default No - enabling it could slow down blog)", "wassup") ?></p>
    2855. 

  2855.         <p style="text-align:left"><input type="text" name="wassup_widget_topbrlimit" size="3" value="<?php echo $wassup_settings['wassup_widget_topbrlimit'] ?>" /> <?php _e("How many top browsers want to show (default 5)", "wassup") ?></p>
    2856. 

  2856.         <p style="text-align:left"><input type="checkbox" name="wassup_widget_topos" value="1" <?php if ($wassup_settings['wassup_widget_topos'] == 1) echo "CHECKED"; ?> /> <?php _e("Check if you want to show top operating systems (default No - enabling it could slow down blog)", "wassup") ?></p>
    2857. 

  2857.         <p style="text-align:left"><input type="text" name="wassup_widget_toposlimit" size="3" value="<?php echo $wassup_settings['wassup_widget_toposlimit'] ?>" /> <?php _e("How many top operating systems want to show (default 5)", "wassup") ?></p>
    2858. 

  2858.         <p style="text-align:left"><input type="hidden" name="wassup-submit" id="wassup-submit" value="1" /></p>
    2859. 

  2859.         </div>
    2860. 

  2860. 	<?php
    2861. 

  2861. } //end function wassup_widget_control
    2862. 

  2862. 

  2863. 	$wassup_settings = get_option('wassup_settings');
    2864. 

  2864. 	if ($wassup_settings['wassup_userlevel'] == "") {
    2865. 

  2865. 		if ($wassup_settings['wassup_userlevel'] == "") {
    2866. 

  2866. 			$wassup_settings['wassup_userlevel'] = 8;
    2867. 

  2867. 			update_option('wassup_settings', $wassup_settings);
    2868. 

  2868. 	}
    2869. 

  2869. 	if ($wassup_settings['wassup_refresh'] == "") {
    2870. 

  2870. 			$wassup_settings['wassup_refresh'] = 3;
    2871. 

  2871. 			update_option('wassup_settings', $wassup_settings);
    2872. 

  2872. 		}
    2873. 

  2873. 	}
    2874. 

  2874. 		if(function_exists('register_sidebar_widget')) {
    2875. 

  2875. 			register_sidebar_widget(__('Wassup Widget'), 'wassup_widget'); 
    2876. 

  2876. 			register_widget_control(array('Wassup Widget', 'widgets'), 'wassup_widget_control', 600, 540);
    2877. 

  2877. 		}
    2878. 

  2878. } //end function wassup_widgit_init
    2879. 

  2879. 

  2880. function wassup_sidebar($before_widget='', $after_widget='', $before_title='', $after_title='', $wtitle='', $wulclass='', $wchars='', $wsearch='', $wsearchlimit='', $wref='', $wreflimit='', $wtopbr='', $wtopbrlimit='', $wtopos='', $wtoposlimit='') {
    2881. 

  2881. 	global $wpdb;
    2882. 

  2882. 	$wpurl =  get_bloginfo('wpurl');
    2883. 

  2883. 	$siteurl =  get_bloginfo('siteurl');
    2884. 

  2884. 	if ($wtitle != "") $title = $wtitle; else $title = "Visitors Online";
    2885. 

  2885. 	if ($wulclass != "") $ulclass = $wulclass; else $ulclass = "links";
    2886. 

  2886. 	if ($wchars != "") $chars = $wchars; else $chars = "18";
    2887. 

  2887. 	if ($wsearchlimit != "") $searchlimit = $wsearchlimit; else $searchlimit = "5";
    2888. 

  2888. 	if ($wreflimit != "") $reflimit = $wreflimit; else $reflimit = "5";
    2889. 

  2889. 	if ($wtopbrlimit != "") $topbrlimit = $wtopbrlimit; else $topbrlimit = "5";
    2890. 

  2890. 	if ($wtoposlimit != "") $toposlimit = $wtoposlimit; else $toposlimit = "5";
    2891. 

  2891. 	$table_name = $wpdb->prefix . "wassup";
    2892. 

  2892. 	$table_tmp_name = $wpdb->prefix . "wassup_tmp";
    2893. 

  2893. 	$to_date = wassup_get_time();
    2894. 

  2894. 	$from_date = strtotime('-3 minutes', $to_date);
    2895. 

  2895. 

  2896.         print $before_widget;
    2897. 

  2897. 	if ($wsearch == 1) {
    2898. 

  2898. 	$query_det = $wpdb->get_results("SELECT search, referrer FROM $table_tmp_name WHERE search!='' GROUP BY search ORDER BY `timestamp` DESC LIMIT $searchlimit");
    2899. 

  2899. 	if (count($query_det) > 0) {
    2900. 

  2900. 		print "$before_title Last searched terms $after_title";
    2901. 

  2901. 		print "<ul class='$ulclass'>";
    2902. 

  2902. 		foreach ($query_det as $sref) {
    2903. 

  2903. 			print "<li>- <a href='".attribute_escape($sref->referrer)."' target='_blank' rel='nofollow'>".stringShortener(attribute_escape($sref->search), $chars)."</a></li>";
    2904. 

  2904. 		}
    2905. 

  2905. 		print "</ul>";
    2906. 

  2906. 	}
    2907. 

  2907. 	}
    2908. 

  2908. 

  2909. 	if ($wref == 1) {
    2910. 

  2910. 	$query_ref = $wpdb->get_results("SELECT referrer FROM $table_tmp_name WHERE searchengine='' AND referrer!='' AND referrer NOT LIKE '$wpurl%' GROUP BY referrer ORDER BY `timestamp` DESC LIMIT $reflimit");
    2911. 

  2911. 	if (count($query_ref) > 0) {
    2912. 

  2912. 		print "$before_title Last referers $after_title";
    2913. 

  2913. 		print "<ul class='$ulclass'>";
    2914. 

  2914. 		foreach ($query_ref as $eref) {
    2915. 

  2915. 			print "<li>- <a href='".attribute_escape($eref->referrer)."' target='_blank' rel='nofollow'>".stringShortener(preg_replace("#https?://#", "", attribute_escape($eref->referrer)), $chars)."</a></li>";
    2916. 

  2916. 		}
    2917. 

  2917. 		print "</ul>";
    2918. 

  2918. 	}
    2919. 

  2919. 	}
    2920. 

  2920. 

  2921. 	if ($wtopbr == 1) {
    2922. 

  2922. 	$query_topbr = $wpdb->get_results("SELECT count(browser) as top_browser, browser FROM $table_name WHERE browser!='' AND browser NOT LIKE 'N/A%' GROUP BY browser ORDER BY top_browser DESC LIMIT $topbrlimit");
    2923. 

  2923. 	if (count($query_topbr) > 0) {
    2924. 

  2924. 		print "$before_title Top Browsers $after_title";
    2925. 

  2925. 		print "<ul class='$ulclass'>";
    2926. 

  2926. 		foreach ($query_topbr as $etopbr) {
    2927. 

  2927. 			print "<li>- ".stringShortener(attribute_escape($etopbr->browser), $chars)."</li>";
    2928. 

  2928. 		}
    2929. 

  2929. 		print "</ul>";
    2930. 

  2930. 	}
    2931. 

  2931. 	}
    2932. 

  2932. 

  2933. 	if ($wtopos == 1) {
    2934. 

  2934. 	$query_topos = $wpdb->get_results("SELECT count(os) as top_os, os FROM $table_name WHERE os!='' AND os NOT LIKE 'N/A%' GROUP BY os ORDER BY top_os DESC LIMIT $toposlimit");
    2935. 

  2935. 	if (count($query_topos) > 0) {
    2936. 

  2936. 		print "$before_title Top OS $after_title";
    2937. 

  2937. 		print "<ul class='$ulclass'>";
    2938. 

  2938. 		foreach ($query_topos as $etopos) {
    2939. 

  2939. 			print "<li>- ".stringShortener(attribute_escape($etopos->os), $chars)."</li>";
    2940. 

  2940. 		}
    2941. 

  2941. 		print "</ul>";
    2942. 

  2942. 	}
    2943. 

  2943. 	}
    2944. 

  2944. 

  2945. 	$TotWid = New MainItems;
    2946. 

  2946. 	$TotWid->tableName = $table_tmp_name;
    2947. 

  2947. 	$TotWid->from_date = $from_date;
    2948. 

  2948. 	$TotWid->to_date = $to_date;
    2949. 

  2949. 

  2950. 	$currenttot = $TotWid->calc_tot("count", null, null, "DISTINCT");
    2951. 

  2951. 	$currentlogged = $TotWid->calc_tot("count", null, "AND  username!=''", "DISTINCT");
    2952. 

  2952. 	$currentauth = $TotWid->calc_tot("count", null, "AND  comment_author!=''' AND username=''", "DISTINCT");
    2953. 

  2953. 

  2954. 	print $before_title . $title . $after_title;
    2955. 

  2955. 	print "<ul class='$ulclass'>";
    2956. 

  2956. 	if ((int)$currenttot < 10) $currenttot = "0".$currenttot;
    2957. 

  2957. 	print "<li><strong style='padding:0 4px 0 4px;background:#ddd;color:#777'>".$currenttot."</strong> visitor(s) online</li>";
    2958. 

  2958. 	if ((int)$currentlogged > 0 AND $wassup_settings['wassup_widget_loggedin'] == 1) {
    2959. 

  2959. 	if ((int)$currentlogged < 10) $currentlogged = "0".$currentlogged;
    2960. 

  2960. 		print "<li><strong style='padding:0 4px 0 4px;background:#e7f1c8;color:#777'>".$currentlogged."</strong> logged-in user(s)</li>";
    2961. 

  2961. 	}
    2962. 

  2962. 	if ((int)$currentauth > 0 AND $wassup_settings['wassup_widget_comauth'] == 1) {
    2963. 

  2963. 

  2964. 	if ((int)$currentauth < 10) $currentauth = "0".$currentauth;
    2965. 

  2965. 		print "<li><strong style='padding:0 4px 0 4px;background:#fbf9d3;color:#777'>".$currentauth."</strong> comment author(s)</li>";
    2966. 

  2966. 	}
    2967. 

  2967. 	print "<li style='font-size:6pt; color:#bbb;'>".__("powered by", "wassup")." <a style='color:#777;' href='http://www.wpwp.org/' title='WassUp - Real Time Visitors Tracking'>WassUp</a></li>";
    2968. 

  2968. 	print "</ul>";
    2969. 

  2969. 	print $after_widget;
    2970. 

  2970. } //end function wassup_sidebar
    2971. 

  2971. 

  2972. //### Add hooks after functions have been defined 
    2973. 

  2973. //## General hooks
    2974. 

  2974. add_action('init', 'wassup_init');
    2975. 

  2975. add_action("widgets_init", "wassup_widget_init");
    2976. 

  2976. 

  2977. //## Wassup Admin filters
    2978. 

  2978. register_activation_hook(__FILE__, 'wassup_install');
    2979. 

  2979. register_deactivation_hook(__FILE__, 'wassup_uninstall');
    2980. 

  2980. //add hooks for wassup admin header functions
    2981. 

  2981. add_action('admin_head', 'add_wassup_css');
    2982. 

  2982. add_action('admin_menu', 'wassup_add_pages');
    2983. 

  2983. add_action('activity_box_end', 'wassupDashChart');
    2984. 

  2984. 

  2985. //## Wassup visitor tracking hooks
    2986. 

  2986. //record visit after page is displayed to keep page load fast
    2987. 

  2987. add_action('shutdown', 'wassupAppend');
    2988. 

  2988. //add_action('send_headers', 'wassupAppend'); //slows down page load
    2989. 

  2989. add_action('wp_head', 'add_wassup_meta_info');
    2990. 

  2990. ?>
    2991. 

  2991.