book.module 21.6 KB
Newer Older
Dries's avatar
 
Dries committed
1
<?php
2
// $Id$
Dries's avatar
 
Dries committed
3

Dries's avatar
   
Dries committed
4
5
6
function book_node($field) {
  global $user;

Dries's avatar
   
Dries committed
7
  $info["name"] = t("book page");
Dries's avatar
   
Dries committed
8
  $info["description"] = t("A book is a collaborative writing effort: users can collaborate writing the pages of the book, positioning the pages in the right order, and reviewing or modifying pages previously written.  So when you have some information to share or when you read a page of the book and you didn't like it, or if you think a certain page could have been written better, you can do something about it.");
Dries's avatar
   
Dries committed
9
10
11
12
13

  return $info[$field];
}

function book_access($op, $node) {
Dries's avatar
   
Dries committed
14
  global $user;
Dries's avatar
   
Dries committed
15
16

  if ($op == "view") {
Dries's avatar
   
Dries committed
17
18
19
20
21
22
23
24
    /*
    ** Everyone can access all published book pages whether these pages
    ** are still waiting for approval or not.  We might not always want
    ** to display pages that are waiting for approval, but we take care
    ** of that problem in the book_view() function.
    */

    return $node->status;
Dries's avatar
   
Dries committed
25
26
  }

Dries's avatar
   
Dries committed
27
  if ($op == "create") {
Dries's avatar
   
Dries committed
28
29
30
31
32
33
    /*
    ** Only registered users can create book pages.  Given the nature
    ** of the book module this is considered to be a good/safe idea.
    */

    return $user->uid;
Dries's avatar
   
Dries committed
34
35
36
  }

  if ($op == "update") {
Dries's avatar
   
Dries committed
37
    /*
Dries's avatar
   
Dries committed
38
39
40
41
42
43
44
    ** Only registered users can update book pages.  Given the nature
    ** of the book module this is considered to be a good/safe idea.
    ** One can only upate a book page if there are no suggested updates
    ** of that page waiting for approval, when it is not a PHP-page and
    ** as long as the "create new revision"-bit is set.  That is, only
    ** updates that don't overwrite the current or pending information
    ** are allowed.
Dries's avatar
   
Dries committed
45
    */
Dries's avatar
   
Dries committed
46
47

    return $user->uid && !$node->moderate && !$node->format && $node->revision;
Dries's avatar
   
Dries committed
48
  }
Dries's avatar
   
Dries committed
49
50
}

Dries's avatar
   
Dries committed
51
function book_save($op, $node) {
Dries's avatar
   
Dries committed
52
  global $user, $REQUEST_URI;
Dries's avatar
   
Dries committed
53
54
55
56
57
58

  if ($op == "approve") {
    return array("status" => 1);
  }

  if ($op == "create") {
Dries's avatar
   
Dries committed
59
60
61
62
63
64
    if (user_access("adminster nodes")) {
      return array("format", "parent", "weight");
    }
    else {
      return array("format", "moderate" => 1, "parent", "promote" => 0, "status" => 1, "weight");
    }
Dries's avatar
   
Dries committed
65
66
67
68
69
70
71
  }

  if ($op == "decline") {
    return array("status" => 0);
  }

  if ($op == "update") {
Dries's avatar
   
Dries committed
72
    if (strstr($REQUEST_URI, "module.php?mod=node&op=edit")) {
Dries's avatar
   
Dries committed
73
      /*
Dries's avatar
   
Dries committed
74
75
      ** If a regular user updates a book page, we always create a new
      ** revision.  All new revisions have to be approved (moderation)
Dries's avatar
   
Dries committed
76
      ** and are not promoted by default.  See also: book_load().
Dries's avatar
   
Dries committed
77
78
      */

Dries's avatar
   
Dries committed
79
      return array("created" => time(), "format", "moderate" => 1, "parent", "promote" => 0, "score" => 0, "status" => 1, "users" => "", "revisions", "votes" => 0, "weight");
Dries's avatar
   
Dries committed
80
    }
Dries's avatar
   
Dries committed
81
    else if (user_access("adminster nodes")) {
Dries's avatar
   
Dries committed
82
      /*
Dries's avatar
   
Dries committed
83
84
85
86
87
      ** If a node administrator updates a book page, we don't create a
      ** new revision unless we are explicitly instructed to. If a node
      ** administrator updates a book page using the "update this book
      ** page"-link (like regular users do) then he'll be treated as a
      ** regular user.
Dries's avatar
   
Dries committed
88
89
      */

Dries's avatar
   
Dries committed
90
      return array("format", "parent", "weight");
Dries's avatar
   
Dries committed
91
92
93
94
95
    }
  }

}

