<? 
    // Configuratie voor catagorieen, voeg $catagorie[nummer] = "Catagorienaam" toe voor een nieuwe catagorie. 

    $fullcat[1] = "Catagorie 1"; 
    $fullcat[2] = "Catagorie 2"; 

    $dbhost = "localhost"; 
    $dbuser = "username"; 
    $dbpass = "password"; 
    $dbdbdb = "databasename"; 

     
    if (!@mysql_select_db($dbdbdb, @mysql_connect($dbhost, $dbuser, $dbpass))) 
    { 
        echo "<font face=\"Verdana, Arial, Helvetica\" size=\"2\">Sorry, er kon geen connectie worden gemaakt met de database.<p>"; 
        echo "Probeer het a.u.b opnieuw. Blijft dit probleem zich voordoen, neemt u dan contact op met de webmaster.</font>"; 
        exit(); 
    } 
     
    $dbhost = ""; 
    $dbuser = ""; 
    $dbpass = ""; 
    $dbdbdb = ""; 
     
    //-- set dynamic vars 
    $tab_links = "links"; 

    if ($_GET['url']) 
    { 
        $sql = "UPDATE links SET out=out+1 WHERE url = '" . $_GET['url'] . "'"; 
        mysql_query($sql); 
         
        header("Location: " . $_GET['$url']); 
    } 
    else 
    { 
         
        function linkscat($cat) 
        { 

            return $fullcat[$cat]; 
        } 

        $sql = "SELECT name,url,lang,cat,out FROM " . $tab_links . " ORDER BY cat,name"; 
        $res = mysql_query($sql); 
         
        while ($row = mysql_fetch_array($res)) 
        { 
            if ($curcat == "") 
            { 
                $thiscat = linkscat($row[cat]); 
                $curcat = $row['cat']; 
                echo "<b>" . $thiscat . "</b><p>"; 
                 
                echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?url=" . $row['url'] . "\" title=\"" . $row['name'] . "\" target=\"_blank\">" . $row['name'] . "</a> <span class=\"small\">[" . $row['lang'] . "] [out: " . $row['out'] . "]</span>";
            } 
            else 
            { 
                if ($curcat == $row['cat']) 
                { 
                    echo "<br><a href=\"" . $_SERVER['PHP_SELF'] . "?url=" . $row['url'] . "\" title=\"" . $row['name'] . "\" target=\"_blank\">" . $row['name'] . "</a> <span class=\"small\">[" . $row['lang'] . "] [out: " . $row['out'] . "]</span>";
                } 
                else 
                { 
                    $thiscat = linkscat($row[cat]); 
                    $curcat = $row['cat']; 
                    echo "<p><b>" . $thiscat . "</b></b><p>"; 
                     
                    echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?url=" . $row['url'] . "\" title=\"" . $row['name'] . "\" target=\"_blank\">" . $row['name'] . "</a> <span class=\"small\">[" . $row['lang'] . "] [out: " . $row['out'] . "]</span>";
                } 
            } 
        } 
    } 
?> 
