Esempio n. 1
0
/**
* @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> &raquo; <a href='./items.php'>" . __('Download Items', 'dtransport') . "</a> &raquo; " . __('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();
}
Esempio n. 2
0
/**
* Muestra las características existentes de una descarga
*/
function dt_show_files($edit = 0)
{
    global $xoopsOption, $db, $tpl, $xoopsTpl, $xoopsUser, $mc, $dtfunc, $page, $item, $xoopsConfig, $xoopsModuleConfig, $file;
    include 'header.php';
    $dtfunc->cpHeader($item, sprintf(__('%s files', 'dtransport'), $item->getVar('name')));
    if ($file > 0 && $edit) {
        $file = new DTFile($file);
        if ($file->isNew() || $file->software() != $item->id()) {
            redirect_header(DT_URL . ($mc['permalinks'] ? '/cp/files/' . $item->id() . '/' : '/?p=cpanel&amp;action=files&amp;id=' . $item->id()), 1, __('Specified feature does not exists!', 'dtransport'));
        }
    }
    $tc = TextCleaner::getInstance();
    $tf = new RMTimeFormatter('', "%m%/%d%/%Y% %h%:%i%");
    $rmu = RMUtilities::get();
    $tfiles = $db->prefix('dtrans_files');
    $tgroup = $db->prefix('dtrans_groups');
    $sql = "SELECT * FROM {$tfiles} WHERE id_soft=" . $item->id();
    $gcache = array();
    $result = $db->queryF($sql);
    while ($rows = $db->fetchArray($result)) {
        $fl = new DTFile();
        $fl->assignVars($rows);
        if (!isset($gcache[$fl->group()])) {
            $gcache[$fl->group()] = new DTFileGroup($fl->group());
        }
        $group = $gcache[$fl->group()];
        $xoopsTpl->append('files', array('id' => $fl->id(), 'title' => $fl->title(), 'date' => $tf->format($fl->date()), 'software' => $item->getVar('name'), 'remote' => $fl->remote(), 'size' => $rmu->formatBytesSize($fl->size()), 'hits' => $fl->hits(), 'date' => $tf->format($fl->date()), 'group' => $group->isNew() ? '' : $group->name(), 'links' => array('edit' => DT_URL . ($mc['permalinks'] ? '/cp/files/' . $item->getVar('nameid') . '/edit/' . $fl->id() . '/' : '/?p=cpanel&amp;id=' . $item->id() . '&amp;action=files&amp;feature=' . $fl->id()), 'delete' => DT_URL . ($mc['permalinks'] ? '/cp/files/' . $item->getVar('nameid') . '/delete/' . $fl->id() . '/' : '/?p=cpanel&amp;id=' . $item->id() . '&amp;action=delete&amp;feature=' . $fl->id()))));
    }
    $formurl = DT_URL . ($mc['permalinks'] ? '/cp/files/' . $item->id() . '/save/' . ($edit ? $file->id() : '0') . '/' : '/p=cpanel');
    // files Form
    $form = new RMForm($edit ? sprintf(__('Editing file of "%s"', 'dtransport'), $item->getVar('name')) : sprintf(__('New file for "%s"', 'dtransport'), $item->getVar('name')), 'frmFile', $formurl);
    $form->setExtra('enctype="multipart/form-data"');
    $form->addElement(new RMFormLabel(__('Download item', 'dtransport'), $item->getVar('name')));
    $form->addElement(new RMFormText(__('File title', 'dtransport'), 'title', 50, 200, $edit ? $file->title() : ''), true);
    //Lista de grupos
    $sql = "SELECT * FROM " . $db->prefix('dtrans_groups') . " WHERE id_soft=" . $item->id();
    $result = $db->query($sql);
    $groups = array();
    while ($rows = $db->fetchArray($result)) {
        $group = new DTFileGroup();
        $group->assignVars($rows);
        $groups[] = array('id' => $group->id(), 'name' => $group->name());
    }
    $ele = new RMFormSelect(__('Group', 'dtransport'), 'group', 0, $edit ? $file->group() : '');
    $ele->addOption('', __('Select group...', 'dtransport'));
    foreach ($groups as $group) {
        $ele->addOption($group['id'], $group['name']);
    }
    $form->addElement($ele);
    $form->addElement(new RMFormYesNo(__('Default file', 'dtransport'), 'default', $edit ? $file->isDefault() : 0));
    $form->addElement(new RMFormYesNo(__('Remote file', 'dtransport'), 'remote', $edit ? $file->remote() : 0));
    $form->addElement(new RMFormFile(__('File', 'dtransport'), 'thefile', 50, $xoopsModuleConfig['size_file'] * 1024 * 1024));
    if ($edit) {
        $form->addElement(new RMFormLabel(__('Current file', 'dtransport'), $file->file()));
    }
    $form->addElement(new RMFormText(__('File URL', 'dtransport'), 'url', 50, 200, $edit ? $file->title() : ''))->setDescription(__('Used only when remote file is activated.', 'dtransport'));
    $form->addElement(new RMFormHidden('action', 'save'));
    $form->addElement(new RMFormHidden('id', $item->id()));
    $form->addElement(new RMFormHidden('file', $edit ? $file->id() : 0));
    $form->addElement(new RMFormHidden('op', 'save'));
    $buttons = new RMFormButtonGroup();
    $buttons->addButton('sbt', $edit ? __('Save Changes', 'dtransport') : __('Save File', 'dtransport'), 'submit');
    $buttons->addButton('cancel', __('Cancel', 'dtransport'), 'button', 'onclick="window.location=\'' . (DT_URL . ($mc['permalinks'] ? '/cp/files/' . $item->id() . '/' : '/?p=cpanel&amp;action=files&amp;id=' . $item->id())) . '\';"');
    $form->addElement($buttons);
    $xoopsTpl->assign('file_form', $form->render());
    $tpl->add_xoops_style('cpanel.css', 'dtransport');
    $tpl->add_head_script('$(document).ready(function(){
        
        $("a.delete").click(function(){
            if(!confirm("' . __('Do you really want to delete selected file?', 'dtransport') . '")) return false;
        });
        
    });');
    $xoopsTpl->assign('lang_id', __('ID', 'dtransport'));
    $xoopsTpl->assign('lang_title', __('Title', 'dtransport'));
    $xoopsTpl->assign('lang_group', __('Group', 'dtransport'));
    $xoopsTpl->assign('lang_remote', __('Remote', 'dtransport'));
    $xoopsTpl->assign('lang_size', __('Size', 'dtransport'));
    $xoopsTpl->assign('lang_hits', __('Hits', 'dtransport'));
    $xoopsTpl->assign('lang_date', __('Date', 'dtransport'));
    $xoopsTpl->assign('lang_edit', __('Edit', 'dtransport'));
    $xoopsTpl->assign('lang_delete', __('Delete', 'dtransport'));
    $xoopsTpl->assign('lang_addfile', __('Add File', 'dtransport'));
    $xoopsTpl->assign('edit', $edit);
    include 'footer.php';
}
Esempio n. 3
0
/**
 * Save a new or edited file to database
 */
