diff options
author | Kristian Lyngstol <kristian@bohemians.org> | 2016-03-13 22:04:00 +0100 |
---|---|---|
committer | Kristian Lyngstol <kristian@bohemians.org> | 2016-03-13 22:04:00 +0100 |
commit | a57fe6b9a707222e0ca1b4e18a542b5b179e6b72 (patch) | |
tree | d342d858c8e142dafb76bb5d326ec1ebb3e040b3 /web/nms.gathering.org/api/private/comment-add | |
parent | 8a89ee32f56e37848ad29be033b095c46b7ce9e3 (diff) | |
parent | fe776bbc6f2e62436acea72f2f3bf027a6138ed8 (diff) |
Merge branch 'master' of github.com:tech-server/tgmanage
Diffstat (limited to 'web/nms.gathering.org/api/private/comment-add')
-rwxr-xr-x | web/nms.gathering.org/api/private/comment-add | 11 |
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(); |