@@ 330-333 (lines=4) @@ | ||
327 | $inner_date_query = "SELECT DISTINCT REG_date from $registration_table "; |
|
328 | $inner_where = " WHERE"; |
|
329 | //exclude events not authored by user if permissions in effect |
|
330 | if ( ! EE_Registry::instance()->CAP->current_user_can( 'ee_read_others_registrations', 'reg_per_event_report' ) ) { |
|
331 | $inner_date_query .= "LEFT JOIN $event_table ON ID = EVT_ID"; |
|
332 | $inner_where .= " post_author = " . get_current_user_id() . " AND"; |
|
333 | } |
|
334 | $inner_where .= " REG_date >= '$sql_date'"; |
|
335 | $inner_date_query .= $inner_where; |
|
336 | ||
@@ 425-428 (lines=4) @@ | ||
422 | $inner_date_query = "SELECT DISTINCT EVT_ID, REG_date from $registration_table "; |
|
423 | $inner_where = " WHERE"; |
|
424 | //exclude events not authored by user if permissions in effect |
|
425 | if ( ! EE_Registry::instance()->CAP->current_user_can( 'ee_read_others_registrations', 'reg_per_event_report' ) ) { |
|
426 | $inner_date_query .= "LEFT JOIN $event_table ON ID = EVT_ID"; |
|
427 | $inner_where .= " post_author = " . get_current_user_id() . " AND"; |
|
428 | } |
|
429 | $inner_where .= " REG_date >= '$sql_date'"; |
|
430 | $inner_date_query .= $inner_where; |
|
431 |