summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-06-17 08:29:10 +0200
committerYorhel <git@yorhel.nl>2022-06-17 08:29:10 +0200
commitf5f3fa2dab23b6a20325a45bd080bdd2aae420de (patch)
tree5fa3688f896ad5ea37ab2bae8c38f6f3c186ba9b
parent5acdb6f9ea915c50e0a6c5614154641bb8395574 (diff)
User::Edit: Fix permissions editing for mods
-rw-r--r--lib/VNWeb/User/Edit.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/VNWeb/User/Edit.pm b/lib/VNWeb/User/Edit.pm
index 1e132937..8d3934fe 100644
--- a/lib/VNWeb/User/Edit.pm
+++ b/lib/VNWeb/User/Edit.pm
@@ -210,8 +210,8 @@ elm_api UserEdit => $FORM_OUT, $FORM_IN, sub {
}
my $old = tuwf->dbRowi('SELECT', sql_comma(keys %set, keys %setp), 'FROM users u JOIN users_prefs up ON up.id = u.id WHERE u.id =', \$data->{id});
- tuwf->dbExeci('UPDATE users SET', \%set, 'WHERE id =', \$data->{id});
- tuwf->dbExeci('UPDATE users_prefs SET', \%setp, 'WHERE id =', \$data->{id});
+ tuwf->dbExeci('UPDATE users SET', \%set, 'WHERE id =', \$data->{id}) if keys %set;
+ tuwf->dbExeci('UPDATE users_prefs SET', \%setp, 'WHERE id =', \$data->{id}) if keys %setp;
my $new = tuwf->dbRowi('SELECT', sql_comma(keys %set, keys %setp), 'FROM users u JOIN users_prefs up ON up.id = u.id WHERE u.id =', \$data->{id});
$_ = JSON::XS->new->allow_nonref->encode($_) for values %$old, %$new;