aboutsummaryrefslogtreecommitdiffstats
path: root/web/nms.gathering.org/api/private/comment-add
diff options
context:
space:
mode:
authorKristian Lyngstol <kristian@bohemians.org>2016-03-13 22:04:00 +0100
committerKristian Lyngstol <kristian@bohemians.org>2016-03-13 22:04:00 +0100
commita57fe6b9a707222e0ca1b4e18a542b5b179e6b72 (patch)
treed342d858c8e142dafb76bb5d326ec1ebb3e040b3 /web/nms.gathering.org/api/private/comment-add
parent8a89ee32f56e37848ad29be033b095c46b7ce9e3 (diff)
parentfe776bbc6f2e62436acea72f2f3bf027a6138ed8 (diff)
Merge branch 'master' of github.com:tech-server/tgmanage
Diffstat (limited to 'web/nms.gathering.org/api/private/comment-add')
-rwxr-xr-xweb/nms.gathering.org/api/private/comment-add11
1 files changed, 7 insertions, 4 deletions
diff --git a/web/nms.gathering.org/api/private/comment-add b/web/nms.gathering.org/api/private/comment-add
index beb7b21..2f8b0b7 100755
--- a/web/nms.gathering.org/api/private/comment-add
+++ b/web/nms.gathering.org/api/private/comment-add
@@ -2,13 +2,16 @@
# vim:ts=8:sw=8
use lib '../../../../include';
use utf8;
-use nms::web;
+use nms::web qw($dbh db_safe_quote get_input finalize_output);
use strict;
use warnings;
-my $data = db_safe_quote('comment');
-my $switch = db_safe_quote('switch');
-my $user = $dbh->quote($cgi->remote_user() || "undefined");
+my $in = get_input();
+my %tmp = %{JSON::XS::decode_json($in)};
+
+my $data = $dbh->quote($tmp{'comment'});
+my $switch = $dbh->quote($tmp{'switch'});
+my $user = $dbh->quote($ENV{'REMOTE_USER'} || "undefined");
my $q = $nms::web::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();