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/Code)
 Mini-Slash Add-on
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 5

Teknics
Starting Member

USA
10 Posts

Posted - 30 August 2000 :  20:52:06  Show Profile  Visit Teknics's Homepage  Send Teknics an AOL message  Send Teknics an ICQ Message
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

Go to Top of Page

Jeepaholic
Average Member

USA
697 Posts

Posted - 23 October 2000 :  16:11:22  Show Profile  Visit Jeepaholic's Homepage
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
Go to Top of Page

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 23 October 2000 :  16:27:24  Show Profile  Visit Reinsnitz's Homepage  Send Reinsnitz an AOL message  Send Reinsnitz an ICQ Message  Send Reinsnitz a Yahoo! Message
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>
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 23 October 2000 :  16:35:39  Show Profile  Visit gor's Homepage
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>
Go to Top of Page

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 23 October 2000 :  16:43:46  Show Profile  Visit Reinsnitz's Homepage  Send Reinsnitz an AOL message  Send Reinsnitz an ICQ Message  Send Reinsnitz a Yahoo! Message
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>
Go to Top of Page

Jeepaholic
Average Member

USA
697 Posts

Posted - 23 October 2000 :  16:47:14  Show Profile  Visit Jeepaholic's Homepage
<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
Go to Top of Page

Jeepaholic
Average Member

USA
697 Posts

Posted - 23 October 2000 :  16:49:48  Show Profile  Visit Jeepaholic's Homepage
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
Go to Top of Page

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 23 October 2000 :  16:51:22  Show Profile  Visit Reinsnitz's Homepage  Send Reinsnitz an AOL message  Send Reinsnitz an ICQ Message  Send Reinsnitz a Yahoo! Message
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>
Go to Top of Page

Rigger82
Junior Member

USA
311 Posts

Posted - 23 October 2000 :  17:13:11  Show Profile  Visit Rigger82's Homepage  Send Rigger82 an AOL message  Send Rigger82 a Yahoo! Message
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
Go to Top of Page

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 23 October 2000 :  17:15:44  Show Profile  Visit Reinsnitz's Homepage  Send Reinsnitz an AOL message  Send Reinsnitz an ICQ Message  Send Reinsnitz a Yahoo! Message
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>
Go to Top of Page

Jeepaholic
Average Member

USA
697 Posts

Posted - 23 October 2000 :  17:27:30  Show Profile  Visit Jeepaholic's Homepage
Abosotively, posolutely, interested.

Al Bsharah
Jeepaholics Anonymous
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 23 October 2000 :  17:56:18  Show Profile  Visit gor's Homepage
<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>
Go to Top of Page

Rigger82
Junior Member

USA
311 Posts

Posted - 23 October 2000 :  18:25:25  Show Profile  Visit Rigger82's Homepage  Send Rigger82 an AOL message  Send Rigger82 a Yahoo! Message
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
Go to Top of Page

jwilkens
New Member

65 Posts

Posted - 23 October 2000 :  19:45:21  Show Profile
<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>

Go to Top of Page

mot
New Member

United Kingdom
70 Posts

Posted - 23 October 2000 :  20:11:12  Show Profile  Visit mot's Homepage
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

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