Add basic oplog

It still needs to be integrated with switches/info box, but this is a good
start.

Shows the last 5 log messages in an overlay on the map, with the rest
visible in an oplog tab.

Fixes #20

1 files changed, 22 insertions, 0 deletions

diff --git a/web/api/read/oplog b/web/api/read/oplog
new file mode 100755
index 0000000..d56890a
--- /dev/null
+++ b/web/api/read/oplog
@@ -0,0 +1,22 @@
+#! /usr/bin/perl
+# vim:ts=8:sw=8
+
+use lib '/opt/gondul/include';
+use nms::web;
+use strict;
+use warnings;
+
+my $query = $nms::web::dbh->prepare('select id,time as timestamp,extract(hour from time) as h, extract(minute from time) as m,systems,username,log from oplog order by id desc;');
+$query->execute();
+while (my $ref = $query->fetchrow_hashref()) {
+	my %meh;
+	$meh{'time'} = $ref->{'h'} . ":" . $ref->{'m'};
+	$meh{'log'} = $ref->{'log'};
+	$meh{'username'} = $ref->{'username'};
+	$meh{'id'} = $ref->{'id'};
+	$meh{'systems'} = $ref->{'systems'};
+	$meh{'timestamp'} = $ref->{'timestamp'};
+	push @{$nms::web::json{'oplog'}},\%meh;
+}
+
+nms::web::finalize_output();