From 8e04e4ac3022bb18e7d0f654a6749f20d3f814be Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Fri, 18 Aug 2017 11:30:48 -0400
Subject: [PATCH] Save work on feature branch for db updates

These update are for the new member_events_allowed option.
---
 index.php                                     |  2 +-
 ..._V0.1.3.sql => create_database_V0.1.4.sql} | 11 ++++----
 setup/databaseScripts/dbVersions.php          |  1 +
 .../update_database_V0.1.4.php                | 27 +++++++++++++++++++
 .../update_database_V0.1.4.sql                | 14 ++++++++++
 5 files changed, 49 insertions(+), 6 deletions(-)
 rename setup/databaseScripts/{create_database_V0.1.3.sql => create_database_V0.1.4.sql} (98%)
 create mode 100644 setup/databaseScripts/update_database_V0.1.4.php
 create mode 100644 setup/databaseScripts/update_database_V0.1.4.sql

diff --git a/index.php b/index.php
index c2986d3..e5f5bde 100644
--- a/index.php
+++ b/index.php
@@ -48,7 +48,7 @@ if (!defined('ABSPATH')) {
  *  version from this plugin.
  */
 define('GLM_MEMBERS_EVENTS_PLUGIN_VERSION', '1.6.58');
-define('GLM_MEMBERS_EVENTS_PLUGIN_DB_VERSION', '0.1.3');
+define('GLM_MEMBERS_EVENTS_PLUGIN_DB_VERSION', '0.1.4');
 
 // This is the minimum version of the GLM Members DB plugin require for this plugin.
 define('GLM_MEMBERS_EVENTS_PLUGIN_MIN_MEMBERS_REQUIRED_VERSION', '2.9.15');
diff --git a/setup/databaseScripts/create_database_V0.1.3.sql b/setup/databaseScripts/create_database_V0.1.4.sql
similarity index 98%
rename from setup/databaseScripts/create_database_V0.1.3.sql
rename to setup/databaseScripts/create_database_V0.1.4.sql
index 9272415..518a8fb 100644
--- a/setup/databaseScripts/create_database_V0.1.3.sql
+++ b/setup/databaseScripts/create_database_V0.1.4.sql
@@ -1,6 +1,6 @@
 -- Gaslight Media Members Database - Events Add-On
--- File Created: 12/02/15 15:27:15
--- Database Version: 0.1.3
+-- File Created: 08/18/17
+-- Database Version: 0.1.4
 -- Database Creation Script
 --
 -- This file is called to create a new set of tables for this
@@ -227,6 +227,7 @@ CREATE TABLE {prefix}management (
     term_event_amenities_plural TINYTEXT NULL,            -- Plural term to use for event amenities
     use_event_amenities BOOLEAN NULL,                     -- Whether amenities are used at all for events
     use_venue_locations BOOLEAN NULL,                     -- To use Other members as the location of event
+    member_events_allowed BOOLEAN NULL,                   -- If members are allowed to add events.
     PRIMARY KEY (id)
 );
 
@@ -234,9 +235,9 @@ CREATE TABLE {prefix}management (
 
 -- Set default event management entry
 INSERT INTO {prefix}management
-    ( id, canonical_event_page, term_event_amenities_singular, term_event_amenities_plural )
+    ( id, canonical_event_page, term_event_amenities_singular, term_event_amenities_plural, member_events_allowed )
    VALUES
-    ( 1, 'event-detail', 'Amenity', 'Amenities' )
+    ( 1, 'event-detail', 'Amenity', 'Amenities', 1 )
 ;
 
 ----
@@ -271,4 +272,4 @@ INSERT INTO {prefix}email_notifications
     ( id, declined_message, approved_message )
    VALUES
     ( 1, 'The Event parameters do not comply with our event guidelines.', 'Your event has been approved.' )
-;
\ No newline at end of file
+;
diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php
index 5dad38c..f8fbd2b 100644
--- a/setup/databaseScripts/dbVersions.php
+++ b/setup/databaseScripts/dbVersions.php
@@ -39,5 +39,6 @@ $glmMembersEventsDbVersions = array(
     '0.1.1' => array('version' => '0.1.1', 'tables' => 12, 'date' => '11/02/2016'),
     '0.1.2' => array('version' => '0.1.2', 'tables' => 12, 'date' => '05/03/2017'),
     '0.1.3' => array('version' => '0.1.3', 'tables' => 13, 'date' => '08/14/2017'),
+    '0.1.4' => array('version' => '0.1.4', 'tables' => 13, 'date' => '08/18/2017'),
 );
 
diff --git a/setup/databaseScripts/update_database_V0.1.4.php b/setup/databaseScripts/update_database_V0.1.4.php
new file mode 100644
index 0000000..660e9bc
--- /dev/null
+++ b/setup/databaseScripts/update_database_V0.1.4.php
@@ -0,0 +1,27 @@
+<?php
+/*
+ * Gaslight Media Members Database - Events Add-On
+ *
+ * Database Update Script for version 0.1.4
+ */
+
+// Update event records with name slug for URLs
+$managementOptions = $this->wpdb->get_results(
+    'SELECT to_email, from_email FROM '.GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX.'management where id = 1',
+    ARRAY_A
+);
+if ($managementOptions && count($managementOptions) > 0) {
+    foreach ($managementOptions as $i) {
+        $wpdb->update(
+                GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX.'email_notifications',
+                array(
+                    'to_email'   => $i['to_email'],
+                    'from_email' => $i['from_email']
+                ),
+                array( 'id' => $i['id'] ),
+                array( '%s', '%s' ),
+                array( '%d')
+        );
+    }
+}
+?>
diff --git a/setup/databaseScripts/update_database_V0.1.4.sql b/setup/databaseScripts/update_database_V0.1.4.sql
new file mode 100644
index 0000000..ba2739d
--- /dev/null
+++ b/setup/databaseScripts/update_database_V0.1.4.sql
@@ -0,0 +1,14 @@
+-- Gaslight Media Members Database  - Events Add-On
+-- File Created: 08/18/17
+-- Database Version: 0.1.4
+-- 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 dashes
+
+-- new field in management
+ALTER TABLE {prefix}management ADD COLUMN member_events_allowed BOOLEAN NULL;  -- If members are allowed to add events.
+
+----
+
+UPDATE {prefix}management SET member_events_allowed = 1 WHERE id = 1;
-- 
2.17.1