/**
* @desc Obtiene las plataformas a las que pertenece el elemento
* @param bool True obtiene los objetos {@link DTPlatform}
* @return array
*/
public function platforms($asobj = false)
{
$tbl1 = $this->db->prefix("dtrans_platsoft");
$tbl2 = $this->db->prefix("dtrans_platforms");
if (empty($this->_platforms) || $asobj && !is_a($this->_platforms, 'DTPlatform')) {
$this->_platforms = array();
$sql = "SELECT b.* FROM {$tbl1} a, {$tbl2} b WHERE a.id_soft='" . $this->id() . "' AND b.id_platform=a.id_platform";
$result = $this->db->queryF($sql);
while ($rows = $this->db->fetchArray($result)) {
if ($asobj) {
$tmp = new DTPlatform();
$tmp->assignVars($rows);
} else {
$tmp = $rows['id_platform'];
}
$this->_platforms[] = $tmp;
}
}
return $this->_platforms;
}
/**
* @desc Formulario de Elementos
**/
function formItems($edit = 0)
{
global $xoopsModule, $xoopsConfig, $xoopsModuleConfig, $rmc_config, $xoopsSecurity, $functions;
define('RMCSUBLOCATION', 'newitem');
// Get layout data
$id = intval(rmc_server_var($_REQUEST, 'id', 0));
$page = intval(rmc_server_var($_REQUEST, 'page', 0));
$search = rmc_server_var($_REQUEST, 'search', '');
$sort = rmc_server_var($_REQUEST, 'sort', 'id_soft');
$mode = intval(rmc_server_var($_REQUEST, 'mode', 0));
$catid = intval(rmc_server_var($_REQUEST, 'car', 0));
$type = rmc_server_var($_REQUEST, 'type', '');
$ev = RMEvents::get();
$params = '?page=' . $page . '&search=' . $search . '&sort=' . $sort . '&mode=' . $mode . '&cat=' . $catid . '&type=' . $type;
if ($edit) {
//Verificamos que el software sea válido
if ($id <= 0) {
redirectMsg('items.php' . $params, __('Download item has not been specified!', 'dtransport'), 1);
die;
}
//Verificamos que el software exista
if ($type == 'edit') {
$sw = new DTSoftwareEdited($id);
$location = __('Verifying edited item!', 'dtransport');
} else {
$sw = new DTSoftware($id);
$location = __('Editing download item', 'dtransport');
}
if ($sw->isNew()) {
redirectMsg('./items.php' . $params, __('Specified download item does not exists!', 'dtransport'), 1);
die;
}
} else {
$sw = new DTSoftware();
$location = __('New Download Item', 'dtransport');
}
$form = new RMForm('', '', '');
$ed = new RMFormEditor('', 'desc', '99%', '300px', $edit ? $sw->getVar('desc', $rmc_config['editor_type'] != 'tiny' ? 'e' : 's') : '', $rmc_config['editor_type']);
$ed->addClass('required');
$db = XoopsDatabaseFactory::getDatabaseConnection();
//Lista de categorías
$categos = array();
$swcats = $sw->categories();
DTFunctions::getCategos($categos, 0, 0, array(), false);
foreach ($categos as $row) {
$cat = new DTCategory();
$cat->assignVars($row);
$categories[] = array('id' => $cat->id(), 'name' => $cat->name(), 'parent' => $cat->parent(), 'active' => $cat->active(), 'description' => $cat->desc(), 'indent' => $row['jumps'], 'selected' => $edit ? in_array($cat->id(), $swcats) : '');
}
unset($categos);
// Licencias
$sql = "SELECT * FROM " . $db->prefix('dtrans_licences');
$result = $db->queryF($sql);
$lics = array();
$lics[] = array('id' => 0, 'name' => __('Other license', 'dtransport'), 'selected' => !$edit || in_array(0, $sw->licences()) ? 1 : 0);
while ($row = $db->fetchArray($result)) {
$lic = new DTLicense();
$lic->assignVars($row);
$lics[] = array('id' => $lic->id(), 'name' => $lic->name(), 'selected' => $edit ? in_array($lic->id(), $sw->licences()) : '');
}
unset($lic);
// Plataformas
$sql = "SELECT * FROM " . $db->prefix('dtrans_platforms');
$result = $db->queryF($sql);
$oss = array();
$oss[] = array('id' => 0, 'name' => __('Other platform', 'dtransport'), 'selected' => !$edit || in_array(0, $sw->platforms()) ? 1 : 0);
while ($row = $db->fetchArray($result)) {
$os = new DTPlatform();
$os->assignVars($row);
$oss[] = array('id' => $os->id(), 'name' => $os->name(), 'selected' => $edit ? in_array($os->id(), $sw->platforms()) : '');
}
unset($os);
// Allowed groups
$field = new RMFormGroups('', 'groups', 1, 1, 1, $edit ? $sw->getVar('groups') : array(1, 2));
$groups = $field->render();
// Tags
$ftags = $sw->tags(true);
$tags = array();
foreach ($ftags as $tag) {
$tags[] = $tag->getVar('tag');
}
unset($ftags);
RMTemplate::get()->add_style('admin.css', 'dtransport');
RMTemplate::get()->add_style('items.css', 'dtransport');
RMTemplate::get()->add_local_script('itemsform.js', 'dtransport');
RMTemplate::get()->add_local_script('jquery.validate.min.js', 'rmcommon', 'include');
include DT_PATH . '/include/js_strings.php';
DTFunctions::toolbar();
xoops_cp_location($location);
xoops_cp_header();
include RMTemplate::get()->get_template('admin/dtrans_formitems.php', 'module', 'dtransport');
xoops_cp_footer();
}
/**
* @desc Elimina la plataforma especificada
**/
function deletePlatforms()
{
global $xoopsModule, $xoopsSecurity;
$ids = rmc_server_var($_POST, 'ids', array());
//Verificamos si nos proporcionaron alguna plataforma
if (!is_array($ids) || empty($ids)) {
redirectMsg('platforms.php', __('You must select at least one platform to delete!', 'dtransport'), 1);
die;
}
if (!$xoopsSecurity->check()) {
redirectMsg('platforms.php', __('Session token expired', 'dtransport'), 1);
die;
}
$errors = '';
foreach ($ids as $k) {
//Verificamos si la plataforma es válida
if ($k <= 0) {
$errors .= sprintf(__('Invalid platform ID: %s', 'dtransport'), $k);
continue;
}
//Verificamos si la plataforma existe
$plat = new DTPlatform($k);
if ($plat->isNew()) {
$errors .= sprintf(__('Does nto exists platform with ID %s', 'dtransport'), $k);
continue;
}
if (!$plat->delete()) {
$errors .= sprintf(__('Platform "%s" could not be deleted!', 'dtransport'), $plat->name());
}
}
if ($errors != '') {
redirectMsg('platforms.php', __('Errors ocurred while trying to delete platforms:', 'dtransport') . '<br />' . $errors, 1);
} else {
redirectMsg('platforms.php', __('Platforms deleted successfully!', 'dtransport'), 0);
}
}
// $Id$
// --------------------------------------------------------------
// D-Transport
// Manage files for download in XOOPS
// Author: Eduardo Cortés <*****@*****.**>
// Email: i.bitcero@gmail.com
// License: GPL 2.0
// --------------------------------------------------------------
$xoopsOption['template_main'] = 'dtrans_tags.html';
$xoopsOption['module_subpage'] = 'platforms';
if ($os == '') {
redirect_header(DT_URL, 1, __('Platform not specified!', 'dtransport'));
die;
}
include 'header.php';
$os = new DTPlatform($os);
// Descargas en esta etiqueta
$sql = "SELECT COUNT(*) FROM " . $db->prefix('dtrans_platsoft') . " AS a INNER JOIN " . $db->prefix('dtrans_software') . " b ON (a.id_platform=" . $os->id() . " AND a.id_soft=b.id_soft) WHERE b.approved='1' AND b.delete=0";
list($num) = $db->fetchRow($db->query($sql));
$limit = $mc['xpage'];
$limit = $limit <= 0 ? 10 : $limit;
$tpages = ceil($num / $limit);
if ($tpages < $page && $tpages > 0) {
header('location: ' . DT_URL . ($mc['permalinks'] ? '/platform/' . $os->nameId() : '/?p=platform&os=' . $os->id()));
die;
}
$p = $page > 0 ? $page - 1 : $page;
$start = $num <= 0 ? 0 : $p * $limit;
$nav = new RMPageNav($num, $limit, $page);
$nav->target_url(DT_URL . ($mc['permalinks'] ? '/platform/' . $os->nameId() . '/page/{PAGE_NUM}/' : '/?p=platform&os=' . $os->id() . '&page={PAGE_NUM}'));
$xoopsTpl->assign('pagenav', $nav->render(true));
