<?php
if (!isset($_POST['eintragen'])) $_POST['eintragen'] = "";
if (!isset($_POST['rally'])) $_POST['rally'] = "";
// neuen Rank eintragen, ändern oder löschen
if ($_POST['eintragen'] == 'Neue Position') {
    $sql = sql::$db->prepare("INSERT INTO " . _VMS_ . "_rallyorte (id, name, welche_rallys) values(?,?,?)");
    $values = implode(',', array_keys($_POST['rally']) );
    $sql->execute(array(NULL, $_POST['name'], $values));
    echo '<b><font size="+2" color="#087102">Eintragung  erfolgreich!</font></b>';
} ;
if ($_POST['eintragen'] == 'Loeschen') {
    $sql = sql::$db->prepare("DELETE FROM " . _VMS_ . "_rallyorte WHERE id = ?;");
    $sql->execute(array($_POST['id']));
    echo '<b><font size="+2" color="#087102">Eintrag erfolgreich gel&ouml;scht!</font></b>';
} ;
if ($_POST['eintragen'] == 'Aendern') {
    $sql = sql::$db->prepare("UPDATE " . _VMS_ . "_rallyorte SET welche_rallys=? WHERE id=?;");
    $values = implode(',', array_keys($_POST['rally']) );
    $sql->execute(array($values, $_POST['id']));
    echo '<b><font size="+2" color="#087102">&Auml;nderung  erfolgreich!</font></b>';
} ;
if ($_POST['rally'] == 'Eintragen') {
    $sql = sql::$db->prepare("INSERT INTO " . _VMS_ . "_rallydaten (`id`, `name`, `beschrieb`, `status`, `start`, `ende_art`, `ende_zeit`, `ende_punkte`, `ende_punkte_aktuell`, `ende_punkte_anzahl`, `ende_formulierung`, `ende_vortschritt`, `gewinn_art`, `gewinn_dyn_steigerung`, `gewinn_topf`, `gewinner_anzahl`, `mindestpunktzhl`, `sperruser`, `tagpotstart`, `einheit`) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
    $sql->execute(array( NULL, $_POST['rallyname'] , ' ', 'deaktiviert', '0', 'zeit', '0', '0', '0.00', '0', ' ', 'datum', 'statisch', '0.00', '0.00', '0', '0', ' ', '0', ' '   ));
    echo '<b><font size="+2" color="#087102">Eintragung erfolgreich!</font></b>';
} ;
if ($_POST['rally'] == 'Loeschen') {
    $sql = sql::$db->prepare("DELETE FROM " . _VMS_ . "_rallydaten WHERE id = ?;");
    $sql->execute(array($_POST['id']));
    echo '<b><font size="+2" color="#087102">Eintrag erfolgreich gel&ouml;scht!</font></b>';
} ;

head("<b><center>Rallys im System </center></b>");
?>
<table align="center" border="0" cellpadding="3" cellspacing="1" width="100%"  bgcolor="#000000">
    <tr bgcolor="#c0c0c0">
        <td align="center"><strong>Name</strong></td>
        <td align="center"><strong>Bearbeiten der einzelnen Rallys</strong></td>
    </tr>
<?php
$rally=sql::$db->query("SELECT * FROM " . _VMS_ . "_rallydaten");
while ($rall = $rally->fetch()) {?>
        <form action="" method="post">
            <tr bgcolor="#d0d0d0" >
                <td align="center"><strong><?php echo $rall['name'];?></strong></td>
                <td align="center" valign="top">
                    <input type="hidden" name="id" value="<?php echo $rall['id']?>">
                    <input type="submit" name="rally" value="Loeschen" style="width:100px;">
                </td>
            </tr>
        </form>
    <?php } ?>
</table>
<?php foot();?>



<?php head("<b><center>Neue Rally eintragen. </center></b>");?>
<table align="center" border="0" cellpadding="3" cellspacing="1" width="100%"  bgcolor="#000000">
    <tr bgcolor="#c0c0c0">
        <td align="center"><strong>Name ("-Rally" wird automatisch angefügt)</strong></td>
        <td align="center"><strong>Bearbeiten der einzelnen Rallys</strong></td>
    </tr>
    <form action="" method="post">
        <tr bgcolor="#d0d0d0" >
            <td align="center"><input type="text" name="rallyname"></td>
            <td align="center" valign="top"><input type="submit" name="rally" value="Eintragen" style="width:100px;"></td>
        </tr>
    </form>
</table>
<?php foot();?>





<?php head("<b><center>Was in welcher Rally teilnehmen soll. </center></b>");?>
<table align="center" border="0" cellpadding="3" cellspacing="1" width="100%"  bgcolor="#000000">
    <tr bgcolor="#c0c0c0">
        <td align="center"><strong>Diese ID<br>müssen Sie<br>in der <br>Funktion<br>eingeben</strong></td>
        <td align="center"><strong>Beschreibung</strong></td>
        <td align="center"><strong>Welche Rallys</strong></td>
        <td align="center"><strong>Bearbeiten<br>der <br>einzelnen <br>Positionen</strong></td>
    </tr>
<?php
$ap_anzeige=sql::$db->query("SELECT * FROM " . _VMS_ . "_rallyorte ORDER BY id ASC");
while ($ap = $ap_anzeige->fetch()) {
    $rallynamen = sql::$db->query("SELECT id, name FROM " . _VMS_ . "_rallydaten");
    $rallys = '';
    while ($rallyname = $rallynamen->fetch()) {
        $checked = '';
        $arrays = explode (',', $ap['welche_rallys']);
        if (in_array($rallyname['id'], $arrays)) $checked = 'checked="checked"';
        $rallys .= '<input type="checkbox" ' . $checked . ' value="1" name="rally[' . $rallyname['id'] . ']"> ' . $rallyname['name'] . '<br>';
    }
    ?>
        <tr bgcolor="#d0d0d0" >
            <form action="" method="post">
                <td align="center" valign="top"><input type="hidden" name="id" value="<?php echo $ap['id']?>"><?php echo $ap['id'];?></td>
                <td align="center" valign="top"><strong><?php echo $ap['name'];?></strong></td>
                <td align="left" valign="top"><?php echo $rallys;?></td>
                <td align="center" valign="top"><input type="submit" name="eintragen" value="Aendern" style="width:100px;"><br><input type="submit" name="eintragen" value="Loeschen" style="width:100px;"></td>
            </form>
        </tr>
    <?php } ;?>
</table>
<?php foot();?>





<?php head("<b><center> Neue Position eintragen</center></b>");
$rallynamenneu = sql::$db->query("SELECT id, name FROM " . _VMS_ . "_rallydaten");
$rallysneu = '';
while ($rallynameneu = $rallynamenneu->fetch()) {
    $rallysneu .= '<input type="checkbox" value="1" name="rally[' . $rallynameneu['id'] . ']"> ' . $rallynameneu['name'] . '<br>';
}
?>
<form action="" method="post">
    <table align="center" border="0" cellpadding="3" cellspacing="1" width="100%" bgcolor="#000000">
        <tr bgcolor="#c0c0c0">
            <td align="center"><b>Name</b></td>
            <td align="center"><b>Rallys</b></td>
            <td align="center"><b>Speichern</b></td>
        </tr>
        <tr bgcolor="#d0d0d0">
            <td align="center">
                Dieser Name ist nur für Sie gedacht.<br>
                Er hat keinerlei Funktion.<br>
                <input type="text" name="name" value=""  style="width:200px;">
            </td>
            <td align="left"><?php echo $rallysneu;?></td>
            <td align="center"><input type="submit" name="eintragen" value="Neue Position" style="width:100px;"></td>
        </tr>
    </table>
</form>
<?php foot(); ?>