book.module 11.7 KB
Newer Older
Dries's avatar
 
Dries committed
1 2 3
<?php

$module = array("find" => "book_find",
Dries's avatar
 
Dries committed
4
                "type" => "book_type",
Dries's avatar
 
Dries committed
5
                "page" => "book_page",
Dries's avatar
 
Dries committed
6
                "user" => "book_user",
Dries's avatar
 
Dries committed
7 8
                "admin" => "book_admin",
                "export" => "book_export");
Dries's avatar
 
Dries committed
9

Dries's avatar
 
Dries committed
10 11 12 13 14 15 16 17 18 19 20 21
class Book {
  function Book($nid, $userid, $title, $body, $parent, $weight, $timestamp) {
    $this->nid = $nid;
    $this->userid = $userid;
    $this->title = $title;
    $this->body = $body;
    $this->parent = $parent;
    $this->weight = $weight;
    $this->timestamp = $timestamp;
  }
}

Dries's avatar
 
Dries committed
22 23 24 25
function book_status() {
  return array(dumped, expired, queued, posted);
}

Dries's avatar
 
Dries committed
26 27 28 29 30 31 32 33 34
function book_location($node, $nodes = array()) {
  $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 AND n.lid = b.lid WHERE n.nid = '$node->parent'"));
  if ($parent->title) {
    $nodes = book_location($parent, $nodes);
    array_push($nodes, $parent);
  }
  return $nodes;
}

Dries's avatar
 
Dries committed
35 36 37 38
function book_type() {
  return array("book", t("book page"));
}

Dries's avatar
 
Dries committed
39
function book_view($node, $main = 0) {
Dries's avatar
 
Dries committed
40 41
  global $theme;

Dries's avatar
 
Dries committed
42 43 44 45 46 47 48
  if ($node->nid && $node->parent) {
    $next = db_fetch_object(db_query("SELECT n.nid, n.title FROM node n LEFT JOIN book b ON n.nid = b.nid AND n.lid = b.lid WHERE b.parent = '$node->parent' AND b.weight > '$node->weight' ORDER BY b.weight ASC"));
    $prev = db_fetch_object(db_query("SELECT n.nid, n.title FROM node n LEFT JOIN book b ON n.nid = b.nid AND n.lid = b.lid WHERE b.parent = '$node->parent' AND b.weight < '$node->weight' ORDER BY b.weight DESC"));
  }

  $output .= "<TABLE BORDER=\"0\" CELLPADDING=\"0\" CELLSPACING=\"0\" WIDTH=\"100%\">\n";

Dries's avatar
 
Dries committed
49
  if ($node->title) {
Dries's avatar
 
Dries committed
50 51 52 53 54 55
    foreach (book_location($node) as $level) {
      $location .= "$indent <A HREF=\"node.php?id=$level->nid\">$level->title</A><BR>";
      $indent .= "-";
    }

    $output .= " <TR><TD COLSPAN=\"2\">$location</TD><TD ALIGN=\"right\">". node_control($node) ."</TD></TR>\n";
56
    $output .= " <TR><TD COLSPAN=\"3\"><HR></TD></TR>";
Dries's avatar
 
Dries committed
57
    $output .= " <TR><TD COLSPAN=\"3\"><B><BIG>". check_output($node->title) ."</BIG></B>". ($node->body ? "<BR><SMALL><I>Last updated by ". format_username($node->userid) ." on ". format_date($node->timestamp) ."</I></SMALL> " : "") ."</TD></TR>\n";
Dries's avatar
 
Dries committed
58
  }
Dries's avatar
 
Dries committed
59

Dries's avatar
 
Dries committed
60
  if ($node->body) {
Dries's avatar
 
Dries committed
61
    $output .= " <TR><TD COLSPAN=\"3\"><BR>". check_output($node->body, 1) ."</TD></TR>";
Dries's avatar
 
Dries committed
62 63
  }

Dries's avatar
 
Dries committed
64 65
  $output .= " <TR><TD COLSPAN=\"3\"><BR>". book_tree($node->nid) ."</TD></TR>";
  $output .= " <TR><TD COLSPAN=\"3\"><HR></TD></TR>";
Dries's avatar
 
Dries committed
66 67 68 69
  $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
70
  $theme->box(t("Handbook"), $output);
Dries's avatar
 
Dries committed
71 72 73
}

