DC Activity Statistics

[Dean C]

[DC Activity Statistics]

Information
vBulletin Version: 3.5.x
Author: Dean Clatworthy (http://www.deanclatworthy.com)
Copyright: You may use this modification at your own risk. I cannot and will not be held responsible for any damage you may cause to your forums during installation or thereafter. You may not distribute this modification in whole or parts and anyone found doing so faces risk of prosecution. All my modifications are released at vBulletin.org and anyone found releasing them elsewhere also faces risk of prosecution. You may not translate this modification without my prior permission.
Donations: I release my modifications for free. If you wish to donate please contact me and I will give you my details. All donations are graciously appreciated.
Credits: Boofo - for being my special little helper :p
What does this modification do?
This modification adds a seperate page to your vBulletin with details on the posting activity of your members over months.

Installation

1/

Read the readme.txt within the zip file

Screenshots
https://vborg.vbsupport.ru/attachment.php?attachmentid=33133

Please Click Install!
If you installed this modifcation please click the install button. It'll help you keep up to date with future releases and important bugfixes, security updates.

[Dan]

Any screenshots?

[Wordplay]

yeah lets see something.

[Dean C]

'Fraid there's little point in a screenshot on my testforum. Only I post on there so it's just one row ;) Basically imagine a page with two dropdowns at the top with month and year. So you can choose the month you want to select the activity for. Then the results is a memberlist style output with username, join date and total posts for that month :)

If someone can provide me with a screenshot, I'll add it to the first post

[sabret00the]

perhaps a ++++ty screenshot with limited stats until someone who's installed provides a better one?

[Boofo]

Here's a screenshot.

Also, you have an uncached template. And the ranking it wrong.

Uncached templates: ACTIVITY_ybits

(You owe me, buddy! ;))

[Dean C]

Updated and fixed, how does it look now Bob ;)?

[Boofo]

What do I need to replace? Any templates?

[Dean C]

Reupload activity.php :) That's all sorry

[Boofo]

You need to reupload it. I got the same file. ;)

[Dean C]

Fixed lol. My bad.

[Boofo]

Well, I got the new file, but I got another present with it. It must be my birthday. ;)

Database error in vBulletin 3.5.0 Release Candidate 1:
Invalid SQL:
SELECT COUNT(p.postid) AS total
,p.userid
,u.username
,u.joindate
FROM
post AS p
LEFT JOIN
user as u
ON
u.userid = p.userid
WHERE
p.dateline > 1122854400
AND
p.dateline < 1125446400
ORDER BY
total DESC
GROUP BY
userid
LIMIT
10;
MySQL 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 'GROUP BY
userid
LIMIT
10' at line 17
Error Number : 1064
Date : Monday, August 8th 2005 @ 05:32:22 PM
Script : http://www.bearfacts2.com/boards/activity.php?$session[sessionurl]
Referrer :
IP Address :
Username : Boofo
Classname : vb_database

[Dean C]

Ok *crosses fingers* try again ;)

[Boofo]

Dean, Dean, Dean, what are we gonna do with you? Once again ...
























It works! Great save! ;)

Want a new pic?

[Boofo]

Here you go, sir. ;)

[Dean C]

Fabolous :D Thanks for helping test Bob.

[Boofo]

Since I have to have you link in the footer of this hack, do I get my name in the credits? ;)

[Dean C]

Omg, who edited my first post ;)

[Boofo]

Special? Now I'm pickled tink. ;)

[Boofo]

Oh, and you might want to put the year after the month in the header for the box, especially if they can have other years in there. ;)

[Boofo]

Dean, I'm getting the following error when I first go into this now. I just upgraded to RC 2.


This date is in the future. You cannot select it. Go back and select antoher.



I can't get into it to change it.

[Dean C]

*looks into it*

[Dean C]

Fixed and updated Bob :) Stupid typos...

[Boofo]

Your "little helper" thanks you. ;)

How about adding posts this week and posts today? You have all that room and nothing there. ;)

Hell, throw "shoe size" in there if you have the room. ;)

[Dean C]

Maybe when I have some more time ;)

[Boofo]

How did I know that was gonna be my answer? ;)

[sheikfreik]

Hey there,

just found this mod and it's exactly what I was looking for...except...is there a way to add the coding for 2003->2005 so that stats from years past can be retrieved? My members wanted to know the stats from '05 and, at the moment, the activity add-on only will show stats from the current year on

thanks in advance if you can help :)

- Joe

[baradaarab]

Hey there,

just found this mod and it's exactly what I was looking for...except...is there a way to add the coding for 2003->2005 so that stats from years past can be retrieved? My members wanted to know the stats from '05 and, at the moment, the activity add-on only will show stats from the current year on

thanks in advance if you can help :)

- Joe

I wanted the same thing, here's what I did... I edited activity.php and changed this:

// generate years dropdown
for($i = intval(vbdate('Y')); $i < intval(vbdate('Y')) + 4; $i++)
{


to this:

// generate years dropdown
for($i = intval(vbdate('Y')); $i > intval(vbdate('Y')) - 4; $i--)
{


Hope that helps :)

The only problem is that it counts down rather than up, if you want it the other way around, I think this would work:

// generate years dropdown
for($i = intval(vbdate('Y')) - 4; $i < intval(vbdate('Y')) + 4; $i++)
{

But I haven't tested it so...

MGM out

[kurtbarker]

nice mod mate...

didn't do the navbar edit though, I don't want people making useless posts just to see their name get to the top of the list... Gunna use it for admin monitoring ;)

thanks for the hack :D

[craiovaforum]

question: does it have reputation stats too?

I'm interessed in most reputation recived and most reputation spread...

[my3shadows]

I have this installed on two separate forums and it has stopped working on both sites within the last few days. Some members it shows correctly, and other's it's way off. On my stats in particular it shows that I've made more posts than I have.

The only modification that I've made to the activity.php file is upping the record limit from 10 to 40.

Any ideas?

[adriano29]

I want to make this page show Post Count only for member that visit it. How can i do it?
Anyone can help me?

Thanks!