<?php
// getSaltMD5()
// sendMail($mail_subject,$mail_text,$mail_recipient)
// sendMailFrom($from_mail, $mail_subject,$mail_text,$mail_recipient)
// getEmail($userid)
// getTeamEmail($SAISON,$TEAMID)
// mailExist($userid)
// GetSaisonSym($SAISON)								                // shows the Saison like 07/08
// GetSaison($MONTH)									                  // gibt die aktuelle Saison zurück
// GetSaisonPath($PATH,$MONT)						   	            // gibt die aktuelle Saison zurück, aber wird nicht vom Home aufgerufen
// GetResultLink($Saison, $shv_grp_id, $shv_team_id)   	// gibt den Link zu den Resultaten zurück von der SHV Page
// TextAbschneiden($Text, $Laenge)
// getDatum($datum)
// getSmallDatum($datum) 
// getTime($datum)
// LocationLink($LINK)
// GetWeekday($DAY)
// GetMonthName($MONTH)
// GetGameTyp($TYP)
// getGameTypeHTML($TYP)
// SetPageCount($PAGE)
// GetPageCount($PAGE)
// GetSetPageCount($PAGE)
// SetMaxMinImageSize($BILD,$MAXBREITE,$MAXHOEHE)
// getErrorMsg($STATUS,$MSG)
// getStatusMatchName($g_status,$name)
// getUserStatusName($status)
// setLocationGym($name,$strasse,$strNr,$plz,$ort,$land)
// setLocationOffice($name,$strasse,$strNr,$plz,$ort,$land)
// setLocationFreetime($name,$strasse,$strNr,$plz,$ort,$land)
//   setLocation($typ,$name,$strasse,$strNr,$plz,$ort,$land)
// insertNewLocation($loc_typ, $loc_name, $strasse, $str_nr, $plz, $ort, $land, $kontakt, $tel, $email, $besch, $link)
// getResultColored($heimteam, $heimscore, $gastscore)

