}
}
if (isset($_GET['updateevent'])) {
$event_id = $_GET['event_id'];
$event = \relive\models\Event::find($event_id);
$event->eventName = $_GET['eventName'];
$event->startDate = strtotime($_GET['startDate']);
$event->endDate = strtotime($_GET['endDate']);
$event->save();
\relive\models\EventHashtagRelationship::where('event_id', '=', $event_id)->delete();
$hashtags = array();
if (isset($_GET['hashtag1']) && $_GET['hashtag1'] !== '') {
$hashtags[] = $_GET['hashtag1'];
}
if (isset($_GET['hashtag2']) && $_GET['hashtag2'] !== '') {
$hashtags[] = $_GET['hashtag2'];
}
if (isset($_GET['hashtag3']) && $_GET['hashtag3'] !== '') {
$hashtags[] = $_GET['hashtag3'];
}
foreach ($hashtags as $tag) {
$hashtag = \relive\models\Hashtag::firstOrCreate(['hashtag' => $tag]);
$eventhashtagrelationship = \relive\models\EventHashtagRelationship::firstOrCreate(['event_id' => $event_id, 'hashtag_id' => $hashtag->hashtag_id]);
}
}
}
$unpublishedEvents = \relive\models\Event::where('isPublished', '=', '0')->get();
$publishedEvents = \relive\models\Event::where('isPublished', '=', '1')->get();
$reportedPosts = \relive\models\Post::join('reports', 'posts.post_id', '=', 'reports.post_id')->groupBy('posts.post_id')->selectRaw('*,(select count(*) from reports c where c.post_id = posts.post_id) as `count`')->where('isSettled', '=', 0)->orderBy('datetime', 'desc')->get();
include './relive/templates/moderate.php';
}
