<?php
/*
 Plugin Name: Counterize II
 Plugin URI: http://www.navision-blog.de/counterize
 Description: Simple counter-plugin with no external libs - saves timestamp, visited URl, referring URl and browserinformation in database, and can display total hits, unique hits and other statistics in WordPress webpages. Admin-interface available with detailed information...
 Version: 2.14.1
 Author: Steffen Forkmann
 Author URI: http://navision-blog.de
*/

/*
 New in 2.14.1
 - German translation corrected (thanks to Johannes Parb)
 New in 2.14.0
 - Dashboard for WP 2.5  
 New in 2.13.0
 - no more ip-logging (this is illegal in some countries e.g. Germany)  
    counterize stores only a small hash to distingiush between two users
    and to get information about the user count 
 New in 2.12.7
 - logging postID for later analysis (thanks to Alfred likemind.co.uk)  
 New in 2.12.6
 - counterize_get_online_users() fixed (thanks to Robbix wombat-tour.de)
 New in 2.12.4  
 - 2 new functions (thanks to KnickerBlogger.net)
 New in 2.12.3
 - fixed installtion
 New in 2.12.1 /n 2.12.2
 - fixed folder
 New in 2.12
 - lots of sql fixing (thanks to Eric blogs.jobdig.com/wwds)
 New in 2.11
 - XHTML valid (thanks to Julia http://julialoeba.de)
 - Japanese version (thanks to Urepko http://wppluginsj.sourceforge.jp/)
 - exclude new bots (thanks to lacroa.altervista.org - Emanuele)
 - Exclude if referer is the same as url (thanks to lacroa.altervista.org - Emanuele)
 - GeoIpTool with new URL geoiptool.com/en/ ==> geoiptool.com/ (thanks to lacroa.altervista.org - Emanuele)
 - Mass-Deletion (thanks to lacroa.altervista.org - Emanuele)
 - Bot Yandex added
 - Spanish translation (thanks to Sandra)
 - Database-flush deletes all keywords
 New in 2.10
 - Italian version (thanks to Emanuele)
 - Russian version (thanks to Ivan http://shadow-blub.livejournal.com/)
 - Small installation bugfixes (thanks to Thorsten http://www.siteartwork.de/)
 New in 2.08
 - %-Bug fixed (% in graphs on new line)
 - max-Width in Settings (width-fix for firefox)
 - users online
 - browser icons
 - operating systems
 New in 2.06
 - Minor compatibility bugfixes for Wordpress 2.2
 New in 2.05
 - small Bugfixes
 - All TableNames replaced with function calls
 - LocalizationFramework used
 - DayOfWeek-Bug fixed
 - display only EXTERNAL referers (Thanks to eric)
 - extremly speed up sql queries
 - stats moved back to Manage-Page (only for admins visible)
 - colors in all stats
 - separate statistics page for blog entries
 - Microsoft URL Control-bot excluded
 New in 2.04
 Features:
 - custom whois-server
 - moved all files to own folder
 - separate settings/admin page
 - stats moved to doashboard-subpage
 - ref-analyzer (http://nopaste.easy-coding.de/?id=146) for keywords
 - keyword-stats (alpha)
 BugFixes:
 - mysql-version independent table structure
 - don't show stats, when db is empty (DivByZero)

 New in 2.03
 - Installprocess for mysql version 4
 - Filter and MapView for most visited ips

 New in 2.02
 - BugFix - UserAgent

 New in 2.01
 - New Author: Steffen Forkmann
 - New Table Structure (saves a lot of space and mostly time)
 - Redesigning some functions

 New in 0.53
 - By mistake (during test) commented out the exclude-function. Once again re-enabled.
 - Added the feature "top referers" in the admin-interface
 - Added the feature to manually select amount to show in the bar-graphs, instead of default 15
 - Minor stuff, changed text, thicker bars in graphs, now "unique hits last 7 days" also shown in admin-interface,

 New in 0.52
 - More bots
 - New function called counterize_getuniquelatest7days() (Curtis)
 - Exclusion of most common images and RSS feeds (SHRIKEE)
 - Don't use the now() insert call when inserting entries. Use gmdate() instead
*/


if(function_exists('load_plugin_textdomain'))
  load_plugin_textdomain('counterize','wp-content/plugins/counterizeii');

include("browsniff.php");

# Counterize II-Tables
function counterize_agentsTable()
{
	return $GLOBALS['table_prefix'] . "Counterize_UserAgents";
}

function counterize_logTable()
{
	return $GLOBALS['table_prefix'] . "Counterize";
}

function counterize_pageTable()
{
	return $GLOBALS['table_prefix'] . "Counterize_Pages";
}

function counterize_refererTable()
{
	return $GLOBALS['table_prefix'] . "Counterize_Referers";
}

function counterize_keywordTable()
{
	return $GLOBALS['table_prefix'] . "Counterize_Keywords";
}

function counterize_update_all_userAgents()
{
	$wpdb =& $GLOBALS['wpdb'];
	$agents = $wpdb->get_results("Select * from `".counterize_agentsTable()."`");
	foreach ($agents as $agent)
	{
		list(
		$browser_name, $browser_code, $browser_ver, $os_name, $os_code, $os_ver,
		$pda_name, $pda_code, $pda_ver ) = counterize_detect_browser($agent->name);

		$wpdb->query("update ".counterize_agentsTable()." set "
		. " browserName = '".$wpdb->escape($browser_name)."', "
		. " browserCode = '".$wpdb->escape($browser_code)."', "
		. " browserVersion = '".$wpdb->escape($browser_ver)."', "
		. " osName = '".$wpdb->escape($os_name)."', "
		. " osCode = '".$wpdb->escape($os_code)."', "
		. " osVersion = '".$wpdb->escape($os_ver)."' "
		. "where agentID=".$agent->agentID);
	}
}

# get the major release number of the installed mysql-version
function mysqlMajorRelease()
{
	$version = explode(".",mysql_get_client_info());
	return $version[0];
}

# Returns how many entries there are in the DB.
function counterize_getamount($only_this_month = false)
{
	$sql = 'SELECT COUNT(1) FROM ' . counterize_logTable();
	if($only_this_month)
  		$sql .= " where timestamp >= '".date("Y-m-01")."'";
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}

