I wonder if the board stats can pull this...

We may earn a small commission from affiliate links and paid advertisements. Terms

pills_PMD

New Member
VIP
Is there anyway to track who uses the word fuck most often when they post?
Like every time the word fuck comes up in a post (regardless of it if it used multiple times) you get a point.

i wonder who would win....
 
the board stats cant, but im sure brian could write a quick select and count for the word fuck.
 
Well fuck. If Brian couldn't, we're all fucked. But if he did could he make sure it picks up on all the fuckin different versions of the word?

BTW, why dont we reward people for NOT cursing?
 
i have a feeling this is going to eat our server resources.....

Code:
SELECT author_name, count(*) as `thecount` FROM invision_posts
where post LIKE '%fuck%'
group by author_name
order by thecount desc

first 30 results....


and the winner is








me


ROFL




author_name thecount

pissedoffsol 2720
E_SolSi 1917
2000Si 1540
Tonyd0821 1229
reckedracing 905
civicious 805
JDMilan 728
92b16vx 723
Havok 638
TurboMirage 635
92civicb18b1 593
Celerity 565
brian11to1 543
Blanco 523
senate_9427 490
Battle Pope 481
Domeskilla 465
Loco Honkey 445
Calesta 415
dveit 406
Jeef 401
New2TheCarScene 391
Seany-izzle 369
asmallsol 362
sohcslammer 360
BodyDroppedNikes 354
dohcvtec_accord 343
B16 328
dohch22a4 318
liquid00meth 311
sLuShBoXtEgGy 310
UDT 309
tab 305
phyregod 303
90 accord 292
GSRCRXsi 289
92CivicCx 282
jeffie7 279
kylemarhx 268
B16RacerN2NR 255
Slammed89Integra 251
hcivic.com 231
sportlinecrx 229
Silverchild79 222
Slammed90Lude 222
SiR Kid 221
Citizen_Insane 219
swanny 216
khrisb 210
h22bubbleback 210



TOTALS:

39904



so, out of a total post count of 657170

that means that 6% of posts contain the word fuck.



happy now? :p
 
It would be nice if you could divide those posts by a users total posts to see how fowl they are consistently.
 
awww i havent even fuckin broke 4-fucking-hundred? what the fucking fuck?
 
Quoted post[/post]]
It would be nice if you could divide those posts by a users total posts to see how fowl they are consistently.

you can do the math...


author_name fuckposts total posts
pissedoffsol 2721 40896
E_SolSi 1917 12777
2000Si 1540 4974
Tonyd0821 1229 5142
reckedracing 905 7926
civicious 805 6793
JDMilan 728 6775
92b16vx 723 12567
Havok 638 6690
TurboMirage 635 8887
92civicb18b1 593 6903
Celerity 565 7733
brian11to1 543 7845
Blanco 523 4480
senate_9427 490 2885
Battle Pope 481 8079
Domeskilla 465 2979
Loco Honkey 445 3684
Calesta 415 19186
dveit 406 3423
Jeef 401 3306
New2TheCarScene 391 2818
Seany-izzle 370 4171
asmallsol 362 7763
sohcslammer 360 2217
BodyDroppedNikes 354 7154
dohcvtec_accord 343 8412
B16 328 6090
dohch22a4 318 1735
liquid00meth 311 3245
 
Loco Honkey 445

LOL! How the FUCK did Ji get in that? I thought he was completely banned gone forever from this fucking site and fucking shit?

Fuck, I didn't fucking make it either!! :shrug2: :fuck:
 
ill happily take second place
:thankyou:
 
Fuck I need to fucking start fucking posting more posts with fuck in them. Atleast I made the top 30 list.
 
Top Ten %'s


0.0665346244131456 pissedoffsol 2721 40896
0.150035219535102 E_SolSi 1917 12777
0.309609971853639 2000Si 1540 4974
0.23901205756515 Tonyd0821 1229 5142
0.114181175876861 reckedracing 905 7926
0.118504342705727 civicious 805 6793
0.107453874538745 JDMilan 728 6775
0.0575316304607305 92b16vx 723 12567
0.0953662182361734 Havok 638 6690
0.0714526836952853 TurboMirage 635 8887
0.0859046791250181 92civicb18b1 593 6903

I'm guessing 2000SI's 31% is about the highest of anyone...
 
Fuck no, only a low-ly 9% of my posts include the word FUCK in it.
 
i still cant believe i didnt make the list...i think my swearing lies in other words (which is really quite suprising).
 
Back
Top