function outline_designer_og_books in Outline Designer 6.2

Same name and namespace in other branches

1. 6 outline_designer_og/outline_designer_og.module \outline_designer_og_books()
2. 7 outline_designer_og/outline_designer_og.module \outline_designer_og_books()

1 string reference to 'outline_designer_og_books'

outline_designer_og_menu in modules/outline_designer_og/outline_designer_og.module

Implementation of hook_menu().

File

modules/outline_designer_og/outline_designer_og.module, line 110

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($sql, $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', $item_list, t("Books to rearrange in %group_name", array(
    '%group_name' => $group_node->title,
  )));
}