Changeset 9632

Timestamp:

03/25/2020 02:37:51 PM (7 years ago)

Author:

ryelle

Message:

Official WordPress Events: Sync the UTC offset to the database

start_timestamp is a fake UTC value, so we need to sync the real UTC offset to be able to get the real local time. This is a workaround because updating start_timestamp to be real UTC would cause more trouble (in the API, in core widget, etc).

Location:

sites/trunk/wordpress.org/public_html/wp-content/plugins/official-wordpress-events

Files:

• official-wordpress-event.php (modified) (1 diff)
• official-wordpress-events.php (modified) (2 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/official-wordpress-events/official-wordpress-event.php

@@ -10 +10 @@
 class Official_WordPress_Event {
         public $id, $type, $source_id, $status, $title, $url, $description, $num_attendees, $meetup_name, $meetup_url,
-           $start_timestamp, $end_timestamp, $location, $country_code, $latitude, $longitude;
+                $start_timestamp, $end_timestamp, $utc_offset, $location, $country_code, $latitude, $longitude;
 
         /**
          * Constructor
-         * 
+         *
          * @param array $members
          */

sites/trunk/wordpress.org/public_html/wp-content/plugins/official-wordpress-events/official-wordpress-events.php

@@ -128 +128 @@
                 foreach ( $events as $event ) {
                         $row_values = array(
-                                'id'          => null,
-                                'type'        => $event->type,
-                                'source_id'   => $event->source_id,
-                                'status'      => $event->status,
-                                'title'       => $event->title,
-                                'url'         => $event->url,
-                                'description' => $event->description,
-                                'attendees'   => $event->num_attendees,
-                                'meetup'      => $event->meetup_name,
-                                'meetup_url'  => $event->meetup_url,
-                                'date_utc'    => date( 'Y-m-d H:i:s', $event->start_timestamp ),
-                                'end_date'    => date( 'Y-m-d H:i:s', $event->end_timestamp ),
-                                'location'    => $event->location,
-                                'country'     => $event->country_code,
-                                'latitude'    => $event->latitude,
-                                'longitude'   => $event->longitude,
+                                'id'              => null,
+                                'type'            => $event->type,
+                                'source_id'       => $event->source_id,
+                                'status'          => $event->status,
+                                'title'           => $event->title,
+                                'url'             => $event->url,
+                                'description'     => $event->description,
+                                'attendees'       => $event->num_attendees,
+                                'meetup'          => $event->meetup_name,
+                                'meetup_url'      => $event->meetup_url,
+                                'date_utc'        => gmdate( 'Y-m-d H:i:s', $event->start_timestamp ),
+                                'end_date'        => gmdate( 'Y-m-d H:i:s', $event->end_timestamp ),
+                                'date_utc_offset' => $event->utc_offset,
+                                'location'        => $event->location,
+                                'country'         => $event->country_code,
+                                'latitude'        => $event->latitude,
+                                'longitude'       => $event->longitude,
                         );
 
-                        // Latitude and longitude are required by the database, so skip events that don't have one
+                        // Latitude and longitude are required by the database, so skip events that don't have one.
                         if ( empty( $row_values['latitude'] ) || empty( $row_values['longitude'] ) ) {
                                 continue;
@@ -475 +476 @@
                                 'num_attendees'   => $meetup['yes_rsvp_count'],
                                 'start_timestamp' => $start_timestamp,
-                                'end_timestamp'   => ( empty ( $meetup['duration'] ) ? $start_timestamp : $start_timestamp + ( $meetup['duration'] / 1000 ) ), // convert to seconds
+                                'end_timestamp'   => ( empty( $meetup['duration'] ) ? $start_timestamp : $start_timestamp + ( $meetup['duration'] / 1000 ) ), // convert to seconds.
+                                'utc_offset'      => $meetup['utc_offset'] / 1000, // convert to seconds.
                                 'location'        => $location,
                                 'country_code'    => $country_code,