Dries's avatar
   
Dries committed
96
function book_link($type, $node = 0, $main = 0) {
Dries's avatar
   
Dries committed
97
98
  if ($type == "page" && user_access("access content")) {
    $links[] = "<a href=\"module.php?mod=book\">". t("collaborative book") ."</a>";
Dries's avatar
   
Dries committed
99
  }
Dries's avatar
   
Dries committed
100

Dries's avatar
   
Dries committed
101
102
103
104
  if ($type == "admin" && user_access("administer nodes")) {
    $links[] = "<a href=\"admin.php?mod=book\">". t("collaborative book") ."</a>";
  }

Dries's avatar
   
Dries committed
105
  if ($type == "node" && $node->type == "book" && book_access("update", $node)) {
Dries's avatar
   
Dries committed
106
107
108
    $links[] = "<a href=\"module.php?mod=node&op=edit&id=$node->nid\">". t("update this book page") ."</a>";
  }

Dries's avatar
   
Dries committed
109
  return $links ? $links : array();
Dries's avatar
   
Dries committed
110
111
}

Dries's avatar
   
Dries committed
112
function book_load($node) {
Dries's avatar
   
Dries committed
113
114
  global $user, $REQUEST_URI;

Dries's avatar
   
Dries committed
115
  $book = db_fetch_object(db_query("SELECT format, parent, weight FROM book WHERE nid = '$node->nid'"));
Dries's avatar
   
Dries committed
116
117

  if (strstr($REQUEST_URI, "module.php?mod=node&op=edit")) {
Dries's avatar
   
Dries committed
118

Dries's avatar
   
Dries committed
119
120
121
122
123
124
125
    /*
    ** If a user is about to update a book page, we overload some
    ** fields to reflect the changes.  We use the $REQUEST_URI to
    ** dectect this as we don't want to interfer with updating a
    ** book page through the admin pages.  See also: book_save().
    */

Dries's avatar
   
Dries committed
126
127
128
129
130
131
132
133
    if ($user->uid) {
      $book->uid = $user->uid;
      $book->name = $user->name;
    }
    else {
      $book->uid = 0;
      $book->name = "";
    }
Dries's avatar
   
Dries committed
134
  }
Dries's avatar
   
Dries committed
135

Dries's avatar
   
Dries committed
136
137
138
139
140
  /*
  ** We set the revision field to indicate that we have to create
  ** a new revision when updating this book page.  We enable this
  ** always such that the "update this book page"-links appear.
  */
Dries's avatar
   
Dries committed
141

Dries's avatar
   
Dries committed
142
  $book->revision = 1;
Dries's avatar
   
Dries committed
143

Dries's avatar
   
Dries committed
144
  return $book;
Dries's avatar
   
Dries committed
145
146
}

Dries's avatar
   
Dries committed
147
function book_insert($node) {
Dries's avatar
   
Dries committed
148
149
150
151
152
153
  if (!user_access("administer nodes")) {
    $node->format = 0;
    $node->weight = 0;
  }

  db_query("INSERT INTO book (nid, format, parent, weight) VALUES ('$node->nid', '$node->format', '$node->parent', '$node->weight')");
Dries's avatar
   
Dries committed
154
}
Dries's avatar
   
Dries committed
155

Dries's avatar
   
Dries committed
156
function book_update($node) {
Dries's avatar
   
Dries committed
157
158
159
160
161
162
  if (!user_access("administer nodes")) {
    $node->format = 0;
    $node->weight = 0;
  }

  db_query("UPDATE book SET format = '$node->format', parent = '$node->parent', weight = '$node->weight' WHERE nid = '$node->nid'");
Dries's avatar
   
Dries committed
163
}
Dries's avatar
   
Dries committed
164

165
function book_delete(&$node) {
Dries's avatar
   
Dries committed
166
  db_query("DELETE FROM book WHERE nid = '$node->nid'");
Dries's avatar
   
Dries committed
167
168
}

