function _signup_event_admin_sql in Signup 5.2

Same name in this branch

1. 5.2 includes/event.5x-1.inc \_signup_event_admin_sql()
2. 5.2 includes/event.5x-2.inc \_signup_event_admin_sql()

Same name and namespace in other branches

1. 6.2 includes/event.6x-2.inc \_signup_event_admin_sql()
2. 6 includes/event.6x-2.inc \_signup_event_admin_sql()
3. 7 includes/event.6x-2.inc \_signup_event_admin_sql()

Return value

Array of SQL clauses for admin overview page query builder.

1 call to _signup_event_admin_sql()

signup_admin_sql in includes/scheduler.inc

File

includes/event.5x-1.inc, line 46

Code required to support version 5.x-1.* of the event module.

Code

function _signup_event_admin_sql($content_type = NULL) {

  // Since all event node types store their event data in the same table, we
  // need to make sure we only JOIN on this table once.  It doesn't matter
  // which node type we use to add this JOIN.
  static $did_event_join = FALSE;
  if ($did_event_join) {
    return array();
  }
  $did_event_join = TRUE;
  $fields = array(
    'e.event_start',
    'e.timezone',
  );
  return array(
    'fields' => $fields,
    // All of the fields should go directly into GROUP BY.
    'group_by' => $fields,
    'joins' => array(
      'LEFT JOIN {event} e ON e.nid = n.nid',
    ),
  );
}