Snitz Forums 2000 - Original Date Posted (Quick View)

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/Code)

Original Date Posted (Quick View)

New Topic

Topic Locked

Printer Friendly

Author

Topic

Ryan
Average Member

USA
858 Posts

Posted - 22 January 2004 : 20:36:18

Original Date Posted (Quick View)

This MOD adds the date the topic was posted to forum.asp. A picture of where it is added appears below:

There are a total of 5 lines to change to get this addition to your forum. Please follow the steps below.

Step 1.
Open forum.asp

Step 2.
Find this line:

strSql ="SELECT T.T_STATUS, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_VIEW_COUNT, T.T_SUBJECT, T.T_MESSAGE, "

Change it to:

strSql ="SELECT T.T_STATUS, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_VIEW_COUNT, T.T_SUBJECT, T.T_MESSAGE, T.T_DATE, "

Step 3.
Find this line:

		"                <td align=""center"" bgcolor=""" & strHeadCellColor & """><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Author</font></b></td>" & vbNewLine & _

Replace that with:

		"                <td align=""center"" bgcolor=""" & strHeadCellColor & """><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Author / Date</font></b></td>" & vbNewLine & _

NOTE: This step is here because you will be adding the date to the Author column. It will look like this:

Step 4.
Find this line:

	tT_MESSAGE = 6

After that add:

	tT_DATE = 7

NOTE: You will need to make sure that the numbers that follow this addition continue in an increasing order. 6,7,8,9, etc... If you have never modified this area of code before it should now look like this:

	tT_STATUS = 0
	tCAT_ID = 1
	tFORUM_ID = 2
	tTOPIC_ID = 3
	tT_VIEW_COUNT = 4
	tT_SUBJECT = 5
	tT_MESSAGE = 6
	tT_DATE = 7
	tT_AUTHOR = 8
	tT_STICKY = 9
	tT_REPLIES = 10
	tT_UREPLIES = 11
	tT_LAST_POST = 12
	tT_LAST_POST_AUTHOR = 13
	tT_LAST_POST_REPLY_ID = 14
	tM_NAME = 15
	tLAST_POST_AUTHOR_NAME = 16

Step 5.
Find this line:

		Topic_Author = arrTopicData(tT_AUTHOR, iTopic)

After that add:

		Topic_Date = arrTopicData(tT_DATE, iTopic)

Step 6.
Find this line:

				"                <td bgcolor=""" & strForumCellColor & """ valign=""middle"" align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """><span class=""spnMessageText"">" & profileLink(chkString(Topic_MName,"display"),Topic_Author) & "</span></font></td>" & vbNewLine & _

Replace that line with this:

				"                <td bgcolor=""" & strForumCellColor & """ valign=""middle"" align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """><span class=""spnMessageText"">By: " & profileLink(chkString(Topic_MName,"display"),Topic_Author) & " </font><br /><font size=""" & strFooterFontSize & """>on: <b>" & ChkDate(Topic_Date, "</b><br />at:",true) & "</font></span></td>" & vbNewLine & _

NOTE: This above line of code has been modified to look best in my forum. In different colors are parts of the code that can be modified to fit your forum best. You can also just leave it as it is.
 - Added to end the font size.
 - Added to break the line between the Author and Date.
 and - Added to make the Date smaller than the Author.
 and - Added to make date bold while leaving time regular so as to make the same as in Last Post.
 - Added to make sure line is broken between date and time.
at: - Added so that when you read it you say:
By: (Author)
On: (Date)
At: (Time)

I hope you enjoy this MOD. Please let me know of any suggestions or bugs. Thanks!

The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help

Ryan
Average Member

USA
858 Posts

Posted - 22 January 2004 : 20:38:51

The reason I made this MOD is so that from outside the topic I can tell what date the topic was posted on. I have many reason for this but one is when a new member is welcomed sometimes two users will welcome the same new member within seconds of each other. I can quickly tell who posted first and delete the other.

The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help

Etymon
Advanced Member

United States
2385 Posts

Posted - 23 January 2004 : 00:51:30

Hi Ryan,

Thank you for the MOD!

Just a suggestion ...

On the Author/Date field, you could also just call it First Post as this is what it actually is. Then your columns would have a First Post and a Last Post.

Also, on the Replies and the Read fields ...

Since the code for the Read field is actually "T_VIEW_COUNT" (Replies is "T_REPLIES"), it seems that Views would make more sense. I don't think I actually "Read" the majority of the topics I flip through. I really just scan most of them for something particular.

Topic | First Post | Replies | Views | Last Post

I know we all process things differently. Just throwing you a thought or two.

Etymon

Edited by - Etymon on 23 January 2004 00:58:32

Ryan
Average Member

USA
858 Posts

Posted - 23 January 2004 : 13:31:53

Thanks for the suggestion.

You kinda caught me on the Read and Views because I wasnt sure what I had done to change that because that is how the base code is. I see what you are talking about now though.

The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.26 seconds.