169
function book_form(&$node, &$help, &$error) {
Dries's avatar
   
Dries committed
170
  global $user, $op;
Dries's avatar
   
Dries committed
171
172

  $output .= form_select(t("Parent"), "parent", $node->parent, book_toc(), t("The parent subject or category the page belongs in."));
Dries's avatar
   
Dries committed
173

Dries's avatar
   
Dries committed
174
175
176
177
178
179
180
181
182
  if ($node->format) {
    if ($op != t("Preview")) {
      $node->body = addslashes($node->body);
    }
  }
  else {
    if ($node->teaser) {
      $output .= form_textarea(t("Teaser"), "teaser", $node->teaser, 60, 5, $error["teaser"]);
    }
Dries's avatar
   
Dries committed
183
184
185
  }

  $output .= form_textarea(t("Body"), "body", $node->body, 60, 20, t("Allowed HTML tags") .": ". htmlspecialchars(variable_get("allowed_html", "")));
Dries's avatar
   
Dries committed
186
187
188
  $output .= form_textarea(t("Log message"), "history", $node->history, 60, 5, t("An explanation of the additions or updates being made to help the group understand your motivations."));

  if (user_access("administer nodes")) {
Dries's avatar
   
Dries committed
189
190
    $output .= form_select(t("Weight"), "weight", $node->weight, array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30), t("The heavier pages will sink and the lighter pages will be positioned nearer the top."));
    $output .= form_select("Type", "format", $node->format, array(0 => "HTML / text", 1 => "PHP"));
Dries's avatar
   
Dries committed
191
192
193
194
195
196
197
  }
  else {

    /*
    ** Carry out some explanation or submission guidelines:
    */

Dries's avatar
   
Dries committed
198
199
    $help = book_node("description");

Dries's avatar
   
Dries committed
200
201
202
203
204
205
206
207
208
209
210
    /*
    ** If a regular user updates a book page, we create a new revision
    ** authored by that user:
    */

    $output .= form_hidden("revision", 1);
  }

  return $output;
}

Dries's avatar
   
Dries committed
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
function book_node_link($node = 0) {
  global $user, $op, $edit;

  if ($node->type != "book") {

    if ($edit["nid"]) {
      $node = node_load(array("nid" => $edit["nid"]));
    }

    if ($op == t("Add to book outline")) {
      db_query("INSERT INTO book (nid, parent, weight) VALUES ('$node->nid', '". check_query($edit["parent"]) ."', '". check_query($edit["weight"]) ."')");
      $output .= status(t("added the node to the book."));
    }

    if ($op == t("Update book outline")) {
      db_query("UPDATE book SET parent = '". check_query($edit["parent"]) ."', weight = '". check_query($edit["weight"]) ."' WHERE nid = '$node->nid'");
      $output .= status(t("updated the book outline."));
    }

    if ($op == t("Remove from book outline")) {
      db_query("DELETE FROM book WHERE nid = '$node->nid'");
      $output .= status(t("removed the node form the book."));
    }

    $output .= "<h3>". t("Edit book outline") ."</h3>";

    if ($edit["nid"]) {
      $page = db_fetch_object(db_query("SELECT * FROM book WHERE nid = '$node->nid'"));

      $output .= form_select(t("Parent"), "parent", $page->parent, book_toc(), t("The parent subject or category the page belongs in."));
      $output .= form_select(t("Weight"), "weight", $page->weight, array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30), t("The heavier pages will sink and the lighter pages will be positioned nearer the top."));

      if ($page->nid) {
        $output .= form_submit(t("Update book outline"));
        $output .= form_submit(t("Remove from book outline"));
      }
      else {
        $output .= form_submit(t("Add to book outline"));
      }

    }
    else {
      $output .= form_submit(t("Edit book outline"));
    }

    $output .= form_hidden("nid", $node->nid);

    return form($output, "post", "admin.php?mod=book&op=outline");
  }
}

Dries's avatar
   
Dries committed
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
/*
** Return the the most recent revision that matches the specified
** conditions.
*/

function book_revision_load($page, $conditions = array()) {

  $revisions = array_reverse(node_revision_list($page));

  foreach ($revisions as $revision) {

    /*
    ** Extract the specified revision:
    */

    $node = node_revision_load($page, $revision);

    /*
    ** Check to see if the conditions are met:
    */

    $status = 1;

    foreach ($conditions as $key => $value) {
      if ($node->$key != $value) {
        $status = 0;
      }
    }

    if ($status) {
      return $node;
    }
  }
}

