Recent Topics count in member profile

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/68418?pagenum=1
06 November 2025, 06:50

Topic

Lon2
Recent Topics count in member profile
18 March 2009, 10:15


I noticed Recent Topics listings in some Member's Profiles not showing recent topics. I ran update forum counts and still no change. There could be newer and older members with fewer or more topics that display correctly and then some don't. For example, right now, I see a member that has posted 4 times in the last few days and their profile shows no Recent Topics. The member right under them (older) has posted in one topic and their Recent Topics shows the one topic. Any ideas on what would be causing this?

 

Replies ...

bobby131313
18 March 2009, 10:53


Recent topics are topics started in the last 30 days.
Lon2
18 March 2009, 12:36


So you're saying if a new member posts a reply to a topic that is older than 30 days, it will not show in their Recent Topics list even if the post was within 30 days?
Wouldn't it make more sense to have Recent Posts in a member's profile? And if there are multiple posts in one topic, list just the topic?
HuwR
18 March 2009, 13:22


So you're saying if a new member posts a reply to a topic that is older than 30 days, it will not show in their Recent Topics list even if the post was within 30 days?
yes, that is correct, it is showin 'recent topics' not recent posts.
Carefree
18 March 2009, 14:55


To show both topics/replies, look in "pop_profile.asp":
Code:
Find these lines (appx 372-387):

					'## Forum_SQL - Find all records for the member
					strsql = "SELECT F.FORUM_ID"
					strSql = strSql & ", T.TOPIC_ID"
					strSql = strSql & ", T.T_SUBJECT"
					strSql = strSql & ", T.T_STATUS"
					strSql = strSql & ", T.T_LAST_POST"
					strSql = strSql & ", T.T_REPLIES "
					strSql = strSql & " FROM ((" & strTablePrefix & "FORUM F LEFT JOIN " & strTablePrefix & "TOPICS T"
					strSql = strSql & " ON F.FORUM_ID = T.FORUM_ID) LEFT JOIN " & strTablePrefix & "REPLY R"
					strSql = strSql & " ON T.TOPIC_ID = R.TOPIC_ID) "
					strSql = strSql & " WHERE (T_DATE > '" & strStartDate & "') "
					strSql = strSql & " AND (T.T_AUTHOR = " & ppMember_ID
					strSql = strSql & " OR R.R_AUTHOR = " & ppMember_ID & ")"
					strSql = strSql & " AND (T_STATUS < 2 OR R_STATUS < 2)"
					strSql = strSql & " AND F.F_TYPE = 0"
					strSql = strSql & " ORDER BY T.T_LAST_POST DESC, T.TOPIC_ID DESC"

Replace them with these:

					'## Forum_SQL - Find all records for the member
					strsql = "SELECT F.FORUM_ID"
					strSql = strSql & ", T.TOPIC_ID"
					strSql = strSql & ", T.T_SUBJECT"
					strSql = strSql & ", T.T_STATUS"
					strSql = strSql & ", T.T_LAST_POST"
					strSql = strSql & ", T.T_REPLIES "
					strSql = strSql & " FROM ((" & strTablePrefix & "FORUM F LEFT JOIN " & strTablePrefix & "TOPICS T"
					strSql = strSql & " ON F.FORUM_ID = T.FORUM_ID) LEFT JOIN " & strTablePrefix & "REPLY R"
					strSql = strSql & " ON T.TOPIC_ID = R.TOPIC_ID) "
					strSql = strSql & " WHERE (T_DATE > '" & strStartDate & "') "
					strSql = strSql & " AND (T.T_AUTHOR = " & ppMember_ID & ") "
					strSql = strSql & " OR ((R_DATE > '" & strStartDate & "') "
					strSql = strSql & " AND (R.R_AUTHOR = " & ppMember_ID & ") "
					strSql = strSql & " AND NOT ((T_DATE > '" & strStartDate & "') "
					strSql = strSql & " AND (T.T_AUTHOR = " & ppMember_ID & "))) "
					strSql = strSql & " AND (T_STATUS < 2 OR R_STATUS < 2)"
					strSql = strSql & " AND F.F_TYPE = 0"
					strSql = strSql & " ORDER BY T.T_LAST_POST DESC, T.TOPIC_ID DESC"
Lon2
19 March 2009, 13:28


Oh man, that was perfect Carefree, thanks a bunch!! [^]
Guess you can move this topic to the mods forum, Huwr.
Carefree
19 March 2009, 15:19


You're welcome.
© 2000-2021 Snitz™ Communications