function counterize_getkeywordamount()
{
	$sql = "SELECT sum(count) FROM " . counterize_keywordTable() . " where keywordID <> 1";
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}

# Return how many unique entries there are in the DB.
function counterize_getuniqueamount()
{
	$sql = 'SELECT count(DISTINCT IP) FROM ' . counterize_logTable();
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}

// deletes a entry from the database
function counterize_killEntry($entryID)
{
	$entries = counterize_getentries(1,$entryID);

	$wpdb =& $GLOBALS['wpdb'];
	foreach($entries as $entry)
	{
		$sql = "DELETE FROM ".counterize_logTable()." WHERE ID=$entry->id";
		$num = $wpdb->query($sql);

		$sql = "UPDATE ".counterize_pageTable()." set count = count - 1 WHERE pageID=$entry->pageID";
		$num = $wpdb->query($sql);

		$sql = "UPDATE ".counterize_refererTable()." set count = count - 1 WHERE refererID=$entry->refererID";
		$num = $wpdb->query($sql);

		$sql = "UPDATE ".counterize_agentsTable()." set count = count - 1 WHERE agentID=$entry->agentID";
		$num = $wpdb->query($sql);

		$sql = "UPDATE ".counterize_keywordTable()." set count = count - 1 WHERE keywordID=$entry->keywordID";
		$num = $wpdb->query($sql);
	}
}

// flushes the db - be careful
function counterize_flush()
{
	$wpdb =& $GLOBALS['wpdb'];
	$sql = 'DELETE FROM '.counterize_logTable();
	$num = $wpdb->query($sql);

	$sql = 'DELETE FROM '.counterize_pageTable();
	$num = $wpdb->query($sql);

	$sql = 'DELETE FROM '.counterize_agentsTable();
	$num = $wpdb->query($sql);

	$sql = 'DELETE FROM '.counterize_refererTable();
	$num = $wpdb->query($sql);

	$sql = 'DELETE FROM '.counterize_keywordTable();
	$num = $wpdb->query($sql);
}

# Returns amount of hits today.
function counterize_gethitstoday()
{
	$today = date("Y-m-d");
	$sql = "SELECT COUNT(1) FROM ".counterize_logTable()." WHERE timestamp >= '$today'";
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}

# Returns amount of hits during the last 7 days.
function counterize_getlatest7days()
{
	$sevendaysago = date("Y-m-d", time()-86400*7);
	$sql = "SELECT COUNT(1) FROM ".counterize_logTable()." WHERE timestamp >= '$sevendaysago'";
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}

# From Curtis(http://www.graymattersonline.net/)
# Returns amount of unique IP's in the last 7 days
function counterize_getuniquelatest7days()
{
	$sevendaysago = date("Y-m-d", time()-86400*7);
	$sql = "SELECT count(DISTINCT IP) FROM ".counterize_logTable()." WHERE timestamp >= '$sevendaysago'";
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}

function counterize_get_online_users()
{
  $timestamp = gmdate("Y-m-d H:i:s",time() + (get_option('gmt_offset') * 60 * 60 ));
  $sql = "SELECT count(DISTINCT IP) FROM ".counterize_logTable()." WHERE timestamp > DATE_SUB('$timestamp', INTERVAL 5 MINUTE)";	
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}

# Returns amount of unique referer-URl's
function counterize_getuniquereferers()
{
	$sql = 'SELECT count(DISTINCT refererID) FROM '.counterize_logTable();
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}

# Returns amount of unique browser-strings in DB.
function counterize_getuniquebrowsers()
{
	$sql = 'SELECT count(1) FROM '. counterize_agentsTable();
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}

# Returns amount on current article
function counterize_getHitsOnCurrentArticle()
{
	$wpdb =& $GLOBALS['wpdb'];
	if ($_SERVER['REQUEST_URI']){
		$requesturl = $wpdb->escape($_SERVER['REQUEST_URI']);
		$sql = "SELECT Count FROM ". counterize_pageTable() ." WHERE url = '$requesturl'";
		return $wpdb->get_var($sql);
	}
	return 0;
}

# Returns amount of unique URl's
function counterize_getuniqueurl()
{
	$sql = 'SELECT count(1) FROM ' .counterize_refererTable();
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}

function counterize_return_first_hit($dateformat = "j/n-Y")
{
	$sql = "SELECT MIN(timestamp) from ".counterize_logTable();
	$wpdb =& $GLOBALS['wpdb'];
	$t = $wpdb->get_var($sql);
	return date($dateformat, strtotime($t));
}

# show the most visited pages
function counterize_most_visited_pages($number = 10, $width = 300)
{
	$wpdb =& $GLOBALS['wpdb'];
	$number = $wpdb->escape($number);
	$sql = "SELECT count as amount , url as url, url as label FROM ".counterize_pageTable()." ORDER BY amount DESC LIMIT $number";
	$rows = $wpdb->get_results($sql);

	counterize_renderstats_vertical($rows, __('Page','counterize'), $width, false);
}

function counterize_most_visited_pages24hrs($number = 10, $width = 300)
{
  $onedayago = date("Y-m-d", time()-86400);
  $wpdb =& $GLOBALS['wpdb'];
  $sql = "SELECT count as amount, p.url as url, p.url as label "
  . " FROM " .counterize_logTable(). " m, " . counterize_pageTable(). " p "
  . " WHERE m.pageID = p.pageID and "
  . " m.timestamp >= '$onedayago'"
  . " GROUP BY p.url "
  . " ORDER BY count DESC LIMIT $number";
  $rows = $wpdb->get_results($sql);
  
  counterize_renderstats_vertical($rows, __('Referer','counterize'), $width);
}

function counterize_most_visited_referrers24hrs($number = 10, $width = 300)
{
  $onedayago = date("Y-m-d", time()-86400);
  $wpdb =& $GLOBALS['wpdb'];
  $sql = "SELECT count as amount, r.name as label, r.name as url "
  . " FROM ".counterize_logTable(). " m, ". counterize_refererTable(). " r "
  . " WHERE m.refererID = r.refererID and "
  . " r.name 'unknown' and "
  . " r.name NOT LIKE '" . $wpdb->escape(get_option("home")) . "%%' "
  . " and r.name NOT LIKE '" . $wpdb->escape(get_option("siteurl")) . "%%' "
  . " and m.timestamp >= '$onedayago'"
  . " GROUP BY r.name "
  . " ORDER BY count DESC LIMIT $number";
  $rows = $wpdb->get_results($sql);
  
  counterize_renderstats_vertical($rows, __('Referer','counterize'), $width);
}


