book.module 12.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
class Book {
Dries's avatar
 
Dries committed
5 6 7 8 9
  function Book($book) {
    $this = new Node($book);
    $this->body = $book[body];
    $this->parent = $book[parent];
    $this->weight = $book[weight];
Dries's avatar
 
Dries committed
10 11 12
  }
}

Dries's avatar
 
Dries committed
13
function book_perm() {
Dries's avatar
 
Dries committed
14 15 16 17 18
  return array("administer book");
}

function book_link($type) {
  if ($type == "admin" && user_access("administer book")) {
Dries's avatar
 
Dries committed
19
     $links[] = "<a href=\"admin.php?mod=book\">collaborative book</a>";
Dries's avatar
 
Dries committed
20 21 22 23 24 25 26
  }

  if ($type == "page" && user_access("access content")) {
    $links[] = "<a href=\"module.php?mod=book\">". t("collaborative book") ."</a>";
  }

  return $links ? $links : array();
Dries's avatar
 
Dries committed
27 28
}

Dries's avatar
 
Dries committed
29 30 31 32
function book_status() {
  return array(dumped, expired, queued, posted);
}

Dries's avatar
 
Dries committed
33
function book_location($node, $nodes = array()) {
Dries's avatar
 
Dries committed
34
  $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
35 36 37 38 39 40 41
  if ($parent->title) {
    $nodes = book_location($parent, $nodes);
    array_push($nodes, $parent);
  }
  return $nodes;
}

Dries's avatar
 
Dries committed
42
function book_view($node, $main = 0) {
Dries's avatar
 
Dries committed
43
  global $status, $theme;
Dries's avatar
 
Dries committed
44

Dries's avatar
 
Dries committed
45 46
  if ($main) {
    $theme->node($node, $main);
Dries's avatar
 
Dries committed
47
  }
Dries's avatar
 
Dries committed
48 49 50
  else {
    if ($node->nid && $node->parent) {
      $list = book_parent_query($node->parent);
Dries's avatar
 
Dries committed
51 52
      $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 = '$status[posted]' AND $list AND (b.weight > '$node->weight' OR (b.weight = '$node->weight' AND n.title > '". check_query($node->title) ."')) 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 = '$status[posted]' AND $list AND (b.weight < '$node->weight' OR (b.weight = '$node->weight' AND n.title < '". check_query($node->title) ."')) ORDER BY b.weight DESC,n.title DESC"));
Dries's avatar
 
Dries committed
53
    }
Dries's avatar
 
Dries committed
54

Dries's avatar
 
Dries committed
55
    $output .= "<TABLE BORDER=\"0\" CELLPADDING=\"0\" CELLSPACING=\"0\" WIDTH=\"100%\">\n";
Dries's avatar
 
Dries committed
56

Dries's avatar
 
Dries committed
57 58 59 60 61
    if ($node->title) {
      foreach (book_location($node) as $level) {
        $location .= "$indent <A HREF=\"node.php?id=$level->nid\">$level->title</A><BR>";
        $indent .= "-";
      }
Dries's avatar
 
Dries committed
62

Dries's avatar
 
Dries committed
63 64
      $output .= " <TR><TD COLSPAN=\"2\">$location</TD><TD ALIGN=\"right\">". node_control($node) ."</TD></TR>\n";
      $output .= " <TR><TD COLSPAN=\"3\"><HR></TD></TR>";
Dries's avatar
 
Dries committed
65
      $output .= " <TR><TD COLSPAN=\"3\"><B><BIG>". check_output($node->title) ."</BIG></B>". ($node->body ? "<BR><SMALL><I>Last updated by ". format_name($node) ." on ". format_date($node->timestamp) ."</I></SMALL> " : "") ."</TD></TR>\n";
Dries's avatar
 
Dries committed
66
    }
Dries's avatar
 
Dries committed
67

Dries's avatar
 
Dries committed
68 69 70
    if ($node->body) {
      $output .= " <TR><TD COLSPAN=\"3\"><BR>". check_output($node->body, 1) ."</TD></TR>";
    }
Dries's avatar
 
Dries committed
71

Dries's avatar
 
Dries committed
72 73 74
    if ($node->nid) {
      $output .= " <TR><TD COLSPAN=\"3\"><BR>". book_tree($node->nid) ."</TD></TR>";
    }
Dries's avatar
 
Dries committed
75

Dries's avatar
 
Dries committed
76 77 78 79
    $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>\n";
    $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>\n";
    $output .= "</TABLE>\n";
Dries's avatar
 
Dries committed
80

Dries's avatar
 
Dries committed
81 82
    $theme->box(t("Handbook"), $output);
  }
Dries's avatar
 
Dries committed
83 84
}

Dries's avatar
 
