Latest New Topics - Blog Style
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21297
Printed Date: 29 March 2026 at 12:52pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Latest New Topics - Blog Style
Posted By: wistex
Subject: Latest New Topics - Blog Style
Date Posted: 14 September 2006 at 8:12pm
|
I am having a hard time getting latest new topics on my website. There are several mods for latest posts, but that gives ones with the latest response. What I want is a list of new topics created, regardless of when and if they were replied to.
Example:
Subject: Latest New Topic
Date: 9/14/2006
Message: This is the latest new topic. And the first 40 characters would be listed here and then... (read more)
It would not display the message of the latest reply, but only and always show the message of the first post in a topic.
This is useful for when only an administrator can post new topics in a forum area, and you want to announce the new topics elsewhere on the site. In that situation, you do not want to display the replies, only the first post.
Any ideas of the proper SQL to do that. Every example I see seems to show how to get the last post in the thread (i.e. the latest reply), not the first post of a thread (the original topic-starter post).
Any help would be appreciated. ------------- http://www.wistex.com" rel="nofollow - WisTex Solutions http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums |
Replies:
Posted By: Mikey
Date Posted: 14 September 2006 at 8:32pm
|
This ties in nicely with what i've been trying to get going. Check the thread on 'front page news' some usefull ideas we could chop and change ------------- Handyman man? |
Posted By: wistex
Date Posted: 14 September 2006 at 9:53pm
|
I just found a mod that worked and then modified it to suit my needs:
http://forums.webwiz.net/forum_posts.asp?TID=21262&PID=114056#114056 - http://forums.webwiz.net/forum_posts.asp?TID=21262&PID=114056#114056
It was a "Latest News" type mod. ------------- http://www.wistex.com" rel="nofollow - WisTex Solutions http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums |
Posted By: freebs
Date Posted: 19 September 2006 at 1:38pm
| Please can you post your code for it, I cant seem to get it to work, and when it does, it shows the whole post. |
Posted By: javi712
Date Posted: 19 September 2006 at 1:46pm
| freebs - the guys working on this script have posted several version on the other thread they have going on: %20 - http://forums.webwiz.net/forum_posts.asp?TID=21262&PN=1 ... you may want to check that other thread out for some code examples. |
Posted By: freebs
Date Posted: 19 September 2006 at 2:25pm
| I have looked at the code, but cant get it to work to only display the headlines, and s short extract not the entire story. It also seems to display too many headlines and i want it to display from all forums. |
Posted By: wistex
Date Posted: 20 September 2006 at 5:14am
My version shows the whole post too. ------------- http://www.wistex.com" rel="nofollow - WisTex Solutions http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums |
freebs wrote: