book.module 17.2 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
    return 1;
  }

  if ($op == "update") {

Dries's avatar
   
Dries committed
33
    /*
Dries's avatar
   
Dries committed
34
35
36
37
    ** Everyone can upate a book page if there are no suggested updates
    ** of that page waiting for approval 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
38
    */
Dries's avatar
   
Dries committed
39
    return !$node->moderate && $node->revision;
Dries's avatar
   
Dries committed
40
  }
Dries's avatar
   
Dries committed
41
42
}

Dries's avatar
   
Dries committed
43
function book_save($op, $node) {
Dries's avatar
   
Dries committed
44
  global $user, $REQUEST_URI;
Dries's avatar
   
Dries committed
45
46
47
48
49
50
51
52
53
54
55
56
57
58

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

  if ($op == "create") {
    return array("moderate" => 1, "parent", "promote" => 0, "status" => 1, "weight");
  }

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

  if ($op == "update") {
Dries's avatar
   
Dries committed
59
    if (strstr($REQUEST_URI, "module.php?mod=node&op=edit")) {
Dries's avatar
   
Dries committed
60
      /*
Dries's avatar
   
Dries committed
61
62
63
      ** If a regular user updates a book page, we always create a new
      ** revision.  All new revisions have to be approved (moderation)
      ** and are not promoted by derault.  See also: book_load().
Dries's avatar
   
Dries committed
64
65
      */

Dries's avatar
   
Dries committed
66
      return array("created" => time(), "moderate" => 1, "parent", "promote" => 0, "score" => 0, "status" => 1, "users" => "", "revisions", "votes" => 0, "weight");
Dries's avatar
   
Dries committed
67
    }
Dries's avatar
   
Dries committed
68
    else if (user_access("adminster nodes")) {
Dries's avatar
   
Dries committed
69
      /*
Dries's avatar
   
Dries committed
70
71
72
73
74
      ** 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
75
76
      */

Dries's avatar
   
Dries committed
77
      return array("parent", "weight");
Dries's avatar
   
Dries committed
78
79
80
81
82
    }
  }

}

Dries's avatar
   
Dries committed
83
84
85
function book_link($type) {
  if ($type == "page" && user_access("access content")) {
    $links[] = "<a href=\"module.php?mod=book\">". t("collaborative book") ."</a>";
Dries's avatar
   
Dries committed
86
  }
Dries's avatar
   
Dries committed
87

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

Dries's avatar
   
Dries committed
92
  return $links ? $links : array();
Dries's avatar
   
Dries committed
93
94
}

Dries's avatar
   
Dries committed
95
function book_load($node) {
Dries's avatar
   
Dries committed
96
97
98
99
100
  global $user, $REQUEST_URI;

  $book = db_fetch_object(db_query("SELECT parent, weight FROM book WHERE nid = '$node->nid'"));

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

Dries's avatar
   
Dries committed
102
103
104
105
106
107
108
    /*
    ** 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
109
110
111
112
113
114
115
116
    if ($user->uid) {
      $book->uid = $user->uid;
      $book->name = $user->name;
    }
    else {
      $book->uid = 0;
      $book->name = "";
    }
Dries's avatar
   
Dries committed
117

Dries's avatar
   
Dries committed
118
119
120
121
    /*
    ** We set the revision field to indicate that we have to create
    ** a new revision when updating this book page.
    */
Dries's avatar
   
Dries committed
122

Dries's avatar
   
Dries committed
123
124
125
    $book->revision = 1;

  }
Dries's avatar
   
Dries committed
126

Dries's avatar
   
Dries committed
127
  return $book;
Dries's avatar
   
Dries committed
128
129
}

Dries's avatar
   
Dries committed
130
function book_insert($node) {
Dries's avatar
   
Dries committed
131
  db_query("INSERT INTO book (nid, parent, weight) VALUES ('$node->nid', '$node->parent', '$node->weight')");
Dries's avatar
   
Dries committed
132
}
Dries's avatar
   
Dries committed
133

Dries's avatar
   
Dries committed
134
function book_update($node) {
Dries's avatar
   
Dries committed
135
  db_query("UPDATE book SET parent = '$node->parent', weight = '$node->weight' WHERE nid = '$node->nid'");
Dries's avatar
   
Dries committed
136
}
Dries's avatar
   
Dries committed
137

138
function book_delete(&$node) {
Dries's avatar
   
Dries committed
139
  db_query("DELETE FROM book WHERE nid = '$node->nid'");
Dries's avatar
   
Dries committed
140
141
}

Dries's avatar
   
Dries committed
142

