[Forum] all threads started by a user in a specific forum

[ibnawa]

Is there any way to download in text format all threads ( only first post ) started by a user in a specific forum.
can this be done by running a mysql query?

[kh99]

I think this works:

SELECT post.pagetext
   FROM thread LEFT JOIN post ON(post.postid = thread.firstpostid)
   WHERE thread.postuserid = 1 AND thread.forumid = 2

But it will be the post with bbcode, not necessarily the same as what you see on the forum. (Obviously you want to change the 1 and 2 to the userid and forumid you want).

[ibnawa]

Thank you a lot.
You cant imagine how helpful this was .
However I'm getting some strange characters like : ÇááÌäÉ ÇáÊí ÑÌÊäí Çä ÇÞæã ÈÊßÈíÑ
I think its an encoding issues because I'm using Arabic.
any idea how can I get the correct characters?

[kh99]

There are mysql CONVERT() and CAST() functions that convert character set, but I don't know the details of what you'd need to do. It would be something like:

SELECT CONVERT(post.pagetext USING utf8)
   FROM thread LEFT JOIN post ON(post.postid = thread.firstpostid)
   WHERE thread.postuserid = 1 AND thread.forumid = 2

but I don't know if utf8 would be right, or if that's even the right function to use.