Web Wiz Support and Community Forums : View posts since last visit MOD

View posts since last visit MOD : Well, I simplified the following...

Wed, 02 Mar 2005 22:56:29 +0000

Author: claytone19
Subject: 13967
Posted: 02 March 2005 at 10:56pm

Well,I simplified the following ASP code, so that you can integrate it intoyour site the way you want. You can add to it as much as you like. Themessage only displays to members logged into your forum and only thenif there is active topics since last visit.

Here is the code for the stored procedure.
##############################################################
CREATE PROCEDURE [dbo].[wwfSpActiveTopicsCount]
(
@AuthorID int,
@GroupID int,
@GroupPerm int,
@dblActiveFrom datetime
)
AS

SELECT Count(tblTopic.Topic_ID) as TopicCount
FROM tblCategory, tblForum, tblTopic
WHERE ((tblCategory.Cat_ID = tblForum.Cat_ID AND tblForum.Forum_ID =tblTopic.Forum_ID) AND (tblTopic.Last_entry_date > @dblActiveFrom))
AND (tblForum.[Read] <= @GroupPerm OR (tblTopic.Forum_ID IN (
    SELECT tblPermissions.Forum_ID
    FROM tblPermissions
    WHERE tblPermissions.Author_ID = @AuthorID ORtblPermissions.Group_ID = @GroupID AND tblPermissions.[Read]=1))
    )
;
##########################################################

On your home page make sure you include this file:

Then you will want to add code similer to this:
<%
' ##########################################################
If strLoggedInUsername <> "" Then
Response.write "Welcome " & strLoggedInUsername & "
IF strLoggedInUsername <> "Guest" and Session("dtmLastVisit") <> "" Then
If intGroupID = 2 Then ' GUEST
intForumGroupPermission = 1
ElseIf intGroupID = 1 Then ' ADMIN
     intForumGroupPermission = 4
Else ' EVERYONE ELSE
    intForumGroupPermission = 2
End If

   strSQL = "EXECUTE wwfSpActiveTopicsCount @dblActiveFrom ='" & Session("dtmLastVisit") & "', @AuthorID = " &lngLoggedInUserID & ", @GroupID = " & intGroupID & ",@GroupPerm = " & intForumGroupPermission
rsCommon.Open strSQL, adoCon
dim intCount
   If Not rsCommon.EOF Then
     intCount = rsCommon("TopicCount")
   End If
   rsCommon.Close

   IF intCount > 0 Then
     If intCount = 1 Then%>

There has been (<%=intCount%>) newmessage posted since you last visited<%
     else%>

There have been (<%=intCount%>) newmessages posted since you last visited<%
    End if
    End If ' Count > 0
End If
' ##########################################################
%>

View posts since last visit MOD : That is exactly what I need. Could...

Tue, 01 Mar 2005 19:32:59 +0000

Author: wistex
Subject: 13967
Posted: 01 March 2005 at 7:32pm

That is exactly what I need. Could you provide the code for the mod? Thanks.

View posts since last visit MOD : Too late, I already wrote my own...

Sat, 26 Feb 2005 22:15:55 +0000

Author: claytone19
Subject: 13967
Posted: 26 February 2005 at 10:15pm

Too late, I already wrote my own stored procedure.
Thanks though.

View posts since last visit MOD : There's a few mods around...

Sat, 26 Feb 2005 10:50:00 +0000

Author: dpyers
Subject: 13967
Posted: 26 February 2005 at 10:50am

There's a few mods around that do just that. Check the mods forum.

View posts since last visit MOD : thanks, I just realized that....

Sat, 26 Feb 2005 01:04:12 +0000

Author: claytone19
Subject: 13967
Posted: 26 February 2005 at 1:04am

thanks, I just realized that.

Now I will write code at login to check if there are any posts sincethe user logged in and if so display "there are 10 new messages sinceyou last logged in" with a link to active topics since lastvisit date.

thanks guys for the responses

View posts since last visit MOD : If you click on "Active Topics"...

Wed, 23 Feb 2005 17:52:41 +0000

Author: wistex
Subject: 13967
Posted: 23 February 2005 at 5:52pm

If you click on "Active Topics" it automatically gives you the posts since last visit. There is also a drop down box where you can specify a different time range if you so desire.

Edited by wistex - 24 February 2005 at 12:49am

View posts since last visit MOD : How is that different from active...

Wed, 23 Feb 2005 13:55:14 +0000

Author: dpyers
Subject: 13967
Posted: 23 February 2005 at 1:55pm

How is that different from active topics?

Edited by dpyers - 23 February 2005 at 4:39pm

View posts since last visit MOD : Is there a "View posts since...

Wed, 23 Feb 2005 12:56:50 +0000

Author: claytone19
Subject: 13967
Posted: 23 February 2005 at 12:56pm

Is there a "View posts since last visit" Mod for Web Wiz?
Or is there something like already that I am overlooking?

I don't want just active topics, all posts that have been posted since the last time the user logged in.

thanks