Changeset 522 for trunk/cgi-bin

Timestamp:

10/19/12 16:44:46 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Another couple of hack-patches to de-noise search.cgi. See #31.

File:

• trunk/cgi-bin/search.cgi (modified) (3 diffs)

trunk/cgi-bin/search.cgi

@@ -161 +161 @@
 
   # If we're not supposed to search for all types, search for the selected types.
+  $webvar{alltypes} = '' if !$webvar{alltypes};
+  $webvar{typeexclude} = '' if !$webvar{typeexclude};
   if ($webvar{alltypes} ne 'on') {
     $sql .= " $sqlconcat (select $cols from searchme where $webvar{typeexclude} type in (";
@@ -172 +174 @@
   # If we're not supposed to search for all cities, search for the selected cities.
   # This could be vastly improved with proper foreign keys in the database.
+  $webvar{allcities} = '' if !$webvar{allcities};
+  $webvar{cityexclude} = '' if !$webvar{cityexclude};
   if ($webvar{allcities} ne 'on') {
     $sql .= " $sqlconcat (select $cols from searchme where $webvar{cityexclude} city in (";
@@ -304 +308 @@
 print $page->output;
 
+$sth->finish;
 # Shut down and clean up.
 finish($ip_dbh);