$xoopsMailer->setToGroups($g);
$xoopsMailer->setFromEmail($xoopsConfig['adminmail']);
$xoopsMailer->setFromName($xoopsConfig['sitename']);
$xoopsMailer->setSubject(sprintf(_MS_DT_SUBJECT, $item->getVar('name')));
if (!$xoopsMailer->send(true)) {
redirect_header(XOOPS_URL . '/modules/dtransport/mydownloads.php', 2, $xoopsMailer->getErrors());
}
} else {
if (!$mc['aprove_edit'] && $mc['edit_notif'] && $app) {
$xoopsMailer =& getMailer();
$xoopsMailer->usePM();
$xoopsMailer->setTemplate('edit_download.tpl');
$xoopsMailer->assign('SITENAME', $xoopsConfig['sitename']);
$xoopsMailer->assign('ADMINMAIL', $xoopsConfig['adminmail']);
$xoopsMailer->assign('SITEURL', XOOPS_URL . "/");
$xoopsMailer->assign('LINK_RESOURCE', XOOPS_URL . "/modules/dtransport/admin/items.php?op=edit&type=edit&id=" . $item->software());
$xoopsMailer->setTemplateDir(XOOPS_ROOT_PATH . "/modules/dtransport/language/" . $xoopsConfig['language'] . "/mail_template/");
foreach ($mc['groups_notif'] as $k) {
$g[] = new XoopsGroup($k);
}
$xoopsMailer->setToGroups($g);
$xoopsMailer->setFromEmail($xoopsConfig['adminmail']);
$xoopsMailer->setFromName($xoopsConfig['sitename']);
$xoopsMailer->setSubject(sprintf(_MS_DT_SUBJECTEDIT, $item->name()));
if (!$xoopsMailer->send(true)) {
redirect_header(XOOPS_URL . '/modules/dtransport/mydownloads.php', 2, $xoopsMailer->getErrors());
}
}
}
redirect_header(DT_URL . ($mc['permalinks'] ? '/cp/' : '/?p=cp'), 2, $edit ? __('Changes saved successfully!', 'dtransport') : __('Download item created successfully'));
}
/**
* @desc Muestra todos lo elementos registrados
**/
function dt_show_items()
{
define('RMCSUBLOCATION', 'downitems');
global $xoopsModule, $xoopsSecurity;
$search = rmc_server_var($_REQUEST, 'search', '');
$sort = rmc_server_var($_REQUEST, 'sort', 'id_soft');
$mode = rmc_server_var($_REQUEST, 'mode', 1);
$sort = $sort == '' ? 'id_soft' : $sort;
$catid = rmc_server_var($_REQUEST, 'cat', 0);
$type = rmc_server_var($_REQUEST, 'type', '');
//Barra de Navegación
$db = XoopsDatabaseFactory::getDatabaseConnection();
$sql = "SELECT COUNT(*) FROM " . ($type == 'edit' ? $db->prefix('dtrans_software_edited') : $db->prefix('dtrans_software'));
$sql .= $catid ? " WHERE id_cat='{$catid}'" : '';
$sql .= $type == 'wait' ? $catid ? " AND approved=0" : " WHERE approved=0" : "";
$sql1 = '';
if ($search) {
$words = explode(" ", $search);
foreach ($words as $k) {
//Verificamos si la palabra proporcionada es mayor a 2 caracteres
if (strlen($k) <= 2) {
continue;
}
$sql1 .= ($sql1 == '' ? $catid || $type == 'wait' ? " AND " : " WHERE " : " OR ") . " (name LIKE '%{$k}%' OR uname LIKE '%{$k}%') ";
}
}
$sql2 = " ORDER BY {$sort} " . ($mode ? "DESC" : "ASC");
list($num) = $db->fetchRow($db->queryF($sql . $sql1 . $sql2));
$page = rmc_server_var($_REQUEST, 'page', 1);
$limit = 15;
$nav = new RMPageNav($num, $limit, $page);
$nav->target_url("items.php?search={$search}&sort={$sort}&mode={$mode}&cat={$catid}&type={$type}&page={PAGE_NUM}");
$navpage = $nav->render(false, true);
$start = $nav->start();
//Fin de barra de navegación
$catego = new DTCategory($catid);
$sql = "SELECT * FROM " . ($type == 'edit' ? $db->prefix('dtrans_software_edited') : $db->prefix('dtrans_software'));
$sql .= $catid ? " WHERE id_cat={$catid}" : '';
$sql .= $type == 'wait' ? $catid ? " AND approved=0" : " WHERE approved=0" : "";
$sql2 .= " LIMIT {$start},{$limit}";
$result = $db->queryF($sql . $sql1 . $sql2);
$items = array();
$timeFormat = new RMTimeFormatter(0, '%m%-%d%-%Y%');
while ($rows = $db->fetchArray($result)) {
if ($type == 'edit') {
$sw = new DTSoftwareEdited();
} else {
$sw = new DTSoftware();
}
$sw->assignVars($rows);
$img = new RMImage($sw->getVar('image'));
$user = new XoopsUser($sw->getVar('uid'));
$items[] = array('id' => $type == 'edit' ? $sw->software() : $sw->id(), 'name' => $sw->getVar('name'), 'screens' => $sw->getVar('screens'), 'image' => $img->get_smallest(), 'secure' => $sw->getVar('secure'), 'approved' => $sw->getVar('approved'), 'uname' => $user->getVar('uname'), 'created' => $timeFormat->format($sw->getVar('created')), 'modified' => $timeFormat->format($sw->getVar('modified')), 'link' => $sw->permalink(), 'featured' => $sw->getVar('featured'), 'daily' => $sw->getVar('daily'), 'password' => $sw->getVar('password') != '', 'deletion' => $sw->getVar('delete'));
}
//Lista de categorías
$categories = array();
DTFunctions::getCategos($categos, 0, 0, array(), true);
foreach ($categos as $k) {
$cat = $k['object'];
$categories[] = array('id' => $cat->id(), 'name' => str_repeat('--', $k['jumps']) . ' ' . $cat->name());
}
switch ($type) {
case 'wait':
$loc = __('Pending Downloads', 'dtransport');
break;
case 'edit':
$loc = __('Edited Downloads', 'dtransport');
break;
default:
$loc = __('Downloads Management', 'dtransport');
break;
}
DTFunctions::toolbar();
$tpl = RMTemplate::get();
$tpl->add_style('admin.css', 'dtransport');
$tpl->add_local_script('admin.js', 'dtransport');
$tpl->add_local_script('items.js', 'dtransport');
$tpl->add_local_script('jquery.checkboxes.js', 'rmcommon', 'include');
include DT_PATH . '/include/js_strings.php';
xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » " . $loc);
xoops_cp_header();
include RMTemplate::get()->get_template('admin/dtrans_items.php', 'module', 'dtransport');
xoops_cp_footer();
}
