24 Hour Activity Stats (24 Saat Etkinlik İstatistikleri)

[ESQARE]

Eklenti de bir sorun olduğunu ben düşünmüyorum. Yoksa şimdiye kadar en başta eklentinin phpBB.com forumlarındaki sayfası olsun bu konu tartışılırdı. Siz çalışma mantığını tam çözemediniz sanırım.

[ToMCaT]

60 dk dada 24 saattede sonuç aynı bunu demek istiyorum 1 saate göre işliyor 24 saatte 1000 kişi olacağına 100 kişi bir saatlik sonucu veriyor. Ama sorun benden kaynaklı da olabilir çünkü eklentilerde forumda aynı 1 saate göre çözemedim gitti en sonunda vaz geçtim 1 saate göre ayarladım bıraktım

[ESQARE]

Forumu hangi tarayıcı ile görüntülüyorsunuz?

[ToMCaT]

Chrome

[ESQARE]

Ctrl+F5 yapıp sayfayı yenileyerek istatistikleri görüntülemeyi deneyin. Tarayıcınız istatistikleri önbelleğe alıyor olabilir.

[ToMCaT]

Hepsini denedim biyer de Bi yanlış bişi var ama çözemedim site forum üstünde 1 saate göre bir ayar varmı bildiğiniz

[ESQARE]

YKP -> GENEL -> Yükleme Ayarları -> Çevrimiçi zamanı görüntüleme süresi:

Bu ayarın varsayılanı 5'tir.

[ToMCaT]

Onun dışında yok deme

[ESQARE]

Çevrimiçi süresi ayarı yok başka. Sitenizi kontrol edeceğim. Eklentiyi tekrar aktifleştirir misiniz?

[ToMCaT]

Aktifleştirdim

[ESQARE]

Aktif olarak kalsın bir süre beklememiz gerekiyor. Bu aşamada başka bir ayar yapmayın.

[ToMCaT]

Ellemiyorum 1 saat sonra 60 tan 20ye gibi 80den 50 te gibi olacak diğeri 60 dkya göre karşılaştırınca gayet açık

[ToMCaT]

Farkettiysen değişti 190 dan 120 ye çekti

[ESQARE]

FTP ile sunucunuza bağlanıp eklentinin listener.php dosyasının içeriğini buraya kopyalarmısınız? rmcgirr83/activity24hours/event/listener.php

[ToMCaT]

Kod: Tümünü seç

<?php
/**
*
* Activity 24 hours extension for the phpBB Forum Software package.
*
* @copyright (c) 2015 Rich McGirr (RMcGirr83)
* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2
*
*/

namespace rmcgirr83\activity24hours\event;

/**
* @ignore
*/
use Symfony\Component\EventDispatcher\EventSubscriberInterface;

/**
* Event listener
*/
class listener implements EventSubscriberInterface
{
	/** @var \phpbb\auth\auth */
	protected $auth;

	/** @var \phpbb\cache\service */
	protected $cache;

	/** @var \phpbb\config\config */
	protected $config;

	/** @var \phpbb\db\driver\driver */
	protected $db;

	/** @var \phpbb\event\dispatcher_interface */
	protected $dispatcher;

	/** @var \phpbb\template\template */
	protected $template;

	/** @var \phpbb\user */
	protected $user;

	public function __construct(
		\phpbb\auth\auth $auth,
		\phpbb\cache\service $cache,
		\phpbb\config\config $config,
		\phpbb\db\driver\driver_interface $db,
		\phpbb\event\dispatcher_interface $dispatcher,
		\phpbb\template\template $template,
		\phpbb\user $user,
		\rmcgirr83\hidebots\event\listener $hidebots = null)
	{
		$this->auth = $auth;
		$this->cache = $cache;
		$this->config = $config;
		$this->db = $db;
		$this->dispatcher = $dispatcher;
		$this->template = $template;
		$this->user = $user;
		$this->hidebots = $hidebots;
	}

	/**
	* Assign functions defined in this class to event listeners in the core
	*
	* @return array
	* @static
	* @access public
	*/
	static public function getSubscribedEvents()
	{
		return array(
			'core.index_modify_page_title'			=> 'display_24_hour_stats',
		);
	}

