function asb_rand_quote_get_quote($settings, $width)
{
global $db, $mybb, $templates, $lang, $theme;
if (!$lang->asb_addon) {
$lang->load('asb_addon');
}
// get forums user cannot view
$unviewable = get_unviewable_forums(true);
if ($unviewable) {
$unviewwhere = " AND p.fid NOT IN ({$unviewable})";
}
// get inactive forums
$inactive = get_inactive_forums();
if ($inactive) {
$inactivewhere = " AND p.fid NOT IN ({$inactive})";
}
if ($settings['important_threads_only']) {
$important_threads = ' AND NOT t.sticky=0';
}
// build the exclude conditions
$show['fids'] = asb_build_id_list($settings['forum_show_list'], 'p.fid');
$show['tids'] = asb_build_id_list($settings['thread_show_list'], 'p.tid');
$hide['fids'] = asb_build_id_list($settings['forum_hide_list'], 'p.fid');
$hide['tids'] = asb_build_id_list($settings['thread_hide_list'], 'p.tid');
$where['show'] = asb_build_SQL_where($show, ' OR ');
$where['hide'] = asb_build_SQL_where($hide, ' OR ', ' NOT ');
$query_where = $important_threads . $unviewwhere . $inactivewhere . asb_build_SQL_where($where, ' AND ', ' AND ');
$post_query = $db->query("\n\t\tSELECT\n\t\t\tp.pid, p.message, p.fid, p.tid, p.subject, p.uid,\n\t\t\tu.username, u.usergroup, u.displaygroup, u.avatar,\n\t\t\tt.sticky\n\t\tFROM {$db->table_prefix}posts p\n\t\tLEFT JOIN {$db->table_prefix}users u ON (u.uid=p.uid)\n\t\tLEFT JOIN {$db->table_prefix}threads t ON (t.tid=p.tid)\n\t\tWHERE\n\t\t\tp.visible='1'{$query_where}\n\t\tORDER BY\n\t\t\tRAND()\n\t\tLIMIT 1;");
// if there was 1 . . .
if ($db->num_rows($post_query) == 0) {
return false;
}
$rand_post = $db->fetch_array($post_query);
// build a post parser
require_once MYBB_ROOT . 'inc/class_parser.php';
$parser = new postParser();
// we just need the text and smilies (we'll parse them after we check length)
$pattern = "|[[\\/\\!]*?[^\\[\\]]*?]|si";
$new_message = asb_strip_url(preg_replace($pattern, '$1', $rand_post['message']));
// get some dimensions that make sense in relation to column width
$asb_width = (int) $width;
$asb_inner_size = $asb_width * 0.83;
$avatar_size = (int) ($asb_inner_size / 5);
$font_size = $asb_width / 4.5;
$font_size = max(10, min(16, $font_size));
$username_font_size = (int) ($font_size * 0.9);
$title_font_size = (int) ($font_size * 0.65);
$message_font_size = (int) $font_size;
if (strlen($new_message) < $settings['min_length']) {
if ($settings['default_text']) {
$new_message = $settings['default_text'];
} else {
// nothing to show
return false;
}
}
if ($settings['max_length'] && strlen($new_message) > $settings['max_length']) {
$new_message = substr($new_message, 0, $settings['max_length']) . ' . . .';
}
// set up the user name link so that it displays correctly for the display group of the user
$plain_text_username = htmlspecialchars_uni($rand_post['username']);
$username = format_name($plain_text_username, $rand_post['usergroup'], $rand_post['displaygroup']);
$author_link = get_profile_link($rand_post['uid']);
$post_link = get_post_link($rand_post['pid'], $rand_post['tid']) . '#pid' . $rand_post['pid'];
$thread_link = get_thread_link($rand_post['tid']);
// allow smilies, but kill
$parser_options = array("allow_smilies" => 1);
$new_message = str_replace(array('<br />', '/me'), array('', " * {$plain_text_username}"), $parser->parse_message($new_message . ' ', $parser_options));
// if the user has an avatar then display it, otherwise force the default avatar.
$avatar_filename = "{$theme['imgdir']}/default_avatar.gif";
if ($rand_post['avatar'] != '') {
$avatar_filename = $rand_post['avatar'];
}
$avatar_alt = $lang->sprintf($lang->asb_random_quote_users_profile, $plain_text_username);
eval("\$read_more = \"" . $templates->get('asb_rand_quote_read_more') . "\";");
if (my_strlen($rand_post['subject']) > 40) {
$rand_post['subject'] = my_substr($rand_post['subject'], 0, 40) . ' . . .';
}
if (substr(strtolower($rand_post['subject']), 0, 3) == 're:') {
$rand_post['subject'] = substr($rand_post['subject'], 3);
}
$rand_post['subject'] = htmlspecialchars_uni($parser->parse_badwords($rand_post['subject']));
$thread_title_link = <<<EOF
<strong><a href="{$thread_link}" title="{$lang->asb_random_quotes_read_more_threadlink_title}"><span style="font-size: {$title_font_size}px;">{$rand_post['subject']}</span></a></strong>
EOF;
// eval() the template
eval("\$this_quote = \"" . $templates->get("asb_rand_quote_sidebox") . "\";");
return $this_quote;
}
function recent_posts_get_postlist($settings)
{
global $db, $mybb, $templates, $lang, $cache, $postlist, $gotounread, $theme;
// load custom language phrases
if (!$lang->asb_addon) {
$lang->load('asb_addon');
}
// get forums user cannot view
$unviewable = get_unviewable_forums(true);
if ($unviewable) {
$unviewwhere = " AND p.fid NOT IN ({$unviewable})";
}
// get inactive forums
$inactive = get_inactive_forums();
if ($inactive) {
$inactivewhere = " AND p.fid NOT IN ({$inactive})";
}
if ($settings['important_threads_only']) {
$important_threads = ' AND NOT t.sticky=0';
}
// build the exclude conditions
$show['fids'] = asb_build_id_list($settings['forum_show_list'], 'p.fid');
$show['tids'] = asb_build_id_list($settings['thread_show_list'], 'p.tid');
$hide['fids'] = asb_build_id_list($settings['forum_hide_list'], 'p.fid');
$hide['tids'] = asb_build_id_list($settings['thread_hide_list'], 'p.tid');
$where['show'] = asb_build_SQL_where($show, ' OR ');
$where['hide'] = asb_build_SQL_where($hide, ' OR ', ' NOT ');
$query_where = $important_threads . $unviewwhere . $inactivewhere . asb_build_SQL_where($where, ' AND ', ' AND ');
$altbg = alt_trow();
$maxtitlelen = 48;
$postlist = '';
// Query for the latest forum discussions
$query = $db->query("\n\t\tSELECT p.tid, p.pid, p.message, p.fid, p.dateline, p.subject,\n\t\t\tu.username, u.uid, u.displaygroup, u.usergroup,\n\t\t\tt.sticky\n\t\tFROM {$db->table_prefix}posts p\n\t\tLEFT JOIN {$db->table_prefix}users u ON (u.uid=p.uid)\n\t\tLEFT JOIN {$db->table_prefix}threads t ON (t.tid=p.tid)\n\t\tWHERE\n\t\t\tp.visible='1'{$query_where}\n\t\tORDER BY\n\t\t\tp.dateline DESC\n\t\tLIMIT\n\t\t\t0, " . (int) $settings['max_posts']);
if ($db->num_rows($query) == 0) {
// no content
return false;
}
// Build a post parser
require_once MYBB_ROOT . 'inc/class_parser.php';
$parser = new postParser();
$post_cache = array();
while ($post = $db->fetch_array($query)) {
$post_cache[$post['pid']] = $post;
}
foreach ($post_cache as $post) {
$forumpermissions[$post['fid']] = forum_permissions($post['fid']);
// make sure we can view this post
if ($forumpermissions[$post['fid']]['canview'] == 0 || $forumpermissions[$post['fid']]['canviewthreads'] == 0 || $forumpermissions[$post['fid']]['canonlyviewownthreads'] == 1 && $post['uid'] != $mybb->user['uid']) {
continue;
}
$lastposttime = my_date($mybb->settings['timeformat'], $post['dateline']);
// don't link to guest's profiles (they have no profile).
if ($post['uid'] == 0) {
$post_author = $post['username'];
} else {
$post_author_name = format_name($post['username'], $post['usergroup'], $post['displaygroup']);
$post_author = build_profile_link($post_author_name, $post['uid']);
}
if (my_strlen($post['subject']) > $maxtitlelen) {
$post['subject'] = my_substr($post['subject'], 0, $maxtitlelen) . '...';
}
if (substr(strtolower($post['subject']), 0, 3) == 're:') {
$post['subject'] = substr($post['subject'], 3);
}
$post['subject'] = htmlspecialchars_uni($parser->parse_badwords($post['subject']));
$post['link'] = get_thread_link($post['tid']) . "&pid={$post['pid']}#pid{$post['pid']}";
// we just need the text and smilies (we'll parse them after we check length)
$pattern = "|[[\\/\\!]*?[^\\[\\]]*?]|si";
$post_excerpt = strip_tags(str_replace('<br />', '', asb_strip_url(preg_replace($pattern, '$1', $post['message']))));
if (strlen($post_excerpt) > $settings['max_length']) {
$post_excerpt = substr($post_excerpt, 0, $settings['max_length']) . ' . . .';
}
eval("\$postlist .= \"" . $templates->get("asb_recent_posts_post") . "\";");
$altbg = alt_trow();
}
return $postlist;
}
