The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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?
Posted
Recent topics are topics started in the last 30 days.
Posted
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?
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?
Posted
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.
Posted
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"
Posted
Oh man, that was perfect Carefree, thanks a bunch!! [^]
Guess you can move this topic to the mods forum, Huwr.
Guess you can move this topic to the mods forum, Huwr.