# New in 0.53
function counterize_most_visited_referrers($number = 10, $width = 300)
{
	$wpdb =& $GLOBALS['wpdb'];
	$sql = "SELECT count as amount, name as label, name as url FROM ".counterize_refererTable()." WHERE "
	. " name <> 'unknown' and "
	. " name NOT LIKE '" . $wpdb->escape(get_option("home")) . "%%' "
	. " and name NOT LIKE '" . $wpdb->escape(get_option("siteurl")) . "%%' "
	. " ORDER BY count DESC LIMIT $number";
	$rows = $wpdb->get_results($sql);

	counterize_renderstats_vertical($rows, __('Referer','counterize'), $width);
}


function counterize_most_searched_keywords($number = 10, $width = 300)
{
	$wpdb =& $GLOBALS['wpdb'];
	$number = $wpdb->escape($number);
	$sql = "SELECT count as amount, keyword as label FROM " . counterize_keywordTable() ." where keywordID <> 1 GROUP BY keyword ORDER BY count DESC LIMIT $number";
	$rows = $wpdb->get_results($sql);

	counterize_renderstats_vertical($rows, __('Keyword','counterize'), $width);
}

function counterize_most_searched_keywords_today($number = 10, $width = 300)
{
	$wpdb =& $GLOBALS['wpdb'];
	$today = date("Y-m-d");	
	$number = $wpdb->escape($number);
	$sql = "SELECT count(1) as amount, k.keyword as label FROM " . counterize_keywordTable() . " k "
	  .", " . counterize_logTable() . " l, " . counterize_refererTable() . " r "
	  . " where r.refererID = l.refererID and r.keywordID = k.keywordID "
    ." and k.keywordID <> 1  and l.timestamp >= '$today' GROUP BY k.keyword ORDER BY amount DESC LIMIT $number";

	$rows = $wpdb->get_results($sql);

	counterize_renderstats_vertical($rows, __('Keyword','counterize'), $width);
}

function counterize_most_used_browsers_without_version($number = 10, $width = 300)
{
	$wpdb =& $GLOBALS['wpdb'];
	$number = $wpdb->escape($number);
	$sql = "SELECT sum(count) as amount, browserName as label, browserCode FROM ".counterize_agentsTable()
	." group by label "
	." ORDER BY amount DESC LIMIT $number";
	$rows = $wpdb->get_results($sql);

	reset($rows);
	while (list($i, $r) = each($rows)) {
		$row =& $rows[$i];
		if($row->label == " " || $row->label == "")
		$row->label = __("unknown","counterize");
		else
		$row->label = counterize_get_image_url ($row->browserCode, $row->label) . " ". $row->label;
	}

	counterize_renderstats_vertical($rows, __('UserAgent','counterize'), $width, true, "100%", false);
}

function counterize_most_used_browsers($number = 10, $width = 300)
{
	$wpdb =& $GLOBALS['wpdb'];
	$number = $wpdb->escape($number);
	$sql = "SELECT sum(count) as amount, concat(concat(browserName,' '),browserVersion) as label, browserCode FROM ".counterize_agentsTable()
	." group by label "
	." ORDER BY amount DESC LIMIT $number";
	$rows = $wpdb->get_results($sql);

	reset($rows);
	while (list($i, $r) = each($rows)) {
		$row =& $rows[$i];
		if($row->label == " " || $row->label == "")
		$row->label = __("unknown","counterize");
		else
		$row->label = counterize_get_image_url ($row->browserCode, $row->label) . " ". $row->label;
	}

	counterize_renderstats_vertical($rows, __('UserAgent','counterize'), $width, true, "100%", false);
}

function counterize_most_used_os($number = 10, $width = 300)
{
	$wpdb =& $GLOBALS['wpdb'];
	$number = $wpdb->escape($number);
	$sql = "SELECT sum(count) as amount, concat(concat(osName,' '),osVersion) as label, osCode FROM ".counterize_agentsTable()
	." group by label "
	." ORDER BY amount DESC LIMIT $number";
	$rows = $wpdb->get_results($sql);

	reset($rows);
	while (list($i, $r) = each($rows)) {
		$row =& $rows[$i];
		if($row->label == " " || $row->label == "")
		$row->label = __("unknown","counterize");
		else
		$row->label = counterize_get_image_url ($row->osCode, $row->label) . " ". $row->label;
	}

	counterize_renderstats_vertical($rows, __('Operating System','counterize'), $width, true, "100%", false);
}

function counterize_getdailystats($only_this_month = false)
{
	$wpdb =& $GLOBALS['wpdb'];

	$sql = "SELECT
    dayofmonth(timestamp) as label,
    COUNT(1) as amount
    FROM " . counterize_logTable();

	if($only_this_month)
		$sql .= " where timestamp >= '".date("Y-m-01")."'";
	$sql .= " group by label";
	return $wpdb->get_results($sql);
}

function counterize_getmonthlystats()
{
	$wpdb =& $GLOBALS['wpdb'];
	$sql = "SELECT
    concat(concat(substring(monthname(timestamp),1,3),' '),substring(year(timestamp),3,2)) as label,
    COUNT(1) as amount,
    month(timestamp) as m,
    year(timestamp) as y
    FROM " . counterize_logTable() .
	" group by label order by y,m";
	return $wpdb->get_results($sql);
}

function counterize_getweeklystats()
{
	$wpdb =& $GLOBALS['wpdb'];
	$sql = "SELECT
    dayname(timestamp) as label,
    COUNT(1) as amount,
    dayofweek(timestamp) as day
    FROM " . counterize_logTable() .
	" group by label order by day";
	return $wpdb->get_results($sql);
}

# This is function is still not done - needs more work...
function counterize_gethourlystats($hour = "undef", $type = both)
{
	$wpdb =& $GLOBALS['wpdb'];

	$sql = "SELECT
    hour(timestamp) as label,
    COUNT(1) as amount
    FROM " . counterize_logTable();

	$sql .= " group by label";
	return $wpdb->get_results($sql);
}

