TLS Awards 2011 Discussion Thread

Hisako

Hisako

消えないひさ&#
AKA
Satsu, BRIAN BLESSED, MIGHTY AND WISE Junpei Iori: Ace Detective, Maccaffrickstonson von Lichtenstafford Frabenschnaben, Polite Krogan, Robert Baratheon
eyy 21st

I feel like a pretty big man now









:awesome:
 
Fangu

Fangu

Great Old One
V said:
Oh, cool, you can do math in queries. Awesome. I have no fucking idea why I didn't think to try that sooner.

SELECT 100*count(post.postid)/user.posts AS swears, post.userid, post.username
FROM post, user
WHERE post.userid=user.userid AND (pagetext like '%bitch%' or pagetext like '%shit%' or pagetext like '%fuck%' or pagetext like '%cunt%' or pagetext like '%bastard%' or pagetext like '%cock%' or pagetext like '%whore%' or pagetext like '%slut%' or pagetext like '%arse%' or pagetext like '%asshole%' or pagetext like '%dumbass%' or pagetext like '%dick%' or pagetext like '%twat%' or pagetext like '%smeg%') AND user.posts>500
GROUP BY post.userid
ORDER BY swears desc

  1. 40.1569% - [member=643]Vriska[/member]
  2. 38.7528% - [member=26]OneWingedDemon[/member]
  3. 36.2292% - [member=694]Neo Bahamut[/member]
  4. 34.0798% - [member=546]Ryoko[/member]
  5. 31.4506% - [member=15]Xelloss[/member]
  6. 31.2028% - [member=1830]Kissmammal2000[/member]
  7. 29.8851% - [member=134]Mormz[/member]
  8. 29.7385% - [member=800]Ariadne[/member]
  9. 28.7726% - [member=321]Fairheartstrife[/member]
  10. 28.5532% - [member=55]Batman[/member]
  11. 26.3017% - [member=382]Munatik[/member]
  12. 25.4949% - [member=683]Splintered[/member]
  13. 24.9597% - [member=1100]Gym Leader Devil[/member]
  14. 24.9523% - [member=8]dude in the background of guile's stage from sfii[/member]
  15. 24.8635% - [member=887]Samantha Carter[/member]
  16. 24.8338% - [member=542]Ulala[/member]
  17. 23.1716% - [member=1111]The Flash[/member]
  18. 23.0030% - [member=97]Gabriel[/member]
  19. 22.8873% - [member=391]ShuShu[/member]
  20. 22.5423% - [member=304]Interslicery[/member]
  21. 21.6808% - [member=581]Maccaffrickstonson von Lichtenstafford Frabenschnaben[/member]
  22. 20.5665% - [member=2729]Raven Roth[/member]
  23. 20.2946% - [member=25]Ishtar[/member]
  24. 20.1760% - [member=64]Devil May Cry[/member]
  25. 20.0704% - [member=253]Loxetta[/member]
  26. 20.0083% - [member=13]Rick Grimes[/member]
  27. 19.6693% - [member=2]Cthulhu[/member]
  28. 19.5122% - [member=874]Vossler[/member]
  29. 19.2639% - [member=9]V[/member]
  30. 19.2235% - [member=90]Ravynne[/member]
  31. 19.0272% - [member=607]KissTheRain[/member]
  32. 18.7967% - [member=33]Oracle[/member]
  33. 17.6928% - [member=184]Gwaine[/member]
  34. 17.6498% - [member=258]Catwoman[/member]
  35. 17.3197% - [member=252]Lord Noctis[/member]
  36. 17.1158% - [member=547]Bodacious[/member]
  37. 17.1083% - [member=229]Username[/member]
  38. 16.8871% - [member=180]Nightwing[/member]
  39. 16.4777% - [member=223]Victor Fries[/member]
  40. 15.7511% - [member=78]CK-47[/member]
  41. 15.3531% - [member=194]Zidane Tribal[/member]
  42. 15.1079% - [member=563]Eerie[/member]
  43. 15.0412% - [member=5]Hidari Shotaro[/member]
  44. 14.8741% - [member=3]X-SOLDIER[/member]
  45. 14.7792% - [member=106]The Red Hood[/member]
  46. 14.7117% - [member=31]null.[/member]
  47. 14.2227% - [member=192]Cole McGrath[/member]
  48. 14.1196% - [member=724]SoulReaper[/member]
  49. 14.0686% - [member=248]Quexinos[/member]
  50. 13.8525% - [member=209]Jacob Black[/member]

