prepare("SELECT id FROM users WHERE eitaa_id = ? LIMIT 1"); $stmtUser->execute([$eitaa_id]); $userRow = $stmtUser->fetch(); if (!$userRow) { $insert = $pdo->prepare("INSERT INTO users (eitaa_id, first_name, last_name) VALUES (?, ?, ?)"); $insert->execute([$eitaa_id, $first_name, $last_name]); $internal_user_id = $pdo->lastInsertId(); } else { $internal_user_id = $userRow['id']; } if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'toggle_fav') { $game_id = intval($_POST['game_id']); $checkFav = $pdo->prepare("SELECT id FROM favorites WHERE user_id = ? AND game_id = ?"); $checkFav->execute([$internal_user_id, $game_id]); if ($checkFav->fetch()) { $pdo->prepare("DELETE FROM favorites WHERE user_id = ? AND game_id = ?")->execute([$internal_user_id, $game_id]); echo json_encode(['status' => 'removed']); } else { $pdo->prepare("INSERT INTO favorites (user_id, game_id) VALUES (?, ?)")->execute([$internal_user_id, $game_id]); echo json_encode(['status' => 'added']); } exit; } $favQuery = "SELECT g.* FROM games g JOIN favorites f ON g.id = f.game_id WHERE f.user_id = ?"; $stmtFav = $pdo->prepare($favQuery); $stmtFav->execute([$internal_user_id]); $favoriteGames = $stmtFav->fetchAll(); $fav_game_ids = array_column($favoriteGames, 'id'); $stmtAll = $pdo->query("SELECT * FROM games ORDER BY id DESC"); $allGames = $stmtAll->fetchAll(); } catch (PDOException $e) { die("Error SQL : " . $e->getMessage()); } ?>

کانال ما

بازی های مورد علاقه

', true)"> icon
بازی محبوب شما
شروع

همه ی بازی ها

', )"> icon
آماده برای بازی
شروع
بازی در دیتابیس یافت نشد!