1 Topic by jtd

  • jtd
  • Junior Member
  • Offline
  • Registered: 2008-07-08
  • Posts: 4

Topic: Extern.php SQL

Hello,
I want print via extern.php last 10 posts with their subjects but i dont know how to implement this sql queries.

select id, (select subject from topics where id = topic_id) from posts where id > ((SELECT MAX(id) from posts) - 10)

After execution this SQL we get 10 last subjects and last post ids. If someone could translate it to extern.php style it would be great ;-)

Regards

  • From: Russia
  • Registered: 2008-07-22
  • Posts: 713

Re: Extern.php SQL

Why not to use this: http://punbb.informer.com/forums/extern … mp;show=10

PunBB team intentions, personal tasks.

Parpalak's Website

3 Reply by jtd

  • jtd
  • Junior Member
  • Offline
  • Registered: 2008-07-08
  • Posts: 4

Re: Extern.php SQL

It doesn't work properly at my forum. This is my forum http://forum.supermoto.pl and you can try. Some new posts are not included in extern file and thats the reason.

4 Reply by jtd

  • jtd
  • Junior Member
  • Offline
  • Registered: 2008-07-08
  • Posts: 4

Re: Extern.php SQL

After migration from other forum system all old topic have first_post_id and this is the problem.

5 Reply by sacsp

  • sacsp
  • Junior Member
  • Offline
  • Registered: 2009-10-29
  • Posts: 4

Re: Extern.php SQL

I rather call the feed, but since it's not working for you then you might have to query from the database. I'm a newbie for punbb too. So I'm not with the solution but waiting for some people idea too smile

Cosmetic Surgery Thailand
  • Slavok
  • PunBB Developer
  • Offline
  • From: Russia
  • Registered: 2008-06-11
  • Posts: 1,238

Re: Extern.php SQL

jtd wrote:

After migration from other forum system all old topic have first_post_id and this is the problem.

All topics should have first_post_id. Why do you think it is the problem?

Slavok's Website