/** * @des Visualiza todas las pantallas existentes **/ function showScreens() { global $xoopsModule, $xoopsSecurity, $tpl, $functions, $xoopsModule, $xoopsModuleConfig, $xoopsUser, $xoopsConfig; define('RMCSUBLOCATION', 'screenshots'); if ($xoopsConfig['closesite']) { showMessage(__('Screenshop uploader does not work when site is closed. Before to start uploding, please change this configuration.', 'rmcommon'), RMMSG_WARN); } $db = XoopsDatabaseFactory::getDatabaseConnection(); $tc = TextCleaner::getInstance(); $item = rmc_server_var($_REQUEST, 'item', 0); if ($item <= 0) { redirectMsg('items.php', __('Download item ID not provided!', 'dtransport'), RMMSG_WARN); } $sw = new DTSoftware($item); $sql = "SELECT * FROM " . $db->prefix('dtrans_screens') . " WHERE id_soft={$item}"; $result = $db->queryF($sql); while ($rows = $db->fetchArray($result)) { $sc = new DTScreenshot(); $sc->assignVars($rows); $screens[] = array('id' => $sc->id(), 'title' => $sc->title(), 'desc' => substr($tc->clean_disabled_tags($sc->desc()), 0, 80) . "...", 'image' => XOOPS_UPLOAD_URL . '/screenshots/' . date('Y', $sc->date()) . '/' . date('m', $sc->date()) . '/ths/' . $sc->image()); } // CSS Styles $tpl->add_style('admin.css', 'dtransport'); $tpl->add_style('screens.css', 'dtransport'); $tpl->add_style('uploadify.css', 'rmcommon'); // Javascripts $tpl->add_local_script('swfobject.js', 'rmcommon', 'include'); $tpl->add_local_script('jquery.uploadify.js', 'rmcommon', 'include'); $tpl->add_local_script('screens.js', 'dtransport'); $tc = TextCleaner::getInstance(); $rmf = RMFunctions::get(); ob_start(); include DT_PATH . '/js/screenshots.js'; $script = ob_get_clean(); $tpl->add_head_script($script); $functions->toolbar(); xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » <a href='items.php'>" . __('Downloads', 'dtransport') . "</a> » " . __('Screenshots Management', 'dtransport')); $tpl->assign('xoops_pagetitle', sprintf(__("%s Screenshots", 'dtransport'), $sw->getVar('name'))); include DT_PATH . '/include/js_strings.php'; xoops_cp_header(); include $tpl->get_template('admin/dtrans_screens.php', 'module', 'dtransport'); xoops_cp_footer(); }
public function delete() { //Eliminamos las relaciones con etiquetas $sql = "DELETE FROM " . $this->db->prefix('dtrans_softtag') . " WHERE id_soft=" . $this->id(); $result = $this->db->queryF($sql); if (!$result) { return false; } //Eliminar caracteristicas $sql = "DELETE FROM " . $this->db->prefix('dtrans_features') . " WHERE id_soft=" . $this->id(); $result = $this->db->queryF($sql); if (!$result) { return false; } //Eliminar pantallas $sql = "SELECT * FROM " . $this->db->prefix('dtrans_screens') . " WHERE id_soft=" . $this->id(); $result = $this->db->queryF($sql); while ($rows = $this->db->fetchArray($result)) { $sc = new DTScreenshot(); $sc->assignVars($rows); $sc->delete(); } //Eliminar Archivos $sql = "SELECT * FROM " . $this->db->prefix('dtrans_files') . " WHERE id_soft=" . $this->id(); $result = $this->db->queryF($sql); while ($rows = $this->db->fetchArray($result)) { $file = new DTFile(); $file->assignVars($rows); $file->delete($this); } //Eliminar Logs $sql = "DELETE FROM " . $this->db->prefix('dtrans_logs') . " WHERE id_soft=" . $this->id(); $result = $this->db->queryF($sql); if (!$result) { return false; } //Eliminar grupo $sql = "DELETE FROM " . $this->db->prefix('dtrans_groups') . " WHERE id_soft=" . $this->id(); $result = $this->db->queryF($sql); if (!$result) { return false; } //Eliminar relación de licencias $sql = "DELETE FROM " . $this->db->prefix('dtrans_licsoft') . " WHERE id_soft=" . $this->id(); $result = $this->db->queryF($sql); if (!$result) { return false; } //Eliminar relación de plataformas $sql = "DELETE FROM " . $this->db->prefix('dtrans_platsoft') . " WHERE id_soft=" . $this->id(); $result = $this->db->queryF($sql); if (!$result) { return false; } //Eliminar alerta $sql = "DELETE FROM " . $this->db->prefix('dtrans_alerts') . " WHERE id_soft=" . $this->id(); $result = $this->db->queryF($sql); if (!$result) { return false; } return $this->deleteFromTable(); }
/** * @desc Obtiene las caracteristicas del elemento * @param bool True devuelve objetos {@link STScreenshot} * @return array */ function screens($asobj = false) { if (empty($this->_screens) || $asobj && !is_a($this->_screens[0], 'DTScreenshot')) { $this->_screens = array(); $sql = "SELECT * FROM " . $this->db->prefix("dtrans_screens") . " WHERE id_soft='" . $this->id() . "' ORDER BY modified DESC"; $result = $this->db->query($sql); while ($row = $this->db->fetchArray($result)) { if ($asobj) { $tmp = new DTScreenshot(); $tmp->assignVars($row); } else { $tmp = $row['id_screen']; } $this->_screens[] = $tmp; } } return $this->_screens; }
/** * @desc Visualiza las pantallas del software y * el formulario de creación de pantallas **/ function dt_screens($edit = 0) { global $xoopsOption, $db, $tpl, $xoopsTpl, $xoopsUser, $mc, $dtfunc, $page, $item, $xoopsConfig, $xoopsModuleConfig, $screen; include 'header.php'; $dtfunc->cpHeader($item, sprintf(__('Screenshots for "%s"', 'dtransport'), $item->getVar('name'))); $tc = TextCleaner::getInstance(); $sql = "SELECT * FROM " . $db->prefix('dtrans_screens') . " WHERE id_soft=" . $item->id(); $result = $db->queryF($sql); while ($rows = $db->fetchArray($result)) { $sc = new DTScreenshot(); $sc->assignVars($rows); $xoopsTpl->append('screens', array('id' => $sc->id(), 'title' => $sc->title(), 'desc' => $tc->clean_disabled_tags($sc->desc()), 'software' => $item->getVar('name'), 'image' => $sc->url('ths'), 'links' => array('edit' => DT_URL . ($mc['permalinks'] ? '/cp/screens/' . $item->getVar('nameid') . '/edit/' . $sc->id() . '/' : '/?p=cpanel&id=' . $item->id() . '&action=screens&screen=' . $sc->id()), 'delete' => DT_URL . ($mc['permalinks'] ? '/cp/screens/' . $item->getVar('nameid') . '/delete/' . $sc->id() . '/' : '/?p=cpanel&id=' . $item->id() . '&action=delete&screen=' . $sc->id())))); } //Formulario de pantallas if ($edit) { //Verificamos si la pantalla es válida if ($screen <= 0) { redirect_header(DT_URL . ($mc['permalinks'] ? '/screens/' . $item->getVar('nameid') : '/?p=cpanel&action=screens&id=' . $item->id()), 1, __('Invalid screen', 'dtransport')); } //Verificamos si la pantalla existe $sc = new DTScreenshot($screen); if ($sc->isNew()) { redirect_header(DT_URL . ($mc['permalinks'] ? '/screens/' . $item->getVar('nameid') : '/?p=cpanel&action=screens&id=' . $item->id()), 1, __('Invalid screen', 'dtransport')); } } if ($edit || $mc['limit_screen'] > $item->getVar('screens')) { if ($edit) { $faction = DT_URL . ($mc['permalinks'] ? '/cp/screens/' . $item->id() . '/save/' . $sc->id() . '/' : ''); } else { $faction = DT_URL . ($mc['permalinks'] ? '/cp/screens/' . $item->id() . '/save/0/' : ''); } $form = new RMForm($edit ? sprintf(__('Edit Screenshot of %s', 'dtransport'), $item->getVar('name')) : sprintf(__('Add screen for %s', 'dtransport'), $item->getVar('name')), 'frmscreen', $faction); $form->setExtra("enctype='multipart/form-data'"); $form->addElement(new RMFormLabel(__('Download item', 'dtransport'), $item->getVar('name'))); $form->addElement(new RMFormText(__('Title', 'dtransport'), 'title', 50, 100, $edit ? $sc->title() : ''), true); $form->addElement(new RMFormEditor(__('Description', 'dtransport'), 'desc', 'auto', '100px', $edit ? $sc->desc() : '', 'simple')); $form->addElement(new RMFormFile(__('Image file', 'dtransport'), 'image', 45, $xoopsModuleConfig['image'] * 1024), $edit ? '' : true); if ($edit) { $img = "<img src='" . $sc->url('ths') . "' border='0' />"; $form->addElement(new RMFormLabel(__('Current image', 'dtransport'), $img)); } $form->addElement(new RMFormHidden('p', 'cpanel')); $form->addElement(new RMFormHidden('action', 'screens')); $form->addElement(new RMFormHidden('id', $item->id())); $form->addElement(new RMFormHidden('op', 'save')); $form->addElement(new RMFormHidden('screen', $edit ? $sc->id() : 0)); $buttons = new RMFormButtonGroup(); $buttons->addButton('sbt', $edit ? __('Save Changes', 'dtransport') : __('Save Screenshot', 'dtransport'), 'submit'); $buttons->addButton('cancel', __('Cancel', 'dtransport'), 'button', 'onclick="window.location=\'' . DT_URL . ($mc['permalinks'] ? '/cp/screens/' . $item->getVar('nameid') . '/' : '/?p=cpanel&action=screens&id=' . $item->id()) . '\';"'); $form->addElement($buttons); $xoopsTpl->assign('formscreens', $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 images?', 'dtransport') . '")) return false; }); });'); $xoopsTpl->assign('lang_id', __('ID', 'dtransport')); $xoopsTpl->assign('lang_title', __('Title', 'dtransport')); $xoopsTpl->assign('lang_desc', __('Description', 'dtransport')); $xoopsTpl->assign('lang_opts', __('Options', 'dtransport')); $xoopsTpl->assign('lang_edit', __('Edit', 'dtransport')); $xoopsTpl->assign('lang_delete', __('Delete', 'dtransport')); $xoopsTpl->assign('lang_image', __('Image', 'dtransport')); $xoopsTpl->assign('lang_deletescreen', _MS_DT_DELETESCREEN); $xoopsTpl->assign('lang_deletescreens', _MS_DT_DELETESCREENS); $xoopsTpl->assign('edit', $edit); include 'footer.php'; }