From fc694499ddc228536df38ffbfb3fc2626fcf3d0a Mon Sep 17 00:00:00 2001 From: Laury GvR Date: Fri, 6 Oct 2017 16:50:19 -0400 Subject: [PATCH] Single quotes were breaking members for cities The member names are now manually ran through str_replace to fix single quotes which were broken due to the way the JSON string is accessed in the viewfile of cities.html --- models/admin/settings/cities.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/models/admin/settings/cities.php b/models/admin/settings/cities.php index 665c69e9..b4dfb566 100644 --- a/models/admin/settings/cities.php +++ b/models/admin/settings/cities.php @@ -159,6 +159,7 @@ class GlmMembersAdmin_settings_cities extends GlmDataCities $sql = "SELECT T.member_name, T.id FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."member_info T WHERE T.city = " . $city["id"] . " "; $membersForCity = $this->wpdb->get_results($sql, ARRAY_A); foreach ($membersForCity as $memberForCity) { + //echo var_dump(addSlashes($memberForCity["member_name"])); $citiesWithMembers[$city["id"]][$memberForCity["id"]] = $memberForCity["member_name"]; } @@ -174,8 +175,10 @@ class GlmMembersAdmin_settings_cities extends GlmDataCities 'data' => false ); } - + // $citiesWithMembersJSON = htmlspecialchars(json_encode($citiesWithMembers), ENT_QUOTES, 'UTF-8'); $citiesWithMembersJSON = json_encode($citiesWithMembers); + $citiesWithMembersJSON = str_replace("'", "\'", $citiesWithMembersJSON); + // Compile template data $templateData = array( -- 2.17.1