XF 1.3 Search biggest posts

[Mr Lucky]

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

 

[Paul B]

You can use the Minimum Number of Replies option.

Or do you mean actual post size based on content?

 

[Mr Lucky]

You can use the Minimum Number of Replies option.

Or do you mean actual post size based on content?

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.

 

[Mike]

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;