Simple Machines Community Forum

Link to Mod (http://custom.simplemachines.org/mods/index.php?mod=844)

*****************************************************
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:
(http://www.simplemods.org/files/screens/simplemods/efs/screen01.png)

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

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.

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

It is the forum statistics center([More stats] (http://www.simplemachines.org/community/index.php?action=stats)), but enhanced. There's no need to enable anything.

Thanks for your explanation rudolf

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.

Entered number 2 for "Last 2 weeks"

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

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.

Quote from: chep on June 21, 2007, 11:29:32 PM
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?

Quote from: topiQ on June 22, 2007, 08:21:54 AM
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.

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


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
//-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


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


Think it has anything to do with recycle bin boards?

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

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   

Nice mod!

I added Dutch language as well, working just fine at my forum.....
Here it can be downloaded (http://www.xs4all.nl/~johonl/kj/dump/Enhanced_Forum_Statistics-1.0-nl.zip)......

Thanks. I added to the main package.

This is great! Thanks  8) ;)

How do you administrate this?

Rudolf explained that a coupla posts above

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

really nice idea -- thumbs up!

I just updated from an older version of SMF to 1.1.3 and now we are finally geared up to use this great forum script.
I applied the Enhanced Stats Mod but I must be BLIND because I don't see where the Forum Statistics Center is located.
I will feel pretty dumb after you tell me exactly, I know...

http://www.utswanesthesia.com/forum

Thanks!

In that page look at the "Forum Stats" page. There isa link called [More stats] (http://www.utswanesthesia.com/forum/index.php?action=stats)

You should update your style.ccs in the classic theme.
Add this at the end of the file

/* //-Enhanced Forum Statistics MOD- Start */
.statform1
{
width: 85%;
margin: 0 auto;
text-align: center;
}
/* //-Enhanced Forum Statistics MOD- End */

Told you I would feel dumb.
FANTASTIC MOD!!!

I'm looking for a statistics mod that would show numbers of users/user activity at certain time ranges.  Could this one be modified for that?

It does exactly this.

I am getting parse errors on sources, themes and languages when I try to install the package on 1.1.3, the only other mod I have is the visual warning mod.

Make sure there is a temp folder (with write access) in the Packages folder before trying to install the mod.

AWESOME!! thanks so much! Is the temp folder required for a lot of mods?

Install ran fine and all tests were successful, but no changes took effect, I checked the files that should have been changed and no changes were effected

It is the configuration of your host, that stops the script to create it.
There is a mod that prevents SMF from removing the temp directory: No temp directory removal (http://custom.simplemachines.org/mods/index.php?mod=724) which you might find it crucial for your site.
Install the mod. Create the temp directory and try to install this mod again.

thanks for the advice. I will let you know in a few hours how it went.

anyone using this with Diber MC theme? I'm just seeing the normal stats aftger installation...

i installed this (and also the enhanced user stats) but nothing changes. no matter what time period i select, it still shows the normal stats as though i hadn't selected any time frame at all.... with both mods.

great mod !! Thanks..  :)
but i have little psoblem  :(

see picture

can this work or integrate with other stats other than the basic ones?

i mean i have referral and invite mod so i also have the stats for them in the stats center so if i use this thread then will i be able to use it in conjunction with the other 2 mods i just mentioned?

if not is it possible to customize it so that it could? how?

Hi Rudolf,
can your mod display the most  traffic per IP address per
day ?

I really need to catch some abusers, who make too much traffic
on my forum and until now I did not find any
online stats script that shows from which
IP address the most traffic per day came...

Then I could block these IP addresses via the
bot-trap.de
script.

Many thanks.

Regards, Stefan.

P.S: Does it store the information inside the database ?
So how many queries and updates does it do to the database per hour ?
As I am limited to 100.000 accesses to the database per hour,
I don´t want a Mod that adds too many database calls, so this will
shut otherwise down my forum, cause my hoster is limiting this...
Many thanks.

i  have installed but not showing in index page

plz help me

Hi, when are you going to make it work for 1.1.4 ?

I installed this mod on a test forum for 1.1.4 and it seems to work very well.  Really nice.

I have not yet looked at the code, but are you able to change the number of "Top Poster" or other things with a "Top number" kind of category.....


Put another way, how could you change "Top 10 posters" for a period to "Top 27 posters" for a period?  Is that something to change in the mod or in the default SMF installation?

Thanks :)

Hey there.
I installed this mod and received no errors. But when i acess the statistics page i get this error in a blank page:
Parse error: syntax error, unexpected $end in /public_html/Sources/Stats.php on line 628

Help?

For some sad reason, my stats.php file has an unexpected end, since i installed this mod. Now i can't acess my forum's statistics.
Where can i find the original stats.php file?

Btw, i attached the stats.php if someone wants to take a look...


EDIT: I already managed to get the original files...

I think the upload went wrong and truncated the file... reinstalled and everything is ok.  :P


Portuguese and brazilian translations:

<file name="$themedir/languages/Stats.portuguese.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
//-Enhanced Forum Statistics MOD- Start
$txt['enh_stats_title'] = 'Seleccionar per&iacute;odo para ver as estat&iacute;sticas';
$txt['period_title'] = 'Seleccionar o per&iacute;odo onde quer ver as estat&iacute;sticas parciais';
$txt['last'] = '&Uacute;ltimo';
$txt['first'] = 'Primeiro';
$txt['period_0'] = 'Hora(s)';
$txt['period_1'] = 'Dia(s)';
$txt['period_2'] = 'Semana(s)';
$txt['period_3'] = 'M&ecirc;s(es)';
$txt['period_4'] = 'Ano(s)';
$txt['update'] = 'Actualizar';
$txt['number_descr'] = '<em>Usar <strong>0</strong> para ver todos</em>';
$txt['from'] = 'desde';
$txt['to'] = 'at&eacute;';
$txt[564] = 'M&ecirc;s (MM)';
$txt[565] = 'Dia (DD)';
$txt[566] = 'Ano (YYYY)';
//-Enhanced Forum Statistics MOD- End
]]></add>
</operation>
</file>

<file name="$themedir/languages/Stats.brazilian.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
//-Enhanced Forum Statistics MOD- Start
$txt['enh_stats_title'] = 'Seleccionar per&iacute;odo para ver as estat&iacute;sticas';
$txt['period_title'] = 'Seleccionar o per&iacute;odo onde quer ver as estat&iacute;sticas parciais';
$txt['last'] = '&Uacute;ltimo';
$txt['first'] = 'Primeiro';
$txt['period_0'] = 'Hora(s)';
$txt['period_1'] = 'Dia(s)';
$txt['period_2'] = 'Semana(s)';
$txt['period_3'] = 'M&ecirc;s(es)';
$txt['period_4'] = 'Ano(s)';
$txt['update'] = 'Actualizar';
$txt['number_descr'] = '<em>Usar <strong>0</strong> para ver todos</em>';
$txt['from'] = 'desde';
$txt['to'] = 'at&eacute;';
$txt[564] = 'M&ecirc;s (MM)';
$txt[565] = 'Dia (DD)';
$txt[566] = 'Ano (YYYY)';
//-Enhanced Forum Statistics MOD- End
]]></add>
</operation>
</file>

