Home

drupal.org

  • Mar 29

    Spammers by mailprovider

    On drupal.org we have much less spammers than other websites. One reason is the fact that we do not allow anonymous users to post anything and that every user needs a valid mail address in order to use his account.

    This poses the question: Which email providers to our spammers use?

    Luckily, this is rather easy to answer:

    mysql> select substring_index(substring_index(init, '@', -1), '.', 1) as provider, count(substring_index(substring_index(init, '@', -1), '.', 1)) as count from users where status = 0 and login != 0 group by provider order by count;

  • Feb 20

    Einmal mit Profis arbeiten!

    The title roughly translates to "Oh, to once work with true professionals!"

    This is something which I all too often have to think (and sometimes say aloud) when working on client projects. The nature of my work usually results in working for some kind of web agency which has secured a bigger Drupal project that they cannot handle alone. I then work with the agency's employees and other freelancers to complete whatever the project demands.

  • Aug 31

    34626 logged in users during August 2008

    select count(login) from users where login > 0 and from_unixtime(login) > '2008-08-01 00:00:00' and status= 1;
    +--------------+
    | count(login) |
    +--------------+
    | 34626 |
    +--------------+

    That means that 10% of all drupal.org user accounts are actively used. Not that bad at all.

    133257 is the result for the same query if you change the date to 1st of January. That is over50% of the accounts that exist on drupal.org and have been used at least once. Quite impressive.

  • Aug 31

    450 Abusers on drupal.org during August 2008

    mysql> select count(login) from users where login > 0 and from_unixtime(login) > '2008-08-01 00:00:00' and status = 0 ;
    +--------------+
    | count(login) |
    +--------------+
    | 450 |
    +--------------+

    The query gives us the number of users who logged in during August and are now blocked.

  • Aug 19

    Confessions of a one-time Project Module contributor

    Or, The Project Module and the Deadly Sins of Drupal Development

    Forgive me, Drupal, for I have sinned. It's been many months since my last confession.

    At the Drupal Association we've set upgrading drupal.org as our top priority this year, and much of that work depends on project.*.

    The Project module and kin are some of the most important pieces of drupal.org--and some of the most difficult. Six months after Drupal 6 came out, drupal.org still is still running Drupal 5, in large part because project.* is not yet upgraded.