From 4f1dc78a44cb3c6193d3bb6022755807f6ceccd3 Mon Sep 17 00:00:00 2001 From: Laury GvR Date: Wed, 17 Jul 2019 19:53:32 -0400 Subject: [PATCH] Comment currently unused dashboard even retrieval --- setup/routes/dashboard.php | 26 +++++++++++++------------- 1 file changed, 13 insertions(+), 13 deletions(-) diff --git a/setup/routes/dashboard.php b/setup/routes/dashboard.php index edbd26a..5f39c07 100644 --- a/setup/routes/dashboard.php +++ b/setup/routes/dashboard.php @@ -363,14 +363,14 @@ class GLMA_Dashboard_Rest_Controller // $recurrence_table = GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX."recurrences AS R, $event_table AS E"; // $recurrence_where = "R.event = E.id"; - $recurrence_fields = "R.id, R.name, R.event, R.start_date, R.start_time, R.end_time, R.from_date, R.to_date"; - $recurrence_table = GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX."recurrences AS R"; - $recurrence_where = "true";//"R.event = 1"; - $recurrence_subquery = "SELECT $recurrence_fields FROM $recurrence_table WHERE $recurrence_where"; + // $recurrence_fields = "R.id, R.name, R.event, R.start_date, R.start_time, R.end_time, R.from_date, R.to_date"; + // $recurrence_table = GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX."recurrences AS R"; + // $recurrence_where = "true";//"R.event = 1"; + // $recurrence_subquery = "SELECT $recurrence_fields FROM $recurrence_table WHERE $recurrence_where"; - $event_fields = "id, name, name_slug, descr, image, ($recurrence_subquery) AS recurrences"; - $event_table = GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX."events"; - $event_where = "status IN (".$this->config['status_numb']['Active'].")"; + // $event_fields = "id, name, name_slug, descr, image, ($recurrence_subquery) AS recurrences"; + // $event_table = GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX."events"; + // $event_where = "status IN (".$this->config['status_numb']['Active'].")"; @@ -381,12 +381,12 @@ class GLMA_Dashboard_Rest_Controller // WHERE $event_where; // "; - $event_sql = " - SELECT E.id, E.name, E.name_slug, R.start_date, R.start_time, R.end_time, R.from_date, R.to_date, R.id as recurrence_id - FROM $event_table AS E - INNER JOIN $recurrence_table AS R ON (E.id = R.event) - WHERE $event_where; - "; + // $event_sql = " + // SELECT E.id, E.name, E.name_slug, R.start_date, R.start_time, R.end_time, R.from_date, R.to_date, R.id as recurrence_id + // FROM $event_table AS E + // INNER JOIN $recurrence_table AS R ON (E.id = R.event) + // WHERE $event_where; + // "; $limit = 5; $events = $this->wpdb->get_results( -- 2.17.1