sidebar block survey

Extensions, styles and support for everything else about phpBB
Post Reply
User avatar
kaptangula
Posts: 20
Joined: 17 Oct 2018, 07:47

sidebar block survey

#1

Post by kaptangula » 10 Nov 2019, 16:52

How can I show the sidebar block survey ?

www.sambah.net

User avatar
kasimi
mChat developer
Posts: 997
Joined: 06 Oct 2016, 09:56
Location: Germany
Contact:

Re: sidebar block survey

#2

Post by kasimi » 10 Nov 2019, 16:54


User avatar
kaptangula
Posts: 20
Joined: 17 Oct 2018, 07:47

Re: sidebar block survey

#3

Post by kaptangula » 10 Nov 2019, 16:59

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);
		}
	}


User avatar
kasimi
mChat developer
Posts: 997
Joined: 06 Oct 2016, 09:56
Location: Germany
Contact:

Re: sidebar block survey

#4

Post by kasimi » 10 Nov 2019, 17:03

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

User avatar
kaptangula
Posts: 20
Joined: 17 Oct 2018, 07:47

Re: sidebar block survey

#5

Post by kaptangula » 10 Nov 2019, 17:09

how to help

terry2
Donor
Posts: 193
Joined: 22 Oct 2016, 18:22
Location: My castle

Re: sidebar block survey

#6

Post by terry2 » 11 Nov 2019, 18:18

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

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests