$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';
/**
* Obtenemos las subcategorías
*/
public function getSubcategos()
{
global $mc, $xoopsModule;
$result = $this->db->query("SELECT * FROM " . $this->_dbtable . " WHERE parent='" . $this->getID() . "'");
$cats = array();
while ($row = $this->db->fetchArray($result)) {
$ret = array();
$ret['id'] = $row['id_cat'];
$catego = new QPCategory();
$catego->assignVars($row);
$ret['nombre'] = $catego->getName();
$ret['link'] = $catego->getLink();
$ret['desc'] = $catego->getDescription();
$cats[] = $ret;
}
return $cats;
}
