watchdog.module 2.9 KB
Newer Older
Dries's avatar
 
Dries committed
1
<?php
Dries's avatar
 
Dries committed
2

Dries's avatar
 
Dries committed
3 4 5 6
function watchdog_help() {
 ?>
  <P>The watchdog module monitors your website, captures system events in a log and records them to be reviewed by an authorized individual at a later time.  The watchdog log is simply a list of events recorded during operation and contains usage data, performance data, errors, warnings and operational information.  It is vital to check the watchdog report on a regular basis as it is often the only way to tell what is going on.</P>
  <P>To ease administration, the watchdog will automatically remove old logs.</P>
Dries's avatar
 
Dries committed
7
 <?php
Dries's avatar
 
Dries committed
8 9
}

Dries's avatar
 
Dries committed
10
function watchdog_cron() {
Dries's avatar
 
Dries committed
11
  db_query("DELETE FROM watchdog WHERE ". time() ." - timestamp > ". variable_get(watchdog_clear, "302400"));
Dries's avatar
 
Dries committed
12
}
Dries's avatar
 
Dries committed
13

Dries's avatar
 
Dries committed
14
function watchdog_overview() {
Dries's avatar
 
Dries committed
15
  $colors = array(message => "#FFFFFF", special => "#836FFF", warning => "#FFAA22", error => "#EE2C2C");
Dries's avatar
 
Dries committed
16

Dries's avatar
 
Dries committed
17
  $result = db_query("SELECT w.*, u.userid FROM watchdog w LEFT JOIN users u ON w.user = u.id ORDER BY timestamp DESC LIMIT 1000");
Dries's avatar
 
Dries committed
18

Dries's avatar
 
Dries committed
19
  $output .= "<TABLE BORDER=\"1\" CELLPADDING=\"2\" CELLSPACING=\"2\">\n";
Dries's avatar
 
Dries committed
20
  $output .= " <TR><TH>date</TH><TH>type</TH><TH>message</TH><TH>user</TH><TH>operations</TH></TR>\n";
Dries's avatar
 
Dries committed
21
  while ($watchdog = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
22 23 24
    if ($color = $colors[$watchdog->type]) {
      $output .= " <TR BGCOLOR=\"$color\"><TD>". format_date($watchdog->timestamp) ."</TD><TD ALIGN=\"center\">$watchdog->link</TD><TD>". substr(check_output($watchdog->message), 0, 50) ."</TD><TD ALIGN=\"center\">". format_username($watchdog->userid) ."</A></TD><TD ALIGN=\"center\"><A HREF=\"admin.php?mod=watchdog&op=view&id=$watchdog->id\">details</A></TD></TR>\n";
    }
Dries's avatar
 
Dries committed
25 26 27
  }
  $output .= "</TABLE>\n";

Dries's avatar
 
Dries committed
28
  return $output;
Dries's avatar
 
Dries committed
29 30 31
}

function watchdog_view($id) {
Dries's avatar
 
Dries committed
32
  $result = db_query("SELECT l.*, u.userid FROM watchdog l LEFT JOIN users u ON l.user = u.id WHERE l.id = '$id'");
Dries's avatar
 
Dries committed
33 34 35

  if ($watchdog = db_fetch_object($result)) {
    $output .= "<TABLE BORDER=\"1\" CELLPADDING=\"3\" CELLSPACING=\"0\">\n";
Dries's avatar
 
Dries committed
36
    $output .= " <TR><TH>Type:</TH><TD>". check_output($watchdog->type) ."</TD></TR>\n";
Dries's avatar
 
Dries committed
37 38
    $output .= " <TR><TH>Date:</TH><TD>". format_date($watchdog->timestamp, "large") ."</TD></TR>\n";
    $output .= " <TR><TH>User:</TH><TD>". format_username($watchdog->userid) ."</TD></TR>\n";
Dries's avatar
 
Dries committed
39 40 41
    $output .= " <TR><TH>Location:</TH><TD>". check_output($watchdog->location). "</TD></TR>\n";
    $output .= " <TR><TH>Message:</TH><TD>". check_output($watchdog->message) ."</TD></TR>\n";
    $output .= " <TR><TH>Hostname:</TH><TD>". check_output($watchdog->hostname) ."</TD></TR>\n";
Dries's avatar
 
Dries committed
42
    $output .= "</TABLE>\n";
Dries's avatar
 
Dries committed
43

Dries's avatar
 
Dries committed
44 45
    return $output;
  }
Dries's avatar
 
Dries committed
46 47
}

Dries's avatar
 
Dries committed
48 49 50
function watchdog_admin() {
  global $op, $id, $order;

Dries's avatar
 
Dries committed
51 52
  print "<SMALL><A HREF=\"admin.php?mod=watchdog\">overview</A> | <A HREF=\"admin.php?mod=watchdog&op=help\">help</A></SMALL><HR>\n";

Dries's avatar
 
Dries committed
53
  switch ($op) {
Dries's avatar
 
Dries committed
54 55 56
    case "help":
      watchdog_help();
      break;
Dries's avatar
 
Dries committed
57
    case "view":
Dries's avatar
 
Dries committed
58
      print watchdog_view(check_input($id));
Dries's avatar
 
Dries committed
59 60
      break;
    default:
Dries's avatar
 
Dries committed
61
      print watchdog_overview();
Dries's avatar
 
Dries committed
62 63 64 65
  }
}

?>