function opigno_live_meetings_db_get_live_meetings_nids_from_group in Opigno Moxtra App 7

1 call to opigno_live_meetings_db_get_live_meetings_nids_from_group()

theme_opigno_live_meetings_course_lessons in modules/opigno_live_meetings/opigno_live_meetings.module

Theme callback: display course quizes and results.

File

modules/opigno_live_meetings/includes/opigno_live_meetings.db_queries.inc, line 20

Code

function opigno_live_meetings_db_get_live_meetings_nids_from_group($gid) {
  $req = db_select('node', 'n');
  $req
    ->condition('n.type', 'live_meeting', '=');
  $req
    ->fields('n', array(
    'nid',
  ));
  $req
    ->join('og_membership', 'ogm', 'n.nid = ogm.etid');
  $req
    ->condition('ogm.entity_type', 'node', '=');
  $req
    ->condition('ogm.gid', $gid, '=');
  $req = $req
    ->execute();
  $live_meetings_ids = array();
  while ($row = $req
    ->fetchAssoc()) {
    $live_meetings_ids[$row['nid']] = $row['nid'];
  }
  return $live_meetings_ids;
}