/*
** Return the path (call stack) to a certain book page.
*/

Dries's avatar
   
Dries committed
301
function book_location($node, $nodes = array()) {
Dries's avatar
   
Dries committed
302
  $parent = db_fetch_object(db_query("SELECT n.nid, n.title, b.parent FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.nid = '$node->parent'"));
Dries's avatar
   
Dries committed
303
304
305
306
307
308
309
  if ($parent->title) {
    $nodes = book_location($parent, $nodes);
    array_push($nodes, $parent);
  }
  return $nodes;
}

Dries's avatar
   
Dries committed
310
311
312
313
314
315
316
317
function book_body($node) {
  global $theme, $op;

  if ($node->format == 1) {
    /*
    ** Make sure only authorized users can preview PHP pages.
    */

Dries's avatar
   
Dries committed
318
319
320
321
322
323
324
    if ($op == t("Preview")) {
      if (user_access("adminster nodes")) {
        $node->body = stripslashes($node->body);  // see also book_form()
      }
      else {
        return;
      }
Dries's avatar
   
Dries committed
325
326
327
328
329
330
331
332
    }

    ob_start();
    eval($node->body);
    $output = ob_get_contents();
    ob_end_clean();
  }
  else {
Dries's avatar
   
Dries committed
333
    $output = check_output(filter($node->body), 1);
Dries's avatar
   
Dries committed
334
335
336
337
338
  }

  return $output;
}

Dries's avatar
   
