//
// ------------------------------------------------------------------------- //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
include '../../../include/cp_header.php';
if ( file_exists("../language/".$xoopsConfig['language']."/main.php") ) {
include "../language/".$xoopsConfig['language']."/main.php";
} else {
include "../language/english/main.php";
}
include "../include/functions.php";
include_once XOOPS_ROOT_PATH."/class/xoopstree.php";
include_once XOOPS_ROOT_PATH."/class/xoopslists.php";
include_once XOOPS_ROOT_PATH."/include/xoopscodes.php";
include_once XOOPS_ROOT_PATH."/class/module.errorhandler.php";
$myts =& MyTextSanitizer::getInstance();
$eh = new ErrorHandler;
$mytree = new XoopsTree($xoopsDB->prefix("mydownloads_cat"),"cid","pid");
function mydownloads()
{
global $xoopsDB, $xoopsModule;
xoops_cp_header();
echo "
";
xoops_cp_footer();
}
function downloadsConfigMenu()
{
global $xoopsDB, $myts, $eh, $mytree;
// Add a New Main Category
xoops_cp_header();
$downimg_array = XoopsLists::getImgListAsArray(XOOPS_ROOT_PATH."/modules/mydownloads/images/shots/");
echo "
"._MD_DLCONF."
";
echo"
"
."
";
echo "";
echo"
";
echo " ";
// Add a New Sub-Category
$result=$xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("mydownloads_cat")."");
list($numrows)=$xoopsDB->fetchRow($result);
if($numrows>0) {
echo"
"
."
";
echo "";
echo"
";
echo " ";
// If there is a category, add a New Download
echo"
\n";
// Show Registered Users Votes
$result5=$xoopsDB->query("SELECT ratingid, ratinguser, rating, ratinghostname, ratingtimestamp FROM ".$xoopsDB->prefix("mydownloads_votedata")." WHERE lid = $lid AND ratinguser != 0 ORDER BY ratingtimestamp DESC");
$votes = $xoopsDB->getRowsNum($result5);
echo "
\n";
$x++;
if ($colorswitch=="dddddd"){
$colorswitch="ffffff";
} else {
$colorswitch="dddddd";
}
}
// Show Unregistered Users Votes
$result5=$xoopsDB->query("SELECT ratingid, rating, ratinghostname, ratingtimestamp FROM ".$xoopsDB->prefix("mydownloads_votedata")." WHERE lid = $lid AND ratinguser = 0 ORDER BY ratingtimestamp DESC");
$votes = $xoopsDB->getRowsNum($result5);
echo "
";
xoops_cp_footer();
}
function delBrokenDownloads()
{
global $xoopsDB, $HTTP_GET_VARS, $eh;
$lid = $HTTP_GET_VARS['lid'];
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_broken"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_downloads"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
redirect_header("index.php",1,_MD_FILEDELETED);
}
function ignoreBrokenDownloads()
{
global $xoopsDB, $HTTP_GET_VARS, $eh;
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_broken"), $HTTP_GET_VARS['lid']);
$xoopsDB->query($sql) or $eh->show("0013");
redirect_header("index.php",1,_MD_BROKENDELETED);
}
function listModReq()
{
global $xoopsDB, $myts, $eh, $mytree, $xoopsModuleConfig;
$result = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("mydownloads_mod")." ORDER BY requestid");
$totalmodrequests = $xoopsDB->getRowsNum($result);
xoops_cp_header();
echo "
";
xoops_cp_footer();
}
function modCatS()
{
global $xoopsDB, $HTTP_POST_VARS, $myts, $eh;
$cid = $HTTP_POST_VARS['cid'];
$sid = $HTTP_POST_VARS['pid'];
$title = $myts->makeTboxData4Save($HTTP_POST_VARS['title']);
if (empty($title)) {
redirect_header("index.php", 2, _MD_ERRORTITLE);
exit();
}
if (($HTTP_POST_VARS["imgurl"]) || ($HTTP_POST_VARS["imgurl"]!="")) {
$imgurl = $myts->makeTboxData4Save($HTTP_POST_VARS["imgurl"]);
}
$sql = sprintf("UPDATE %s SET title = '%s', imgurl = '%s', pid = %u WHERE cid = %u", $xoopsDB->prefix("mydownloads_cat"), $title, $imgurl, $sid, $cid);
$xoopsDB->query($sql) or $eh->show("0013");
redirect_header("index.php",1,_MD_DBUPDATED);
}
function delCat()
{
global $xoopsDB, $HTTP_GET_VARS, $HTTP_POST_VARS, $eh, $mytree, $xoopsModule;
$cid = isset($HTTP_POST_VARS['cid']) ? intval($HTTP_POST_VARS['cid']) : intval($HTTP_GET_VARS['cid']);
$ok = isset($HTTP_POST_VARS['ok']) ? intval($HTTP_POST_VARS['ok']) : 0;
if ($ok == 1) {
//get all subcategories under the specified category
$arr=$mytree->getAllChildId($cid);
$lcount = count($arr);
for ($i = 0; $i < $lcount; $i++) {
//get all downloads in each subcategory
$result=$xoopsDB->query("SELECT lid FROM ".$xoopsDB->prefix("mydownloads_downloads")." WHERE cid=".$arr[$i]."") or $eh->show("0013");
//now for each download, delete the text data and vote ata associated with the download
while ( list($lid)=$xoopsDB->fetchRow($result) ) {
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_text"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_votedata"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_downloads"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
// delete comments
xoops_comment_delete($xoopsModule->getVar('mid'), $lid);
}
//all downloads for each subcategory is deleted, now delete the subcategory data
$sql = sprintf("DELETE FROM %s WHERE cid = %u", $xoopsDB->prefix("mydownloads_cat"), $arr[$i]);
$xoopsDB->query($sql) or $eh->show("0013");
}
//all subcategory and associated data are deleted, now delete category data and its associated data
$result=$xoopsDB->query("SELECT lid FROM ".$xoopsDB->prefix("mydownloads_downloads")." WHERE cid=".$cid."") or $eh->show("0013");
while(list($lid)=$xoopsDB->fetchRow($result)){
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_downloads"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_text"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
// delete comments
xoops_comment_delete($xoopsModule->getVar('mid'), $lid);
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_votedata"), $lid);
$xoopsDB->query($sql) or $eh->show("0013");
}
$sql = sprintf("DELETE FROM %s WHERE cid = %u", $xoopsDB->prefix("mydownloads_cat"), $cid);
$xoopsDB->query($sql) or $eh->show("0013");
redirect_header("index.php",1,_MD_CATDELETED);
exit();
} else {
xoops_cp_header();
echo "
"._MD_DLCONF."
";
xoops_confirm(array('op' => 'delCat', 'cid' => $cid, 'ok' => 1), 'index.php', _MD_WARNING);
xoops_cp_footer();
}
}
function delNewDownload()
{
global $xoopsDB, $HTTP_GET_VARS, $eh, $xoopsModule;
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_downloads"), $HTTP_GET_VARS['lid']);
$xoopsDB->query($sql) or $eh->show("0013");
$sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix("mydownloads_text"), $HTTP_GET_VARS['lid']);
$xoopsDB->query($sql) or $eh->show("0013");
// delete comments
xoops_comment_delete($xoopsModule->getVar('mid'), $HTTP_GET_VARS['lid']);
redirect_header("index.php",1,_MD_FILEDELETED);
}
function addCat()
{
global $xoopsDB, $HTTP_POST_VARS, $myts, $eh;
$pid = $HTTP_POST_VARS["cid"];
$title = $myts->makeTboxData4Save($HTTP_POST_VARS["title"]);
if (empty($title)) {
redirect_header("index.php", 2, _MD_ERRORTITLE);
}
if (($HTTP_POST_VARS["imgurl"]) || ($HTTP_POST_VARS["imgurl"]!="")) {
$imgurl = $myts->makeTboxData4Save($HTTP_POST_VARS["imgurl"]);
}
$newid = $xoopsDB->genId($xoopsDB->prefix("mydownloads_cat")."_cid_seq");
$sql = sprintf("INSERT INTO %s (cid, pid, title, imgurl) VALUES (%u, %u, '%s', '%s')", $xoopsDB->prefix("mydownloads_cat"), $newid, $pid, $title, $imgurl);
$xoopsDB->query($sql) or $eh->show("0013");
if ($newid == 0) {
$newid = $xoopsDB->getInsertId();
}
// Notify of new category
global $xoopsModule;
$tags = array();
$tags['CATEGORY_NAME'] = $title;
$tags['CATEGORY_URL'] = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/viewcat.php?cid=' . $newid;
$notification_handler =& xoops_gethandler('notification');
$notification_handler->triggerEvent('global', 0, 'new_category', $tags);
redirect_header("index.php",1,_MD_NEWCATADDED);
}
function addDownload()
{
global $xoopsDB, $xoopsUser, $xoopsModule, $HTTP_POST_VARS, $myts, $eh;
$url = $myts->makeTboxData4Save(formatURL($HTTP_POST_VARS["url"]));
$logourl = $myts->makeTboxData4Save($HTTP_POST_VARS["logourl"]);
$title = $myts->makeTboxData4Save($HTTP_POST_VARS["title"]);
$homepage = $myts->makeTboxData4Save(formatURL($HTTP_POST_VARS["homepage"]));
$version = $myts->makeTboxData4Save($HTTP_POST_VARS["version"]);
$size = $myts->makeTboxData4Save($HTTP_POST_VARS["size"]);
$platform = $myts->makeTboxData4Save($HTTP_POST_VARS["platform"]);
$description = $myts->makeTareaData4Save($HTTP_POST_VARS["description"]);
$submitter = $xoopsUser->uid();
$result = $xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("mydownloads_downloads")." WHERE url='$url'");
list($numrows) = $xoopsDB->fetchRow($result);
$error = 0;
$errormsg = "";
if ($numrows>0) {
$errormsg .= "
";
$errormsg .= _MD_ERROREXIST."
";
$error = 1;
}
// Check if Title exist
if ($title=="") {
$errormsg .= "
![](\"".XOOPS_URL."/modules/mydownloads/images/shots/".$origlogourl."\")
";
}else{
echo " ";
}
echo "![](\"".XOOPS_URL."/modules/mydownloads/images/shots/".$logourl."\")
";
} else {
echo " ";
}
echo "