//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%


	if(preg_match("/\/TEST\//",$_SERVER["PHP_SELF"] ))
	{
	  $ENV="TEST";
	} 
	else 
	{				        
      $ENV="";
	}			
	$SAISON = GetSaison(4); // 7 = Juli = sieben Monate lang soll die Saison im neuen Jahr angezeigt werden
	$SAISON_ORIG = GetSaisonSym($SAISON);
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
        
       function getSaltMD5(){
             return "Seen Tigers braucht Salz, zum PWD zu schützten";
       }
 	
	//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	      
	function sendMail($mail_subject,$mail_text,$mail_recipient)
	{
		return sendMailFrom("info@seen-tigers.ch",$mail_subject,$mail_text, $mail_recipient);
	}
	
	function sendMailFrom($from_mail, $mail_subject,$mail_text,$mail_recipient)
	{
		// *** Kontaktadresse für Missbrauchsmeldungen ***
		$Abuse_Mail="webmaster@seen-tigers.ch";
		
		$header ="From: ".$from_mail."\n"; //<".$from_mail.">
		$header.="Reply-To: ".$from_mailh."\n";
  		$header.="X-Abuse-Mail: <".$Abuse_Mail.">\n";
		$header.="X-Mailer: PHP-FormMailer (www.gaijin.at)\n";
		$header.="Content-Type: text/html \n";

		return mail($mail_recipient,$mail_subject,$mail_text,$header);

	}
		
	//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	function getEmail($userid){
		//DB-Verbindung aufbauen
		include("/home/www/web54/html/SeenTigers/TOOLS/DB/seentigers_db_connect.php");
		
		$ResultPointer=mysql_query("SELECT email_a,email_b FROM `ADDRESS` WHERE `user_id`='".$userid."' ORDER BY `changetime` DESC LIMIT 1", $DatabasePointer);
		$Email=mysql_fetch_object($ResultPointer);
		
		$email="";
		if(ereg("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,6})$",trim($Email->email_a))){
			$email=$Email->email_a;
		} 
		if (ereg("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,6})$",trim($Email->email_b))) {
			if(!empty($email)){ $email.=","; }
			$email.=$Email->email_b;
		} 
		return $email;							
	}
	
	//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	function getTeamEmail($SAISON,$TEAMID)
	{
		$SAISON=trim(mysql_real_escape_string(stripslashes($SAISON)));
		$TEAMID=trim(mysql_real_escape_string(stripslashes($TEAMID)));
		
		//DB-Verbindung aufbauen
		include("/home/www/web54/html/SeenTigers/TOOLS/DB/seentigers_db_connect.php");
		$dl = "";
		
		$SQL = "SELECT u.user_id AS user_id 
		        FROM USERS u JOIN TRIGGER_USER_TEAM t ON u.user_id=t.user_id
						WHERE saison='".$SAISON."'
				  AND team_id='".$TEAMID."'";
		$ResultPointer=mysql_query($SQL, $DatabasePointer);
		$ctr = mysql_num_rows($ResultPointer);
		
	    if( $ctr > 0 )
	    {
		  	// Dateien
		  	for($i=0; $ctr > $i; $i++ )
		  	{
				$p=mysql_fetch_object($ResultPointer);
				if(!empty($dl)){ $dl.=","; }
				$dl .= getEmail($p->user_id);
			}
		}
		
		return $dl;
	}
	//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	function mailExist($userid)
	{
		//DB-Verbindung aufbauen
		include("/home/www/web54/html/SeenTigers/TOOLS/DB/seentigers_db_connect.php");
		
		$out = true;
		$email = getEmail($userid);
		if( empty( $email ) ) { $out = false; }
			
		return $out;

		include("/home/www/web54/html/SeenTigers/TOOLS/DB/seentigers_db_disconnect.php");
	}
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	function GetSaisonSym($SAISON){
		$NEXT=$SAISON+1;
		return substr($SAISON,-2)."/".substr($NEXT,-2);		
	}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	// get the link from the SHV with all results
	function GetResultLink($Saison, $shv_grp_id, $shv_team_id){
		return "http://vvs.handball.ch/vvs/resultatanzeige.asp?Team=".$shv_team_id."&DatumVon=&DatumBis=&AuswahlGruppe=AktGruppe&Submit=Anzeigen&Gruppe=".$shv_grp_id."&Saison=".$Saison;
	}
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	// get the link from the SHV with all results
	function GetSaison($MONTH)
	{ 
		return GetSaisonPath("/home/www/web54/html/SeenTigers/".$ENV."/", $MONTH);
	}
	//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	function GetSaisonPath($PATH,$MONTH){
		//DB-Verbindung aufbauen
		$DB_CONN=@mysql_ping($DatabasePointer);
		if (!$DB_CONN) {
			include($PATH."TOOLS/DB/seentigers_db_connect.php");
		}
		
		// VARIABLEN
		$MONTS=$MONTH; // 7 = JUNI = sieben Monate lang soll die Saison im neuen Jahr angezeigt werden
			
		$tomorrow = mktime(0,0,0,date("m")-$MONTS,date("d"),date("Y"));
		$AKTUELLE_SAISON=date("Y", $tomorrow);			
			
		$HelpPointer=mysql_query("SELECT DISTINCT saison as saisons FROM TEAM ORDER BY saison DESC", $DatabasePointer);
		$SAISONS=mysql_fetch_object($HelpPointer);
		$SAISON_TRG=$SAISONS->saisons;
			
		// DEFAULT Saison setzten
		$SHOW_SAISON=$AKTUELLE_SAISON;
		if ( $SAISON_TRG != $AKTUELLE_SAISON  ){
			if ( $SAISON_TRG < $AKTUELLE_SAISON  ){
				// es gibt noch keine neue Saison in der DB, daher zeig die letzte Saison
				$SHOW_SAISON=$SAISON_TRG;
			}else{
				$SAISON_COUNTER=$AKTUELLE_SAISON;
				$i=20; //max Anzahl Saisons, die in die Vergangenheit gesucht werden soll
				while($SAISON_COUNTER != $SAISON_COUNTER && $i!=0)
				{ 
					if($AKTUELLE_SAISON  == $SAISON_COUNTER){
						$SHOW_SAISON=$SAISON_COUNTER ;
					}
					$SAISON_COUNTER --;
					$i--;
				}
			}
				
		}
		else
		{
			//aktuelle Saison ist auch die neuste
			$SHOW_SAISON=$AKTUELLE_SAISON;
		}	
		
		return $SHOW_SAISON;	
			
		//DB-Verbindung abbrechen, falls sie nicht vorhanden war
		if($DB_CONN){
			include($PATH."TOOLS/DB/seentigers_db_disconnect.php");	
		}			
	}
	

