<?php require_once '/var/www/vendor/autoload.php'; if (isset($_GET['event_id'])) { $event = \relive\models\SearchIndex::find($_GET['event_id']); } if ($event) { $hashtags = \relive\models\Hashtag::whereIn('hashtag_id', function ($query) use($event) { $query->select('hashtag_id')->from('eventhashtagrelationships')->where('event_id', '=', $event->event_id); })->select('hashtag')->get(); $tags = []; foreach ($hashtags as $hashtag) { array_push($tags, $hashtag->hashtag); } $keyword = join(',', $tags); $posts = \relive\models\Post::whereIn('post_id', function ($query) use($event) { $query->select('post_id')->from('posteventrelationships')->where('event_id', '=', $event->event_id)->where('isFiltered', False); })->orderBy('datetime', 'desc')->offset(0)->limit(15)->get(); } else { header("Location: http://relive.space/"); } ?> <!DOCTYPE html> <html lang="en"> <head prefix="og: http://ogp.me/ns# fb: http://ogp.me/ns/fb##"> <meta charset="UTF-8"> <title>relive</title> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1, user-scalable=no, minimal-ui"> <meta name="apple-mobile-web-app-capable" content="yes"> <meta name="apple-mobile-web-app-status-bar-style" content="black"> <link rel="apple-touch-icon" sizes="57x57" href="//relive.space/apple-touch-icon-57x57.png">