{"id":7237096,"date":"2016-04-04T08:59:25","date_gmt":"2016-04-04T08:59:25","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/facebook-events-importing-custom-code\/"},"modified":"2016-08-31T15:25:23","modified_gmt":"2016-08-31T15:25:23","slug":"facebook-events-importing-custom-code","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/facebook-events-importing-custom-code\/","title":{"rendered":"Facebook events importing: custom code"},"content":{"rendered":"<p>Hi,<br \/>\nIt&#8217;s been a long time I&#8217;d like to implement events from facebook to EM:<br \/>\nI tried a lot of plugins but none solve my problem completely.<\/p>\n<p>So I decided to implement it manually:<br \/>\nI used facebook SDK and I can retrieve what I need from my facebook page.<br \/>\nGreat.<\/p>\n<p>But I don&#8217;t succeed to insert in EM the events I got from facebook.<\/p>\n<p>Here my code in my cycle where I loop facebooks events:<\/p>\n<pre><code>\/\/check if event it&#039;s already been imported\n$args = array (\n&#039;post_type&#039; =&gt; &#039;event&#039;,\n&#039;posts_per_page&#039; =&gt; -1,\n&#039;meta_key&#039; =&gt; &#039;_facebook_event_id&#039;,\n&#039;meta_query&#039; =&gt; array(\n&#039;key&#039;\t\t=&gt; &#039;_facebook_event_id&#039;,\n&#039;value&#039;\t\t=&gt; $event_id,\n),\n);\n$loop = new WP_Query( $args );\n\n\/\/if presents, I update data\nif( $loop-&gt;have_posts() ){\n\t\/\/ se l&#039;evento  presente aggiorno i suoi dati\n\t\/\/$u++;\n\twhile ( $loop-&gt;have_posts() ) : $loop-&gt;the_post();\n\n\t$post_id = get_the_ID();\n\t$post_information = array(\n\t&#039;post_type&#039; =&gt; &#039;event&#039;,\n\t&#039;ID&#039; =&gt; $post_id,\n\t&#039;post_title&#039; =&gt; wp_strip_all_tags($e-&gt;name),\n\t&#039;post_content&#039; =&gt; wp_strip_all_tags($e-&gt;description),\n\t);\n\n\twp_update_post( $post_information );\n\tendwhile;\n}else{ \n\n\t\/\/ else I add event\n\t$post_information = array(\n\t&#039;post_type&#039; =&gt; &#039;event&#039;,\n\t&#039;post_title&#039; =&gt; wp_strip_all_tags($e-&gt;name),\n\t&#039;post_content&#039; =&gt; wp_strip_all_tags($e-&gt;description),\n\t&#039;post_status&#039; =&gt; &#039;publish&#039;,\n\t);\t\t\n\n\t\/\/ insert event post in WP\n\t$post_id = wp_insert_post( $post_information ); \n\n\t\/\/ insert event in events table\n\t$wpdb-&gt;insert(\n\t&#039;SqE_em_events&#039;,\n\tarray(\n\t&#039;event_owner&#039; =&gt; 1,\n\t&#039;event_status&#039; =&gt; 1,\n\t&#039;event_name&#039; =&gt;  wp_strip_all_tags($e-&gt;name),\n\t&#039;event_start_time&#039; =&gt; $starTime,\n\t&#039;event_end_time&#039; =&gt; $endTime,\n\t&#039;event_start_date&#039; =&gt; $startDate,\n\t&#039;event_end_date&#039; =&gt; $endDate,\n\t&#039;post_content&#039; =&gt; wp_strip_all_tags($e-&gt;description),\n\t&#039;event_rsvp&#039; =&gt; 0,\n\t&#039;post_id&#039; =&gt; $post_id,\n\t&#039;location_id&#039; =&gt; $location_id\n\t),\n\tarray(\n\t&#039;%s&#039;,\n\t&#039;%s&#039;,\n\t&#039;%s&#039;,\n\t&#039;%s&#039;,\n\t&#039;%s&#039;,\n\t&#039;%s&#039;,\n\t&#039;%s&#039;,\n\t&#039;%s&#039;,\n\t&#039;%s&#039;,\n\t&#039;%d&#039;,\n\t&#039;%d&#039;\n\t)\n\t);\n\n}\n\n\/\/ update meta for event\nadd_post_meta($post_id, &#039;_facebook_event_id&#039;, $eId, true);\nupdate_post_meta($post_id,&#039;_event_start_time&#039;,$starTime);\nupdate_post_meta($post_id,&#039;_event_end_time&#039;,$endTime);\nupdate_post_meta($post_id,&#039;_event_start_date&#039;,$startDate);\nupdate_post_meta($post_id,&#039;_event_end_date&#039;,$endDate);\nupdate_post_meta($post_id,&#039;_event_status&#039;, 1);\nupdate_post_meta($post_id,&#039;_location_status&#039;, 1);<\/code><\/pre>\n<p>Can someone help me to insert manually and safely an event into EM?<\/p>\n<p><strong>PS: If I use this, Have I to add some includes in php file?<br \/>\nThis doesn&#8217;t work for me.<br \/>\n<\/strong><\/p>\n<pre><code>$EM_Event = new EM_Event();\n$EM_Event-&gt;event_name = $evt_name;\n$EM_Event-&gt;event_start_date = $evt_start_d;\n$EM_Event-&gt;event_start_time = $evt_start_t;\n$EM_Event-&gt;event_end_date = $evt_end_d;\n$EM_Event-&gt;event_end_time = $evt_end_t;\n$EM_Event-&gt;start = strtotime($EM_Event-&gt;event_start_date.&quot; &quot;.$EM_Event-&gt;event_start_time);\n$EM_Event-&gt;end = strtotime($EM_Event-&gt;event_end_date.&quot; &quot;.$EM_Event-&gt;event_end_time);\n$EM_Event-&gt;event_all_day = $evt_all_day;\n$EM_Event-&gt;save();<\/code><\/pre>\n<p>Really thanks guys<\/p>\n","protected":false},"template":"","class_list":["post-7237096","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/7237096","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/7237096\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=7237096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}