Dries committed
339
function book_view($node, $main = 0) {
Dries's avatar
   
Dries committed
340
341
342
343
  global $theme, $mod;

  /*
  ** Always display the most recently approved revision of a node
Dries's avatar
   
Dries committed
344
345
  ** (if any) unless we have to display this page in the context of
  ** the moderation queue.
Dries's avatar
   
Dries committed
346
347
348
  */

  if ($node->moderate && $mod != "queue") {
Dries's avatar
   
Dries committed
349
350
351
352
353
    $revision = book_revision_load($node, array("moderate" => 0, "status" => 1));

    if ($revision) {
      $node = $revision;
    }
Dries's avatar
   
Dries committed
354
355
  }

Dries's avatar
   
Dries committed
356
357
358
359
360
361
362
  /*
  ** Extract the page body.  If body is dynamic (using PHP code), the body
  ** will be generated.
  */

  $node->body = book_body($node);

Dries's avatar
   
Dries committed
363
364
365
366
367
  /*
  ** Display the node.  If not displayed on the main page, we render
  ** the node as a page in the book with extra links to the previous
  ** and the next page.
  */
Dries's avatar
 
Dries committed
368

Dries's avatar
   
Dries committed
369
370
  if ($main) {
    $theme->node($node, $main);
Dries's avatar
   
Dries committed
371
  }
Dries's avatar
   
Dries committed
372
  else {
Dries's avatar
   
Dries committed
373
374
375
376
    /*
    ** Construct the "next" and "previous" links:
    */

Dries's avatar
   
Dries committed
377
    if ($node->nid && $node->parent) {
378
379
      $next = db_fetch_object(db_query("SELECT n.nid, n.title FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.status = 1 AND b.parent = '$node->parent' AND (b.weight > '$node->weight' OR (b.weight = '$node->weight' AND n.title > '". check_query($node->title) ."')) AND (n.moderate = 0 OR n.revisions != '') ORDER BY b.weight ASC, n.title ASC"));
      $prev = db_fetch_object(db_query("SELECT n.nid, n.title FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.status = 1 AND b.parent = '$node->parent' AND (b.weight < '$node->weight' OR (b.weight = '$node->weight' AND n.title < '". check_query($node->title) ."')) AND (n.moderate = 0 OR n.revisions != '') ORDER BY b.weight DESC, n.title DESC"));
Dries's avatar
   
Dries committed
380
    }
Dries's avatar
   
Dries committed
381

Dries's avatar
   
Dries committed
382
    $output .= "<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" width=\"100%\">";
Dries's avatar
   
Dries committed
383

Dries's avatar
   
Dries committed
384
385
    if ($node->title) {
      foreach (book_location($node) as $level) {
Dries's avatar
   
Dries committed
386
        $location .= "$indent <a href=\"node.php?id=$level->nid\">$level->title</a><br />";
Dries's avatar
   
Dries committed
387
388
        $indent .= "-";
      }
Dries's avatar
   
Dries committed
389

Dries's avatar
   
Dries committed
390
      $output .= " <tr><td colspan=\"3\">$location</td></tr>";
Dries's avatar
   
Dries committed
391
392
      $output .= " <tr><td colspan=\"3\"><hr /></td></tr>";
      $output .= " <tr><td colspan=\"3\"><b><big>". check_output($node->title) ."</big></b>". ($node->body ? "<br /><small><i>". sprintf(t("Last updated by %s on %s"), format_name($node), format_date($node->created)) ."</i></small> " : "") ."</td></tr>";
Dries's avatar
   
Dries committed
393
    }
Dries's avatar
   
Dries committed
394

Dries's avatar
   
Dries committed
395
    if ($node->body) {
Dries's avatar
   
Dries committed
396
      $output .= " <tr><td colspan=\"3\"><br />$node->body</td></tr>";
Dries's avatar
   
Dries committed
397
    }
Dries's avatar
 
Dries committed
398

Dries's avatar
   
Dries committed
399
    if ($node->nid) {
Dries's avatar
   
Dries committed
400
      $output .= " <tr><td colspan=\"3\"><br />". book_tree($node->nid) ."</td></tr>";
Dries's avatar
   
Dries committed
401
    }
Dries's avatar
   
Dries committed
402

Dries's avatar
   
Dries committed
403
404
405
    $output .= " <tr><td colspan=\"3\"><hr /></td></tr>";
    $output .= " <tr><td align=\"left\" width=\"33%\">". ($prev ? "<a href=\"node.php?id=$prev->nid\">". t("previous") ."</a>" : t("previous")) ."</td><td align=\"center\" width=\"34%\"><a href=\"module.php?mod=book\">index</a></td><td align=\"right\" width=\"33%\">". ($next ? "<a href=\"node.php?id=$next->nid\">". t("next") ."</a>" : t("next")) ."</td></tr>";
    $output .= " <tr><td align=\"left\" width=\"33%\">". ($prev ? "<small>". check_output($prev->title) ."</small>" : "&nbsp;") ."</td><td align=\"center\" width=\"34%\">". ($node->parent ? "<a href=\"node.php?id=$node->parent\">". t("up") ."</a>" : t("up")) ."</td><td align=\"right\" width=\"33%\">". ($next ? "<small>". check_output($next->title) ."</small>" : "&nbsp;") ."</td></tr>";
Dries's avatar
   
Dries committed
406
407
    $output .= " <tr><td colspan=\"3\"><hr /></td></tr>";
    $output .= " <tr><td colspan=\"3\" align=\"right\"><div style=\"margin: 10 10 10 10;\">". $theme->links(link_node($node, $main)) ."</div></td></tr>";
Dries's avatar
   
Dries committed
408
    $output .= "</table>";
Dries's avatar
   
Dries committed
409

Dries's avatar
   
Dries committed
410
411
    $theme->box(t("Handbook"), $output);
  }
Dries's avatar
 
Dries committed
412
413
}

Dries's avatar
   
Dries committed
414
415
416
417
418
419
420
421
422
423
424
425
function book_toc_recurse($nid, $indent, $toc, $children) {

  if ($children[$nid]) {
    foreach ($children[$nid] as $foo => $node) {
      $toc[$node->nid] = "$indent $node->title";
      $toc = book_toc_recurse($node->nid, "$indent--", $toc, $children);
    }
  }

  return $toc;
}

Dries's avatar
   
