When viewing some signup enabled node with the permission to see all signups there is a list of users currently signed up. This list does not seem to be sorted in any particular way. To me it seems intuitive to sort it by the sign up order, or by username. Or even better make it possible to choose.
I could probably supply a patch for this, such that the default sort order can be chosen in the settings., but I am not very familiar with the whole drupal development system. And there is no need to add extra complexity if I am the only one thinking this is an issue.
However a quick change to make it sort by signup time:
Line 763 From:
$registered_signups = db_query("SELECT u.uid, u.name, s.signup_time, s.form_data FROM {signup_log} s INNER JOIN {users} u ON u.uid = s.uid WHERE s.nid = %d AND u.uid <> 0", $node->nid);
To:
$registered_signups = db_query("SELECT u.uid, u.name, s.signup_time, s.form_data FROM {signup_log} s INNER JOIN {users} u ON u.uid = s.uid WHERE s.nid = %d AND u.uid <> 0 ORDER BY s.signup_time", $node->nid);
And
Line 1444 From:
$result = db_query("SELECT u.uid, u.name, s.anon_mail, s.signup_time, s.form_data FROM {signup_log} s INNER JOIN {users} u ON u.uid = s.uid WHERE s.nid =%d", $node->nid);
To:
$result = db_query("SELECT u.uid, u.name, s.anon_mail, s.signup_time, s.form_data FROM {signup_log} s INNER JOIN {users} u ON u.uid = s.uid WHERE s.nid =%d ORDER BY s.signup_time", $node->nid);
Comments
Comment #1
dwwThe best way to solve this is by having the list of users who signed up for a node as a view. See #243035: How to list all signed up users in a view?? (which will be included in version 5.x-2.5).
Comment #2
dwwwhoops, forgot to change the status...