Top_Poster_Block::setup()

Complexity

Conditions	10
Paths	120

Size

Total Lines	103
Code Lines	45

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
	public function setup($parameters, $id)
	{
		global $txt, $scripturl;

		$limit = !empty($parameters['limit']) ? (int) $parameters['limit'] : 5;
		$type = !empty($parameters['type']) ? (int) $parameters['type'] : 0;

		// If not top poster of all time we need to set a start time
		if (!empty($type))
		{
			$start_time = time();

			// Today
			if ($type == 1)
			{
				list($year, $month, $day) = explode('-', date('Y-m-d'));
				$start_time = mktime(0, 0, 0, $month, $day, $year);

$day of type string is incompatible with the type integer expected by parameter $day of mktime().

$month of type string is incompatible with the type integer expected by parameter $month of mktime().

$year of type string is incompatible with the type integer expected by parameter $year of mktime().

			}
			// This week
			elseif ($type == 2)
			{
				$start_time = mktime(0, 0, 0, date("n"), date("j"), date("Y")) - (date("N") * 3600 * 24);
			}
			// This month
			elseif ($type == 3)
			{
				$months = array(1 => 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
				$start_time = mktime(0, 0, 0, date("n"), date("j"), date("Y")) - (3600 * 24 * $months[(int) date("m", time())]);
			}

			$start_time = forum_time(false, $start_time);

			$request = $this->_db->query('', '
				SELECT
					mem.id_member, mem.real_name, COUNT(*) as posts, mem.email_address,
					mem.avatar, a.id_attach, a.attachment_type, a.filename
				FROM {db_prefix}messages AS m
					LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
					LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = mem.id_member)
				WHERE m.poster_time > {int:start_time}
					AND m.id_member != 0
				GROUP BY mem.id_member
				ORDER BY posts DESC
				LIMIT {int:limit}',
				array(
					'start_time' => $start_time,
					'limit' => $limit,
				)
			);
		}
		// Or from the start of time
		else
		{
			$request = $this->_db->query('', '
				SELECT
					m.id_member, m.real_name, m.posts, m.avatar, m.email_address,
					a.id_attach, a.attachment_type, a.filename
				FROM {db_prefix}members AS m
					LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = m.id_member)
				ORDER BY posts DESC
				LIMIT {int:limit}',
				array(
					'limit' => $limit,
				)
			);
		}
		$this->data['members'] = array();
		while ($row = $this->_db->fetch_assoc($request))
		{
			if (!empty($row['id_member']))
			{
				$this->color_ids[$row['id_member']] = $row['id_member'];
			}

			// Load the member data
			$this->data['members'][] = array(
				'id' => $row['id_member'],
				'name' => $row['real_name'],
				'href' => $scripturl . '?action=profile;u=' . $row['id_member'],
				'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>',
				'posts' => comma_format($row['posts']),
				'avatar' => determineAvatar(array(
					'avatar' => $row['avatar'],
					'filename' => $row['filename'],
					'id_attach' => $row['id_attach'],
					'email_address' => $row['email_address'],
					'attachment_type' => $row['attachment_type'],
				)),
			);
		}
		$this->_db->free_result($request);

		// Profile colors?
		$this->_color_ids();

		if (empty($this->data['members']))
		{
			$this->data['error_msg'] = $txt['error_sp_no_members_found'];
			$this->setTemplate('template_sp_topPoster_error');
		}
		else
		{
			$this->setTemplate('template_sp_topPoster');
		}