X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_user.php;h=0c861764522ffd981c4a34001ed85d600346c553;hp=b330b66c255b051c5881718de49e317a8360d418;hb=0fada672e2066043b76ed5d57f852f451a49a3a3;hpb=e1cf98e08d4d92edf492396b82c67efa97a0ece8

diff --git a/inc/modules/admin/what-list_user.php b/inc/modules/admin/what-list_user.php
index b330b66c25..0c86176452 100644
--- a/inc/modules/admin/what-list_user.php
+++ b/inc/modules/admin/what-list_user.php
@@ -188,20 +188,20 @@ LIMIT 1",
 			case 'norefs': // Users w/o refs
 				if (!empty($whereStatement)) {
 					// Add AND statement
-					$whereStatement .= " AND `refid`=0";
+					$whereStatement .= ' AND (`refid`=0 OR `refid` IS NULL)';
 				} else {
 					// Add WHERE statement
-					$whereStatement = " WHERE `refid`=0";
+					$whereStatement = ' WHERE (`refid`=0 OR `refid` IS NULL)';
 				}
 				break;
 
 			case 'random_refid': // Users available for random referal id
 				if (!empty($whereStatement)) {
 					// Add AND statement
-					$whereStatement .= " AND `rand_confirmed` >= {?user_min_confirmed?}";
+					$whereStatement .= ' AND `rand_confirmed` >= {?user_min_confirmed?}';
 				} else {
 					// Add WHERE statement
-					$whereStatement = " WHERE `rand_confirmed` >= {?user_min_confirmed?}";
+					$whereStatement = ' WHERE `rand_confirmed` >= {?user_min_confirmed?}';
 				}
 				break;