Author |
Topic |
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 23 April 2002 : 05:11:00
|
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
|
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 |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 23 April 2002 : 06:10:02
|
Yes, I have seen it too, but I don´t have the code for it.
|
|
|
HarshReality
Junior Member
USA
128 Posts |
Posted - 23 April 2002 : 07:35:54
|
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 |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 23 April 2002 : 07:42:12
|
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 |
|
|
HarshReality
Junior Member
USA
128 Posts |
Posted - 23 April 2002 : 09:29:21
|
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.... |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 23 April 2002 : 09:38:43
|
Of course I will...thanks. |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 23 April 2002 : 14:32:27
|
I had done it for v3.1sr4 |
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 23 April 2002 : 16:55:53
|
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.
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 23 April 2002 : 17:46:52
|
Richard / blackinwhite - could you please send me the changes for 3.1SR4 ?
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 23 April 2002 : 18:03:23
|
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 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 23 April 2002 : 18:07:47
|
here is what it will look like:
|
|
|
HarshReality
Junior Member
USA
128 Posts |
Posted - 23 April 2002 : 21:42:10
|
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.... |
|
|
suhern
Junior Member
186 Posts |
Posted - 24 April 2002 : 10:24:35
|
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.
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2002 : 11:17:26
|
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") & """>" |
|
|
suhern
Junior Member
186 Posts |
Posted - 24 April 2002 : 11:38:38
|
Thanks Richard. Works great.
|
|
|
Topic |
|