XF 2.0 How to display threads details on a external page

[sysfoc]

Can someone please guide how to get following details from a thread to display on external pages,
1- Thread Title
2- Thread starter ID
3- Thread start time
4- ID of a member who replied last post
5- Thread thumbnail (using thumbanil add-on)

 

[Paul B]

That would require custom development.

 

[sysfoc]

That would require custom development.

We will do custom development. Where does xenforo store this information in the database?

 

[Paul B]

I have moved the thread to a more appropriate forum.

The content is spread across various tables (assuming you also want user names, etc.) - you should be able to work it out by looking at the schema/DB.

 

[S Thomas]

1-4 is actually stored in xf_thread, including user names of first and last poster. Thread thumbnail is something which is not stock, so you would need to ask the addon developer.

 

[sysfoc]

How to display threads with latest replies? I can display latest posts on external page but I want to display threads with latest replies instead latest posts because currently when one thread gets replies then each reply displays as a new thread on external page.
I might need to use some distinct post id query. What query should I use?

 

[S Thomas]

SELECT * FROM `xf_thread` ORDER BY `last_post_date`  DESC LIMIT 0, 1000

?
You should use the entity/finder system though https://xenforo.com/xf2-docs/dev/entities-finders-repositories/. There might be even functions in the stock XF code for latest threads with replies.