function counterize_ref_analyzer($referer)
{
	$domain = explode('/', $referer);

	$source = array(
		array('google','q'),
		array('alltheweb','query'),
		array('altavista','q'),
		array('aol','query'),
		array('excite','search'),
		array('hotbot','query'),
		array('lycos','query'),
		array('yahoo','p'),
		array('live','q'),
		array('t-online','q'),
		array('msn','q'),
		array('netscape','search')
		);

	$keyword = "";
	for($i=0; $i<count($source); $i++)
	{
		if(eregi($source[$i][0], $referer))
		{
			$parse = parse_url($referer);
			parse_str($parse['query'], $output);
			$keyword = $output[$source[$i][1]];
			break;
		}
	}

	return array('domain' => str_replace('www.', '', $domain[2]), 'keyword' => strtolower($keyword));
}

# Returns amount of unique hits today
function counterize_getuniquehitstoday()
{
	$today = date("Y-m-d");
	$sql = "SELECT count(DISTINCT ip) FROM ".counterize_logTable()." WHERE timestamp >= '$today'";
	$wpdb =& $GLOBALS['wpdb'];
	return $wpdb->get_var($sql);
}


# Fetch information matching ID in DB.
function counterize_getentries($amount = 50, $entryID = null)
{
	$wpdb =& $GLOBALS['wpdb'];
	$sql =  'SELECT id, ip, timestamp, p.url as url, r.name as referer, ua.name as useragent, ';
	$sql .= 'm.refererID, m.agentID, m.pageID, k.keyword, k.keywordID ';
	$sql .= "FROM ".
	counterize_logTable(). " m, " .
	counterize_pageTable(). " p, " .
	counterize_agentsTable(). " ua, " .
	counterize_refererTable(). " r, " .
	counterize_keywordTable(). " k ";
	$sql .= "WHERE m.pageID = p.pageID and m.agentID = ua.agentID and m.refererID = r.refererID ";
	$sql .= " and k.keywordID = r.keywordID and ";

	if($_GET["urifilter"])
	$sql .= " p.url = '" . $wpdb->escape($_GET["urifilter"]) ."' and ";
	if($_GET["refererfilter"])
	$sql .= " r.name = '" . $wpdb->escape($_GET["refererfilter"]) ."' and ";
	if($_GET["agentfilter"])
	$sql .= " ua.name = '" . $wpdb->escape($_GET["agentfilter"]) ."' and ";

	if(isset($entryID))
	$sql .= " m.id = ".$wpdb->escape($entryID)." and ";

	$sql .= ' 1 = 1 ORDER BY m.timestamp DESC';

	if ($amount == "")
	$sql .= " LIMIT 50";
	else if ($amount != 0 AND is_numeric($amount))
	$sql .= " LIMIT $amount";

	return $wpdb->get_results($sql);
}

