all threads started by a user in a specific forum

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ibnawa
    New Member
    • Sep 2011
    • 2

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

    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
    Senior Member
    • Aug 2009
    • 533

    #2
    I think this works:
    Code:
    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).

    Comment

    • ibnawa
      New Member
      • Sep 2011
      • 2

      #3
      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?

      Comment

      • kh99
        Senior Member
        • Aug 2009
        • 533

        #4
        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:

        Code:
        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.

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...