Dries committed
426
function book_toc($parent = "", $indent = "", $toc = array()) {
Dries's avatar
   
Dries committed
427

Dries's avatar
   
Dries committed
428
  $result = db_query("SELECT n.nid, n.title, b.parent FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.type = 'book' AND n.status = '1' ORDER BY b.weight, n.title");
Dries's avatar
   
Dries committed
429

Dries's avatar
   
Dries committed
430
431
432
433
434
  while ($node = db_fetch_object($result)) {
    $list = $children[$node->parent] ? $children[$node->parent] : array();
    array_push($list, $node);
    $children[$node->parent] = $list;
  }
Dries's avatar
   
Dries committed
435
436

  /*
Dries's avatar
   
Dries committed
437
438
  ** If the user is an administrator, add the root node; only
  ** administrators can start new books.
Dries's avatar
   
Dries committed
439
  */
Dries's avatar
   
Dries committed
440

Dries's avatar
   
Dries committed
441
  if (user_access("administer nodes")) {
Dries's avatar
   
Dries committed
442
    $toc[0] = "<root>";
Dries's avatar
   
Dries committed
443
444
  }

Dries's avatar
   
Dries committed
445
  /*
Dries's avatar
   
Dries committed
446
  ** Iterate root book nodes:
Dries's avatar
   
Dries committed
447
448
  */

Dries's avatar
   
Dries committed
449
  $toc = book_toc_recurse(0, $indent, $toc, $children, $titles);
Dries's avatar
   
Dries committed
450

Dries's avatar
   
Dries committed
451
452
453
  return $toc;
}

Dries's avatar
Dries committed
454
function book_tree($parent = "", $depth = 0) {
Dries's avatar
 
Dries committed
455

Dries's avatar
   
Dries committed
456
  if ($depth < 3) {
Dries's avatar
   
Dries committed
457

Dries's avatar
   
Dries committed
458
459
460
461
    /*
    ** Select all child nodes and render them into a table of contents:
    */

Dries's avatar
   
Dries committed
462
    $result = db_query("SELECT n.nid FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE b.parent = '$parent' AND (n.moderate = 0 OR n.revisions != '') ORDER BY b.weight, n.title");
Dries's avatar
   
Dries committed
463

Dries's avatar
   
Dries committed
464
465
466
    while ($page = db_fetch_object($result)) {
      // load the node:
      $node = node_load(array("nid" => $page->nid));
Dries's avatar
   
Dries committed
467

Dries's avatar
   
Dries committed
468
469
470
471
      // take the most recent approved revision:
      if ($node->moderate) {
        $node = book_revision_load($node, array("moderate" => 0, "status" => 1));
      }
Dries's avatar
   
Dries committed
472

Dries's avatar
   
Dries committed
473
474
475
      if ($node) {
        // output the content:
        $output .= "<li><a href=\"node.php?id=$node->nid\">". check_output($node->title) ."</a></li>";
Dries's avatar
   
Dries committed
476

Dries's avatar
   
Dries committed
477
478
479
480
        // build the sub-tree of each child:
        $output .= book_tree($node->nid, $depth + 1);
      }
    }
Dries's avatar
   
Dries committed
481

Dries's avatar
   
Dries committed
482
    $output = "<ul>$output</ul>";
Dries's avatar
   
Dries committed
483

Dries's avatar
   
Dries committed
484
  }
Dries's avatar
   
Dries committed
485

Dries's avatar
   
Dries committed
486
487
488
  return $output;
}

Dries's avatar
   
Dries committed
489
function book_render() {
Dries's avatar
   
Dries committed
490
  global $theme;
Dries's avatar
Dries committed
491

492
  $result = db_query("SELECT n.nid FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE b.parent = 0 AND n.status = 1 AND (n.moderate = 0 OR n.revisions != '') ORDER BY b.weight");
Dries's avatar
   
Dries committed
493

Dries's avatar
   
Dries committed
494
495
496
497
498
499
  while ($page = db_fetch_object($result)) {
    // load the node:
    $node = node_load(array("nid" => $page->nid));

    // take the most recent approved revision:
    if ($node->moderate) {
Dries's avatar
   
Dries committed
500
      $node = book_revision_load($node, array("moderate" => 0, "status" => 1));
Dries's avatar
   
Dries committed
501
502
    }

Dries's avatar
   
Dries committed
503
504
    if ($node) {
      // output the content:
Dries's avatar
   
Dries committed
505
      $output .= "<dt><a href=\"node.php?id=$node->nid\">". check_output($node->title) ."</a></dt><dd>". book_body($node) ."<br /><br /></dd>";
Dries's avatar
   
Dries committed
506
    }
Dries's avatar
   
Dries committed
507
508
509
  }

  $theme->header();
Dries's avatar
   
Dries committed
510
  $theme->box(t("Handbook"), "<dl>$output</dl>");
Dries's avatar
   
Dries committed
511
512
513
514
515
516
  $theme->footer();
}