//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
// Text auf eine bestimmte länge kürzen	
	function TextAbschneiden($Text, $Laenge){
		
		if ( strlen($Text) < $Laenge+1 ){
			return $Text;
		}
		else{
			return substr($Text, 0, strpos(wordwrap($Text, $Laenge, "*!U-M-B-R-U-C-H*"), "*!U-M-B-R-U-C-H*"));
		} 
		
		
	}	
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

	function getDatum($datum){
		$array = explode(" ",$datum); 
		$day_array = explode("-",$array[0]); 
		$DATUM = $day_array[2].'.'.$day_array[1].'.'.$day_array[0];
		if($DATUM == ".."){
			$DATUM="";
		}
		return preg_replace('/^[.][.]/', '',$DATUM);
	}

	function getSmallDatum($datum){
		$tag = explode(" ",$datum); 
		$array = explode("-",$tag[0]); 
		$DATUM = $array[2].'.'.$array[1].'.'.substr($datum, 2, 2);
		return $DATUM;
	}
	
	function getTime($datum)
	{
		if( preg_match("/^[0-2][0-9][:][0-5][0-9][:][0-5][0-9]$/",$datum ))
		{ 
			return preg_replace("/^([0-2][0-9][:][0-5][0-9])[:][0-5][0-9]$/", "$1", $datum );
		}
		else
		{
			$array = explode(" ",$datum); 
			$time_array = explode(":",$array[1]); 
			$TIME = $time_array[0].'.'.$time_array[1];
			return $TIME;
		}
	}
	
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	
	function LocationLink($LINK){
		if ( substr_count($LINK, 'map.maponair.com') == '1' ){
			return "javascript:Openwin('".$LINK."','Hallenplan',650,680)";
		} else {
			return $LINK."\" target=\"_blank";
		}
	
	}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	function GetWeekday($DAY){
		$WEEKDAY="";	
		switch($DAY){
		case "1":
			$WEEKDAY="Mo";	
			break;		
		case "2":
			$WEEKDAY="Di";	
			break;		
		case "3":
			$WEEKDAY="Mi";	
			break;		
		case "4":
			$WEEKDAY="Do";	
			break;		
		case "5":
			$WEEKDAY="Fr";	
			break;		
		case "6":
			$WEEKDAY="Sa";	
			break;		
		case "0":
			$WEEKDAY="So";	
			break;				
		case "7":
			$WEEKDAY="So";	
			break;		
		case "*":
			$WEEKDAY="tbd";	
			break;		
		}//switch...	
		
		return $WEEKDAY;
	}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	function GetMonthName($MONTH)
	{
		$MONTH_NAME="";	
		switch($DAY){
		case "1":
			$MONTH_NAME="Januar";	
			break;		
		case "2":
			$MONTH_NAME="Februar";	
			break;		
		case "3":
			$MONTH_NAME="März";	
			break;		
		case "4":
			$MONTH_NAME="April";	
			break;		
		case "5":
			$MONTH_NAME="Mai";	
			break;		
		case "6":
			$MONTH_NAME="Juni";	
			break;		
		case "7":
			$MONTH_NAME="Juli";	
			break;				
		case "8":
			$MONTH_NAME="August";	
			break;		
		case "9":
			$MONTH_NAME="September";	
			break;		
		case "10":
			$MONTH_NAME="Oktober";	
			break;		
		case "11":
			$MONTH_NAME="November";	
			break;		
		case "12":
			$MONTH_NAME="Dezember";	
			break;		
		case "*":
			$MONTH_NAME="";	
		}//switch...	
		
		return $MONTH_NAME;
	
	}
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	function getGameTypeHTML($typ)
	{
		switch (strtolower($typ)) {
		case 'ts':
			return '<a title="Trainingsspiel">'.strtoupper($typ).'</a>';
			break;
		case 'cp':
			return '<a title="Cupspiel">'.strtoupper($typ).'</a>';
			break;
		case 'ms':
			return '<a title="Meisterschaftsspiel">'.strtoupper($typ).'</a>';
			break;
		}
		return '<a title="">'.strtoupper($typ).'</a>';
	}

	function GetGameTyp($TYP){
		$SPIELTYP="";
		switch($TYP){
		case "MS":
			$SPIELTYP="Meisterschaft";	
			break;		
		case "TS":
			$SPIELTYP="Training";	
			break;		
		case "CP":
			$SPIELTYP="Cup";	
			break;		
		}//switch...
		return $SPIELTYP;
	}
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

	function SetPageCount($PAGE){
		// ip-protection in seconds
		$counter_expire = 3600;
	
		//DB-Verbindung aufbauen
		$DB_CONN=@mysql_ping($DatabasePointer);
		if (!$DB_CONN) {
			include("TOOLS/DB/seentigers_db_connect.php");
		}
		
		// get counter information
	   $sql = "select * from counter_values WHERE page_name='".$PAGE."'";
	   $res = mysql_query($sql);
	   
	   // fill when empty
	   if (mysql_num_rows($res) == 0)
	   {	  
		  $sql = "INSERT INTO `counter_values` (`id`,`page_name` ,`day_id`, `day_value`, `week_id`, `week_value`, `month_id`, `month_value`, `year_id`, `year_value`, `all_value`, `record_date`, `record_value`) VALUES ('1','".$PAGE."', '" . date("z") . "',  '0', '" . date("W") . "', '0', '" . date("n") . "', '0', '" . date("Y") . "',  '0',  '0',  NOW(),  '0')";
		  mysql_query($sql);
	
		  $sql = "select * from counter_values WHERE page_name='".$PAGE."'";
		  $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' AND page_name='".$PAGE."'";
		  $res = mysql_query($sql);
		  if (mysql_num_rows($res) == 0)
		  {
			 // insert
			 $sql = "INSERT INTO counter_ips (ip, page_name, visit) VALUES ('$counter_ip','".$PAGE."' , NOW())";
			 mysql_query($sql);
		  }
		  else
		  {
			 $ignore = true;
			 $sql = "update counter_ips set visit = NOW() where ip = '$counter_ip' AND page_name='".$PAGE."'";
			 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 AND page_name='".$PAGE."'";
		  mysql_query($sql);  
	   }	  			
	   	
		
		//DB-Verbindung abbrechen, falls sie nicht vorhanden war
		if($DB_CONN){
			include("TOOLS/DB/seentigers_db_disconnect.php");	
		}			 
	}
	
// -------------------------------------------------------------------	

	function SetPageCount2($PAGE,$DB){
		// ip-protection in seconds
		$counter_expire = 3600;
	
		//DB-Verbindung aufbauen
		$DB_CONN=@mysql_ping($DB);
		if ( $DB_CONN) {
		
				// get counter information
			   $sql = "select * from counter_values WHERE page_name='".$PAGE."'";
			   $res = mysql_query($sql);
			   
			   // fill when empty
			   if (mysql_num_rows($res) == 0)
			   {	  
				  $sql = "INSERT INTO `counter_values` (`id`,`page_name` ,`day_id`, `day_value`, `week_id`, `week_value`, `month_id`, `month_value`, `year_id`, `year_value`, `all_value`, `record_date`, `record_value`) VALUES ('1','".$PAGE."', '" . date("z") . "',  '0', '" . date("W") . "', '0', '" . date("n") . "', '0', '" . date("Y") . "',  '0',  '0',  NOW(),  '0')";
				  mysql_query($sql);
			
				  $sql = "select * from counter_values WHERE page_name='".$PAGE."'";
				  $res = mysql_query($sql,$DB);
				  
				  $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,$DB);
			   }
				  
			   // check for entry
			   if ($ignore == false)
			   {
				  $sql = "select * from counter_ips where ip = '$counter_ip' AND page_name='".$PAGE."'";
				  $res = mysql_query($sql,$DB);
				  if (mysql_num_rows($res) == 0)
				  {
					 // insert
					 $sql = "INSERT INTO counter_ips (ip, page_name, visit) VALUES ('$counter_ip','".$PAGE."' , NOW())";
					 mysql_query($sql,$DB);
				  }
				  else
				  {
					 $ignore = true;
					 $sql = "update counter_ips set visit = NOW() where ip = '$counter_ip' AND page_name='".$PAGE."'";
					 mysql_query($sql,$DB);
				  }
			   }
			   
			   // online?
			   $sql = "select * from counter_ips";
			   $res = mysql_query($sql,$DB);
			   $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 AND page_name='".$PAGE."'";
				  mysql_query($sql,$DB);  
			   }	  			
	   	}
				 
	}
	
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	function GetPageCount($PAGE){	
		//DB-Verbindung aufbauen
		$DB_CONN=@mysql_ping($DatabasePointer);
		if (!$DB_CONN) {
			include("TOOLS/DB/seentigers_db_connect.php");
		}
			  
		// get counter information
		$sql = "select * from counter_values WHERE page_name='".$PAGE."'";
		$res = mysql_query($sql);
		$PC_COUNT=mysql_fetch_object($res);
		if( mysql_num_rows($res) < 1 ){
			return 0;
		} else {
			return $PC_COUNT->all_value;
		}			
		
		//DB-Verbindung abbrechen, falls sie nicht vorhanden war
		if($DB_CONN){
			include("TOOLS/DB/seentigers_db_disconnect.php");	
		}		
	}
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	
	function GetSetPageCount($PAGE){	
		// Set Pagecount
		SetPageCount($PAGE);
	
		//DB-Verbindung aufbauen
		$DB_CONN=@mysql_ping($DatabasePointer);
		if (!$DB_CONN) {
			include("TOOLS/DB/seentigers_db_connect.php");
		}
			  
		// get counter information
		$sql = "select * from counter_values WHERE page_name='".$PAGE."'";
		$res = mysql_query($sql);
		$PC_COUNT=mysql_fetch_object($res);
		if( mysql_num_rows($res) < 1 ){
			return 0;
		} else {
			return $PC_COUNT->all_value;
		}			
		
		//DB-Verbindung abbrechen, falls sie nicht vorhanden war
		if($DB_CONN){
			include("TOOLS/DB/seentigers_db_disconnect.php");	
		}		
	}

