function bxpress_recents_show($options)
{
$util = RMUtilities::get();
$tc = TextCleaner::getInstance();
$db = XoopsDatabaseFactory::getDatabaseConnection();
$xoopsModuleConfig = $util->module_config('exmbb');
$mc = RMUtilities::module_config('bxpress');
$tbl1 = $db->prefix('bxpress_posts');
$tbl2 = $db->prefix('bxpress_topics');
$tbl3 = $db->prefix('bxpress_posts_text');
$tbl4 = $db->prefix('bxpress_forums');
$sql = "SELECT MAX(id_post) AS id FROM {$tbl1} WHERE approved=1 GROUP BY id_topic ORDER BY MAX(id_post) DESC LIMIT 0,{$options['0']}";
$result = $db->queryF($sql);
$topics = array();
$block = array();
include_once XOOPS_ROOT_PATH . '/modules/bxpress/class/bxforum.class.php';
include_once XOOPS_ROOT_PATH . '/modules/bxpress/class/bxpost.class.php';
include_once XOOPS_ROOT_PATH . '/modules/bxpress/class/bxtopic.class.php';
include_once XOOPS_ROOT_PATH . '/modules/bxpress/class/bxfunctions.class.php';
$post = new bXPost();
$forum = new bXForum();
$tf = new RMTimeFormatter(0, '%T%-%d%-%Y% at %h%:%i%');
while ($row = $db->fetchArray($result)) {
$post = new bXPost($row['id']);
$topic = new bXTopic($post->topic());
$forum = new bXForum($post->forum());
$ret = array();
$ret['id'] = $topic->id();
$ret['post'] = $post->id();
$ret['link'] = $post->permalink();
if ($options[2]) {
$ret['date'] = $tf->format($post->date());
}
if ($options[3]) {
$ret['poster'] = sprintf(__('Posted by: %s', 'bxpress'), "<a href='" . $post->permalink() . "'>" . $post->uname() . "</a>");
}
$ret['title'] = $topic->title();
if ($options[4]) {
$ret['text'] = $tc->clean_disabled_tags($post->text());
}
$ret['forum'] = array('id' => $forum->id(), 'name' => $forum->name(), 'link' => $forum->permalink());
$topics[] = $ret;
}
// Opciones
$block['showdates'] = $options[2];
$block['showuname'] = $options[3];
$block['showtext'] = $options[4];
$block['topics'] = $topics;
$block['lang_topic'] = __('Topic', 'bxpress');
$block['lang_date'] = __('Date', 'bxpress');
$block['lang_poster'] = __('Poster', 'bxpress');
return $block;
}
function bxpress_block_topics_show($options)
{
$db = XoopsDatabaseFactory::getDatabaseConnection();
$mc = RMSettings::module_settings('bxpress');
$tbl1 = $db->prefix('mod_bxpress_posts');
$tbl2 = $db->prefix('mod_bxpress_topics');
$tbl3 = $db->prefix('mod_bxpress_likes');
$tbl4 = $db->prefix('mod_bxpress_forums');
// Calculate period of time
if (0 < $options['days']) {
$period = time() - $options['days'] * 86400;
}
$order = 'DESC' == $options['order'] ? 'DESC' : 'ASC';
$sql = "SELECT topics.*, forums.name,\n (SELECT SUM(likes) FROM {$tbl1} WHERE id_topic=topics.id_topic) as likes,\n (SELECT post_time FROm {$tbl1} WHERE id_topic=topics.id_topic ORDER BY post_time DESC LIMIT 0, 1) as updated\n FROM {$tbl2} as topics, {$tbl4} as forums WHERE ";
if (0 < $options['days']) {
$sql .= " topics.date > {$period} AND ";
}
$sql .= "forums.id_forum=topics.id_forum";
if ('recent' == $options['type']) {
$sql .= " ORDER BY topics.id_topic {$order} LIMIT 0, {$options['limit']}";
} elseif ('hot' == $options['type']) {
$sql .= " ORDER BY topics.replies {$order} LIMIT 0, {$options['limit']}";
} elseif ('hits' == $options['type']) {
$sql .= " ORDER BY topics.views {$order} LIMIT 0, {$options['limit']}";
}
$result = $db->queryF($sql);
$topics = array();
$block = array();
include_once XOOPS_ROOT_PATH . '/modules/bxpress/class/bxforum.class.php';
include_once XOOPS_ROOT_PATH . '/modules/bxpress/class/bxpost.class.php';
include_once XOOPS_ROOT_PATH . '/modules/bxpress/class/bxtopic.class.php';
include_once XOOPS_ROOT_PATH . '/modules/bxpress/class/bxfunctions.class.php';
$topic = new bXTopic();
$forum = new bXForum();
$tf = new RMTimeFormatter(0, '%T% %d%, %Y%');
while ($row = $db->fetchArray($result)) {
$topic->assignVars($row);
$forum->assignVars(array('id_forum' => $topic->forum()));
$ret = array('id' => $topic->id(), 'title' => $topic->title, 'link' => $topic->permalink(), 'likes' => $topic->likes, 'replies' => $topic->replies, 'hits' => $topic->views, 'forum' => array('name' => $row['name'], 'id' => $row['id_forum'], 'link' => $forum->permalink()), 'time' => $topic->date, 'date' => $tf->ago($topic->date), 'likes' => $row['likes'], 'updated' => 'full' == $options['format'] ? sprintf(__('Updated on %s', 'bxpress'), $tf->format($row['updated'])) : $tf->ago($row['updated']));
$topics[] = $ret;
}
$block['topics'] = $topics;
$block['format'] = $options['format'];
// Add css styles
RMTemplate::get()->add_style('bxpress-blocks.min.css', 'bxpress');
return $block;
}
// Verificamos que el usuario tenga permiso
if (!$xoopsUser || !$forum->isAllowed($xoopsUser->getGroups(), 'delete')) {
redirect_header('topic.php?pid=' . $id . '#p' . $id, 2, __('Sorry, you don\'t have permission to do this action!', 'bxpress'));
die;
}
// Verificamos si el usuario tiene permiso de eliminación para el post
if ($xoopsUser->uid() != $post->user() && (!$xoopsUser->isAdmin() && !$forum->isModerator($xoopsUser->uid()))) {
redirect_header('topic.php?pid=' . $id . '#p' . $id, 2, __('Sorry, you don\'t have permission to do this action!', 'bxpress'));
die;
}
if ($ok) {
if (!$xoopsSecurity->check()) {
redirect_header('topic.php?pid=' . $id . '#p' . $id, 2, __('Session token expired!', 'bxpress'));
die;
}
if ($post->id() == bXFunctions::getFirstId($topic->id())) {
$ret = $topic->delete();
$wtopic = true;
} else {
$ret = $post->delete();
$wtopic = false;
}
if ($ret) {
redirect_header($wtopic ? 'forum.php?id=' . $forum->id() : 'topic.php?id=' . $topic->id(), 1, $wtopic ? __('Topic deleted successfully!', 'bxpress') : __('Post deleted successfully!', 'bxpress'));
} else {
redirect_header('topic.php?pid=' . $id, 1, ($wtopic ? __('The topic could not be deleted!', 'bxpress') : __('The post could not be deleted!', 'bxpress')) . '<br />' . ($wtopic ? $topic->errors() : $post->errors()));
}
} else {
include 'header.php';
//include '../../header.php';
$myts =& MyTextSanitizer::getInstance();
//Determinamos de el mensaje esta aprobado y si el usuario es administrador o moderador
$forum = new bXForum($topic->forum());
if (!$topic->approved() && (!$xoopsUser->isAdmin() || !$forum->isModerator($xoopsUser->uid()))) {
redirect_header('./', 2, __('This topic has not been approved yet!', 'bxpress'));
die;
}
$forum = new bXForum($topic->forum());
if (!$forum->isAllowed($xoopsUser ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS, 'view')) {
redirect_header('./', 2, __('Sorry, you don\'t have permission to view this forum!', 'bxpress'));
die;
}
if (!isset($_SESSION['topics_viewed'])) {
$topic->addView();
$topic->save();
$_SESSION['topics_viewed'] = array();
$_SESSION['topics_viewed'][] = $topic->id();
} else {
if (!in_array($topic->id(), $_SESSION['topics_viewed'])) {
$topic->addView();
$topic->save();
$_SESSION['topics_viewed'][] = $topic->id();
}
}
$xoopsOption['template_main'] = "bxpress-topic.tpl";
$xoopsOption['module_subpage'] = "topics";
include 'header.php';
bXFunctions::makeHeader();
$tpl->assign('forum', array('id' => $forum->id(), 'title' => $forum->name(), 'moderator' => $xoopsUser ? $forum->isModerator($xoopsUser->uid()) || $xoopsUser->isAdmin() : false));
$tpl->assign('topic', array('id' => $topic->id(), 'title' => $topic->title(), 'closed' => $topic->status(), 'sticky' => $topic->sticky(), 'approved' => $topic->approved()));
if ($forum->isAllowed($xoopsUser ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS, 'reply')) {
if ($topic->status()) {
$lastpost['time'] = $last->date();
$lastpost['id'] = $last->id();
$lastpost['poster'] = array('uid' => $last->uid, 'uname' => $last->poster_name, 'name' => $last_poster->name != '' ? $last_poster->name : $last_poster->uname, 'email' => $last_poster->email, 'avatar' => RMEvents::get()->run_event('rmcommon.get.avatar', $last_poster->getVar('email'), 50), 'link' => XOOPS_URL . '/userinfo.php?uid=' . $last_poster->uid);
if ($xoopsUser) {
$lastpost['new'] = $last->date() > $xoopsUser->getVar('last_login') && time() - $last->date() < $xoopsModuleConfig['time_new'];
} else {
$lastpost['new'] = time() - $last->date() <= $xoopsModuleConfig['time_new'];
}
}
$tpages = ceil($topic->replies() / $xoopsModuleConfig['perpage']);
if ($tpages > 1) {
$pages = bXFunctions::paginateIndex($tpages);
} else {
$pages = null;
}
$tpl->append('topics', array('id' => $topic->id(), 'title' => $topic->title(), 'replies' => $topic->replies(), 'views' => $topic->views(), 'by' => sprintf(__('By: %s', 'bxpress'), $topic->posterName()), 'last' => $lastpost, 'popular' => $topic->replies() >= $forum->hotThreshold(), 'sticky' => $topic->sticky(), 'pages' => $pages, 'tpages' => $tpages, 'closed' => $topic->status(), 'poster' => array('uid' => $topic->poster, 'uname' => $poster->uname, 'name' => $poster->name, 'email' => $poster->email, 'avatar' => RMEvents::get()->run_event('rmcommon.get.avatar', $poster->getVar('email'), 100), 'type' => $poster->isAdmin() ? 'admin' : ($forum->isModerator($topic->poster) ? 'moderator' : 'user'))));
}
// Datos del Foro
$tpl->assign('forum', array('id' => $forum->id(), 'title' => $forum->name(), 'moderator' => $xoopsUser ? $forum->isModerator($xoopsUser->uid()) || $xoopsUser->isAdmin() : false));
// Notificaciones de Common Utilities
$notifications = RMNotifications::get();
$events = Bxpress_Notifications::get();
// New topics notifications
$event = $events->event('newtopic')->parameters($forum->id())->permissions(array('users' => $forum->moderators(), 'groups' => array(XOOPS_GROUP_ADMIN)));
$notifications->add_item($event);
// New posts notification
$event = $events->event('forum-newpost')->parameters($forum->id())->permissions(array('users' => $forum->moderators(), 'groups' => array(XOOPS_GROUP_ADMIN)));
$notifications->add_item($event);
// Assign output to a Smarty variable
$tpl->assign('notifications', $notifications->render());
$tpl->assign('lang_pages', __('Pages:', 'bxpress'));
$topic->setViews(0);
$topic->setVotes(0);
$topic->setFriendName(TextCleaner::getInstance()->sweetstring($subject));
if ($xoopsUser && isset($sticky) && $xoopsModuleConfig['sticky']) {
if ($xoopsUser->isAdmin() || $forum->isModerator($xoopsUser->uid()) || $xoopsUser->posts() > $xoopsModuleConfig['sticky_posts']) {
$topic->setSticky($sticky);
}
}
if (!$topic->save()) {
redirect_header('./forum.php?id=' . $forum->id(), 2, __('Message could not be posted! Please try again', 'bxpress'));
die;
}
}
$post = new bXPost();
$post->setPid(0);
$post->setTopic($topic->id());
$post->setForum($forum->id());
$post->setDate(time());
$post->setUser($xoopsUser ? $xoopsUser->uid() : 0);
$post->setUname($xoopsUser ? $xoopsUser->uname() : $name);
$post->setIP($_SERVER['REMOTE_ADDR']);
$post->setHTML(isset($dohtml) ? 1 : 0);
$post->setBBCode(isset($doxcode) ? 1 : 0);
$post->setSmiley(isset($dosmiley) ? 1 : 0);
$post->setBR(isset($dobr) ? 1 : 0);
$post->setImage(isset($doimg) ? 1 : 0);
$post->setIcon('');
$post->setApproved($forum->isAllowed($xoopsUser ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS, 'approve'));
$post->setSignature(isset($sig) ? 1 : 0);
$post->setText($msg);
if (!$post->save() && $create) {
if ($op == 'report') {
$xoopsOption['template_main'] = 'bxpress_report.html';
$xoopsOption['module_subpage'] = "report";
include 'header.php';
bXFunctions::makeHeader();
//Id de mensaje
$pid = isset($_REQUEST['pid']) ? intval($_REQUEST['pid']) : 0;
$post = new bXPost($pid);
$forum = new bXForum($post->forum());
$topic = new bXTopic($post->topic());
$form = new RMForm(__('Report Post', 'bxpress'), 'formrep', 'report.php');
$form->styles('width: 30%;', 'odd');
$form->addElement(new RMFormEditor(__('Your reasons to report this post', 'bxpress'), 'report', '90%', '300px', '', 'textarea'), true);
$form->addElement(new RMFormHidden('op', 'savereport'));
$form->addElement(new RMFormHidden('pid', $pid));
$form->addElement(new RMFormHidden('id', $topic->id()));
$buttons = new RMFormButtonGroup();
$buttons->addButton('sbt', _SUBMIT, 'submit');
$buttons->addButton('cancel', _CANCEL, 'button', 'onclick="history.go(-1);"');
$form->addElement($buttons);
$tpl->assign('report_contents', $form->render());
$tpl->assign('forumtitle', $forum->name());
$tpl->assign('topictitle', $topic->title());
$tpl->assign('forumid', $forum->id());
$tpl->assign('topicid', $topic->id());
$tpl->assign('report', __('Report Post', 'bxpress'));
include 'footer.php';
} elseif ($op == 'savereport') {
foreach ($_POST as $k => $v) {
${$k} = $v;
}
// Verificamos si el usuario tiene permiso de edición para el post
if ($xoopsUser->uid() != $post->user() && (!$xoopsUser->isAdmin() && !$forum->isModerator($xoopsUser->uid()))) {
redirect_header('topic.php?pid=' . $id . '#p' . $id, 2, __('You don\'t have permission to edit this post!', 'bxpress'));
die;
}
switch ($op) {
case 'post':
foreach ($_POST as $k => $v) {
${$k} = $v;
}
if (!$xoopsSecurity->check()) {
redirect_header('edit.php?id=' . $id, 2, __('Session token expired!', 'bxpress'));
die;
}
$myts =& MyTextSanitizer::getInstance();
if (bXFunctions::getFirstId($topic->id()) == $id) {
$topic->setDate(time());
$topic->setTitle($myts->addSlashes($subject));
if ($xoopsUser && isset($sticky) && $xoopsModuleConfig['sticky']) {
if ($xoopsUser->isAdmin() || $forum->isModerator($xoopsUser->uid()) || $xoopsUser->posts() > $xoopsModuleConfig['sticky_posts'] && $xoopsUser->uid() == $topic->poster()) {
$topic->setSticky($sticky);
}
}
}
$post->setPid(0);
$post->setIP($_SERVER['REMOTE_ADDR']);
$post->setIcon('');
$post->setSignature(isset($sig) ? 1 : 0);
if ($forum->isAllowed($xoopsUser ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS, 'approve') || $xoopsUser->isAdmin() || $forum->isModerator()) {
$post->setText($msg);
} else {
$lastpost['date'] = formatTimeStamp($last->date(), 'c');
$lastpost['by'] = sprintf(__('By: %s', 'bxpress'), $last->uname());
$lastpost['id'] = $last->id();
if ($xoopsUser) {
$lastpost['new'] = $last->date() > $xoopsUser->getVar('last_login') && time() - $last->date() < $xoopsModuleConfig['time_new'];
} else {
$lastpost['new'] = time() - $last->date() <= $xoopsModuleConfig['time_new'];
}
}
$tpages = ceil($topic->replies() / $xoopsModuleConfig['perpage']);
if ($tpages > 1) {
$pages = bXFunctions::paginateIndex($tpages);
} else {
$pages = null;
}
$tpl->append('topics', array('id' => $topic->id(), 'title' => $topic->title(), 'replies' => $topic->replies(), 'views' => $topic->views(), 'by' => sprintf(__('By: %s', 'bxpress'), $topic->posterName()), 'last' => $lastpost, 'popular' => $topic->replies() >= $forum->hotThreshold(), 'sticky' => $topic->sticky(), 'pages' => $pages, 'tpages' => $tpages, 'closed' => $topic->status()));
}
// Datos del Foro
$tpl->assign('forum', array('id' => $forum->id(), 'title' => $forum->name(), 'moderator' => $xoopsUser ? $forum->isModerator($xoopsUser->uid()) || $xoopsUser->isAdmin() : false));
$tpl->assign('lang_pages', __('Pages:', 'bxpress'));
$tpl->assign('lang_topic', __('Topics', 'bxpress'));
$tpl->assign('lang_replies', __('Replies', 'bxpress'));
$tpl->assign('lang_views', __('Views', 'bxpress'));
$tpl->assign('lang_lastpost', __('Last Post', 'bxpress'));
$tpl->assign('lang_nonew', __('No new posts', 'bxpress'));
$tpl->assign('lang_withnew', __('New posts', 'bxpress'));
$tpl->assign('lang_hotnonew', __('No hot topics', 'bxpress'));
$tpl->assign('lang_hotnew', __('New hot topics', 'bxpress'));
$tpl->assign('lang_sticky', __('Sticky', 'bxpress'));
$tpl->assign('lang_closed', __('Closed Topic', 'bxpress'));
if ($forum->isAllowed($xoopsUser ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS, 'topic')) {
/**
* @desc Muestra todas las opciones configurables
*/
function showItemsAndOptions()
{
global $xoopsUser, $db, $xoopsOption, $tpl, $xoopsModule, $xoopsConfig, $xoopsSecurity;
global $xoopsModuleConfig, $forum;
$xoopsOption['template_main'] = "bxpress_moderate.html";
$xoopsOption['module_subpage'] = "moderate";
include 'header.php';
/**
* Cargamos los temas
*/
$tbl1 = $db->prefix("bxpress_topics");
$tbl2 = $db->prefix("bxpress_forumtopics");
$sql = "SELECT COUNT(*) FROM {$tbl1} WHERE id_forum='" . $forum->id() . "' ";
list($num) = $db->fetchRow($db->queryF($sql));
$page = isset($_REQUEST['pag']) ? $_REQUEST['pag'] : '';
$limit = $xoopsModuleConfig['topicperpage'] > 0 ? $xoopsModuleConfig['topicperpage'] : 15;
if ($page > 0) {
$page -= 1;
}
$start = $page * $limit;
$tpages = (int) ($num / $limit);
if ($num % $limit > 0) {
$tpages++;
}
$pactual = $page + 1;
if ($pactual > $tpages) {
$rest = $pactual - $tpages;
$pactual = $pactual - $rest + 1;
$start = ($pactual - 1) * $limit;
}
if ($tpages > 0) {
$nav = new RMPageNav($num, $limit, $pactual);
$nav->target_url('moderate.php?id=' . $forum->id() . '&pag={PAGE_NUM}');
$tpl->assign('itemsNavPage', $nav->render(false));
}
$sql = str_replace("COUNT(*)", '*', $sql);
$sql .= " ORDER BY sticky DESC, date DESC LIMIT {$start},{$limit}";
$result = $db->query($sql);
while ($row = $db->fetchArray($result)) {
$topic = new bXTopic();
$topic->assignVars($row);
$last = new bXPost($topic->lastPost());
$lastpost = array();
if (!$last->isNew()) {
$lastpost['date'] = bXFunctions::formatDate($last->date());
$lastpost['by'] = sprintf(__('By: %s', 'bxpress'), $last->uname());
$lastpost['id'] = $last->id();
if ($xoopsUser) {
$lastpost['new'] = $last->date() > $xoopsUser->getVar('last_login') && time() - $last->date() < $xoopsModuleConfig['time_new'];
} else {
$lastpost['new'] = time() - $last->date() <= $xoopsModuleConfig['time_new'];
}
}
$tpages = ceil($topic->replies() / $xoopsModuleConfig['perpage']);
if ($tpages > 1) {
$pages = bXFunctions::paginateIndex($tpages);
} else {
$pages = null;
}
$tpl->append('topics', array('id' => $topic->id(), 'title' => $topic->title(), 'replies' => $topic->replies(), 'views' => $topic->views(), 'by' => sprintf(__('By: %s', 'bxpress'), $topic->posterName()), 'last' => $lastpost, 'popular' => $topic->replies() >= $forum->hotThreshold(), 'sticky' => $topic->sticky(), 'pages' => $pages, 'tpages' => $tpages, 'approved' => $topic->approved(), 'closed' => $topic->status()));
}
$tpl->assign('forum', array('id' => $forum->id(), 'title' => $forum->name()));
$tpl->assign('lang_topic', __('Topic', 'bxpress'));
$tpl->assign('lang_replies', __('Replies', 'bxpress'));
$tpl->assign('lang_views', __('Views', 'bxpress'));
$tpl->assign('lang_lastpost', __('Last Post', 'bxpress'));
$tpl->assign('lang_sticky', __('Sticky', 'bxpress'));
$tpl->assign('lang_moderating', __('Moderating Forum', 'bxpress'));
$tpl->assign('lang_pages', __('Pages', 'bxpress'));
$tpl->assign('lang_move', __('Move', 'bxpress'));
$tpl->assign('lang_open', __('Unlock', 'bxpress'));
$tpl->assign('lang_close', __('Lock', 'bxpress'));
$tpl->assign('lang_dosticky', __('Sticky', 'bxpress'));
$tpl->assign('lang_dounsticky', __('Unsticky', 'bxpress'));
$tpl->assign('lang_approved', __('Approved', 'bxpress'));
$tpl->assign('lang_app', __('Approve', 'bxpress'));
$tpl->assign('lang_noapp', __('Unapprove', 'bxpress'));
$tpl->assign('lang_delete', __('Delete', 'bxpress'));
$tpl->assign('lang_confirm', __('Do you really want to delete selected topics?', 'bxpress'));
$tpl->assign('token_input', $xoopsSecurity->getTokenHTML());
bXFunctions::makeHeader();
RMTemplate::get()->add_xoops_style('style.css', 'bxpress');
include 'footer.php';
}
while ($row = $db->fetchArray($result)) {
//print_r($row);
$pt->assignVars($row);
$post = array('id' => $row['last_post'], 'date' => sprintf(__('Last post on %s', 'bxpress'), bXFunctions::formatDate($row['post_time'])), 'by' => sprintf(__('By %s', 'bxpress'), $row['poster_name']), 'link' => $pt->permalink(), 'uid' => $row['uid']);
$topic->assignVars($row);
$forum->assignVars($row);
$topics[] = array('id' => $row['id_topic'], 'title' => $row['title'], 'post' => $post, 'link' => $topic->permalink(), 'forum' => array('id' => $forum->id(), 'name' => $forum->name(), 'link' => $forum->permalink()));
}
$sql = "SELECT * FROM {$tbl2} ORDER BY replies DESC LIMIT 0,5";
$result = $db->query($sql);
$poptops = array();
$topic = new bXTopic();
while ($row = $db->fetchArray($result)) {
$topic->assignVars($row);
$forum->assignVars($row);
$poptops[] = array('id' => $topic->id(), 'title' => $topic->title(), 'date' => sprintf(__('Created on %s', 'bxpress'), bXFunctions::formatDate($row['date'])), 'replies' => $topic->replies(), 'link' => $topic->permalink(), 'forum' => array('id' => $forum->id(), 'name' => $forum->name(), 'link' => $forum->permalink()));
}
unset($post, $pt, $topic, $result, $row, $sql, $tbl1, $tbl2, $tbl3);
RMTemplate::get()->add_style('dashboard.css', 'bxpress');
RMTemplate::get()->add_script('dashboard.js', 'bxpress');
RMTemplate::get()->add_help('Ayuda de bXpress', 'http://www.xoopsmexico.net/docs/bxpress-forums/dashboard/standalone/1/');
// Activity
// 30 Days
$ago = strtotime("-30 days");
$sql = "SELECT id_post,post_time,id_forum FROM " . $db->prefix("mod_bxpress_posts") . " WHERE post_time>={$ago} ORDER BY post_time ASC";
$result = $db->query($sql);
$posts = array();
$forums = array();
$p = '';
while ($row = $db->fetchArray($result)) {
$ds = date("d-M-Y", $row['post_time']);
//Determinamos de el mensaje esta aprobado y si el usuario es administrador o moderador
$forum = new bXForum($topic->forum());
if (!$topic->approved() && (!$xoopsUser->isAdmin() || !$forum->isModerator($xoopsUser->uid()))) {
redirect_header('./', 2, __('This topic has not been approved yet!', 'bxpress'));
die;
}
$forum = new bXForum($topic->forum());
if (!$forum->isAllowed($xoopsUser ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS, 'view')) {
redirect_header('./', 2, __('Sorry, you don\'t have permission to view this forum!', 'bxpress'));
die;
}
if (!isset($_SESSION['topics_viewed'])) {
$topic->addView();
$topic->save();
$_SESSION['topics_viewed'] = array();
$_SESSION['topics_viewed'][] = $topic->id();
} else {
if (!in_array($topic->id(), $_SESSION['topics_viewed'])) {
$topic->addView();
$topic->save();
$_SESSION['topics_viewed'][] = $topic->id();
}
}
$xoopsOption['template_main'] = "bxpress_topic.html";
$xoopsOption['module_subpage'] = "topics";
include 'header.php';
bXFunctions::makeHeader();
$tpl->assign('forum', array('id' => $forum->id(), 'title' => $forum->name(), 'moderator' => $xoopsUser ? $forum->isModerator($xoopsUser->uid()) || $xoopsUser->isAdmin() : false));
$tpl->assign('topic', array('id' => $topic->id(), 'title' => $topic->title(), 'closed' => $topic->status(), 'sticky' => $topic->sticky(), 'approved' => $topic->approved()));
if ($forum->isAllowed($xoopsUser ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS, 'reply')) {
if ($topic->status()) {