The number depicts the percentage of posts by a given member that contain swears. Note, though, that this includes quoted text, so it's still not a 100% accurate depiction of how profane the user is. It also doesn't indicate how many times they swear per post, just the percentage of posts that contain swears somewhere in the message body. (It also excludes message titles; too lazy to figure out how to include those right now).
Click to expand...
Aaahhhh the user-table holds total number of posts! That makes it so much easier. I thought the forum counts each post from the posts-table per userID, but of course that would take a hell of a lot longer. And it makes perfect sense. Each time you write a post, that number is updated (and vice versa for deletion). And then you can just use it like you do. Awesome!

You could erase posts with quotes in them, but that would have to be done via PHP I guess. I don't think SQL lets you search strings (and if so, it would look awful). In PHP you would just make two integer variables, one for quote-swears and one for original swears, make a loop where you look for the quote-tag, count the quote swears until quote-tag is shut, then count anything outside the quote tag, add to original swears, and in the end return the original swears integer.

Oh and I guess "ass" could be added, just remove the %'s?
 
Winter

Winter

8ad 8r8k
AKA
oddishness, like vines, azula, femshep, winter
V said:
Winter is the most thanked user this year. Also the most frequent swearer. I wonder if those two are fucking connected :monster:
Click to expand...
damn i feel so legit right now

it makes me feel better about never contributing anything to any fandom ever

"what are you a fanartist? haha you fucking plebian i'm the sweariest bastard with the highest thanked post ratio on tls, i know you lay awake at night wishing you were born with these god-given abilites"
 
Last edited:
Mage

Mage

She/They
AKA
Mage
Haha, number four. I fucking well knew it. Some of you tossers are fucking angelic in comparison to the sheer shite smut that emits forth from my gobhole. :monster:

Still, gotta work on that tally. Cockles.
 
Joker

Joker

We have come to terms
AKA
Godot
Oracle said:
What was that Kimble? Oh right.


Can't rag on me for my lack of swearing now can you, bitch?


Suck it fuckass.
Click to expand...
Rishi's swear percentage: 18.7967
Kimble's swear percentage: 16.4777

Rishi's total post count: 2814
Kimble's total post count: 10761

Rishi's posts with swears: 528.939138
Kimble's posts with swears: 1773.165297

what was that dunkass

now shut the fuck up and make me a sandwich white girl

ps love youuu <3
 
Ryushikaze

Ryushikaze

Deus Admiral Parsimonious, PHD, DDS, MD, JD, OBE
AKA
Tim, Ryu
V said:
Oh, cool, you can do math in queries. Awesome. I have no fucking idea why I didn't think to try that sooner.

