<?
require("../db_config_hornusse.php"); 
$db=mysql_connect($db_host, $db_user, $db_pass) or die ("Die Verbindung konnte nicht hergestellt werden");
mysql_select_db($db_name, $db);
header('Content-Type: text/x-csv');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Content-Disposition: attachment; filename=Bieri Christian.csv');
header('Pragma: no-cache');


$Exportt = ""; 

	$Titel[] = str_replace("\"", "\"\"", SpielDatum);
    $Titel[] = str_replace("\"", "\"\"", Anlass);
	$Titel[] = str_replace("\"", "\"\"", Gegner);	
 	$Titel[] = str_replace("\"", "\"\"", Ort);
	$Titel[] = str_replace("\"", "\"\"", R1);
	$Titel[] = str_replace("\"", "\"\"", R2);
	$Titel[] = str_replace("\"", "\"\"", R3);
	$Titel[] = str_replace("\"", "\"\"", R4);
	$Titel[] = str_replace("\"", "\"\"", R5);
	$Titel[] = str_replace("\"", "\"\"", R6);
	$Titel[] = str_replace("\"", "\"\"", Rangpunkte);

    
    for($j = 0; $j < count($Titel); $j++)
    {
        $Exportt .= "\"" . $Titel[$j] . "\"";

        if($j != count($Titel)-1)
        {
            $Exportt .= ";";
        }
    }
    $Exportt .= "\r\n";
    $Titel = "";


echo$Exportt;


include "../hornusse-scripts/Rollforward.php";
//$ResultPointer = mysql_query("SELECT * FROM Spieler "
 //       . " WHERE SpielerID = 60  ");
       
$ResultPointer = mysql_query("SELECT Spieler. * , Streiche. * , Gegner. * "
        . " FROM Spieler"
        . " INNER JOIN Streiche"
        . " USING ( SpielerID ) "
        . " INNER JOIN Gegner"
        . " USING ( SpielID ) "
        . " WHERE Substring( Gegner.Datum, 1, 4 ) = $Jahr AND Spielername = 'Bieri' AND Spielervorname = 'Christian'");
        //. " ORDER BY Spielername, Spielervorname, Datum LIMIT 0, 3000");	
	
	
for($i = 0, $Export = ""; $i < 500; $i++)
{
    $Daten = mysql_fetch_object($ResultPointer);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Datum);
    $Spalte[] = str_replace("\"", "\"\"", $Daten->Anlass);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Gegner);	
 	$Spalte[] = str_replace("\"", "\"\"", $Daten->Ort);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Ries1);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Ries2);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Ries3);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Ries4);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Ries5);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Ries6);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Rangpunkte);

    
   for($j = 0; $j < count($Spalte); $j++)
    {
        $Export .= "\"" . $Spalte[$j] . "\"";

        if($j != count($Spalte)-1)
        {
            $Export .= ";";
        }
    }
    $Export .= "\r\n";
    $Spalte = "";
}

echo$Export;

?>