XF 2.0 How to build the SEO friendly link for a thread/post? (Xenforo 2)

[screamfine]

Hi there,

I am currently developing some shortcodes for my wordpress theme.
One of the functions I am about to develop is fetching latest posts and outputs the title along with the link to the post.
(my sql statement:

    $results = $wpdb->get_results("SELECT title, last_post_username, last_post_date FROM xf_thread ORDER BY last_post_date DESC");

Can somebody please explain me how to build the (SEO friendly) link to a thread/post?
e.g.: http://myforum.com/forum/threads/first-testthread.1/

How would the php code for this look like assuming I have the title, the thread id and anything else needed already stored in php variables?

 

[S Thomas]

Take friendly_seo_string from here: https://www.visualscope.com/seo-friendly-urls.html
and then:

$url = "/forum/threads/$seo_string.$id/";

where $seo_string is the friendly seo string thread title and $id is the thread id.

 

[screamfine]

That seems to work! Thank you so much @yoloswaggerino