@@ -14,21 +14,21 @@ |
||
| 14 | 14 | ORDER BY `hulu`.`date` DESC"; |
| 15 | 15 | $huluActivities = $pdo->fetchAll($query); |
| 16 | 16 | foreach ($huluActivities as $huluActivity) { |
| 17 | - $query = " |
|
| 17 | + $query = " |
|
| 18 | 18 | INSERT INTO `jpemeric_stream`.`activity` |
| 19 | 19 | (`id`, `message`, `message_long`, `datetime`, `metadata`, `type`, `type_id`) |
| 20 | 20 | VALUES |
| 21 | 21 | (:id, :message, :message_long, :datetime, :metadata, :type, :type_id)"; |
| 22 | 22 | |
| 23 | - $bindings = [ |
|
| 24 | - 'id' => $huluActivity['id'], |
|
| 25 | - 'message' => "Watched {$huluActivity['title']} on Hulu.", |
|
| 26 | - 'message_long' => "<p>Watched {$huluActivity['title']} on Hulu.</p>", |
|
| 27 | - 'datetime' => (new DateTime($huluActivity['date'], $container['default_timezone']))->format('Y-m-d H:i:s'), |
|
| 28 | - 'metadata' => json_encode([]), |
|
| 29 | - 'type' => 'hulu', |
|
| 30 | - 'type_id' => $huluActivity['type_id'], |
|
| 31 | - ]; |
|
| 23 | + $bindings = [ |
|
| 24 | + 'id' => $huluActivity['id'], |
|
| 25 | + 'message' => "Watched {$huluActivity['title']} on Hulu.", |
|
| 26 | + 'message_long' => "<p>Watched {$huluActivity['title']} on Hulu.</p>", |
|
| 27 | + 'datetime' => (new DateTime($huluActivity['date'], $container['default_timezone']))->format('Y-m-d H:i:s'), |
|
| 28 | + 'metadata' => json_encode([]), |
|
| 29 | + 'type' => 'hulu', |
|
| 30 | + 'type_id' => $huluActivity['type_id'], |
|
| 31 | + ]; |
|
| 32 | 32 | |
| 33 | - $pdo->perform($query, $bindings); |
|
| 33 | + $pdo->perform($query, $bindings); |
|
| 34 | 34 | } |