Scotty32 wrote:
I have updated the Who Visited Today mod so that it is compatible with Web Wiz Forum version 9.63.
For more information and to download visit the Who Visited Today page.
|
Thanks Scotty - Great mod

I needed to make a slight change to it due to the the server for my forum being located in a different country to myself and a lot of my users - as such returning the list of users who have visited based on the server date didn't make sense to users.
I changed it to reflect users who have visited in the last 24 hours which now makes sense regardless of where the server and users are located.
Here's the modified SqlString I used in case it's of use to anyone else (not a problem if your server is located in the same country, although even then different time zones could make the results innacurate)
The change I have made is specific to MS SQLserver, a slightly different query would be required for MySQL as it does not support the hour parameter in the DateDiff function
strSQL = "SELECT " & strDbTable & "Author.Username, " & strDbTable & "Author.Author_ID FROM " & strDbTable & "Author" & strDBNoLock & " WHERE DATEDIFF(hh, Last_Visit , " & CHR(39) & now() & CHR(39) & ") <25" & " ORDER BY " & strDbTable & "Author.Last_visit DESC;"
|
To reflect the above change i also changed the following value in language_s2h.asp
Const strTxtS2HWVTSummary = "members have visited the forum within the last 24 hours."
|
Edited by TonyM - 12 December 2009 at 2:11am