Announcement

Collapse
No announcement yet.

all threads started by a user in a specific forum

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [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?

  • #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


    • #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


      • #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...
        X