Note: You must be registered in order to post a reply. To register, click here. Registration is FREE! Before posting, make sure you have read this topic!
T O P I C R E V I E W
Lon2
Posted - 18 March 2009 : 10:15:20 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?
6 L A T E S T R E P L I E S (Newest First)
Carefree
Posted - 19 March 2009 : 15:19:05 You're welcome.
Lon2
Posted - 19 March 2009 : 13:28:51 Oh man, that was perfect Carefree, thanks a bunch!!
Guess you can move this topic to the mods forum, Huwr.
Carefree
Posted - 18 March 2009 : 14:55:14 To show both topics/replies, look in "pop_profile.asp":
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"
HuwR
Posted - 18 March 2009 : 13:22:22
quote: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.
Lon2
Posted - 18 March 2009 : 12:36: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?
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?
bobby131313
Posted - 18 March 2009 : 10:53:45 Recent topics are topics started in the last 30 days.