"); add_to_head(""); if ( isset($_GET['projekt_id']) && isNum($_GET['projekt_id']) ) { opentable($locale['psp_196']); $result = dbquery("SELECT * FROM ".DB_PREFIX."projekte LEFT JOIN ".DB_PREFIX."projekttype pt ON projekt_type = pt.type_id LEFT JOIN ".DB_USERS." ON user_id = projekt_user WHERE projekt_id = ".$_GET['projekt_id'].""); echo ""; if (dbrows($result)>0) while ($data = dbarray($result)) { $kat = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."projektkat WHERE kat_id = '".$data['projekt_kat']."'")); if ($data['projekt_status'] == "3") { if ($data['projekt_url'] == "") { $downurl = $locale['psp_175']; } else { if (iGUEST) { $downurl = "[".$locale['psp_165']."]"; } else { $downurl = "[".$locale['psp_165']."]"; } } if ($data['projekt_screen'] == "") { $screenurl = $locale['psp_175']; } else { $screenurl = "[".$locale['psp_176']."]"; } } else { $downurl = $locale['psp_175']; $screenurl = $locale['psp_175']; } $fusion = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fusions WHERE fusion_id = ".$data['projekt_fusion']."")); $fuser = dbarray(dbquery("SELECT user_name FROM ".DB_USERS." LEFT JOIN ".DB_PREFIX."projekte pr ON projekt_activate_from = user_id")); echo " "; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".$locale['psp_117'].":	".$data['projekt_name']."	".$locale['psp_145'].":	".$data['projekt_version']."
".$locale['psp_126'].":	".$kat['kat_name']."	".$locale['psp_160_5'].":	".$fusion['fusion_name']." - ".$data['type_name']."
".$locale['psp_161_1'].":	".$data['projekt_entwickler']." [".$locale['psp_161_2']."] [".$locale['psp_161_3']."]	".$locale['psp_146'].":	".showdate("%d.%m.%y", $data['projekt_date'])."
".$locale['psp_166'].":	".$screenurl."	".$locale['psp_194'].":	".showrank($data['projekt_id'],"x")."
".$locale['psp_165'].":	".$downurl."	".$locale['psp_177'].":	".$data['projekt_klicks']."
".$locale['psp_165_4'].":
Dateigrösse: ".showsize($data['projekt_id'])." Dateityp: ".showtype($data['projekt_id'])."
".$locale['psp_162'].":
".nl2br(parseubb(htmlspecialchars($data['projekt_beschreibung'])))."
".$locale['psp_163'].":
".nl2br(parseubb(htmlspecialchars($data['projekt_copyright'])))."
".$locale['psp_174'].":	".$data['user_name']."	".$locale['psp_179'].":	".$fuser['user_name']."

"; closetable(); require_once INCLUDES."comments_include.php"; require_once INCLUDES."ratings_include.php"; showratings("D",$projekt_id,FUSION_SELF."?projekt_id=$projekt_id"); showcomments("D","projekte","projekt_id",$projekt_id,$PHP_SELF."?projekt_id=".$projekt_id); } else { function buildfusionlist() { global $locale; $fusionlist = ""; return $fusionlist; } function buildkatlist() { global $locale; $katlist = ""; return $katlist; } function buildtypelist() { global $locale; $typelist = ""; return $typelist; } function buildsortlist() { global $locale; $sortlist = ""; return $sortlist; } function buildanzlist() { global $locale; $anzlist = ""; return $anzlist; } opentable($locale['psp_907']); echo ""; echo " "; $rows = dbcount("(projekt_id)", DB_PREFIX."projekte", "projekt_prozent = 100"); if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0; $items_per_page = 25; $catname = ""; $query = "SELECT tu.*, tn.*, kat_id, kat_name, pt.type_name FROM ".DB_PREFIX."projektkat tn LEFT JOIN ".DB_PREFIX."projekte tu ON tn.kat_id=projekt_kat LEFT JOIN ".DB_PREFIX."projekttype pt ON tu.projekt_type = pt.type_id WHERE projekt_status=3 AND projekt_prozent = '100' AND projekt_active='1'"; if ( $_REQUEST['selCat'] ) $query .= " AND projekt_kat='".$_REQUEST['selCat']."'"; if ( $_REQUEST['selType'] ) $query .= " AND projekt_type='".$_REQUEST['selType']."'"; if ( $_REQUEST['selFusion'] ) $query .= " AND projekt_fusion='".$_REQUEST['selFusion']."'"; if ( $_REQUEST['selAnz'] ) { if ( $_REQUEST['selAnz'] != 1 ) $items_per_page = $_REQUEST['selAnz']; else $items_per_page = $rows;//Alle } if ( $_REQUEST['selSort'] ) { switch ( $_REQUEST['selSort'] ) { case 1: $orderby = " BY kat_name ASC"; break; case 2: $orderby = " BY kat_name DESC"; break; case 3: $orderby = " BY projekt_date ASC"; break; case 4: $orderby = " BY projekt_date DESC"; break; } } else $orderby = " BY kat_name ASC"; $query .= " ORDER ".$orderby.",projekt_name LIMIT $rowstart,$items_per_page"; $result = dbquery($query); $tbl_header = " ".$locale['psp_117']." ".$locale['psp_161_1']." ".$locale['psp_160_7']." ".$locale['psp_160_2']." ".$locale['psp_146']." ".$locale['psp_177']." ".$locale['psp_194']." "; echo "
"; if ($ro = dbrows($result) >0 ) { while ($data = dbarray($result)) { $fusion = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."fusions WHERE fusion_id = ".$data['projekt_fusion']."")); if ( ($catname == "") || ($catname != $data['kat_name']) ) { $catname = $data['kat_name']; echo "\n"; echo $tbl_header; } echo ""; echo ""; $pm_head = ""; $pm_body = ""; $ltitle = ""; $pm_head .= trimlink( str_replace(array("[","]"),array("[","]"),$data['projekt_name']), 50); $pm_body .= nl2br( trimlink( str_replace(array("[","]"),array("[","]"), parsesmileys( parseubb( htmlspecialchars($data['projekt_beschreibung'] ) ) ) ), 500 ) ); $ltitle .= " cssheader=[ft-header]"; $ltitle .= " cssbody=[ft-body]"; $ltitle .= " fade=[on]"; $ltitle .= " fadespeed=[0.05]"; $ltitle .= " delay=[0]"; $ltitle .= " header=[".$pm_head."]"; $ltitle .= " body=[".$pm_body."]"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } } else { echo ""; } echo "

