Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.The new drupal.org main page as designed by Mark Boulton shows some community statistics above the map. The statistics are shown in a single sentence that reads:
310,721 people in 24 countries speaking 14 different languages are using Drupal.
- x people comes from the user table.
- y countries comes from the profile table.
- z language we don't know yet but it should probably come from a profile field that can be re-used for event matching. DamZ is creating an issue for the event matching but it currently doesn't exist yet. We should link to DamZ's issue from this issue.
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | activity-api.patch | 1.14 KB | mfb |
Comments
Comment #1
dwwThere's a patch for users, comments, and members of the doc team over at #431144-3: Clean API to provide statistics from core (now marked duplicate with this).
Comment #2
mfbI'm attaching the same patch that I had already uploaded on the newer issue.
This is a fairly slow query:
SELECT COUNT(DISTINCT p.value) FROM profile_values p INNER JOIN users u ON p.uid = u.uid WHERE p.fid = 17 AND u.status = 1 AND p.value NOT IN ('<not specified>', '');. Should this patch provide a caching layer or can we rely on block cache etc.?Comment #3
lisarex commentedMoving to the Redesign project
Comment #4
drummLooks like this was already added in theme preprocess, which is good enough.