function dt_save_file($edit = 0)
{
    global $xoopsSecurity, $functions, $db;
    foreach ($_POST as $k => $v) {
        ${$k} = $v;
    }
    if (!$xoopsSecurity->check()) {
        $functions->dt_send_message(__('Session token not valid!', 'dtransport'), 1, 0);
    }
    //Verificamos si el software es válido
    if ($item <= 0) {
        $functions->dt_send_message(__('Item download ID not provided!', 'dtransport'), 1, 1);
    }
    //Verificamos si existe el software
    $sw = new DTSoftware($item);
    if ($sw->isNew()) {
        $functions->dt_send_message(__('Specified item download does nto exists!', 'dtransport'), 1, 1);
    }
    if ($edit) {
        //Verificamos si archivo es válido
        if ($id <= 0) {
            $functions->dt_send_message(__('File ID has not been provided!', 'dtransport'), 1, 1);
        }
        //Verificamos si existe archivo
        $fl = new DTFile($id);
        if ($fl->isNew()) {
            $functions->dt_send_message(__('Specified file does not exists!', 'dtransport'), 1, 1);
        }
        // Si es un archivo remoto eliminamos el archivo actual
        if (!$fl->remote() && $remote) {
            $rmu = RMUtilities::get();
            $mc = $rmu->module_config('dtransport');
            $dir = $sw->getVar('secure') ? $mc['directory_secure'] : $mc['directory_insecure'];
            if (file_exists($dir . '/' . $fl->file())) {
                unlink($dir . '/' . $fl->file());
            }
            unset($dir, $mc, $rmu);
        }
    } else {
        $fl = new DTFile();
    }
    $fl->setSoftware($item);
    $fl->setRemote($remote);
    $fl->setFile($file);
    $fl->setDefault($default);
    $fl->setGroup($group);
    $fl->setDate(time());
    $fl->setTitle(trim($title));
    $fl->setMime($mime);
    $fl->setSize($size);
    if (!$fl->save()) {
        $functions->dt_send_message(__('File could not be saved!', 'dtransport') . '<br />' . $fl->errors(), 1, 1);
    } else {
        if ($fl->isDefault()) {
            $db->queryF("UPDATE " . $db->prefix("dtrans_files") . " SET `default`=0 WHERE id_soft=" . $sw->id() . " AND id_file !=" . $fl->id());
        }
        $ret = array('message' => __('File saved successfully!', 'dtransport'));
        showMessage(sprintf(__('File %s saved successfully!', 'dtransport'), $fl->title()), RMMSG_SAVED);
        $functions->dt_send_message($ret, 0, 1);
    }
}