function book_page() {
  global $op, $id, $theme;

Dries's avatar
   
Dries committed
517
  if (user_access("access content")) {
Dries's avatar
   
Dries committed
518
519
    switch ($op) {
      case "feed":
Dries's avatar
   
Dries committed
520
        print book_export_html($id, $depth = 1);
Dries's avatar
   
Dries committed
521
522
523
        break;
      default:
        book_render();
Dries's avatar
   
Dries committed
524
525
526
527
528
529
530
    }
  }
  else {
    $theme->header();
    $theme->box(t("Access denied"), message_access());
    $theme->footer();
  }
Dries's avatar
 
Dries committed
531
532
}

Dries's avatar
   
Dries committed
533
function book_export_html($id = "", $depth = 1) {
Dries's avatar
   
Dries committed
534
  $result = db_query("SELECT n.nid FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.status = 1 AND n.nid = '". check_input($id) ." AND (n.moderate = 0 OR n.revisions != '')'");
Dries's avatar
   
Dries committed
535

Dries's avatar
   
Dries committed
536
537
538
  while ($page = db_fetch_object($result)) {
    // load the node:
    $node = node_load(array("nid" => $page->nid));
Dries's avatar
   
Dries committed
539

Dries's avatar
   
Dries committed
540
541
    // take the most recent approved revision:
    if ($node->moderate) {
Dries's avatar
   
Dries committed
542
      $node = book_revision_load($node, array("moderate" => 0, "status" => 1));
Dries's avatar
   
Dries committed
543
544
    }

Dries's avatar
   
Dries committed
545
546
547
    if ($node) {
      // output the content:
      $output .= "<h$depth>". check_output($node->title) ."</h$depth>";
Dries's avatar
   
Dries committed
548

Dries's avatar
   
Dries committed
549
      if ($node->body) {
Dries's avatar
   
Dries committed
550
        $output .= "<ul>". book_body($node) ."</ul>";
Dries's avatar
   
Dries committed
551
      }
Dries's avatar
   
Dries committed
552
    }
Dries's avatar
   
Dries committed
553
  }
Dries's avatar
   
Dries committed
554

Dries's avatar
   
Dries committed
555
  $output .= book_export_html_recurse($id, $depth);
Dries's avatar
   
Dries committed
556
557
558
559

  return $output;
}

Dries's avatar
   
Dries committed
560
function book_export_html_recurse($parent = "", $depth = 1) {
Dries's avatar
   
Dries committed
561
  $result = db_query("SELECT n.nid FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.status = 1 AND b.parent = '$parent' AND (n.moderate = 0 OR n.revisions != '') ORDER BY b.weight");
Dries's avatar
   
Dries committed
562

Dries's avatar
   
Dries committed
563
564
565
566
567
568
  while ($page = db_fetch_object($result)) {
    // load the node:
    $node = node_load(array("nid" => $page->nid));

    // take the most recent approved revision:
    if ($node->moderate) {
Dries's avatar
   
Dries committed
569
      $node = book_revision_load($node, array("moderate" => 0, "status" => 1));
Dries's avatar
   
Dries committed
570
571
    }

Dries's avatar
   
Dries committed
572
573
574
    if ($node) {
      // output the content:
      $output .= "<h$depth>". check_output($node->title) ."</h$depth>";
Dries's avatar
   
Dries committed
575

Dries's avatar
   
Dries committed
576
      if ($node->body) {
Dries's avatar
   
Dries committed
577
        $output .= "<ul>". book_body($node) ."</ul>";
Dries's avatar
   
Dries committed
578
      }
Dries's avatar
   
Dries committed
579

Dries's avatar
   
Dries committed
580
      $output .= book_export_html_recurse($node->nid, $depth + 1);
Dries's avatar
   
Dries committed
581
    }
Dries's avatar
   
Dries committed
582
  }
Dries's avatar
   
Dries committed
583

Dries's avatar
   
Dries committed
584
585
  return $output;
}
Dries's avatar
   
Dries committed
586

Dries's avatar
   
