Author |
Topic  |
Teknics
Starting Member
USA
10 Posts |
Posted - 30 August 2000 : 20:52:06
|
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 :).
teknics
|
 |
|
Jeepaholic
Average Member
  
USA
697 Posts |
Posted - 23 October 2000 : 16:11:22
|
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!)
You can see a working version of the above mod at the URL in the signature, or short-cut to it by going here: http://www.jeepaholics.com/default.asp
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.
Thoughts?
Thanks! You guys rule. <hooked already>
Al Bsharah Jeepaholics Anonymous |
 |
|
Reinsnitz
Snitz Forums Admin
    
USA
3545 Posts |
Posted - 23 October 2000 : 16:27:24
|
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?
<center>Reinsnitz (Mike) <font color=red>><)))'></font id=red>
<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> |
 |
|
gor
Retired Admin
    
Netherlands
5511 Posts |
Posted - 23 October 2000 : 16:35:39
|
Just take a look at Marks site:
http://www.paratrooper.net/aotw/
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> |
 |
|
Reinsnitz
Snitz Forums Admin
    
USA
3545 Posts |
Posted - 23 October 2000 : 16:43:46
|
I kept looking in the forums... and couldn't see anything out of the ordinary! hehe geez... OK... now I see it on the FRONT PAGE of all of them :)
This is an awesome mod!
(I'm realy wanting to put some of this stuff in... gah gah agh agh hag hag ahg ahg etc etc...)
<center>Reinsnitz (Mike) <font color=red>><)))'></font id=red>
<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> |
 |
|
Jeepaholic
Average Member
  
USA
697 Posts |
Posted - 23 October 2000 : 16:47:14
|
<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 )
Al Bsharah Jeepaholics Anonymous |
 |
|
Jeepaholic
Average Member
  
USA
697 Posts |
Posted - 23 October 2000 : 16:49:48
|
Guess I shouldn't start a post, then walk away and come back and finish it without re-reading the people that beat me to it!
Al Bsharah Jeepaholics Anonymous |
 |
|
Reinsnitz
Snitz Forums Admin
    
USA
3545 Posts |
Posted - 23 October 2000 : 16:51:22
|
hehe no prob ;) it's a hot topic now!
<center>Reinsnitz (Mike) <font color=red>><)))'></font id=red>
<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> |
 |
|
Rigger82
Junior Member
 
USA
311 Posts |
Posted - 23 October 2000 : 17:13:11
|
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 |
 |
|
Reinsnitz
Snitz Forums Admin
    
USA
3545 Posts |
Posted - 23 October 2000 : 17:15:44
|
I am interested...
<center>Reinsnitz (Mike) <font color=red>><)))'></font id=red>
<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> |
 |
|
Jeepaholic
Average Member
  
USA
697 Posts |
|
gor
Retired Admin
    
Netherlands
5511 Posts |
Posted - 23 October 2000 : 17:56:18
|
<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> |
 |
|
Rigger82
Junior Member
 
USA
311 Posts |
Posted - 23 October 2000 : 18:25:25
|
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.
--------------------- Mark Christianson Gulf War Veteran (82nd Airborne Division) Owner/Operator of www.paratrooper.net Rigger@paratrooper.net |
 |
|
jwilkens
New Member

65 Posts |
Posted - 23 October 2000 : 19:45:21
|
<b>This is a great mod!!</b>
<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>
|
 |
|
mot
New Member

United Kingdom
70 Posts |
Posted - 23 October 2000 : 20:11:12
|
Anyone come up with a way to get the above script to work, showing the uk date format. Or better still the date format used by the forum
|
 |
|
Topic  |
|