require_once "../../maincore.php"; require_once THEMES."templates/admin_header.php"; include INFUSIONS."Downloads_Submissions/infusion_db.php"; if (!checkrights("DLSM")) fallback("../index.php"); if (file_exists(INFUSIONS."Downloads_Submissions/locale/".$settings['locale'].".php")) { include INFUSIONS."Downloads_Submissions/locale/".$settings['locale'].".php"; } else { include INFUSIONS."Downloads_Submissions/locale/English.php"; } if (isset ($_POST['publish_download'])) { $download_title = stripinput($_POST['download_title']); $download_description = addslash($_POST['download_description']); $download_url = stripinput($_POST['download_url']); $download_cat = stripinput($_POST['download_cat']); $download_license = stripinput($_POST['download_license']); $download_os = stripinput($_POST['download_os']); $download_version = stripinput($_POST['download_version']); $download_filesize = stripinput($_POST['download_filesize']); $result = dbquery("INSERT INTO ".DB_DOWNLOADS." (download_title, download_description, download_url, download_cat, download_license, download_os, download_version, download_filesize, download_datestamp, download_count) VALUES ('$download_title', '$download_description', '$download_url', '$download_cat', '$download_license', '$download_os', '$download_version', '$download_filesize', '".time()."', '0')"); $result = dbquery("DELETE FROM ".DB_DLSM." WHERE download_id='$download_id'"); opentable($locale['dls121']); echo "".$locale['dls122']."\n"; closetable(); } if (isset($_GET['action']) && $_GET['action'] == "view") { opentable($locale['dls112']); $result = dbquery("SELECT * FROM ".DB_DLSM." WHERE download_id='$download_id'"); $data = dbarray($result); $result2 = dbquery("SELECT * FROM ".DB_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_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 (isset($_GET['action']) && $_GET['action'] == "publish") { $result = dbquery("SELECT * FROM ".DB_DLSM." WHERE download_id='$download_id'"); $data = dbarray($result); $result = dbquery("INSERT INTO ".DB_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_DLSM." WHERE download_id='$download_id'"); opentable($locale['dls121']); echo "".$locale['dls122']."\n"; closetable(); } if (isset($_GET['action']) && $_GET['action'] == "remove") { $result = dbquery("DELETE FROM ".DB_DLSM." WHERE download_id='$download_id'"); } opentable($locale['dls100']); $resultado = dbquery("SELECT * FROM ".DB_DLSM." ORDER BY download_datestamp DESC"); $rows = dbrows($resultado); echo "\n"; if ($rows != 0) { echo "\n"; } while ($dados = dbarray($resultado)) { $resultado2 = dbquery("SELECT user_name FROM ".DB_USERS." WHERE user_id='".$dados['download_submitted']."'"); $user = dbresult($resultado2, 0); echo "\n"; } echo "

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

\n"; closetable(); echo "\n"; require_once THEMES."templates/footer.php"; ?>