script

 <?php
########################################
##    Made by Pieter Boussaer         ##
##    Email [email protected]        ##
########################################

include_once "database.php";

    echo '::&nbsp;Fuiven<br>
    &nbsp;&nbsp;::&nbsp;<a href="admin.php?actie=fuiven&actie2=controle" target="_self">Fuiven die tusen de fuivenkalender willen staan.</a><br>
    &nbsp;&nbsp;::&nbsp;<a href="admin.php?actie=fuiven&actie2=delete" target="_self">Gepasseerde fuiven wissen.</a><br><br>';

 echo "<a><b>Verzoekjes!</b></a><br><br>";

if($_GET['actie'] == "fuiven")
    $query = mysql_query("SELECT * FROM fuiven WHERE Titel >= NOW() ORDER BY Titel ASC");
    while ($list = mysql_fetch_object($query))  
        {  
        if ($list->Gecontroleerd == "Nee") 
            {
            $unixtime = strtotime($list->Datum);
                    
            echo "&nbsp;&nbsp;::&nbsp;<a href=fuiven.php?id=$list->id target='load'>";  
			$fuif = "&nbsp;&nbsp;$list->Titel  |<a href=admin.php?actie=fuiven&ja=$list->id target=_self>  Ja</a>&nbsp;&nbsp;<a href=admin.php?actie=fuiven&wis=$list->id target=_self>  Nee</a>&nbsp;&nbsp;";  
            echo "$fuif<BR>";
            }
        echo "</a>";  
        
        // als er op komende fuiven is geklikt  
        
        if($_GET['id'] == "$list->id") 
            {  
            $query1 = mysql_query("SELECT * FROM fuiven WHERE id='".$_GET['id']."' ");  
            while ($list1 = mysql_fetch_object($query1))  
                {
                $unixtime = strtotime($list1->Datum);
                 
                echo "<table align='center'> 
                <tr><TD><b>Titel:</td><TD>$list1->Titel</td></TR>  
                <tr><TD><b>Commentaar:</td><TD>$list1->Commentaar</td></TR> 
                <tr><TD><b>Verzoekjedoor:</td><TD>$list1->Verzoekjedoor</td></TR>
                <tr><TD><b>Contact:</td><TD><a href=mailto:$list1->Contact>$list1->Contact</a></td></TR>
				<tr><TD><b>Toestaan:</td><TD>$list1->Gecontroleerd</td></TR> 
                </table>";  
                }      
            } 
        }   
    if($_GET['actie2'] == "controle")
        {
        echo '<br><table width="100%"><TD width=20%><b>Verzoekje<TD width="20%"><b>Datum<TD width="20%"><b>Organisator<TD width="20%"><b>Contact<TD width="20%"><b>Toestaan<TR>'; 
        $select = "SELECT * FROM fuiven WHERE Gecontroleerd!='Ja' ORDER by Datum DESC"; 
        $query = mysql_query($select); 
        while ($list = mysql_fetch_object($query)) 
            { 
            echo '<td>'; 
            $fuif = "<font color=red><b>$list->Titel</b></font>"; 
            echo '$fuif<TD><b>            </b></font>"; 
            echo '$list->Datum<TD>$list->Verzoekjedoor<TD>$list->Contact<TD><a href="admin.php?actie=fuiven&ja='.$list->id.'" target="_self">Ja</a>&nbsp;&nbsp;<a href="admin.php?actie=fuiven&wis='.$list->id.'" target="_self">Nee</a><TR>'; 
            }
        echo '</table>';
        }
    if($_GET['actie2'] == "delete")
        {
        echo '<br><table width="100%"><TD width="20%"><b>Titel<TD width="20%"><b>Datum<TD width="20%"><b>Organisator<TD width="20%"><b>Contact<TD width="20%"><b>Delete<TR>'; 
        $select = "SELECT * FROM fuiven WHERE Datum < NOW() ORDER by Datum DESC"; 
        $query = mysql_query($select); 
        while ($list = mysql_fetch_object($query)) 
            { 
            echo '<td>'; 
            $fuif = "<font color=red><b>$list->Titel</b></font>"; 
            echo '$fuif<TD>'; 
            echo '$list->Datum<TD>$list->Verzoekjedoor<TD>$list->Contact<TD><a href="admin.php?actie=fuiven&fdelete='.$list->id.'" target="_self">Delete</a><TR>'; 
            }
        echo '</table>';
        }  
    elseif($_GET['wis'])
        { 
        mysql_query("DELETE FROM fuiven WHERE id='".$_GET['wis']."'"); 
        echo '<META HTTP-EQUIV="refresh" CONTENT="0; URL=admin.php?actie=fuiven&actie2=controle" target="_self">'; 
        }
    elseif($_GET['ja'])
        { 
        mysql_query(" UPDATE fuiven SET Gecontroleerd='Ja' WHERE id='".$_GET['ja']."'"); 
        echo '<META HTTP-EQUIV="refresh" CONTENT="0; URL=admin.php?actie=fuiven&actie2=controle" target="_self">'; 
        }
    elseif($_GET['fdelete'])
        { 
        mysql_query("DELETE FROM fuiven WHERE id='".$_GET['fdelete']."'"); 
        echo '<META HTTP-EQUIV="refresh" CONTENT="0; URL=admin.php?actie=fuiven&actie2=delete" target="_self">'; 
        }
?>
<iframe src="" name="load" width="760" height="300" scrolling="No" frameborder="0" id="load" title="load"></iframe>