From b8314f8319f00c9bb507d67f11ab8e75d1ca659f Mon Sep 17 00:00:00 2001 From: Kristian Lyngstol Date: Thu, 10 Mar 2016 18:19:10 +0000 Subject: nms: Fix comments (presumably) --- web/nms.gathering.org/api/private/comment-add | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'web') diff --git a/web/nms.gathering.org/api/private/comment-add b/web/nms.gathering.org/api/private/comment-add index beb7b21..7ad386e 100755 --- a/web/nms.gathering.org/api/private/comment-add +++ b/web/nms.gathering.org/api/private/comment-add @@ -2,13 +2,13 @@ # vim:ts=8:sw=8 use lib '../../../../include'; use utf8; -use nms::web; +use nms::web qw($dbh db_safe_quote); 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 $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(); -- cgit v1.2.3