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
Originally posted by Jagoop 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
Originally posted by Jagoop 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.?



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net