function og_views_handler_field_og_uid_groups::pre_render in Organic groups 6

Same name and namespace in other branches

1. 6.2 modules/og_views/includes/og_views_handler_field_og_uid_groups.inc \og_views_handler_field_og_uid_groups::pre_render()

Query in pre_render to grab what we need.

File

modules/og_views/includes/og_views_handler_field_og_uid_groups.inc, line 32

Class

og_views_handler_field_og_uid_groups

Field handler for displaying a list of groups for a user.

Code

function pre_render($values) {
  $uids = array();
  foreach ($values as $row) {
    if (!empty($row->{$this->field_alias})) {
      $uids[] = $row->{$this->field_alias};
    }
  }
  if (!empty($uids)) {
    $placeholders = db_placeholders($uids, 'int');
    $result = db_query(db_rewrite_sql("SELECT n.nid, n.title, ogu.uid FROM {node} n JOIN {og_uid} ogu ON ogu.nid = n.nid WHERE ogu.uid IN ({$placeholders}) AND n.status = 1"), $uids);
    while ($row = db_fetch_object($result)) {
      $this->items[$row->uid][$row->nid] = l($row->title, "node/{$row->nid}");
    }
  }
}