Author Topic: Let's hear it!  (Read 1969644 times)

0 Members and 114 Guests are viewing this topic.

Offline CrAz3D

  • Hero Member
  • *****
  • Posts: 10184
    • View Profile
Re: Let's hear it!
« Reply #5550 on: August 03, 2008, 09:55:54 pm »
I so fucking dominate here.

Offline truste1

  • Hero Member
  • *****
  • Posts: 1130
  • I haven't visited my profile!
    • View Profile
Re: Let's hear it!
« Reply #5551 on: August 03, 2008, 09:57:15 pm »
losers nobody cares about your life.
Ain't Life Grand?

Offline CrAz3D

  • Hero Member
  • *****
  • Posts: 10184
    • View Profile
Re: Let's hear it!
« Reply #5552 on: August 03, 2008, 10:52:00 pm »


My cousin's new car ... oh snap

Offline iago

  • Leader
  • Administrator
  • Hero Member
  • *****
  • Posts: 17914
  • Fnord.
    • View Profile
    • SkullSecurity
Re: Let's hear it!
« Reply #5553 on: August 04, 2008, 12:30:36 am »
Here, I changed up the query a bit:

mysql> select memberName, COUNT from (select ID_MEMBER, count(*) as COUNT from smf_messages where subject like "%Let's hear it!" group by ID_MEMBER) as a LEFT JOIN smf_members ON smf_members.ID_MEMBER = a.ID_MEMBER order by COUNT desc limit 0, 10;
+----------------+-------+
| memberName     | COUNT |
+----------------+-------+
| CrAz3D         |  1313 |
| NULL           |   851 |
| Newby          |   452 |
| Sidoh          |   266 |
| iago           |   216 |
| R.a.B.B.i.T    |   201 |
| BigAznDaddy    |   192 |
| leet_muffin    |   186 |
| InsaneJoey[e2] |   154 |
| Rule           |   139 |
+----------------+-------+
10 rows in set (1.32 sec)


NULL would be deleted users, almost certainly entirely Trust. :)

Offline BigAznDaddy

  • Hero Member
  • *****
  • Posts: 2163
    • View Profile
Re: Let's hear it!
« Reply #5554 on: August 04, 2008, 12:40:34 am »
k so as you guys know i am going to college next year and i have absolutly no money after tuition :( and i dont want to live at home so the solution: build a house. my dad owns a warehouse and it is like a 2 story building but is only used as one ( if that makes sense) anyways on top of the office i decided there was enough room to make 2 rooms one for me and one for my brother and it is going really good so far. i am almost completed. i just have a couple more walls to insulate and drywall and i still need to put in carpet or whatnot. but tomorrow i will post pictures.

Offline Ender

  • x86
  • Hero Member
  • *****
  • Posts: 2390
    • View Profile
Re: Let's hear it!
« Reply #5555 on: August 04, 2008, 04:16:58 am »
The disparity between 1st and 2nd, and 2nd and 3rd, is pretty hilarious.

It's pretty obvious that Trust and CrAz3d are so far ahead because they post their life problems (and have all the more to post!) but what about the disparity between 1st and 2nd?

After a little thought, I have concluded that CrAzed pulls ahead because he not only posts about his life problems, but he also posts pictures of trucks, cars, and mexicans.

Also, I think alcohol is involved. The ratio 1313 : 851 : 452, approximately 13 : 8 : 4 is pretty much the ratio that Craz3d, Trust, and Newby drink in.

Offline Blaze

  • x86
  • Hero Member
  • *****
  • Posts: 7136
  • Canadian
    • View Profile
    • Maide
Re: Let's hear it!
« Reply #5556 on: August 04, 2008, 04:42:09 am »
I'm only 15th highest (in this thread).  Trust's second account is already 19th.   :D

Also, lower is better, I think.  :)
And like a fool I believed myself, and thought I was somebody else...

Offline Super_X

  • I suck.
  • Hero Member
  • *****
  • Posts: 1340
  • I suck!
    • View Profile
Re: Let's hear it!
« Reply #5557 on: August 04, 2008, 07:56:06 am »
I'm only 15th highest (in this thread).  Trust's second account is already 19th.   :D

Also, lower is better, I think.  :)
I must be one of the best. :D

Offline Krazed

  • x86
  • Hero Member
  • *****
  • Posts: 1822
    • View Profile
