node.module 5.62 KB
Newer Older
Dries's avatar
 
Dries committed
1 2 3 4
<?php

$module = array("admin" => "node_admin");

Dries's avatar
 
Dries committed
5
function node_overview($query = array()) {
Dries's avatar
 
Dries committed
6
  global $user, $rstatus;
Dries's avatar
 
Dries committed
7

Dries's avatar
 
Dries committed
8
  $result = db_query("SELECT n.*, u.userid, c.name AS category FROM node n LEFT JOIN users u ON n.author = u.id LEFT JOIN category c ON n.cid = c.cid $query[1] LIMIT 50");
Dries's avatar
 
Dries committed
9

Dries's avatar
 
Dries committed
10
  $output .= status($query[0]);
Dries's avatar
 
Dries committed
11
  $output .= "<TABLE BORDER=\"1\" CELLPADDING=\"2\" CELLSPACING=\"2\">\n";
Dries's avatar
 
Dries committed
12
  $output .= " <TR><TH>title</TH><TH>category</TH><TH>status</TH><TH>author</TH><TH>date</TH><TH COLSPAN=\"3\">operations</TH></TR>\n";
Dries's avatar
 
Dries committed
13
  while ($node = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
14
    $output .= " <TR><TD><A HREF=\"node.php?id=$node->nid\">". check_output($node->title) ."</A></TD><TD ALIGN=\"center\">". check_output($node->category ? $node->category : $node->type) ."</TD><TD>". $rstatus[$node->status] ."</TD><TD>". format_username($node->userid) ."</TD><TD>". format_date($node->timestamp, "small") ."</TD><TD>". (user_access($user, "node") ? "<A HREF=\"admin.php?mod=node&op=view&id=$node->nid\">view node</A></TD>" : "view node") ."</TD><TD>". (user_access($user, "node") ? "<A HREF=\"admin.php?mod=node&op=edit&id=$node->nid\">edit node</A></TD>" : "edit node") ."</TD><TD>". (user_access($user, $node->type) ? "<A HREF=\"admin.php?mod=$node->type&op=edit&id=$node->nid\">edit $node->type</A></TD>" : "edit $node->type") ."</TD></TR>\n";
Dries's avatar
 
Dries committed
15 16 17 18 19 20 21
  }
  $output .= "</TABLE>\n";

  return $output;
}

function node_admin_view($id) {
Dries's avatar
 
Dries committed
22
  global $rstatus;
Dries's avatar
 
Dries committed
23 24 25 26 27 28

  $node = node_get_object("nid", $id);

  $output .= "<FORM ACTION=\"admin.php?mod=node&id=$node->nid\" METHOD=\"post\">\n";
  $output .= "<B>Title:</B><BR>". check_output($node->title) ."<P>\n";
  $output .= "<B>Author:</B><BR>". format_username($node->userid) ."<P>\n";
Dries's avatar
 
Dries committed
29
  $output .= "<B>Status:</B><BR>". $rstatus[$node->status] ."<P>\n";
Dries's avatar
 
Dries committed
30 31
  $output .= "<B>Comment:</B><BR>". node_comment_status($node->comment) ."<P>\n";
  $output .= "<B>Promote:</B><BR>". node_promote_status($node->promote) ."<P>\n";
Dries's avatar
 
Dries committed
32 33 34 35 36 37 38 39 40
  $output .= "<B>Date:</B><BR>". format_date($node->timestamp) ."<P>\n";
  $output .= "<INPUT TYPE=\"submit\" NAME=\"op\" VALUE=\"Edit node\">\n";
  $output .= "<INPUT TYPE=\"submit\" NAME=\"op\" VALUE=\"Delete node\">\n";
  $output .= "</FORM>\n";

  return $output;
}