SELECT 100*count(post.postid)/user.posts AS swears, post.userid, post.username
FROM post, user
WHERE post.userid=user.userid AND (pagetext like '%bitch%' or pagetext like '%shit%' or pagetext like '%fuck%' or pagetext like '%cunt%' or pagetext like '%bastard%' or pagetext like '%cock%' or pagetext like '%whore%' or pagetext like '%slut%' or pagetext like '%arse%' or pagetext like '%asshole%' or pagetext like '%dumbass%' or pagetext like '%dick%' or pagetext like '%twat%' or pagetext like '%smeg%') AND user.posts>500
GROUP BY post.userid
ORDER BY swears desc

  1. 40.1569% - [member=643]Vriska[/member]
  2. 38.7528% - [member=26]OneWingedDemon[/member]
  3. 36.2292% - [member=694]Neo Bahamut[/member]
  4. 34.0798% - [member=546]Ryoko[/member]
  5. 31.4506% - [member=15]Xelloss[/member]
  6. 31.2028% - [member=1830]Kissmammal2000[/member]
  7. 29.8851% - [member=134]Mormz[/member]
  8. 29.7385% - [member=800]Ariadne[/member]
  9. 28.7726% - [member=321]Fairheartstrife[/member]
  10. 28.5532% - [member=55]Batman[/member]
  11. 26.3017% - [member=382]Munatik[/member]
  12. 25.4949% - [member=683]Splintered[/member]
  13. 24.9597% - [member=1100]Gym Leader Devil[/member]
  14. 24.9523% - [member=8]dude in the background of guile's stage from sfii[/member]
  15. 24.8635% - [member=887]Samantha Carter[/member]
  16. 24.8338% - [member=542]Ulala[/member]
  17. 23.1716% - [member=1111]The Flash[/member]
  18. 23.0030% - [member=97]Gabriel[/member]
  19. 22.8873% - [member=391]ShuShu[/member]
  20. 22.5423% - [member=304]Interslicery[/member]
  21. 21.6808% - [member=581]Maccaffrickstonson von Lichtenstafford Frabenschnaben[/member]
  22. 20.5665% - [member=2729]Raven Roth[/member]
  23. 20.2946% - [member=25]Ishtar[/member]
  24. 20.1760% - [member=64]Devil May Cry[/member]
  25. 20.0704% - [member=253]Loxetta[/member]
  26. 20.0083% - [member=13]Rick Grimes[/member]
  27. 19.6693% - [member=2]Cthulhu[/member]
  28. 19.5122% - [member=874]Vossler[/member]
  29. 19.2639% - [member=9]V[/member]
  30. 19.2235% - [member=90]Ravynne[/member]
  31. 19.0272% - [member=607]KissTheRain[/member]
  32. 18.7967% - [member=33]Oracle[/member]
  33. 17.6928% - [member=184]Gwaine[/member]
  34. 17.6498% - [member=258]Catwoman[/member]
  35. 17.3197% - [member=252]Lord Noctis[/member]
  36. 17.1158% - [member=547]Bodacious[/member]
  37. 17.1083% - [member=229]Username[/member]
  38. 16.8871% - [member=180]Nightwing[/member]
  39. 16.4777% - [member=223]Victor Fries[/member]
  40. 15.7511% - [member=78]CK-47[/member]
  41. 15.3531% - [member=194]Zidane Tribal[/member]
  42. 15.1079% - [member=563]Eerie[/member]
  43. 15.0412% - [member=5]Hidari Shotaro[/member]
  44. 14.8741% - [member=3]X-SOLDIER[/member]
  45. 14.7792% - [member=106]The Red Hood[/member]
  46. 14.7117% - [member=31]null.[/member]
  47. 14.2227% - [member=192]Cole McGrath[/member]
  48. 14.1196% - [member=724]SoulReaper[/member]
  49. 14.0686% - [member=248]Quexinos[/member]
  50. 13.8525% - [member=209]Jacob Black[/member]

The number depicts the percentage of posts by a given member that contain swears. Note, though, that this includes quoted text, so it's still not a 100% accurate depiction of how profane the user is. It also doesn't indicate how many times they swear per post, just the percentage of posts that contain swears somewhere in the message body. (It also excludes message titles; too lazy to figure out how to include those right now).
Click to expand...

Just remember, folks, this counts times posted against times times A swear was posted in posts, not Total number of swears vs number of posts. This is how frequently, as opposed to how much.
 
Kikyou

Kikyou

just a fleeting memory
AKA
M-Mira, crackitlackin, Izaya Orihara, SAILOR NARU, Sharon Rainsworth, Mara, Brosuke Hanamura, Commissioner Gordon, Santa Claus, Lenneth Valkyrie
My Tiff/Dacon OTP would like to have a word with you.
 
Winter

Winter

8ad 8r8k
AKA
oddishness, like vines, azula, femshep, winter
>back to shipping tls members

i tried to save this thread i really did

this forum has too many single people or something what is wrong with all of you
 
Splintered

Splintered

unsavory tart
V said:
Oh, cool, you can do math in queries. Awesome. I have no fucking idea why I didn't think to try that sooner.

