Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Simple Forum Usage Statistics Details »
Simple Forum Usage Statistics
Mod Version: 1.07, by Paul M (Member) Paul M is offline
Developer Last Online: Jan 2018 I like it Show Printable Version Email this Page

This thread is in the Modification Graveyard.
vB Version: 3.5.x Rating: (1 vote - 5.00 average) Installs: 37
Released: 22 Apr 2006 Last Update: 15 May 2006 Downloads: 24
Not Supported  

This modification is no longer available or supported.

This is a little custom hack originally written for Jilly.

This adds an option to the forum tools dropdown menu to display three counts for the forum (and sub forums if you click on the link) - Number of New Posts, Number of New Threads and Number of Unique Posters - all for a preset time limit (in days). The days and usergroups allowed to use it this function are defined in the ACP.

Unzip the xml file and import it into vbulletin via the product manager, then set the options (in the vb options > forum display options). 7 Days and usergroups 5,6 & 7 are the defaults.


History:

v1.01 : First Private Release.
v1.02 : Minor changes, no update necessary.
v1.03 : Permissions added.
v1.04 : Forum Tools Link Automated.
v1.05 : First Public Release.
v1.06 : Fixed missing table prefixes on joins.
v1.07 : Fixed more table prefix errors.

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	stats1.JPG
Views:	1165
Size:	69.7 KB
ID:	46298   Click image for larger version

Name:	stats2.JPG
Views:	784
Size:	26.4 KB
ID:	46299   Click image for larger version

Name:	stats3.JPG
Views:	913
Size:	42.0 KB
ID:	46307  

Show Your Support

  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Add-On Releases Simple Style Statistics Surviver vBulletin 3.6 Add-ons 20 26 Feb 2008 17:04
Avatar Usage Statistics in AdminCP 1.0 N9ne vBulletin 2.x Full Releases 14 25 Apr 2003 03:00

Comments
  #2  
Old 22 Apr 2006, 18:12
Mr Chad's Avatar
Mr Chad Mr Chad is offline
 
Join Date: Jul 2005
Looks pretty good, Installin.
Reply With Quote
  #3  
Old 22 Apr 2006, 18:31
klaush klaush is offline
 
Join Date: Oct 2005
Mhhhh:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount
FROM vb3_post AS post
LEFT JOIN thread on post.threadid = thread.threadid
WHERE post.dateline > 1145122278 AND thread.forumid IN (32);

MySQL-Fehler : Table 'usr_web2_3.thread' doesn't exist

---

Thanks!:-)
__________________
Greetings

Klaus
Reply With Quote
  #4  
Old 22 Apr 2006, 18:51
XanTrax XanTrax is offline
 
Join Date: Aug 2005
Need to include table prefix in the code.
Reply With Quote
  #5  
Old 22 Apr 2006, 19:12
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Oops, a table prefix missing on the joins - 1.06 uploaded to fix it.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.

Last edited by Paul M; 22 Apr 2006 at 19:17.
Reply With Quote
  #6  
Old 22 Apr 2006, 19:45
topsoftware topsoftware is offline
 
Join Date: Dec 2005
hi

where is the link
Reply With Quote
  #7  
Old 22 Apr 2006, 19:54
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
As it says ;

This adds an option to the forum tools dropdown menu
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #8  
Old 22 Apr 2006, 20:12
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
Nice idea.

Are you planning on adding any other statistics to this?
Reply With Quote
  #9  
Old 22 Apr 2006, 20:12
Atakan KOC's Avatar
Atakan KOC Atakan KOC is offline
 
Join Date: Feb 2006
Real name: Atakan KO
Nice. Thanks
__________________
vBulletin 5 : http://www.atabb.com/

Last edited by Atakan KOC; 22 Apr 2006 at 20:15.
Reply With Quote
  #10  
Old 22 Apr 2006, 20:29
Ziki's Avatar
Ziki Ziki is offline
 
Join Date: Nov 2005
Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount
FROM forumziki_post AS post
LEFT JOIN forumziki_thread on post.threadid = thread.threadid
WHERE post.dateline > 1145129031 AND thread.forumid IN (2);

MySQL Error : Unknown column 'thread.forumid' in 'where clause'
Error Number : 1054
Date : Saturday, April 22nd 2006 @ 03:23:51 PM
Script : http://www.xxxxxxxxxx.com/forums/mis...forumstats&f=2
Referrer : http://www.xxxxxxx.com/forums/forumdisplay.php?f=2
IP Address : XXXXXXX
Username : ZIKI-SET
Classname : vb_database
__________________
My free mods~click here
Reply With Quote
  #11  
Old 22 Apr 2006, 20:29
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Boofo
Nice idea.

Are you planning on adding any other statistics to this?
What it has now is what was required by the original requestor, so I haven't really thought about it. What other stats were you thinking of ?
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #12  
Old 22 Apr 2006, 20:44
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by ZIKI-SET
MySQL Error : Unknown column 'thread.forumid' in 'where clause'
Error Number : 1054
Date : Saturday, April 22nd 2006 @ 03:23:51 PM
Script : http://www.xxxxxxxxxx.com/forums/mis...forumstats&f=2
Referrer : http://www.xxxxxxx.com/forums/forumdisplay.php?f=2
IP Address : XXXXXXX
Username : ZIKI-SET
Classname : vb_database
Aaaarrrggg, bloody table prefixes should be banned. :cross-eyed:

Fixed.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.

Last edited by Paul M; 22 Apr 2006 at 20:49.
Reply With Quote
  #13  
Old 22 Apr 2006, 20:50
tei727's Avatar
tei727 tei727 is offline
 
Join Date: Feb 2006
MySQL Error : Unknown table 'thread' in where clause
Error Number : 1109
Reply With Quote
  #14  
Old 22 Apr 2006, 21:05
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by tei727
MySQL Error : Unknown table 'thread' in where clause
Error Number : 1109
Posting only a small part of the error message is not much use to me, but I think that's fixed by 1.07 anyway - I can't see any stupid prefix changes I've missed now.

Note to self: I really must set-up a test forum using prefixes.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #15  
Old 22 Apr 2006, 21:09
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
Originally Posted by Paul M
What it has now is what was required by the original requestor, so I haven't really thought about it. What other stats were you thinking of ?
Last Poster, Link to last post, stuff like that. I might add some things to it that I use for my forumstatistics Cache hack. Using the datastore would be better if you have a lot of staff using it all the time. But they really shouldn't be, I would think. Scratch the datstore idea.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 13:10.

Layout Options | Width: Wide Color: