From 40011c4f8190161d2df1d9ed2679bbe6ca420428 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Tue, 19 Feb 2019 13:29:21 -0500
Subject: [PATCH] Update for apos in field name

to get O'Reilly to work for last name search.
---
 admin/Contact/list_contact.phtml  | 2 +-
 admin/Contact/query_contact.phtml | 4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/admin/Contact/list_contact.phtml b/admin/Contact/list_contact.phtml
index b36b176..0d4341f 100755
--- a/admin/Contact/list_contact.phtml
+++ b/admin/Contact/list_contact.phtml
@@ -63,7 +63,7 @@ if ($delimiter == "csv") {
 if (isset($query_string) && $query_string) {
     $query_string = strtr($query_string,"\n"," ");
     $query_string = strtr($query_string,"\t"," ");
-    $query_string = stripslashes($query_string);
+    // $query_string = stripslashes($query_string);
     $qs = $query_string;
 } elseif ($query_no) {
     $qs = "select query from query_db where id = $query_no";
diff --git a/admin/Contact/query_contact.phtml b/admin/Contact/query_contact.phtml
index f15fbcb..ead483e 100755
--- a/admin/Contact/query_contact.phtml
+++ b/admin/Contact/query_contact.phtml
@@ -157,14 +157,14 @@ if (!$query_no) {
                 for ($c=0;$c<count($keywords);$c++) {
                     $totalc = count($keywords)-1;
                     $query_string .= $fields[$b].$operator."'".
-                        $begin.$keywords[$c].$end."'";
+                        $begin.addslashes( $keywords[$c] ).$end."'";
                     if ($c != $totalc) {
                         $query_string .= " \n$compare\t";
                     }
                 }
             } else {
                 $query_string .= $fields[$b].$operator."'".
-                    $begin.$keywords.$end."'";
+                    $begin.addslashes( $keywords ).$end."'";
             }
             if ($b != $totalb) {
                 $query_string .= " \n$compare\t";
-- 
2.17.1