# Append information to DB
function counterize_add()
{
	# Set to unknown, if we're unable to extract information below.
	$referer = $remoteaddr = $useragent = $requesturl = 'unknown';

	if ($_SERVER['REMOTE_ADDR'])
		$remoteaddr = $_SERVER['REMOTE_ADDR'];
	if ($_SERVER['HTTP_USER_AGENT'])
		$useragent = $_SERVER['HTTP_USER_AGENT'];
	if ($_SERVER['REQUEST_URI'])
		$requesturl = $_SERVER['REQUEST_URI'];
	if ($_SERVER['HTTP_REFERER'])
		$referer = $_SERVER['HTTP_REFERER'];

	$this_url = "http://".$_SERVER['HTTP_HOST'].$requesturl;
	# Check to see if we really want to insert the entry...
	$checkval = 0;

	###################################
	# Bots detected and excluded
	#
	# To add an entry to the array, simply create line looking like this:
	#        $botarray[] = "<text in user-agent string>";
	$botarray[] = "bot";
	$botarray[] = "Yahoo! Slurp";
	$botarray[] = "slurpy";
	$botarray[] = "agent 007";
	$botarray[] = "ichiro";
	$botarray[] = "ia_archiver";
	$botarray[] = "zyborg";
	$botarray[] = "linkwalker";
	$botarray[] = "crawl";
	$botarray[] = "python";
	$botarray[] = "perl";
	$botarray[] = "w3c_validator";
	$botarray[] = "Microsoft URL Control";
	$botarray[] = "almaden";
	$botarray[] = "topicspy";
	$botarray[] = "poodle predictor";
	$botarray[] = "link checker pro";
	$botarray[] = "xenu link sleuth";
	$botarray[] = "iconsurf";
	$botarray[] = "zoe indexer";
	$botarray[] = "grub-client";
	$botarray[] = "spider";
	$botarray[] = "pompos";
	$botarray[] = "Mediapartners";
	$botarray[] = "virus_detector";
	$botarray[] = "Nuhk";
	$botarray[] = "findlinks";
	$botarray[] = "larbin";
	$botarray[] = "Sphere Scout";
	$botarray[] = "Ask Jeeves";
	$botarray[] = "Yahoo-Blogs";
	$botarray[] = "Yandex";
	$botarray[] = "Pagebull";
	$botarray[] = "HTTrack";
	$botarray[] = "OffByOne";
	$botarray[] = "PrintSmart";
	$botarray[] = "Getleft";
	$botarray[] = "Indy Library";
	$botarray[] = "DE Slurp";
	$botarray[] = "compatible; ICS";
	$botarray[] = "Powermarks";
	$botarray[] = "C-CCK-MCD";
	$botarray[] = "depspid";
	$botarray[] = "Twingly Recon";
	$botarray[] = "Netcraft";
	$botarray[] = "Check&amp;Get";
	$botarray[] = "relevantnoise";
	$botarray[] = "LiteFinder";
	$botarray[] = "Gigamega";
	$botarray[] = "Wget";
	$botarray[] = "Java/1.5";
	$botarray[] = "publisher.yahoo.com/rssguide";
	$botarray[] = "unknown";
	##############################

	# Run through bot-array and see if there's anything we don't like...
	foreach ($botarray as $entry)
		if (stristr($useragent, $entry))
			$checkval = 1;

	# From SHRIKEE, don't count RSS and other stuff...
	# Exclude files from being counted
	if ($checkval == 0)
	{
		// Exclude if referer is the same as url
		if ($this_url==$referer )
			$checkval = 1;

		// Exclude RSS feeds (Both with and without permalinks)
		// Stating just feed would make it impossible to name a page or post 'feed'
		/* if (stristr($requesturl, "feed/"))
		 $checkval = 1;
		 if (stristr($requesturl, "feed="))
		 $checkval = 1;
		 */
		 // Exclude files which annoying browsers like safari and opera request on each page
		 if (stristr($requesturl, "robots.txt")){
		 	$checkval = 1;
		 }
		 elseif (stristr($requesturl, "favicon.ico")){
		 	$checkval = 1;
		 }

		 // Exclude any admin or core files
		 elseif (stristr($requesturl, "wp-includes/")){
		 	$checkval = 1;
		 }
		 elseif (stristr($requesturl, "wp-admin/")) {
		 	$checkval = 1;
		 }
		 elseif (stristr($requesturl, "wp-content/")){
		 	$checkval = 1;
		 }
	}

	// more extensions?
	elseif (stristr($requesturl, ".jpg")){
		$checkval = 1;
	}
	elseif (stristr($requesturl, ".bmp")){
		$checkval = 1;
	}
	elseif (stristr($requesturl, ".png")){
		$checkval = 1;
	}
	elseif (stristr($requesturl, ".gif")){
		$checkval = 1;
	}


	# If not found anything unwanted yet, check to see if it's on the excludelist...
	if ($checkval == 0)
	{
		$tmp = get_option('counterize_excluded');
		$excludelist = preg_replace('/\s\s+/', ' ', $tmp);

		$tmp_array = explode(" ", $excludelist);
		$count = count($tmp_array);

		if ($excludelist != "" && $excludelist != " ")
		{
			for ($i=0; $i<$count; $i++)
			{
				if (strpos($remoteaddr, $tmp_array[$i]) === FALSE)
				{
					# Coming up...
				}
				else
				{
					# IP found on exclude-list - we don't want it!
					$checkval = 1;
				}
			}
		}
	}

	# DISABLED: This functionality is replaced with the admin functionality
	#           to enable/disable counting of certain users...
	#
	# let's check it is a logged in user.
	# If he's logged in, we don't count him.
	if ($checkval == 0)
	{
		$excluded_users = explode(",",get_option('counterize_excluded_users'));
		global $user_ID;
		get_currentuserinfo();
		$tmp = count($excluded_users);
		if($user_ID != "" && $user_ID != " " && in_array($user_ID,$excluded_users))
		$checkval = 1;
	}

	# If checkval is still 0, then yes - we want to insert it...
	if ($checkval == 0)
	{
		# Replace %20's(spaces) in strings with a white-space
		# Man, someone should create a better checking-module... *sigh*
		$requesturl = str_replace("%20", " ", $requesturl);
		$referer = str_replace("%20", " ", $referer);
		$timestamp = gmdate("Y-m-d H:i:s",time() + ( get_option('gmt_offset') * 60 * 60 ));

		$agentID = counterize_getUserAgentID($useragent);
		$pageID = counterize_getPageID($requesturl);
		$refererID = counterize_getRefererID($referer);
		$keywordID = counterize_getKeywordID($referer);

		$wpdb =& $GLOBALS['wpdb'];
		$sql = "INSERT INTO ".counterize_logTable()." (IP, timestamp, pageID, refererID, agentID) VALUES (";
		$sql .= "'" . substr(md5($wpdb->escape($remoteaddr)),1,16) . "',";
		$sql .= "'" . $timestamp . "', '";
		$sql .= $pageID . "', '";
		$sql .= $refererID . "', '";
		$sql .= $agentID . "')";

		$results = $wpdb->query($sql);

		counterize_AddUserAgentVisit($agentID);
		counterize_AddPageVisit($pageID);
		counterize_AddRefererVisit($refererID);
		counterize_AddKeywordVisit($keywordID);
	}
}

# gives the useragentID back
function counterize_getUserAgentID($useragent)
{
	$wpdb =& $GLOBALS['wpdb'];
	$sql = "SELECT count(agentID) from ".counterize_agentsTable()." where name = '".$wpdb->escape($useragent)."'";

	if(!$wpdb->get_var($sql))
	{
		# create new agent
		list(
		$browser_name, $browser_code, $browser_ver, $os_name, $os_code, $os_ver,
		$pda_name, $pda_code, $pda_ver ) = counterize_detect_browser($useragent);

		$sql = "INSERT INTO ".counterize_agentsTable()." (name,count,browserName,browserCode,browserVersion,osName,osCode,osVersion) VALUES (";
		$sql .= "'".$wpdb->escape($useragent)."',0,'".$wpdb->escape($browser_name)."','".$wpdb->escape($browser_name)."','".$wpdb->escape($browser_ver)."','".$wpdb->escape($os_name)."','".$wpdb->escape($os_code)."','".$wpdb->escape($os_ver)."')";
		$wpdb->query($sql);
	}

	$sql = "SELECT agentID from ".counterize_agentsTable()." where name = '".$wpdb->escape($useragent)."'";
	return $wpdb->get_var($sql);
}

function counterize_AddUserAgentVisit($agentID)
{
	if(is_numeric($agentID)){
		$wpdb =& $GLOBALS['wpdb'];
		$sql = "update ".counterize_agentsTable()." set count = count + 1 where agentID = $agentID";
		$wpdb->query($sql);
	}
}

function counterize_AddKeywordVisit($keywordID)
{
	if(is_numeric($keywordID)){
		$wpdb =& $GLOBALS['wpdb'];
		$sql = "update " . counterize_keywordTable() ." set count = count + 1 where keywordID = $keywordID";
		$wpdb->query($sql);
	}
}

# gives the pageID back
function counterize_getPageID($url)
{
	$wpdb =& $GLOBALS['wpdb'];
	$sql = "SELECT pageID from " . counterize_pageTable() ." where url = '".$wpdb->escape($url)."'";
	$pageID = $wpdb->get_var($sql);
	if(!$pageID)
	{
		# create new page
    global $post;
    $post_id = is_single() || $post->post_type == 'page'? $post->ID: 'NULL';
    $sql = "INSERT INTO " . counterize_pageTable() ." (url,count,postID) VALUES ('".$wpdb->escape($url)."',0,".$post_id.")";				
		$wpdb->query($sql);
		return $wpdb->insert_id;
	}
	return $pageID;
}

