/**
* Muestra los envíos existentes
*/
function showPages($acceso = -1)
{
global $mc, $xoopsModule, $xoopsSecurity;
$keyw = rmc_server_var($_REQUEST, 'keyw', '');
$acceso = rmc_server_var($_REQUEST, 'acceso', -1);
$cat = rmc_server_var($_REQUEST, 'cat', '');
$db = XoopsDatabaseFactory::getDatabaseConnection();
$sql = "SELECT COUNT(*) FROM " . $db->prefix("qpages_pages");
if ($acceso >= 0) {
$sql .= " WHERE acceso={$acceso}";
}
if (trim($keyw) != '') {
$sql .= ($acceso >= 0 ? " AND " : " WHERE ") . "titulo LIKE '%{$keyw}%'";
}
if (isset($cat) && $cat > 0) {
$sql .= ($acceso >= 0 || $keyw != '' ? " AND " : " WHERE ") . "cat='{$cat}'";
}
/**
* Paginacion de Resultados
*/
$page = rmc_server_var($_REQUEST, 'page', 1);
$page = $page <= 0 ? 1 : $page;
$limit = 15;
list($num) = $db->fetchRow($db->query($sql));
$tpages = ceil($num / $limit);
$page = $page > $tpages ? $tpages : $page;
$start = $num <= 0 ? 0 : ($page - 1) * $limit;
$nav = new RMPageNav($num, $limit, $page, 5);
$nav->target_url('pages.php?cat=' . $cat . '&page={PAGE_NUM}');
$sql .= " ORDER BY id_page DESC LIMIT {$start},{$limit}";
$sql = str_replace("SELECT COUNT(*)", "SELECT *", $sql);
$result = $db->query($sql);
$pages = array();
while ($row = $db->fetchArray($result)) {
$p = new QPPage();
$p->assignVars($row);
# Enlaces para las categorías
$catego = new QPCategory($p->getCategory());
$pages[] = array('id' => $p->getID(), 'titulo' => $p->getTitle(), 'catego' => $catego->getName(), 'fecha' => formatTimeStamp($p->getDate(), 's'), 'link' => $p->getPermaLink(), 'estado' => $p->getAccess(), 'modificada' => $p->getModDate() == 0 ? '--' : formatTimestamp($p->getModDate(), 'c'), 'lecturas' => $p->getReads(), 'order' => $p->order(), 'type' => $p->type(), 'desc' => $p->getDescription());
}
/**
* Cargamos las categorias
*/
$categos = array();
qpArrayCategos($categos);
$categories = array();
foreach ($categos as $k) {
$categories[] = array('id' => $k['id_cat'], 'nombre' => $k['nombre'], 'saltos' => $k['saltos']);
}
RMTemplate::get()->add_style('admin.css', 'qpages');
RMTemplate::get()->add_script('../include/js/qpages.js');
RMTemplate::get()->add_script(RMCURL . '/include/js/jquery.checkboxes.js');
RMTemplate::get()->assign('xoops_pagetitle', __('Pages Management', 'qpages'));
xoops_cp_location('<a href="./">' . $xoopsModule->name() . '</a> » ' . ($acceso < 0 ? __('All Pages', 'qpages') : ($acceso == 0 ? __('Draft pages', 'qpages') : __('Published pages', 'qpages'))));
xoops_cp_header();
include RMTemplate::get()->get_template("admin/qp_pages.php", 'module', 'qpages');
xoops_cp_footer();
}
$pagetitle .= $pagetitle == '' ? $pt[$i] : " « {$pt[$i]}";
}
$tpl->assign('page_location', $location);
$tpl->assign('page_title', $catego->getName());
$tpl->assign('xoops_pagetitle', $pagetitle);
$tpl->assign('lang_pages', sprintf(__('Pages in %s', 'qpages'), $catego->getName()));
/**
* Cargamos las páginas
*/
$lpages = $catego->loadPages();
$pages = array();
foreach ($lpages as $p) {
$ret = array();
$rp = new QPPage();
$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();
RMTemplate::get()->add_head('<script type="text/javascript">var xoops_url="' . XOOPS_URL . '";</script>');
xoops_cp_header();
// Get data for statistics
$db = XoopsDatabaseFactory::getDatabaseConnection();
$sql = "SELECT * FROM " . $db->prefix("qpages_pages") . " WHERE acceso=1 ORDER BY lecturas DESC LIMIT 0, 5";
$result = $db->query($sql);
$labels = "chxt=x,y&chxl=0:";
$values = 'chd=t:';
$leg = "chdlp=bv&chdl=";
$i = 0;
$max = 0;
while ($row = $db->fetchArray($result)) {
$page = new QPPage();
$page->assignVars($row);
if ($i == 0) {
$max = $page->getReads();
}
$i++;
$labels .= "|Id:" . $page->getID();
$leg .= urlencode($page->getTitle() . ' (' . $page->getReads() . ' times)') . "|";
$values .= $page->getReads() . ',';
}
$values = rtrim($values, ',');
$leg = rtrim($leg, "|");
if ($max > 0) {
$chart = "http://chart.apis.google.com/chart?";
$chart .= "cht=bvs&chco=99CC00|FFCC00|0099FF|FF6600|6666FF";
$chart .= "&" . $labels . '&' . $values . "&" . $leg;
$chart .= "&chbh=a,20&chs=330x300&chxr=1,0," . $max . "&chds=0," . ($max + 1);
$chart .= "&chtt=" . urlencode(__('Most viewed pages', 'qpages'));
} else {