SELECT 100*count(post.postid)/user.posts AS swears, post.userid, post.username
FROM post, user
WHERE post.userid=user.userid AND (pagetext like '%bitch%' or pagetext like '%shit%' or pagetext like '%fuck%' or pagetext like '%cunt%' or pagetext like '%bastard%' or pagetext like '%cock%' or pagetext like '%whore%' or pagetext like '%slut%' or pagetext like '%arse%' or pagetext like '%asshole%' or pagetext like '%dumbass%' or pagetext like '%dick%' or pagetext like '%twat%' or pagetext like '%smeg%') AND user.posts>500
GROUP BY post.userid
ORDER BY swears desc

  1. 40.1569% - [member=643]Vriska[/member]
  2. 38.7528% - [member=26]OneWingedDemon[/member]
  3. 36.2292% - [member=694]Neo Bahamut[/member]
  4. 34.0798% - [member=546]Ryoko[/member]
  5. 31.4506% - [member=15]Xelloss[/member]
  6. 31.2028% - [member=1830]Kissmammal2000[/member]
  7. 29.8851% - [member=134]Mormz[/member]
  8. 29.7385% - [member=800]Ariadne[/member]
  9. 28.7726% - [member=321]Fairheartstrife[/member]
  10. 28.5532% - [member=55]Batman[/member]
  11. 26.3017% - [member=382]Munatik[/member]
  12. 25.4949% - [member=683]Splintered[/member]
  13. 24.9597% - [member=1100]Gym Leader Devil[/member]
  14. 24.9523% - [member=8]dude in the background of guile's stage from sfii[/member]
  15. 24.8635% - [member=887]Samantha Carter[/member]
  16. 24.8338% - [member=542]Ulala[/member]
  17. 23.1716% - [member=1111]The Flash[/member]
  18. 23.0030% - [member=97]Gabriel[/member]
  19. 22.8873% - [member=391]ShuShu[/member]
  20. 22.5423% - [member=304]Interslicery[/member]
  21. 21.6808% - [member=581]Maccaffrickstonson von Lichtenstafford Frabenschnaben[/member]
  22. 20.5665% - [member=2729]Raven Roth[/member]
  23. 20.2946% - [member=25]Ishtar[/member]
  24. 20.1760% - [member=64]Devil May Cry[/member]
  25. 20.0704% - [member=253]Loxetta[/member]
  26. 20.0083% - [member=13]Rick Grimes[/member]
  27. 19.6693% - [member=2]Cthulhu[/member]
  28. 19.5122% - [member=874]Vossler[/member]
  29. 19.2639% - [member=9]V[/member]
  30. 19.2235% - [member=90]Ravynne[/member]
  31. 19.0272% - [member=607]KissTheRain[/member]
  32. 18.7967% - [member=33]Oracle[/member]
  33. 17.6928% - [member=184]Gwaine[/member]
  34. 17.6498% - [member=258]Catwoman[/member]
  35. 17.3197% - [member=252]Lord Noctis[/member]
  36. 17.1158% - [member=547]Bodacious[/member]
  37. 17.1083% - [member=229]Username[/member]
  38. 16.8871% - [member=180]Nightwing[/member]
  39. 16.4777% - [member=223]Victor Fries[/member]
  40. 15.7511% - [member=78]CK-47[/member]
  41. 15.3531% - [member=194]Zidane Tribal[/member]
  42. 15.1079% - [member=563]Eerie[/member]
  43. 15.0412% - [member=5]Hidari Shotaro[/member]
  44. 14.8741% - [member=3]X-SOLDIER[/member]
  45. 14.7792% - [member=106]The Red Hood[/member]
  46. 14.7117% - [member=31]null.[/member]
  47. 14.2227% - [member=192]Cole McGrath[/member]
  48. 14.1196% - [member=724]SoulReaper[/member]
  49. 14.0686% - [member=248]Quexinos[/member]
  50. 13.8525% - [member=209]Jacob Black[/member]

The number depicts the percentage of posts by a given member that contain swears. Note, though, that this includes quoted text, so it's still not a 100% accurate depiction of how profane the user is. It also doesn't indicate how many times they swear per post, just the percentage of posts that contain swears somewhere in the message body. (It also excludes message titles; too lazy to figure out how to include those right now).
Click to expand...

I'm only 12? A part of me feels like I'm slacking.
 
Ⓐaron

Ⓐaron

