X-Git-Url: https://ruin.nu/git/%3CTMPL_VAR%20NAME=PAGE%3E?a=blobdiff_plain;f=Commands%2FUsermgm.pm;h=a5e3abf8a70ff478cc01e5ac9640b112e2760722;hb=899a2860f3816042c168b995616fc7425732e878;hp=3501120f10d38b03f8e2b6343f5c98bea056dbf9;hpb=fc37239d5f764e9f0f7c113a03fc52d264699725;p=NDIRC.git diff --git a/Commands/Usermgm.pm b/Commands/Usermgm.pm index 3501120..a5e3abf 100644 --- a/Commands/Usermgm.pm +++ b/Commands/Usermgm.pm @@ -45,7 +45,7 @@ FROM users WHERE username = $1 OR hostmask = $2 OR pnick = $3 $c->reply("$username ($p_nick) already exists with host: $hostname"); }else{ $dbh->do(q{ -INSERT INTO users (username,hostmask,pnick,password) VALUES(?,?,?,'') +INSERT INTO users (username,hostmask,pnick) VALUES($1,$2,$3) },undef,$nick,$host,$pnick); $c->reply("Added $nick(/$pnick) with host: $host"); } @@ -67,7 +67,7 @@ command '-user' => { if ($f->rows == 1){ my $updated = $dbh->do(q{ -UPDATE users SET hostmask = ?, password = '' WHERE uid = ? +UPDATE users SET hostmask = $1, password = NULL WHERE uid = $2 },undef,$username,$uid); if ($updated > 0){ my $groups = $dbh->do(q{DELETE FROM groupmembers WHERE uid = ?},undef,$uid);