Enhanced User Statistics

[Rudolf]

Link to Mod

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

Screenshot
 

[KGIII]

Much thanks. Installed on a live forum just a few minutes ago.

[Pranav]

Thanks a lot man..installed 2 mins. ago.

[kamili34]

Mod installed correct but when I want search in statistic I  got sth

Code Select Expand

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND m.posterTime <= 1173534646)' at line 2
Plik: /home/xxxxx/xxx/xxxxx_html/forum/Sources/Profile.php
Linia: 1734

[Rudolf]

Can you be a bit more specific? What are you searching? What values you use?
Any errors in the forum error log?

[kamili34]

Can you be a bit more specific?

Yes of course

What are you searching?

I went to user panel statistic and tick Last 1 day and upload and after this I got error

Any errors in the forum error log?

In error log errors are the same as above in my post..

[eminent]

hey mate,

I was wondering if it can keep track of the days that the user have signed on??

Mainly this may not be the mod, but im searching for something that can keep track of all the users that sign on for that day, everyday..

for example:

July 12th, 2007
User1(time), User2(time), etc..

would this mod be able to do it? or can you point me to that direction of mod? thanks..

[Rudolf]

There is not such mod, as far as I know. It's pretty easy to write this, so make a request in the Mod requests board.
Or.
You can order the member list based on date and see for each day who signed up.

[eminent]

thanks, ill go to the mod request.. =]

[rowedf]

When I put in the criteria the stats don't change.  The other mod works fine for overall forum stats but this ones not doing anything.

[permutedpress]

When I put in the criteria the stats don't change.

Yep, I'm having the same problem.  I'm using SMF 1.1.3.

[LadyC]

i'm also having that problem, both with this mod and the enhanced forum statistics.... nothing changes when i select a date range.

[kamili34]

Are you change yours mysql from smf 1.1.2 to 1.1.3 ?

[LadyC]

not sure i understand your question. i did upgrade the forum to 1.1.3, and i'm assuming that took care of the database. wouldn't that be done automatically? i wasn't aware that we had to manually altar anything in mysql.

[Rudolf]

You don't have to change anything in the database, and the mod doesn't changes either.
Can you check the error log for errors and maybe give a link to your forum so I can see what's happening?

[kamili34]

I mean If your MySQL server version is 1.1.2 it will not work and you have change to 1.1.3. 

[LadyC]

mysql version is 4.1.22-standard, according to the info in my cpanel.....

[tsmalmbe]

I think I've succesfully installed this beast. Nothing changes on the statisticts-page though (I expect the same kind of change as with the enhanced forum stats-mod).

[angelsluver]

I think I've succesfully installed this beast. Nothing changes on the statisticts-page though (I expect the same kind of change as with the enhanced forum stats-mod).

That's kinda what im looking for too. but this mod shows up on general statistics in user profile.

Wouldn't it be great if it shows up in Forum statistics page? So that it can track the whole forum when you enter specific period of time. not unlike you have to go to each members profile to see their post on a certain period of time.

[dxyy]

I get the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND m.posterTime <= 1195534800)' at line 2
File: /home/daxueyin/public_html/finalforumtest/Sources/Profile.php
Line: 1877

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

I have no idea how to update my database, so any help with that would be greatly appreciated.