vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   DC Activity Statistics (https://vborg.vbsupport.ru/showthread.php?t=93857)

Dean C 08-07-2005 10:00 PM

DC Activity Statistics
 
[DC Activity Statistics]

Information
  • [high]vBulletin Version:[/high] 3.5.x
  • [high]Author:[/high] Dean Clatworthy
  • [high]Copyright:[/high] 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.
  • [high]Donations:[/high] 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.
  • [high]Credits:[/high] 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/attachmen...chmentid=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 08-08-2005 12:57 PM

Any screenshots?

Wordplay 08-08-2005 01:12 PM

yeah lets see something.

Dean C 08-08-2005 01:35 PM

'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 08-08-2005 02:51 PM

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

Boofo 08-08-2005 04:00 PM

Here's a screenshot.

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

Quote:

Uncached templates: ACTIVITY_ybits
(You owe me, buddy! ;))

Dean C 08-08-2005 04:24 PM

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

Boofo 08-08-2005 04:25 PM

What do I need to replace? Any templates?

Dean C 08-08-2005 04:26 PM

Reupload activity.php :) That's all sorry

Boofo 08-08-2005 04:30 PM

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

Dean C 08-08-2005 04:31 PM

Fixed lol. My bad.

Boofo 08-08-2005 04:33 PM

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

Quote:

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 08-08-2005 04:49 PM

Ok *crosses fingers* try again ;)

Boofo 08-08-2005 04:57 PM

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
























It works! Great save! ;)

Want a new pic?

Boofo 08-08-2005 04:59 PM

Here you go, sir. ;)

Dean C 08-08-2005 05:04 PM

Fabolous :D Thanks for helping test Bob.

Boofo 08-08-2005 05:07 PM

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

Dean C 08-08-2005 05:16 PM

Omg, who edited my first post ;)

Boofo 08-08-2005 05:17 PM

Special? Now I'm pickled tink. ;)

Boofo 08-08-2005 05:20 PM

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 08-10-2005 01:42 PM

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

Quote:

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 08-10-2005 02:41 PM

*looks into it*

Dean C 08-10-2005 02:48 PM

Fixed and updated Bob :) Stupid typos...

Boofo 08-10-2005 04:10 PM

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 08-10-2005 04:13 PM

Maybe when I have some more time ;)

Boofo 08-10-2005 04:55 PM

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

sheikfreik 01-06-2006 11:59 AM

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 01-14-2006 07:20 PM

Quote:

Originally Posted by 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

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

PHP Code:

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

to this:

PHP Code:

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

PHP Code:

    // 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 04-13-2006 01:25 PM

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 05-02-2006 12:44 PM

question: does it have reputation stats too?

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

my3shadows 05-31-2006 10:38 PM

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 05-02-2009 06:58 AM

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!


All times are GMT. The time now is 04:49 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02581 seconds
  • Memory Usage 1,783KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (32)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete