Output Listing of Recent Vanilla Discussions into TextPattern powered site?

v_wafer

A client for whom I recently installed and skinned a Vanilla forum would now like to have a list of ten or so recent forum discussions appear in the sidebar of their TextPattern powered web site. TextPattern is not a CMS which I have much experience with, but surely this is something that has been done and must be relatively simple?

I've searched the addons here at VanillaForums as well the discussion forums for TextPattern and for here. What I've mostly found are threads on integrating the log-in systems for both which isn't required for this project.

Anyone have any guidance?

Mark

The easiest thing would be to do something custom in textpattern. I'm not sure what language it is written in, but I imagine connecting to the database, pulling ten discussions, and echo'ing them can't be that hard.

Mark

We can give you the SQL to get the discussions if you can handle the rest.

v_wafer

Mark,

Thanks for chiming in!

I found one SQL query in the archives, from a discussion back in 2005 and I've been able to get it to work through a PHP call, but it just returns the DiscussionID? What would that query be?

http://vanillaforums.org/discussion/comment/9234/#Comment_9235
http://textpattern.org/plugins/976/smd_query

v_wafer

Using the a slightly tweaked version query linked to below, I was able to get this to work!

http://vanillaforums.org/discussion/comment/3407/#Comment_3407

The trick was to use the tag pair containing an include to a PHP script that makes the query call and displays the results. That script was based on one found here:

http://www.tizag.com/mysqlTutorial/mysqlfetcharray.php