Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2026-02-22 15:26
admin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
api	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
assets	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
cgi-bin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
chat	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
image	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
includes	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
5CIklYH0.php	445 B	-rw-r--r--	2026-02-23 13:08
G0cQmLsV.php	445 B	-rw-r--r--	2026-02-22 23:14
chat.zip	27.93 MB	-rw-r--r--	2026-02-22 17:31
dashboard.php	36.16 KB	-rw-r--r--	2026-02-23 09:09
database.sql	2.81 KB	-rw-r--r--	2026-02-22 22:29
error_log	2.61 KB	-rw-r--r--	2026-02-23 10:51
index.php	25.53 KB	-rw-r--r--	2026-02-23 10:52
install.php	5.88 KB	-rw-r--r--	2026-02-22 17:43
login.php	5.69 KB	-rw-r--r--	2026-02-22 18:40
logout.php	328 B	-rw-r--r--	2026-02-21 21:39
manifest.json	536 B	-rw-r--r--	2026-02-22 19:03
my_stories.php	11.66 KB	-rw-r--r--	2026-02-21 23:17
signup.php	6.39 KB	-rw-r--r--	2026-02-22 11:41
sw.js	2.21 KB	-rw-r--r--	2026-02-22 20:10
txets.php	4.37 KB	-rw-r--r--	2026-02-24 02:50
wp-blog-header.php	2.74 KB	-rw-r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

<?php
/**
 * Database Installation Script
 * This script will create all necessary tables in your existing database.
 * Run this by visiting yourdomain.com/install.php
 */

require_once 'includes/db.php';

$queries = [
    "CREATE TABLE IF NOT EXISTS users (
        id INT AUTO_INCREMENT PRIMARY KEY,
        username VARCHAR(50) NOT NULL UNIQUE,
        email VARCHAR(100) NOT NULL UNIQUE,
        password VARCHAR(255) NOT NULL,
        profile_pic_url VARCHAR(255) DEFAULT 'default.png',
        status VARCHAR(255) DEFAULT 'Available',
        role ENUM('user', 'admin') DEFAULT 'user',
        last_seen TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        is_online BOOLEAN DEFAULT FALSE,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    )",
    "CREATE TABLE IF NOT EXISTS friend_requests (
        id INT AUTO_INCREMENT PRIMARY KEY,
        sender_id INT NOT NULL,
        receiver_id INT NOT NULL,
        status ENUM('pending', 'accepted', 'rejected') DEFAULT 'pending',
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (sender_id) REFERENCES users(id) ON DELETE CASCADE,
        FOREIGN KEY (receiver_id) REFERENCES users(id) ON DELETE CASCADE
    )",
    "CREATE TABLE IF NOT EXISTS friends (
        id INT AUTO_INCREMENT PRIMARY KEY,
        user_id_1 INT NOT NULL,
        user_id_2 INT NOT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (user_id_1) REFERENCES users(id) ON DELETE CASCADE,
        FOREIGN KEY (user_id_2) REFERENCES users(id) ON DELETE CASCADE
    )",
    "CREATE TABLE IF NOT EXISTS stories (
        id INT AUTO_INCREMENT PRIMARY KEY,
        user_id INT NOT NULL,
        media_url VARCHAR(255) DEFAULT NULL,
        type ENUM('text', 'image', 'video') DEFAULT 'image',
        content TEXT DEFAULT NULL,
        bg_color VARCHAR(20) DEFAULT '#4F46E5',
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    )",
    "CREATE TABLE IF NOT EXISTS messages (
        id INT AUTO_INCREMENT PRIMARY KEY,
        sender_id INT NOT NULL,
        receiver_id INT NOT NULL,
        message TEXT NOT NULL,
        media_url VARCHAR(255) DEFAULT NULL,
        media_type ENUM('text', 'image', 'video', 'audio', 'document') DEFAULT 'text',
        status ENUM('sent', 'delivered', 'read') DEFAULT 'sent',
        deleted_for_sender BOOLEAN DEFAULT FALSE,
        deleted_for_receiver BOOLEAN DEFAULT FALSE,
        story_id INT DEFAULT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (sender_id) REFERENCES users(id) ON DELETE CASCADE,
        FOREIGN KEY (receiver_id) REFERENCES users(id) ON DELETE CASCADE,
        FOREIGN KEY (story_id) REFERENCES stories(id) ON DELETE SET NULL
    )",
    "CREATE TABLE IF NOT EXISTS user_sessions (
        id INT AUTO_INCREMENT PRIMARY KEY,
        user_id INT NOT NULL,
        session_token VARCHAR(255) NOT NULL,
        expires_at TIMESTAMP NOT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    )",
    "CREATE TABLE IF NOT EXISTS admin_logs (
        id INT AUTO_INCREMENT PRIMARY KEY,
        admin_id INT NOT NULL,
        action TEXT NOT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (admin_id) REFERENCES users(id) ON DELETE CASCADE
    )",
    "CREATE TABLE IF NOT EXISTS notifications (
        id INT AUTO_INCREMENT PRIMARY KEY,
        user_id INT NOT NULL,
        message TEXT NOT NULL,
        is_read BOOLEAN DEFAULT FALSE,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    )",
    "CREATE TABLE IF NOT EXISTS calls (
        id INT AUTO_INCREMENT PRIMARY KEY,
        caller_id INT NOT NULL,
        receiver_id INT NOT NULL,
        status ENUM('calling', 'accepted', 'rejected', 'ended', 'busy') DEFAULT 'calling',
        caller_signal TEXT DEFAULT NULL,
        receiver_signal TEXT DEFAULT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        FOREIGN KEY (caller_id) REFERENCES users(id) ON DELETE CASCADE,
        FOREIGN KEY (receiver_id) REFERENCES users(id) ON DELETE CASCADE
    )",
    "CREATE TABLE IF NOT EXISTS story_views (
        user_id INT NOT NULL,
        story_id INT NOT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        PRIMARY KEY (user_id, story_id),
        FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
        FOREIGN KEY (story_id) REFERENCES stories(id) ON DELETE CASCADE
    )",
    "CREATE TABLE IF NOT EXISTS user_chat_settings (
        id INT AUTO_INCREMENT PRIMARY KEY,
        user_id INT NOT NULL,
        friend_id INT NOT NULL,
        background_url VARCHAR(255) DEFAULT NULL,
        is_locked BOOLEAN DEFAULT FALSE,
        lock_password VARCHAR(255) DEFAULT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        UNIQUE KEY (user_id, friend_id),
        FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
        FOREIGN KEY (friend_id) REFERENCES users(id) ON DELETE CASCADE
    )",
    "ALTER TABLE users ADD COLUMN IF NOT EXISTS status VARCHAR(255) DEFAULT 'Available' AFTER profile_pic_url",
    "ALTER TABLE messages ADD COLUMN IF NOT EXISTS story_id INT DEFAULT NULL AFTER deleted_for_receiver"
];

echo "<h2>Database Installation</h2>";

foreach ($queries as $sql) {
    try {
        $pdo->exec($sql);
        echo "<p style='color: green;'>Successfully executed query.</p>";
    }
    catch (PDOException $e) {
        echo "<p style='color: red;'>Error: " . $e->getMessage() . "</p>";
    }
}

echo "<h3>Installation Finished. Please DELETE this file (install.php) for security.</h3>";