my $host = "$pnick.users.netgamers.org";
my ($username,$hostname,$p_nick) = $dbh->selectrow_array(q{
SELECT username, hostmask,pnick
-FROM users WHERE username ILIKE ? OR hostmask ILIKE ? OR pnick ILIKE ?
+FROM users WHERE username = $1 OR hostmask = $2 OR pnick = $3
},undef,$nick,$host,$pnick);
if (defined $username){
if($@){
if ($@ =~ /duplicate key value violates unique constraint/){
my ($username, $hostname) = $dbh->selectrow_array(q{
-SELECT username,hostmask FROM users WHERE hostmask ILIKE $1
+SELECT username,hostmask FROM users WHERE hostmask = $1
},undef,$host);
$c->reply("<c04>Problem</c>, <b>$username</b> already uses host <b>$hostname</b>.");
}else{
if($@){
if ($@ =~ /duplicate key value violates unique constraint/){
my ($username, $hostname, $pnick) = $dbh->selectrow_array(q{
-SELECT username,hostmask,pnick FROM users WHERE hostmask ILIKE $1 OR pnick ILIKE $2
+SELECT username,hostmask,pnick FROM users WHERE hostmask = $1 OR pnick = $2
},undef,$hostname, $pnick);
$c->reply("<c04>Problem</c>, <b>$username</b> already uses host <b>$hostname</b> and pnick <b>$pnick</b>.");
}else{