[ABD] Activity Stats (includes "who was here?")

Any abandoned Extensions will be moved to this forum.

WARNING: Extensions in this forum are not currently being supported or maintained by the original Extension author. Proceed at your own risk.
Forum rules
IMPORTANT: Extension Development Forum rules

WARNING: Extensions in this forum are not currently being supported nor updated by the original Extension author. Proceed at your own risk.
Locked
combuster
Registered User
Posts: 342
Joined: Sun Oct 26, 2008 11:58 pm

[ABD] Activity Stats (includes "who was here?")

Post by combuster » Sun Sep 14, 2014 10:09 pm

Please test the extension and provide feedback here or at github, THX!

Extension Name: Activity Stats
Author: combuster

Extension Description::

phpBB 3.1 extension that displays statistics of the latest activities on the boards index site.

This extension is the 3.1.x version of the 3.0.x Activity Stats MOD merged with 3.0.x Who was here? MOD.

NOTE: To increase performance the calculated data is cached (10min by default, adjustable in ACP) - so it might take a while until the stats are updated.

Extension Version:: 1.2.3-DEV

Features:
  • adjust the timespan that is considered for calculating the "lately" activities in ACP
  • show count of new topics, new posts and newly registered users in that timespan ("Activity Stats")
  • list of useres who have been active lately ("Who was here?")
  • en-/disable new topics in the list (adjustable in ACP)
  • en-/disable new posts in the list (adjustable in ACP)
  • en-/disable new users in the list (adjustable in ACP)
  • en-/disable bots in the list (adjustable in ACP)
  • en-/disable hidden users in the list (adjustable in ACP)
  • en-/disable guests in the record (adjustable in ACP)
  • en-/disable visit-time in the list or as "hover" on the name (adjustable in ACP)
  • display and store the record (in ACP)
  • reset-function (in ACP)
  • time is displayed with user-timezone and dst(daylight-saving-time) adjustment of the ucp
  • usernames are coloured
  • Data is cached to improve performance (cache-time adjustable in ACP)
  • permission who can see the stats:
    Disabled (default)=everybody can always see the stats (permission is ignored).
    Enabled=use user permission like configured in ACP. It can be assigned to users and/or groups. By default its assigned to the roles ROLE_ADMIN_FULL, ROLE_USER_FULL, ROLE_USER_STANDARD.
Screenshots:
Image
Image
Image

Downloads: Extension Repository:

Github: https://github.com/RobertHeim/phpbb3_1- ... ivitystats

Installation:
  1. Clone (or download an move) the repository into the folder phpBB3/ext/robertheim/activitystats:

    Code: Select all

    cd phpBB3
    git clone https://github.com/RobertHeim/phpbb3_1-ext-activitystats.git ext/robertheim/activitystats/
    
  2. Go to admin panel -> tab customise -> Manage extensions -> enable Activity Stats
  3. Go to admin panel -> tab Extensions -> Activity Stats -> Settings for configuration
Donation:
Please donate to any charity organisation or buyme a bear on my blog, Thanks!

Changelog:
Since 1.2.2-DEV
  • Bug-Fixes
Since 1.2.1-DEV
  • Bug-Fixes (especially timezone handling is now much better and phpbb3.1 conform)
  • plurals & typos
Since 1.2.0-DEV
  • *fixed* users that are not allowed to see the stats were not recorded
  • more plurals
  • improved documentation
  • removed permission assignments to forum-roles on installation
Since 1.1.2-DEV
  • fixed HTML
  • added permissions for viewing stats
Since 1.1.1-DEV
  • mode-selection fixed (e.g. switching from "period of time" to "today")
  • better explenation of today-mode
  • bug-fixes
Since 1.1.0-DEV:
  • minor bug fixes
Since 1.0.0-RC3:
  • all the "Who was here?"-Features
  • several bug fixes
  • caching time adjustable
  • en-/disable new topics/posts/users
  • plurals
Since 1.0.0-RC2:
  • added count of guests that were active in the last 24 hours
Last edited by combuster on Sat Nov 22, 2014 9:36 pm, edited 27 times in total.

User avatar
Meis2M
Translator
Posts: 883
Joined: Wed Mar 03, 2010 11:32 am
Location: IR.Damghan
Name: میثم نوبری
Contact:

Re: [RC] Activity Stats

Post by Meis2M » Mon Sep 15, 2014 7:45 am

well done...

can u add number of guests who visited in 24 h ?
phpBB persian international support
Ultimate SEO Friendly URL - Extension
Follow us in Instagram
Free upgrade and install extensions on your forum - drop me PM

combuster
Registered User
Posts: 342
Joined: Sun Oct 26, 2008 11:58 pm

Re: [RC] Activity Stats

Post by combuster » Mon Sep 15, 2014 1:43 pm

Meis2M wrote:can u add number of guests who visited in 24 h ?
short: no

long:
  1. The ext should match the exact functionality as the MOD for 3.0.x
  2. We would need to store additional data to not count a guest twice, right?

User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 6652
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact:

Re: [RC] Activity Stats

Post by Raul [ThE KuKa] » Mon Sep 15, 2014 5:17 pm

Nice Extension!!! ;)
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies :warning:


If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate with Image
:flag_es: phpBB Spain - Online Since 2003 :heart:



User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: [RC] Activity Stats

