Announcement

Collapse
No announcement yet.

all threads started by a user in a specific forum

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

  • kh99
    replied
    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.

    Leave a comment:


  • ibnawa
    replied
    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?

    Leave a comment:


  • kh99
    replied
    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).

    Leave a comment:


  • ibnawa
    started a topic [Forum] all threads started by a user in a specific 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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X