	/**
	* Display stats on index page
	*
	* @param object $event The event object
	* @return null
	* @access public
	*/
	public function display_24_hour_stats($event)
	{
		// if the user is a bot
		if ($this->user->data['is_bot'])
		{
			return;
		}

		$this->user->add_lang_ext('rmcgirr83/activity24hours', 'common');

		// obtain posts/topics/new users activity
		$activity = $this->obtain_activity_data();

		// obtain user activity data
		$active_users = $this->obtain_active_user_data();

		// Obtain guests data
		$total_guests_online_24 = $this->obtain_guest_count_24();

		$user_count = $bot_count = $hidden_count = 0;
		$interval = $this->define_interval();
		// parse the activity
		foreach ((array) $active_users as $row)
		{
			// we hide bots according to the hide bots extension
			$should_hide = (!$this->auth->acl_get('a_') && $this->hidebots !== null) ? true : false;
			
			// the users stuff...this is changed below depending
			$username_string = $this->auth->acl_get('u_viewprofile') ? get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']) : get_username_string('no_profile', $row['user_id'], $row['username'], $row['user_colour']);
			$max_last_visit = max($row['user_lastvisit'], $row['session_time']);
			$hover_info = ' title="' . $this->user->format_date($max_last_visit, false, false) . '"';
			
			if (($should_hide && $row['user_type'] == USER_IGNORE) || ($row['user_lastvisit'] < $interval && $row['session_time'] < $interval))
			{
				continue;
			}

			if (((!$row['session_viewonline'] && !empty($row['session_time'])) || !$row['user_allow_viewonline']) && $row['user_type'] != USER_IGNORE )
			{
				++$hidden_count;
				if ($this->auth->acl_get('u_viewonline') || $row['user_id'] === $this->user->data['user_id'])
				{
					$row['username'] = '<em>' . $row['username'] . '</em>';
					$username_string = get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);
				}
			}
			// to seperate bots from normal users
			elseif ($row['user_type'] == USER_IGNORE)
			{
				++$bot_count;
				$this->template->assign_block_vars('bot_lastvisit', array(
					'BOTNAME_FULL'	=> '<span' . $hover_info . '>' . get_username_string('no_profile', $row['user_id'], $row['username'], $row['user_colour']) . '</span>',
				));
				continue;
			}
			else
			{
				++$user_count;
			}
			
			$this->template->assign_block_vars('lastvisit', array(
				'USERNAME_FULL'	=> '<span' . $hover_info . '>' . $username_string . '</span>',
			));
		}

		// assign the forum stats to the template.
		$template_data = array(
			'BOTS_ACTIVE'			=> $bot_count,
			'USERS_ACTIVE'			=> $user_count + $hidden_count,
			'TOTAL_24HOUR_USERS'	=> $this->user->lang('TOTAL_24HOUR_USERS', $user_count + $total_guests_online_24 + $bot_count + $hidden_count),
			'USERS_24HOUR_TOTAL'	=> $this->user->lang('USERS_24HOUR_TOTAL', $user_count),
			'BOTS_24HOUR_TOTAL'		=> $this->user->lang('BOTS_24HOUR_TOTAL', $bot_count),
			'HIDDEN_24HOUR_TOTAL'	=> $this->user->lang('HIDDEN_24HOUR_TOTAL', $hidden_count),
			'GUEST_ONLINE_24'		=> $total_guests_online_24 ? $this->user->lang('GUEST_ONLINE_24', $total_guests_online_24) : '',
			'HOUR_TOPICS'			=> $this->user->lang('24HOUR_TOPICS', $activity['topics']),
			'HOUR_POSTS'			=> $this->user->lang('24HOUR_POSTS', $activity['posts']),
			'HOUR_USERS'			=> $this->user->lang('24HOUR_USERS', $activity['users']),
			'S_CAN_VIEW_24_HOURS'	=> true,
		);
		/**
		* Modify activity display
		*
		* @event rmcgirr83.activity24hours.modify_activity_display
		* @var array	activity				An array of the activity posts, topics etc.
		* @var array	active_users			An array of users active for past x time
		* @var bool		total_guests_online_24 Count of guests for past x time
		* @var array	template_data			An array of the template items
		* @since 1.0.6
		*/
		$vars = array('activity', 'active_users', 'total_guests_online_24', 'template_data');
		extract($this->dispatcher->trigger_event('rmcgirr83.activity24hours.modify_activity_display', compact($vars)));

