As I was browsing through the statistics, I noticed we're about to have a significant anniversary. Several others have had this same anniversary, but it has gone unnoticed, as best as I can recall. I'm going to remedy that, right now.

tilly is about to celebrate his 500th post!

I've taken this opportunity to generate the statistics of the number of days at the monastery (defined by your Last here date minus your Since date), divided by the number of posts (for any number of posts above 0), ordered by that average. 

mysql> SELECT Name, 
              Writeups,
              DATE_FORMAT(Since,"%Y-%m-%d") AS Since,
              TO_DAYS(LastOn)-TO_DAYS(Since) AS NDays,
              WriteUps/(TO_DAYS(Laston)-TO_DAYS(Since)) AS Average 
         FROM UserInfo 
        WHERE WriteUps/(TO_DAYS(LastOn)-TO_DAYS(Since)) > 0
     ORDER BY Average DESC
        LIMIT 25;
+-----------+----------+------------+-------+---------+
| Name      | Writeups | Since      | NDays | Average |
+-----------+----------+------------+-------+---------+
| tilly     |      499 | 2000-08-04 |    65 |    7.68 |
| bp        |        7 | 2000-08-24 |     1 |    7.00 |
| merlyn    |      845 | 2000-04-25 |   166 |    5.09 |
| Smash8    |        5 | 2000-07-17 |     1 |    5.00 |
| trigger   |        4 | 2000-05-10 |     1 |    4.00 |
| jntn      |        4 | 2000-05-24 |     1 |    4.00 |
| tye       |      328 | 2000-07-14 |    86 |    3.81 |
| cgiguy    |        3 | 2000-03-22 |     1 |    3.00 |
| dlux      |        3 | 2000-08-01 |     1 |    3.00 |
| rlk       |       15 | 2000-10-03 |     5 |    3.00 |
| Adam      |      481 | 2000-04-25 |   165 |    2.92 |
| Ovid      |      354 | 2000-06-08 |   122 |    2.90 |
| chromatic |      826 | 1999-12-24 |   289 |    2.86 |
| btrott    |      651 | 2000-02-01 |   248 |    2.62 |
| turnstep  |      496 | 2000-03-24 |   198 |    2.51 |
| KM        |      318 | 2000-05-17 |   144 |    2.21 |
| jwielgos  |        2 | 2000-04-10 |     1 |    2.00 |
| Dinero    |        2 | 2000-06-19 |     1 |    2.00 |
| Dungan    |        6 | 2000-06-23 |     3 |    2.00 |
| ty        |        2 | 2000-06-25 |     1 |    2.00 |
| cynicgrrl |        2 | 2000-07-19 |     1 |    2.00 |
| clrobert  |        2 | 2000-07-20 |     1 |    2.00 |
| dduncan   |        2 | 2000-08-06 |     1 |    2.00 |
| lhoward   |      379 | 2000-03-17 |   205 |    1.85 |
| jcwren    |      295 | 2000-04-26 |   165 |    1.79 |
+-----------+----------+------------+-------+---------+
25 rows in set (0.07 sec)


--Chris

e-mail jcwren

Replies are listed 'Best First'.
RE: In honor of a pontiff...
by extremely (Priest) on Oct 09, 2000 at 03:19 UTC
    You should add "and WHERE WriteUps>25" in there. You catch more honeys with your fly closed. =)

    Grats tilly in advance, way too cool fer mere words, he's added to my understanding almost daily...

    --
    $you = new YOU;
    honk() if $you->love(perl)

[reply]
RE (tilly) 1: In honor of a pontiff...
by tilly (Archbishop) on Oct 09, 2000 at 06:17 UTC
    *blush*

    Until you put it like that, I had not realized exactly how heavily I post. I have several years of online experience, and I have always tended to post heavily. But wow... 

    $self->note("Post what you think won't be said by others.");

    [download]
[reply]
[d/l]
      use Monk;
$monk = new Monk "tilly";

$monk->blush_off();
$monk->note_external("Keep doing what you are doing.");

$monk->pat_on_back() x 10;

      [download]

      --
      $you = new YOU;
      honk() if $you->love(perl)

[reply]
[d/l]
RE: In honor of a pontiff...
by curtisb (Monk) on Oct 11, 2000 at 14:47 UTC
    This is a good thing!!! Maybe next time you can give a listing of everyone on the system, not just a select few. But, I agree that there should be some kind of incentive. curtisb
[reply]
      There are listings, if you've not been there already:

      Go to jcwren's home page.

      Follow the link to the PM stats page....

[reply]

Back to Perl Monks Discussion