aboutsummaryrefslogtreecommitdiffstats
path: root/web/nms.gathering.org/comment-add.pl
diff options
context:
space:
mode:
Diffstat (limited to 'web/nms.gathering.org/comment-add.pl')
-rwxr-xr-xweb/nms.gathering.org/comment-add.pl25
1 files changed, 25 insertions, 0 deletions
diff --git a/web/nms.gathering.org/comment-add.pl b/web/nms.gathering.org/comment-add.pl
new file mode 100755
index 0000000..262d625
--- /dev/null
+++ b/web/nms.gathering.org/comment-add.pl
@@ -0,0 +1,25 @@
+#! /usr/bin/perl
+use CGI qw(fatalsToBrowser);
+use DBI;
+use lib '../../include';
+use utf8;
+use nms;
+use strict;
+use warnings;
+use Data::Dumper;
+
+my $cgi = CGI->new;
+
+my $dbh = nms::db_connect();
+
+my $data = $dbh->quote($cgi->param('comment') || die );
+my $switch = $dbh->quote($cgi->param('switch') || die );
+my $user = $dbh->quote($cgi->remote_user() || "undefined");
+
+
+my $q = $dbh->prepare("INSERT INTO switch_comments (time,username,switch,comment) values (now(),$user,(select switch from switches where sysname = $switch limit 1),$data)");
+$q->execute();
+
+print $cgi->header(-type=>'text/json; charset=utf-8');
+print "{ 'state': 'ok' }";
+