<?php
// neuen Rank eintragen, ändern oder löschen
if ($_POST['eintragen'] == 'Neue Position') {
    db_query("INSERT INTO " . $db_prefix . "_rallyorte (id, name, welche_rallys) VALUES (NULL, '" . $_POST['name'] . "','" . implode(',', array_keys($_POST['rally'])) . "');");
    Echo '<b><font size="+2" color="#087102">Eintragung  erfolgreich!</font></b>';
} ;
if ($_POST['eintragen'] == 'Loeschen') {
    db_query("DELETE FROM " . $db_prefix . "_rallyorte WHERE id = '" . $_POST['id'] . "';");
    Echo '<b><font size="+2" color="#087102">Eintrag erfolgreich gel&ouml;scht!</font></b>';
} ;
if ($_POST['eintragen'] == 'Aendern') {
    db_query("UPDATE " . $db_prefix . "_rallyorte SET welche_rallys='" . implode(',', array_keys($_POST['rally'])) . "' WHERE id='" . $_POST['id'] . "';");
    Echo '<b><font size="+2" color="#087102">&Auml;nderung  erfolgreich!</font></b>';
} ;
if ($_POST['rally'] == 'Eintragen') {
    db_query("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 (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') {
    db_query("DELETE FROM " . $db_prefix . "_rallydaten WHERE id = '" . $_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 = db_query("SELECT * FROM " . $db_prefix . "_rallydaten");
while ($rall = mysqli_fetch_array($rally)) {?>
        <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</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 teil nehmen 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>Beschrieb</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 = db_query("SELECT * FROM " . $db_prefix . "_rallyorte ORDER BY id ASC");
while ($ap = mysqli_fetch_array($ap_anzeige)) {
    $rallynamen = db_query("SELECT id, name FROM " . $db_prefix . "_rallydaten");
    $rallys = '';
    while ($rallyname = mysqli_fetch_array($rallynamen)) {
        $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 = db_query("SELECT id, name FROM " . $db_prefix . "_rallydaten");
$rallysneu = '';
while ($rallynameneu = mysqli_fetch_array($rallynamenneu)) {
    $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(); ?>