".$locale['dls122']."\n"; closetable(); } if ($action == "view" && isNum($download_id)) { opentable($locale['dls112']); $result = dbquery("SELECT * FROM ".$db_prefix."downloads_submissions WHERE download_id='$download_id'"); $data = dbarray($result); $result2 = dbquery("SELECT * FROM ".$db_prefix."download_cats ORDER BY download_cat_name"); if (dbrows($result2) != 0) { while ($data2 = dbarray($result2)) { $sel = ($data['download_cat'] == $data2['download_cat_id'] ? " selected" : ""); $editlist .= "".$data2['download_cat_name']."\n"; } echo "

\n"; $result3 = dbquery("SELECT user_name FROM ".$db_prefix."users WHERE user_id='".$data['download_submitted']."'"); $user = dbresult($result3, 0); echo "

".$locale['dls103']."
".$locale['dls104']."	".$data['download_description']."
".$locale['dls105']."
".$locale['dls106']."	$editlist
".$locale['dls107']."
".$locale['dls108']."
".$locale['dls109']."
".$locale['dls110']."
".$locale['dls113']."	".showdate("%d.%m.%y", $data['download_datestamp'])."
".$locale['dls114']."	$user

\n"; } else { echo "
\n".$locale['dls128']."

\n\n"; } closetable(); } if ($action == "publish" && isNum($download_id)) { $result = dbquery("SELECT * FROM ".$db_prefix."downloads_submissions WHERE download_id='$download_id'"); $data = dbarray($result); $result = dbquery("INSERT INTO ".$db_prefix."downloads (download_title, download_description, download_url, download_cat, download_license, download_os, download_version, download_filesize, download_datestamp, download_count) VALUES ('".$data['download_title']."', '".$data['download_description']."', '".$data['download_url']."', '".$data['download_cat']."', '".$data['download_license']."', '".$data['download_os']."', '".$data['download_version']."', '".$data['download_filesize']."', '".time()."', '0')"); $result = dbquery("DELETE FROM ".$db_prefix."downloads_submissions WHERE download_id='$download_id'"); opentable($locale['dls121']); echo "".$locale['dls122']."\n"; closetable(); } if ($action == "remove" && isNum($download_id)) { $result = dbquery("DELETE FROM ".$db_prefix."downloads_submissions WHERE download_id='$download_id'"); } opentable($locale['dls100']); $resultado = dbquery("SELECT * FROM ".$db_prefix."downloads_submissions ORDER BY download_datestamp DESC"); $rows = dbrows($resultado); echo "\n"; if ($rows != 0) { echo "\n"; } $i = 0; while ($dados = dbarray($resultado)) { $resultado2 = dbquery("SELECT user_name FROM ".$db_prefix."users WHERE user_id='".$dados['download_submitted']."'"); $user = dbresult($resultado2, 0); echo "\n"; $i++; } echo "

".$locale['dls115']."	".$locale['dls116']."	".$locale['dls117']."
".$dados['download_title']."	$user	".$locale['dls118']." | ".$locale['dls119']." | ".$locale['dls120']."

\n"; closetable(); echo "\n"; echo "\n"; require_once BASEDIR."footer.php"; ?>