本文整理汇总了PHP中vartrue函数的典型用法代码示例。如果您正苦于以下问题:PHP vartrue函数的具体用法?PHP vartrue怎么用?PHP vartrue使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了vartrue函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: showForm
public function showForm($mes)
{
$ns = e107::getRender();
$frm = new form();
$text = $frm->form_open('post', e_SELF);
$text .= "<table class='table adminform'>";
$text .= "<tr><td>" . LAN_RADIUS_01 . "</td><td>";
$text .= $frm->form_text('radius_server', 35, vartrue($this->radius['radius_server']), 120);
$text .= "</td></tr>\n";
$text .= "<tr><td>" . LAN_RADIUS_02 . "</td><td>";
$text .= $frm->form_text('radius_secret', 35, vartrue($this->radius['radius_secret']), 200);
$text .= "</td></tr>\n";
$tmp = $this->alt_auth_get_field_list('radius', $frm, $this->radius, FALSE);
if ($tmp) {
$text .= "<tr><td class='forumheader2' colspan='2'>" . LAN_ALT_27 . "</td></tr>\n" . $tmp;
unset($tmp);
}
$text .= "<tr><td class='forumheader' colspan='2' style='text-align:center;'>";
// $text .= $frm -> form_button("submit", "update", LAN_ALT_2);
$text .= e107::getForm()->admin_button('update', LAN_UPDATE, 'update');
$text .= "</td></tr>\n";
$text .= "</table>\n";
$text .= $frm->form_close();
$ns->tablerender(LAN_RADIUS_06, $mes->render() . $text);
$ns->tablerender(LAN_ALT_40 . LAN_ALT_41, $this->alt_auth_test_form('radius', $frm));
}
示例2: data
/**
* Generate the Feed Data
* @param string $parms
* @return array
*/
function data($parms = '')
{
$pref = e107::getConfig()->getPref();
$tp = e107::getParser();
$this->showImages = vartrue($pref['rss_shownewsimage'], false);
$this->summaryDescription = vartrue($pref['rss_summarydiz'], false);
$render = $pref['rss_othernews'] != 1 ? "AND (FIND_IN_SET('0', n.news_render_type) OR FIND_IN_SET(1, n.news_render_type))" : "";
$nobody_regexp = "'(^|,)(" . str_replace(",", "|", e_UC_NOBODY) . ")(,|\$)'";
$topic = !empty($parms['id']) && is_numeric($parms['id']) ? " AND news_category = " . intval($parms['id']) : '';
$limit = vartrue($parms['limit'], 10);
$rssQuery = "SELECT n.*, u.user_id, u.user_name, u.user_email, u.user_customtitle, nc.category_name, nc.category_icon FROM #news AS n\n\t\t\t\tLEFT JOIN #user AS u ON n.news_author = u.user_id\n\t\t\t\tLEFT JOIN #news_category AS nc ON n.news_category = nc.category_id\n\t\t\t\tWHERE n.news_class IN (" . USERCLASS_LIST . ") AND NOT (n.news_class REGEXP " . $nobody_regexp . ") AND n.news_start < " . time() . " AND (n.news_end=0 || n.news_end>" . time() . ") {$render} {$topic} ORDER BY n.news_datestamp DESC LIMIT 0," . $limit;
$sql = e107::getDb();
$sql->gen($rssQuery);
$tmp = $sql->db_getList();
$rss = array();
$i = 0;
foreach ($tmp as $value) {
$rss[$i]['title'] = $value['news_title'];
$rss[$i]['link'] = e107::getUrl()->create('news/view/item', $value, 'full=1');
$rss[$i]['author'] = $value['user_name'];
$rss[$i]['author_email'] = $value['user_email'];
$rss[$i]['category_name'] = $tp->toHTML($value['category_name'], TRUE, 'defs');
$rss[$i]['category_link'] = SITEURL . "news.php?cat." . $value['news_category'];
//TODO SEFURL.
$rss[$i]['datestamp'] = $value['news_datestamp'];
$rss[$i]['description'] = $this->getDescription($value);
if ($value['news_allow_comments'] && $pref['comments_disabled'] != 1) {
$rss[$i]['comment'] = "http://" . $_SERVER['HTTP_HOST'] . e_HTTP . "comment.php?comment.news." . $value['news_id'];
}
$rss[$i]['media'] = $this->getMedia($value);
$i++;
}
return $rss;
}
示例3: iconpicker_shortcode
function iconpicker_shortcode($parm)
{
$parms = array();
parse_str($parm, $parms);
$name = varset($parms['id']);
$sql = e107::getDb();
$frm = e107::getForm();
$tp = e107::getParser();
// $sc_parameters is currently being used to select the media-category.
$qry = "SELECT * FROM `#core_media` WHERE media_userclass IN (" . USERCLASS_LIST . ") ";
$qry .= vartrue($sc_parameters) ? " AND media_category = '" . $sc_parameters . "' " : " AND `media_category` REGEXP '_icon_16|_icon_32|_icon_48|_icon_64' ";
$qry .= "ORDER BY media_category,media_name";
$str = "";
$size_section = array();
$lastsize = "16";
if ($sql->db_Select_gen($qry)) {
while ($row = $sql->db_Fetch()) {
list($tmp, $tmp2, $size) = explode("_", $row['media_category']);
if ($str != '' && $size != $lastsize) {
$size_section[] = $str;
$str = "";
}
$str .= "<a href='#" . $row['media_url'] . "' title='{$filepath}' onclick=\"e107Helper.insertText('{$row['media_url']}','{$name}','{$name}-iconpicker'); return false; \"><img class='icon picker list%%size%%' src='" . $tp->replaceConstants($row['media_url'], 'abs') . "' alt='{$row['media_name']}' /></a>";
$lastsize = $size;
}
return '<div id="' . $name . '-iconpicker-ajax"><div class="field-spacer iconpicker">' . str_replace('%%size%%', '', implode('</div><div class="field-spacer iconpicker">', $size_section)) . '</div></div>';
}
}
示例4: user_avatar_shortcode
function user_avatar_shortcode($parm = '')
{
global $loop_uid;
$height = e107::getPref("im_height");
$width = e107::getPref("im_width");
$tp = e107::getParser();
if (intval($loop_uid) > 0 && trim($parm) == "") {
$parm = $loop_uid;
}
if (is_numeric($parm)) {
if ($parm == USERID) {
$image = USERIMAGE;
} else {
$row = get_user_data(intval($parm));
$image = $row['user_image'];
}
} elseif ($parm) {
$image = $parm;
} elseif (USERIMAGE) {
$image = USERIMAGE;
} else {
$image = "";
}
if (vartrue($image)) {
$img = strpos($image, "://") !== false ? $image : $tp->thumbUrl(e_MEDIA . "avatars/" . $image, "aw=" . $width . "&ah=" . $height);
$text = "<img class='user-avatar e-tip' src='" . $img . "' alt='' style='width:" . $width . "px; height:" . $height . "px' />\n\t\t";
} else {
$img = $tp->thumbUrl(e_IMAGE . "generic/blank_avatar.jpg", "aw=" . $width . "&ah=" . $height);
$text = "<img class='user-avatar' src='" . $img . "' alt='' />";
}
return $text;
}
示例5: nodejs_forum_event_user_forum_post_created_callback
/**
* Event callback after triggering "user_forum_post_created".
*
* @param array $info
* Details about forum post.
*/
function nodejs_forum_event_user_forum_post_created_callback($info)
{
$postID = intval(vartrue($info['data']['post_id'], 0));
$postUserID = intval(vartrue($info['data']['post_user'], 0));
$postThreadID = intval(vartrue($info['data']['post_thread'], 0));
if ($postID === 0 || $postThreadID === 0) {
return;
}
// Get forum plugin preferences.
$plugForumPrefs = e107::getPlugConfig('forum')->getPref();
$db = e107::getDb();
// Load thread.
$thread = $db->retrieve('forum_thread', '*', 'thread_id = ' . $postThreadID);
$threadUser = intval(vartrue($thread['thread_user'], 0));
// Load forum to check (read) permission.
$forum = $db->retrieve('forum', '*', 'forum_id = ' . intval(vartrue($thread['thread_forum_id'], 0)));
// Author of the forum post.
$authorPost = e107::user($postUserID);
// Author of the forum topic.
$authorThread = e107::user($threadUser);
e107_require_once(e_PLUGIN . 'nodejs/nodejs.main.php');
$template = e107::getTemplate('nodejs_forum');
$sc = e107::getScBatch('nodejs_forum', true);
$tp = e107::getParser();
// Get topic page number.
$postNum = $db->count('forum_post', '(*)', "WHERE post_id <= " . $postID . " AND post_thread = " . $postThreadID . " ORDER BY post_id ASC");
$postPage = ceil($postNum / vartrue($plugForumPrefs['postspage'], 10));
// Push rendered row item into Latest Forum Posts menu.
$sc_vars = array('author' => $authorPost, 'post' => $info['data'], 'thread' => $thread, 'topicPage' => $postPage);
$sc->setVars($sc_vars);
$markup = $tp->parseTemplate($template['MENU']['RECENT']['ITEM'], true, $sc);
$message = (object) array('broadcast' => true, 'channel' => 'nodejs_notify', 'callback' => 'nodejsForumMenu', 'type' => 'latestForumPosts', 'markup' => $markup);
nodejs_enqueue_message($message);
// Broadcast logged in users to inform about new forum post created.
if ($authorPost) {
$sc->setVars($sc_vars);
$markup = $tp->parseTemplate($template['NOTIFICATION']['POST_ALL'], true, $sc);
// It's a public forum, so broadcast every online user.
if (intval(vartrue($forum['forum_class'], 0)) === 0) {
$message = (object) array('broadcast' => true, 'channel' => 'nodejs_notify', 'callback' => 'nodejsForum', 'type' => 'newForumPostAny', 'markup' => $markup, 'exclude' => $postUserID);
nodejs_enqueue_message($message);
} else {
$forumClass = vartrue($forum['forum_class'], 0);
$db->select('nodejs_presence');
while ($row = $db->fetch()) {
if (isset($row['uid']) && check_class($forumClass, null, $row['uid'])) {
$message = (object) array('channel' => 'nodejs_user_' . $row['uid'], 'callback' => 'nodejsForum', 'type' => 'newForumPostAny', 'markup' => $markup, 'exclude' => $postUserID);
nodejs_enqueue_message($message);
}
}
}
}
// Broadcast logged in (thread-author) user to inform about new forum post created in his/her topic.
if (isset($authorThread['user_id'])) {
$sc->setVars($sc_vars);
$markup = $tp->parseTemplate($template['NOTIFICATION']['POST_OWN'], true, $sc);
$message = (object) array('channel' => 'nodejs_user_' . $authorThread['user_id'], 'callback' => 'nodejsForum', 'type' => 'newForumPostOwn', 'markup' => $markup, 'exclude' => $postUserID);
nodejs_enqueue_message($message);
}
}
示例6: init
function init()
{
$pref = e107::getPref();
$sql = e107::getDb();
if (vartrue($_POST['cron_execute'])) {
$executeID = key($_POST['cron_execute']);
$this->cronExecute($executeID);
}
if (!vartrue(e107::getPref('e_cron_pwd')) || varset($_POST['generate_pwd'])) {
$pwd = $this->setCronPwd();
}
$sql->gen("SELECT cron_function,cron_active FROM #cron ");
while ($row = $sql->fetch(MYSQL_ASSOC)) {
$this->curCrons[] = $row['cron_function'];
if ($row['cron_active'] == 1) {
$this->activeCrons++;
}
}
$this->lastRefresh();
// Import Core and Plugin e_cron data
$cronDefaults['_system'] = array(0 => array('name' => LAN_CRON_01_1, 'function' => 'sendEmail', 'category' => 'mail', 'description' => str_replace("[eml]", $pref['siteadminemail'], LAN_CRON_01_2) . "<br />" . LAN_CRON_01_3), 1 => array('name' => LAN_CRON_02_1, 'category' => 'mail', 'function' => 'procEmailQueue', 'description' => LAN_CRON_02_2), 2 => array('name' => LAN_CRON_03_1, 'category' => 'mail', 'function' => 'procEmailBounce', 'description' => LAN_CRON_03_2), 3 => array('name' => LAN_CRON_04_1, 'category' => 'user', 'function' => 'procBanRetrigger', 'description' => LAN_CRON_04_2 . "<br />" . LAN_CRON_04_3, 'available' => e107::getPref('ban_retrigger')), 4 => array('name' => LAN_CRON_05_1, 'category' => 'backup', 'function' => 'dbBackup', 'description' => LAN_CRON_05_2 . ' ' . e_SYSTEM . 'backups/'), 5 => array('name' => LAN_CRON_06_1, 'category' => 'user', 'function' => 'procBanRetrigger', 'description' => LAN_CRON_06_2 . "<br />" . LAN_CRON_06_3), 6 => array('name' => LAN_CRON_20_1, 'category' => 'update', 'function' => 'checkCoreUpdate', 'description' => LAN_CRON_20_2 . "<br />" . LAN_CRON_20_3));
if (is_dir(e_BASE . ".git")) {
$cronDefaults['_system'][7] = array('name' => LAN_CRON_20_4, 'category' => 'update', 'function' => 'gitrepo', 'description' => LAN_CRON_20_5 . "<br />" . LAN_CRON_20_6 . "<br /><span class='label label-warning'>" . LAN_CRON_20_7 . "</span> " . LAN_CRON_20_8);
}
if (!vartrue($_GET['action']) || $_GET['action'] == 'refresh') {
$this->cronImport($cronDefaults);
// import Core Crons (if missing)
$this->cronImport(e107::getAddonConfig('e_cron'));
// Import plugin Crons
$this->cronImportLegacy();
// Import Legacy Cron Tab Settings
}
}
示例7: __construct
function __construct()
{
$pref = e107::pref('core', 'social_login');
if (!empty($pref) && is_array($pref['Twitter'])) {
$this->twitterActive = vartrue($pref['Twitter']['keys']['key']);
}
}
示例8: getListData
function getListData()
{
$sql = e107::getDb();
$list_caption = $this->parent->settings['caption'];
$list_display = $this->parent->settings['open'] ? "" : "none";
$qry = '';
if ($this->parent->mode == "new_page" || $this->parent->mode == "new_menu") {
$qry = "user_join>" . $this->parent->getlvisit() . " AND ";
}
$qry .= " user_ban=0 ORDER BY user_join DESC LIMIT 0," . intval($this->parent->settings['amount']);
$bullet = $this->parent->getBullet($this->parent->settings['icon']);
if (!$this->parent->e107->sql->gen("SELECT user_id,user_name,user_join FROM #user WHERE " . $qry)) {
$list_data = LIST_MEMBER_2;
} else {
while ($row = $this->parent->e107->sql->fetch()) {
$record = array();
$rowheading = $this->parent->parse_heading($row['user_name']);
//<a href='".e_BASE."user.php?id.".$row['user_id']."'>".$rowheading."</a>
$uparams = array('id' => $row['user_id'], 'name' => $rowheading);
$link = e107::getUrl()->create('user/profile/view', $uparams);
$userlink = "<a href='" . $link . "'>" . $rowheading . "</a>";
$record['icon'] = $bullet;
$record['heading'] = USER ? $userlink : $rowheading;
$record['category'] = '';
$record['author'] = '';
$record['date'] = vartrue($this->parent->settings['date']) ? $this->parent->getListDate($row['user_join']) : "";
$record['info'] = '';
$list_data[] = $record;
}
}
//return array with 'records', (global)'caption', 'display'
return array('records' => $list_data, 'caption' => $list_caption, 'display' => $list_display);
}
示例9: renderMenu
/**
* Render menu.
*/
function renderMenu()
{
$tpl = e107::getTemplate('nodejs_comment');
$sc = e107::getScBatch('nodejs_comment', true);
$tp = e107::getParser();
$cm = e107::getComment();
$amount = (int) vartrue($this->plugPrefs['comment_display'], 10);
/**
* getCommentData() returns with array, which contains:
* - comment_datestamp
* - comment_author_id
* - comment_author
* - comment_comment
* - comment_subject
* - comment_type
* - comment_title
* - comment_url
*/
$items = $cm->getCommentData($amount);
$text = $tp->parseTemplate($tpl['MENU']['LATEST']['HEADER'], true, $sc);
foreach ($items as $item) {
$sc->setVars($item);
$text .= $tp->parseTemplate($tpl['MENU']['LATEST']['ITEM'], true, $sc);
}
if (empty($items)) {
$text .= '<a href="#" class="list-group-item no-posts text-center">' . LAN_PLUGIN_NODEJS_COMMENT_FRONT_05 . '</a>';
}
$text .= $tp->parseTemplate($tpl['MENU']['LATEST']['FOOTER'], true, $sc);
e107::getRender()->tablerender(LAN_PLUGIN_NODEJS_COMMENT_FRONT_04, $text);
unset($text);
}
示例10: toDB
/**
* Called prior to save
* Sanitize and re-assemble the bbcode
*/
function toDB($code_text, $parm)
{
$code_text = trim($code_text);
if (empty($code_text)) {
return '';
}
if ($parm && !strpos($parm, '=')) {
$parm = 'class=' . $parm;
}
$parms = eHelper::scParams($parm);
$safe = array();
if (vartrue($parms['class'])) {
$safe['class'] = eHelper::secureClassAttr($parms['class']);
}
if (vartrue($parms['id'])) {
$safe['id'] = eHelper::secureIdAttr($parms['id']);
}
if (vartrue($parms['style'])) {
$safe['style'] = eHelper::secureStyleAttr($parms['style']);
}
if ($safe) {
return '[p=' . eHelper::buildAttr($safe) . ']' . $code_text . '[/p]';
}
return '[p]' . $code_text . '[/p]';
}
示例11: getListData
function getListData()
{
$list_caption = $this->parent->settings['caption'];
$list_display = $this->parent->settings['open'] ? "" : "none";
if ($this->parent->mode == "new_page" || $this->parent->mode == "new_menu") {
$qry = " l.link_datestamp>" . $this->parent->getlvisit() . " AND ";
} else {
$qry = '';
}
$bullet = $this->parent->getBullet($this->parent->settings['icon']);
$qry = "\n \tSELECT l.*, c.link_category_id, c.link_category_name\n \tFROM #links_page AS l\n \tLEFT JOIN #links_page_cat AS c ON c.link_category_id = l.link_category\n \tWHERE " . $qry . " l.link_class REGEXP '" . e_CLASS_REGEXP . "' AND c.link_category_class REGEXP '" . e_CLASS_REGEXP . "' AND l.link_active != '0' \n \tORDER BY l.link_datestamp DESC LIMIT 0," . intval($this->parent->settings['amount']) . " ";
$links_pages = $this->parent->e107->sql->gen($qry);
if ($links_pages == 0) {
$list_data = LIST_LINKS_2;
} else {
$list_data = array();
while ($row = $this->parent->e107->sql->fetch()) {
$record = array();
$rowheading = $this->parent->parse_heading($row['link_name']);
$record['icon'] = $bullet;
$record['heading'] = "<a href='" . $row['link_url'] . "' rel='external' title='" . $row['link_name'] . "'>" . $rowheading . "</a>";
$record['author'] = "";
$record['category'] = vartrue($this->parent->settings['category']) ? "<a href='" . e_PLUGIN . "links_page/links.php?cat." . $row['link_category_id'] . "'>" . $row['link_category_name'] . "</a>" : "";
$record['date'] = vartrue($this->parent->settings['date']) ? $this->parent->getListDate($row['link_datestamp']) : "";
$record['info'] = "";
$list_data[] = $record;
}
}
//return array with 'records', (global)'caption', 'display'
return array('records' => $list_data, 'caption' => $list_caption, 'display' => $list_display);
}
示例12: create
/**
*
*/
public function create($route, $params = array())
{
if (!$params) {
return 'page.php';
}
if (is_string($route)) {
$route = explode('/', $route, 2);
}
if (!varset($route[1])) {
$route[1] = 'index';
}
## aliases as retrieved from the DB, map vars to proper values
if (isset($params['page_title']) && !empty($params['page_title'])) {
$params['name'] = $params['page_title'];
}
if (isset($params['page_id']) && !empty($params['page_id'])) {
$params['id'] = $params['page_id'];
}
$url = 'page.php?';
if ('--FROM--' != vartrue($params['page'])) {
$page = varset($params['page']) ? intval($params['page']) : '0';
} else {
$page = '--FROM--';
}
$url .= intval($params['id']) . ($page ? '.' . $page : '');
return $url;
}
示例13: init
public function init()
{
// $this->listQry = "SELECT p.*,u.user_name FROM #private_msg AS p LEFT JOIN #user AS u ON p.pm_from = u.user_id ";
if ($this->getMode() == 'inbox') {
$this->listQry = 'SELECT p.*, u.user_name, f.user_name AS fromuser FROM #private_msg AS p LEFT JOIN #user AS u ON u.user_id = p.pm_to
LEFT JOIN #user as f on f.user_id = p.pm_from WHERE p.pm_to = ' . USERID;
$this->fields['pm_to']['nolist'] = true;
$this->fields['options']['readParms'] = 'editClass=' . e_UC_NOBODY;
}
if ($this->getMode() == 'outbox') {
$this->listQry = 'SELECT p.*, u.user_name, f.user_name AS fromuser FROM #private_msg AS p LEFT JOIN #user AS u ON u.user_id = p.pm_to
LEFT JOIN #user as f on f.user_id = p.pm_from WHERE p.pm_from = ' . USERID;
$this->fields['pm_from']['nolist'] = true;
$this->fields['options']['readParms'] = 'editClass=' . e_UC_NOBODY;
}
if ($this->getAction() == 'create') {
$this->fields['pm_to']['writeParms']['default'] = 99999999;
$this->fields['pm_to']['writeParms']['required'] = 1;
$this->fields['pm_subject']['writeParms']['required'] = 1;
if (!empty($_GET['to'])) {
$this->fields['pm_to']['writeParms']['default'] = intval($_GET['to']);
$this->addTitle('Reply');
}
if (!empty($_GET['subject'])) {
$this->fields['pm_subject']['writeParms']['default'] = "Re: " . base64_decode($_GET['subject']);
}
}
if (vartrue($_GET['iframe'])) {
define('e_IFRAME', true);
}
}
示例14: getListData
function getListData()
{
$list_caption = $this->parent->settings['caption'];
$list_display = $this->parent->settings['open'] ? "" : "none";
if ($this->parent->mode == "new_page" || $this->parent->mode == "new_menu") {
$qry = " AND download_datestamp>" . $this->parent->getlvisit();
} else {
$qry = '';
}
$bullet = $this->parent->getBullet($this->parent->settings['icon']);
$qry = "SELECT d.download_id, d.download_name, d.download_author, d.download_datestamp,\n\t\t dc.download_category_id, dc.download_category_name, dc.download_category_class\n\t\t FROM #download AS d\n\t\t LEFT JOIN #download_category AS dc ON d.download_category=dc.download_category_id\n\t\t WHERE dc.download_category_class REGEXP '" . e_CLASS_REGEXP . "' AND d.download_class REGEXP '" . e_CLASS_REGEXP . "' AND d.download_active != '0' " . $qry . "\n\t\t ORDER BY download_datestamp DESC LIMIT 0," . intval($this->parent->settings['amount']) . " ";
$downloads = $this->parent->e107->sql->db_Select_gen($qry);
if ($downloads == 0) {
$list_data = LIST_DOWNLOAD_2;
} else {
$list_data = array();
while ($row = $this->parent->e107->sql->db_Fetch()) {
$record = array();
$rowheading = $this->parent->parse_heading($row['download_name']);
$record['icon'] = $bullet;
$record['heading'] = "<a href='" . e_BASE . "download.php?view." . $row['download_id'] . "'>" . $rowheading . "</a>";
$record['author'] = vartrue($this->parent->settings['author']) ? $row['download_author'] : "";
$record['category'] = vartrue($this->parent->settings['category']) ? "<a href='" . e_BASE . "download.php?list." . $row['download_category_id'] . "'>" . $row['download_category_name'] . "</a>" : "";
$record['date'] = vartrue($this->parent->settings['date']) ? $this->parent->getListDate($row['download_datestamp']) : "";
$record['info'] = "";
$list_data[] = $record;
}
}
//return array with 'records', (global)'caption', 'display'
return array('records' => $list_data, 'caption' => $list_caption, 'display' => $list_display);
}
示例15: getQuery
function getQuery()
{
$max_age = vartrue($this->menuPref['maxage'], 0);
$max_age = $max_age == 0 ? '' : '(t.post_datestamp > ' . (time() - (int) $max_age * 86400) . ') AND ';
$forumList = implode(',', $this->forumObj->getForumPermList('view'));
$qry = "\n\t\tSELECT\n\t\t\tp.post_user, p.post_id, p.post_datestamp, p.post_user_anon, p.post_entry,\n\t\t\tt.thread_id, t.thread_datestamp, t.thread_name, u.user_name, f.forum_sef\n\t\tFROM `#forum_post` as p\n\n\t\tLEFT JOIN `#forum_thread` AS t ON t.thread_id = p.post_thread\n\t\tLEFT JOIN `#forum` as f ON f.forum_id = t.thread_forum_id\n\t\tLEFT JOIN `#user` AS u ON u.user_id = p.post_user\n\t\tWHERE {$max_age} p.post_forum IN ({$forumList})\n\t\tORDER BY p.post_datestamp DESC LIMIT 0, " . vartrue($this->menuPref['display'], 10);
return $qry;
}