|
$id = 0;
// $id = $_GET['id'];
$counter_expire = 1200; // ip-protection in seconds
$counter_connected = true;
// require('typo3conf/localconf.php');
require('/home/marodayh/www.marcant-music.com/typo3conf/localconf.php');
$link = @mysql_connect($typo_db_host, $typo_db_username, $typo_db_password);
if (!$link)
{
$counter_connected = false;
echo "Counter: " . mysql_error();
}
else
{
$db_selected = @mysql_select_db($typo_db, $link);
if (!$db_selected)
{
$counter_connected = false;
echo "Counter: " . mysql_error();
}
}
if ($counter_connected == true)
{
$ignore = false;
// get counter information
$sql = "select * from counter_values";
$res = mysql_query($sql);
// fill when empty
if (mysql_num_rows($res) == 0)
{
$sql = "INSERT INTO `counter_values` (`id`, `day_id`, `day_value`, `week_id`, `week_value`, `month_id`, `month_value`, `year_id`, `year_value`, `all_value`, `record_date`, `record_value`) VALUES ('1', '" . date("z") . "', '1', '" . date("W") . "', '1', '" . date("n") . "', '1', '" . date("Y") . "', '1', '1', NOW(), '1')";
mysql_query($sql);
$sql = "select * from counter_values";
$res = mysql_query($sql);
$ignore = true;
}
$row = mysql_fetch_assoc($res);
$day_id = $row['day_id'];
$day_value = $row['day_value'];
$week_id = $row['week_id'];
$week_value = $row['week_value'];
$month_id = $row['month_id'];
$month_value = $row['month_value'];
$year_id = $row['year_id'];
$year_value = $row['year_value'];
$all_value = $row['all_value'];
$record_date = $row['record_date'];
$record_value = $row['record_value'];
$counter_agent = (isset($_SERVER['HTTP_USER_AGENT'])) ? addslashes(trim($_SERVER['HTTP_USER_AGENT'])) : "";
$counter_time = time();
$counter_ip = trim(addslashes($_SERVER['REMOTE_ADDR']));
// ignorore some bots
if (substr_count($counter_agent, "bot") > 0)
$ignore = true;
// delete free ips
if ($ignore == false)
{
$sql = "delete from counter_ips where unix_timestamp(NOW())-unix_timestamp(visit) > $counter_expire";
mysql_query($sql);
}
// check for entry
if ($ignore == false)
{
$sql = "select * from counter_ips where ip = '$counter_ip'";
$res = mysql_query($sql);
if (mysql_num_rows($res) == 0)
{
// insert
$sql = "INSERT INTO counter_ips (ip, visit) VALUES ('$counter_ip', NOW())";
mysql_query($sql);
}
else
{
$ignore = true;
$sql = "update counter_ips set visit = NOW() where ip = '$counter_ip'";
mysql_query($sql);
}
}
// online?
$sql = "select * from counter_ips";
$res = mysql_query($sql);
$online = mysql_num_rows($res);
// add counter
if ($ignore == false)
{
// day
if ($day_id == date("z"))
{
$day_value++;
}
else
{
$day_value = 1;
$day_id = date("z");
}
// week
if ($week_id == date("W"))
{
$week_value++;
}
else
{
$week_value = 1;
$week_id = date("W");
}
// month
if ($month_id == date("n"))
{
$month_value++;
}
else
{
$month_value = 1;
$month_id = date("n");
}
// year
if ($year_id == date("Y"))
{
$year_value++;
}
else
{
$year_value = 1;
$year_id = date("Y");
}
// all
$all_value++;
// neuer record?
if ($day_value > $record_value)
{
$record_value = $day_value;
$record_date = date("Y-m-d H:i:s");
}
// speichern und aufräumen
$sql = "update counter_values set day_id = '$day_id', day_value = '$day_value', week_id = '$week_id', week_value = '$week_value', month_id = '$month_id', month_value = '$month_value', year_id = '$year_id', year_value = '$year_value', all_value = '$all_value', record_date = '$record_date', record_value = '$record_value' where id = 1";
mysql_query($sql);
}
if($id==13) // auf kontaktseite vollständige anzeige
{
?>
Besucherstatistik |
» echo $online; ?> Online
» echo $day_value; ?> Heute
» echo $week_value; ?> diese Woche
» echo $month_value; ?> diesen Monat
» echo $year_value; ?> dieses Jahr
» echo $all_value; ?> seit 27.02.2004
Rekord: echo $record_value; ?> am echo date("d.m.Y", strtotime($record_date)) ?>
|
}
else
{
echo " Besucher: $all_value (seit 27.02.04)\n";
}
}
?>
|
|
Christian Höppner Plan 13 37359 Effelder
Tel 036075-54159 Tel 036024-80084 Mobil 0172/7982780 info@marcant-music.com
// require('typo3conf/localconf.php');
require('/home/marodayh/www.marcant-music.com/typo3conf/localconf.php');
$connect = mysql_connect($typo_db_host, $typo_db_username, $typo_db_password);
$heute = date("Y-m-d");
if($connect)
{
$sql = "SELECT * FROM event_info WHERE ((date>='$heute')AND(status=1)) ORDER BY date";
$ergebnis = mysql_db_query($typo_db, $sql, $connect);
if($ergebnis)
{
$zeile = mysql_fetch_row($ergebnis);
$eid = $zeile[0];
$lid = $zeile[1];
$date = $zeile[2];
$time = $zeile[3];
$teaser = $zeile[4];
$text = $zeile[5];
// $status = $zeile[6];
$sql2 = "SELECT * FROM event_location WHERE lid='$lid'";
$ergebnis2 = mysql_db_query($typo_db, $sql2, $connect);
$zeile2 = mysql_fetch_row($ergebnis2);
// $lid = $zeile2[0];
$city = $zeile2[1];
$location = $zeile2[2];
$address = $zeile2[3];
$web = $zeile2[4];
$lon = $zeile2[5];
$lat = $zeile2[6];
// $status = $zeile2[7];
$t = substr($date,8,2);
$m = substr($date,5,2);
$j = substr($date,2,2);
$datum = $t.".".$m.".".$j;
if($date==$heute) $datum = "heute";
echo "\n";
}
}
?>
[ zurück ]
|
|
|