$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(); }