Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2026-03-13 15:14
admin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
assets	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
hania	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
includes	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
user	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
.user.ini	578 B	-rw-r--r--	2026-03-13 17:04
add_maintenance_setting.php	669 B	-rw-r--r--	2026-03-12 12:31
check_db.php	161 B	-rw-r--r--	2026-03-12 15:16
check_withdrawals.php	156 B	-rw-r--r--	2026-03-12 15:17
contact.php	6.42 KB	-rw-r--r--	2026-03-28 15:18
database.sql	19.53 KB	-rw-r--r--	2026-03-11 23:07
debug.php	5.09 KB	-rw-r--r--	2026-03-30 15:21
error_log	8.83 KB	-rw-r--r--	2026-03-30 15:27
forgot-password.php	2.16 KB	-rw-r--r--	2026-03-30 15:26
how-it-works.php	1.99 KB	-rw-r--r--	2026-03-11 22:52
index.php	9.37 KB	-rw-r--r--	2026-03-12 00:13
login.php	5.17 KB	-rw-r--r--	2026-03-30 15:28
logout.php	56 B	-rw-r--r--	2026-03-11 23:27
maintenance.php	4.5 KB	-rw-r--r--	2026-03-12 12:39
php.ini	578 B	-rw-r--r--	2026-03-13 17:04
plans.php	2.72 KB	-rw-r--r--	2026-03-12 00:10
register.php	8.79 KB	-rw-r--r--	2026-03-30 15:27
reset-password.php	6.39 KB	-rw-r--r--	2026-03-14 18:08
update_db.php	421 B	-rw-r--r--	2026-03-12 15:17
update_withdrawals.php	417 B	-rw-r--r--	2026-03-12 15:18
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

-- ============================================================
--  Assignment Work Zone — Full Database Schema  v1.1
--  Compatible with XAMPP MySQL / MariaDB
-- ============================================================

CREATE DATABASE IF NOT EXISTS assignment_work_zone
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;

USE assignment_work_zone;