Factiō Rēpūblicāna dēlenda est.
AKA
The Man, V
There are some really fucking accomplished swearers here. I ran the same query on Fool's Gold and the highest swearer was at 34%. And that's with a lot more people - the hundredth highest swearer there is only slightly below the fiftieth highest swearer here.
 
looneymoon

looneymoon

they/them
AKA
Rishi
Victor Fries said:
Rishi's swear percentage: 18.7967
Kimble's swear percentage: 16.4777

Rishi's total post count: 2814
Kimble's total post count: 10761

Rishi's posts with swears: 528.939138
Kimble's posts with swears: 1773.165297

what was that dunkass

now shut the fuck up and make me a sandwich white girl

ps love youuu <3
Click to expand...

The irony of this post is delicious.

Also your math sucks.
 
Marle

Marle

Pro Adventurer
AKA
Ava, Spike Spiegel, Stella Nox Fleuret, Altair Ibn-La'Ahad, Princess Zelda, Alice, Raven Roth, Faye Valentine, Tifa Lockhart, Khal Drogo
Alex

Alex

alex is dead
AKA
Alex, Ashes, Pennywise, Bill Weasley, Jack's Smirking Revenge, Sterling Archer
Oracle said:
The irony of this post is delicious.

Also your math sucks.
Click to expand...

Was it the irony of Kimble calling somebody else white.

because yeah
 
Ⓐaron

Ⓐaron

Factiō Rēpūblicāna dēlenda est.
AKA
The Man, V
TLS's most frequent poasters of tl;dr.

  1. 1679.9610 (1,076,855 characters in 641 posts) - [member=574]Baldy[/member]
  2. 1102.8104 (3,757,275 characters in 3,407 posts) - [member=800]Ariadne[/member]
  3. 909.5601 (492,072 characters in 541 posts) - [member=694]Neo Bahamut[/member]
  4. 862.3421 (690,736 characters in 801 posts) - [member=601]Raquelborn[/member]
  5. 851.2038 (6,825,803 characters in 8,019 posts) - [member=25]Ishtar[/member]
  6. 785.5871 (829,580 characters in 1,056 posts) - [member=90]Ravynne[/member]
  7. 757.2253 (836,734 characters in 1,105 posts) - [member=32]Treize Khushrenada[/member]
  8. 740.4518 (3,146,920 characters in 4,250 posts) - [member=3]X-SOLDIER[/member]
  9. 735.5071 (623,710 characters in 848 posts) - [member=1176]DLPB[/member]
  10. 710.2880 (579,595 characters in 816 posts) - [member=2729]Raven Roth[/member]
  11. 686.0265 (1,707,520 characters in 2,489 posts) - [member=1100]Gym Leader Devil[/member]
  12. 666.2220 (1,113,257 characters in 1,671 posts) - [member=683]Splintered[/member]
  13. 664.6889 (497,852 characters in 749 posts) - [member=382]Munatik[/member]
  14. 659.4856 (1,894,702 characters in 2,873 posts) - [member=98]Mantichorus[/member]
  15. 659.2193 (982,896 characters in 1,491 posts) - [member=321]Fairheartstrife[/member]
  16. 639.2260 (619,410 characters in 969 posts) - [member=1282]Felix[/member]
  17. 631.2398 (526,454 characters in 834 posts) - [member=563]Eerie[/member]
  18. 578.5316 (421,171 characters in 728 posts) - [member=214]Sprites[/member]
  19. 554.5832 (520,199 characters in 938 posts) - [member=830]Minato Arisato[/member]
  20. 543.0953 (1,395,755 characters in 2,570 posts) - [member=54]Arianna[/member]
  21. 527.8310 (299,808 characters in 568 posts) - [member=253]Loxetta[/member]
  22. 519.3371 (272,652 characters in 525 posts) - [member=624]Neutron Ronnie[/member]
  23. 506.5566 (6,502,161 characters in 12,836 posts) - [member=15]Xelloss[/member]
  24. 484.1531 (657,964 characters in 1,359 posts) - [member=26]OneWingedDemon[/member]
  25. 480.7556 (468,256 characters in 974 posts) - [member=1917]Seras Victoria[/member]
  26. 478.0456 (954,657 characters in 1,997 posts) - [member=1830]Kissmammal2000[/member]
  27. 469.3006 (1,667,425 characters in 3,553 posts) - [member=521]DrakeClawfang[/member]
  28. 466.8109 (822,054 characters in 1,761 posts) - [member=252]Lord Noctis[/member]
  29. 460.2372 (485,090 characters in 1,054 posts) - [member=625]LicoriceAllsorts[/member]
  30. 453.9847 (917,957 characters in 2,022 posts) - [member=887]Samantha Carter[/member]
  31. 451.8786 (312,700 characters in 692 posts) - [member=312]Atticus[/member]
  32. 446.8827 (312,371 characters in 699 posts) - [member=607]KissTheRain[/member]
  33. 444.1174 (571,135 characters in 1,286 posts) - [member=643]Vriska[/member]
  34. 434.4054 (257,168 characters in 592 posts) - [member=233]Russell[/member]
  35. 432.2187 (6,577,072 characters in 15,217 posts) - [member=9]V[/member]
  36. 428.9469 (1,210,917 characters in 2,823 posts) - [member=33]Oracle[/member]
  37. 425.0930 (521,164 characters in 1,226 posts) - [member=955]Sice[/member]
  38. 424.8490 (627,502 characters in 1,477 posts) - [member=64]Devil May Cry[/member]
  39. 423.2720 (620,940 characters in 1,467 posts) - [member=4]Dark and Divine[/member]
  40. 419.1654 (3,311,407 characters in 7,900 posts) - [member=248]Quexinos[/member]
  41. 415.2117 (376,597 characters in 907 posts) - [member=192]Cole McGrath[/member]
  42. 411.3246 (866,661 characters in 2,107 posts) - [member=542]Ulala[/member]
  43. 410.3222 (1,455,413 characters in 3,547 posts) - [member=1842]Garnet til Alexandros XVII[/member]
  44. 408.9954 (2,786,486 characters in 6,813 posts) - [member=8]dude in the background of guile's stage from sfii[/member]
  45. 408.8690 (1,776,127 characters in 4,344 posts) - [member=6]Lancelot[/member]
  46. 406.9366 (1,631,409 characters in 4,009 posts) - [member=547]Bodacious[/member]
  47. 402.0982 (282,675 characters in 703 posts) - [member=1338]Mr. Ite[/member]
  48. 396.8544 (386,933 characters in 975 posts) - [member=567]Black Canary[/member]
  49. 385.1948 (725,707 characters in 1,884 posts) - [member=1049]Ghost X[/member]
  50. 378.0432 (201,119 characters in 532 posts) - [member=561]Akemmi[/member]