Dries committed
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
function book_admin_view_line($node, $depth = 0) {

  /*
  ** Extract the revision number:
  */

  if ($list = node_revision_list($node)) {
    $revision = end($list);
  }
  else {
    $revision = 0;
  }

  /*
  ** Diplay the book page:
  */

  $output .= "<tr>";
  $output .= " <td><div style=\"padding-left: ". (25 * $depth) ."px;\"><a href=\"node.php?id=$node->nid\">". check_output($node->title) ."</a></div></td>";
  $output .= " <td align=\"center\">$revision</td>";
  $output .= " <td><a href=\"admin.php?mod=node&op=edit&id=$node->nid\">". t("edit page") ."</td>";
  $output .= " <td><a href=\"admin.php?mod=node&op=delete&id=$node->nid\">". t("delete page") ."</td>";
  $output .= "</tr>";

  return $output;
}

function book_admin_view_book($nid, $depth = 1) {
Dries's avatar
   
Dries committed
615
616
  $weight = array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30);

Dries's avatar
   
Dries committed
617
  $result = db_query("SELECT n.nid FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE b.parent = '$nid' ORDER BY b.weight, n.title");
Dries's avatar
   
Dries committed
618
619
620

  while ($node = db_fetch_object($result)) {
    $node = node_load(array("nid" => $node->nid));
Dries's avatar
   
Dries committed
621
622
    $output .= book_admin_view_line($node, $depth);
    $output .= book_admin_view_book($node->nid, $depth + 1);
Dries's avatar
   
Dries committed
623
624
625
626
627
628
629
630
631
632
633
634
  }

  return $output;
}

function book_admin_view($nid, $depth = 0) {

  $node = node_load(array("nid" => $nid));

  $output .= "<h3>". check_output($node->title) ."</h3>";
  $output .= "<table border=\"1\" cellpadding=\"2\" cellspacing=\"2\">";
  $output .= " <tr><th>title</th><th>rev</th><th colspan=\"2\">operations</th></tr>";
Dries's avatar
   
Dries committed
635
636
  $output .= book_admin_view_line($node);
  $output .= book_admin_view_book($nid);
Dries's avatar
   
Dries committed
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
  $output .= "</table>";

  return $output;
}

function book_admin_orphan() {

  $result = db_query("SELECT n.nid, n.title, b.parent FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.type = 'book'");

  while ($page = db_fetch_object($result)) {
    $pages[$page->nid] = $page;
  }

  $output .= "<table border=\"1\" cellpadding=\"2\" cellspacing=\"2\">";
  $output .= " <tr><th>title</th><th colspan=\"2\">operations</th></tr>";
  foreach ($pages as $nid => $node) {
    if ($node->parent && empty($pages[$node->parent])) {
      $output .= "<tr><td><a href=\"node.php?id=$node->nid\">". check_output($node->title) ."</a></td><td><a href=\"admin.php?mod=node&op=edit&id=$node->nid\">". t("edit page") ."</td><td><a href=\"admin.php?mod=node&op=delete&id=$node->nid\">". t("delete page") ."</td>";
    }
  }
  $output .= "</table>";

  return $output;
}

function book_admin_links() {
  $result = db_query("SELECT n.nid, n.title FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE b.parent = 0 ORDER BY b.weight, n.title");

  while ($book = db_fetch_object($result)) {
    $links[] = "<a href=\"admin.php?mod=book&op=view&id=$book->nid\">". t("book") .": <i>". check_output($book->title) ."</i></a>";
  }

  return $links;
}

function book_admin() {
  global $id, $op;

  if (user_access("administer nodes")) {

    /*
    ** Compile a list of the administrative links:
    */

    $links = book_admin_links();
    $links[] = "<a href=\"admin.php?mod=book&op=orphan\">". t("orphan pages") ."</a>";

    print "<small>". implode(" &middot; ", $links) ."</small><hr />";

    switch ($op) {
Dries's avatar
   
Dries committed
687
688
689
690
691
692
      case t("Edit book outline"):
      case t("Add to book outline"):
      case t("Remove from book outline"):
      case t("Update book outline"):
        print book_node_link();
        break;
Dries's avatar
   
Dries committed
693
694
695
696
697
698
699
700
701
702
703
      case "orphan":
        print book_admin_orphan();
        break;
      case "view":
        print book_admin_view($id);
        break;
      default:
    }
  }
}

Dries's avatar
 
Dries committed
704
?>