Enhanced Forum Statistics

[Rudolf]

Link to Mod

*****************************************************
Enhanced Forum Statistics - Modification for SMF
version 1.0
© 2007, Rudolf Martincsek
*****************************************************
This mod allows you to select periods for which to display the forum statistics.
You can choose between first/last x days/weeks/months/years or custom start and end dates OR their combination.
Experiment.

Some values explained:

• Total Members - The number of members registered during the selected period
• Average registrations per day - Like the title say, based on the selected period
• Total Posts - The number of posts made in the selected period
• Average posts per day - Like the title say, based on the selected period
• Total Topics - The number of new topics posted in the selected period
• Average topics per day - Like the title say, based on the selected period
• Total Categories - The total number of categories on the forum (regardless of the period)
• Total Boards - The total number of boards on the forum (regardless of the period)
• Users Online - The number of users online at the moment (regardless of the period)
• Latest Member - The lastes member registered on your forum (regardless of the period)
• Most Online - The most online users in the selected period
• Average online per day - Like the title says, based on the selected period
• Online Today - Like the title says
• Male to Female ratio - Like the title says, based on the selected period

• Top 10 Posters - The 10 members who made the mosts posts in the selected period
• Top 10 Boards - The 10 boards whith the most new posts made in the selected period
• Top 10 Topics (by Replies) - The 10 topics with the the most new replies in the selected period
• Top 10 Topics (by Views) - The 10 topics with the the most views in the selected period
• Top Topic Starters - The members who started the most topics in the selected period
• Most Time Online - Members who spent most time on your forum. Regardless of the period. Don't even ask to make it specific.

Screenshot:

[ArkServer]

Nice mod, tempted to install but im not sure if it will work with all teh other mods i have..

[Rudolf]

I'm pretty sure it will work. Not many mods relate to the statistics. Probably it will work on all your themes out of the box too.

[babjusi]

Seems a cool mod, do I have to enable it anywhere after installing it? Where will those satistics be shown in my board, do I get to choose the place for them to be displayed? Thank you

[Rudolf]

It is the forum statistics center([More stats]), but enhanced. There's no need to enable anything.

[babjusi]

Thanks for your explanation rudolf

[casp3r]

I have just installed it on two forums:
1 - Many mods and using Cityscape theme - Works
2 - Many Mods and using Classic YaBB SE Theme - Doesn't work - although this forum has a number of other mods that don't work and to be honest I had Tiny Portal installed and I have had problems ever since I uninstalled it.

[chep]

Entered number 2 for "Last 2 weeks"

Code Select Expand

Database Error
Column 'ID_BOARD' in where clause is ambiguous
File: /home/u1/huntwa/html/smf/Sources/Stats.php
Line: 648

[topiQ]

Thanks Rudolf for this useful mod! As i am a native german speaker i edited the languages.xml and added german language support.
if some one is interested just download my attachment.

Greets,
topiQ

@Rudolf: If u want u can implement the modified language.xml in any new version of your mod.

//EDIT: Attachment removed as Rudolft integrated it in the mod.

[Rudolf]

Entered number 2 for "Last 2 weeks"

Code Select Expand

Database Error
Column 'ID_BOARD' in where clause is ambiguous
File: /home/u1/huntwa/html/smf/Sources/Stats.php
Line: 648

I don't get that error. Any error in the forum error log apart of this?
Can you post the lines from 640 to 655 from Stats.php?

[Rudolf]

Thanks Rudolf for this useful mod! As i am a native german speaker i edited the languages.xml and added german language support.
if some one is interested just download my attachment.

Greets,
topiQ

@Rudolf: If u want u can implement the modified language.xml in any new version of your mod.

Thank you. I integrated in the mod. You should remove the attachment because it will give errors on the installation if someone doesn't have the german language pack installed.

[chep]

This is the error in the forum error log as well...

Code Select Expand

Database Error
Column 'ID_BOARD' in where clause is ambiguous
File: /home/u1/huntwa/html/smf/Sources/Stats.php
Line: 648


Lines 636 until 654

Code Select Expand

//-Enhanced Forum Statistics MOD- Start
if ($restrict_date)
{
$request = db_query("
SELECT ID_MEMBER_STARTED, COUNT(*) AS hits
FROM {$db_prefix}topics
LEFT JOIN  {$db_prefix}messages as msg ON (msg.ID_MSG = ID_FIRST_MSG)
WHERE msg.posterTime >= $start_date AND msg.posterTime <= $end_date
" . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? "
AND ID_BOARD != $modSettings[recycle_board]" : '') . "
GROUP BY ID_MEMBER_STARTED
ORDER BY hits DESC
LIMIT 20", __FILE__, __LINE__);
$members = array();
while ($row = mysql_fetch_assoc($request))
$members[$row['ID_MEMBER_STARTED']] = $row['hits'];
mysql_free_result($request);
}
//-Enhanced Forum Statistics MOD- End



Lines 647 - 8 - 9

Code Select Expand


ORDER BY hits DESC
LIMIT 20", __FILE__, __LINE__);
$members = array();


Think it has anything to do with recycle bin boards?

[Rudolf]

Yes, that was it.
I uploaded the package. Download and reinstall should solve the problem.

[chep]

Works now! Great mod.

I have over 30 mods and works well.

1. SMF Links 1.6.3
2. New Topic Button 1.0
3. Increase/Decrease Postbox Size 1.0
4. Coppermine Userpics 1.0
5. TinyPortal 0.983
6. Spam Me Not Mod 1.02
7. Ad Managment 2.3
8. FlashChat Integration 1.0
9. SMF Ajax Registration Feedback 1.0.0
10. Topics Started by a user v 0.1.3 bugfixed - By Yio - bugfixed by Jack van Dijk 0.1.3
11. Enhanced Calendar 1.1
12. Search Topic 1.01
13. Select Admin for Notifications 1.1
14. PhpInfo 1.1
15. Ignore user 1.3
16. vMoveTopic Notify by PM 0.90
17. Googlebot & Spiders Mod 2.0.3
18. EmailFlash 2.0
19. Expand Pages Mod 1.0
20. Enhanced Password Reminder 1.0
21. Who Voted What? 1.1.2
22. Unsend Private Messages 1.1.1
23. Color Bar 2.0
24. Display Number of Attachments 0.4.1
25. Media Center 1.0
26. Unread by category 1.0
27. Reason For Editing Mod 1.14
28. Simple_Mood 1.0
29. SMF Store 1.1.3.1
30. Rename Topic 1.0.2
31. Enhanced Forum Statistics 1.0   

[kaajee]

Nice mod!

I added Dutch language as well, working just fine at my forum.....
Here it can be downloaded [nofollow]......

[Rudolf]

Thanks. I added to the main package.

[Skipdawg]

This is great! Thanks 

[ShadowStriker]

How do you administrate this?

[babjusi]

Rudolf explained that a coupla posts above

It is the forum statistics center([More stats]), but enhanced. There's no need to enable anything.

[dcmouser]

really nice idea -- thumbs up!