• 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

Brogan

XenForo moderator
Staff member
#2
You can use the Minimum Number of Replies option.

Or do you mean actual post size based on content?
 

Mr Lucky

Well-known member
#3
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

XenForo developer
Staff member
#4
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;