Dries committed
85
function book_search($keys) {
Dries's avatar
 
Dries committed
86
  global $PHP_SELF, $status;
Dries's avatar
 
Dries committed
87
  $result = db_query("SELECT n.*, u.name FROM node n LEFT JOIN book b ON n.nid = b.nid LEFT JOIN users u ON n.uid = u.uid WHERE n.type = 'book' AND n.status = '$status[posted]' AND (n.title LIKE '%". check_input($keys) ."%' OR b.body LIKE '%". check_input($keys) ."%') ORDER BY n.timestamp DESC LIMIT 20");
Dries's avatar
 
Dries committed
88
  while ($node = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
89
    $find[$i++] = array("title" => check_output($node->title), "link" => (strstr($PHP_SELF, "admin.php") ? "admin.php?mod=node&type=book&op=edit&id=$node->nid" : "node.php?id=$node->nid"), "user" => $node->name, "date" => $node->timestamp);
Dries's avatar
 
Dries committed
90 91 92 93
  }
  return $find;
}

Dries's avatar
 
Dries committed
94
function book_parent_query($parent) {
Kjartan's avatar
Kjartan committed
95
  if ($parent > 0) {
Dries's avatar
 
Dries committed
96 97 98 99 100 101 102 103 104 105
    $list = array();
    foreach (book_parent($parent) as $pid) array_push($list, "b.parent = $pid");
  }
  else {
    $list = array("b.parent = ''");
  }
  return "(". implode(" OR ", $list) .")";
}

function book_toc($parent = "", $indent = "", $toc = array()) {
Dries's avatar
 
Dries committed
106
  global $status;
Dries's avatar
 
Dries committed
107

Dries's avatar
 
Dries committed
108
  // select all child nodes:
Dries's avatar
 
Dries committed
109
  $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.type = 'book' AND n.status = '$status[posted]' AND ". book_parent_query($parent) ." ORDER BY b.weight");
Dries's avatar
 
Dries committed
110

Dries's avatar
 
Dries committed
111
  // add root node:
Dries's avatar
 
Dries committed
112
  if (user_access("administer nodes")) {
Dries's avatar
 
Dries committed
113
    $toc[0] = "<root>";
Dries's avatar
 
Dries committed
114 115
  }

Dries's avatar
 
Dries committed
116
  // build table of contents:
Dries's avatar
 
Dries committed
117
  while ($node = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
118 119
    $toc[$node->nid] = "$indent $node->title";
    $toc = book_toc($node->nid, "$indent-", $toc);
Dries's avatar
 
Dries committed
120
  }
Dries's avatar
 
Dries committed
121

Dries's avatar
 
Dries committed
122 123 124
  return $toc;
}

Dries's avatar
 