function book_find($keys) {
Dries's avatar
 
Dries committed
74
  global $status, $user;
Dries's avatar
 
Dries committed
75
  $find = array();
Dries's avatar
 
Dries committed
76
  $result = db_query("SELECT n.*, u.userid FROM node n LEFT JOIN book b ON n.nid = b.nid AND n.lid = b.lid LEFT JOIN users u ON n.author = u.id 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
77 78 79 80 81 82
  while ($node = db_fetch_object($result)) {
    array_push($find, array("title" => check_output($node->title), "link" => (user_access($user, "book") ? "admin.php?mod=book&op=edit&id=$node->nid" : "node.php?id=$node->nid"), "user" => $node->userid, "date" => $node->timestamp));
  }
  return $find;
}

Dries's avatar
 
Dries committed
83
function book_toc($parent = 0, $indent = "", $toc = array()) {
Dries's avatar
 
Dries committed
84
  global $status;
Dries's avatar
 
Dries committed
85
  $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid AND n.lid = b.lid WHERE n.type = 'book' AND n.status = '$status[posted]' AND b.parent = '$parent' ORDER BY b.weight");
Dries's avatar
 
Dries committed
86
  while ($node = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
87 88 89
    $toc[$node->nid] = "$indent $node->title";
    if ($node->pid) $toc = book_toc($node->pid, "$indent-", $toc);
    $toc = book_toc($node->nid, "$indent-", $toc);
Dries's avatar
 
Dries committed
90 91 92 93
  }
  return $toc;
}

Dries's avatar
 
Dries committed
94
function book_form($edit = array()) {
Dries's avatar
 
Dries committed
95
  global $allowed_html, $PHP_SELF, $REQUEST_URI, $user;
Dries's avatar
 
Dries committed
96

Dries's avatar
 
Dries committed
97
  $output .= "<FORM ACTION=\"$REQUEST_URI\" METHOD=\"post\">\n";
Dries's avatar
 
Dries committed
98

Dries's avatar
 
Dries committed
99 100 101 102
  $output .= form_item(t("Author"), format_username(($edit[userid] ? $edit[userid] : $user->userid)));
  $output .= form_hidden(userid, $edit[userid]);
  $output .= form_textfield(t("Subject"), "title", $edit[title], 50, 128);
  $output .= form_item(t("Category"), category_form_select("book", $edit));
Dries's avatar
 
Dries committed
103

Dries's avatar
 
Dries committed
104 105
  if ($edit[pid]) {
    $node = node_get_object("nid", $edit[pid]);
Dries's avatar
 
Dries committed
106 107
    $output .= form_item(t("Parent"), "<A HREF=\"node.php?id=$node->id\">". check_output($node->title) ."</A>", t("The parent subject or category the page belongs in."));
    $output .= form_hidden("parent". $edit[parent]);
Dries's avatar
 
Dries committed
108 109
  }
  else {
Dries's avatar
 
Dries committed
110
    $output .= form_select(t("Parent"), "parent", user_access($user, "book") ? array_merge(array(0 => "&nbsp;"), book_toc()) : book_toc(), $edit[parent], t("The parent subject or category the page belongs in."));
Dries's avatar
 
Dries committed
111
  }
Dries's avatar
 
Dries committed
112

Dries's avatar
 
Dries committed
113 114
  $output .= form_textarea(t("Content"), "body", $edit[body], 50, 10, t("Allowed HTML tags") .": ". htmlspecialchars($allowed_html));
  $output .= form_textarea(t("Log message"), "log", $edit[log], 50, 5, t("An explanation of the additions or updates being made to help the group understand your motivations."));
Dries's avatar
 
Dries committed
115

Dries's avatar
 
Dries committed
116
  if (user_access($user, "book")) {
Dries's avatar
 
Dries committed
117
    $output .= form_select(t("Weight"), "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), $edit[weight], t("The heavier nodes will sink and the lighter nodes will be positioned nearer the top."));
Dries's avatar
 
Dries committed
118 119 120
  }

  if (!$edit) {
Dries's avatar
 
Dries committed
121
    $output .= form_submit(t("Preview"));
Dries's avatar
 
Dries committed
122 123 124
  }
  else if (!$edit[title]) {
    $output .= "<FONT COLOR=\"red\">". t("Warning: you did not supply a title.") ."</FONT><P>\n";
Dries's avatar
 
Dries committed
125
    $output .= form_submit(t("Preview"));
Dries's avatar
 
Dries committed
126 127
  }
  else {
Dries's avatar
 
Dries committed
128 129
    $output .= form_submit(t("Preview"));
    $output .= form_submit(t("Submit"));
Dries's avatar
 
Dries committed
130 131
  }

Dries's avatar
 
Dries committed
132 133
  $output .= form_hidden("pid", $edit[pid]);
  $output .= form_hidden("nid", $edit[nid]);
Dries's avatar
 
Dries committed
134

Dries's avatar
 
Dries committed
135 136 137 138 139 140
  $output .= "</FORM>\n";

  return $output;
}

function book_save($edit) {
Dries's avatar
 
Dries committed
141
  node_save(array_diff(array_merge($edit, array(nid => $edit[nid], type => "book")), array(userid => $edit[userid])));
Dries's avatar
 
Dries committed
142 143
}

Dries's avatar
Dries committed
144
function book_tree($parent = "", $depth = 0) {
Dries's avatar
 
Dries committed
145
  global $PHP_SELF, $status;
Dries's avatar
 
Dries committed
146

Dries's avatar
 
Dries committed
147
  if (($depth < 3) || (strstr($PHP_SELF,"admin.php"))) {
Dries's avatar
Dries committed
148 149 150 151 152 153 154 155 156
    $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid AND n.lid = b.lid WHERE n.type = 'book' AND n.status = '$status[posted]' AND b.parent = '$parent' ORDER BY b.weight");
    $output .= "<UL>";
    while ($node = db_fetch_object($result)) {
      $output .= "<LI><A HREF=\"node.php?id=$node->nid\">". check_output($node->title) ."</A>";
      if ($PHP_SELF == "/admin.php") $output .= " <SMALL>(weight: $node->weight/$node->parent, status: $node->status) (<A HREF=\"admin.php?mod=book&op=edit&id=$node->nid\">edit</A>)</SMALL>\n";
      if ($node->pid) $output .= book_tree($node->pid, $depth + 1);
      $output .= book_tree($node->nid, $depth + 1);
    }
    $output .= "</UL>";
Dries's avatar
 
Dries committed
157
  }
Dries's avatar
 
Dries committed
158 159 160
  return $output;
}

Dries's avatar
 
Dries committed
161 162
function book_list($query = array()) {
  return node_overview($query);
Dries's avatar
 
Dries committed
163 164
}

Dries's avatar
 
Dries committed
165 166
function book_query($type = "") {
  global $status;
Dries's avatar
 
Dries committed
167
  $queries =  array(array("recent book pages", "WHERE n.type = 'book' ORDER BY n.timestamp DESC"), array("posted book pages", "WHERE n.type = 'book' AND n.status = '$status[posted]' ORDER BY n.timestamp DESC"), array("queued book pages", "WHERE n.type = 'book' AND n.status = '$status[queued]' ORDER BY n.timestamp DESC"), array("dumped book pages", "WHERE n.type = 'book' AND n.status = '$status[dumped]' ORDER BY n.timestamp DESC"));
Dries's avatar
 
Dries committed
168 169 170
  return ($queries[$type] ? $queries[$type] : $queries);
}

Dries's avatar
 
Dries committed
171
function book_admin() {
Dries's avatar
 
Dries committed
172 173 174
  global $op, $id, $edit, $mod, $keys, $type, $user;

  print "<SMALL><A HREF=\"admin.php?mod=book&op=add\">add new page</A> | <A HREF=\"admin.php?mod=book&op=listing\">book listing</A> | <A HREF=\"admin.php?mod=book&op=search\">search book</A> | <A HREF=\"admin.php?mod=book\">list overview</A> | <A HREF=\"admin.php?mod=book&op=tree\">tree overview</A></SMALL><HR>\n";
Dries's avatar
 
Dries committed
175

Dries's avatar
 
Dries committed
176
  $type = $type ? $type : 0;
Dries's avatar
 
Dries committed
177 178 179 180 181 182 183 184

  switch ($op) {
    case "add":
      print book_form();
      break;
    case "edit":
      print book_form(node_get_array(nid, $id));
      break;
Dries's avatar
 
Dries committed
185
    case "listing":
Dries's avatar
 
Dries committed
186
      print node_listing(book_query());
Dries's avatar
 
Dries committed
187
      break;
Dries's avatar
 
Dries committed
188
    case "search":
Dries's avatar
 
Dries committed
189 190
      print search_form($keys);
      print search_data($keys, $mod);
Dries's avatar
 
Dries committed
191
      break;
Dries's avatar
 
Dries committed
192 193 194
    case "tree":
      print book_tree();
      break;
Dries's avatar
 
Dries committed
195
    case t("Preview"):
Dries's avatar
 
Dries committed
196
      book_view(new Book(($edit[nid] ? $edit[nid] : -1), ($edit[userid] ? $edit[userid] : $user->userid), $edit[title], $edit[body], $edit[parent], $edit[weight], ($edit[timestamp] ? $edit[timestamp] : time())));
Dries's avatar
 
Dries committed
197 198 199 200
      print book_form($edit);
      break;
    case t("Submit"):
      book_save($edit);
Dries's avatar
 
Dries committed
201
      // fall through:
Dries's avatar
 
Dries committed
202
    default:
Dries's avatar
 
Dries committed
203
      print book_list(book_query($type));
Dries's avatar
 
Dries committed
204 205 206
  }
}

Dries's avatar
Dries committed
207 208 209
function book_page() {
  global $status, $theme;

Dries's avatar
Dries committed
210
  $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid AND n.lid = b.lid WHERE b.parent = 0 AND n.status = $status[posted] ORDER BY b.weight");
Dries's avatar
Dries committed
211 212

  while ($node = db_fetch_object($result)) {
Dries's avatar
- typo  
Dries committed
213
    $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
214 215 216
  }

  $theme->header();
Dries's avatar
 
Dries committed
217
  $theme->box(t("Handbook"), "<DL>$output</DL>");
Dries's avatar
Dries committed
218
  $theme->footer();
Dries's avatar
 
Dries committed
219 220
}

Dries's avatar
 
Dries committed
221 222 223 224 225 226 227 228
function book_update($id) {
  global $status;

  if ($node = node_get_object("nid", $id)) {
    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.");
    }
    else if (db_result(db_query("SELECT COUNT(nid) FROM node WHERE pid = '$node->nid' AND status = '$status[queued]'"))) {
Dries's avatar
 
Dries committed
229
      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
230 231 232 233 234 235 236
    }
    else {
      return book_form(array(nid => -1, pid => $id, title => $node->title, body => $node->body, parent => $node->parent));
    }
  }
}

Dries's avatar
 
Dries committed
237 238 239
function book_user() {
  global $edit, $id, $op, $theme, $user;

Dries's avatar
 
Dries committed
240
  $title = t("Submit");
Dries's avatar
 
Dries committed
241

Dries's avatar
 
Dries committed
242 243
  switch($op) {
    case "update":
Dries's avatar
 
Dries committed
244
      $theme->box($title, book_update($id));
Dries's avatar
 
Dries committed
245 246
      break;
    case t("Preview"):
Dries's avatar
 
Dries committed
247
      book_view(new Book(($edit[nid] ? $edit[nid] : -1), $user->userid, $edit[title], $edit[body], $edit[parent], $edit[weight], ($edit[timestamp] ? $edit[timestamp] : time())));
Dries's avatar
 
Dries committed
248
      $theme->box($title, book_form($edit));
Dries's avatar
 
Dries committed
249 250 251
      break;
    case t("Submit"):
      book_save($edit);
Dries's avatar
 
Dries committed
252
      $theme->box($title, t("Thank you for your submission."));
Dries's avatar
 
Dries committed
253 254
      break;
    default:
Dries's avatar
 
Dries committed
255
      $theme->box($title, book_form());
Dries's avatar
 
Dries committed
256 257 258
  }
}

Dries's avatar
 
Dries committed
259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278
function book_export_html($parent = "", $depth = 0) {
  global $status;

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

  while ($node = db_fetch_object($result)) {
    $output .= "<H$depth>". check_output($node->title) ."</H$depth>";
    if ($node->body) $output .= check_output($node->body, 1);
    if ($node->pid) $output .= book_export_html($node->pid, $depth + 1);
    $output .= book_export_html($node->nid, $depth + 1);
  }
  return $output;
}

function book_export($uri) {
  if ($uri[2] == "book") {
    print book_export_html($uri[3], $depth = 1);
  }
}

Dries's avatar
 
Dries committed
279
?>