		// Assign template date to template engine
		$this->template->assign_vars($template_data);
	}

	/**
	 * Obtain an array of active users over the last 24 hours.
	 *
	 * @return array
	 */
	private function obtain_active_user_data()
	{
		$active_users = array();
		$interval = $this->define_interval();
		if (($active_users = $this->cache->get('_24hour_users')) === false)
		{
			// grab a list of users who are currently online
			// and users who have visited in the last 24 hours
			$sql_ary = array(
				'SELECT'	=> 'u.user_id, u.user_colour, u.username, u.user_type, u.user_lastvisit, u.user_allow_viewonline, MAX(s.session_time) as session_time, s.session_viewonline',
				'FROM'		=> array(USERS_TABLE => 'u'),
				'LEFT_JOIN'	=> array(
					array(
						'FROM'	=> array(SESSIONS_TABLE => 's'),
						'ON'	=> 's.session_user_id = u.user_id',
					),
				),
				'WHERE'		=> 'u.user_lastvisit > ' . (int) $interval . ' OR s.session_user_id <> ' . ANONYMOUS,
				'GROUP_BY'	=> 'u.user_id, s.session_viewonline',
				'ORDER_BY'	=> 'u.username_clean',
			);

			/**
			* Modify sql_ary
			*
			* @event rmcgirr83.activity24hours.modify_sql_ary
			* @var array	sql_ary			An array of the sql query
			* @since 1.0.4
			*/
			$vars = array('sql_ary');
			extract($this->dispatcher->trigger_event('rmcgirr83.activity24hours.modify_sql_ary', compact($vars)));

			$result = $this->db->sql_query($this->db->sql_build_query('SELECT', $sql_ary));

			while ($row = $this->db->sql_fetchrow($result))
			{
				$active_users[$row['user_id']] = $row;
			}
			$this->db->sql_freeresult($result);

			// cache this data for 5 minutes, this improves performance
			$this->cache->put('_24hour_users', $active_users, 300);
		}
		return $active_users;
	}

	/**
	 * obtained cached 24 hour activity data
	 *
	 * @return array
	 */
	private function obtain_activity_data()
	{
		$activity = array();
		$interval = $this->define_interval();
		if (($activity = $this->cache->get('_24hour_activity')) === false)
		{

			// total new posts in the last 24 hours
			$sql = 'SELECT COUNT(post_id) AS new_posts
					FROM ' . POSTS_TABLE . '
					WHERE post_time > ' . (int) $interval;
			$result = $this->db->sql_query($sql);
			$activity['posts'] = $this->db->sql_fetchfield('new_posts');
			$this->db->sql_freeresult($result);

			// total new topics in the last 24 hours
			$sql = 'SELECT COUNT(topic_id) AS new_topics
					FROM ' . TOPICS_TABLE . '
					WHERE topic_time > ' . (int) $interval;
			$result = $this->db->sql_query($sql);
			$activity['topics'] = $this->db->sql_fetchfield('new_topics');
			$this->db->sql_freeresult($result);

			// total new users in the last 24 hours, counts inactive users as well
			$sql = 'SELECT COUNT(user_id) AS new_users
					FROM ' . USERS_TABLE . '
					WHERE user_regdate > ' . (int) $interval;
			$result = $this->db->sql_query($sql);
			$activity['users'] = $this->db->sql_fetchfield('new_users');
			$this->db->sql_freeresult($result);

			// cache this data for 5 minutes, this improves performance
			$this->cache->put('_24hour_activity', $activity, 300);
		}
		return $activity;
	}

	private function obtain_guest_count_24()
	{
		$total_guests_online_24 = 0;
		$interval = $this->define_interval();
		if ($this->config['load_online_guests'])
		{
			// Get number of online guests for the past 24 hours
			// caching and main sql if none yet
			if (($total_guests_online_24 = $this->cache->get('_total_guests_online_24')) === false)
			{
				if ($this->db->get_sql_layer() === 'sqlite' || $this->db->get_sql_layer() === 'sqlite3')
				{
					$sql = 'SELECT COUNT(session_ip) as num_guests_24
						FROM (
							SELECT DISTINCT session_ip
							FROM ' . SESSIONS_TABLE . '
							WHERE session_user_id = ' . ANONYMOUS . '
								AND session_time >= ' . ($interval - ((int) ($interval % 60))) . ')';
				}
				else
				{
					$sql = 'SELECT COUNT(DISTINCT session_ip) as num_guests_24
						FROM ' . SESSIONS_TABLE . '
						WHERE session_user_id = ' . ANONYMOUS . '
							AND session_time >= ' . ($interval - ((int) ($interval % 60)));
				}
				$result = $this->db->sql_query($sql);
				$total_guests_online_24 = (int) $this->db->sql_fetchfield('num_guests_24');

				$this->db->sql_freeresult($result);

				// cache this data for 5 minutes, this improves performance
				$this->cache->put('_total_guests_online_24', $total_guests_online_24, 300);
			}
		}
		return $total_guests_online_24;
	}

	public function define_interval()
	{
		/* you can define the amount to look back
		 * be careful with this, it may cause performance issues on your forum
		 * (60 * 60) * hours * days
		 * 86400 = 24 hours
		 * 604800 = past 7 days
		 * 2628000 = past month
		*/
		$look_back = 86400;

		/**
		* Modify activity look back
		*
		* @event rmcgirr83.activity24hours.modify_activity_look_back
		* @var	int		look_back	The number of seconds used in the extension
		* @return		the amount of time in seconds
		* @since 1.0.7
		*/
		$vars = array('look_back');
		extract($this->dispatcher->trigger_event('rmcgirr83.activity24hours.modify_activity_look_back', compact($vars)));

		return (time() - $look_back);
	}
}

buyrun