• Registered: 2006-08-27
  • Posts: 28

Topic: exporting topics to a front page of a site

hi all,

just updating a site for someone and im having trouble exporting just the main(first) post out of a forum without replies by the same person showing as well

i dont actually have the site online as its being dev'd on my machine

here is the code im using at the moment

"FROM topics,posts WHERE topics.forum_id='1' AND topics.id = posts.topic_id AND topics.poster ='treelo' AND posts.poster ='treelo' ORDER BY topics.posted DESC LIMIT 0,4"

basically, it shows my replies as well as the main post

anyone tried tinkering with punbb before and found a way round this?

  • Registered: 2006-08-27
  • Posts: 28

Re: exporting topics to a front page of a site

right, i know what i need to do, i just havent got a clue how to do it

i need to get code that only shows the first posted message, per topic_id

  • Registered: 2006-08-27
  • Posts: 28

Re: exporting topics to a front page of a site

ignore this thread, now solved

  • Registered: 2006-08-27
  • Posts: 28

Re: exporting topics to a front page of a site

ignore that

i do need help

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: exporting topics to a front page of a site

Take a look at the news generator plugin smile

  • Registered: 2006-08-27
  • Posts: 28

Re: exporting topics to a front page of a site

i dont actually want the news generator though

7 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: exporting topics to a front page of a site

treelo wrote:

i dont actually want the news generator though

No, but you could try reading the code and adapting it. big_smile

MattF's Website

  • Registered: 2006-08-27
  • Posts: 28

Re: exporting topics to a front page of a site

i dont pinch code

i had a brief look at the mod and its more a portal than a mod IMO