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/O Code)
 Date/time of first post in topic		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

jfitz
Junior Member

USA
345 Posts
Posted - 08 January 2003 :  15:10:21  Show Profile
I would like to include the date/time that a topic originated in the table cell with the topic title, similar to the date/time of last post that is already shown. How do I get and format that information so I can add it to the existing table data in forum.asp?
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down.
Edited by - ruirib on 08 January 2003 15:29:50

Roland
Advanced Member

Netherlands
9335 Posts
Posted - 08 January 2003 :  15:48:54  Show Profile
First create a backup of your forum.asp before you do anything else.

Here's what I did to get it working:

Edit line 237 from
strSql = strSql & "T.T_AUTHOR, T.T_STICKY, T.T_REPLIES, T.T_UREPLIES, T.T_LAST_POST, T.T_LAST_POST_AUTHOR, "


to by adding the red code
strSql = strSql & "T.T_AUTHOR, T.T_STICKY, T.T_REPLIES, T.T_UREPLIES, T.T_LAST_POST, T.T_DATE, T.T_LAST_POST_AUTHOR, "


lines 451 to 455 now look like this:
	tT_LAST_POST = 10
	tT_LAST_POST_AUTHOR = 11
	tT_LAST_POST_REPLY_ID = 12
	tM_NAME = 13
	tLAST_POST_AUTHOR_NAME = 14


Change them to this (one line added and the numbers are changed):
	tT_LAST_POST = 10
	tT_TOPIC_POST = 11
	tT_LAST_POST_AUTHOR = 12
	tT_LAST_POST_REPLY_ID = 13
	tM_NAME = 14
	tLAST_POST_AUTHOR_NAME = 15


line 473 should look like this:
		Topic_LastPost = arrTopicData(tT_LAST_POST, iTopic)


Add this below that line:
		Topic_TopicPost = arrTopicData(tT_DATE, iTopic)


Line 535 looks like this:
		Response.Write	"<span class=""spnMessageText""><a href=""topic.asp?" & ArchiveLink & "TOPIC_ID=" & Topic_ID & """>" & ChkString(Topic_Subject,"title") & "</a></span> </font>" & vbNewLine


Change it to this:
		Response.Write	"<span class=""spnMessageText""><a href=""topic.asp?" & ArchiveLink & "TOPIC_ID=" & Topic_ID & """>" & ChkString(Topic_Subject,"title") & "</a><br />" & vbNewline & _
				"<font size=""" & strFooterFontSize & """>Posted on <strong>" & ChkDate(Topic_TopicPost,"</strong> at<strong>",true) & "</strong></font></span> </font>" & vbNewLine


That ought to do the trick.
Go to Top of Page

jfitz
Junior Member

USA
345 Posts
Posted - 08 January 2003 :  16:34:36  Show Profile
Thank you!

I will test it out tonight when I get to my FTP site at home.
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down.
Go to Top of Page

jfitz
Junior Member

USA
345 Posts
Posted - 08 January 2003 :  20:45:26  Show Profile
Got a minor problem when I tried it:
Microsoft VBScript runtime error '800a000d' 

Type mismatch: '[string: ""]' 

/forums/inc_func_common.asp, line 888


Line 888 of my inc_func_common.asp is in the chkDate routine: right here (second line):
case "dmmmy"
  chkDate = Mid(fDate,7,2) & " " & _
  Monthname(Mid(fDate,5,2),0) & " " & _
  Mid(fDate,1,4)


Looking for the problem source but haven't identified it yet. (P.S. I also have Poll Mod installed, but I didn't see any conflicts when I made the changes.)
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down.
Edited by - jfitz on 08 January 2003 20:48:29
Go to Top of Page

jfitz
Junior Member

USA
345 Posts
Posted - 08 January 2003 :  20:53:30  Show Profile
Never mind - I found it. A small typo in your code:

Topic_TopicPost = arrTopicData(tT_DATE, iTopic)
should be 
Topic_TopicPost = arrTopicData(tT_TOPIC_POST, iTopic)


I should have picked that up when I entered the code.

It works as advertised (and as I wanted).

Thanks again!!
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down.
Go to Top of Page

jfitz
Junior Member

USA
345 Posts
Posted - 08 January 2003 :  21:02:52  Show Profile
It seems to format (for me) just a bit better without the <strong> and with only the date part:
Response.Write	"<span class=""spnMessageText""><a href=""topic.asp?" & ArchiveLink & "TOPIC_ID=" & Topic_ID & """>" & ChkString(Topic_Subject,"title") & "</a><br />" & vbNewline & _
		"<font size=""" & strFooterFontSize & """> Begun " & ChkDate(Topic_TopicPost,"",false) & "</font></span> </font>" & vbNewLine


Again, THANK YOU EVER SO MUCH!
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down.
Edited by - jfitz on 08 January 2003 21:05:28
Go to Top of Page

zbenggg
Junior Member

Israel
227 Posts
Posted - 08 January 2003 :  21:12:43  Show Profile
There is possibility to photograph picture screen ( Print Screen ) ?
I love Israel
Go to Top of Page

jfitz
Junior Member

USA
345 Posts
Posted - 08 January 2003 :  21:17:58  Show Profile
zbenggg - If you want to see what it looks like on my forums, send me an email and I will send you a logon id and password.

quote:
Originally posted by zbenggg

There is possibility to photograph picture screen ( Print Screen ) ?
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down.
Edited by - jfitz on 08 January 2003 21:26:52
Go to Top of Page

zbenggg
Junior Member

Israel
227 Posts
Posted - 08 January 2003 :  21:19:46  Show Profile
Yes.
I do not know so English and I understood a little then I want to know how it seem.

Thank you
I love Israel
Go to Top of Page

zbenggg
Junior Member

Israel
227 Posts
Posted - 08 January 2003 :  21:33:28  Show Profile
To send...

http://forum.snitz.com/forum/pop_mail.asp?id=24484
I love Israel
Go to Top of Page

jfitz
Junior Member

USA
345 Posts
Posted - 08 January 2003 :  21:39:47  Show Profile
zbenggg, I got your email and responded to it.
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down.
Go to Top of Page

zbenggg
Junior Member

Israel
227 Posts
Posted - 08 January 2003 :  21:46:36  Show Profile
Ho thanks man
I love Israel
Go to Top of Page

zbenggg
Junior Member

Israel
227 Posts
Posted - 08 January 2003 :  21:54:50  Show Profile
Yes. I'm sorry i not to understand function this...
I love Israel
Go to Top of Page

jfitz
Junior Member

USA
345 Posts
Posted - 08 January 2003 :  21:56:41  Show Profile
Sometimes I like to know how OLD a topic is, rather than only the date of the last post.
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down.
Go to Top of Page

jfitz
Junior Member

USA
345 Posts
Posted - 08 January 2003 :  22:23:42  Show Profile
Almost exactly parallel changes to topic.asp will work as well.
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07