<?php

/*
phphits v0.951 Beta :: include file
Coded by Johannes Gamba (webmaster@gamba.de)
Source last updated: 2001.10.11 21:00
*/

/////////////// Konfiguratsiooni failike  ///////////////

// Format: "NAME", "VALUE"


// MySQL settings

define("SQL_HOST", "localhost");		// Name or IP of MySQL server
define("SQL_USER", "sqluser");			// MySQL user name
define("SQL_PWD", "torumees");			// MySQL password
define("SQL_DB", "phphits");			// Andmebaasi nimi
define("SQL_TABLE", "log");			// Tabeli nimi

define("SQL_SHOW_ERRORS", "1");			// Mysql errorite väljastamine 1 true 2 false

// Counter settings

define("COUNTER_MODE", "2");			// Counter  (1 = tekst , 2 = pilt)
define("COUNTER_IMG_SUBDIR", "digits");		// Piltide asukoht

define("COUNTER_USERONLINE_TIME", "2");		// mitme min jooksul olnud onlain kasut ta näitab
define("COUNTER_HITS_OFFSET", "0");		// Klikkide offset,  näitab 10000 mitte 10
define("COUNTER_BLOCK_TIME", "30");		// Ei loe  min jooksul klikke
define("COUNTER_DIGITS", "4");			// mitu numbrit näitab

// Admin settings

define("STATS_ADMIN_USER", "admin");		// Admin kasutajanimi
define("STATS_ADMIN_PWD", "aimar");		// Admin parool

// Log file settings

define("STATS_FONT_SIZE1", "2");		// Fondi suurus on norm
define("STATS_FONT_SIZE2", "1");		// Väike fondi suurus
define("STATS_FONT_FACE", "Verdana, Arial");	// Font
define("STATS_HIGHLIGHT_TIME", "24");		// Näitab klikke 24 tunnijooksul vastavates värvides
define("STATS_HIGHLIGHT_COLOR", "#FFCC33");	// Selle värviga on klikid

///refresh counteri  seadistused

$counterstyle = "graphic"; // text või  graphic
$invisible = "no";    //
$height = "19";     //
$width = "15";    //
$hitsfile = ""; //
$images = "";  ///pildi path

// ==========================================================================================

/////////////////////  Funktsioon, mis lisab klikke ////////////////////////////


function phphitsAddHit()
{
			
/////////////// Set vars ///////////////

$sql_result = "";

/////////////// Kasutaja IP aadress ja hosti nimi ///////////////

if (getenv ("HTTP_X_FORWARDED_FOR"))
{
	$u_ip = getenv ("HTTP_X_FORWARDED_FOR");
	$u_host = gethostbyaddr($u_ip);
}
else
{
	$u_ip = getenv ("REMOTE_ADDR");
	$u_host = gethostbyaddr($u_ip);
}

/////////////// Teeb kindlaks mis brauseriga tegemist on///////////////

$u_browser= getenv ("HTTP_USER_AGENT");

/////////////// Kasutaja vaikimisi kehtiv keel  ///////////////

$u_lang = explode(",", getenv ("HTTP_ACCEPT_LANGUAGE"));
$u_lang = strtolower($u_lang[0]);

/////////////// Unixi ajatempli saamine ///////////////

$u_timestamp = time();

///////////////  kuupäeva ja aja saamine ///////////////

$u_date = date("F j, Y | H:i:s");

/////////////// Mysqliga ühenduse loomine ///////////////

if (!($sql_id = @mysql_connect(SQL_HOST, SQL_USER, SQL_PWD)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_connect", $sql_id);	
}

/////////////// uue andmebaasi loomine ja selle  aktiveerimine ///////////////

@mysql_create_db(SQL_DB, $sql_id);


if (!@mysql_select_db(SQL_DB, $sql_id))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select_db", $sql_id);
}

/////////////// Loob uue tabeli ///////////////

$sql_query = "CREATE TABLE " . SQL_TABLE . " (ip CHAR(255), host CHAR(255), browser CHAR(255), language CHAR(255), date CHAR(255), tstamp CHAR(255), rowid INT PRIMARY KEY AUTO_INCREMENT)";

@mysql_query($sql_query, $sql_id);

/////////////// saab kõik IP aadressid ja ajatemplid ning reastab desc ///////////////


$sql_query = "SELECT ip,tstamp FROM " . SQL_TABLE . " ORDER BY rowid DESC";

if (!($sql_res = @mysql_query($sql_query, $sql_id)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select", $sql_id);
}

/////////////// KONTROLLIB kas IP on juba käinud, kui on, siis exit ///////////////

while ($sql_row = @mysql_fetch_array ($sql_res))
{
	if ((($sql_row["tstamp"] + (COUNTER_BLOCK_TIME * 60)) > $u_timestamp) && ($sql_row["ip"] == $u_ip))
	{
		@mysql_close($sql_id);
		$t = (($sql_row["tstamp"] + (COUNTER_BLOCK_TIME * 60)) - $u_timestamp);
		return $sql_result;
		exit;
	}
}

/////////////// lisab tabelisse uue veeru koos infoga, mis sai kasutaja klikist ///////////////

$sql_query = "INSERT INTO " . SQL_TABLE . " (ip,host,browser,language,date,tstamp) VALUES (\"$u_ip\",\"$u_host\",\"$u_browser\",\"$u_lang\",\"$u_date\",\"$u_timestamp\")";

if (!@mysql_query($sql_query, $sql_id))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_insert", $sql_id);
}

/////////////// Mysql serveriga ühenduse lõpetamine ///////////////

@mysql_close($sql_id);

return $sql_result;
}