function counterize_AddPageVisit($pageID)
{
	if(is_numeric($pageID)){
		$wpdb =& $GLOBALS['wpdb'];
		$sql = "update " . counterize_pageTable() ." set count = count + 1 where pageID = $pageID";
		$wpdb->query($sql);
	}
}

# gives the keywordID back
function counterize_getKeywordID($referer)
{
	$wpdb =& $GLOBALS['wpdb'];
	$ref = counterize_ref_analyzer($referer);
	$sql = "SELECT keywordID from ".counterize_keywordTable()." where keyword = '".$wpdb->escape($ref['keyword'])."'";
	$keywordID = $wpdb->get_var($sql);

	if(!$keywordID)
	{
		# create new keyword
		$sql = "INSERT INTO ".counterize_keywordTable()." (keyword,count) VALUES ('" . $wpdb->escape($ref['keyword']). "',0)";
		$wpdb->query($sql);
		return $wpdb->insert_id;
	}
	return $keywordID;
}

# gives the refererID back
function counterize_getRefererID($referer)
{
	$wpdb =& $GLOBALS['wpdb'];
	$sql = "SELECT refererID from ".counterize_refererTable()." where name = '".$wpdb->escape($referer)."'";
	$refererID = $wpdb->get_var($sql);
	if(!$refererID)
	{
		$keywordID = counterize_getKeywordID($referer);
		# create new referer
		$sql = "INSERT INTO ".counterize_refererTable()." (name,count,keywordID) VALUES (";
		$sql .= "'".$wpdb->escape($referer)."',0,$keywordID)";
		$wpdb->query($sql);
		return $wpdb->insert_id;
	}
	return $refererID;
}

function counterize_AddRefererVisit($refererID)
{
	if(is_numeric($refererID)){
		$wpdb =& $GLOBALS['wpdb'];
		$sql = "update " . counterize_refererTable() ." set count = count + 1 where refererID = $refererID";
		$wpdb->query($sql);
	}
}

function counterize_pagefooter()
{
	?>
<div class="wrap"><?php _e('<strong>Need help?</strong> Go to <a href="http://www.navision-blog.de/counterize">the Counterize II Homepage</a> and search the Blog of the <a href="http://www.navision-blog.de">.NET / Dynamics NAV Blog</a> - others may have had the same question or problem as you...','counterize'); ?>
</div>
	<?php
}

function counterize_copyright()
{
	?>
<br />
<br />
<p style="text-align: center"><small> <?php
_e('Statistics recorded with <a href="http://www.navision-blog.de/counterize" title="Counterize II - Statistics-plugin for Wordpress by Steffen Forkmann">Counterize II</a>','counterize');
echo ' - Version ' . get_option('counterize_MajorVersion') . "." . get_option('counterize_MinorVersion');
?> </small></p>
<p><?php
}

function counterize_renderstats_vertical($rows, $header, $max_width = "500",
$nofollow = true, $maxwidth = "100%", $shorten = true)
{
	$max_label = get_option('counterize_maxWidth');
	foreach($rows as $row)
	{
		$items++;
		$complete_amount += $row->amount;
		if($row->amount > $max)
		$max = $row->amount;
	}

	?>
<table width="<?php echo $maxwidth; ?>">
	<tr class="alternate">
		<td style="width: 25%"><small><strong><?php _e($header,'counterize'); ?></strong></small></td>
		<td style="width: 10%"><small><strong><?php _e('Amount','counterize'); ?></strong></small></td>
		<td style="width: 65%"><small><strong><?php _e('Graph / %','counterize'); ?></strong></small></td>
	</tr>

	<?php
	foreach($rows as $row)
	{
		$percent = round($row->amount / $complete_amount * 100,2);

		if($row->amount)
		$width = round($row->amount * $max_width / $max);
		else
		$width = 0;

		$group = round($width / $max_width * 100);
		?>
	<tr <?php if($counter%2) { print " class=\"alternate\""; }?>>
		<td style="width: 25%" align="left"><small> <?php
		if(strlen($row->label) > $max_label && $shorten == true)
		$label = substr($row->label,0,$max_label) . '...';
		else
		$label = $row->label;
		if($row->url)
		{
			echo "<a href=\"" . $row->url . "\"";
			if($nofollow)
			echo " rel=\"nofollow\"";
			echo ">" . $label . "</a>";
		}
		else
		echo $label;
		?> </small></td>

		<td style="width: 10%"><small> <?php echo $row->amount; ?> </small></td>

		<td style="width: 65%" align="left"><img src="<?php echo get_option("siteurl") . "/wp-content/plugins/";
                        if ($group < 40)
                                echo "counterizeii/counterize_red.png";
                        else if ($group < 80)
                                echo "counterizeii/counterize_yellow.png";
                        else
                                echo "counterizeii/counterize_green.png";
                        ?>" style="height:8px; width:<?php echo $width ?>px; vertical-align:bottom"
                        alt="<?php echo $header . ' - ' . htmlspecialchars($row->label) . ' - ' . $row->amount . ' - ' . $percent . ' %' ?>" />
		&nbsp; <small><strong> <?php echo $percent; ?> % </strong></small></td>
	</tr>
	<?php $counter++;
}
?>
</table>

<?php
}


function counterize_renderstats($rows, $max_height = 80, $maxwidth = "100%")
{

	?>
<table width="<?php echo $maxwidth; ?>">
	<tr>
	<?php

	foreach($rows as $row)
	{
		$items++;
		$complete_amount += $row->amount;
		if($row->amount > $max)
		$max = $row->amount;
	}

	foreach($rows as $row)
	{
		$percent = round($row->amount / $complete_amount * 100,2);

		if($row->amount)
		$height = round($row->amount * $max_height / $max);
		else
		$height = 0;

		$group = round($height / $max_height * 100);

		echo "<td style=\"width:3%\"";
		if($i%2)
		print "class=\"alternate\"";

		echo " align=\"center\" valign=\"bottom\"><small>";
		echo $row->amount;
		?>
		<br />
		<img src="<?php echo get_option("siteurl") . "/wp-content/plugins/";
                        if ($group < 40)
                                echo "counterizeii/counterize_red.png";
                        else if ($group < 80)
                                echo "counterizeii/counterize_yellow.png";
                        else
                                echo "counterizeii/counterize_green.png";
                        ?>" style="width:8px; height:<?php echo $height ?>px; vertical-align:bottom" alt="Statistics" />
                        <?php
                        echo "<br />$percent<br />%</small></td>";
                        $i++;
}
?>
	</tr>
	<tr>
	<?php
	$i = 0;
	foreach($rows as $row)
	{
		echo "<td style=\"width:3%\"";
		if($i % 2)
		echo "class=\"alternate\"";
		echo " align=\"center\"><small><strong>$row->label</strong></small></td>";
		$i++;
	}
	?>
	</tr>
</table>
	<?php
}

