<?
require("./global.php");
if (!isset($action) or $action=="") {
  $action="main";
}
// #################### Links Home ####################
if ($action=="main") {
$ebg = $DB_site->query("SELECT * FROM gportal_weblinkscat ORDER BY catname");
if ($DB_site->num_rows($ebg)) {
  while ($myrow=$DB_site->fetch_array($ebg)) {
			$hasattach=1;
			$catid=$myrow["webcatid"];
			$catname=$myrow["catname"];
			$catdesc=$myrow["catdesc"];
      eval("\$catlistbit .= \"".gettemplate('drkslinks_catbit')."\";");
  }
}
eval("dooutput(\"".gettemplate('drkslinks_main')."\");");
}

// #################### View Links ####################

if ($action=="viewlinks") {
$asb = $DB_site->query("SELECT * FROM gportal_weblinkslink WHERE catagoryid=$catid AND valid='1' ORDER BY linkname");
if ($DB_site->num_rows($asb)) {
  while ($myrow=$DB_site->fetch_array($asb)) {
			$hasattach=1;
			$linkid=$myrow["linkid"];
			$linkname=$myrow["linkname"];
			$linkurl=$myrow["linkurl"];
			$linkdesc=$myrow["linkdesc"];
			$linkhits=$myrow["hits"];
  if ($linkhits < '1') {
     $linkhits = "0";
  }
      eval("\$catlistbit .= \"".gettemplate('drkslinks_linkbit')."\";");
  }
}
$result1 = $DB_site->query("SELECT * FROM gportal_weblinkscat WHERE webcatid=$catid");
     if ($DB_site->num_rows($result1)) {
      while ($myrow=$DB_site->fetch_array($result1)) {
			$hasattach=1;
			$catid=$myrow["webcatid"];
			$catname=$myrow["catname"];
			$catdesc=$myrow["catdesc"];
eval("dooutput(\"".gettemplate('drkslinks_browselink')."\");");
 }
}
}

// #################### Add Link ####################
if ($action=="addlink") {
  if ($bbuserinfo[usergroupid]=="1" or $bbuserinfo[usergroupid]=="3" or $bbuserinfo[usergroupid]=="0") {
      eval("dooutput(\"".gettemplate('drkslinks_error1')."\");");
      }else{

$result1 = $DB_site->query("SELECT * FROM gportal_weblinkscat");
     if ($DB_site->num_rows($result1)) {
      while ($myrow=$DB_site->fetch_array($result1)) {
			$hasattach=1;
			$catid=$myrow["webcatid"];
			$catname=$myrow["catname"];
			$catdesc=$myrow["catdesc"];
     eval("\$optbit .= \"".gettemplate('drkslinks_addnewlink_select')."\";");
     }
    }
     eval("dooutput(\"".gettemplate('drkslinks_addnewlink')."\");");

 }
}
// #################### Do Add New ####################
if ($HTTP_POST_VARS['action']=="doaddnew") {
if ($catid == '0'){
    eval("dooutput(\"".gettemplate('drkslinks_error2')."\");");
}elseif ($linkname == ''){
    eval("dooutput(\"".gettemplate('drkslinks_error2')."\");");
}elseif ($linkurl == 'http://' or $linkurl == ''){
    eval("dooutput(\"".gettemplate('drkslinks_error2')."\");");
}elseif ($linkdesc == ''){
    eval("dooutput(\"".gettemplate('drkslinks_error2')."\");");
}else{
 if ($valid == '1'){
     $vd = "0";
 }else{
     $vd = "1";
 }
$result = mysql_query("INSERT INTO gportal_weblinkslink (catagoryid, linkname, linkurl, linkdesc, valid) VALUES ('$catid', '".addslashes(htmlspecialchars($linkname))."', '$linkurl', '$linkdesc', $vd)");
     eval("dooutput(\"".gettemplate('drkslinks_doneaddlink')."\");");
}
}

// #################### Search Links ####################
if ($action=="search") {
 eval("dooutput(\"".gettemplate('drkslinks_search')."\");");
}

// #################### Search Links ####################
if ($action=="results") {
    if ($string!="") {
      $condition.=" AND linkname LIKE '%".addslashes($string)."%' OR linkdesc LIKE '%".addslashes($string)."%'";
    }

$search=$DB_site->query("SELECT linkid,catagoryid,linkname,linkdesc,hits FROM gportal_weblinkslink WHERE valid='1' $condition ORDER BY linkname");

while ($linky=$DB_site->fetch_array($search)) {
    $linkid = $linky['linkid'];
    $linkname = $linky['linkname'];
    $linkdesc = $linky['linkdesc'];
    $linkhits = $linky['hits'];
  if ($linkhits < '1') {
     $linkhits = "0";
  }
 eval("\$resultbits .= \"".gettemplate("drkslinks_linkbit")."\";");
 }
eval("dooutput(\"".gettemplate('drkslinks_searchresults')."\");");;
}

// #################### Jump ####################
if ($action=="jump") {

if ($noshutdownfunc) {
  $DB_site->query("UPDATE gportal_weblinkslink SET hits=hits+1 WHERE linkid='$id'");
} else {
  $shutdownqueries[]="UPDATE LOW_PRIORITY gportal_weblinkslink SET hits=hits+1 WHERE linkid='$id'";
}


$jumplink=$DB_site->query("SELECT * FROM gportal_weblinkslink WHERE linkid='$id'");

while ($jump=$DB_site->fetch_array($jumplink)) {
    $url = $jump['linkurl'];
    $name = $jump['linkname'];
 eval("\$jumpinfo .= \"".gettemplate("drkslinks_jumpinfo")."\";");
}

eval("dooutput(\"".gettemplate('drkslinks_jump')."\");");
}

// #################### Top 10 Latest Added Links ####################
if ($action=="top10last") {
    $asb = $DB_site->query("SELECT * FROM gportal_weblinkslink WHERE valid='1' ORDER BY linkid DESC LIMIT 10");
if ($DB_site->num_rows($asb)) {
  while ($myrow=$DB_site->fetch_array($asb)) {
			$linkid=$myrow["linkid"];
			$linkname=$myrow["linkname"];
			$linkurl=$myrow["linkurl"];
			$linkdesc=$myrow["linkdesc"];
			$linkhits=$myrow["hits"];
  if ($linkhits < '1') {
     $linkhits = "0";
  }
      eval("\$catlistbit .= \"".gettemplate('drkslinks_linkbit')."\";");
  }
}
$catname = "Laatste 10 Links";
eval("dooutput(\"".gettemplate('drkslinks_browselink')."\");");

}

// #################### Top 10 Most Visited Links ####################
if ($action=="top10visited") {
    $asb = $DB_site->query("SELECT * FROM gportal_weblinkslink WHERE valid='1' ORDER BY hits DESC LIMIT 10");
if ($DB_site->num_rows($asb)) {
  while ($myrow=$DB_site->fetch_array($asb)) {
			$linkid=$myrow["linkid"];
			$linkname=$myrow["linkname"];
			$linkurl=$myrow["linkurl"];
			$linkdesc=$myrow["linkdesc"];
			$linkhits=$myrow["hits"];
  if ($linkhits < '1') {
     $linkhits = "0";
  }
      eval("\$catlistbit .= \"".gettemplate('drkslinks_linkbit')."\";");
  }
}
$catname = "Top 10 Bezochte Sites";
eval("dooutput(\"".gettemplate('drkslinks_browselink')."\");");

}
?>