Simple Machines Community Forum

General Community => Scripting Help => Topic started by: NV on August 11, 2003, 01:10:26 PM

Title: XML export of a certain topic
Post by: NV on August 11, 2003, 01:10:26 PM
Hi, i'm in the middle of doing some reorgs on my board.
Now i'd like to export a certain topic to xml.

But strangely enough, while using phpmyadmin, the export function is not available after executing my sql query, which btw looks like this:

Quote
SELECT topics.ID_TOPIC, messages.posterTime, messages.subject, messages.posterName, messages.body
FROM messages INNER JOIN topics ON messages.ID_TOPIC = topics.ID_TOPIC
WHERE (((topics.ID_BOARD)=2))
ORDER BY topics.ID_TOPIC, messages.posterTime;

Anyone knows work arounds etc.?

Thanks in advance....
Title: Re:XML export of a certain topic
Post by: [Unknown] on August 11, 2003, 07:12:32 PM
SMF has some XML stuff, you might like it ;).

But, it doesn't allow for a SPECIFIC topic, just like recent ones and news, etc.

For example..
http://www.simplemachines.org/community/index.php?action=.xml

-[Unknown]
Title: Re:XML export of a certain topic
Post by: NV on August 12, 2003, 03:13:56 AM
Àctually I noticed I was using a somewhat older version of PhpMyAdmin. The latest version has this option built in, so trouble's gone.