function qpagesBlockCategos() { global $xoopsConfig, $mc; include_once XOOPS_ROOT_PATH . '/modules/qpages/class/qpcategory.class.php'; include_once XOOPS_ROOT_PATH . '/modules/qpages/include/general.func.php'; $mc =& RMUtilities::module_config('qpages'); $db =& XoopsDatabaseFactory::getDatabaseConnection(); if (!defined('QP_URL')) { define('QP_URL', XOOPS_URL . ($mc['links'] ? $mc['basepath'] : '/modules/qpages')); } $block = array(); $categos = array(); qpArrayCategos($categos); foreach ($categos as $k) { $catego = new QPCategory(); $catego->assignVars($k); $rtn = array(); $rtn['id'] = $catego->getID(); $rtn['nombre'] = $catego->getName(); $rtn['link'] = $catego->getLink(); $rtn['ident'] = $k['saltos'] > 0 ? $k['saltos'] + 8 : 0; $block['categos'][] = $rtn; } return $block; }
$rp->assignVars($p); $tpl->append('pages', array('id' => $rp->getID(), 'link' => $rp->getPermaLink(), 'title' => $rp->getTitle(), 'modified' => formatTimestamp($rp->getModDate(), 'l'), 'hits' => $rp->getReads(), 'desc' => $rp->getDescription())); } $tpl->assign('page_count', count($lpages)); unset($pages); // Subcategorias $result = $db->query("SELECT * FROM " . $db->prefix("qpages_categos") . " WHERE parent = " . $catego->getID()); $tpl->assign('subcats_count', $db->getRowsNum($result)); while ($k = $db->fetchArray($result)) { $cat = new QPCategory(); $cat->assignVars($k); $lpages = $cat->loadPages(); $pages = array(); foreach ($lpages as $p) { $page = new QPPage(); $page->assignVars($p); $ret = array(); $ret['titulo'] = $page->getTitle(); $ret['desc'] = $page->getDescription(); $ret['link'] = $page->getPermaLink(); $pages[] = $ret; } $link = $cat->getLink(); $subcats = $cat->getSubcategos(); $tpl->append('categos', array('id' => $cat->getID(), 'nombre' => $cat->getName(), 'desc' => $cat->getDescription(), 'pages_count' => sprintf(__('%u pages', 'qpages'), count($lpages)), 'link' => $link, 'subcats' => count($subcats) > 0 ? $subcats : '', 'subcats_count' => count($subcats))); } $tpl->assign('lang_subcats', __('Subcategories', 'qpages')); $tpl->assign('lang_page', __('Page', 'qpages')); $tpl->assign('lang_modified', __('Last update', 'qpages')); $tpl->assign('lang_hits', __('Reads', 'qpages')); require 'footer.php';
} } if (!$ok && !$xoopsUser->isAdmin()) { redirect_header(QP_URL, 2, _MS_QP_NOALLOWED); die; } } } if ($page->type()) { header('location: ' . $page->url()); die; } $catego = new QPCategory($page->getCategory()); require 'header.php'; // Asignamos datos de la categoría $tpl->assign('qpcategory', array('id' => $catego->getID(), 'name' => $catego->getName(), 'nameid' => $catego->getFriendName())); $idp = 0; # ID de la categoria padre $rutas = array(); $path = explode('/', $catego->getPath()); $tbl = $db->prefix("qpages_categos"); foreach ($path as $k) { if ($k == '') { continue; } $sql = "SELECT id_cat FROM {$tbl} WHERE nombre_amigo='{$k}' AND parent='{$idp}'"; $result = $db->query($sql); if ($db->getRowsNum($result) > 0) { list($idp) = $db->fetchRow($result); $rutas[] = new QPCategory($idp); }