# Do the installation stuff, if the plugin is marked to be activated...
include("counterize_install.php");
$install = (basename($_SERVER['SCRIPT_NAME']) == 'plugins.php' && isset($_GET['activate']));
if ($install)
{
	counterize_install();
}

function counterize_show_history()
{
	$howmany = __("Latest entries",'counterize');

	$amount = get_option('counterize_amount');
	if ($amount == "" || $amount == " ")
	$amount = 50;

	$howmany = $howmany . " (" .$amount .")";
	$entries = counterize_getentries($amount);

	?>
<div class="wrap">
<h2><?php echo $howmany; ?></h2>

<a href="edit.php?page=counterizeii/counterize.php"><?php _e("Reset Filters",'counterize'); ?></a></br>
</br>
<form method="post"
	action="edit.php?page=counterizeii/counterize.php&amp;killmass=yes"
	name="tablesForm" id="tablesForm">
<table width="100%" cellpadding="3" cellspacing="3">
	<tr class="alternate">
		<td scope="col" width="2%"><strong><?php _e("del",'counterize'); ?></strong></td>
		<td scope="col" width="6%"><strong><?php _e("ID",'counterize'); ?></strong></td>
		<td scope="col" style="width: 14%"><strong><?php _e("Timestamp",'counterize'); ?></strong></td>
		<td scope="col" style="width: 20%"><strong><?php _e("URl",'counterize'); ?></strong></td>
		<td scope="col" style="width: 31%"><strong><?php _e("Referer",'counterize'); ?></strong></td>
		<td scope="col" style="width: 10%"><strong><?php _e("UserAgent",'counterize'); ?></strong></td>
		<td scope="col" style="width: 25%"><strong><?php _e("Keywords",'counterize'); ?></strong></td>
		<td scope="col" style="width: 3%"><strong><?php _e("Kill",'counterize'); ?></strong></td>
	</tr>

	<?php
	foreach($entries as $entry)
	{
		?>
	<tr <?php if($i%2) { print "class=\"alternate\""; } ?>>
		<td scope="col" width="6%"><small> <input type="checkbox"
			name='counterize_killemall[<?php echo $entry->id; ?>]'
			value="<?php echo $entry->id; ?>" /></td>
		<td><?php echo $entry->id; ?></small></td>
		<td scope="col" width="14%"><small><?php echo $entry->timestamp; ?> </small></td>
		<td scope="col" width="25%"><small><?php echo "<a href=\"" . $entry->url . "\">" . wordwrap($entry->url, 30, "\n", 1); ?>
		</a> (<a
			href="edit.php?page=counterizeii/counterize.php&urifilter=<?php echo $entry->url; ?>">F</a>)</small></td>
		<td scope="col" width="20%"><small> <?php
		if ($entry->referer != "unknown")
		{
			echo "<a href=\"" . $entry->referer . "\">" . wordwrap($entry->referer, 30, "\n", 1) . "</a>";
			?> (<a
			href="edit.php?page=counterizeii/counterize.php&refererfilter=<?php echo $entry->referer; ?>">F</a>)
			<?php
}
else
echo wordwrap($entry->referer, 30, "\n", 1);
?> </small></td>
		<td scope="col" style="width: 25%"><small><?php echo counterize_browser_string($entry->useragent , true, '<br>'); ?></small>
		</td>
		<td><small><?php echo $entry->keyword; ?></small></td>
		<td scope="col" style="width: 5%"><a
			href="javascript:conf('edit.php?page=counterizeii/counterize.php&amp;kill=<?php echo $entry->id; ?>');">
		<font color="red" size="+1">X</font> </a></td>
		<?php
		$i++;
}
?>
	</tr>
</table>

<input type="button" name="CheckAll"
	value="<?php _e("Check All",'counterize'); ?>"
	onClick="checkAll(document.tablesForm)" /> <input type="button"
	name="UnCheckAll" value="<?php _e("Uncheck All",'counterize'); ?>"
	onClick="uncheckAll(document.tablesForm)" /> <input type="SUBMIT"
	value="<?php _e("Delete selected Entries",'counterize'); ?>" /></form>
</div>

<?php

}

function counterize_updateText($text="Configuration updated", $color="red")
{
	echo "<div id=\"message\" class=\"updated fade\"><p><font color=\"$color\">";
	_e($text,'counterize');
	echo "</font></p></div>";
}