//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

	function SetMaxMinImageSize($BILD,$MAXBREITE,$MAXHOEHE){	
		
			$result[0]=$MAXBREITE;
			$result[1]=$MAXHOEHE;
			
		if (is_file($BILD)){
			/*getimagesize*/
			$getimagesize = getimagesize($BILD);
			$B = $getimagesize[0];
			$H = $getimagesize[1];	
			
			/*imagecopyresized*/
			if($B >= $MAXBREITE)
			{
				$v = $H / $B;
				$H = round($MAXBREITE * $v);
				$B = $MAXBREITE;
			}
			if($H >= $MAXHOEHE)
			{
				$v =  $B / $H;
				$B = round($MAXHOEHE * $v);
				$H = $MAXHOEHE;
			}	
			$result[0]=$B;
			$result[1]=$H;
		}
		return $result;
	}
	
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

	
	function getErrorMsg($STATUS,$MSG){	
			/*
				0: nichts verändert  --> Fehler
				1: OK
				2: Warnung/Info		
				3: Fehler		
			*/
			$msg_table="";
			
			if($STATUS!=99999 && !empty($STATUS) ){
				$msg_table="";
				switch($STATUS){
					case 0:
						$color='background-color:#FFCC99; border:1px solid #FF0000;';
						break;
					case 3:													
						$color='background-color:#FFCC99; border:1px solid #FF0000;';
						break;
					case 1:
						$color='background-color:#66FF66; border:1px solid #339900;';
						break;
					case 2:
						$color='background-color:#FFFF00; border:1px solid #FFCC00;';
						break;
				}
				$msg_table='<table id="errTable"><tr><td>';
				$msg_table.='<div id="errDiv" style="'.$color.'" >';
				$msg_table.=$MSG;
				$msg_table.='</div></td></tr></table>';
			}			
			
			return $msg_table;
	}	
	
	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

	
	 $USTAT_AKTIV=0;
	 $USTAT_AKTIV_JUNIOR=10;
	 $USTAT_STAFF=20;
	 $USTAT_AKTIV_EXTERN=200;
	 $USTAT_PASSIV=1;
	 $USTAT_AUSGETRETEN=2;
	 $USTAT_EHRENMITGLIED=3;
	 $USTAT_VIP95=4;
	 $USTAT_INFO=5;
	 $USTAT_GAST=6;
	 $USTAT_VERSTORBEN=666;

	
	function getStatusMatchName($status,$name)
	{
		$isTrue=false;
				
		if( getUserStatusName($status) == $name ) 
		{ 
				$isTrue=true; 
		} 
		else 
		{ 
				$isTrue=false; 
		}
				
		return $isTrue;
	}

  function getAllUserStatus()
  {
		extract($GLOBALS);
  	
		$STATUS_DB[$USTAT_AKTIV] ="Aktiv";				
		$STATUS_DB[$USTAT_AKTIV_JUNIOR]="Aktiv/Junior";		
		$STATUS_DB[$USTAT_AKTIV_EXTERN] ="Aktiv/Externer Verein";
		$STATUS_DB[$USTAT_STAFF] ="Trainer/Team-Staff";	
		$STATUS_DB[$USTAT_PASSIV] ="Passiv";			
		$STATUS_DB[$USTAT_AUSGETRETEN] ="Ausgetreten";	
		$STATUS_DB[$USTAT_EHRENMITGLIED] ="Ehrenmitglied";
		$STATUS_DB[$USTAT_VIP95] ="VIP95";			
		$STATUS_DB[$USTAT_INFO] ="Info-Account";			
		$STATUS_DB[$USTAT_GAST] ="Gast-Account";			
		$STATUS_DB[$USTAT_VERSTORBEN] ="Verstorben";	
		
		/* Firma
		$STATUS_DB[100] ="Aktiver Sponsor"; 	
		$STATUS_DB[101] ="Passiver Sponsor";	
		$STATUS_DB[102] ="Ehemaliger Sponsor";	
		$STATUS_DB[106] ="Firma Aufgelöst";	*/
		
		return $STATUS_DB;
  }

	function getUserStatusName($status)
	{
		$STATUS_DB = getAllUserStatus();		
		
		return $STATUS_DB[$status];
	}

