From b449b4b3b766dd86728f585f88d91b2c22024805 Mon Sep 17 00:00:00 2001 From: LeonardoBizzoni Date: Thu, 26 May 2022 17:01:01 +0200 Subject: [PATCH] Favorites in home page --- www/controllers/SiteController.php | 15 ++++++++++++--- www/views/live.php | 18 ++++++++++++++++-- 2 files changed, 28 insertions(+), 5 deletions(-) diff --git a/www/controllers/SiteController.php b/www/controllers/SiteController.php index 8f2992a..05226be 100644 --- a/www/controllers/SiteController.php +++ b/www/controllers/SiteController.php @@ -32,7 +32,7 @@ class SiteController extends BaseController public function live(Request $req) { - $params = []; + $vtuberLive = []; $singleVtuber = false; $vtuberModel = new Vtubers; @@ -55,13 +55,22 @@ class SiteController extends BaseController $statement->execute(); foreach ($statement->fetchAll() as $vtuber) { - $params[] = [$vtuber, $vtuberModel->isLive($vtuber["login"], $vtuber["link"])]; + $vtuberLive[] = [$vtuber, $vtuberModel->isLive($vtuber["login"], $vtuber["link"])]; if ($singleVtuber) { Application::$app->router->title = "WeebSite - " . $vtuber["username"]; } } + + if (!Application::isGuest()) { + $statement = Application::$app->db->pdo->prepare("SELECT _vtuberID FROM favoriteVtuber where _userID=".Application::$app->user->id); + $statement->execute(); + + foreach ($statement->fetchAll() as $fav) { + $favorites[] = $fav["_vtuberID"]; + } + } } - return $this->render("live", ["model" => $vtuberModel, $params]); + return $this->render("live", ["model" => $vtuberModel, $vtuberLive, $favorites]); } } diff --git a/www/views/live.php b/www/views/live.php index ca90ac3..561f309 100644 --- a/www/views/live.php +++ b/www/views/live.php @@ -38,6 +38,17 @@ if (count($model->errors) > 0) { Favorites"; + echo ""; + } + echo "

Currently live

"; echo "