Файловый менеджер - Редактировать - /home/gqdcvggs/.trash/save_session.php
Назад
<?php header('Content-Type: application/json'); header('Access-Control-Allow-Origin: *'); require_once 'config.php'; $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME); if ($conn->connect_error) { echo json_encode(['success' => false, 'error' => 'Database connection failed']); exit; } $data = json_decode(file_get_contents('php://input'), true); $userId = intval($data['userId']); $title = $conn->real_escape_string($data['title']); $description = $conn->real_escape_string($data['description']); $leftScore = intval($data['leftScore']); $rightScore = intval($data['rightScore']); $duration = intval($data['duration']); $satisfaction = intval($data['satisfaction']); $notifyFriends = isset($data['notifyFriends']) ? $data['notifyFriends'] : false; $winner = $leftScore > $rightScore ? 'left' : ($rightScore > $leftScore ? 'right' : 'draw'); $sql = "INSERT INTO sessions (user_id, title, description, left_score, right_score, duration, satisfaction, winner, created_at) VALUES ($userId, '$title', '$description', $leftScore, $rightScore, $duration, $satisfaction, '$winner', NOW())"; if ($conn->query($sql) === TRUE) { $sessionId = $conn->insert_id; if ($notifyFriends) { $userSql = "SELECT first_name, last_name FROM users WHERE id = $userId"; $userResult = $conn->query($userSql); $user = $userResult->fetch_assoc(); $userName = $user['first_name'] . ' ' . $user['last_name']; $friendsSql = "SELECT friend_id FROM friends WHERE user_id = $userId UNION SELECT user_id FROM friends WHERE friend_id = $userId"; $friendsResult = $conn->query($friendsSql); while($friend = $friendsResult->fetch_assoc()) { $friendId = $friend['friend_id']; $notifData = [ 'userId' => strval($friendId), 'title' => 'Nouvelle session', 'message' => "$userName vient de terminer une session !", 'data' => [ 'type' => 'new_session', 'sessionId' => $sessionId, 'userId' => $userId ] ]; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://imators.systems/api-court/send_notification.php'); curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application/json']); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, true); curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($notifData)); curl_exec($ch); curl_close($ch); } } echo json_encode(['success' => true, 'sessionId' => $sessionId]); } else { echo json_encode(['success' => false, 'error' => $conn->error]); } $conn->close(); ?>
| ver. 1.6 |
Github
|
.
| PHP 8.1.33 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка