$c->reply("<b>$username ($p_nick)</b> already exists with host: <b>$hostname</b>");
}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 <b>$nick(/$pnick)</b> with host: <b>$host</b>");
}
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);