I've just crossed 100,000 posts today :)

AnandGupta

Expert
Licensed User
Longtime User
Interesting question.
B4X:
SELECT count(*) FROM `xf_post` WHERE `user_id` = 1 AND `message` LIKE 'please start a new thread%'
The answer is 1,122.

Should ya put % before too,
SELECT count(*) FROM `xf_post` WHERE `user_id` = 1 AND `message` LIKE '%please start a new thread%'

as the text sometimes are in next line

Regards,

Anand
 

Erel

B4X founder
Staff member
Licensed User
Longtime User
hould ya put % before too,
SELECT count(*) FROM `xf_post` WHERE `user_id` = 1 AND `message` LIKE '%please start a new thread%'

as the text sometimes are in next line
I actually did it. The result is about 1800. However there are many cases where I gave an answer to one question and then asked the OP to start a new thread for the second question. So I don't add it to the number of non-informative posts.

Don't take it too seriously. The administration posts are very important, not less important than other posts...
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…