Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Number Of Topic Posts

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!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
leatherlips Posted - 17 March 2009 : 14:34:40
I would like to add a new stat in the Authors column on the topic.asp page. Currently it says something like "123 Posts". I'd also like to add "Topics Started: 10"

The Topics Started would list how many topics have been started by that member. I looked at the database but could not find anything that kept track of that. Is there a way to add it?
7   L A T E S T    R E P L I E S    (Newest First)
texanman Posted - 19 March 2009 : 17:26:43
I will update the counts in the database (to remove deteled topics/posts) and apply the changes again and see what happens.
Carefree Posted - 19 March 2009 : 15:22:07
This method cannot count previous (deleted) posts. It only shows posts which still exist. Thus, if you want to include the difference between the standard value and the current value, you'll have to decide whether you want those numbers reflected as posts, topics, or split to a particular degree.
Classicmotorcycling Posted - 19 March 2009 : 14:16:03
That could be because someone could of deleted a post or a few from the user(s).
quote:
Originally posted by texanman

It works but doesn't give the correct total. In other words, # of topics plus the # of posts do no add up to the number of posts before the change.
texanman Posted - 18 March 2009 : 10:14:46
It works but doesn't give the correct total. In other words, # of topics plus the # of posts do no add up to the number of posts before the change.
Carefree Posted - 18 March 2009 : 05:44:37
You'll have to use two routines in "topic.asp", one for original posts and one for replies. 


For topics, look for the following line (appx 770):
	Response.Write	"                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Member_Posts & " Posts</small></font></p></td>" & vbNewLine & _

Change it to say:
	strSql = "SELECT COUNT(T_AUTHOR) AS CNT FROM " & strTablePrefix & "TOPICS WHERE T_AUTHOR="&TMEMBER_ID
	set rsCount = Server.CreateObject("ADODB.Recordset")
	rsCount.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
	intTotalPosts=rsCount("CNT")
	rsCount.close
	set rsCount=Nothing
	strSql = "SELECT COUNT(R_AUTHOR) AS CNT FROM " & strTablePrefix & "REPLY WHERE R_AUTHOR="&TMEMBER_ID
	set rsCount = Server.CreateObject("ADODB.Recordset")
	rsCount.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
	intTotalReplies=rsCount("CNT")
	rsCount.close
	set rsCount=Nothing
	Response.Write	"                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & IntTotalPosts & " Posts<br>" & IntTotalReplies & " Replies</small></font></p></td>" & vbNewLine & _

For replies, look for the following line (appx 565):
			Response.Write	"                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Reply_MemberPosts & " Posts</small></font></p></td>" & vbNewLine & _

Change it to say:
			strSql = "SELECT COUNT(T_AUTHOR) AS CNT FROM " & strTablePrefix & "TOPICS WHERE T_AUTHOR="&Reply_MemberID
			set rsCount = Server.CreateObject("ADODB.Recordset")
			rsCount.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
			intTotalPosts=rsCount("CNT")
			rsCount.close
			set rsCount=Nothing
			strSql = "SELECT COUNT(R_AUTHOR) AS CNT FROM " & strTablePrefix & "REPLY WHERE R_AUTHOR="&Reply_MemberID
			set rsCount = Server.CreateObject("ADODB.Recordset")
			rsCount.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
			intTotalReplies=rsCount("CNT")
			rsCount.close
			set rsCount=Nothing
			Response.Write	"                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & IntTotalPosts & " Posts<br>" & IntTotalReplies & " Replies</small></font></p></td>" & vbNewLine & _


Note: If you're using the active members' mod, the closing /td will not be present on the Response Write lines.
HuwR Posted - 17 March 2009 : 16:06:24
ther is nothing that tracks that, you will have to write a query that counts the number of topics where the user is the TopicAuthor
leatherlips Posted - 17 March 2009 : 16:01:42
I think I may have figured it out. I added this:

Response.Write "                <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>Topics Started: " & Topic_Author & "</small></font><br />" & vbNewLine

I think it is working properly.

Edit: Oops. Nevermind. All that does is show the members id number.

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000 Version 3.4.07