Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Complete statistics
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Complete statistics
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
yandr View Drop Down
Groupie
Groupie


Joined: 10 March 2009
Status: Offline
Points: 106 		Post Options Post Options   Thanks (0) Thanks(0)   Quote yandr Quote  Post ReplyReply Direct Link To This Post Topic: Complete statistics
    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.
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post 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.
Visit 123 Simples Web Design
Back to Top
Jagoop View Drop Down
Groupie
Groupie
Avatar

Joined: 17 August 2009
Location: Denmark
Status: Offline
Points: 49 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Jagoop Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
dld-nordic View Drop Down
Groupie
Groupie


Joined: 24 October 2008
Status: Offline
Points: 99 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dld-nordic Quote  Post ReplyReply Direct Link To This Post Posted: 21 January 2011 at 10:20am
That would be nice to incorporate in the admin page on the forum.
Back to Top
yandr View Drop Down
Groupie
Groupie


Joined: 10 March 2009
Status: Offline
Points: 106 		Post Options Post Options   Thanks (0) Thanks(0)   Quote yandr Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Jagoop View Drop Down
Groupie
Groupie
Avatar

Joined: 17 August 2009
Location: Denmark
Status: Offline
Points: 49 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Jagoop Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
yandr View Drop Down
Groupie
Groupie


Joined: 10 March 2009
Status: Offline
Points: 106 		Post Options Post Options   Thanks (0) Thanks(0)   Quote yandr Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
Jagoop View Drop Down
Groupie
Groupie
Avatar

Joined: 17 August 2009
Location: Denmark
Status: Offline
Points: 49 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Jagoop Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.