Xboxic Stats

[Curry]

Thought you guys might find this funny, the so-far-alltime list of top commenters on the frontpage:

+-----------------------+------+
| comment_author        | cnt  |
+-----------------------+------+
| TRIGGER M4N           | 1114 |
| Curry                 |  892 |
| Doug                  |  823 |
| Nino                  |  748 |
| The_Glovner           |  614 |
| trj156                |  425 |
| Studley               |  377 |
| Chris                 |  365 |
| Rival24               |  264 |
| aries                 |  232 |
| The M.A.R.T.          |  211 |
| ARCHA1C               |  207 |
| YLA G                 |  181 |
| Rossko UK             |  173 |
| kobejonez             |  166 |
| Hoffer                |  161 |
| McGrude               |  158 |
| Number13              |  138 |
| mtbjunkie             |  127 |
| Doug the Aquacell Guy |  120 |
| Messiah               |  114 |
| ONI 23                |  110 |
| Cage                  |  108 |
| Neejoh                |  104 |
| AN ALIEN              |   95 |
| j0k3r360              |   89 |
| Dirty Duck            |   85 |
| VerbalKint27          |   84 |
| Mattias               |   83 |
| DSK UK                |   81 |
| D4V3                  |   76 |
| Bob                   |   75 |
| soul2soul             |   75 |
| Xploited13            |   74 |
| pmpboarder            |   70 |
| Sean                  |   66 |
| aces high             |   65 |
| TobiM2000             |   64 |
| seth                  |   61 |
| Ponder416             |   61 |
| The_Plesident         |   61 |
| jmel                  |   60 |
| mutigen               |   59 |
| Norman Bates          |   58 |
| George Podge          |   57 |
| Jason                 |   56 |
| Karel_ende            |   55 |
| Wekko                 |   53 |
| Todd                  |   51 |
| Eric                  |   49 |
+-----------------------+------+
50 rows in set (0.23 sec)

If you'd like some more wacky stats, let me know and I'll see what I can cook up from the database

btw for the forum you can simply go to the Member List and sort by postcount

[Zerodisorder]

Wow, TRIGGER M4N, thats hardcore lol.

[Cage]

Yes! I'm not in the top 3 of this one (mods excluded)

Edit: Just noticed; I've reached the 500 posts mark on the forum! Beat you to it Mr Moen! Now, where's the secret pr0n thread??

[Zerodisorder]

Grats on the 500 posts

[Nekro Neko]

cool stat, but I haven't spammed enough to get on there yet.

[Nino]

TRIGGER M4N's scary.

 spoiler:

we love him regardless

[Curry]

Some more stuff.... total number of characters posted in frontpage comments:

+-----------------------+--------+
| comment_author        | total  |
+-----------------------+--------+
| Curry                 | 172146 |
| The_Glovner           | 132039 |
| TRIGGER M4N           | 113312 |
| Doug                  |  92179 |
| Nino                  |  87135 |
| phentermine           |  80391 |
| Studley               |  69869 |
| aries                 |  65789 |
| Chris                 |  65571 |
| The M.A.R.T.          |  64547 |
| ARCHA1C               |  40135 |
| trj156                |  36897 |
| Hoffer                |  36384 |
| Number13              |  28894 |
| The_Plesident         |  25861 |
| McGrude               |  25551 |
| mtbjunkie             |  25387 |
| Rossko UK             |  22779 |
| kobejonez             |  21412 |
| Bill                  |  21280 |
| seth                  |  20568 |
| Bob                   |  20354 |
| Doug the Aquacell Guy |  19731 |
| Rival24               |  19324 |
| Mattias               |  18669 |
+-----------------------+--------+
25 rows in set (0.25 sec)

Most elaborate posters (highest average length) for posters having at least 5 comments:

