Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2009-10-23 20:59:05
- bseymore
- New Member
- Registered: 2009-10-23
- Posts: 3
List recent Vanilla-powered forums discussions on TextPattern pages?
After installing and skinning a Vanilla-powered forum for a client, they would now like a list of the ten most recent discussions to appear on the sidebar of their TextPattern powered blog. I haven’t worked much with either Vanilla or TextPattern (most of my experience is with a different CMS) but surely this is something relatively simple? I imagine there are a variety of different approaches but this is something which TXP users have done more than a once?
Thanks in advance for any tips, suggestions or pointers.
Offline
Re: List recent Vanilla-powered forums discussions on TextPattern pages?
It’s a while since I worked with Vanilla but I think what you need to do is create a feed in Vanilla and pull it into Textpattern with something like the aks_rss plug-in. I should say that I’ve never tried this myself.
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline
#3 2009-10-23 21:42:24
- bseymore
- New Member
- Registered: 2009-10-23
- Posts: 3
Re: List recent Vanilla-powered forums discussions on TextPattern pages?
That approach seemed the most natural. From what I see in the Syndication document from the Vanilla site, syndication seems to require something called Garden which seems to be part of the still-in-development Vanilla 2. Thanks for pointing me to the aks_rss plug_in — I’ll do some research into how to create a feed of recent discussions.
Thanks again for the pointer.
Offline
#4 2009-10-29 21:37:41
- bseymore
- New Member
- Registered: 2009-10-23
- Posts: 3
Re: List recent Vanilla-powered forums discussions on TextPattern pages?
Using the a slightly tweaked version of the SQL 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 <txp:php> 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
Offline