//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%


	function setLocationGym($name,$strasse,$strNr,$plz,$ort,$land)
	{
		  return setLocation('h',$name,$strasse,$strNr,$plz,$ort,$land);
	}

	function setLocationOffice($name,$strasse,$strNr,$plz,$ort,$land)
	{
		  return setLocation('g',$name,$strasse,$strNr,$plz,$ort,$land);
	}

	function setLocationFreetime($name,$strasse,$strNr,$plz,$ort,$land)
	{
		  return setLocation('f',$name,$strasse,$strNr,$plz,$ort,$land);
	}
	
	function setLocation($typ, $name,$strasse,$strNr,$plz,$ort,$land)
	{
			include("/home/www/web54/html/SeenTigers/TOOLS/DB/seentigers_db_connect.php");
			
		  $query="SELECT * FROM LOCATION 
		          WHERE LOWER(strasse)='".strtolower($strasse)."' 
		            AND LOWER(str_nr) LIKE '%".strtolower($strNr)."%' 
		            AND ( LOWER(plz)='".strtolower($plz)."' OR LOWER(ort)='".strtolower($ort)."' )";
			$Pointer=mysql_query($query, $DatabasePointer);
			
			$link="http://maps.google.com/maps?f=q&hl=de&q=".urlencode($strasse)."+".urlencode($strNr).",".urlencode($plz).",".urlencode($ort).",".urlencode($land);
			
			
			if(mysql_num_rows($Pointer)>0)
			{
		        $HALLE=mysql_fetch_object($Pointer);
		        $ID=$HALLE->location_id;
		  } 
			else 
			{																	     
				$ID = insertNewLocation($typ, $name, $strasse, $strNr, $plz, $ort, $land,'', '', '', '', $link);			
		 	}
			
			// ID von Halle zurück geben
			return $ID;
	}
	
	
	//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	/*
	*  insert a Location
	*/
	function insertNewLocation($loc_typ, $loc_name, $strasse, $str_nr, $plz, $ort, $land, $kontakt, $tel, $email, $besch, $link)
	{
			include("/home/www/web54/html/SeenTigers/TOOLS/DB/seentigers_db_connect.php");
			$besch = str_replace("'", "\'", $besch);
			$ID='';		
			if(!empty($loc_name) && !empty($strasse) && !empty($str_nr) && !empty($plz) )	
			{		
				$SQL = "INSERT INTO LOCATION( location_typ, location_name, strasse, str_nr, plz, ort, land, kontakt, tel, email, beschreibung, link) 
				        VALUES('".$loc_typ."','".$loc_name."','".$strasse."','".$str_nr."','".$plz."','".$ort."','".$land."','".$kontakt."','".$tel."','".$email."','".$besch."','".$link."')";
				mysql_query($SQL, $DatabasePointer);
				$ID = mysql_insert_id($DatabasePointer);
				echo "INSERTED: $ID       $SQL";
			}
			
			return $ID;
	}

//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

	function getResultColored($heimteam, $heimscore, $gastscore)
	{
		
		if(empty($heimteam))
		{
			return $heimscore.':'.$gastscore;
		}
		else
		{
			if(substr_count(strtolower($heimteam),'seen') !=0 )
			{
				$COLOR=calcColor($heimscore, $gastscore);
			} 
			else 
			{
				$COLOR=calcColor($gastscore, $heimscore);	
			}
		}
		return '<a style="font-weight:bold; color:'.$COLOR.'">'.$heimscore.':'.$gastscore.'</a>';
	}

	function calcColor($st, $gegner)
	{
		$BLAU = "#0000FF";
		$ROT = "#FF0000";
		$GRUEN = "#009900";
		$COLOR = "";
		if($st > $gegner){ $COLOR=$GRUEN; }
		elseif($st == $gegner){ $COLOR=$BLAU; }
		elseif($st < $gegner){ $COLOR=$ROT; }
		
		return $COLOR;
	}

//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
	

?>