Post by RMcGirr83 » Tue Sep 16, 2014 10:52 am

combuster wrote:
Meis2M wrote:can u add number of guests who visited in 24 h ?
short: no
If you don't care if guests are counted more than once

Code: Select all

        // total guests in the last 24 hours
        $sql = 'SELECT COUNT(session_ip) AS num_guests
                FROM ' . SESSIONS_TABLE . '
                WHERE session_user_id = ' . ANONYMOUS . '
                AND session_time >= ' . $interval;                
        $result = $db->sql_query($sql);
        $activity['guests'] = $db->sql_fetchfield('num_guests');
        $db->sql_freeresult($result); 
and if you do care

Code: Select all

        // total guests in the last 24 hours
        $sql = 'SELECT COUNT(DISTINCT session_ip) AS num_guests
                FROM ' . SESSIONS_TABLE . '
                WHERE session_user_id = ' . ANONYMOUS . '
                AND session_time >= ' . $interval;                
        $result = $db->sql_query($sql);
        $activity['guests'] = $db->sql_fetchfield('num_guests');
        $db->sql_freeresult($result); 
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

combuster
Registered User
Posts: 342
Joined: Sun Oct 26, 2008 11:58 pm

Re: [RC] Activity Stats

Post by combuster » Tue Sep 16, 2014 3:48 pm

Thanks RMcGirr83!

I added it and updated the downloads to 1.0.0-RC3.

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: [RC] Activity Stats

Post by RMcGirr83 » Tue Sep 16, 2014 5:05 pm

You're welcome but you need to edit the html file, the lang file as well as the event php file to get it to display. Right now you have the query but the output from it isn't displaying anywhere.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

combuster
Registered User
Posts: 342
Joined: Sun Oct 26, 2008 11:58 pm

Re: [RC] Activity Stats

Post by combuster » Tue Sep 16, 2014 6:45 pm

RMcGirr83, my friend, look again, as I said I added it already: “1 users and 1guests have been active in the last 24h“

leschek
Registered User
Posts: 791
Joined: Tue Jul 18, 2006 12:49 pm
Contact:

Re: [RC] Activity Stats

Post by leschek » Tue Sep 16, 2014 8:18 pm

Interesting. I like "Who was here" MOD and this extension could replace it, when I'll update my board. I have a few questions:

1. Is possible to set permission who can see it?
2. Is possible to set time range or it is always 24 hours?
3. Do you plan to add plurals?

User avatar
Jessica
Former Team Member
Posts: 4342
Joined: Sun Jul 18, 2010 2:53 pm
Location: Pennsylvania, USA
Name: Jessica
Contact:

Re: [RC] Activity Stats

Post by Jessica » Tue Sep 16, 2014 9:22 pm

The "Who was here" MOD added an option to choose the last time visited to show in a hover when putting the mouse over a username. Can you add that to the extension please?
Pro-choice, Atheist, Pro-LGBT rights
Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid. - Albert Einstein

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: [RC] Activity Stats

Post by RMcGirr83 » Wed Sep 17, 2014 1:45 am

The "who was here mod" is not the same as this mod.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

User avatar
Jessica
Former Team Member
Posts: 4342
Joined: Sun Jul 18, 2010 2:53 pm
Location: Pennsylvania, USA
Name: Jessica
Contact:

Re: [RC] Activity Stats

Post by Jessica » Wed Sep 17, 2014 2:14 am

I beg to differ.

Part of the Activity Stats mod/ext is the last users/guests visited in the last 24 hours feature. That's essentially the Who was Here mod (for the users last visited), even if it's not exact
Pro-choice, Atheist, Pro-LGBT rights
Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid. - Albert Einstein

combuster
Registered User
Posts: 342
Joined: Sun Oct 26, 2008 11:58 pm

Re: [RC] Activity Stats

Post by combuster » Fri Sep 19, 2014 1:45 pm

I think we can merge both 3.0 MODS "Activity Stats" with "Who was here" in this 3.1 extension.
leschek wrote:1. Is possible to set permission who can see it?
2. Is possible to set time range or it is always 24 hours?
3. Do you plan to add plurals?
Thx for ideas. I will add these things in 1.1.0. See https://github.com/RobertHeim/phpbb3_1- ... ats/issues
Jessica wrote:The "Who was here" MOD added an option to choose the last time visited to show in a hover when putting the mouse over a username. Can you add that to the extension please?
Was this feature available only at the part of the index-page where the last activity-stats were shown or everywhere where a user-name is shown (board-wide)?

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: [RC] Activity Stats

Post by RMcGirr83 » Sat Sep 20, 2014 2:00 am

combuster wrote:Was this feature available only at the part of the index-page where the last activity-stats were shown or everywhere where a user-name is shown (board-wide)?
As far as I recall, on the index page (it was a hover title thing).
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

combuster
Registered User
Posts: 342
Joined: Sun Oct 26, 2008 11:58 pm

Re: [RC] Activity Stats

Post by combuster » Sat Sep 20, 2014 5:11 am

:arrow: Huge *UPDATE*: integrated all features of "Who was here"-3.0.x-MOD as well as (adjustable) caching and some other tweaks! See first post for full feature list and screenshots!

Donate to some charity organisation. Thanks! :)

Locked

Return to “Abandoned Extensions”