| 
               
                
                                                            
                
                 
               
               
$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";
     }
   }
?>  
               
  
                | 
                 | 
               
               
               
                
               
                 
                   
                   
	
		
		
			
		
			
		
			
		
			Geburtstag: 27.06. Sternzeichen: Krebs
 
Instrument: Bass-Gitarre, Tuba, Gesang 
		
			  
		
			
	
		
                    
                   
// 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 ]
                   
  
                    | 
                  
                
               
                | 
                 |