1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Members' Lounge' started by pills_PMD, May 4, 2006.

  1. pills_PMD

    pills_PMD Super Moderator

    Messages:
    4,232
    Likes Received:
    0
    Joined:
    Sep 30, 2002
    Location:
    New Albany, OH
    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....
     
  2. reikoshea

    reikoshea HS Troll...And Mod Moderator VIP

    Messages:
    12,633
    Likes Received:
    193
    Joined:
    Apr 27, 2005
    Location:
    San Antonio, TX
    the board stats cant, but im sure brian could write a quick select and count for the word fuck.
     
  3. TommyTheCat

    TommyTheCat Gonzo Scientist

    Messages:
    1,248
    Likes Received:
    11
    Joined:
    Sep 29, 2002
    Location:
    Minneapolis, MN
    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?
     
  4. pissedoffsol

    pissedoffsol RETIRED

    Messages:
    49,693
    Likes Received:
    54
    Joined:
    Sep 28, 2002
    Location:
    Retirement Home
    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
     
  5. TommyTheCat

    TommyTheCat Gonzo Scientist

    Messages:
    1,248
    Likes Received:
    11
    Joined:
    Sep 29, 2002
    Location:
    Minneapolis, MN
    It would be nice if you could divide those posts by a users total posts to see how fowl they are consistently.
     
  6. Dustin_m

    Dustin_m Active Member

    Messages:
    4,603
    Likes Received:
    16
    Joined:
    May 21, 2003
    Location:
    San Diego, CA
    haha i've used it 490 times out of 2885 posts, once in every 5.9 posts :p
     
  7. Seany-izzle

    Seany-izzle New Member

    Messages:
    7,738
    Likes Received:
    8
    Joined:
    Aug 25, 2003
    Location:
    In a fucking house.
    awww i havent even fuckin broke 4-fucking-hundred? what the fucking fuck?
     
  8. pissedoffsol

    pissedoffsol RETIRED

    Messages:
    49,693
    Likes Received:
    54
    Joined:
    Sep 28, 2002
    Location:
    Retirement Home
    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
     
  9. reikoshea

    reikoshea HS Troll...And Mod Moderator VIP

    Messages:
    12,633
    Likes Received:
    193
    Joined:
    Apr 27, 2005
    Location:
    San Antonio, TX
    FUCK, didnt even make the list.
     
  10. Citizen_Insane

    Citizen_Insane Senior Member

    Messages:
    3,698
    Likes Received:
    3
    Joined:
    Jul 24, 2003
    Location:
    Minneapolis
    aww fuck, 219 is so fucking lame.

    or should I say 211 HA!
     
  11. MugenCRX

    MugenCRX Senior Member

    Messages:
    1,463
    Likes Received:
    0
    Joined:
    Mar 21, 2003
    Location:
    Thornton CO
    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!! [​IMG] :fuck:
     
  12. TurboMirage

    TurboMirage YEEAAAHHH VIP

    Messages:
    24,579
    Likes Received:
    696
    Joined:
    May 20, 2003
    Location:
    Central, MA
    noice. top 10 fuckers!
     
  13. E_SolSi

    E_SolSi Member of the 20 nut club Moderator VIP

    Messages:
    30,036
    Likes Received:
    3,970
    Joined:
    Sep 28, 2002
    Location:
    CT
    ill happily take second place
    [​IMG]
     
  14. Jeef

    Jeef NO MA'AM Moderator VIP

    Messages:
    7,151
    Likes Received:
    294
    Joined:
    Sep 29, 2002
    Location:
    CT
    Fuck I need to fucking start fucking posting more posts with fuck in them. Atleast I made the top 30 list.
     
  15. reckedracing

    reckedracing TTIWWOP VIP

    Messages:
    21,057
    Likes Received:
    1,180
    Joined:
    Dec 5, 2002
    Location:
    NY
    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...
     
  16. asmallsol

    asmallsol Super Moderator

    Messages:
    8,074
    Likes Received:
    3
    Joined:
    Sep 28, 2002
    Location:
    Houghton/Livonia Michigan
    fuck yea, I made the list!
     
  17. BigJ

    BigJ I'm just about that action Boss. VIP

    Messages:
    11,091
    Likes Received:
    408
    Joined:
    Oct 4, 2002
    Location:
    Washington
    Fucking Woot ! made the list! 251!
     
  18. Slammed90Lude

    Slammed90Lude Senior Member

    Messages:
    3,733
    Likes Received:
    0
    Joined:
    Jan 13, 2003
    Location:
    milford, PA
    fuck ing a, I made the list too!!!
     
  19. Seany-izzle

    Seany-izzle New Member

    Messages:
    7,738
    Likes Received:
    8
    Joined:
    Aug 25, 2003
    Location:
    In a fucking house.
    Fuck no, only a low-ly 9% of my posts include the word FUCK in it.
     
  20. reikoshea

    reikoshea HS Troll...And Mod Moderator VIP

    Messages:
    12,633
    Likes Received:
    193
    Joined:
    Apr 27, 2005
    Location:
    San Antonio, TX
    i still cant believe i didnt make the list...i think my swearing lies in other words (which is really quite suprising).
     
Verification:
Draft saved Draft deleted

Share This Page