select sum(length(pagetext))/posts AS charcount, sum(length(pagetext)) AS chars, user.posts, user.userid, user.username FROM user, post, thread WHERE post.threadid=thread.threadid AND user.userid=post.userid AND post.visible=1 AND thread.visible=1 AND user.posts>499 GROUP BY userid ORDER BY charcount desc

Again, I would probably be higher up if not for the now listening thread :monster:
 
Max Payne

Max Payne

Banned
AKA
Leon S. Kennedy,Terry Bogard, The Dark Knight, Dacon, John Marston, Teal'c
Why's that being posted here again?

Isn't there a thread for statistics?
 
Ⓐaron

Ⓐaron

Factiō Rēpūblicāna dēlenda est.
AKA
The Man, V
I thought someone proposed an award for wordiest poster. Maybe I'm misremembering. Most of the other stats I've posted were requested.

edit: Yeah, Tres proposed that "most pistoning penor" be considered a synonym for the person who writes the longest posts.
 
Ⓐaron

Ⓐaron

Factiō Rēpūblicāna dēlenda est.
AKA
The Man, V
I strongly doubt anyone here is that convincing of an actor.

I am pretty surprised that Neo Bahamut is that high on the list though. I don't remember him posting that much tl;dr bullshit.
 
Max Payne

Max Payne

Banned
AKA
Leon S. Kennedy,Terry Bogard, The Dark Knight, Dacon, John Marston, Teal'c
I do.

He and Ryu made out quite a bit
 
You must log in or register to reply here.
Top Bottom