X-Git-Url: http://dxcluster.net/gitweb/gitweb.cgi?a=blobdiff_plain;f=cmd%2Fshow%2Fdx.pl;h=15eaffd0d5a434feb986827389f838552dbab50e;hb=36e0c1ffda9295a4090eab75360f1b59d964ada3;hp=b65f0f8275a54cbc6d0c9511aa90ecf3843d35ec;hpb=0ce79a125db0acb043fceaa641d8b3a9eae71a41;p=spider.git

diff --git a/cmd/show/dx.pl b/cmd/show/dx.pl
index b65f0f82..15eaffd0 100644
--- a/cmd/show/dx.pl
+++ b/cmd/show/dx.pl
@@ -32,6 +32,8 @@ my $fromdxcc;
 my $exact;
 my ($doqsl, $doiota, $doqra, $dofilter);
 
+my $usesql = $main::dbh && $Spot::use_db_for_search;
+
 while ($f = shift @list) {		# next field
 	#  print "f: $f list: ", join(',', @list), "\n";
 	if (!$from && !$to) {
@@ -181,7 +183,7 @@ if ($pre) {
 	unless (@ans) {
 		$pre .= '*' unless $pre =~ /[\*\?\[]$/o;
 		$pre = shellregex($pre);
-		if ($main::dbh) {
+		if ($usesql) {
 			$pre =~ s/\.\*/%/g;
 		} else {
 			$pre =~ s/\.\*\$$//;
@@ -257,7 +259,7 @@ if ($spotter) {
 		$expr .= ' && ' if $expr;
 		$spotter .= '*' unless $spotter =~ /[\*\?\[]/o;
 		$spotter = shellregex($spotter);
-		if ($main::dbh) {
+		if ($usesql) {
 			$spotter =~ s/\.\*/%/g;
 		} else {
 			$spotter =~ s/\.\*\$$//;
@@ -331,7 +333,7 @@ if ($state) {
 		push @expr, "\$f12 eq '$_'";
 		push @hint, "m{$_}";
 	}
-	if ($main::dbh) {
+	if ($usesql) {
 		$expr .= @expr > 1 ? '(' . join(' || ', @expr) . ')' : "$expr[0]";
 	} else {
 		$expr .= @expr > 1 ? '(\$f12 && (' . join(' || ', @expr) . '))' : "(\$f12 && $expr[0])";
@@ -347,7 +349,7 @@ if ($bystate) {
 		push @expr, "\$f13 eq '$_'";
 		push @hint, "m{$_}";
 	}
-	if ($main::dbh) {
+	if ($usesql) {
 		$expr .= @expr > 1 ? '(' . join(' || ', @expr) . ')' : "$expr[0]";
 	} else {
 		$expr .= @expr > 1 ? '(\$f13 && (' . join(' || ', @expr) . '))' : "(\$f13 && $expr[0])";