function outline_designer_og_books in Outline Designer 7

Same name and namespace in other branches

1. 6.2 modules/outline_designer_og/outline_designer_og.module \outline_designer_og_books()
2. 6 outline_designer_og/outline_designer_og.module \outline_designer_og_books()

@todo Please document this function.

See also

http://drupal.org/node/1354

1 string reference to 'outline_designer_og_books'

outline_designer_og_menu in outline_designer_og/outline_designer_og.module

Implements hook_menu().

File

outline_designer_og/outline_designer_og.module, line 117

Code

function outline_designer_og_books($group_node) {
  $sql = "SELECT b.bid\n          FROM {book} b\n          JOIN {og_ancestry} o\n          ON b.bid = o.nid\n          WHERE o.group_nid = %d\n          GROUP BY b.bid";
  $bids = db_query("SELECT b.bid\n          FROM {book} b\n          JOIN {og_ancestry} o\n          ON b.bid = o.nid\n          WHERE o.group_nid = :o.group_nid\n          GROUP BY b.bid", array(
    ':o.group_nid' => $group_node->nid,
  ));
  $books = array();
  while ($row = db_fetch_array($bids)) {
    $books[$row['bid']] = node_load($row['bid']);
  }
  $item_list = array();
  foreach ($books as $book) {
    $item_list[] = l($book->title, "outline_designer/book/" . $book->nid);
  }
  return theme('item_list', array(
    'items' => $item_list,
    'title' => t("Books to rearrange in %group_name", array(
      '%group_name' => $group_node->title,
    )),
  ));
}