".$catname."
	".$data['projekt_name']."	".$data['projekt_entwickler']."	".$fusion['fusion_name']." - ".$data['type_name']."	".$data['projekt_version']."	".showdate("%d.%m.%Y", $data['projekt_date'])."	".$data['projekt_klicks']."	".showrank($data['projekt_id'])."
".$locale['psp_198_1']."

"; closetable(); if ($rows > $items_per_page) { echo "

".makepagenav($rowstart,$items_per_page,$rows,0,$PHP_SELF."?")."\n

\n"; } } require_once THEMES."templates/footer.php"; function showsize($id) { $dl = dbarray(dbquery("SELECT projekt_url AS download FROM ".DB_PREFIX."projekte WHERE projekt_id = '".$id."'")); if (is_file(INFUSIONS."projekt_panel/downloads/".$dl['download'])) $size = filesize(INFUSIONS."projekt_panel/downloads/".$dl['download']); if ( $size > 1000 ) $rsize = round($size/1000,1)." kB"; else if ( $size > 1000000 ) $rsize = round($size/1000000,1)." MB"; else $rsize = round($size,1)." Byte"; return $rsize; } function showtype($id) { $dl = dbarray(dbquery("SELECT projekt_url AS download FROM ".DB_PREFIX."projekte WHERE projekt_id = '".$id."'")); if (is_file(INFUSIONS."projekt_panel/downloads/".$dl['download'])) $type = pathinfo(INFUSIONS."projekt_panel/downloads/".$dl['download']); return $type['extension']; } function showrank ($id, $pic="") { global $locale; $ratings = array(5=>$locale['psp_200_1'], 4=>$locale['psp_200_2'], 3=>$locale['psp_200_3'], 2=>$locale['psp_200_4'], 1=>$locale['psp_200_5']); $num_votes = dbresult(dbquery("SELECT COUNT(rating_item_id) FROM ".DB_PREFIX."ratings WHERE rating_item_id='".$id."' AND rating_type='D'"),0); $tot_votes = dbresult(dbquery("SELECT SUM(rating_vote) FROM ".DB_PREFIX."ratings WHERE rating_item_id='".$id."' AND rating_type='D'"),0); if (( $num_votes > 0 ) && ($tot_votes > 0)) { $pct_rating = ceil(round($tot_votes / $num_votes)); if ( $pic=="" ) $voto = "

"; else $voto = $ratings[$pct_rating]; } else { $voto = $locale['psp_195']; } return $voto; } ?>

	".$locale['psp_191']."
	".$locale['psp_126'].":	".buildkatlist()."
	".$locale['psp_112_4'].":	".buildtypelist()."
	".$locale['psp_160_5']." ".$locale['psp_145'].":	".buildfusionlist()."
	".$locale['psp_192'].":	".buildsortlist()."
	".$locale['psp_193'].":	".buildanzlist()."