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

Erel

B4X founder
Staff member
Licensed User
Longtime User
giphy.gif
 

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...
 
Top