Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Recent Topics count in member profile
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Lon2
Junior Member

USA
151 Posts

Posted - 18 March 2009 :  10:15:20  Show Profile  Reply with Quote
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?

bobby131313
Senior Member

USA
1163 Posts

Posted - 18 March 2009 :  10:53:45  Show Profile  Visit bobby131313's Homepage  Reply with Quote
Recent topics are topics started in the last 30 days.

Switch the order of your title tags
Go to Top of Page

Lon2
Junior Member

USA
151 Posts

Posted - 18 March 2009 :  12:36:22  Show Profile  Reply with 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?

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?
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 18 March 2009 :  13:22:22  Show Profile  Visit HuwR's Homepage  Reply with Quote
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.
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 18 March 2009 :  14:55:14  Show Profile  Reply with Quote
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"
Go to Top of Page

Lon2
Junior Member

USA
151 Posts

Posted - 19 March 2009 :  13:28:51  Show Profile  Reply with Quote
Oh man, that was perfect Carefree, thanks a bunch!!

Guess you can move this topic to the mods forum, Huwr.

Edited by - Lon2 on 19 March 2009 13:34:15
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 19 March 2009 :  15:19:05  Show Profile  Reply with Quote
You're welcome.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07