T.ME/BIBIL_0DAY
CasperSecurity


Server : Apache/2
System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64
User : gositeme ( 1004)
PHP Version : 8.2.29
Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname
Directory :  /home/gositeme/domains/soundstudiopro.com/public_html/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/gositeme/domains/soundstudiopro.com/public_html/api_select_variation.php
<?php
session_start();
header('Content-Type: application/json');

// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
    http_response_code(401);
    echo json_encode(['success' => false, 'error' => 'Not authenticated']);
    exit;
}

// Check if it's a POST request
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    http_response_code(405);
    echo json_encode(['success' => false, 'error' => 'Method not allowed']);
    exit;
}

// Get JSON input
$input = json_decode(file_get_contents('php://input'), true);

if (!$input || !isset($input['track_id']) || !isset($input['variation_index'])) {
    http_response_code(400);
    echo json_encode(['success' => false, 'error' => 'Missing required parameters']);
    exit;
}

$track_id = (int)$input['track_id'];
$variation_index = (int)$input['variation_index'];

// Include database configuration
require_once 'config/database.php';

try {
    $pdo = getDBConnection();
    
    // Verify the track belongs to the user
    $stmt = $pdo->prepare("SELECT id FROM music_tracks WHERE id = ? AND user_id = ?");
    $stmt->execute([$track_id, $_SESSION['user_id']]);
    $track = $stmt->fetch();
    
    if (!$track) {
        http_response_code(404);
        echo json_encode(['success' => false, 'error' => 'Track not found']);
        exit;
    }
    
    // Verify the variation exists
    $stmt = $pdo->prepare("SELECT id FROM audio_variations WHERE track_id = ? AND variation_index = ?");
    $stmt->execute([$track_id, $variation_index]);
    $variation = $stmt->fetch();
    
    if (!$variation) {
        http_response_code(404);
        echo json_encode(['success' => false, 'error' => 'Variation not found']);
        exit;
    }
    
    // Update the track's selected variation in metadata
    $stmt = $pdo->prepare("SELECT metadata FROM music_tracks WHERE id = ?");
    $stmt->execute([$track_id]);
    $track_data = $stmt->fetch();
    
    $metadata = json_decode($track_data['metadata'] ?? '{}', true) ?: [];
    $metadata['selected_variation'] = $variation_index;
    
    // Update the track with the new metadata
    $stmt = $pdo->prepare("UPDATE music_tracks SET metadata = ? WHERE id = ?");
    $stmt->execute([json_encode($metadata), $track_id]);
    
    echo json_encode([
        'success' => true,
        'message' => 'Variation selection saved successfully',
        'track_id' => $track_id,
        'variation_index' => $variation_index
    ]);
    
} catch (Exception $e) {
    error_log("Error saving variation selection: " . $e->getMessage());
    http_response_code(500);
    echo json_encode(['success' => false, 'error' => 'Internal server error']);
}
?> 

CasperSecurity Mini