function counterize_showStats($admin = false)
{
	if(!counterize_getamount())
	{
		_e("There's no data in the database - You can't see stats until you have data.",'counterize');
		return;
	}
	?>
</p>
<div class="wrap">
<h2><?php _e('Hit Counter',"counterize");?></h2>
<table width="100%" cellpadding="3" cellspacing="3">
	<tr>
		<td scope="col" style="width: 15%" align="center"><?php _e("Total hits: ",'counterize'); ?>
		</td>
		<td scope="col" style="width: 15%" align="center"><?php _e("Hits from unique IPs: ",'counterize'); ?>
		</td>
		<td scope="col" style="width: 15%" align="center"><?php _e("Total hits, today: ",'counterize'); ?>
		</td>
		<td scope="col" style="width: 20%" align="center"><?php _e("Hits from unique IPs, today: ",'counterize'); ?>
		</td>
		<td scope="col" style="width: 15%" align="center"><?php _e("Hits, the last 7 days: ",'counterize'); ?>
		</td>
		<td scope="col" style="width: 20%" align="center"><?php _e("Unique hits, the last 7 days: ",'counterize'); ?>
		</td>
	</tr>
	<tr>
		<td align="center"><strong><?php echo counterize_getamount(); ?></strong></td>
		<td align="center"><strong><?php echo counterize_getuniqueamount(); ?></strong></td>
		<td align="center"><strong><?php echo counterize_gethitstoday(); ?></strong></td>
		<td align="center"><strong><?php echo counterize_getuniquehitstoday(); ?></strong></td>
		<td align="center"><strong><?php echo counterize_getlatest7days(); ?></strong></td>
		<td align="center"><strong><?php echo counterize_getuniquelatest7days(); ?></strong></td>
	</tr>
</table>
</div>

	<?php
	# Amount to pass as option to the graphs...
	$amount2 = get_option('counterize_amount2');
	if ($amount2 == "" || $amount2 == " ")
	$amount2 = 5;
	$width = 250;
	?>

<div class="wrap">
<h2><?php _e('Visits based on day of month','counterize');?></h2>
	<?php
	if($admin)
	counterize_renderstats(counterize_getdailystats());
	else
	counterize_renderstats_vertical(counterize_getdailystats(),__("Day",'counterize'),$width);
	?></div>

<div class="wrap">
<h2><?php _e('Visits based on day of month (only this month)','counterize');?></h2>
	<?php
	if($admin)
	counterize_renderstats(counterize_getdailystats(true));
	else
	counterize_renderstats_vertical(counterize_getdailystats(true),__("Day",'counterize'),$width);
	?></div>


<div class="wrap">
<h2><?php _e('Visits based on day of week','counterize');?></h2>
	<?php
	if($admin)
	counterize_renderstats(counterize_getweeklystats());
	else
	counterize_renderstats_vertical(counterize_getweeklystats(),__("Day",'counterize'),$width);
	?></div>

<div class="wrap">
<h2><?php _e('Visits based on month','counterize');?></h2>
	<?php
	if($admin)
	counterize_renderstats(counterize_getmonthlystats());
	else
	counterize_renderstats_vertical(counterize_getmonthlystats(),__("Month",'counterize'),$width);
	?></div>

<div class="wrap">
<h2><?php _e('Visits based on hour of day','counterize');?></h2>
	<?php
	if($admin)
	counterize_renderstats(counterize_gethourlystats());
	else
	counterize_renderstats_vertical(counterize_gethourlystats(),__("Hour",'counterize'),$width);
	?></div>

<div class="wrap">
<h2><?php echo __("Most visited pages ",'counterize') . "(" . $amount2 .")"; ?></h2>
	<?php counterize_most_visited_pages($amount2,$width); ?></div>
<div class="wrap">
<h2><?php echo __("Most seen referers ",'counterize') . "(" . $amount2 . ")"; ?></h2>
<?php counterize_most_visited_referrers($amount2,$width); ?></div>
<div class="wrap">
<h2><?php echo __("Most used browsers ",'counterize') . "(" . $amount2 . ")";?></h2>
<?php counterize_most_used_browsers_without_version($amount2,$width); ?>
</div>

<div class="wrap">
<h2><?php echo __("Most used browsers versions ",'counterize') . "(" . $amount2 . ")";?></h2>
<?php counterize_most_used_browsers($amount2,$width); ?></div>

<div class="wrap">
<h2><?php echo __("Most used operating systems ",'counterize') . "(" . $amount2 . ")";?></h2>
<?php counterize_most_used_os($amount2,$width); ?></div>

<div class="wrap">
<h2><?php echo __("Most searched keywords ",'counterize') . "(" . $amount2 . ")";?></h2>
<?php counterize_most_searched_keywords($amount2,$width); ?></div>

<div class="wrap">
<h2><?php echo __("Most searched keywords today",'counterize') . "(" . $amount2 . ")";?></h2>
<?php counterize_most_searched_keywords_today($amount2,$width); ?></div>

<?php
}

function counterize_manage_page()
{
	?>
<script language="javascript" type="text/javascript">
        function conf(url)
        {
                if (confirm('<?php _e('Are you sure that you want to delete this entry?','counterize'); ?>'))
                {
                        self.location.href = url;
                }
        }
        
        <!--
		// by Nannette Thacker
		// http://www.shiningstar.net -->
		
		function checkAll(field)
		{
			for (i = 0; i < field.length; i++)
				field[i].checked = true ;
		}
		 
		function uncheckAll(field)
		{
			for (i = 0; i < field.length; i++)
				field[i].checked = false ;
		}

	</script>

	<?php

	$updateText = "";
	if (isset($_GET['killmass']))
	if ($_GET['killmass']=='yes')
	if (isset($_POST['counterize_killemall']))
	{
		foreach ($_POST['counterize_killemall'] as $key => $val)
		{
			counterize_killEntry($val);
			$updateText .= __('Entry: '.$val.' removed<br />','counterize');
		}
		counterize_updateText($updateText);
	}

	# For the zap-an-entry-option
	if (isset($_GET['kill']))
	{
		counterize_killEntry($_GET['kill']);
		counterize_updateText(__("Deleting entry ","counterize") . $_GET['kill']);
	}

	counterize_showStats(true);
	counterize_show_history();
	counterize_pagefooter();
}

function counterize_filter($data)
{
	$pattern = '/\<\!\-\-\s*counterize_stats\s*\-\-\>/';
	while(preg_match($pattern, $data, $matches))
	{
		ob_start();

		counterize_showStats();
		counterize_copyright();

		$content = ob_get_contents();
		ob_end_clean();
		$replace_pattern = $pattern;
		$data = preg_replace($replace_pattern, $content, $data);
	}
	return $data;
}

include("counterize_admin.php");
include("counterize_dashboard.php");

function counterize_add_pages()
{
	# Set it up... - add to Dashboard and options-page.
	add_action('activity_box_end', 'counterize_dashboard');
	add_submenu_page('edit.php',__('Counterize II'), __('Counterize II'), 8, __FILE__, 'counterize_manage_page');
	add_options_page('Counterize II Options', 'Counterize II', 8, basename(__FILE__), 'counterize_options_page');
}

add_action('admin_menu', 'counterize_add_pages');

# Create API hook instead of placing code in the header.php-file
add_action('wp_head', 'counterize_add', 1);
add_filter('the_content', 'counterize_filter');

?>