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)
 Addition to Last Post Info
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 23 April 2002 :  05:11:00  Show Profile
Has anyone considered adding the subject name to a topic to the last post info - just like Ikonbard?

I imagine something like this:



See it in action here:

http://www.4gigs.com/~wii/

Edited by - wii on 23 April 2002 06:16:23

stuF
Average Member

United Kingdom
561 Posts

Posted - 23 April 2002 :  06:07:55  Show Profile  Visit stuF's Homepage
sombody did this a while ago, i remember seeing it on a test forum, may have been richard...not sure though.

http://36-degrees.co.uk
Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 23 April 2002 :  06:10:02  Show Profile
Yes, I have seen it too, but I don´t have the code for it.

Go to Top of Page

HarshReality
Junior Member

USA
128 Posts

Posted - 23 April 2002 :  07:35:54  Show Profile  Visit HarshReality's Homepage  Send HarshReality an AOL message  Send HarshReality an ICQ Message  Send HarshReality a Yahoo! Message
I think I can do this.... Let me see now..

Would have to make a new colum in Foru, F_LASTPOST_SUBJECT and then in post_info have it write the topic subject to that table and then....

Oh what wonders await we the ****ed in exile, for in a single act of rage I have slain what little humanity I have left and all that remains is the beast....

Edited by - HarshReality on 23 April 2002 08:30:42
Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 23 April 2002 :  07:42:12  Show Profile
I hope you can - could you make it for both the current version and 3.1SR4 ?



Edited by - wii on 23 April 2002 07:42:32
Go to Top of Page

HarshReality
Junior Member

USA
128 Posts

Posted - 23 April 2002 :  09:29:21  Show Profile  Visit HarshReality's Homepage  Send HarshReality an AOL message  Send HarshReality an ICQ Message  Send HarshReality a Yahoo! Message
If by chance you find the answer to this before I figure it out drop me a line, I'll be more than certain to do the same should the reverse occour.

Oh what wonders await we the ****ed in exile, for in a single act of rage I have slain what little humanity I have left and all that remains is the beast....
Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 23 April 2002 :  09:38:43  Show Profile
Of course I will...thanks.
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 23 April 2002 :  14:32:27  Show Profile
I had done it for v3.1sr4
Go to Top of Page

blackinwhite
Average Member

Turkey
657 Posts

Posted - 23 April 2002 :  16:55:53  Show Profile
I think RichardKinser kindly send me the necessary files one more times.

There aren't so much changes, a small code for inc_functions.asp, and some changes in default.asp I think.


Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 23 April 2002 :  17:46:52  Show Profile
Richard / blackinwhite - could you please send me the changes for 3.1SR4 ?

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 23 April 2002 :  18:03:23  Show Profile
This will get it to show kinda like you have indicated in your topic:

in default.asp find this section of code: (around line #341 of an unmodified v3.3.03 version of default.asp)

							Response.Write	"        <td bgcolor=""" & strForumCellColor & """ align=center valign=top nowrap><font face=""" & strDefaultFontFace & """ color=""" & strForumFontColor & """ size=""" & strFooterFontSize & """>" & vbNewline & _
" <b>" & ChkDate(rsForum("F_LAST_POST")) & "</b><br>" & vbNewline & _
" " & ChkTime(rsForum("F_LAST_POST")) & strLastUser & vbNewline & _
" </font></td>" & vbNewline

replace it with this:

	                                                '## Forum_SQL - Get all topics from DB
strSql ="SELECT TOPIC_ID, T_SUBJECT "
strSql = strSql & " FROM " & strTablePrefix & "TOPICS "
strSql = strSql & " WHERE FORUM_ID = " & rsForum("FORUM_ID")
strSql = strSql & " ORDER BY T_LAST_POST DESC; "

set rsNewStuff = my_Conn.Execute (strSql)

if rsNewStuff.eof or rsNewStuff.bof then
TopicSubject = ""
set rsNewStuff = nothing
else
TopicSubject = "<a href=""topic.asp?TOPIC_ID=" & rsNewStuff("TOPIC_ID") & """>"
if Len(ChkString(rsNewStuff("T_SUBJECT"),"display")) > 16 then
TopicSubject = TopicSubject & Trim(Left(ChkString(rsNewStuff("T_SUBJECT"),"display"),16)) & "...."
else
TopicSubject = TopicSubject & ChkString(rsNewStuff("T_SUBJECT"),"display")
end if
TopicSubject = TopicSubject & "</a>"
set rsNewStuff = nothing
end if
Response.Write " <td bgcolor=""" & strForumCellColor & """ align=center valign=top nowrap><font face=""" & strDefaultFontFace & """ color=""" & strForumFontColor & """ size=""" & strFooterFontSize & """>" & vbNewline
if TopicSubject <> "" then
Response.Write " " & TopicSubject & "<br>" & vbNewLine
end if
Response.Write " <b>" & ChkDate(rsForum("F_LAST_POST")) & "</b><br>" & vbNewline & _
" " & ChkTime(rsForum("F_LAST_POST")) & strLastUser & vbNewline & _
" </font></td>" & vbNewline
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 23 April 2002 :  18:07:47  Show Profile
here is what it will look like:

Go to Top of Page

HarshReality
Junior Member

USA
128 Posts

Posted - 23 April 2002 :  21:42:10  Show Profile  Visit HarshReality's Homepage  Send HarshReality an AOL message  Send HarshReality an ICQ Message  Send HarshReality a Yahoo! Message
is there a mod anywhere that will work in forum.asp to jusmp to last post? Have looked around and cant find it at all. Would look really good if coult use a similar method in forum.asp but simply call th link "Latest"

Oh what wonders await we the ****ed in exile, for in a single act of rage I have slain what little humanity I have left and all that remains is the beast....
Go to Top of Page

suhern
Junior Member

186 Posts

Posted - 24 April 2002 :  10:24:35  Show Profile
quote:

here is what it will look like:





Richard,
This works wonderfully. It is easy to implement too thanks...

I am wandering since the title is read form the database call already, we can make full use of it. What I am suggesting is a mouse tip that will show the whole title when mouse over. I hope I am communicating clearly.

Anyway just a thought. It is great in itself already.

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 24 April 2002 :  11:17:26  Show Profile
Sure, just change this line:

TopicSubject = "<a href=""topic.asp?TOPIC_ID=" & rsNewStuff("TOPIC_ID") & """>"


to this:

TopicSubject = "<a href=""topic.asp?TOPIC_ID=" & rsNewStuff("TOPIC_ID") & """ title=""" & ChkString(rsNewStuff("T_SUBJECT"),"display") & """>"
Go to Top of Page

suhern
Junior Member

186 Posts

Posted - 24 April 2002 :  11:38:38  Show Profile
Thanks Richard. Works great.

Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 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.33 seconds. Powered By: Snitz Forums 2000 Version 3.4.07