|
$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";
}
}
?>
|
|
Unser Repertoire ist sehr breit gefächert und erstreckt sich von aktueller Pop- und Rockmusik über Schlager, Oldies Blas- und Stimmungsmusik bis hin zu volkstümlichen Hits. Um auch Frühschoppen und Marschmusik in bester Qualität anbieten zu können, haben wir die Möglichkeit, auf personelle Verstärkung bei den Blasinstumenten zurückzugreifen zu kömmen.
// 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 ]
|
|
|