diff options
author | Yorhel <git@yorhel.nl> | 2022-06-17 08:29:10 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-06-17 08:29:10 +0200 |
commit | f5f3fa2dab23b6a20325a45bd080bdd2aae420de (patch) | |
tree | 5fa3688f896ad5ea37ab2bae8c38f6f3c186ba9b | |
parent | 5acdb6f9ea915c50e0a6c5614154641bb8395574 (diff) |
User::Edit: Fix permissions editing for mods
-rw-r--r-- | lib/VNWeb/User/Edit.pm | 4 |
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; |