• From: chicago
  • Registered: 2003-11-04
  • Posts: 67

Topic: use punbb as a news scirpt

hello.  basicly im using the forum access mod and hidding a topic.  my idea is to let only mods and admins post in this catagory then take the first post from each topic and post it as a news entry on the front of my site.  the only problem is when i select the posts from the database i have no way of determining which is the first post of the topic.

heres the sql statement i came up with.  anybody have any ideas or suggestions?

SELECT * FROM forum_topics, forum_posts WHERE forum_topics.forum_id = 20 AND forum_posts.topic_id = forum_topics.forum_id

  • From: Melbourne, Australia
  • Registered: 2004-05-19
  • Posts: 220

Re: use punbb as a news scirpt

Hey, look at
http://punbb.org/forums/viewtopic.php?id=3868 AND
http://punbb.org/forums/viewtopic.php?id=4036

Cheers,
Julian

Digital photography news, reviews, discussions and more!
http://www.shuttertalk.com

The online bible for all
http://www.publicbible.com

cuteseal's Website

  • From: chicago
  • Registered: 2003-11-04
  • Posts: 67

Re: use punbb as a news scirpt

thanks.  that did the trick for me.  basicly i hid a forum and allowed only certain people to post in it with the efam.  i had to change the sql statement for that i think.  for some reason i had a little tourble unerstanding how it worked at first. you might want to include some better example in the documentaion on extrennews.php.

but thanks though. smile

www.socom.f8klan.com is where im using it.  the forum it comes from is hidden.