From 9ebd047be0d44bee8aa64325e49324912c639a93 Mon Sep 17 00:00:00 2001
From: Laury GvR <laury@gaslightmedia.com>
Date: Tue, 2 Aug 2016 17:26:40 -0400
Subject: [PATCH] Added members only help form and number settings

Admin side now has settings fields for the members only login form
email and phone number that can be called for assistance. This
change is combined with a theme change that gets the info from
glm  associate through a filter.
---
 classes/data/settings/dataSettingsGeneral.php | 19 +++++++++++++++++++
 index.php                                     |  2 +-
 ...1.1.11.sql => create_database_V1.1.12.sql} |  4 +++-
 setup/databaseScripts/dbVersions.php          |  1 +
 .../update_database_V1.1.12.sql               | 16 ++++++++++++++++
 views/admin/management/index.html             | 18 ++++++++++++++++++
 6 files changed, 58 insertions(+), 2 deletions(-)
 rename setup/databaseScripts/{create_database_V1.1.11.sql => create_database_V1.1.12.sql} (99%)
 create mode 100644 setup/databaseScripts/update_database_V1.1.12.sql

diff --git a/classes/data/settings/dataSettingsGeneral.php b/classes/data/settings/dataSettingsGeneral.php
index ba16f6fe..274307b1 100644
--- a/classes/data/settings/dataSettingsGeneral.php
+++ b/classes/data/settings/dataSettingsGeneral.php
@@ -935,8 +935,27 @@ class GlmDataSettingsGeneral extends GlmDataAbstract
                         'type' => 'checkbox',
                         'default' => false,
                         'use' => 'a'
+                ),
+            
+                /*
+                 * Front-end Member Detail Map Options
+                 */
+
+                // Front-end Detail - Map Show amenities
+                'members_only_support_email' => array(
+                        'field' => 'members_only_support_email',
+                        'type' => 'text',
+                        'use' => 'a'
+                ),
+
+                // Front-end Detail - Map Show Logo
+                'members_only_support_phone' => array(
+                        'field' => 'members_only_support_phone',
+                        'type' => 'text',
+                        'use' => 'a'
                 )
 
+
         );
 
     }
diff --git a/index.php b/index.php
index e6da298a..49825d7f 100644
--- a/index.php
+++ b/index.php
@@ -39,7 +39,7 @@
  */
 
 define('GLM_MEMBERS_PLUGIN_VERSION', '2.3.2');
-define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.11');
+define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.12');
 
 // Check if plugin version is not current in WordPress option and if needed updated it
 if (GLM_MEMBERS_PLUGIN_VERSION != get_option('glmMembersDatabasePluginVersion')) {
diff --git a/setup/databaseScripts/create_database_V1.1.11.sql b/setup/databaseScripts/create_database_V1.1.12.sql
similarity index 99%
rename from setup/databaseScripts/create_database_V1.1.11.sql
rename to setup/databaseScripts/create_database_V1.1.12.sql
index 65645bdb..f6787d30 100644
--- a/setup/databaseScripts/create_database_V1.1.11.sql
+++ b/setup/databaseScripts/create_database_V1.1.12.sql
@@ -1,6 +1,6 @@
 -- Gaslight Media Members Database 
 -- File Created: 12/09/14 15:27:15
--- Database Version: 1.1.11
+-- Database Version: 1.1.12
 -- Database Creation Script
 -- 
 -- To permit each query below to be executed separately,
@@ -324,6 +324,8 @@ CREATE TABLE {prefix}settings_general (
   detail_map_show_categories BOOLEAN DEFAULT '0',
   detail_map_show_creditcards BOOLEAN DEFAULT '0',
   detail_map_show_amenities BOOLEAN DEFAULT '0',
+  members_only_support_email TINYTEXT DEFAULT '',
+  members_only_support_phone TINYTEXT DEFAULT '',
   PRIMARY KEY (id)
 );
 
diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php
index 76a145c3..a06f528a 100644
--- a/setup/databaseScripts/dbVersions.php
+++ b/setup/databaseScripts/dbVersions.php
@@ -43,6 +43,7 @@ $glmMembersDbVersions = array(
     '1.1.9' => array('version' => '1.1.9', 'tables' => 16, 'date' => '6/13/16'),
     '1.1.10' => array('version' => '1.1.10', 'tables' => 16, 'date' => '6/16/16'),
     '1.1.11' => array('version' => '1.1.11', 'tables' => 16, 'date' => '6/21/16'),
+    '1.1.12' => array('version' => '1.1.12', 'tables' => 16, 'date' => '8/2/16'),
 );
 
 
diff --git a/setup/databaseScripts/update_database_V1.1.12.sql b/setup/databaseScripts/update_database_V1.1.12.sql
new file mode 100644
index 00000000..cf352774
--- /dev/null
+++ b/setup/databaseScripts/update_database_V1.1.12.sql
@@ -0,0 +1,16 @@
+-- Gaslight Media Members Database 
+-- File Created: 8/2/16 15:56:08
+-- Database Version: 1.1.12
+-- Database Update From Previous Version Script
+-- 
+-- To permit each query below to be executed separately,
+-- all queries must be separated by a line with four dashses
+
+-- Add new setting for capturing support email and phone
+
+
+ALTER TABLE {prefix}settings_general ADD members_only_support_email TINYTEXT NULL;
+
+----
+
+ALTER TABLE {prefix}settings_general ADD members_only_support_phone TINYTEXT NULL;
diff --git a/views/admin/management/index.html b/views/admin/management/index.html
index b255257f..b606dc99 100644
--- a/views/admin/management/index.html
+++ b/views/admin/management/index.html
@@ -11,6 +11,7 @@
             <a id="glm-settings-list" data-show-table="glm-table-list" class="glm-settings-tab nav-tab">Member List Options</a>
             <a id="glm-settings-detail" data-show-table="glm-table-detail" class="glm-settings-tab nav-tab">Member Detail Options</a>
             <a id="glm-settings-required-page" data-show-table="glm-table-required-page" class="glm-settings-tab nav-tab">Required Pages</a>
+            <a id="glm-settings-members-only" data-show-table="glm-table-members-only" class="glm-settings-tab nav-tab">Members Only</a>
             {if $settingsUpdated}<span class="glm-notice glm-flash-updated glm-right">Settings Updated</span>{/if}
             {if $settingsUpdateError}<span class="glm-error glm-flash-updated glm-right">Settings Update Error</span>{/if}
         </h2>
@@ -340,6 +341,23 @@
                     </table>
                 </td>  
             </tr>
+        </table> 
+                        <!-- Members Only Settings -->
+                   
+        <table id="glm-table-members-only" class="glm-admin-table glm-settings-table">
+            <tr><td colspan="2"><h2>Members Only Settings</h2></td></tr>
+            <tr>
+                <th>Member Login Form Support Email:</th>
+                <td>
+                    <input type="text" name="members_only_support_email" value="{$genSettings.fieldData.members_only_support_email}" class="glm-form-text-input-medium">
+                </td>
+            </tr>
+            <tr>
+                <th>Member Login Form Support Number:</th>
+                <td>
+                    <input type="text" name="members_only_support_phone" value="{$genSettings.fieldData.members_only_support_phone}" class="glm-form-text-input-medium">
+                </td>
+            </tr>
         </table>
         <input id="updateSettings" type="submit" value="Update Settings" class="">
     </form>
-- 
2.17.1