<?PHP


mysql_query("UPDATE `[users]` SET online=NOW() WHERE `login`='". $data->login ."'");


?>
<table width="100%">
    <tr>
        <td><b>Link partners goedkeuren</b></td>
    </tr>
    <tr>
        <td>
            Hier kan je linkpartners goedkeuren, kijk wel alle links na voor de zekerheid.!
        </td>
    </tr>
    <form method="POST">
        <?PHP
            $dbres = mysql_query("SELECT url,titel,email,id FROM keuring ORDER BY id DESC");
            
            if(mysql_num_rows($dbres) == "0") {
                echo '<tr>
                        <td>Zijn geen links die gekeurd hoefen worden!</td>
                    </tr>
                ';
            } else {
        ?>
        <tr>
            <td width="50%"><b>Titel</b></td>
            <td width="50%"><b>Url</b></td>
        </tr>
        <?
        while($url = mysql_fetch_assoc($dbres)) {
            echo '<tr>
                    <td width="50%"><a href="?p=keuring&id='. $url['id'] .'">'. $url['titel'] .'</a></td>
                    <td width="50%">'. $url['url'] .'</td>
                </tr>
            ';
        }
        }
        
        if($_GET['p'] == "keuring" && isset($_GET['id']))
        {
          if(is_numeric($_GET['id']))
          {
            if(isset($_POST['goed']))
            {
              $select = mysql_query("SELECT url,titel,email,id FROM keuring WHERE id='". $_GET['id'] ."'");
              $goed   = mysql_fetch_assoc($select);
            
              mysql_query("INSERT INTO linkers (titel,url,email) VALUES ('". $goed['titel'] ."','". $goed['url'] ."','". $goed['email'] ."')");
              echo 'Je hebt '. $goed['url'] .' goedgekeurt!';
            }
            
            $dbres1 = mysql_query("SELECT url, titel, email, id FROM keuring WHERE id='". $_GET['id'] ."'") or trigger_error(mysql_error());
            while($link = mysql_fetch_assoc($dbres1)) {
?>
            <tr>
                <td>Url</td>
                <td><a href="<? echo $link['url']; ?>" target="_blanc"><? echo $link['url']; ?></a></td>
            </tr>
            <tr>
                <td>Titel</td>
                <td><? echo $link['titel']; ?></td>
            </tr>
            <tr>
                <td>Email</td>
                <td><? echo $link['email']; ?></td>
            </tr>
            <tr>
                <td>Keuring:</td>
                <td><input type="submit" name="goed" value="Goed" /> - <input type="submit" name="fout" value="Fout!" /></td>
            </tr>
<?php
            }
          }
          else
          {
            echo 'Alleen nummers in voeren AUB.';
            exit();
          }
        }


?>
    </form>
</table>