Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/pennagaram.org/public_html

Free Space:

10.31 TB

🔧 Quick Actions

✏️ Editing: submit-shop.php

<?php
session_start();
require_once 'includes/db.php';

// Enable error reporting for debugging
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Set content type
header('Content-Type: text/html; charset=utf-8');

// Initialize variables
$errors = [];
$success = false;

// PUSH NOTIFICATION FUNCTION - UPDATED METHOD NAMES
function sendPushNotification($title, $body)
{
    // Your VAPID Keys
    $publicKey = "BN0McYnUYCrMY0b71TWNnZfqzshBud8m9Rt-TqHJbKTCKFEb46P5PPndrVAMLTLnIky-4Q3UW3pZeUW3althbUE";
    $privateKey = "-GGKKtfGEkUPqKs0MlG25J1xcsEFIqqm6gNJj20UkFU";

$auth = [
        'VAPID' => [
            'subject' => 'mailto:admin@pennagaram.org',
            'publicKey' => $publicKey,
            'privateKey' => $privateKey,
        ],
    ];

$file = __DIR__ . "/subs.txt";
    if (!file_exists($file)) {
        return; // No subscribers yet
    }

$subs = file($file, FILE_IGNORE_NEW_LINES);
    if (empty($subs)) {
        return;
    }

try {
        // Load WebPush library
        require __DIR__ . '/new/vendor/autoload.php';
        
        // Try different method names based on library version
        $webPush = new Minishlink\WebPush\WebPush($auth);

$sent = false;
        foreach ($subs as $s) {
            $subscriptionData = json_decode($s, true);
            if (json_last_error() !== JSON_ERROR_NONE) {
                continue; // Skip invalid JSON
            }

// Create subscription object
            $subscription = Minishlink\WebPush\Subscription::create($subscriptionData);
            
            // Try different method names for different versions
            $payload = json_encode([
                "title" => $title,
                "body" => $body,
                "icon" => "/icon.png"
            ]);

// Method 1: Try queueNotification (newer versions)
            if (method_exists($webPush, 'queueNotification')) {
                $webPush->queueNotification($subscription, $payload);
                $sent = true;
            } 
            // Method 2: Try sendNotification (older versions)
            elseif (method_exists($webPush, 'sendNotification')) {
                $webPush->sendNotification($subscription, $payload);
                $sent = true;
            }
            // Method 3: Try sendOneNotification (some versions)
            elseif (method_exists($webPush, 'sendOneNotification')) {
                $webPush->sendOneNotification($subscription, $payload);
                $sent = true;
            }
        }

// Flush notifications if any were sent
        if ($sent) {
            // Try different flush method names
            if (method_exists($webPush, 'flush')) {
                $webPush->flush();
            } elseif (method_exists($webPush, 'close')) {
                $webPush->close();
            }
        }

} catch (Exception $e) {
        error_log("Push notification error: " . $e->getMessage());
        // Don't break the shop registration if push fails
    }
}

