Last active
August 29, 2015 13:57
-
-
Save managementboy/9463425 to your computer and use it in GitHub Desktop.
Sync Facebook Events
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /* | |
| Plugin Name: Sync Facebook Events | |
| Plugin URI: http://pdxt.com | |
| Description: Sync Facebook Events to The Events Calendar Plugin | |
| Author: Mark Nelson | |
| Version: 1.0.8 | |
| Author URI: http://pdxt.com | |
| */ | |
| /* Copyright 2013 PDX Technologies, LLC. (mark.nelson@pdxt.com) | |
| This program is free software; you can redistribute it and/or modify | |
| it under the terms of the GNU General Public License as published by | |
| the Free Software Foundation; either version 2 of the License, or | |
| (at your option) any later version. | |
| This program is distributed in the hope that it will be useful, | |
| but WITHOUT ANY WARRANTY; without even the implied warranty of | |
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | |
| GNU General Public License for more details. | |
| You should have received a copy of the GNU General Public License | |
| along with this program; if not, write to the Free Software | |
| Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA | |
| */ | |
| register_activation_hook(__FILE__,'activate_fbes'); | |
| register_deactivation_hook(__FILE__,'deactivate_fbes'); | |
| function activate_fbes() { wp_schedule_event(time(), 'daily', 'fbes_execute_sync'); } | |
| function deactivate_fbes() { wp_clear_scheduled_hook('fbes_execute_sync'); } | |
| add_action('fbes_execute_sync', 'fbes_process_events'); | |
| function update_schedule($fbes_frequency) { | |
| wp_clear_scheduled_hook('fbes_execute_sync'); | |
| wp_schedule_event(time(), $fbes_frequency, 'fbes_execute_sync'); | |
| } | |
| function fbes_add_page() { add_options_page('Sync FB Events', 'Sync FB Events', 8, __FILE__, 'fbes_options_page'); } | |
| add_action('admin_menu', 'fbes_add_page'); | |
| function fbes_process_events() { | |
| #Get option values | |
| $fbes_api_key = get_option('fbes_api_key'); | |
| $fbes_api_secret = get_option('fbes_api_secret'); | |
| $fbes_api_uid = get_option('fbes_api_uid'); | |
| $fbes_api_uids = get_option('fbes_api_uids'); | |
| $fbes_frequency = get_option('fbes_frequency'); | |
| $events = fbes_get_events($fbes_api_key, $fbes_api_secret, $fbes_api_uids); | |
| fbes_send_events($events); | |
| } | |
| function fbes_get_events($fbes_api_key, $fbes_api_secret, $fbes_api_uids) { | |
| require 'facebook.php'; | |
| $facebook = new Facebook(array( | |
| 'appId' => $fbes_api_key, | |
| 'secret' => $fbes_api_secret, | |
| 'cookie' => true, | |
| )); | |
| Facebook::$CURL_OPTS[CURLOPT_SSL_VERIFYPEER] = false; | |
| Facebook::$CURL_OPTS[CURLOPT_SSL_VERIFYHOST] = 2; | |
| $ret = array(); | |
| foreach ($fbes_api_uids as $key => $value) { | |
| if($value!='') { | |
| //https://developers.facebook.com/docs/reference/fql/event/ | |
| $fql = "SELECT eid, name, start_time, end_time, location, description, host, venue | |
| FROM event WHERE eid IN ( SELECT eid FROM event_member WHERE uid = $value ) | |
| ORDER BY start_time desc"; | |
| $param = array( | |
| 'method' => 'fql.query', | |
| 'query' => $fql, | |
| 'callback' => '' | |
| ); | |
| $result = $facebook->api($param); | |
| foreach($result as $k => $v) | |
| $result[$k]['uid'] = $value; | |
| $ret = array_merge($ret, $result); | |
| } | |
| } | |
| return $ret; | |
| } | |
| function fbes_segments($url='') { | |
| $parsed_url = parse_url($url); | |
| $path = trim($parsed_url['path'],'/'); | |
| return explode('/',$path); | |
| } | |
| function fbes_send_events($events) { | |
| $query = new WP_Query(array( | |
| 'post_type'=>'tribe_events', | |
| 'posts_per_page'=>'-1' | |
| )); | |
| foreach($query->posts as $post) { | |
| if(!empty($post->to_ping)) { | |
| $segments = fbes_segments($post->to_ping); | |
| $eid = array_pop($segments); | |
| $eids[$eid] = $post->ID; | |
| } | |
| } | |
| file_put_contents($_SERVER['DOCUMENT_ROOT'].'/fbevent.log', print_r(array(time(),$events,$eids),1)."\n".str_repeat('=',40)."\n", FILE_APPEND); | |
| $organizers = get_posts( array( 'post_type' => TribeEvents::ORGANIZER_POST_TYPE ) ); | |
| $venues = get_posts( array( 'post_type' => TribeEvents::VENUE_POST_TYPE ) ); | |
| foreach($events as $event) { | |
| $args['post_title'] = $event['name']; | |
| //$offset = get_option('gmt_offset')*3600; | |
| $offset = 2*3600; | |
| $offsetStart =strtotime($event['start_time'])+$offset; | |
| $offsetEnd = strtotime($event['end_time'])+$offset; | |
| foreach($organizers as $organizer) { | |
| if ($organizer->post_title == $event['host']){ | |
| $orgkey = $organizer->ID; | |
| } | |
| } | |
| foreach($venues as $venue) { | |
| if ($venue->post_title == $event['location']){ | |
| $venuekey = $venue->ID; | |
| } | |
| } | |
| //don't update or insert events from the past. | |
| if($offsetStart > time()) { | |
| $args['EventStartDate'] = date("m/d/Y", $offsetStart); | |
| $args['EventStartHour'] = date("H", $offsetStart); | |
| $args['EventStartMinute'] = date("i", $offsetStart); | |
| $args['EventEndDate'] = date("m/d/Y", $offsetEnd); | |
| $args['EventEndHour'] = date("H", $offsetEnd); | |
| $args['EventEndMinute'] = date("i", $offsetEnd); | |
| $args['post_content'] = $event['description']; | |
| $args['post_status'] = "Publish"; | |
| $args['post_type'] = "tribe_events"; | |
| //$args['to_ping'] = $event['eid']; //damn you, sanitize_trackback_urls in 3.4 | |
| $args['to_ping'] = 'https://www.facebook.com/events/'.$event['eid'].'/'; | |
| if($args['EventStartHour'] == '22' && $event['uid'] == '256763181050120') { //why are UT events 2 hours off??? | |
| $args['EventStartHour'] = '20'; | |
| $args['EventEndHour'] = '22'; | |
| $args['EventEndDate'] = date('m/d/Y',strtotime($args['EventEndDate'], '-1 day')); | |
| } | |
| echo "<br />ID: ".$eids[$event['eid']]; | |
| $inserting = $post_id = false; | |
| if (!array_key_exists($event['eid'], $eids)) { | |
| //double check | |
| $already_exists = false; | |
| foreach($query->posts as $post) { | |
| if($post->to_ping == $args['to_ping'] || trim($post->pinged) == $args['to_ping']) { | |
| $already_exists = true; | |
| } | |
| } | |
| if(!$already_exists) { | |
| if (!$venuekey){ | |
| $args['Venue']['Venue'] = $event['location']; | |
| $args['Venue']['City'] = $event['venue']['city']; | |
| $args['Venue']['Street'] = $event['venue']['street']; | |
| $args['Venue']['State'] = $event['venue']['state']; | |
| $args['Venue']['Country'] = $event['venue']['country']; | |
| $args['Venue']['Zip'] = $event['venue']['zip']; | |
| $args['Venue']['Address'] = $event['venue']['street']; | |
| $args['EventShowMapLink'] = true; | |
| $args['EventShowMap'] = true; | |
| $args['EventURL'] = $args['to_ping']; | |
| wp_set_object_terms( $post_id, 'facebook', TribeEvents::TAXONOMY, 1); | |
| } else { | |
| $args['Venue']['VenueID'] = $venuekey; | |
| } | |
| if (!$orgkey){ | |
| $args['Organizer']['Organizer'] = $event['host']; | |
| } else { | |
| $args['Organizer']['OrganizerID'] = $orgkey; | |
| } | |
| $post_id = tribe_create_event($args); | |
| echo "<br />Inserting Venue: ".$post_id; | |
| $inserting = true; | |
| //file_put_contents($_SERVER['DOCUMENT_ROOT'].'/fbevent.log', print_r(array(time(),'creating', $args, $eids, $query->posts),1)."\n".str_repeat('=',40)."\n", FILE_APPEND); | |
| } | |
| } | |
| if(!$inserting) { | |
| $post_id = $eids[$event['eid']]; | |
| $args['Venue']['VenueID'] = tribe_get_venue_id($post_id); | |
| $args['Venue']['Venue'] = $event['location']; | |
| $args['Venue']['City'] = $event['venue']['city']; | |
| $args['Venue']['Street'] = $event['venue']['street']; | |
| $args['Venue']['State'] = $event['venue']['state']; | |
| $args['Venue']['Country'] = $event['venue']['country']; | |
| $args['Venue']['Zip'] = $event['venue']['zip']; | |
| $args['Venue']['Address'] = $event['venue']['street']; | |
| $args['EventShowMapLink'] = true; | |
| $args['EventShowMap'] = true; | |
| $args['EventURL'] = $args['to_ping']; | |
| $args['Organizer']['OrganizerID'] = tribe_get_organizer_id($post_id); | |
| $args['Organizer']['Organizer'] = $event['host']; | |
| $args['Venue']['Category'] = 'Von Facebook'; | |
| wp_set_object_terms( $post_id, 'facebook', TribeEvents::TAXONOMY, 1); | |
| tribe_update_event($post_id, $args); | |
| //file_put_contents($_SERVER['DOCUMENT_ROOT'].'/fbevent.log', print_r(array(time(),'updating', $args, $eids, $query->posts),1)."\n".str_repeat('=',40)."\n", FILE_APPEND); | |
| echo "<br />Updating Venue: ".$eids[$event['eid']]; | |
| } | |
| if($post_id) | |
| update_metadata('post', $post_id, 'fb_event_obj', $event); | |
| //eid, name, start_time, end_time, location, description | |
| } | |
| //reset($eids); | |
| } | |
| } | |
| function fbes_options_page() { | |
| $fbes_api_uids = array(); | |
| #Get option values | |
| $fbes_api_key = get_option('fbes_api_key'); | |
| $fbes_api_secret = get_option('fbes_api_secret'); | |
| $fbes_api_uid = get_option('fbes_api_uid'); | |
| $fbes_api_uids = get_option('fbes_api_uids'); | |
| $fbes_frequency = get_option('fbes_frequency'); | |
| #Get new updated option values, and save them | |
| if( !empty($_POST['update']) ) { | |
| $fbes_api_key = $_POST['fbes_api_key']; | |
| update_option('fbes_api_key', $fbes_api_key); | |
| $fbes_api_secret = $_POST['fbes_api_secret']; | |
| update_option('fbes_api_secret', $fbes_api_secret); | |
| $fbes_api_uid = $_POST['fbes_api_uid']; | |
| update_option('fbes_api_uid', $fbes_api_uid); | |
| $fbes_frequency = $_POST['fbes_frequency']; | |
| update_option('fbes_frequency', $fbes_frequency); | |
| $events = fbes_get_events($fbes_api_key, $fbes_api_secret, $fbes_api_uids); | |
| update_schedule($fbes_frequency); | |
| $msg = "Syncronization of Events from Facebook Complete."; | |
| ?> | |
| <div id="message" class="updated fade"><p><strong><?php echo $msg; ?></strong></p></div> | |
| <?php | |
| } elseif( !empty($_POST['add-uid']) ) { | |
| if(!in_array($_POST['fbes_api_uid'], $fbes_api_uids)) { | |
| $fbes_api_uids[] = $_POST['fbes_api_uid']; | |
| update_option('fbes_api_uids', $fbes_api_uids); | |
| } | |
| } elseif( !empty($_GET['r']) ) { | |
| foreach ($fbes_api_uids as $key => $value) | |
| if($fbes_api_uids[$key] == $_GET['r']) | |
| unset($fbes_api_uids[$key]); | |
| update_option('fbes_api_uids', $fbes_api_uids); | |
| } | |
| ?> | |
| <div class="wrap"> | |
| <br /><div class="icon32" id="icon-plugins"><br/></div> | |
| <h2 style="margin-bottom:10px;">Sync Facebook Events</h2> | |
| <form method="post" action="<?php echo $_SERVER['REQUEST_URI'] ?>"> | |
| <input type="hidden" name="update" /> | |
| <?php | |
| echo '<form action="'. $_SERVER["REQUEST_URI"] .'" method="post"><table style="width:475px;">'; | |
| echo '<tr><td>Facebook App ID:</td><td><input type="text" id="fbes_api_key" name="fbes_api_key" value="'.htmlentities($fbes_api_key).'" size="35" /></td><tr>'; | |
| echo '<tr><td>Facebook App Secret:</td><td><input type="text" id="fbes_api_secret" name="fbes_api_secret" value="'.htmlentities($fbes_api_secret) .'" size="35" /></td><tr>'; | |
| echo '<tr><td>Update Fequency:</td><td><select id="fbes_frequency" name="fbes_frequency">'; | |
| if(htmlentities($fbes_frequency)=="daily") { | |
| echo '<option value="daily" SELECTED>Daily</option>'; | |
| } else { | |
| echo '<option value="daily">Daily</option>'; | |
| } | |
| if(htmlentities($fbes_frequency)=="twicedaily") { | |
| echo '<option value="twicedaily" SELECTED>Twice Daily</option>'; | |
| } else { | |
| echo '<option value="twicedaily">Twice Daily</option>'; | |
| } | |
| if(htmlentities($fbes_frequency)=="hourly") { | |
| echo '<option value="hourly" SELECTED>Hourly</option>'; | |
| } else { | |
| echo '<option value="hourly">Hourly</option>'; | |
| } | |
| echo '</select>'; | |
| echo '<tr><td>Add Facebook Page UID:</td><td><input type="text" id="fbes_api_uid" name="fbes_api_uid" value="" size="15" />'; | |
| echo '<input type="submit" value="Add" class="button-secondary" name="add-uid" /></td></tr>'; | |
| echo '<tr><td style="vertical-align:top;"></td><td>'; | |
| foreach ($fbes_api_uids as $value) { | |
| if($value!='') | |
| echo ' '.$value.' <a href="'.$_SERVER["REQUEST_URI"].'&r='.$value.'">remove</a><br />'; | |
| } | |
| echo '</td></tr>'; | |
| echo '<tr><td colspan="2"></td></tr><tr><td colspan="2"><br /><input type="submit" value="Update" class="button-primary"'; | |
| echo ' name="update" /></td></tr></table>'; | |
| ?> | |
| </form> | |
| </div> | |
| <?php if(isset($events)) { ?> | |
| <div style="margin-top:20px;font-size:14px;color:#444;border:1px solid #999;padding:15px;width:95%;font-face:couriernew;"> | |
| <span style="color:red;">Updating all facebook events...</span><br /> | |
| <?php fbes_send_events($events); ?><br /> | |
| <span style="color:red;">Events Calendar updated with current Facebook events.</span><br /><br /> | |
| </div> | |
| <?php } ?> | |
| <?php | |
| } | |
| ?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment