Top_Stats_Member_Block::setup()

Complexity

Conditions	33
Paths	18464

Size

Total Lines	160
Code Lines	75

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	1	Features	0

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

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

		// Time is in days, but we need seconds
		$last_active_limit = !empty($parameters['last_active_limit']) ? $parameters['last_active_limit'] * 86400 : 0;
		$this->data['enable_label'] = !empty($parameters['enable_label']);
		$this->data['list_label'] = !empty($parameters['list_label']) ? $parameters['list_label'] : '';

		// Setup current block type
		$current_system = $this->sp_topStatsSystem[$type];

		// Possible to output?
		if (empty($current_system['enabled']))
		{
			if (!empty($current_system['error_msg']))
			{
				$this->setTemplate('template_sp_topStatsMember_error');
				$this->data['error_msg'] = $current_system['error_msg'];
			}

			return;
		}

		// Sort in reverse?
		$sort_asc = !empty($current_system['reverse']) ? !$sort_asc : $sort_asc;

		// Build the where statement
		$where = array();

		// If this is already cached, use it
		$chache_id = 'sp_chache_' . $id . '_topStatsMember';
		if (empty($this->_modSettings['sp_disableChache']) && !empty($this->_modSettings[$chache_id]))
		{
			$data = explode(';', $this->_modSettings[$chache_id]);

			if ($data[0] == $type && $data[1] == $limit && !empty($data[2]) == $sort_asc && $data[3] > time() - 300) // 5 Minute cache
			{
				$where[] = 'mem.id_member IN (' . $data[4] . ')';
			}
			else
			{
				unset($this->_modSettings[$chache_id]);
			}
		}

		// Last active remove
		if (!empty($last_active_limit))
		{
			$timeLimit = time() - $last_active_limit;
			$where[] = "last_login > $timeLimit";
		}

		if (!empty($current_system['where']))
		{
			$where[] = $current_system['where'];
		}

		if (!empty($where))
		{
			$where = 'WHERE (' . implode(')
				AND (', $where) . ')';
		}
		else
		{
			$where = "";
		}

		// Finally make the query with the parameters we built
		$request = $this->_db->query('', '
			SELECT
				mem.id_member, mem.real_name, mem.avatar, mem.email_address,
				a.id_attach, a.attachment_type, a.filename,
				{raw:field}
			FROM {db_prefix}members as mem
				LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = mem.id_member)
			{raw:where}
			ORDER BY {raw:order} {raw:sort}
			LIMIT {int:limit}',
			array(
				// Prevent delete of user if the cache was available
				'limit' => isset($context['common_stats']['total_members']) && $context['common_stats']['total_members'] > 100 ? ($limit + 5) : $limit,
				'field' => $current_system['field'],
				'where' => $where,
				'order' => $current_system['order'],
				'sort' => ($sort_asc ? 'ASC' : 'DESC'),
			)
		);
		$this->data['members'] = array();
		$count = 1;
		$chache_member_ids = array();
		while ($row = $this->_db->fetch_assoc($request))
		{
			// Collect some to cache data
			$chache_member_ids[$row['id_member']] = $row['id_member'];
			if ($count++ > $limit)
			{
				continue;
			}

			$this->color_ids[$row['id_member']] = $row['id_member'];

			// Setup the row
			$output = '';

			// Prepare some data of the row?
			if (!empty($current_system['output_function']))
			{
				$current_system['output_function']($row);
			}

			if (!empty($current_system['output_text']))
			{
				$output = $current_system['output_text'];
				foreach ($row as $item => $replacewith)
				{
					$output = str_replace('%' . $item . '%', $replacewith, $output);
				}
			}

			$this->data['members'][] = array(
				'id' => $row['id_member'],
				'name' => $row['real_name'],
				'href' => $scripturl . '?action=profile;u=' . $row['id_member'],
				'link' => '<a style="font-size: 90%" href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>',
				'avatar' => determineAvatar(array(
					'avatar' => $row['avatar'],
					'filename' => $row['filename'],
					'id_attach' => $row['id_attach'],
					'email_address' => $row['email_address'],
					'attachment_type' => $row['attachment_type'],
				)),
				'output' => $output,
				'complete_row' => $row,
			);
		}
		$this->_db->free_result($request);

		// Update the cache, at least around 100 members are needed for a good working version
		if (empty($this->_modSettings['sp_disableChache']) && isset($context['common_stats']['total_members']) && $context['common_stats']['total_members'] > 0 && !empty($chache_member_ids) && count($chache_member_ids) > $limit && empty($this->_modSettings[$chache_id]))
		{
			$toCache = array($type, $limit, ($sort_asc ? 1 : 0), time(), implode(',', $chache_member_ids));
			updateSettings(array($chache_id => implode(';', $toCache)));
		}
		// One time error, if this happens the cache needs an update
		elseif (!empty($this->_modSettings[$chache_id]))
		{
			updateSettings(array($chache_id => '0;0;0;1000;0'));
		}

		// Color the id's
		$this->_colorids();

		// Set the template to use
		$this->setTemplate('template_sp_topStatsMember');
	}