<?php
/*
'#############################
'DWStats 1.0 - ASP
'(c) 2004 N G Rohler & Elkfoot.com software
'All Rights Reserved.
'
'This File: send.php
'Purpose: collects data
'----DO NOT MODIFY BELOW HERE!!!----
'#############################
*/
header("Content-type: image/gif");
readfile("blank.gif");
include_once("connection.html");
include_once("../Connections/".$ConnectionName.".php");
$dbname = ${"database_".$ConnectionName};
$conn = ${$ConnectionName};
mysql_select_db($dbname, $conn);
function doQuery($sql) {
	global $conn;
	mysql_query($sql, $conn) or die(mysql_error());
}
if (isset($HTTP_GET_VARS["nojs"]) && $HTTP_GET_VARS["nojs"]=="true") {
	################################
	if (isset($HTTP_GET_VARS["pnm"]) && $HTTP_GET_VARS["pnm"]!="") {
		$pagename = $HTTP_GET_VARS["pnm"];
	} else {
		$pagename = "(No page name specified)";
	}
	$ip = getenv("REMOTE_ADDR");
	$trimref = "Bookmark/Entered URL or blocked";
	$platform = "Unknown";
	$browser = "Unknown";
	$language = "Unknown";
	$country = "Unknown";
	$javascript = "Disabled";
	$java = "Unknown";
	$screenres = "Unknown";
	$screencolor = "Unknown";
	$searchengine = "None";
	$searchquery = "None";
	################################
} else {
	################################
	$ip = getenv("REMOTE_ADDR");
	if (isset($HTTP_GET_VARS["pnm"]) && $HTTP_GET_VARS["pnm"] != "") {
		$pagename = $HTTP_GET_VARS["pnm"];
	} else {
		$pagename = "(No page name specified)";
	}
	if (isset($HTTP_GET_VARS["ref"]) && $HTTP_GET_VARS["ref"] != "") {
		$ref = strtolower($HTTP_GET_VARS["ref"]);
		if (strpos($ref, "?")!==false) {
			$trimref = substr($ref, 0, strpos($ref, "?"));
		}
	} else {
		$ref = "Bookmark/Entered URL or blocked";
	}
	if (isset($HTTP_GET_VARS["plat"]) && $HTTP_GET_VARS["plat"] != "") {
		$platform = strtolower($HTTP_GET_VARS["plat"]);
		if ($platform=="win32") {
			$platform = "Windows";
		} elseif ($platform=="macppc") {
			$platform = "Macintosh";
		} else {
			$platform = "Other";
		}
	} else {
		$ref = "Other";
	}
	if (isset($HTTP_GET_VARS["brw"]) && $HTTP_GET_VARS["brw"] != "" && isset($HTTP_GET_VARS["ver"]) && $HTTP_GET_VARS["ver"] != "") {
		$browser = strtolower($HTTP_GET_VARS["brw"]);
		if (strpos($browser, "msie")!=false) {
			$browser = "Microsoft Internet Explorer ";
		} elseif (strpos($browser, "firefox")!=false) {
			$browser = "FireFox ";
		} elseif (strpos($browser, "netscape")!=false) {
			$browser = "Netscape ";
		} elseif (strpos($browser, "safari")!=false) {
			$browser = "Safari ";
		} elseif (strpos($browser, "opera")!=false) {
			$browser = "Opera ";
		} elseif (strpos($browser, "konqueror")!=false) {
			$browser = "Konqueror";
		} elseif (strpos($browser, "googlebot")!=false) {
			$browser = "(GoogleBot)";
		} elseif (strpos($browser, "spider")!=false || strpos($browser, "bot")!=false) {
			$browser = "(Spider/Bot)";
		} elseif (strpos($browser, "gecko")!=false) {
			$browser = "Mozilla ";
		} else {
			$browser = "Other ";
		}
		if (($space_pos = strpos($HTTP_GET_VARS["ver"], " "))!=false) {
			$browser .= substr($HTTP_GET_VARS["ver"], 0, $space_pos);
		} else {
			$browser .= $HTTP_GET_VARS["ver"];
		}
	} else {
		$browser = "Unknown";
	}
	if (isset($HTTP_GET_VARS["lang"]) && strlen($HTTP_GET_VARS["lang"])==5 && strpos($HTTP_GET_VARS["lang"], "-")==2) {
		$language = substr($HTTP_GET_VARS["lang"], 0, 2);
		$country = substr($HTTP_GET_VARS["lang"], 3, 2);
		switch (strtolower($language)) {
			case "en":
			  $language = "English";
			  break;
			case "zh":
			  $language = "Chinese";
			  break;  
			case "es":
			  $language = "Spanish";
			  break;
			case "de":
			  $language = "German";
			  break;
			case "fr":
			  $language = "French";
			  break;
			case "af":
			  $language = "Afrikaans";
			  break;
			case "sq":
			  $language = "Albanian";
			  break;
			case "ar":
			  $language = "Arabic";
			  break;
			case "eu":
			  $language = "Basque";
			  break;
			case "bg":
			  $language = "Bulgarian";
			  break;
			case "be":
			  $language = "Belarusian";
			  break;
			case "ca":
			  $language = "Catalan";
			  break;
			case "hr":
			  $language = "Croatian";
			  break;
			case "cs":
			  $language = "Czech";
			  break;
			case "da":
			  $language = "Danish";
			  break;
			case "nl":
			  $language = "Dutch";
			  break;
			case "et":
			  $language = "Estonian";
			  break;
			case "fo":
			  $language = "Faeroese";
			  break;
			case "fa":
			  $language = "Farsi";
			  break;
			case "fi":
			  $language = "Finnish";
			  break;
			case "gd":
			  $language = "Gaelic";
			  break;
			case "el":
			  $language = "Greek";
			  break;
			case "he":
			  $language = "Hebrew";
			  break;
			case "hi":
			  $language = "Hindi";
			  break;
			case "hu":
			  $language = "Hungarian";
			  break;
			case "is":
			  $language = "Icelandic";
			  break;
			case "id":
			  $language = "Indonesian";
			  break;
			case "it":
			  $language = "Italian";
			  break;
			case "ja":
			  $language = "Japanese";
			  break;
			case "ko":
			  $language = "Korean";
			  break;
			case "lv":
			  $language = "Latvian";
			  break;
			case "lt":
			  $language = "Lithuanian";
			  break;
			case "mk":
			  $language = "Macedonian";
			  break;
			case "ms":
			  $language = "Malaysian";
			  break;
			case "mt":
			  $language = "Maltese";
			  break;
			case "no":
			  $language = "Norwegian";
			  break;
			case "pl":
			  $language = "Polish";
			  break;
			case "pt":
			  $language = "Portuguese";
			  break;
			case "rm":
			  $language = "Rhaeto-Romanic";
			  break;
			case "ro":
			  $language = "Romanian";
			  break;
			case "ru":
			  $language = "Russian";
			  break;
			case "sz":
			  $language = "Sami";
			  break;
			case "sr":
			  $language = "Serbian Cyrillic";
			  break;
			case "sk":
			  $language = "Slovak";
			  break;
			case "sl":
			  $language = "Slovenian";
			  break;
			case "sb":
			  $language = "Sorbian";
			  break;
			case "sx":
			  $language = "Sutu";
			  break;
			case "sv":
			  $language = "Swedish";
			  break;
			case "th":
			  $language = "Thai";
			  break;
			case "ts":
			  $language = "Tsonga";
			  break;
			case "tn":
			  $language = "Tswana";
			  break;
			case "tr":
			  $language = "Turkish";
			  break;
			case "uk":
			  $language = "Ukrainian";
			  break;
			case "ur":
			  $language = "Urdu";
			  break;
			case "ve":
			  $language = "Venda";
			  break;
			case "vi":
			  $language = "Vietnamese";
			  break;
			case "xh":
			  $language = "Xhosa";
			  break;
			case "ji":
			  $language = "Yiddish";
			  break;
			case "zu":
			  $language = "Zulu";
			  break;
			default:
				$language = "Other";
		}
		switch (strtolower($country)) {
			  case "us":
				  $country = "United States";
				  break;
			  case "gb":
				  $country = "United Kingdom";
				  break;
			  case "ca":
				  $country = "Canada";
				  break;
			  case "de":
				  $country = "Germany";
				  break;
			  case "sa":
				  $country = "Saudi Arabia";
				  break;
			  case "be":
				  $country = "Belgium";
				  break;
			  case "au":
				  $country = "Australia";
				  break;
			  case "iq":
				  $country = "Iraq";
				  break;
			  case "eg":
				  $country = "Egypt";
				  break;
			  case "ly":
				  $country = "Libya";
				  break;
			  case "dz":
				  $country = "Algeria";
				  break;
			  case "ma":
				  $country = "Morocco";
				  break;
			  case "tn":
				  $country = "Tunisia";
				  break;
			  case "om":
				  $country = "Oman";
				  break;
			  case "ye":
				  $country = "Yemen";
				  break;
			  case "sy":
				  $country = "Syria";
				  break;
			  case "jo":
				  $country = "Jordan";
				  break;
			  case "lb":
				  $country = "Lebanon";
				  break;
			  case "kw":
				  $country = "Kuwait";
				  break;
			  case "ae":
				  $country = "United Arab Emirates";
				  break;
			  case "bh":
				  $country = "Bahrain";
				  break;
			  case "qa":
				  $country = "Qatar";
				  break;
			  case "tw":
				  $country = "Taiwan";
				  break;
			  case "cn":
				  $country = "PRC";
				  break;
			  case "hk":
				  $country = "Hong Kong SAR";
				  break;
			  case "sg":
				  $country = "Singapore";
				  break;
			  case "nz":
				  $country = "New Zealand";
				  break;
			  case "ie":
				  $country = "Ireland";
				  break;
			  case "za":
				  $country = "South Africa";
				  break;
			  case "jm":
				  $country = "Jamaica";
				  break;
			  case "bz":
				  $country = "Belize";
				  break;
			  case "tt":
				  $country = "Trinidad";
				  break;
			  case "ch":
				  $country = "Switzerland";
				  break;
			  case "lu":
				  $country = "Luxembourg";
				  break;
			  case "ie":
				  $country = "Ireland";
				  break;
			  case "ch":
				  $country = "Switzerland";
				  break;
			  case "at":
				  $country = "Austria";
				  break;
			  case "lu":
				  $country = "Luxembourg";
				  break;
			  case "li":
				  $country = "Liechtenstein";
				  break;
			  case "ch":
				  $country = "Switzerland";
				  break;
			  case "br":
				  $country = "Brazil";
				  break;
			  case "pt":
				  $country = "Portugal";
				  break;
			  case "mo":
				  $country = "Moldavia";
				  break;
			  case "mx":
				  $country = "Mexico";
				  break;
			  case "gt":
				  $country = "Guatemala";
				  break;
			  case "cr":
				  $country = "Costa Rica";
				  break;
			  case "pa":
				  $country = "Panama";
				  break;
			  case "do":
				  $country = "Dominican Republic";
				  break;
			  case "ve":
				  $country = "Venezuela";
				  break;
			  case "co":
				  $country = "Colombia";
				  break;
			  case "pe":
				  $country = "Peru";
				  break;
			  case "ar":
				  $country = "Argentina";
				  break;
			  case "ec":
				  $country = "Ecuador";
				  break;
			  case "cl":
				  $country = "Chile";
				  break;
			  case "uy":
				  $country = "Uruguay";
				  break;
			  case "py":
				  $country = "Paraguay";
				  break;
			  case "bo":
				  $country = "Bolivia";
				  break;
			  case "sv":
				  $country = "El Salvador";
				  break;
			  case "hn":
				  $country = "Honduras";
				  break;
			  case "ni":
				  $country = "Nicaragua";
				  break;
			  case "pr":
				  $country = "Puerto Rico";
				  break;
			  case "fi":
				  $country = "Finland";
				  break;
			  default:
			  	  $country = "Other";		
		}
	} else {
		$language = "Unknown";
		$country = "Unknown";
	}
	$javascript = "Enabled";
	if (isset($HTTP_GET_VARS["jav"])) {
		if ($HTTP_GET_VARS["jav"]=="true") {
			$java = "Enabled";
		} else {
			$java = "Disabled";
		}
	} else {
		$java = "Unknown";
	}
	if (isset($HTTP_GET_VARS["scrw"]) && $HTTP_GET_VARS["scrw"]!="" && isset($HTTP_GET_VARS["scrh"]) && $HTTP_GET_VARS["scrh"]!="") {
		$screenres = $HTTP_GET_VARS["scrw"]." x ".$HTTP_GET_VARS["scrh"];
	} else {
		$screenres = "Unknown";
	}
	if (isset($HTTP_GET_VARS["clr"]) && $HTTP_GET_VARS["clr"]!="") {
		$screencolor = $HTTP_GET_VARS["clr"]." bit";
	} else {
		$screencolor = "Unknown";
	}
	//search engines
	if (strpos($ref, "google.com/search")!=false) {
		$searchengine = "Google";
		if (ereg("q=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "altavista.com/web")!=false) {
		$searchengine = "AltaVista";
		if (ereg("q=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "ask.com/web")!=false) {
		$searchengine = "Ask Jeeves";
		if (ereg("q=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "search.msn.com")!=false) {
		$searchengine = "MSN Search";
		if (ereg("q=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "alltheweb.com/search")!=false) {
		$searchengine = "AllTheWeb";
		if (ereg("q=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "s.teoma.com/search")!=false) {
		$searchengine = "Teoma";
		if (ereg("q=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "search.yahoo.com")!=false) {
		$searchengine = "Yahoo";
		if (ereg("p=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "search.aol.com")!=false) {
		$searchengine = "AOL Search";
		if (ereg("query=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "hotbot.com")!=false) {
		$searchengine = "HotBot";
		if (ereg("query=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "mamma.com/mamma")!=false) {
		$searchengine = "Mamma";
		if (ereg("query=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "search.netscape.com")!=false) {
		$searchengine = "Netscape Search";
		if (ereg("query=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "websearch.com")!=false) {
		$searchengine = "WebSearch";
		if (ereg("qkw=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} elseif (strpos($ref, "voila.com/s")!=false) {
		$searchengine = "Voila";
		if (ereg("rdata=(.[^&]*)", $ref, $regs)) {
			$searchquery = $regs[1];
		} else {
			$searchquery = "None";
		}
	} else {
		$searchengine = "Other/None";
		$searchquery = "None/Unknown Engine";
	}
	$searchquery = urldecode($searchquery);
	if (!isset($trimref)) {
		$trimref = $ref;
	}
	##################################
};
$insertsql = "INSERT INTO dwstats_stats (pagename, date, ip, ref, os, browser, country, language, javascript, java, screenres, screencolor, searchengine, searchquery)
VALUES ('".$pagename."', 
	NOW(), 
	'".$ip."', 
	'".$trimref."', 
	'".$platform."', 
	'".$browser."', 
	'".$country."', 
	'".$language."', 
	'".$javascript."', 
	'".$java."', 
	'".$screenres."',
	'".$screencolor."',
	'".$searchengine."',
	'".$searchquery."'
)
";
doQuery($insertsql);
/*echo("IP: ".$ip."<br>");
echo("Referrer: ".$trimref."<br>");
echo("OS: ".$platform."<br>");
echo("Browser: ".$browser."<br>");
echo("Country: ".$country."<br>");
echo("Language: ".$language."<br>");
echo("Javascript: ".$javascript."<br>");
echo("Java: ".$java."<br>");
echo("Screen Resolution: ".$screenres."<br>");
echo("Search Color: ".$screencolor."<br>");
echo("Search Engine: ".$searchengine."<br>");
echo("Search Query: ".$searchquery."<br>");*/
?>