| 
               
                
                                       
                
                 
               
               
$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 ]
                   
  
                    | 
                  
                
               
                | 
                 |