📚 Project Documentation

mirror/
├── index.php              # Main kernel listing page
├── docs.php               # This documentation page
├── stats.php              # Statistics dashboard
├── mirror.php             # Mirror setup guide
├── contact.php            # Contact information
├── privacy.php            # Privacy policy
├── terms.php              # Terms of service
├── mission.php            # About/mission page
│
├── css/
│   └── style.css          # Global stylesheet (1000+ lines)
│
├── js/
│   └── helper.js          # Utility functions
│
├── backend/
│   ├── db.php             # Database connection (PDO)
│   ├── init.php           # Security & session initialization
│   └── userp.php          # Helper classes (User, Stats)
│
├── static/
│   ├── nav.php            # Navigation component
│   ├── logo.php           # Logo/branding component
│   └── footer.php         # Footer component
│
└── images/
    ├── icons/             # Icon assets
    └── media/             # Media files

# 1. Clone or download the project
cd /var/www/html
sudo git clone https://github.com/yourusername/kernel-mirror.git mirror

# 2. Set proper permissions
sudo chown -R www-data:www-data mirror
find mirror -type d -exec chmod 755 {} \;
find mirror -type f -exec chmod 644 {} \;

# 3. Install PHP dependencies (if using Composer)
cd mirror
composer install --no-dev

# 4. Create database
mysql -u root -p
CREATE DATABASE kernel_mirror CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE USER 'mirror_user'@'localhost' IDENTIFIED BY 'secure_password';
GRANT ALL PRIVILEGES ON kernel_mirror.* TO 'mirror_user'@'localhost';
FLUSH PRIVILEGES;
EXIT;

# 5. Import database schema
mysql -u mirror_user -p kernel_mirror < database/schema.sql

# 6. Configure database connection
cp inc/db.example.php inc/db.php
nano inc/db.php  # Edit with your credentials

<?php
// Database Configuration
define('DB_HOST', 'localhost');
define('DB_NAME', 'kernel_mirror');
define('DB_USERNAME', 'mirror_user');
define('DB_PASSWORD', 'your_secure_password');
define('DB_CHARSET', 'utf8mb4');

// PDO Connection
try {
    $odb = new PDO(
        "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=" . DB_CHARSET,
        DB_USERNAME,
        DB_PASSWORD,
        [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
            PDO::ATTR_EMULATE_PREPARES => false
        ]
    );
} catch (PDOException $e) {
    error_log("Database Connection Error: " . $e->getMessage());
    die("Database connection failed. Please check configuration.");
}
?>

server {
    listen 80;
    listen [::]:80;
    server_name mirror.example.com;
    root /var/www/html/mirror;
    index index.php;

    # Logging
    access_log /var/log/nginx/mirror-access.log;
    error_log /var/log/nginx/mirror-error.log;

    # PHP Processing
    location ~ \.php$ {
        fastcgi_pass unix:/var/run/php/php8.1-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }

    # Security headers
    add_header X-Frame-Options "SAMEORIGIN" always;
    add_header X-Content-Type-Options "nosniff" always;
    add_header X-XSS-Protection "1; mode=block" always;

    # Cache static assets
    location ~* \.(css|js|jpg|jpeg|png|gif|ico|svg|woff|woff2|ttf|eot)$ {
        expires 1y;
        add_header Cache-Control "public, immutable";
    }

    # Deny access to sensitive files
    location ~ /\. {
        deny all;
    }
}

:root {
    --primary-color: #2563eb;      /* Main brand color */
    --primary-hover: #1d4ed8;      /* Hover state */
    --success-color: #10b981;      /* Success messages */
    --warning-color: #f59e0b;      /* Warnings */
    --danger-color: #ef4444;       /* Errors */
    --border-radius: 8px;          /* Border radius */
    --transition: all 0.3s ease;   /* Animation speed */
}

CREATE TABLE `kernel` (
  `id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `version` VARCHAR(50) NOT NULL,
  `status` VARCHAR(20) NOT NULL DEFAULT 'stable',
  `url` TEXT NOT NULL,
  `pgp` TEXT,
  `changelog` TEXT,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `idx_version` (`version`),
  INDEX `idx_status` (`status`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `users` (
  `ID` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `username` VARCHAR(100) NOT NULL UNIQUE,
  `password` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255),
  `rank` TINYINT DEFAULT 0,      -- 0=user, 1=admin, 2=staff
  `status` TINYINT DEFAULT 0,    -- 0=active, 1=banned
  `membership` TINYINT DEFAULT 0,
  `expire` INT UNSIGNED,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Insert new kernel version
INSERT INTO `kernel` (version, status, url, pgp, changelog)
VALUES (
    '6.6.0',
    'stable',
    'https://cdn.kernel.org/pub/linux/kernel/v6.x/linux-6.6.tar.xz',
    'https://cdn.kernel.org/pub/linux/kernel/v6.x/linux-6.6.tar.sign',
    'Linux 6.6 Release Notes:\n- Feature 1\n- Feature 2\n- Bug fixes'
);

-- Mark kernel as deprecated
UPDATE `kernel` SET status = 'deprecated' WHERE version = '5.4.0';

-- Promote beta to stable
UPDATE `kernel` SET status = 'stable' WHERE version = '6.6.0';

-- Create admin user (remember to hash password!)
INSERT INTO `users` (username, password, email, rank)
VALUES ('admin', '$2y$10$hashed_password_here', 'admin@example.com', 1);

-- Ban a user
UPDATE `users` SET status = 1 WHERE username = 'spammer';

class User {
    // Check if user is admin
    public function isAdmin($odb): bool
    
    // Check if user is staff
    public function isStaff($odb): bool
    
    // Check if user is logged in
    public function LoggedIn(): bool
    
    // Check if user has active membership
    public function hasMembership($odb): bool
    
    // Check if user is not banned
    public function notBanned($odb): bool
}

// Always sanitize user input
$version = htmlspecialchars($_POST['version'], ENT_QUOTES, 'UTF-8');

// Validate URLs
$validURL = filter_var($url, FILTER_VALIDATE_URL) ? $url : null;

// Use prepared statements for database queries
$stmt = $odb->prepare("SELECT * FROM kernel WHERE version = :version");
$stmt->execute([':version' => $version]);