// Check if form is submitted
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
 
 // Validate and sanitize input data
 $shop_name = trim($_POST['shop_name'] ?? '');
 $business_type = intval($_POST['business_type'] ?? 0);
 $description = trim($_POST['description'] ?? '');
 $keywords = trim($_POST['keywords'] ?? '');
 $owner_name = trim($_POST['owner_name'] ?? '');
 $email = trim($_POST['email'] ?? '');
 $mobile = trim($_POST['mobile'] ?? '');
 $address = trim($_POST['address'] ?? '');
 $opening_hours = trim($_POST['opening_hours'] ?? '');
 $custom_timing = trim($_POST['custom_timing'] ?? '');
 $map_link = trim($_POST['map_link'] ?? '');
 $website = trim($_POST['website'] ?? '');
 
 // Use custom timing if provided
 if ($opening_hours === 'custom' && !empty($custom_timing)) {
 $opening_hours = $custom_timing;
 } elseif ($opening_hours === 'custom' && empty($custom_timing)) {
 $opening_hours = '';
 }
 
 // Validate required fields
 if (empty($shop_name)) {
 $errors[] = "Shop name is required";
 }
 
 if ($business_type <= 0) {
 $errors[] = "Business type is required";
 }
 
 if (empty($description)) {
 $errors[] = "Business description is required";
 }
 
 if (empty($owner_name)) {
 $errors[] = "Owner name is required";
 }
 
 if (empty($email)) {
 $errors[] = "Email address is required";
 } elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
 $errors[] = "Please enter a valid email address";
 }
 
 if (empty($mobile)) {
 $errors[] = "Mobile number is required";
 } elseif (!preg_match('/^[0-9+\-\s()]{10,}$/', $mobile)) {
 $errors[] = "Please enter a valid mobile number";
 }
 
 if (empty($address)) {
 $errors[] = "Address is required";
 }
 
 // Check if terms are agreed
 if (!isset($_POST['terms'])) {
 $errors[] = "You must agree to the terms and conditions";
 }
 
 // Validate file uploads
 $front_image_path = '';
 $additional_images = [];
 
 // Process front image
 if (isset($_FILES['front_image']) && $_FILES['front_image']['error'] === UPLOAD_ERR_OK) {
 $front_image = $_FILES['front_image'];
 $front_image_path = handleFileUpload($front_image, 'front');
 if (!$front_image_path) {
 $errors[] = "Failed to upload front image. Please try again.";
 }
 } else {
 $errors[] = "Front image is required";
 }
 
 // Process additional images
 if (isset($_FILES['additional_images']) && !empty($_FILES['additional_images']['name'][0])) {
 $additional_files = $_FILES['additional_images'];
 
 // Handle multiple file uploads
 for ($i = 0; $i < count($additional_files['name']); $i++) {
 if ($additional_files['error'][$i] === UPLOAD_ERR_OK) {
 $file = [
 'name' => $additional_files['name'][$i],
 'type' => $additional_files['type'][$i],
 'tmp_name' => $additional_files['tmp_name'][$i],
 'error' => $additional_files['error'][$i],
 'size' => $additional_files['size'][$i]
 ];
 
 $additional_image_path = handleFileUpload($file, 'additional_' . ($i + 1));
 if ($additional_image_path) {
 $additional_images[] = $additional_image_path;
 }
 }
 }
 }
 
 // If no errors, proceed with database insertion
 if (empty($errors)) {
 // Get business type name from categories table
 $business_type_name = getBusinessTypeName($business_type);
 
 // Generate slug for the shop
 $slug = generateSlug($shop_name);
 
 // Prepare SQL statement for shop registration - using shops1 table
 $sql = "INSERT INTO shops1 (
 shop_name, owner_name, email, mobile, address, 
 business_type, opening_hours, website, map_link, 
 description, keywords, front_image, slug, status, created_at
 ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pending', NOW())";
 
 $stmt = mysqli_prepare($conn, $sql);
 
 if ($stmt) {
 // Bind parameters
 mysqli_stmt_bind_param($stmt, "sssssssssssss", 
 $shop_name, $owner_name, $email, $mobile, $address,
 $business_type_name, $opening_hours, $website, $map_link,
 $description, $keywords, $front_image_path, $slug
 );
 
 // Execute the statement
 if (mysqli_stmt_execute($stmt)) {
 $shop_id = mysqli_insert_id($conn);
 $success = true;
 
 // Insert additional images if any
 if (!empty($additional_images)) {
 foreach ($additional_images as $image_path) {
 $image_sql = "INSERT INTO shop_images (shop_id, image_path, created_at) VALUES (?, ?, NOW())";
 $image_stmt = mysqli_prepare($conn, $image_sql);
 if ($image_stmt) {
 mysqli_stmt_bind_param($image_stmt, "is", $shop_id, $image_path);
 mysqli_stmt_execute($image_stmt);
 mysqli_stmt_close($image_stmt);
 }
 }
 }
 
 // Send confirmation email (optional)
 sendConfirmationEmail($email, $shop_name, $owner_name);
 
 // 🚀 SEND PUSH NOTIFICATION
 sendPushNotification(
 "New Shop Registered", 
 "A new shop '$shop_name' has registered on Pennagaram Official!"
 );
 
 } else {
 $errors[] = "Database error: " . mysqli_error($conn);
 }
 
 mysqli_stmt_close($stmt);
 } else {
 $errors[] = "Database preparation error: " . mysqli_error($conn);
 }
 }
}

