/** * @desc Visualiza todos los archivos de un software **/ function showFiles() { global $xoopsModule, $xoopsSecurity, $tpl; define("RMCSUBLOCATION", 'fileslist'); $item = rmc_server_var($_REQUEST, 'item', 0); $edit = rmc_server_var($_REQUEST, 'edit', 0); $id = rmc_server_var($_REQUEST, 'id', 0); $db = XoopsDatabaseFactory::getDatabaseConnection(); if ($item <= 0) { redirectMsg('items.php', __('Before to view files, you must specify a download item!', 'dtransport'), RMMSG_INFO); } $sw = new DTSoftware($item); if ($sw->isNew()) { redirectMsg('items.php', __('Specified item does not exists!', 'dtransport'), RMMSG_WARN); } $files = array(); // Files data container //Archivos sin grupo $sql = "SELECT * FROM " . $db->prefix('dtrans_files') . " WHERE id_soft={$item} AND `group`=0"; $result = $db->queryF($sql); while ($rows = $db->fetchArray($result)) { $fl = new DTFile(); $fl->assignVars($rows); $files[] = array('id' => $fl->id(), 'file' => $fl->file(), 'downs' => $fl->hits(), 'group' => $fl->group(), 'default' => $fl->isDefault(), 'remote' => $fl->remote(), 'type' => 'files', 'title' => $fl->title()); } //Grupos pertenecientes al software $groups = $sw->filegroups(); foreach ($groups as $k) { $gr = new DTFileGroup($k); $files[] = array('id' => $gr->id(), 'file' => $gr->name(), 'type' => 'group'); $sql = "SELECT * FROM " . $db->prefix('dtrans_files') . " WHERE id_soft={$item} AND `group`={$k}"; $result = $db->queryF($sql); while ($rows = $db->fetchArray($result)) { $fl = new DTFile(); $fl->assignVars($rows); $files[] = array('id' => $fl->id(), 'file' => $fl->file(), 'downs' => $fl->hits(), 'group' => $fl->group(), 'default' => $fl->isDefault(), 'remote' => $fl->remote(), 'type' => 'files', 'title' => $fl->title()); } } $groups = array(); //Lista de grupos $sql = "SELECT * FROM " . $db->prefix('dtrans_groups') . " WHERE id_soft={$item}"; $result = $db->queryF($sql); while ($rows = $db->fetchArray($result)) { $group = new DTFileGroup(); $group->assignVars($rows); $groups[] = array('id' => $group->id(), 'name' => $group->name()); } xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » <a href='./items.php'>" . __('Download Items', 'dtransport') . "</a> » " . __('Files Management', 'dtransport')); // Title $title = sprintf(__('Files for "%s"', 'dtransport'), $sw->getVar('name')); $tpl->assign('xoops_pagetitle', $title); DTFunctions::toolbar(); $tpl->add_style('admin.css', 'dtransport'); include DT_PATH . '/include/js_strings.php'; $tpl->add_local_script('admin.js', 'dtransport'); $tpl->add_local_script('files.js', 'dtransport'); $tpl->add_local_script('jquery.checkboxes.js', 'rmcommon', 'include'); xoops_cp_header(); include $tpl->get_template('admin/dtrans_files.php', 'module', 'dtransport'); xoops_cp_footer(); }