function gallery_assist_item_load in Gallery Assist 7

File

./gallery_assist.module, line 361

Extend drupal with gallery functionalities. Manage galleries.

Code

function gallery_assist_item_load($pid) {
  $node = node_load(arg(1));
  $gallery_assist_item = !empty($node->ga_items[$pid]) ? $node->ga_items[$pid] : NULL;
  if ($pid && empty($gallery_assist_item)) {
    $query = db_select('gallery_assist_item', 'p');
    $query
      ->join('gallery_assist_translated', 't', 'p.pid = t.pid');
    $query
      ->fields('p');
    $query
      ->fields('t', array(
      'lang',
      'ptitle',
      'palt',
      'pdescription',
      'format',
    ));
    $query
      ->condition('p.pid', $pid);
    $query
      ->condition('p.gref', $node->ga_gref);
    $result = $query
      ->execute();
    foreach ($result as $rec) {
      $gallery_assist_item = $rec;
    }
  }
  return $gallery_assist_item;
}