Dries committed
125
function book_form($edit = array()) {
Dries's avatar
 
Dries committed
126
  global $user;
Dries's avatar
 
Dries committed
127

Dries's avatar
 
Dries committed
128 129 130 131
  if ($edit[title]) {
    $form .= book_view(new Book(node_preview($edit)));
  }

Dries's avatar
 
Dries committed
132
  $form .= form_item(t("Author"), ($edit[name] ? $edit[name] :  ($user->name ? $user->name : variable_get(anonymous, "Anonymous"))));
Dries's avatar
 
Dries committed
133
  $form .= form_hidden(name, $edit[name]);
Dries's avatar
 
Dries committed
134
  $form .= form_textfield(t("Subject"), "title", $edit[title], 50, 64);
Dries's avatar
 
Dries committed
135

Dries's avatar
 
Dries committed
136
  $form .= form_select(t("Parent"), "parent", $edit[parent], book_toc(), t("The parent subject or category the page belongs in."));
Dries's avatar
 
Dries committed
137

Dries's avatar
 
Dries committed
138 139
  $form .= form_textarea(t("Content"), "body", $edit[body], 70, 20, t("Allowed HTML tags") .": ". htmlspecialchars(variable_get("allowed_html", "")));
  $form .= form_textarea(t("Log message"), "log", $edit[log], 70, 5, t("An explanation of the additions or updates being made to help the group understand your motivations."));
Dries's avatar
 
Dries committed
140

Dries's avatar
 
Dries committed
141
  if (user_access("administer nodes")) {
Dries's avatar
 
Dries committed
142
    $form .= form_select(t("Weight"), "weight", $edit[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."));
Dries's avatar
 
Dries committed
143 144
  }

Dries's avatar
 
Dries committed
145 146 147
  if ($edit[nid] > 0) {
    $form .= form_hidden("nid", $edit[nid]);
  }
Dries's avatar
 
Dries committed
148

Dries's avatar
 
Dries committed
149 150 151 152
  if ($edit[pid] > 0) {
    $form .= form_hidden("pid", $edit[pid]);
  }

Dries's avatar
 
Dries committed
153 154 155 156
  if (!$edit) {
    $form .= form_submit(t("Preview"));
  }
  else if ($edit && !$edit[title]) {
Dries's avatar
 
Dries committed
157 158
    $form .= "<FONT COLOR=\"red\">". t("Warning: you did not supply a title.") ."</FONT><P>\n";
    $form .= form_submit(t("Preview"));
Dries's avatar
 
Dries committed
159 160
  }
  else {
Dries's avatar
 
Dries committed
161 162
    $form .= form_submit(t("Preview"));
    $form .= form_submit(t("Submit"));
Dries's avatar
 
Dries committed
163 164
  }

Dries's avatar
 
Dries committed
165
  return form($form);
Dries's avatar
 
Dries committed
166 167 168
}

function book_save($edit) {
Dries's avatar
 
Dries committed
169 170 171
  global $status, $user;

  if (!$edit[nid]) {
Dries's avatar
 
Dries committed
172
    node_save($edit, array(uid => $user->uid, body, comment => variable_get("book_comment", 0), log, moderate => variable_get("book_moderate", ""), parent, pid, promote => variable_get("book_promote", 0), score => 0, status => variable_get("book_status", $status[queued]), timestamp => time(), title, type => "book", votes => 0, weight));
Dries's avatar
 
Dries committed
173
  }
Dries's avatar
 
Dries committed
174
  else if (user_access("administer nodes")) {
Dries's avatar
 
Dries committed
175
    node_save($edit, array(body, log, parent, title, type => "book", weight));
Dries's avatar
 
Dries committed
176
  }
Dries's avatar
 
Dries committed
177 178
}

Dries's avatar
 
Dries committed
179 180 181 182 183 184 185 186
function book_delete($node) {
  if ($node->pid && $node->status == node_status("posted")) {
    db_query("UPDATE node SET status = '". node_status("posted") ."' WHERE nid = '$node->pid'");
  }
}

function book_insert($node) {
  if ($node->pid && $node->status == node_status("posted")) {
Dries's avatar
 
Dries committed
187
    db_query("UPDATE node SET status = '". node_status("expired") ."' WHERE nid = '$node->pid'");
Dries's avatar
 
Dries committed
188 189 190 191 192
  }
}

function book_update($node) {
  if ($node->pid && $node->status == node_status("posted")) {
Dries's avatar
 
Dries committed
193
    db_query("UPDATE node SET status = '". node_status("expired") ."' WHERE nid = '$node->pid'");
Dries's avatar
 
Dries committed
194 195 196
  }
}

Dries's avatar
 
Dries committed
197 198
function book_parent($nid) {
  global $status;
199
  if ($node = node_get_object(array("nid" => $nid))) {
Dries's avatar
 
Dries committed
200 201 202 203 204 205 206 207
    $list[$nid] = $nid;
  }
  if ($node->pid) {
    $list = array_merge($list, book_parent($node->pid));
  }
  return $list ? $list : array();
}

Dries's avatar
Dries committed
208
function book_tree($parent = "", $depth = 0) {
Dries's avatar
 
Dries committed
209
  global $PHP_SELF, $status;
Dries's avatar
 
Dries committed
210

Dries's avatar
 
Dries committed
211 212
  if ($depth < 3 || strstr($PHP_SELF,"admin.php")) {
    // select all child nodes:
Dries's avatar
 
Dries committed
213
    $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.type = 'book' AND n.status = '$status[posted]' AND ". book_parent_query($parent) ." ORDER BY b.weight, n.title");
Dries's avatar
 
Dries committed
214 215 216

    // render output:
    while ($node = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
217
      $output .= "<LI><A HREF=\"node.php?id=$node->nid\">". check_output($node->title) ."</A>". (strstr($PHP_SELF, "admin.php") ? " <SMALL>(weight: $node->weight/$node->parent, status: $node->status) (<A HREF=\"admin.php?mod=node&type=book&op=edit&id=$node->nid\">edit</A>)</SMALL>" : "") ."</LI>\n";
Dries's avatar
 
Dries committed
218 219 220 221 222 223 224
      $output .= book_tree($node->nid, $depth + 1);
    }
    $output = "<UL>$output</UL>";
  }
  return $output;
}

Dries's avatar
 
Dries committed
225
function book_admin() {
Dries's avatar
 
Dries committed
226
  if (user_access("administer book")) {
Dries's avatar
 
Dries committed
227 228 229 230 231
    print book_tree();
  }
  else {
    print message_access();
  }
Dries's avatar
 
Dries committed
232 233
}

Dries's avatar
 
Dries committed
234
function book_render() {
Dries's avatar
 
Dries committed
235
  global $status, $theme;
Dries's avatar
Dries committed
236

Dries's avatar
 
Dries committed
237
  $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE b.parent = 0 AND n.status = $status[posted] ORDER BY b.weight");
Dries's avatar
 
Dries committed
238 239 240 241 242 243 244 245 246 247 248 249 250

  while ($node = db_fetch_object($result)) {
    $output .= "<DT><A HREF=\"node.php?id=$node->nid\">". check_output($node->title) ."</A></DT><DD>". check_output($node->body, 1) ."<BR><BR></DD>";
  }

  $theme->header();
  $theme->box(t("Handbook"), "<DL>$output</DL>");
  $theme->footer();
}

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

Dries's avatar
 
Dries committed
251
  if (user_access("access content")) {
Dries's avatar
Dries committed
252

Dries's avatar
 
Dries committed
253 254
    switch ($op) {
      case "feed":
Dries's avatar
 
Dries committed
255
        print book_export_html($id, $depth = 1);
Dries's avatar
 
Dries committed
256 257 258
        break;
      default:
        book_render();
Dries's avatar
 
Dries committed
259 260 261 262 263 264 265
    }
  }
  else {
    $theme->header();
    $theme->box(t("Access denied"), message_access());
    $theme->footer();
  }
Dries's avatar
 
Dries committed
266 267
}

Dries's avatar
 
Dries committed
268
function book_edit($id) {
Dries's avatar
 
Dries committed
269 270
  global $status;

271
  if ($node = node_get_object(array("nid" => $id))) {
Dries's avatar
 
Dries committed
272 273 274
    if ($node->status != $status[posted]) {
      return t("You can only update accepted pages: pages that are still queued or already expired can not be updated.");
    }
Dries's avatar
 
Dries committed
275
    else if (db_result(db_query("SELECT COUNT(n.nid) FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE b.pid = '$node->nid' AND n.status = '$status[queued]'"))) {
Dries's avatar
 
Dries committed
276
      return t("There is already an update for this node in the queue: we can only process one update at once.");
Dries's avatar
 
Dries committed
277 278 279 280 281 282 283
    }
    else {
      return book_form(array(nid => -1, pid => $id, title => $node->title, body => $node->body, parent => $node->parent));
    }
  }
}

Dries's avatar
 
Dries committed
284 285 286
function book_user() {
  global $edit, $id, $op, $theme, $user;

Dries's avatar
 
Dries committed
287
  $title = t("Submit");
Dries's avatar
 
Dries committed
288

Dries's avatar
 
Dries committed
289 290
  switch($op) {
    case "update":
Dries's avatar
 
Dries committed
291
      $theme->box($title, book_edit($id));
Dries's avatar
 
Dries committed
292 293
      break;
    case t("Preview"):
Dries's avatar
 
Dries committed
294
      $theme->box($title, book_form($edit));
Dries's avatar
 
Dries committed
295 296 297
      break;
    case t("Submit"):
      book_save($edit);
Dries's avatar
 
Dries committed
298
      $theme->box($title, t("Thank you for your submission."));
Dries's avatar
 
Dries committed
299 300
      break;
    default:
Dries's avatar
 
Dries committed
301
      $theme->box($title, book_form());
Dries's avatar
 
Dries committed
302 303 304
  }
}

Dries's avatar
 
Dries committed
305 306 307
function book_export_html($id = "", $depth = 1) {
  global $status;

Dries's avatar
 
Dries committed
308
  $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.type = 'book' AND n.status = '$status[posted]' AND n.nid = '". check_input($id) ."'");
Dries's avatar
 
Dries committed
309 310 311 312 313 314 315 316 317 318 319

  while ($node = db_fetch_object($result)) {
    $output .= "<H$depth>". check_output($node->title) ."</H$depth>";
    if ($node->body) $output .= "<blockquote>". check_output($node->body, 1) ."</blockquote>";
  }
  $output .= book_export_html_recursive($id, $depth);

  return $output;
}

function book_export_html_recursive($parent = "", $depth = 1) {
Dries's avatar
 
Dries committed
320 321
  global $status;

Dries's avatar
 
Dries committed
322
  $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.type = 'book' AND n.status = '$status[posted]' AND b.parent = '$parent' ORDER BY b.weight");
Dries's avatar
 
Dries committed
323 324 325

  while ($node = db_fetch_object($result)) {
    $output .= "<H$depth>". check_output($node->title) ."</H$depth>";
Dries's avatar
 
Dries committed
326 327 328
    if ($node->body) $output .= "<blockquote>". check_output($node->body, 1) ."</blockquote>";
    if ($node->pid) $output .= book_export_html_recursive($node->pid, $depth + 1);
    $output .= book_export_html_recursive($node->nid, $depth + 1);
Dries's avatar
 
Dries committed
329
  }
Dries's avatar
 
Dries committed
330

Dries's avatar
 
Dries committed
331 332
  return $output;
}
333

Dries's avatar
 
Dries committed
334
?>