[RSS Feed/News] Create in PHP a list of links to last topics

[XenForo]

Hi
I'd like to code in PHP (outside XF) a list of the 10 last topics/threads (that are visible to visitors). I need the title and the thread ID in order to construct the full URL of each thread page. The URL is "sanitized" from the thread title.
In MySQL it's something like that
SQL:

SELECT thread_id, title FROM `xf_thread` WHERE `discussion_state`='visible' AND `discussion_open`=1 ORDER BY thread_id DESC LIMIT 0,10
I don't know how to call XF and make simple query like that.
Thanks for...

Read more

ادامه مطلب...