From b68ded41c1bc7bee9b0ca4a521f11de08c219917 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Wed, 28 Jun 2017 16:16:21 -0400
Subject: [PATCH] Adding export file for social

Creating social media export file.
---
 .gitignore       |  1 +
 exportSocial.php | 44 ++++++++++++++++++++++++++++++++++++++++++++
 2 files changed, 45 insertions(+)
 create mode 100644 .gitignore
 create mode 100644 exportSocial.php

diff --git a/.gitignore b/.gitignore
new file mode 100644
index 0000000..afed073
--- /dev/null
+++ b/.gitignore
@@ -0,0 +1 @@
+*.csv
diff --git a/exportSocial.php b/exportSocial.php
new file mode 100644
index 0000000..5fa1667
--- /dev/null
+++ b/exportSocial.php
@@ -0,0 +1,44 @@
+<?php
+require_once '../setup.phtml';
+$socialFileName = './social-export.csv';
+
+// DB connection
+$dbh = Toolkit_Database::getInstance();
+
+// pull the member data
+$sql = "
+  SELECT member_id,
+         facebook, twitter, pinterest, google_plus, '' as digg, linkedin,
+         instagram, youtube, '' as flickr, blog, '' as photobucket, '' as rss
+    FROM members.member
+ORDER BY member_id";
+$stmt = $dbh->query( $sql );
+$memberData = $stmt->fetchAll( PDO::FETCH_ASSOC );
+echo '<pre>$memberData: ' . print_r( $memberData, true ) . '</pre>';
+
+$fileHeader = array( 'member_id',
+    'facebook',
+    'twitter',
+    'pinterest',
+    'google_plus',
+    'digg',
+    'linkedin',
+    'instagram',
+    'youtube',
+    'flickr',
+    'blog',
+    'photobucket',
+    'rss',
+);
+
+// create file
+$fp = fopen( $socialFileName, 'w' );
+if ( $fp ) {
+    // create file header
+    fputcsv( $fp, $fileHeader );
+    foreach ( $memberData as $member ) {
+        fputcsv( $fp, $member );
+    }
+    fclose( $fp );
+}
+
-- 
2.17.1