I just upgraded my test server to 1.1.6 and installed this mod.. it says it all installed properly, i have no errors on either my server or the forum error log and yet nothing has changed on my stats page... am I a muppet?

I'm getting this error :

Database error: Column 'ID_TOPIC' in field list is ambiguous
File: /www/htdocs/hulpvera/forum/Sources/Stats.php
Line: 492

// Are you on a larger forum?  If so, let's try to limit the number of topics we search through.
if ($modSettings['totalMessages'] > 100000)
{
//-Enhanced Forum Statistics MOD- Start
if ($restrict_date)
$request = db_query("
SELECT ID_TOPIC
FROM {$db_prefix}topics as t
LEFT JOIN {$db_prefix}messages as msg ON (msg.ID_MSG = t.ID_FIRST_MSG)
WHERE numReplies != 0 AND posterTime >= $start_date AND posterTime <= $end_date
ORDER BY numReplies DESC
[b] LIMIT 100", __FILE__, __LINE__);
[/b] else
//-Enhanced Forum Statistics MOD- End
$request = db_query("
SELECT ID_TOPIC
FROM {$db_prefix}topics
WHERE numReplies != 0
ORDER BY numReplies DESC
LIMIT 100", __FILE__, __LINE__);
$topic_ids = array();
while ($row = mysql_fetch_assoc($request))
$topic_ids[] = $row['ID_TOPIC'];
mysql_free_result($request);
}
else
$topic_ids = array();

The bold line is 492.

Replace

SELECT ID_TOPIC
with

SELECT t.ID_TOPIC

is there a 2.0 rc 5 version of this downloadable or maybe someone that has it can send it to me or something?

Quote from: Rudolf on February 18, 2011, 07:46:22 PM
Replace

Code Select Expand


SELECT ID_TOPIC
with

Code Select Expand


SELECT t.ID_TOPIC

Thanks! Is fixed now.

Good Morning Rudolf,

I am trying to install the "Enhanced forum Statistics" for a friend, but I am receiving errors and receiving the following message:  Error in Package Installation

"Error in Package Installation - At least one error was encountered during a test installation of this package. It is strongly recommended that you do not continue with installation unless you know what you are doing, and have made a backup very recently. This error may be caused by a conflict between the package you're trying to install and another package you have already installed, an error in the package, a package which requires another package that you don't have installed yet, or a package designed for another version of SMF."

She is using 2.0.2

Your suggestions would be much appreciated.

Thank you for your time.

Letting us know there was an error is not enough to go on.

We need to know what the error actually states.

Have you checked your error log?