exclude unpublished nodes from admin signup list

I have a client using 5.x.2.7 who wanted to exclude past events from the signup admin list page (admin/content/signup).

I modified the signup_admin_form_sql() function to exclude unpublished nodes:

1) Add a where clause to $admin_common_sql array:

    'where' => array(
      'n.status = 1',
    ),

2) Add an INNER JOIN to $sql_count string:

  $sql_count = "SELECT COUNT(s.nid) FROM {signup} s INNER JOIN {node} n ON n.nid = s.nid";

Sorry, I didn't have time to roll a patch. Using the provided code should make revising the code base a breeze.