<?php
/**
* $Id: modifications.php v 1.03 06 july 2004 Liquid Exp $
* Module: WF-Downloads
* Version: v2.0.5a
* Release Date: 26 july 2004
* Author: WF-Sections
* Licence: GNU
*/
include 'admin_header.php';
if (!isset($_POST['op']))
{
$op = isset($_GET['op']) ? $_GET['op'] : 'main';
}
else
{
$op = $_POST['op'];
}
switch ($op)
{
case "listModReqshow":
include XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
global $xoopsDB, $myts, $mytree, $xoopsModuleConfig, $xoopsUser;
xoops_cp_header();
xtorrent_adminmenu(_AM_XTORRENT_MOD_MODREQUESTS);
$requestid = intval($_GET['requestid']);
$sql = "SELECT lid, title, url, mirror, homepage, homepagetitle, cid, version, submitter, size, platform,
license, limitations, price, description, features, requirements, dhistory, screenshot, modifysubmitter, requestid
FROM " . $xoopsDB->prefix('xtorrent_mod') . " WHERE requestid=" . $_GET['requestid'];
$mod_array = $xoopsDB->fetchArray($xoopsDB->query($sql));
unset($sql);
$sql = "SELECT lid, title, url, mirror, homepage, homepagetitle, cid, version, publisher, size, platform,
license, limitations, price, description, features, requirements, dhistory, screenshot, submitter
FROM " . $xoopsDB->prefix('xtorrent_downloads') . " WHERE lid=" . $mod_array['lid'] ;
$orig_array = $xoopsDB->fetchArray($xoopsDB->query($sql));
unset($sql);
$orig_user = new XoopsUser($orig_array['submitter']);
$submittername = xoops_getLinkedUnameFromId($orig_array['submitter']); // $orig_user->getvar("uname");
$submitteremail = $orig_user->getUnameFromId("email");
echo "<div><b>" . _AM_XTORRENT_MOD_MODPOSTER . "</b> $submittername</div>";
$not_allowed = array("lid", "submitter", "requestid", "modifysubmitter");
$sform = new XoopsThemeForm(_AM_XTORRENT_MOD_ORIGINAL, "storyform", "index.php");
foreach ($orig_array as $key => $content)
{
if (in_array($key , $not_allowed))
{
continue;
}
$lang_def = constant("_AM_XTORRENT_MOD_" . strtoupper($key));
if ($key == "platform" || $key == "license" || $key == "limitations")
$content = $xoopsModuleConfig[$key][$orig_array[$key]];
if ($key == "cid")
{
$sql = "SELECT title FROM " . $xoopsDB->prefix('xtorrent_cat') . " WHERE cid=" . $content . "";
$row = $xoopsDB->fetchArray($xoopsDB->query($sql));
$content = $row['title'];
}
if ($key == "forumid")
{
$content = '';
$modhandler = &xoops_gethandler('module');
$xoopsforumModule = &$modhandler->getByDirname('newbb');
$sql = "SELECT title FROM " . $xoopsDB->prefix('bb_categories') . " WHERE cid=" . $content . "";
if ($xoopsforumModule && $content > 0)
{
$content = "<a href='" . XOOPS_URL . "/modules/newbb/viewforum.php?forum=" . $content . "'>Forumid</a>";
}
else
{
$content = '';
}
}
if ($key == "screenshot")
{
$content = '';
if ($content > 0)
$content = "<img src='" . XOOPS_URL . "/" . $xoopsModuleConfig['screenshots'] . "/" . $logourl . "' width='" . $xoopsModuleConfig['shotwidth'] . "' alt='' />";
}
if ($key == "features" || $key == "requirements")
{
if ($content != '')
{
$downrequirements = explode('|', trim($content));
foreach ($downrequirements as $bi)
{
$content = "<li>" . $bi;
}
}
}
if ($key == "dhistory")
{
$content = $myts->displayTarea($content, 1, 0, 0, 0, 1);;
}
$sform->addElement(new XoopsFormLabel($lang_def, $content));
}
$sform->display();
$orig_user = new XoopsUser($mod_array['modifysubmitter']);
$submittername = xoops_getLinkedUnameFromId($mod_array['modifysubmitter']);
$submitteremail = $orig_user->getUnameFromId("email");
echo "<div><b>" . _AM_XTORRENT_MOD_MODIFYSUBMITTER . "</b> $submittername</div>";
$sform = new XoopsThemeForm(_AM_XTORRENT_MOD_PROPOSED, "storyform", "modifications.php");
foreach ($mod_array as $key => $content)
{
if (in_array($key, $not_allowed))
{
Continue;
}
$lang_def = constant("_AM_XTORRENT_MOD_" . strtoupper($key));
if ($key == "platform" || $key == "license" || $key == "limitations")
$content = $xoopsModuleConfig[$key][$orig_array[$key]];
if ($key == "cid")
{
$sql = "SELECT title FROM " . $xoopsDB->prefix('xtorrent_cat') . " WHERE cid=" . $content . "";
$row = $xoopsDB->fetchArray($xoopsDB->query($sql));
$content = $row['title'];
}
if ($key == "forumid")
{
$content = '';
$modhandler = &xoops_gethandler('module');
$xoopsforumModule = &$modhandler->getByDirname('newbb');
$sql = "SELECT title FROM " . $xoopsDB->prefix('bb_categories') . " WHERE cid=" . $content . "";
$content = '';
if ($xoopsforumModule && $content > 0)
{
$content = "<a href='" . XOOPS_URL . "/modules/newbb/viewforum.php?forum=" . $content . "'>Forumid</a>";
}
}
if ($key == "screenshot")
{
$content = '';
if ($content > 0)
$content = "<img src='" . XOOPS_URL . "/" . $xoopsModuleConfig['screenshots'] . "/" . $logourl . "' width='" . $xoopsModuleConfig['shotwidth'] . "' alt='' />";
}
if ($key == "features" || $key == "requirements")
{
if ($content != '')
{
$downrequirements = explode('|', trim($content));
foreach ($downrequirements as $bi)
{
$content = "<li>" . $bi;
}
}
}
if ($key == "dhistory")
{
$content = $myts->displayTarea($content, 1, 0, 0, 0, 1);;
}
$sform->addElement(new XoopsFormLabel($lang_def, $content));
}
$button_tray = new XoopsFormElementTray('', '');
$button_tray->addElement(new XoopsFormHidden('requestid', $requestid));
$button_tray->addElement(new XoopsFormHidden('lid', $mod_array['requestid']));
$hidden = new XoopsFormHidden('op', 'changeModReq');
$button_tray->addElement($hidden);
if ($mod_array)
{
$butt_dup = new XoopsFormButton('', '', _AM_XTORRENT_BAPPROVE, 'submit');
$butt_dup->setExtra('onclick="this.form.elements.op.value=\'changeModReq\'"');
$button_tray->addElement($butt_dup);
}
$butt_dupct2 = new XoopsFormButton('', '', _AM_XTORRENT_BIGNORE, 'submit');
$butt_dupct2->setExtra('onclick="this.form.elements.op.value=\'ignoreModReq\'"');
$button_tray->addElement($butt_dupct2);
$sform->addElement($button_tray);
$sform->display();
xoops_cp_footer();
exit();
break;
case "changeModReq":
global $xoopsDB, $_POST, $eh, $myts;
$sql = "SELECT * FROM " . $xoopsDB->prefix('xtorrent_mod') . " WHERE requestid=" . $_POST['requestid'] . "";
$down_array = $xoopsDB->fetchArray($xoopsDB->query($sql));
$lid = $down_array['lid'];
$cid = $down_array['cid'];
$title = $down_array['title'];
$url = $down_array['url'];
$homepage =$down_array['homepage'];
$homepagetitle = $down_array['homepagetitle'];
$version = $down_array['version'];
$size = $down_array['size'];
$platform = $down_array['platform'];
$publisher = $down_array['publisher'];
$screenshot = $down_array['screenshot'];
$price = $down_array['price'];
$description = $down_array['description'];
$mirror = $down_array['mirror'];
$license = $down_array['license'];
$features = $down_array['features'];
$requirements = $down_array['requirements'];
$limitations = $down_array['limitations'];
$dhistory = $down_array['dhistory'];
$submitter = $down_array['submitter'];
$updated = time();
$xoopsDB->query("UPDATE " . $xoopsDB->prefix('xtorrent_downloads') . " SET cid = $cid, title = '$title',
url = '$url', mirror = '$mirror', license = '$license', features = '$features', homepage = '$homepage', version = '$version', size = $size, platform = '$platform',
screenshot = '$screenshot', publisher = '$publisher', status = '2', price = '$price', requirements = '$requirements',
homepagetitle = '$homepagetitle', limitations = '$limitations', dhistory = '$dhistory', updated = '$updated',
description = '$description' WHERE lid = $lid");
$sql = "DELETE FROM " . $xoopsDB->prefix('xtorrent_mod') . " WHERE requestid = " . $_POST['requestid'] . "";
$result = $xoopsDB->query($sql);
redirect_header('index.php', 1, _AM_XTORRENT_MOD_REQUPDATED);
break;
case "ignoreModReq":
global $xoopsDB, $_POST;
$sql = sprintf("DELETE FROM " . $xoopsDB->prefix('xtorrent_mod') . " WHERE requestid = " . $_POST['requestid'] . "");
$xoopsDB->query($sql);
redirect_header('index.php', 1, _AM_XTORRENT_MOD_REQDELETED);
break;
case 'main':
default:
include_once XOOPS_ROOT_PATH . '/class/xoopstree.php';
global $xoopsModuleConfig;
$start = isset($_GET['start']) ? intval($_GET['start']) : 0;
$mytree = new XoopsTree($xoopsDB->prefix('xtorrent_mod'), "requestid", 0);
global $xoopsDB, $myts, $mytree, $xoopsModuleConfig;
$sql = "SELECT * FROM " . $xoopsDB->prefix('xtorrent_mod') . " ORDER BY requestdate DESC" ;
$result = $xoopsDB->query($sql, $xoopsModuleConfig['admin_perpage'] , $start);
$totalmodrequests = $xoopsDB->getRowsNum($xoopsDB->query($sql));
xoops_cp_header();
xtorrent_adminmenu(_AM_XTORRENT_MOD_MODREQUESTS);
echo "
<fieldset><legend style='font-weight: bold; color: #900;'>" . _AM_XTORRENT_MOD_MODREQUESTSINFO . "</legend>\n
<div style='padding: 8px;'>" . _AM_XTORRENT_MOD_TOTMODREQUESTS . " <b>$totalmodrequests</></div>\n
</fieldset><br />\n
<table width='100%' cellspacing='1' cellpadding='2' border='0' class='outer'>\n
<tr>\n
<th align='center'><b>" . _AM_XTORRENT_MOD_MODID . "</b></th>\n
<th><b>" . _AM_XTORRENT_MOD_MODTITLE . "</b></th>\n
<th align='center'><b>" . _AM_XTORRENT_MOD_MODIFYSUBMIT . "</b></th>\n
<th align='center'><b>" . _AM_XTORRENT_MOD_DATE . "</b></th>\n
<th align='center'><b>" . _AM_XTORRENT_MINDEX_ACTION . "</b></th>\n
</tr>\n";
if ($totalmodrequests > 0)
{
while ($down_arr = $xoopsDB->fetchArray($result))
{
$path = $mytree->getNicePathFromId($down_arr['requestid'], "title", "modifications.php?op=listModReqshow&requestid");
$path = str_replace("/", "", $path);
$path = str_replace(":", "", trim($path));
$title = trim($path);
$submitter = xoops_getLinkedUnameFromId($down_arr['modifysubmitter']);;
$requestdate = formatTimestamp($down_arr['requestdate'], $xoopsModuleConfig['dateformat']);
echo "
<tr>\n
<td class='head' align='center'>" . $down_arr['requestid'] . "</td>\n
<td class='even'>" . $title . "</td>\n
<td class='even' align='center'>" . $submitter . "</td>\n
<td class='even' align='center'>" . $requestdate . "</td>\n
<td class='even' align='center'> <a href='modifications.php?op=listModReqshow&requestid=" . $down_arr['requestid'] . "'>"._AM_XTORRENT_MOD_VIEW."</a></td>\n
</tr>\n";
}
}
else
{
echo "<tr><td class='head' align='center' colspan='7'>" . _AM_XTORRENT_MOD_NOMODREQUEST . "</td></tr>";
}
echo "</table>\n";
include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
$page = ($totalmodrequests > $xoopsModuleConfig['admin_perpage']) ? _AM_XTORRENT_MINDEX_PAGE : '';
$pagenav = new XoopsPageNav($totalmodrequests, $xoopsModuleConfig['admin_perpage'], $start, 'start');
echo "<div align='right' style='padding: 8px;'>" . $page . '' . $pagenav->renderNav() . '</div>';
xoops_cp_footer();
}
?>