X-Git-Url: https://ruin.nu/git/?p=NDIRC.git;a=blobdiff_plain;f=Commands%2FUsermgm.pm;h=adda73f80de3eb170aa75e834198967ab70f7891;hp=78c02b81d24431a0a9cf7b6d3156d72c59017fb8;hb=a7e034b3599d41cdf5a158b14bd1715451f89a0c;hpb=87ddd7d37d6f5880757a71bfedd3459f4a511d2b

diff --git a/Commands/Usermgm.pm b/Commands/Usermgm.pm
index 78c02b8..adda73f 100644
--- a/Commands/Usermgm.pm
+++ b/Commands/Usermgm.pm
@@ -40,7 +40,7 @@ sub adduser
 	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){
@@ -351,7 +351,7 @@ SELECT uid,username,pnick,hostmask FROM users WHERE username ILIKE ?
 		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{
@@ -387,7 +387,7 @@ sub setpnick
 		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{