<?
require("../db_config_hornusse.php"); 

//Datum, Gegner, Kategorie, Anlass, Ort, NrThoeris, PunkteThoeris, SBWetter
$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=Alle-Spiele-2020.csv');
header('Pragma: no-cache');

//Spaltentitel exportieren
$Exportt = ""; 

	$Titel[] = str_replace("\"", "\"\"", StartDate);
	$Titel[] = str_replace("\"", "\"\"", StartTime);
    $Titel[] = str_replace("\"", "\"\"", Subject1);
	$Titel[] = str_replace("\"", "\"\"", Gegenmannschaft);	
 	$Titel[] = str_replace("\"", "\"\"", Location);
	$Titel[] = str_replace("\"", "\"\"", EndDate);
	$Titel[] = str_replace("\"", "\"\"", EndTime);
	$Titel[] = str_replace("\"", "\"\"", Subject);

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

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

echo$Exportt;

//Datenbankinhalt exportieren (ab Zeile 2)
include "../hornusse-scripts/Rollforward.php";
$ResultPointer = mysql_query("SELECT * FROM Gegner "
					   ."WHERE Substring(Gegner.Datum,1,4) = $Jahr OR Substring(Gegner.Datum,1,4) = $Nextjahr "
					   ."ORDER BY Datum");

for($i = 0, $Export = ""; $i < mysql_num_rows($ResultPointer); $i++)
{
    $Daten = mysql_fetch_object($ResultPointer);

    $Spalte[] = str_replace("\"", "\"\"", $Daten->Datum);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Zeit);
    $Spalte[] = str_replace("\"", "\"\"", $Daten->Anlass);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Gegner);	
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Ort);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Datum);
	$Spalte[] = str_replace("\"", "\"\"", $Daten->Zeit+5);
    $Spalte[] = str_replace("\"", "\"\"", '=C2&" "&D2');
    
    for($j = 0; $j < count($Spalte); $j++)
    {
        $Export .= "\"" . $Spalte[$j] . "\"";

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

echo$Export;
?>