Quick-n-dirty little tweak, folks:
I wanted a way to see all the registered members that stopped by since the last time I visited my forums.
Here's what I came up with (and please note that this code is not plug-and-play. You need to know a bit about how this all works. I'll come up with a standalone version tomorrow after I get some sleep):
if IsEmpty(Session(strCookieURL & "last_here_date")) then
Session(strCookieURL & "last_here_date") = ReadLastHereDate(strDBNTUserName)
end if
thisSQL = "SELECT M_NAME FROM FORUM_MEMBERS WHERE M_LASTHEREDATE > '" & session(strCookieURL & "last_here_date") & "' ORDER BY M_LASTHEREDATE"
set rsPast = my_Conn.execute(thisSQL)
while not rsPast.eof
response.write rsPast("M_NAME") & "<br>" & vbCrLf
rsPast.moveNext
wend
set rsPast = nothing
Just pop that code in wherever you want to display it: I've got mine buried somewhere within my inc_top.asp file.
This produces a simple list of everyone who's been to your forum since your last visit, much like this:
member1
member2
member3
etc....
Enjoy.
Topic Locked
Posted - 04 January 2002 : 01:25:12