143
function book_form(&$node, &$help, &$error) {
Dries's avatar
   
Dries committed
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
  global $user;

  $output .= form_select(t("Parent"), "parent", $node->parent, book_toc(), t("The parent subject or category the page belongs in."));
  $output .= form_textarea(t("Content"), "body", $node->body, 60, 20, t("Allowed HTML tags") .": ". htmlspecialchars(variable_get("allowed_html", "")));
  $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")) {
    $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 nodes will sink and the lighter nodes will be positioned nearer the top."));
  }
  else {

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

Dries's avatar
   
Dries committed
159
160
    $help = book_node("description");

Dries's avatar
   
Dries committed
161
162
163
164
165
166
167
168
169
170
171
    /*
    ** 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
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
/*
** 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
211
function book_location($node, $nodes = array()) {
Dries's avatar
   
Dries committed
212
  $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
213
214
215
216
217
218
219
  if ($parent->title) {
    $nodes = book_location($parent, $nodes);
    array_push($nodes, $parent);
  }
  return $nodes;
}

Dries's avatar
   
Dries committed
220
function book_view($node, $main = 0) {
Dries's avatar
   
Dries committed
221
222
223
224
225
226
227
228
229
  global $theme, $mod;

  /*
  ** Always display the most recently approved revision of a node
  ** unless we have to display it in the context of the moderation
  ** queue.
  */

  if ($node->moderate && $mod != "queue") {
Dries's avatar
   
Dries committed
230
    $node = book_revision_load($node, array("moderate" => 0, "status" => 1));
Dries's avatar
   
Dries committed
231
232
233
234
235
236
237
  }

  /*
  ** 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
238

Dries's avatar
   
Dries committed
239
240
  if ($main) {
    $theme->node($node, $main);
Dries's avatar
   
Dries committed
241
  }
Dries's avatar
   
Dries committed
242
243
  else {
    if ($node->nid && $node->parent) {
244
245
      $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
246
    }
Dries's avatar
   
Dries committed
247

Dries's avatar
   
Dries committed
248
    $output .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\n";
Dries's avatar
   
Dries committed
249

Dries's avatar
   
Dries committed
250
251
    if ($node->title) {
      foreach (book_location($node) as $level) {
Dries's avatar
   
Dries committed
252
        $location .= "$indent <a href=\"node.php?id=$level->nid\">$level->title</a><br />";
Dries's avatar
   
Dries committed
253
254
        $indent .= "-";
      }
Dries's avatar
   
Dries committed
255

Dries's avatar
   
Dries committed
256
257
258
      $output .= " <tr><td colspan=\"2\">$location</td><td align=\"right\"><a href=\"module.php?mod=node&op=edit&id=$node->nid\">". t("update this book page") ."</a></td></tr>";
      $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
259
    }
Dries's avatar
   
Dries committed
260

Dries's avatar
   
Dries committed
261
    if ($node->body) {
Dries's avatar
   
Dries committed
262
      $output .= " <tr><td colspan=\"3\"><br />". check_output($node->body, 1) ."</td></tr>";
Dries's avatar
   
Dries committed
263
    }
Dries's avatar
 
Dries committed
264

Dries's avatar
   
Dries committed
265
    if ($node->nid) {
Dries's avatar
   
Dries committed
266
      $output .= " <tr><td colspan=\"3\"><br />". book_tree($node->nid) ."</td></tr>";
Dries's avatar
   
Dries committed
267
    }
Dries's avatar
   
Dries committed
268

Dries's avatar
   
Dries committed
269
270
271
272
    $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>";
    $output .= "</table>";
Dries's avatar
   
Dries committed
273

Dries's avatar
   
Dries committed
274
275
    $theme->box(t("Handbook"), $output);
  }
Dries's avatar
 
Dries committed
276
277
}

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

Dries's avatar
   
Dries committed
280
281
282
283
  /*
  ** Select all child nodes:
  */

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

  /*
Dries's avatar
   
Dries committed
287
288
  ** If the user is an administrator, add the root node; only
  ** administrators can start new books.
Dries's avatar
   
Dries committed
289
  */
Dries's avatar
   
Dries committed
290

Dries's avatar
   
Dries committed
291
  if (user_access("administer nodes")) {
Dries's avatar
   
Dries committed
292
    $toc[0] = "<root>";
Dries's avatar
   
Dries committed
293
294
  }

Dries's avatar
   
Dries committed
295
296
297
298
  /*
  ** Build the table of contents:
  */

Dries's avatar
   
Dries committed
299
  while ($node = db_fetch_object($result)) {
Dries's avatar
   
Dries committed
300
301
    $toc[$node->nid] = "$indent $node->title";
    $toc = book_toc($node->nid, "$indent-", $toc);
Dries's avatar
   
Dries committed
302
  }
Dries's avatar
   
Dries committed
303

Dries's avatar
   
Dries committed
304
305
306
  return $toc;
}

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

Dries's avatar
   