Re: Let's hear it!
« Reply #5558 on: August 04, 2008, 08:35:44 am »
Now what's trust's new account at? That might bring him a little closer to crazed.
It is good to be good, but it is better to be lucky.

Offline iago

  • Leader
  • Administrator
  • Hero Member
  • *****
  • Posts: 17914
  • Fnord.
    • View Profile
    • SkullSecurity
Re: Let's hear it!
« Reply #5559 on: August 04, 2008, 11:19:17 am »
Here, top 50:

mysql> select memberName, COUNT from (select ID_MEMBER, count(*) as COUNT from smf_messages where subject like "%Let's hear it!" group by ID_MEMBER) as a LEFT JOIN smf_members ON smf_members.ID_MEMBER = a.ID_MEMBER order by COUNT desc limit 0, 50;
+----------------+-------+
| memberName     | COUNT |
+----------------+-------+
| CrAz3D         |  1313 |
| NULL           |   851 |
| Newby          |   452 |
| Sidoh          |   266 |
| iago           |   217 |
| R.a.B.B.i.T    |   201 |
| BigAznDaddy    |   193 |
| leet_muffin    |   186 |
| InsaneJoey[e2] |   154 |
| Rule           |   139 |
| Towelie[x86]   |   135 |
| deadly7        |   130 |
| dark_drake     |   121 |
| Hitmen         |   109 |
| Blaze          |   101 |
| Ender          |    97 |
| zorm           |    90 |
| Explicit[nK]   |    88 |
| truste1        |    84 |
| krazed         |    60 |
| Warrior        |    58 |
| DeuceNQuota    |    56 |
| Quik           |    55 |
| Killer360      |    52 |
| Ergot          |    38 |
| Camel          |    38 |
| Super_X        |    35 |
| DJO910         |    29 |
| Kaleeko        |    27 |
| Michael        |    21 |
| CetniK         |    21 |
| GameSnake      |    20 |
| unTactical     |    20 |
| TeHFoOoL       |    16 |
| warz           |    11 |
| igimo          |     9 |
| chuck          |     7 |
| Lobo           |     7 |
| xir            |     7 |
| MyndFyre       |     5 |
| disco          |     4 |
| Assault        |     4 |
| Topaz          |     4 |
| Brandon        |     3 |
| dlStevens      |     3 |
| SNiFFeR        |     3 |
| nslay          |     2 |
| Skywing        |     2 |
| Islanti        |     2 |
| ZeroX          |     2 |
+----------------+-------+
50 rows in set (1.77 sec)

Offline warz

  • Hero Member
  • *****
  • Posts: 1134
    • View Profile
    • chyea.org
Re: Let's hear it!
« Reply #5560 on: August 04, 2008, 02:17:29 pm »
make that 12.
http://www.chyea.org/ - web based markup debugger

Offline CrAz3D

  • Hero Member
  • *****
  • Posts: 10184
    • View Profile
Re: Let's hear it!
« Reply #5561 on: August 04, 2008, 03:00:17 pm »
This is still my thread, bitches.

Offline Camel

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
    • BNU Bot
Re: Let's hear it!
« Reply #5562 on: August 04, 2008, 03:47:01 pm »
Here, top 50:

You should make a mod which puts that at the top of any thread with more than X posts.

<Camel> i said what what
<Blaze> in the butt
<Camel> you want to do it in my butt?
<Blaze> in my butt
<Camel> let's do it in the butt
<Blaze> Okay!

Offline CrAz3D

  • Hero Member
  • *****
  • Posts: 10184
    • View Profile
Re: Let's hear it!
« Reply #5563 on: August 04, 2008, 04:08:33 pm »
Date with Stacey on Saturday, probably poker on Wednesday with her & friends.  yay!

Dinner/drinks tonight with friend who is back in town for a little while.

Offline iago

  • Leader
  • Administrator
  • Hero Member
  • *****
  • Posts: 17914
  • Fnord.
    • View Profile
    • SkullSecurity
Re: Let's hear it!
« Reply #5564 on: August 04, 2008, 04:48:34 pm »
Here, top 50:

You should make a mod which puts that at the top of any thread with more than X posts.

Bad idea. First, because it's heavy on the database. And second, because it would encourage people to post even more crap in already bloated threads.