// ==========================================================================================


/////////////////////   Funktsioon mis näitab logi     //////////////////



function phphitsShowLog()
{

/////////////// Set vars ///////////////

$sql_result = "";
$sql_numrows = 0;
$i = 0;

/////////////// Võtab ühendust mysql serveriga ///////////////

if (!($sql_id = @mysql_connect(SQL_HOST, SQL_USER, SQL_PWD)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_connect", $sql_id);
}

/////////////// Andmebaas aktiveeritakse ///////////////

if (!@mysql_select_db(SQL_DB, $sql_id))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select_db", $sql_id);
}

/////////////// saadakse kõik read  desc  reastatult ///////////////

$sql_query = "SELECT ip,host,browser,language,date,tstamp,rowid FROM " . SQL_TABLE . " ORDER BY rowid DESC";

if (!($sql_res = @mysql_query($sql_query, $sql_id)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select", $sql_id);
}

/////////////// Saab numbrilised väärtused tabelist ///////////////

$sql_numrows = @mysql_num_rows($sql_res);

/////////////// Väljastab html koodi ///////////////

echo "<hr noshade><br>";
echo "<font size=\"" . STATS_FONT_SIZE1 . "\" face=\"" . STATS_FONT_FACE . "\"><b>" . $sql_numrows . " Klikki kokku</b></font><p></p>";

echo "<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#CCCCCC\">";
echo "<tr height=\"25\" bgcolor=\"#dddddd\">";
echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\"><b>Nr.</b></font></td>";
echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\"><b>Kuupäev | Kellaaeg</b></font></td>";
echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\"><b>IP</b></font></td>";
echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\"><b>Host</b></font></td>";
echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\"><b>Brauser</b></font></td>";
echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\"><b>Keel.</b></font></td>";
echo "</tr>";

$i = (-($sql_numrows)) - 1;

while ($sql_row = @mysql_fetch_array ($sql_res))
{
	$i++;
	
	if ((time() - $sql_row["tstamp"]) <= (STATS_HIGHLIGHT_TIME * 3600))
	{
		echo "<tr bgcolor=\"" . STATS_HIGHLIGHT_COLOR . "\">";
	}	
	else
	{
		echo "<tr>";
	}
	echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\">" . abs($i) ."</font></td>";
	echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\">" . $sql_row["date"] . "</font></td>";
	echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\">" . $sql_row["ip"] . "</font></td>";
	echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\">" . $sql_row["host"] . "</font></td>";
	echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\">" . $sql_row["browser"] . "</font></td>";
	echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\">" . $sql_row["language"] . "</font></td>";
	echo "</tr>";
}

echo "</table><br>";
echo "<font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\"><i>Klikke viimase " . STATS_HIGHLIGHT_TIME . " tunni jooksul on <font color=\"" . STATS_HIGHLIGHT_COLOR . "\"><b>näha ridades</b></font>.</i></font><p></p>";
echo "<hr noshade>";

/////////////// Lõpetab Mysql andmebaasiga ühenduse ///////////////

@mysql_close($sql_id);

return $sql_result;
}

// ==========================================================================================



function phphitsShowLastUsers()
{

/////////////// Set vars ///////////////

$sql_result = "";
$sql_numrows = 0;
$i = 0;

/////////////// Võtab ühendust mysql serveriga ///////////////

if (getenv ("HTTP_X_FORWARDED_FOR"))
{
	$u_ip = getenv ("HTTP_X_FORWARDED_FOR");
	$u_host = gethostbyaddr($u_ip);
}
else
{
	$u_ip = getenv ("REMOTE_ADDR");
	$u_host = gethostbyaddr($u_ip);
}



if (!($sql_id = @mysql_connect(SQL_HOST, SQL_USER, SQL_PWD)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_connect", $sql_id);
}

/////////////// Andmebaas aktiveeritakse ///////////////

if (!@mysql_select_db(SQL_DB, $sql_id))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select_db", $sql_id);
}

/////////////// saadakse kõik read  desc  reastatult ///////////////

$sql_query = "SELECT ip,host,browser,language,date,tstamp,rowid FROM " . SQL_TABLE . " where ip = '$u_ip'";

if (!($sql_res = @mysql_query($sql_query, $sql_id)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select", $sql_id);
}

/////////////// Saab numbrilised väärtused tabelist ///////////////

$sql_numrows = @mysql_num_rows($sql_res);

/////////////// Väljastab html koodi ///////////////

echo "<hr noshade><br>";
echo "<font size=\"" . STATS_FONT_SIZE1 . "\" face=\"" . STATS_FONT_FACE . "\"><b> Oled Teinud: " . $sql_numrows . " Klikki kokku 30 min jooksul.</b></font><p></p>";

echo "<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#CCCCCC\">";
echo "<tr height=\"25\" bgcolor=\"#dddddd\">";

echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\"><b>Kuupäev | Kellaaeg</b></font></td>";

echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\"><b>Host</b></font></td>";
echo "</tr>";





$i = (-($sql_numrows)) - 1;

while ($sql_row = @mysql_fetch_array ($sql_res))
{
	$i++;

	if ((time() - $sql_row["tstamp"]) <= (STATS_HIGHLIGHT_TIME * 3600))
	{
		echo "<tr bgcolor=\"" . STATS_HIGHLIGHT_COLOR . "\">";
	}
	else
	{
		echo "<tr>";
	}

	echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\">" . $sql_row["date"] . "</font></td>";
	echo "<td><font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\">" . $sql_row["host"] . "</font></td>";
	echo "</tr>";
}

echo "</table><br>";
echo "<font size=\"" . STATS_FONT_SIZE2 . "\" face=\"" . STATS_FONT_FACE . "\"><i>Klikke viimase " . STATS_HIGHLIGHT_TIME . " tunni jooksul on <font color=\"" . STATS_HIGHLIGHT_COLOR . "\"><b>näha ridades</b></font>.</i></font><p></p>";
echo "<hr noshade>";

/////////////// Lõpetab Mysql andmebaasiga ühenduse ///////////////

@mysql_close($sql_id);

return $sql_result;
}


////////////////////////// Funktsioon näitab kasutajaid hetkel  //////////////////////////

function phphitsShowOnlineUsers()
{

/////////////// Set vars ///////////////

$sql_result = "";
$sql_numrows = 0;
$imghtml = "";

/////////////// Võtab ühendust Mysql serveriga///////////////

if (!($sql_id = @mysql_connect(SQL_HOST, SQL_USER, SQL_PWD)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_connect", $sql_id);
}

/////////////// Aktiveerib andmebaasi ///////////////

if (!@mysql_select_db(SQL_DB, $sql_id))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select_db", $sql_id);
}

/////////////// Kõik ajatemplid reastatult desc ///////////////

$sql_query = "SELECT tstamp FROM " . SQL_TABLE . " ORDER BY rowid DESC";

if (!($sql_res = @mysql_query($sql_query, $sql_id)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select", $sql_id);
}

/////////////// Loeb klikke online ajas//////////////

$users_online = 0;

while ($sql_row = @mysql_fetch_array ($sql_res))
{
   if ((time() - $sql_row["tstamp"]) <= (COUNTER_USERONLINE_TIME * 60))
	{
		$users_online++;
	}	
}

/////////////// Lõpetab Mysql andmebaasiga suhtlemise///////////////

@mysql_close($sql_id);

if(COUNTER_MODE == 2)
{
	for($i = 0; $i < strlen($users_online); $i++)
	{
		$imghtml .= "<img src=\"" . COUNTER_IMG_SUBDIR . "/" . substr($users_online, $i, 1) . ".gif\" border=\"0\" align=\"absmiddle\">";
	}
	
	return $imghtml;
}
else
{
	return $users_online;
}	

}

// ==========================================================================================


////////////////////////////  Funktsioon, mis kuvab klikke /////////////////////////


function phphitsShowHits($c_time)
{

/////////////// Set vars ///////////////

$sql_result = "";
$sql_numrows = 0;
$hits = 0;
$imghtml = "";

/////////////// võtab ühendust mysql serveriga ///////////////

if (!($sql_id = @mysql_connect(SQL_HOST, SQL_USER, SQL_PWD)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_connect", $sql_id);
}

/////////////// Aktiveeritakse andmebaas ///////////////

if (!@mysql_select_db(SQL_DB, $sql_id))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select_db", $sql_id);
}

/////////////// Saadakse IP aadressid desc reastatud ///////////////

$sql_query = "SELECT ip,tstamp FROM " . SQL_TABLE . " ORDER BY rowid DESC";

if (!($sql_res = @mysql_query($sql_query, $sql_id)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select", $sql_id);
}

if ($c_time == 0)
{
	/////////////// Võtab read, milles on numbriline väärtus ///////////////

	$sql_numrows = @mysql_num_rows($sql_res);
	
	$hits = $sql_numrows + COUNTER_HITS_OFFSET;
}

else
{
	$c_time = abs($c_time * 3600);
	$hits_today = 0;

	while ($sql_row = @mysql_fetch_array ($sql_res))
	{
		if ((time() - $sql_row["tstamp"]) <= $c_time)
		{
			$hits_today++;
		}	
	}
	$hits = $hits_today;
}

/////////////// Mysql ühenduse lõpp ///////////////

@mysql_close($sql_id);

if (strlen($hits) < COUNTER_DIGITS)
{
	while ((strlen($hits)) < COUNTER_DIGITS)
	{
		$hits = "0" . $hits;
	} 
}

if(COUNTER_MODE == 2)
{
	for($i = 0; $i < strlen($hits); $i++)
	{
		$imghtml .= "<img src=\"" . COUNTER_IMG_SUBDIR . "/" . substr($hits, $i, 1) . ".gif\" border=\"0\" align=\"absmiddle\">";
	}
	
	return $imghtml;
}
else
{
	return $hits;
}

}

// ==========================================================================================

//////////////////////  Funktsioon mis teeb counterile reseti //////////////////////////

function phphitsResetCounter()
{

/////////////// Set vars ///////////////

$sql_result = "";
$sql_numrows = 0;

/////////////// Mysql ühenduse loomine ///////////////

if (!($sql_id = @mysql_connect(SQL_HOST, SQL_USER, SQL_PWD)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_connect", $sql_id);
}

/////////////// Andmebaasi aktiveerimine ///////////////

if (!@mysql_select_db(SQL_DB, $sql_id))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_select_db", $sql_id);
}

/////////////// Kustutab tabeli ///////////////

$sql_query = "DROP TABLE " . SQL_TABLE;

if (!($sql_res = @mysql_query($sql_query, $sql_id)))
{
	if (SQL_SHOW_ERRORS <> 0) phphitsShowErrorMsg("mysql_drop", $sql_id);
}

/////////////// Väljastab htmlina ///////////////

echo "<hr noshade>";
echo "<font size=\"" . STATS_FONT_SIZE1 . "\" face=\"" . STATS_FONT_FACE . "\"><b>Counterile tehti reset</b></font>";
echo "<hr noshade>";

/////////////// Mysql ühenduse lõpp ///////////////

@mysql_close($sql_id);
}

// ==========================================================================================

function phphitsShowErrorMsg($err, $id)
{
 ///////////////////////// juhul kui tulevad  sisse vead käsitletakse neid case-des /////////////
switch ($err)
{
	case "mysql_connect":
		$msg[1] = "Ei suuda võtta ühendust Mysql-iga";
		$msg[3] = "Kontrolli mysql seadistusi, kasutajanime ja parooli! ";
		break;
	case "mysql_select_db":
		$msg[1] = "Ei suuda Mysql aktiveerida";
		$msg[3] = "Kas  andmebaas on õige";
		break;
	case "mysql_select":
		$msg[1] = "Ei suuda teha päringut Mysqli";
		$msg[3] = "Kontrolli kas mysql andmebaasinimi on korrektne.";
		break;		
	case "mysql_insert":
		$msg[1] = "Eiõnnestu lisada uusi ridu";
		$msg[3] = "Kontrolli Mysql seadistusi.";
		break;
	case "mysql_drop":
		$msg[1] = "Ei õnnestu kustutada tabelit.";
		$msg[3] = "Kontrolli Mysql seadistusi.";
		break;
	default:
		$msg[1] = "Mysqli viga";
		$msg[3] = "Kontrolli Mysql seadistusi. ";
		break;
}

if (@mysql_error($id) <> "")
{
	$msg[2] = @mysql_error($id);
}
else
{
	$msg[2] = "Unknown";
}

die("<hr><font color=\"#ff0000\"><b>" . $msg[1] . "</b><br>Põhjus: " . $msg[2] . "<p></p>" . $msg[3] . "</font><hr><br>");
}

?>