Dries committed
309
  if ($depth < 3) {
Dries's avatar
   
Dries committed
310

Dries's avatar
   
Dries committed
311
312
313
314
    /*
    ** Select all child nodes and render them into a table of contents:
    */

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

Dries's avatar
   
Dries committed
317
318
319
     while ($page = db_fetch_object($result)) {
       // load the node:
       $node = node_load(array("nid" => $page->nid));
Dries's avatar
   
Dries committed
320

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

Dries's avatar
   
Dries committed
326
327
328
       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
329

Dries's avatar
   
Dries committed
330
331
332
         // build the sub-tree of each child:
         $output .= book_tree($node->nid, $depth + 1);
       }
Dries's avatar
   
Dries committed
333
334
335
     }

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

Dries's avatar
   
Dries committed
337
  }
Dries's avatar
   
Dries committed
338

Dries's avatar
   
Dries committed
339
340
341
  return $output;
}

Dries's avatar
   
Dries committed
342
function book_render() {
Dries's avatar
   
Dries committed
343
  global $theme;
Dries's avatar
Dries committed
344

345
  $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
346

Dries's avatar
   
Dries committed
347
348
349
350
351
352
  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
353
      $node = book_revision_load($node, array("moderate" => 0, "status" => 1));
Dries's avatar
   
Dries committed
354
355
    }

Dries's avatar
   
Dries committed
356
357
358
359
    if ($node) {
      // output the content:
      $output .= "<dt><a href=\"node.php?id=$node->nid\">". check_output($node->title) ."</a></dt><dd>". check_output($node->body, 1) ."<br /><br /></dd>";
    }
Dries's avatar
   
Dries committed
360
361
362
  }

  $theme->header();
Dries's avatar
   
Dries committed
363
  $theme->box(t("Handbook"), "<dl>$output</dl>");
Dries's avatar
   
Dries committed
364
365
366
367
368
369
  $theme->footer();
}

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

Dries's avatar
   
Dries committed
370
  if (user_access("access content")) {
Dries's avatar
   
Dries committed
371
372
    switch ($op) {
      case "feed":
Dries's avatar
   
Dries committed
373
        print book_export_html($id, $depth = 1);
Dries's avatar
   
Dries committed
374
375
376
        break;
      default:
        book_render();
Dries's avatar
   
Dries committed
377
378
379
380
381
382
383
    }
  }
  else {
    $theme->header();
    $theme->box(t("Access denied"), message_access());
    $theme->footer();
  }
Dries's avatar
 
Dries committed
384
385
}

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

Dries's avatar
   
Dries committed
389
390
391
  while ($page = db_fetch_object($result)) {
    // load the node:
    $node = node_load(array("nid" => $page->nid));
Dries's avatar
   
Dries committed
392

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

Dries's avatar
   
Dries committed
398
399
400
    if ($node) {
      // output the content:
      $output .= "<h$depth>". check_output($node->title) ."</h$depth>";
Dries's avatar
   
Dries committed
401

Dries's avatar
   
Dries committed
402
403
404
      if ($node->body) {
        $output .= "<ul>". check_output($node->body, 1) ."</ul>";
      }
Dries's avatar
   
Dries committed
405
    }
Dries's avatar
   
Dries committed
406
  }
Dries's avatar
   
Dries committed
407

Dries's avatar
   
Dries committed
408
409
410
411
412
413
  $output .= book_export_html_recursive($id, $depth);

  return $output;
}

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

Dries's avatar
   
Dries committed
416
417
418
419
420
421
  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
422
      $node = book_revision_load($node, array("moderate" => 0, "status" => 1));
Dries's avatar
   
Dries committed
423
424
    }

Dries's avatar
   
Dries committed
425
426
427
    if ($node) {
      // output the content:
      $output .= "<h$depth>". check_output($node->title) ."</h$depth>";
Dries's avatar
   
Dries committed
428

Dries's avatar
   
Dries committed
429
430
431
      if ($node->body) {
        $output .= "<blockquote>". check_output($node->body, 1) ."</blockquote>";
      }
Dries's avatar
   
Dries committed
432

Dries's avatar
   
Dries committed
433
434
      $output .= book_export_html_recursive($node->nid, $depth + 1);
    }
Dries's avatar
   
Dries committed
435
  }
Dries's avatar
   
Dries committed
436

Dries's avatar
   
Dries committed
437
438
  return $output;
}
Dries's avatar
   
Dries committed
439

Dries's avatar
   
Dries committed
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
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
468
469
470
471
472
473
  $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);

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

  while ($node = db_fetch_object($result)) {
    $node = node_load(array("nid" => $node->nid));
Dries's avatar
   
Dries committed
474
475
    $output .= book_admin_view_line($node, $depth);
    $output .= book_admin_view_book($node->nid, $depth + 1);
Dries's avatar
   
Dries committed
476
477
478
479
480
481
482
483
484
485
486
487
  }

  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
488
489
  $output .= book_admin_view_line($node);
  $output .= book_admin_view_book($nid);
Dries's avatar
   
Dries committed
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
  $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) {
      case "orphan":
        print book_admin_orphan();
        break;
      case "view":
        print book_admin_view($id);
        break;
      default:
    }
  }
}

Dries's avatar
 
Dries committed
551
?>