-- ──────────────────────────────────────────────────────────────
--  1. USERS
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `users` (
  `id`               int(11)       NOT NULL AUTO_INCREMENT,
  `full_name`        varchar(100)  NOT NULL,
  `email`            varchar(100)  NOT NULL,
  `password`         varchar(255)  NOT NULL,
  `referral_code`    varchar(20)   DEFAULT NULL,
  `referred_by`      int(11)       DEFAULT NULL,
  `status`           enum('active','inactive') DEFAULT 'inactive',
  `balance`          decimal(10,2) DEFAULT '0.00',
  `total_earned`     decimal(10,2) DEFAULT '0.00',
  `total_withdrawn`  decimal(10,2) DEFAULT '0.00',
  `created_at`       timestamp     DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_email`         (`email`),
  UNIQUE KEY `uq_referral_code` (`referral_code`),
  KEY `idx_status`              (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  2. PLANS
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `plans` (
  `id`              int(11)       NOT NULL AUTO_INCREMENT,
  `name`            varchar(100)  NOT NULL,
  `features`        text          NOT NULL,
  `is_premium`      tinyint(1)    DEFAULT '0',
  `is_active`       tinyint(1)    DEFAULT '1',           -- NEW: soft-delete / hide plan
  `price`           decimal(10,2) NOT NULL,
  `validity_type`   enum('lifetime','days') DEFAULT 'days',
  `validity_days`   int(11)       DEFAULT '0',
  `assignment_pay`  decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  3. USER PLANS  (purchased plan per user)
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `user_plans` (
  `id`           int(11)  NOT NULL AUTO_INCREMENT,
  `user_id`      int(11)  NOT NULL,
  `plan_id`      int(11)  NOT NULL,
  `status`       enum('active','expired') DEFAULT 'active',
  `purchased_at` timestamp DEFAULT CURRENT_TIMESTAMP,
  `expires_at`   timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_status` (`user_id`, `status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  4. DEPOSITS  (payment proof submitted by user)
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `deposits` (
  `id`            int(11)      NOT NULL AUTO_INCREMENT,
  `user_id`       int(11)      NOT NULL,
  `plan_id`       int(11)      NOT NULL,
  `status`        enum('pending','approved','rejected') DEFAULT 'pending',
  `payment_proof` varchar(255) DEFAULT NULL,
  `submitted_at`  timestamp    DEFAULT CURRENT_TIMESTAMP,
  `reviewed_at`   timestamp    NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_status` (`user_id`, `status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  5. ASSIGNMENTS  (topics posted by admin)
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `assignments` (
  `id`           int(11)      NOT NULL AUTO_INCREMENT,
  `topic`        varchar(255) NOT NULL,
  `subject`      varchar(100) NOT NULL,
  `type`         enum('manual','auto') DEFAULT 'manual',
  `instructions` text,
  `is_active`    tinyint(1)   DEFAULT '1',               -- NEW: hide old topics
  `created_at`   timestamp    DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  6. ASSIGNMENT SUBMISSIONS
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `assignment_submissions` (
  `id`            int(11)      NOT NULL AUTO_INCREMENT,
  `user_id`       int(11)      NOT NULL,
  `assignment_id` int(11)      NOT NULL,
  `file_path`     varchar(255) NOT NULL,
  `status`        enum('pending','approved','rejected') DEFAULT 'pending',
  `reviewed_at`   timestamp    NULL DEFAULT NULL,
  `pay_amount`    decimal(10,2) DEFAULT '0.00',
  `created_at`    timestamp    DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_date` (`user_id`, `created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  7. WITHDRAW METHODS  (admin-configured payout options)
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `withdraw_methods` (
  `id`             int(11)      NOT NULL AUTO_INCREMENT,
  `bank_name`      varchar(100) NOT NULL,
  `account_name`   varchar(100) DEFAULT NULL,
  `account_number` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  8. WITHDRAWALS  (user payout requests)
--     NEW columns: user_account_name, user_account_number
--     so admin knows WHERE to send the money
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `withdrawals` (
  `id`                  int(11)       NOT NULL AUTO_INCREMENT,
  `user_id`             int(11)       NOT NULL,
  `method_id`           int(11)       NOT NULL,
  `amount`              decimal(10,2) NOT NULL,
  `user_account_name`   varchar(150)  DEFAULT NULL,       -- NEW
  `user_account_number` varchar(150)  DEFAULT NULL,       -- NEW
  `status`              enum('pending','approved','rejected') DEFAULT 'pending',
  `requested_at`        timestamp     DEFAULT CURRENT_TIMESTAMP,
  `approved_at`         timestamp     NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_status` (`user_id`, `status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  9. PAYMENT METHODS  (admin-configured deposit options)
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `payment_methods` (
  `id`             int(11)      NOT NULL AUTO_INCREMENT,
  `bank_name`      varchar(100) NOT NULL,
  `account_name`   varchar(100) NOT NULL,
  `account_number` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  10. TRANSACTIONS  (unified ledger)
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `transactions` (
  `id`          int(11)  NOT NULL AUTO_INCREMENT,
  `user_id`     int(11)  NOT NULL,
  `type`        enum('deposit','withdrawal','assignment_earning','referral_commission','plan_purchase') NOT NULL,
  `amount`      decimal(10,2) NOT NULL,
  `description` varchar(255)  DEFAULT NULL,
  `created_at`  timestamp     DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_type` (`user_id`, `type`),
  KEY `idx_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  11. REFERRALS
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `referrals` (
  `id`               int(11)       NOT NULL AUTO_INCREMENT,
  `referrer_id`      int(11)       NOT NULL,
  `referred_id`      int(11)       NOT NULL,
  `level`            int(11)       NOT NULL,
  `commission_earned` decimal(10,2) DEFAULT '0.00',
  `created_at`       timestamp     DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_referrer` (`referrer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  12. SUPPORT TICKETS
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `tickets` (
  `id`         int(11)      NOT NULL AUTO_INCREMENT,
  `user_id`    int(11)      NOT NULL,
  `subject`    varchar(255) NOT NULL,
  `message`    text         NOT NULL,
  `status`     enum('open','in_progress','resolved') DEFAULT 'open',
  `created_at` timestamp    DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_status` (`user_id`, `status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  13. TICKET REPLIES
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `ticket_replies` (
  `id`          int(11) NOT NULL AUTO_INCREMENT,
  `ticket_id`   int(11) NOT NULL,
  `sender_role` enum('user','admin') NOT NULL,
  `message`     text    NOT NULL,
  `created_at`  timestamp DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_ticket` (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  14. SITE SETTINGS  (key-value store)
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `site_settings` (
  `setting_key`   varchar(100) NOT NULL,
  `setting_value` text,
  PRIMARY KEY (`setting_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  15. ANNOUNCEMENTS  (dashboard marquee bar)
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `announcements` (
  `id`        int(11) NOT NULL AUTO_INCREMENT,
  `text`      text    NOT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  16. CONTACT MESSAGES  (from landing page contact form)
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `contact_messages` (
  `id`         int(11)      NOT NULL AUTO_INCREMENT,
  `name`       varchar(100) NOT NULL,
  `email`      varchar(100) NOT NULL,
  `message`    text         NOT NULL,
  `is_read`    tinyint(1)   DEFAULT '0',             -- NEW: admin can mark read
  `created_at` timestamp    DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ──────────────────────────────────────────────────────────────
--  17. ADMIN LOGS  (audit trail for impersonation & sensitive actions)
--  NEW TABLE — required by PRD security section
-- ──────────────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `admin_logs` (
  `id`          int(11)      NOT NULL AUTO_INCREMENT,
  `admin_id`    int(11)      NOT NULL,
  `action`      varchar(100) NOT NULL,
  `target_type` varchar(50)  DEFAULT NULL,   -- e.g. 'user', 'deposit', 'plan'
  `target_id`   int(11)      DEFAULT NULL,
  `details`     text         DEFAULT NULL,
  `ip_address`  varchar(45)  DEFAULT NULL,
  `created_at`  timestamp    DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_admin` (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ============================================================
--  DEFAULT DATA
-- ============================================================

-- Admin user  (password = Admin123)
INSERT IGNORE INTO `users`
  (`full_name`, `email`, `password`, `referral_code`, `status`)
VALUES
  ('Admin', 'admin@gmail.com',
   '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi',
   'ADMINXYZ1', 'active');
-- NOTE: The hash above is for "Admin123" using PASSWORD_BCRYPT cost 10.
-- You can regenerate it with:  echo password_hash('Admin123', PASSWORD_BCRYPT);

-- ── Site Settings (all keys needed across every PHP page) ───────────────────
INSERT IGNORE INTO `site_settings` (`setting_key`, `setting_value`) VALUES
-- General
('site_name',              'Assignment Work Zone'),
('currency_symbol',        'Rs'),
-- Owner / Contact page
('owner_name',             'Muhammad Ali'),
('owner_bio',              'Founder of Assignment Work Zone — Dedicated to building a fair and transparent earning platform.'),
('owner_phone',            '+92-300-1234567'),
('owner_email',            'owner@assignmentworkzone.com'),
('owner_photo',            ''),          -- path to uploaded photo
-- Co-Founder info (PRD requirement)
('cofounder_name',         'Hania Bibi'),
('cofounder_bio',          'Co-Founder — Managing platform operations and user success.'),
('cofounder_phone',        '+92-311-7654321'),
('cofounder_email',        'cofounder@assignmentworkzone.com'),
('cofounder_photo',        ''),
-- Finance
('min_withdrawal',         '500.00'),
-- Referral system
('referral_levels',        '3'),
('referral_commissions',   '{"1": 10, "2": 5, "3": 2}');

-- ── Default Announcement ─────────────────────────────────────────────────────
INSERT IGNORE INTO `announcements` (`text`, `is_active`) VALUES
('🎉 Welcome to Assignment Work Zone! Submit your first assignment today and start earning money.', 1);

-- ── Sample Plans (so new installs are not empty) ─────────────────────────────
INSERT IGNORE INTO `plans`
  (`id`, `name`, `features`, `is_premium`, `is_active`, `price`, `validity_type`, `validity_days`, `assignment_pay`)
VALUES
(1, 'Starter', 'Daily Assignments\nFast Withdrawals\nBasic Support',
 0, 1, 1000.00, 'days', 30, 150.00),
(2, 'Standard', 'Daily Assignments\nPriority Support\nTeam Commission\nFast Withdrawals',
 0, 1, 2500.00, 'days', 60, 300.00),
(3, 'Premium ⭐', 'Unlimited Daily Assignments\nVIP Support 24/7\nMulti-Level Team Commission\nInstant Withdrawals\nExclusive Bonuses',
 1, 1, 5000.00, 'lifetime', 0, 600.00);

-- ── Sample Payment Methods ────────────────────────────────────────────────────
INSERT IGNORE INTO `payment_methods` (`id`, `bank_name`, `account_name`, `account_number`) VALUES
(1, 'EasyPaisa',  'Assignment Work Zone', '03001234567'),
(2, 'JazzCash',   'Assignment Work Zone', '03001234567'),
(3, 'Bank Transfer (HBL)', 'Muhammad Ali', '01234567890123');

-- ── Sample Withdraw Methods ───────────────────────────────────────────────────
INSERT IGNORE INTO `withdraw_methods` (`id`, `bank_name`, `account_name`, `account_number`) VALUES
(1, 'EasyPaisa',  'Enter your account title', 'Enter your 11-digit number'),
(2, 'JazzCash',   'Enter your account title', 'Enter your 11-digit number'),
(3, 'Bank Transfer', 'Enter your bank account title', 'Enter your IBAN / account number');