/** * Función para realizar búsquedas */ function qpages_search($qa, $andor, $limit, $offset, $userid) { global $xoopsUser, $mc; include_once XOOPS_ROOT_PATH . '/modules/qpages/class/qppage.class.php'; $mc = RMUtilities::module_config('qpages'); $db = XoopsDatabaseFactory::getDatabaseConnection(); $sql = "SELECT * FROM " . $db->prefix("qpages_pages"); $adds = ''; if (is_array($qa) && ($count = count($qa))) { $adds = ''; for ($i = 0; $i < $count; $i++) { $adds .= $adds == '' ? "(titulo LIKE '%{$qa[$i]}%' OR titulo_amigo LIKE '%{$qa[$i]}%')" : " {$andor} (titulo LIKE '%{$qa[$i]}%' OR titulo_amigo LIKE '%{$qa[$i]}%')"; } } $sql .= $adds != '' ? " WHERE {$adds}" : ''; if ($userid > 0) { $sql .= ($adds != '' ? " AND " : " WHERE ") . "uid='{$userid}'"; } $sql .= " ORDER BY modificado DESC"; $i = 0; $result = $db->query($sql); $ret = array(); while ($row = $db->fetchArray($result)) { $page = new QPPage(); $page->assignVars($row); $ret[$i]['image'] = "images/page.png"; $ret[$i]['link'] = $mc['links'] == 0 ? 'page.php?page=' . $page->getFriendTitle() : $page->getFriendTitle() . '/'; $ret[$i]['title'] = $page->getTitle(); $ret[$i]['time'] = $page->getDate(); $ret[$i]['uid'] = $page->uid(); $ret[$i]['desc'] = $page->getDescription(); $i++; } return $ret; }
/** * Mostramos las página existentes */ function qpagesBlockPages($options) { global $xoopsConfig; include_once XOOPS_ROOT_PATH . '/modules/qpages/class/qppage.class.php'; $db =& XoopsDatabaseFactory::getDatabaseConnection(); $mc =& RMUtilities::module_config('qpages'); if (!defined('QP_URL')) { define('QP_URL', XOOPS_URL . ($mc['links'] ? $mc['basepath'] : '/modules/qpages')); } $sql = "SELECT * FROM " . $db->prefix("qpages_pages"); if ($options[0] > 0) { $sql .= " WHERE cat='{$options['0']}'"; } $sql .= " ORDER BY fecha DESC LIMIT 0,{$options['1']}"; $block = array(); $result = $db->query($sql); while ($row = $db->fetchArray($result)) { $page = new QPPage(); $page->assignVars($row); $rtn = array(); $rtn['id'] = $page->getID(); $rtn['titulo'] = $page->getTitle(); $rtn['link'] = $page->getPermaLink(); $block['pages'][] = $rtn; } return $block; }
function linkedPages() { foreach ($_REQUEST as $k => $v) { ${$k} = $v; } if (count($ids) <= 0) { redirectMsg("pages.php?cat={$cat}&page={$page}", __('Select at least a cetegory to edit', 'qpages'), 1); die; } $db = XoopsDatabaseFactory::getDatabaseConnection(); $sql = "SELECT * FROM " . $db->prefix("qpages_pages") . " WHERE id_page IN ("; $sql .= implode(',', $ids) . ')'; $result = $db->query($sql); while ($row = $db->fetchArray($result)) { $page = new QPPage(); $page->assignVars($row); $page->setType(!$page->type()); $page->update(); } redirectMsg("pages.php?cat={$cat}&page={$page}", __('Database updated successfully!', 'qpages'), 0); }
$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';
$location .= '» <a href="' . $k->getLink() . '">' . $k->getName() . '</a> '; $pt[] = $k->getName(); } $location .= '» ' . $page->getTitle(); $pt[] = $page->getTitle(); $pagetitle = ''; for ($i = count($pt) - 1; $i >= 0; $i--) { $pagetitle .= $pagetitle == '' ? $pt[$i] : " « {$pt[$i]}"; } $tpl->assign('page_location', $location); $tpl->assign('xoops_pagetitle', $pagetitle); $page->addRead(); $tpl->assign('page', array('title' => $page->getTitle(), 'text' => $page->getText(), 'id' => $page->getID(), 'name' => $page->getFriendTitle(), 'mod_date' => sprintf(__('Last update: %s', 'qpages'), formatTimestamp($page->getModDate(), 'c')), 'reads' => sprintf(__('Read %u times', 'qpages'), $page->getReads()), 'metas' => $page->get_meta())); // Páginas relacionadas if ($mc['related']) { $sql = "SELECT * FROM " . $db->prefix("qpages_pages") . " WHERE cat='" . $catego->getID() . "' AND id_page<>'" . $page->getID() . "' ORDER BY RAND() DESC LIMIT 0,{$mc['related_num']}"; $result = $db->query($sql); $tpl->assign('related_num', $db->getRowsNum($result)); while ($row = $db->fetchArray($result)) { $rp = new QPPage(); $rp->assignVars($row); $tpl->append('related', array('id' => $rp->getID(), 'link' => $rp->getPermaLink(), 'title' => $rp->getTitle(), 'modified' => formatTimestamp($rp->getModDate(), 'c'), 'hits' => $rp->getReads(), 'desc' => $rp->getDescription())); } } $tpl->assign('show_related', $mc['related']); $tpl->assign('lang_related', __('Related Pages', 'qpages')); $tpl->assign('lang_page', __('Page', 'qpages')); $tpl->assign('lang_modified', __('Last modification', 'qpages')); $tpl->assign('lang_hits', __('Hits', 'qpages')); RMEvents::get()->run_event('qpages.view.page', $page); require 'footer.php';
$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 { $chart = ''; } // Recent pages $sql = "SELECT * FROM " . $db->prefix("qpages_pages") . " ORDER BY fecha DESC LIMIT 0, 5"; $result = $db->query($sql); $pages = array(); while ($row = $db->fetchArray($result)) { $page = new QPPage(); $page->assignVars($row); $pages[] = array('id' => $page->getID(), 'title' => $page->getTitle(), 'link' => $page->getPermaLink(), 'desc' => $page->getDescription(), 'public' => $page->getAccess()); } RMTemplate::get()->set_help('http://redmexico.com.mx/docs/quickpages'); // Left widgets and right widgets $left_widgets = array(); $left_widgets = RMEvents::get()->run_event('qpages.left.widgets', $left_widgets); $right_widgets = array(); $right_widgets = RMEvents::get()->run_event('qpages.right.widgets', $right_widgets); include RMTemplate::get()->get_template('admin/qp_index.php', 'module', 'qpages'); xoops_cp_footer();