Web Wiz Forums Modifications - Changing "Visitors of Today" time base ??

Print Page | Close Window

Changing "Visitors of Today" time base ??

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=26952
Printed Date: 29 March 2026 at 5:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Changing "Visitors of Today" time base ??

Posted By: Northwind
Subject: Changing "Visitors of Today" time base ??
Date Posted: 06 February 2009 at 10:36pm

Hi all,
I have WWF version 8.0 RC1.1.

In the main page, there is "visitors of today" section. But the count goes zero at 00:00 am. So i need a code that provide "visitors of last 24 hours" or "visitors of last 2 days" etc.

Thanks in advance.
I think the related codes are as follows:

Dim Num
Num = 0
Dim Visiters_of_Members_Today
Dim LngMmeber_Vistor_ID
Dim GroupID_type

If strDatabaseType = "SQLServer" Then
strSQL = "SELECT tblAuthor.Username, tblAuthor.Author_ID, tblAuthor.Group_ID "
strSQL = strSQL & "FROM tblAuthor "
strSQL = strSQL & "where day(tblAuthor.Last_visit) = day(getdate()) and month(tblAuthor.Last_visit) = month(getdate()) and year(tblAuthor.Last_visit) = year(getdate()) "
strSQL = strSQL & "ORDER BY tblAuthor.Last_visit DESC;"
Else
strSQL = "SELECT tblAuthor.Username, tblAuthor.Author_ID, tblAuthor.Group_ID "
strSQL = strSQL & "FROM tblAuthor "
strSQL = strSQL & "where day(tblAuthor.Last_visit) = day(Date()) and month(tblAuthor.Last_visit) = month(Date()) and year(tblAuthor.Last_visit) = year(Date())"
strSQL = strSQL & "ORDER BY tblAuthor.Last_visit DESC;"
End If

'Query the database
rsCommon.Open strSQL, adoCon

do while NOT rsCommon.EOF
Num = Num + 1
Visiters_of_Members_Today = rsCommon("Username")
LngMmeber_Vistor_ID = rsCommon("Author_ID")
GroupID_type = rsCommon("Group_ID")

Replies:

Posted By: msnahm
Date Posted: 28 February 2009 at 10:36am

How can I enable the "Visitor of today" in Ver. 9.54 Free Edition?

Posted By: 123Simples
Date Posted: 28 February 2009 at 3:29pm

Try this modification here - http://www.s2h.co.uk/wwf/mods/who-visited-today/" rel="nofollow - Who Visited Today

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