I've modified this code slightly including now chopping off the topic at a certain length. I did this for a specific reason. I now include the "Latest Topic" on my web page (limited number of posts shown to 1 so it's the newest). It works very effectively.
How would i go about adding the author's name? I know i need to convert T_AUTHOR to the M_NAME but i don't know how, any ideas/help :).
Love this mod! Great work guys... I realize this is set up to display the latest TOPICS, but I was wondering if it could be set up to have the option of displaying the latest MESSAGES (new or reply)? I realize the original topic posts and the reply posts are located in different tables, so that would make this more difficult...but I don't have the know-how to make this happen... (yet!)
I also agree with the above post that it'd be nice to have the poster's name as well. Again, this is a cross-table thing that I just couldn't figure out.
Um... could somone tell me what this is? I've read the thread through... and even scanned the code in the post here a little... but it's not realy clear as to what it does...
I'm guessing that it's on the Topic.asp page, it actualy shows a little bit of the post instead of just the title?
<font color=green>Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make your path straight. -- Proverbs 3:5-6</font id=green></center>
Here you see some of the most recent topics taken from the forum, with some info on the amount of replies and an easy way to read the full story.
It is like you see at http://www.slashdot.com (hence the name of the mod <img src=icon_smile_wink.gif border=0 align=middle>)
<b>Pierre Gorissen</b>
<font color=blue><font size=1>Maturity is only a short break in adolescence. </font id=blue></font id=size1><font size=1><font color=black>Jules Feiffer</font id=size1></font id=black>
<font color=green>Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make your path straight. -- Proverbs 3:5-6</font id=green></center>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Um... could somone tell me what this is? I've read the thread through... and even scanned the code in the post here a little... but it's not realy clear as to what it does...
I'm guessing that it's on the Topic.asp page, it actualy shows a little bit of the post instead of just the title? <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Hey Mike, it's simply code that can be put into any web page (outside of the forum) that will give you the X most-recent Topics posted to the forum, a brief amount of text from the message, dates posted, times, and links to view the whole topic or reply to it.
I posted a link to a working version on my website above and Mark C has a version on his webpage too ( http://www.paratrooper.net )
<font color=green>Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make your path straight. -- Proverbs 3:5-6</font id=green></center>
Oh, just so you know, I am rewriting it to show the latest replies instead of topics, my goal is to create the mod so that you can easily switch the view type from latest TOPICS to latest posts.
If anyone is interested, let me know and I will post the code here when its complete.
<font color=green>"I no longer call you servants, because a servant does not know his master's business. Instead I have called you friends... -- John 15:15</font id=green></center>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Oh, just so you know, I am rewriting it to show the latest replies instead of topics, my goal is to create the mod so that you can easily switch the view type from latest TOPICS to latest posts.
If anyone is interested, let me know and I will post the code here when its complete. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Are you going to use a UNION or just going to use 2 recordsets take the first X of both, sort them and then use the first Y of the resulting set? I don't think MySql supports the UNION statement though, and it would be nice to have something that works on all the Snitz certified databases <img src=icon_smile.gif border=0 align=middle>
<b>Pierre Gorissen</b>
<font color=blue><font size=1>Maturity is only a short break in adolescence. </font id=blue></font id=size1><font size=1><font color=black>Jules Feiffer</font id=size1></font id=black>
We'll see Gor, I want to make it as flexible as possible as well, and watching this version work on my site has taught me a few things. I am really going to get into it. I will post what I come up with ASAP.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Oh, just so you know, I am rewriting it to show the latest replies instead of topics, my goal is to create the mod so that you can easily switch the view type from latest TOPICS to latest posts.
If anyone is interested, let me know and I will post the code here when its complete.
--------------------- Mark Christianson Gulf War Veteran (82nd Airborne Division) Owner/Operator of www.paratrooper.net Rigger@paratrooper.net <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>