// Redirect with status message
if ($success) {
    header('Location: register-your-shop.php?status=success');
    exit();
} else {
    $error_message = urlencode(implode(', ', $errors));
    header('Location: register-your-shop.php?status=error&message=' . $error_message);
    exit();
}

/**
 * Handle file upload with proper validation and security
 */
function handleFileUpload($file, $prefix) {
    $upload_dir = 'uploads/shops/';
    
    // Create upload directory if it doesn't exist
    if (!is_dir($upload_dir)) {
        mkdir($upload_dir, 0755, true);
    }
    
    // Validate file type
    $allowed_types = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif', 'image/webp'];
    $file_type = mime_content_type($file['tmp_name']);
    
    if (!in_array($file_type, $allowed_types)) {
        return false;
    }
    
    // Generate unique filename
    $file_extension = pathinfo($file['name'], PATHINFO_EXTENSION);
    $filename = $prefix . '_' . uniqid() . '_' . time() . '.' . strtolower($file_extension);
    $file_path = $upload_dir . $filename;
    
    // Move uploaded file
    if (move_uploaded_file($file['tmp_name'], $file_path)) {
        return $file_path;
    }
    
    return false;
}

/**
 * Get business type name from category ID
 */
function getBusinessTypeName($category_id) {
    global $conn;
    
    $sql = "SELECT name FROM shop_categories WHERE id = ?";
    $stmt = mysqli_prepare($conn, $sql);
    mysqli_stmt_bind_param($stmt, "i", $category_id);
    mysqli_stmt_execute($stmt);
    mysqli_stmt_bind_result($stmt, $name);
    
    if (mysqli_stmt_fetch($stmt)) {
        mysqli_stmt_close($stmt);
        return $name;
    }
    
    mysqli_stmt_close($stmt);
    return 'Other';
}

/**
 * Generate unique slug for the shop
 */
function generateSlug($shop_name) {
    global $conn;
    
    // Create base slug from shop name
    $slug = preg_replace('/[^a-zA-Z0-9]/', '-', $shop_name);
    $slug = strtolower($slug);
    $slug = preg_replace('/-+/', '-', $slug);
    $slug = trim($slug, '-');
    
    // Check if slug already exists
    $base_slug = $slug;
    $counter = 1;
    
    do {
        $check_sql = "SELECT id FROM shops1 WHERE slug = ?";
        $check_stmt = mysqli_prepare($conn, $check_sql);
        mysqli_stmt_bind_param($check_stmt, "s", $slug);
        mysqli_stmt_execute($check_stmt);
        mysqli_stmt_store_result($check_stmt);
        
        if (mysqli_stmt_num_rows($check_stmt) > 0) {
            // If slug exists, add counter
            $slug = $base_slug . '-' . $counter;
            $counter++;
        } else {
            break;
        }
        
        mysqli_stmt_close($check_stmt);
    } while (true);
    
    return $slug;
}

/**
 * Send confirmation email to shop owner
 */
function sendConfirmationEmail($email, $shop_name, $owner_name) {
 $subject = "Shop Registration Confirmation - Pennagaram Official";
 $message = "
 <html>
 <head>
 <title>Shop Registration Confirmation</title>
 </head>
 <body>
 <h2>Thank you for registering your shop!</h2>
 Dear $owner_name,
 Your shop $shop_name has been successfully registered with Pennagaram Official.
 Our team will review your registration and approve it within 24-48 hours. You will receive another email once your shop is approved and listed in our directory.
 If you have any questions, please contact us.
 
 Best regards, Pennagaram Official Team
 </body>
 </html>
 ";
 
 $headers = "MIME-Version: 1.0" . "\r\n";
 $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
 $headers .= "From: no-reply@pennagaram.org" . "\r\n";
 
 // Uncomment the line below to actually send emails
 // mail($email, $subject, $message, $headers);
 
 // For debugging, you can log instead
 error_log("Email would be sent to: $email - Subject: $subject");
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: submit-shop.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation