diff options
Diffstat (limited to 'web/nms.gathering.org/comment-add.pl')
-rwxr-xr-x | web/nms.gathering.org/comment-add.pl | 25 |
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' }"; + |