Example #1
0
 function cms_block_poll()
 {
     global $db, $cache, $config, $template, $images, $user, $lang, $block_id, $cms_config_vars;
     global $kb_mode_append, $is_auth, $lofi, $bbcode;
     $template->_tpldata['poll_option.'] = array();
     if ($cms_config_vars['md_poll_type'][$block_id] == 0) {
         $order_sql = 'ORDER BY t.topic_time DESC';
     } else {
         $order_sql = 'ORDER BY RAND()';
     }
     if ($cms_config_vars['md_poll_type'][$block_id] != 2 && !empty($cms_config_vars['md_poll_forum_id'][$block_id])) {
         $in_sql = 't.forum_id IN (' . $cms_config_vars['md_poll_forum_id'][$block_id] . ') AND';
     } elseif (!empty($cms_config_vars['md_poll_topic_id'][$block_id])) {
         $in_sql = 't.topic_id = ' . intval($cms_config_vars['md_poll_topic_id'][$block_id]) . ' AND';
     }
     $sql = "SELECT t.*\n\t\t\tFROM " . TOPICS_TABLE . " AS t\n\t\t\tWHERE " . $in_sql . " t.topic_status <> " . TOPIC_LOCKED . "\n\t\t\t\tAND t.topic_status <> " . TOPIC_MOVED . "\n\t\t\t\tAND t.poll_start <> 0\n\t\t\t" . $order_sql . "\n\t\t\tLIMIT 0,1";
     $result = $db->sql_query($sql);
     $total_topics = $db->sql_numrows($result);
     if (!empty($total_topics)) {
         $topic_data = $db->sql_fetchrow($result);
         $db->sql_freeresult($result);
         if (!class_exists('class_topics')) {
             @(include_once IP_ROOT_PATH . 'includes/class_topics.' . PHP_EXT);
         }
         $class_topics = new class_topics();
         // Set some vars to make sure block is displayed correctly
         $forum_id_append = POST_FORUM_URL . '=' . $topic_data['forum_id'];
         $topic_id_append = POST_TOPIC_URL . '=' . $topic_data['topic_id'];
         // Store temp config value
         $portal_vote_graphic_length = $cms_config_vars['md_poll_bar_length'][$block_id];
         $config_vote_graphic_length = $config['vote_graphic_length'];
         $config['vote_graphic_length'] = $portal_vote_graphic_length;
         $class_topics->poll_display($topic_data, true);
         // Reset original config value
         $config['vote_graphic_length'] = $config_vote_graphic_length;
         $template->assign_vars(array('S_POLL_EXISTS' => true, 'U_VIEW_RESULTS' => append_sid(CMS_PAGE_VIEWTOPIC . '?' . $forum_id_append . '&amp;' . $topic_id_append)));
     } else {
         $template->assign_vars(array('S_POLL_EXISTS' => false));
     }
 }
Example #2
0
	'S_MARK_AR_IMG' => $s_mark_ar_img,
// UPI2DB - END
	'U_TOPIC_VIEWED' => $topic_viewed_link,
	'U_VIEW_FORUM' => $view_forum_url,
	'U_VIEW_OLDER_TOPIC' => $view_prev_topic_url,
	'U_VIEW_NEWER_TOPIC' => $view_next_topic_url,
	'U_THANKS' => $thank_topic_url,
	'U_POST_NEW_TOPIC' => $new_topic_url,
	'U_POST_REPLY_TOPIC' => $reply_topic_url
	)
);

// Does this topic contain a poll?
if (!empty($forum_topic_data['poll_start']))
{
	$class_topics->poll_display($forum_topic_data, false);
}

// Event Registration - BEGIN
include(IP_ROOT_PATH . 'includes/viewtopic_events_reg.' . PHP_EXT);
// Event Registration - END

init_display_post_attachments($forum_topic_data['topic_attachment']);

// Begin Thanks Mod
// Get topic thanks
if ($show_thanks)
{
	// Select Format for the date
	$timeformat = "d F";
	$sql = "SELECT u.user_id, u.username, u.user_active, u.user_color, t.thanks_time