sidebar block survey

[kaptangula]

How can I show the sidebar block survey ?

www.sambah.net

[kasimi]

Have a look at this extension: https://www.phpbb.com/customise/db/exte ... _on_index/

[kaptangula]

is this enough

Code: Select all

	public function index_modify_page_title()
	{
		$topics = $this->sql_query([
			'SELECT'	=> 't.topic_id, t.topic_title, t.topic_first_post_id, t.topic_status, t.poll_start, t.poll_length, t.poll_title, t.poll_max_options, t.poll_vote_change, t.forum_id, f.forum_status',
			'FROM'		=> [TOPICS_TABLE => 't'],
			'LEFT_JOIN'	=> [
				[
					'FROM'	=> [FORUMS_TABLE => 'f'],
					'ON'	=> 'f.forum_id = t.forum_id',
				],
			],
			'WHERE'		=> 't.poll_start <> 0 AND (t.poll_on_index = ' . ext::POLL_ON_INDEX_YES_INDEFINITELY . ' OR t.poll_on_index = ' . ext::POLL_ON_INDEX_YES_END . ' AND (t.poll_length = 0 OR t.poll_start + t.poll_length >= ' . time() . '))',
			'ORDER_BY'	=> 't.poll_start + t.poll_length DESC, t.poll_start DESC',
		]);

		if ($topics)
		{
			$this->lang->add_lang('viewtopic');
			$this->lang->add_lang('common', 'kasimi/pollonindex');
		}

		foreach ($topics as $topic_data)
		{
			if (!$this->auth->acl_get('f_read', $topic_data['forum_id']))
			{
				continue;
			}

			$poll_info = $this->sql_query([
				'SELECT'	=> 'o.*, p.bbcode_bitfield, p.bbcode_uid',
				'FROM'		=> [POLL_OPTIONS_TABLE => 'o', POSTS_TABLE => 'p'],
				'WHERE'		=> 'o.topic_id = ' . (int) $topic_data['topic_id'] . ' AND p.post_id = ' . (int) $topic_data['topic_first_post_id'] . ' AND p.topic_id = o.topic_id',
				'ORDER_BY'	=> 'o.poll_option_id',
			]);

			$vote_counts = [];

			foreach ($poll_info as $row)
			{
				$option_id = (int) $row['poll_option_id'];
				$vote_counts[$option_id] = (int) $row['poll_option_total'];
			}

			if ($this->user->data['is_registered'])
			{
				$cur_voted_id = $this->sql_query([
					'SELECT'	=> 'poll_option_id',
					'FROM'		=> [POLL_VOTES_TABLE => 'pv'],
					'WHERE'		=> 'topic_id = ' . (int) $topic_data['topic_id'] . ' AND vote_user_id = ' . (int) $this->user->data['user_id'],
				], 'poll_option_id');
			}
			else
			{
				$cookie_name = $this->config['cookie_name'] . '_poll_' . $topic_data['topic_id'];
				$cur_voted_id = $this->request->variable($cookie_name, '', true, request_interface::COOKIE);
				$cur_voted_id = $cur_voted_id ? explode(',', $cur_voted_id) : [];
				$cur_voted_id = array_map('intval', $cur_voted_id);
			}

			// Can not vote at all if no vote permission
			$s_can_vote = $this->auth->acl_get('f_vote', $topic_data['forum_id']) &&
				(($topic_data['poll_length'] != 0 && $topic_data['poll_start'] + $topic_data['poll_length'] > time()) || $topic_data['poll_length'] == 0) &&
				$topic_data['topic_status'] != ITEM_LOCKED &&
				$topic_data['forum_status'] != ITEM_LOCKED &&
				(!sizeof($cur_voted_id) ||
				($this->auth->acl_get('f_votechg', $topic_data['forum_id']) && $topic_data['poll_vote_change']));
			$s_display_results = !$s_can_vote || $cur_voted_id;

			/**
			* Event to manipulate the poll data
			*
			* @event core.viewtopic_modify_poll_data
			* @var	array	cur_voted_id				Array with options' IDs current user has voted for
			* @var	int		forum_id					The topic's forum id
			* @var	array	poll_info					Array with the poll information
			* @var	bool	s_can_vote					Flag indicating if a user can vote
			* @var	bool	s_display_results			Flag indicating if results or poll options should be displayed
			* @var	int		topic_id					The id of the topic the user tries to access
			* @var	array	topic_data					All the information from the topic and forum tables for this topic
			* @var	string	viewtopic_url				URL to the topic page
			* @var	array	vote_counts					Array with the vote counts for every poll option
			* @var	array	voted_id					Array with updated options' IDs current user is voting for
			* @since 3.1.5-RC1
			*/
			$vars = [
				'cur_voted_id',
				'forum_id',
				'poll_info',
				's_can_vote',
				's_display_results',
				'topic_id',
				'topic_data',
				'viewtopic_url',
				'vote_counts',
				'voted_id',
			];
			extract($this->dispatcher->trigger_event('core.viewtopic_modify_poll_data', compact($vars)));

			if ($s_can_vote)
			{
				add_form_key('posting');
			}

			$poll_option_total = array_column($poll_info, 'poll_option_total');
			$poll_total = array_sum($poll_option_total);
			$poll_most = max($poll_option_total);

			$parse_flags = ($poll_info[0]['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES;

			for ($i = 0, $size = sizeof($poll_info); $i < $size; $i++)
			{
				$poll_info[$i]['poll_option_text'] = generate_text_for_display($poll_info[$i]['poll_option_text'], $poll_info[$i]['bbcode_uid'], $poll_info[$i]['bbcode_bitfield'], $parse_flags, true);
			}

			$topic_data['poll_title'] = generate_text_for_display($topic_data['poll_title'], $poll_info[0]['bbcode_uid'], $poll_info[0]['bbcode_bitfield'], $parse_flags, true);

			$poll_options_template_data = [];

			foreach ($poll_info as $poll_option)
			{
				$option_pct = $poll_total > 0 ? $poll_option['poll_option_total'] / $poll_total : 0;
				$option_pct_txt = sprintf("%.1d%%", round($option_pct * 100));
				$option_pct_rel = $poll_most > 0 ? $poll_option['poll_option_total'] / $poll_most : 0;
				$option_pct_rel_txt = sprintf("%.1d%%", round($option_pct_rel * 100));
				$option_most_votes = $poll_option['poll_option_total'] > 0 && $poll_option['poll_option_total'] == $poll_most;

				$poll_options_template_data[] = [
					'POLL_OPTION_ID' 			=> $poll_option['poll_option_id'],
					'POLL_OPTION_CAPTION' 		=> $poll_option['poll_option_text'],
					'POLL_OPTION_RESULT' 		=> $poll_option['poll_option_total'],
					'POLL_OPTION_PERCENT' 		=> $option_pct_txt,
					'POLL_OPTION_PERCENT_REL' 	=> $option_pct_rel_txt,
					'POLL_OPTION_PCT'			=> round($option_pct * 100),
					'POLL_OPTION_WIDTH'			=> round($option_pct * 250),
					'POLL_OPTION_VOTED'			=> in_array($poll_option['poll_option_id'], $cur_voted_id),
					'POLL_OPTION_MOST_VOTES'	=> $option_most_votes,
				];
			}

			$poll_end = $topic_data['poll_length'] + $topic_data['poll_start'];

			$viewtopic_url = append_sid($this->root_path . 'viewtopic.' . $this->php_ext, ['f' => $topic_data['forum_id'], 't' => $topic_data['topic_id']]);

			$poll_template_data = [
				'TOPIC_TITLE'			=> $topic_data['topic_title'],
				'POLL_QUESTION'			=> $topic_data['poll_title'],
				'TOTAL_VOTES' 			=> $poll_total,
				'POLL_LEFT_CAP_IMG'		=> $this->user->img('poll_left'),
				'POLL_RIGHT_CAP_IMG'	=> $this->user->img('poll_right'),

				'L_MAX_VOTES'			=> $this->lang->lang('MAX_OPTIONS_SELECT', (int) $topic_data['poll_max_options']),
				'L_POLL_LENGTH'			=> $topic_data['poll_length'] ? $this->lang->lang($poll_end > time() ? 'POLL_RUN_TILL' : 'POLL_ENDED_AT', $this->user->format_date($poll_end)) : '',

				'S_HAS_POLL'			=> true,
				'S_CAN_VOTE'			=> $s_can_vote,
				'S_DISPLAY_RESULTS'		=> $s_display_results,
				'S_IS_MULTI_CHOICE'		=> $topic_data['poll_max_options'] > 1,
				'S_POLL_ACTION'			=> $viewtopic_url,

				'U_VIEW_RESULTS'		=> $viewtopic_url . '&amp;view=viewpoll',
			];

			if ($this->cc_operator !== null)
			{
				$fid = 'poll_' . $topic_data['topic_id'];
				$poll_template_data = array_merge($poll_template_data, [
					'S_CAN_HIDE_CATEGORY'		=> true,
					'S_CATEGORY_HIDDEN'			=> $this->cc_operator->is_collapsed($fid),
					'U_CATEGORY_COLLAPSE_URL'	=> $this->cc_operator->get_collapsible_link($fid),
				]);
			}

			/**
			* Event to add/modify poll template data
			*
			* @event core.viewtopic_modify_poll_template_data
			* @var	array	cur_voted_id					Array with options' IDs current user has voted for
			* @var	int		poll_end						The poll end time
			* @var	array	poll_info						Array with the poll information
			* @var	array	poll_options_template_data		Array with the poll options template data
			* @var	array	poll_template_data				Array with the common poll template data
			* @var	int		poll_total						Total poll votes count
			* @var	int		poll_most						Mostly voted option votes count
			* @var	array	topic_data						All the information from the topic and forum tables for this topic
			* @var	string	viewtopic_url					URL to the topic page
			* @var	array	vote_counts						Array with the vote counts for every poll option
			* @var	array	voted_id						Array with updated options' IDs current user is voting for
			* @since 3.1.5-RC1
			*/
			$vars = [
				'cur_voted_id',
				'poll_end',
				'poll_info',
				'poll_options_template_data',
				'poll_template_data',
				'poll_total',
				'poll_most',
				'topic_data',
				'viewtopic_url',
				'vote_counts',
				'voted_id',
			];
			extract($this->dispatcher->trigger_event('core.viewtopic_modify_poll_template_data', compact($vars)));

			$this->template->assign_block_vars('polls', $poll_template_data);

			$this->template->assign_block_vars_array('polls.poll_options', $poll_options_template_data);
		}
	}

[kasimi]

Sorry, in this case I can only help if you post specific error messages.

[kaptangula]

how to help

[terry2]

Ask the real author of the side bar ext he will know.

You left his site link in the ext for version check also some empty classes lol