<?
require("portal_config.php");

global $db_zugriff;

/* ############## Start Database Copyright by Daddycool http://www.crazy-board.de ############## */ 

# Anzahl rubriken und Dateien
$get = $db_zugriff->query_first("SELECT COUNT(id) AS aid FROM bb".$n."_mywbb_portal_database");
$all_cats = $get[aid];
$get = $db_zugriff->query_first("SELECT COUNT(id) AS bid FROM bb".$n."_mywbb_portal_database_entrys");
$all_down = $get[bid];

# neuester download
$get = $db_zugriff->query_first("SELECT id,cid,title,downloads,version FROM bb".$n."_mywbb_portal_database_entrys ORDER BY adate DESC LIMIT 1");
$nfid = $get[id];
$ncid = $get[cid];
$nname = $get[title] . " " . $get[version];
$ncount = $get[downloads];

# beliebtester download
$get = $db_zugriff->query_first("SELECT id,cid,title,downloads,version FROM bb".$n."_mywbb_portal_database_entrys ORDER BY downloads DESC LIMIT 1");
$bfid = $get[id];
$bcid = $get[cid];
$bname = $get[title] . " " . $get[version];
$bcount = $get[downloads];

if ($cid) {
   $get2 = $db_zugriff->query_first("SELECT title FROM bb".$n."_mywbb_portal_database WHERE id='$cid'");
   $catname = $get2[title];
}
eval ("\$copyright = \"".gettemplate("portal_database_copyright")."\";");
eval ("\$database_header = \"".gettemplate("portal_database_header")."\";");
eval ("\$database_footer = \"".gettemplate("portal_database_footer")."\";");

if ($action == "show_cat" && $cid) {
	$get = $db_zugriff->query("SELECT id,title,adate,views,version,kbeschr,downloads FROM bb".$n."_mywbb_portal_database_entrys WHERE cid='$cid'");
	if ($db_zugriff->num_rows($get) > 0) {
	    while ($info = $db_zugriff->fetch_array($get)) {
	        $time = time() - 259200;
			if ($time < $info[adate]) {eval ("\$new = \"".gettemplate("portal_database_neu")."\";");
			} else {eval ("\$new = \"".gettemplate("portal_database_alt")."\";");}

			$name = $info[title] . " " . $info[version];
			$desc = stripslashes($info[kbeschr]);
			$view = $info[views];
			$count = $info[downloads];
			$add = formatdate($info[adate],$shortdateformat);
			$fid = $info[id];
			eval ("\$entrys .= \"".gettemplate("portal_database_show_cat_entry")."\";");
	    }
	}
	eval ("\$neu = \"".gettemplate("portal_database_neu")."\";");
	eval ("\$alt = \"".gettemplate("portal_database_alt")."\";");
    eval ("dooutput(\"".gettemplate("portal_database_show_cat")."\");");
} elseif ($action == "view" && $fid && $cid) {
	$db_zugriff->query("UPDATE bb".$n."_mywbb_portal_database_entrys SET views=views+1 WHERE id='$fid'");
    $info = $db_zugriff->query_first("SELECT * FROM bb".$n."_mywbb_portal_database_entrys WHERE id='$fid'");
	$name = $info[title];
	$desc = stripslashes(nl2br($info[lbeschr]));
	$version = $info[version];
	$autor = $info[author];
	$eingetragen = formatdate($info[adate],$longdateformat);
	$last = formatdate($info[ldate],$longdateformat, 1);
	$count = $info[downloads];
	if ($info[boardwww]) {
	    $boardurl = $info[boardwww];
		eval ("\$burl = \"".gettemplate("portal_database_view_boardurl")."\";");
	}
	if ($info[demo]) {
	    $demourl = $info[demo];
		eval ("\$demo = \"".gettemplate("portal_database_view_demo")."\";");
	}
	eval ("dooutput(\"".gettemplate("portal_database_view")."\");");
} elseif ($action == "dl" && $cid && $fid) {
	$time = time();
	$db_zugriff->query("UPDATE bb".$n."_mywbb_portal_database_entrys SET downloads=downloads+1, ldate='$time' WHERE id='$fid'");
	$info = $db_zugriff->query_first("SELECT title,www,version FROM bb".$n."_mywbb_portal_database_entrys WHERE id='$fid'");
	$url = $info[www];
	$name = $info[title];
	$version = $info[version];
    eval ("dooutput(\"".gettemplate("portal_database_dl")."\");");
} elseif ($action == "top10") {
    $get = $db_zugriff->query("SELECT id,title,downloads,cid,version FROM bb".$n."_mywbb_portal_database_entrys ORDER BY downloads DESC LIMIT 10");
	$a = 1;
	if ($db_zugriff->num_rows($get) > 0) {
	    while ($info = $db_zugriff->fetch_array($get)) {
	        $fid = $info[id];
			$name = $info[title] . " " . $info[version];
			$count = $info[downloads];
			$cid = $info[cid];
			eval ("\$entrys .= \"".gettemplate("portal_database_top10_entry")."\";");
			$a++;
	    }
	}
	eval ("dooutput(\"".gettemplate("portal_database_top10")."\");");
} elseif ($action == "new") {
    $get = $db_zugriff->query("SELECT id,title,adate,cid,version FROM bb".$n."_mywbb_portal_database_entrys ORDER BY adate DESC LIMIT 10");
	$a = 1;
	if ($db_zugriff->num_rows($get)) {
	    while ($info = $db_zugriff->fetch_array($get)) {
	        $fid = $info[id];
			$cid = $info[cid];
			$ldate = formatdate($info[adate],$shortdateformat);
			$name = $info[title] . " " . $info[version];
			eval ("\$entrys .= \"".gettemplate("portal_database_new_entry")."\";");
			$a++;
	    }
	}
	eval ("dooutput(\"".gettemplate("portal_database_new")."\");");
} else {
	$get = $db_zugriff->query("SELECT id,title,beschr FROM bb".$n."_mywbb_portal_database ORDER BY title");
	if ($db_zugriff->num_rows($get) > 0) {
		while ($info = $db_zugriff->fetch_array($get)) {
		    $info2 = $db_zugriff->query_first("SELECT COUNT(id) AS cid FROM bb".$n."_mywbb_portal_database_entrys WHERE cid='$info[id]'");
			$cid = $info[id];
			$name = $info[title];
			$desc = $info[beschr];
			$count = $info2[cid];
			eval ("\$downloads .= \"".gettemplate("portal_database_entry")."\";");
		}  
	}
eval("dooutput(\"".gettemplate("portal_database")."\");");
}
/* ############## Ende Database Copyright by Daddycool http://www.crazy-board.de############## */ 

 

?>