function node_admin_edit($id) {
Dries's avatar
 
Dries committed
41
  global $user, $status;
Dries's avatar
 
Dries committed
42 43 44 45 46

  $node = node_get_object("nid", $id);

  foreach (array($node->userid => $node->author, $user->userid => $user->id) as $value=>$key) $author .= " <OPTION VALUE=\"$key\"". (($node->author == $key) ? " SELECTED" : "") .">$value</OPTION>\n";
  foreach (array(format_date($node->timestamp) ." (original)" => $node->timestamp, format_date(time()) ." (current)" => time()) as $value=>$key) $timestamp .= " <OPTION VALUE=\"$key\"". (($node->timestamp == $key) ? " SELECTED" : "") .">$value</OPTION>\n";
Dries's avatar
 
Dries committed
47
  foreach (node_status($node) as $value) $display .= " <OPTION VALUE=\"". $status[$value] ."\"". (($node->status == $status[$value]) ? " SELECTED" : "") .">$value</OPTION>\n";
Dries's avatar
 
Dries committed
48 49
  foreach (node_comment_status() as $key=>$value) $comment .= " <OPTION VALUE=\"$key\"". ($node->comment == $key ? " SELECTED" : "") .">$value</OPTION>\n";
  foreach (node_promote_status() as $key=>$value) $promote .= " <OPTION VALUE=\"$key\"". ($node->promote == $key ? " SELECTED" : "") .">$value</OPTION>\n";
Dries's avatar
 
Dries committed
50 51 52 53

  $output .= "<FORM ACTION=\"admin.php?mod=node&id=$node->nid\" METHOD=\"post\">\n";
  $output .= "<B>Title:</B><BR>". check_output($node->title) ."<P>\n";
  $output .= "<B>Author:</B><BR><SELECT NAME=\"edit[author]\">$author</SELECT><P>\n";
Dries's avatar
 
Dries committed
54 55
  $output .= "<B>Status:</B><BR><SELECT NAME=\"edit[status]\">$display</SELECT><P>\n";
  $output .= "<B>Comment:</B><BR><SELECT NAME=\"edit[comment]\">$comment</SELECT><P>\n";
Dries's avatar
 
Dries committed
56
  $output .= "<B>Promote:</B><BR><SELECT NAME=\"edit[promote]\">$promote</SELECT><P>\n";
Dries's avatar
 
Dries committed
57 58 59 60 61 62 63 64 65 66
  $output .= "<B>Date:</B><BR><SELECT NAME=\"edit[timestamp]\">$timestamp</SELECT><P>\n";
  $output .= "<INPUT TYPE=\"hidden\" NAME=\"edit[nid]\" VALUE=\"$node->nid\">\n";
  $output .= "<INPUT TYPE=\"submit\" NAME=\"op\" VALUE=\"View node\">\n";
  $output .= "<INPUT TYPE=\"submit\" NAME=\"op\" VALUE=\"Save node\">\n";
  $output .= "</FORM>\n";

  return $output;
}

function node_delete($id) {
Dries's avatar
 
Dries committed
67
  return (node_del("nid", $id) ? "node has been deleted." : "failed to delete node: node must be dumped first.");
Dries's avatar
 
Dries committed
68 69
}

Dries's avatar
 
Dries committed
70 71
function node_query($type = "") {
  global $status;
Dries's avatar
 
Dries committed
72
  $queries =  array(array("recent nodes", "ORDER BY n.timestamp DESC"), array("posted nodes", "WHERE n.status = '$status[posted]' ORDER BY n.timestamp DESC"), array("queued nodes", "WHERE n.status = '$status[queued]' ORDER BY n.timestamp DESC"), array("dumped nodes", "WHERE n.status = '$status[dumped]' ORDER BY n.timestamp DESC"));
Dries's avatar
 
Dries committed
73 74 75
  return ($queries[$type] ? $queries[$type] : $queries);
}

Dries's avatar
 
Dries committed
76 77 78 79
function node_listing($queries) {
  global $mod;
  foreach ($queries as $key=>$array) {
    $output .= "<LI><A HREF=\"admin.php?mod=$mod&type=$key\">$array[0]</A></LI>\n";
Dries's avatar
 
Dries committed
80 81 82 83
  }
  return "<OL>$output</OL>\n";
}

Dries's avatar
 
Dries committed
84
function node_admin() {
Dries's avatar
 
Dries committed
85 86 87
  global $op, $id, $edit, $type;

  print "<SMALL><A HREF=\"admin.php?mod=node&op=listing\">node listings</A> | <A HREF=\"admin.php?mod=node\">overview</A></SMALL><HR>\n";
Dries's avatar
 
Dries committed
88 89

  $id = check_input($edit[nid] ? $edit[nid] : $id);
Dries's avatar
 
Dries committed
90
  $type = ($type ? $type : 0);
Dries's avatar
 
Dries committed
91 92 93 94 95 96 97 98 99 100

  switch ($op) {
    case "Edit node":
    case "edit":
      print node_admin_edit($id);
      break;
    case "Delete node":
      print status(node_delete($id));
      print node_overview();
      break;
Dries's avatar
 
Dries committed
101
    case "listing":
Dries's avatar
 
Dries committed
102
      print node_listing(node_query());
Dries's avatar
 
Dries committed
103
      break;
Dries's avatar
 
Dries committed
104
    case "Save node":
Dries's avatar
 
Dries committed
105
      node_save($edit);
Dries's avatar
 
Dries committed
106
      print node_admin_view($id);
Dries's avatar
 
Dries committed
107 108 109 110 111 112
      break;
    case "View node":
    case "view":
      print node_admin_view($id);
      break;
    default:
Dries's avatar
 
Dries committed
113
      print node_overview(node_query($type));
Dries's avatar
 
Dries committed
114 115 116 117
  }
}

?>