Web Wiz Forums Modifications - Complete statistics

Print Page | Close Window

Complete statistics

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28870
Printed Date: 28 March 2026 at 10:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Complete statistics

Posted By: yandr
Subject: Complete statistics
Date Posted: 24 September 2010 at 2:36pm

Has anyone implemented a screen with full statistics?

I am looking for something that will include

No of messages
No of topics
No of users
messages/day
topics/day
new users/day
messages/topic
popular topics by views
popular topics by replies
a break down of the number of messages and views each month
etc

You get the picture. Something complete.

Replies:

Posted By: 123Simples
Date Posted: 24 September 2010 at 7:52pm

Not as far as I know - it probably is quite possible to do it as it would only be calling most of the readily accessible statistics but into a file to display in an ordered format.

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design

Posted By: Jagoop
Date Posted: 17 January 2011 at 6:47pm

I've added a simple page to our forum, that displays the following:

Number of unique users logged in and number of unique users that have posted in the last 24 hours, 2/7/14/30/90 days.
Users with the hights number of PMs in their mailbox
Top 10 users with the most posts in the last 30 days
General forum activity (number of posts) divided by year/month, since first post
List of users with individual priviledges.

Let me know if the source code for this page is of any interest to anyone.

Posted By: dld-nordic
Date Posted: 21 January 2011 at 10:20am

That would be nice to incorporate in the admin page on the forum.

Posted By: yandr
Date Posted: 25 January 2011 at 3:10pm

Jagoop wrote:

Let me know if the source code for this page is of any interest to anyone.

let's have it

Posted By: Jagoop
Date Posted: 27 January 2011 at 4:14pm

The source is available here: http://www.bindslet.net/stats_english.txt
Rename the file from .txt to .asp before using it.

The source has been translated from Danish to English very quickly, so please excuse the low quality english

Posted By: yandr
Date Posted: 30 January 2011 at 6:58am

that's very nice, very close to what I was looking for and I can take it from there.

Thank you!

Posted By: Jagoop
Date Posted: 31 January 2011 at 6:54pm

Ups ... I forgot that one of the statistics displayed is dependent on this view (whihc need to be created on the SQL Server):

CREATE VIEW [dbo].[rettigheder] AS
    SELECT (SELECT username
            FROM tblAuthor
            WHERE tblAuthor.Author_ID = tblPermissions.Author_ID
            ) AS UserName,
            (SELECT forum_name
            FROM tblForum
            WHERE tblForum.Forum_ID = tblPermissions.Forum_ID
            ) AS ForumName,
            *
    FROM dbo.tblPermissions
    WHERE Author_ID > 0

Posted By: madpakke
Date Posted: 11 February 2011 at 12:05pm

Jagoop: I been trying out your code, but then i am logged in as admin, and trying to entering the simple page with all the code, ill get this "error":Sorry, you do not have access here!

Nu er jeg selv dansker, så det tyder som om den ikke acceptere mit login som admin på den stats side, eller gør jeg måske noget forkert her.?

Posted By: Scotty32
Date Posted: 11 February 2011 at 1:10pm

Jagoop wrote:

The source is available here: http://www.bindslet.net/stats_english.txt
Rename the file from .txt to .asp before using it.

The source has been translated from Danish to English very quickly, so please excuse the low quality english

Based on the file linked above, the code is wrong (based on the Default forum and the comments)

' ### START ### Code added by JBI to remove statistics for guests
If intGroupID = 8 Then
' ### END ### Code added by JBI to remove statistics for guests

To block only guests it should be

if intGroupID <> 2 then

To allow only Administrators it should be

if intGroupID = 1 then

This my solve your problem madpakke

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: madpakke
Date Posted: 11 February 2011 at 10:48pm

Thanks fore the feedback Scotty,

Then i change it to "1", it says that the page canot be found, and then i change it to "2" it says the same as the start.

So am woundering if its only me that have troubles with this nice looing mod.?