1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 Search biggest posts

Discussion in 'XenForo Questions and Support' started by Mr Lucky, Jul 3, 2014.

  1. Mr Lucky

    Mr Lucky Well-Known Member

    I'd like to search for posts by size. Is this possible? Any addons that might do it?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    You can use the Minimum Number of Replies option.

    Or do you mean actual post size based on content?
  3. Mr Lucky

    Mr Lucky Well-Known Member

    I mean actual size of the post content.

    There are some very old posts that I'd like to convert to xenzine Articles or CTA Featured Threads. All I can remember is that they are very large. I can't even remember what they are about, so searching for big posts would help me find them.
  4. Mike

    Mike XenForo Developer Staff Member

    You'd have to do it in the DB directly:

    SELECT post_id, thread_id, message FROM xf_post ORDER BY LENGTH(message) DESC LIMIT 20;
    Mr Lucky likes this.

Share This Page