+-----------------------------+-----------+-----+
| comment_author              | average   | cnt |
+-----------------------------+-----------+-----+
| Whimsy                      | 1701.0000 |   6 |
| Chris Taylor                | 1601.6667 |   6 |
| SW 1540                     |  988.3333 |   9 |
| lovesgame                   |  719.5000 |  10 |
| julesthejackal              |  711.7500 |  12 |
| FlozzyFlosborn              |  661.0000 |  16 |
| Hell2Pay                    |  534.4286 |   7 |
| ElmoFox                     |  509.4000 |  20 |
| E2K                         |  488.5500 |  20 |
| theartistformerlyknownasE2K |  484.4000 |  10 |
| Jeroen Mulder               |  472.5714 |   7 |
| ron workman                 |  470.6250 |   8 |
| fulgore                     |  463.0909 |  11 |
| SidearmS                    |  427.7895 |  19 |
| slugg                       |  424.7778 |   9 |
| The_Plesident               |  423.9508 |  61 |
| the plesident               |  411.0000 |  31 |
| Philip                      |  405.6667 |   6 |
| Holloguts                   |  387.8333 |   6 |
| Hologuts                    |  386.5000 |  10 |
| Mixelpix                    |  373.5000 |   6 |
| Agent MOO                   |  368.4545 |  11 |
| Zahadoom                    |  360.1714 |  35 |
| Clay                        |  348.9524 |  21 |
| seth                        |  337.1803 |  61 |
+-----------------------------+-----------+-----+
25 rows in set (0.27 sec)

On that first query I forgot to filter unapproved comments btw, hence the phentermine poster

[Zerodisorder]

I suck, I'm not on any of those lists lol

[trj156]

hahaha e2k is still on one of them. here are some more stats i found:

Xboxic's Dumbest Assholes:
1. E2K
2. i dont even know

[Rival24]

OMG, I'm on the bottom of that first list

[Curry]

Originally Posted by trj156

hahaha e2k is still on one of them. here are some more stats i found:

Xboxic's Dumbest Assholes:
1. E2K
2. i dont even know

You can probably fill in E2k for the next 9 spots as well

[Nino]

I don't think the_president is getting proper credits if you give E2K all 10 of the spots.

[Cage]

For shure! the_plesident earned his spot in the top 2. I'm still thinking it's E2K who has moved to another town so he can post again with a different IP

[Rossko_UK]

Wow, thats cool. Trig you spammer! Got any more facts like that Curry, I find it really intresting!

[Rival24]

Originally Posted by Rossko_UK

Wow, thats cool. Trig you spammer! Got any more facts like that Curry, I find it really intresting!

He chickens out on the tough SQL statements

[Curry]

Originally Posted by Rossko_UK

Wow, thats cool. Trig you spammer! Got any more facts like that Curry, I find it really intresting!

Shoot what you'd like to know, I can extract most things from the database

[Chris]

How amazing am I? Can you find that in your stats?

[TRIGGER M4N]

Wow, what can I say?
I can explain..?
I spend most day inside, then spend most of the night outside, so during the day, I like doing what I like doing... Computer games, and this site is far the best!
School's back now though, so I doubt I will be top for any longer.

[Rival24]

Originally Posted by TRIGGER M4N

Wow, what can I say?
I can explain..?
I spend most day inside, then spend most of the night outside, so during the day, I like doing what I like doing... Computer games, and this site is far the best!
School's back now though, so I doubt I will be top for any longer.

[TRIGGER M4N]

The rate The_Glovener is going, he'll beat me.
The funny this is, I am also the most active non-crew member forum member!
Though Cage is quickly catching up!

[Curry]

Total amount of spam posted in frontpage comments, in bytes:

+------------------------------+
| sum(length(comment_content)) |
+------------------------------+
|                       890490 |
+------------------------------+
1 row in set (0.04 sec)

That's in 1525 out of 18192 total comments btw.

[Nino]

~70KB of spam? ZOMG LAWSUIT!

[Curry]

That's 900KB sweetheart.

Ow and we get MUCH MORE spam than this, but most of it is automatically deleted when attempted

[Nino]

Calculations, calculations...

[trj156]

Originally Posted by Cage

For shure! the_plesident earned his spot in the top 2. I'm still thinking it's E2K who has moved to another town so he can post again with a different IP

you are probably right. he probably got a sex change as well.

hey curry, can you find out how much time people have spent viewing the site?