Activity Details [Archive]

mutus123

10-21-2005, 10:00 PM

Admin tool: Where specific users are posting most often... Which forums have the most activity, and who exactly is responsible for that activity in each forum.

If not for your own curiosity, probably the most useful benefit of Activity Details is the ability to track forums individually, which could help to set value on per-forum advertising rates.

Features

Installer included, No code modification.
All queries accept start/end date parameters.
Activity measured by either thread or by post.
Choose a member, view that member's activity by forum.
Choose a forum, view forum's activity by member.
View overall activity by forum or by member.

Possible Future Expsansions

Cache results for public viewing
Track activity details by time of day / day of week
Track activity details by age group
Private message activity tracking
Add forum grouping system for custom pattern queries
Maybe use forum activity patterns in conjunction with a banner system to intelligently target ads by forum and/or by member.

Contents

2 files
1 Product installer (10 phrases)

Installation

Copy contents of "upload" folder to corresponding directories on your forum.
Import product-activitydetails.xml (Admin CP -> Plugin System -> Manage Products -> Add/Import Product)
(Note: addtion to admincp nav panel will not appear after installation until the nav panel is refreshed)

Updates

1.0.0 Release
1.0.1 Adjusted forum queries to properly recognize categories and sub-forums

Odysseus

10-22-2005, 08:49 PM

Sounds interesting.
I will try this tomorrow!

Injektilo

10-22-2005, 08:59 PM

can somehow, those resaults be shown to members as well so it encourages them for more activity?

mutus123

10-22-2005, 09:16 PM

can somehow, those resaults be shown to members as well so it encourages them for more activity?

Yeah sure, but the queries can be slow on large tables. For that reason, I would build a cache table that updated every so often for public use. The only drawback would be that you couldn't let the end users choose a time frame. You'd have to pre-determine it before caching the results, for example past month or past 3 months. And realistically, you'd have to determine the top X members/forums to display in advance. But these could be admin CP settings and cron could take it from there.

I like the idea, thanks. I will add it to the future considerations. I have free time tomorrow. Maybe I'll tinker around with it :)

harmor19

10-22-2005, 09:21 PM

Nice hack,
I'm guessing you coded for another bbs?
because you only have 13 posts.

mutus123

10-22-2005, 09:45 PM

Nice hack,
I'm guessing you coded for another bbs?
because you only have 13 posts.

Thank you :)

never coded for another bbs. (acutally I'm not even sure what that means) :nervous:

I do code for a living (.NET by day, PHP by night)

been lurking here for a long time. I only post when I have a question about a hack (until now).

harmor19

10-22-2005, 09:47 PM

bbs = bulletin board software
meaning ipb, mybb, phpbb, etc.

Oblivion Knight

10-23-2005, 07:28 AM

Interesting, I'll have to take a closer look at this one when I'm more awake.. ;)

xtreme-mobile

10-23-2005, 11:52 AM

ill take a look at this too looks very interesting

Snake

10-23-2005, 12:20 PM

This is great, thanks.

Oblivion Knight

10-23-2005, 01:12 PM

Is it possible for this to be extended to show "Member Activity by Category"? I'd have thought that logically, displaying the member activity by forum would have already covered this but it doesn't..

For example:
Category 1
> Forum 1
> Forum 2

Category 2
> Forum 3
> Forum 4

If I try selecting Category 1, it says "No Matches Found". I'd like it to add Forum 1 and Forum 2 together. :)

Gizmo5h1t3

10-23-2005, 01:29 PM

/me clicks install, thats SWEEET!!

mutus123

10-23-2005, 02:14 PM

Is it possible for this to be extended to show "Member Activity by Category"?

Yea I think that should be easy enough to adjust for. Right now it's just looking for a straight match on forum ID. I'll try and fix that when I get a chance.

weaver

10-23-2005, 02:57 PM

This is great. Thanks :)

I'd like to know how to exclude certain users and forums from being calculated. I have an RSS feed moderator and RSS feed forums that I'd like to have ignored from the results.

mutus123

10-23-2005, 03:22 PM

Oblivion Knight - I updated the queries and that problem should be resolved. New version is 1.0.1. The file that changed is admincp/activitydetails.php.

weaver - my pleasure :) Yep that's what I meant under future considerations by "Add forum grouping system for custom pattern queries". In other words, let the admin create custom groupings of forums (not necessarily related to the parent-child forum hierarchy) for activity tracking purposes. So that's definitely something I would like to add in.

I honestly hadn't thought about user exclusions or groupings, but that is certainly an idea for consideration as well.

Oblivion Knight

10-23-2005, 05:06 PM

Oblivion Knight - I updated the queries and that problem should be resolved. New version is 1.0.1. The file that changed is admincp/activitydetails.php.Excellent, thank you very much.. :D

weaver

10-23-2005, 06:25 PM

weaver

10-23-2005, 06:28 PM

I reinstalled but I don't see where it is now allowing for categories. I'm still getting "No Matches Found" when I click on a category title.

mutus123

10-23-2005, 06:35 PM

I reinstalled but I don't see where it is now allowing for categories. I'm still getting "No Matches Found" when I click on a category title.

Hmm, Did you over-write the file admincp/activitydetails.php with the new version? That's where all the queries were changed.

SnowBot

10-23-2005, 07:02 PM

very, very interesting......well done and thanks for sharing.

Reminder

11-16-2005, 04:39 PM

thanks

Tralala

02-01-2006, 05:59 AM

How about allowing us to see LEAST active?

fuldon

12-08-2007, 10:24 AM

Installed.