From d1457479b6d131085201afba98beddcb9316cf5d Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Tue, 7 Feb 2017 15:54:08 -0500
Subject: [PATCH] Removing PDO stuff

From old postgres
---
 lib/StreamSend/StreamSend.php | 64 +++++++++++------------------------
 1 file changed, 19 insertions(+), 45 deletions(-)

diff --git a/lib/StreamSend/StreamSend.php b/lib/StreamSend/StreamSend.php
index 5c7eb6fb..af4e59a3 100644
--- a/lib/StreamSend/StreamSend.php
+++ b/lib/StreamSend/StreamSend.php
@@ -153,6 +153,7 @@ class Toolkit_Members_StreamSend
             );
         }
         try {
+            /*
             // for getting the categories parent name (needed for option name)
             $sql = "
             SELECT name
@@ -165,11 +166,7 @@ class Toolkit_Members_StreamSend
               FROM streamsend
              WHERE category_id = :category_id";
             $stmt = $this->dbh->prepare($sql);
-            $stmt->bindParam(
-                ':category_id',
-                $categoryId,
-                PDO::PARAM_INT
-            );
+            $stmt->bindParam( ':category_id', $categoryId, PDO::PARAM_INT);
             $stmt->execute();
             // $currentFieldData is from the streamsend table
             $currentFieldData = $stmt->fetch(PDO::FETCH_ASSOC);
@@ -178,20 +175,13 @@ class Toolkit_Members_StreamSend
               FROM category
              WHERE category_id = :category_id";
             $stmt = $this->dbh->prepare($sql);
-            $stmt->bindParam(
-                ':category_id',
-                $categoryId,
-                PDO::PARAM_INT
-            );
+            $stmt->bindParam( ':category_id', $categoryId, PDO::PARAM_INT);
             $stmt->execute();
+             */
             // $data will be the array from category table
             $data = $stmt->fetch(PDO::FETCH_ASSOC);
             if ($data['parent_id']) {
-                $getParentId->bindParam(
-                    ':parent_id',
-                    $data['parent_id'],
-                    PDO::PARAM_INT
-                );
+                $getParentId->bindParam( ':parent_id', $data['parent_id'], PDO::PARAM_INT);
                 $getParentId->execute();
                 $parentName = $getParentId->fetchColumn();
                 $newOptionName = $parentName . '/' . $data['name'];
@@ -264,6 +254,7 @@ class Toolkit_Members_StreamSend
                 'Must have option name with a slash in it'
             );
         }
+        /*
         $sql = "
         SELECT field_id
           FROM streamsend
@@ -279,6 +270,7 @@ class Toolkit_Members_StreamSend
         VALUES
         (:field_id, :field_name, :option_id, :option_name, :category_id, :parent)";
         $stmt = $this->dbh->prepare($sql);
+         */
         $optionId = $this->streamSendMember->createFieldOption(
             $fieldId,
             $newOptionName
@@ -298,37 +290,15 @@ class Toolkit_Members_StreamSend
             return true;
         }
         // now insert into the streamsend table
-        $stmt->bindParam(
-            ':field_id',
-            $fieldId,
-            PDO::PARAM_INT
-        );
-        $stmt->bindParam(
-            ':field_name',
-            $fieldName,
-            PDO::PARAM_STR
-        );
-        $stmt->bindParam(
-            ':option_id',
-            $optionId,
-            PDO::PARAM_INT
-        );
-        $stmt->bindParam(
-            ':category_id',
-            $data['category_id'],
-            PDO::PARAM_INT
-        );
-        $stmt->bindParam(
-            ':option_name',
-            $newOptionName,
-            PDO::PARAM_STR
-        );
-        $stmt->bindParam(
-            ':parent',
-            $data['parent_id'],
-            PDO::PARAM_INT
-        );
+        /*
+        $stmt->bindParam( ':field_id', $fieldId, PDO::PARAM_INT);
+        $stmt->bindParam( ':field_name', $fieldName, PDO::PARAM_STR);
+        $stmt->bindParam( ':option_id', $optionId, PDO::PARAM_INT);
+        $stmt->bindParam( ':category_id', $data['category_id'], PDO::PARAM_INT);
+        $stmt->bindParam( ':option_name', $newOptionName, PDO::PARAM_STR);
+        $stmt->bindParam( ':parent', $data['parent_id'], PDO::PARAM_INT);
         $stmt->execute();
+         */
     }
 
     /**
@@ -368,6 +338,7 @@ class Toolkit_Members_StreamSend
             $data['field_id'],
             $data['option_id']
         );
+        /*
         try {
             $sql = "
             DELETE FROM streamsend
@@ -382,6 +353,7 @@ class Toolkit_Members_StreamSend
         } catch(PDOException $e) {
             Toolkit_Common::handleError($e);
         }
+         */
     }
 
     /**
@@ -418,6 +390,7 @@ class Toolkit_Members_StreamSend
             $optionId,
             $newOptionName
         );
+        /*
         try {
             $sql = "
             UPDATE streamsend
@@ -438,5 +411,6 @@ class Toolkit_Members_StreamSend
         } catch(PDOException $e) {
             Toolkit_Common::handleError($e);
         }
+         */
     }
 }
-- 
2.17.1