Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
data	[ DIR ]	drwxr-xr-x	2025-09-15 23:22
uploads	[ DIR ]	drwxr-xr-x	2025-09-15 18:00
COMPLETE_SETUP_GUIDE.md	5.02 KB	-rw-r--r--	2025-09-15 23:45
DATABASE_SETUP.md	2.84 KB	-rw-r--r--	2025-09-15 23:41
FIX_ACCESS_DENIED.md	2.36 KB	-rw-r--r--	2025-09-16 00:07
MIGRATION_SUMMARY.md	4.28 KB	-rw-r--r--	2025-09-15 23:45
NEXT_STEPS.md	2.18 KB	-rw-r--r--	2025-09-15 23:45
PHPMYADMIN_SETUP_GUIDE.md	3.61 KB	-rw-r--r--	2025-09-15 23:43
QUICK_FIX_INSTRUCTIONS.md	1.99 KB	-rw-r--r--	2025-09-16 00:09
admin-dashboard.html	25.26 KB	-rw-r--r--	2025-09-15 17:29
admin-login.html	5.25 KB	-rw-r--r--	2025-09-15 02:24
admin-profile.html	24.21 KB	-rw-r--r--	2025-09-15 17:43
analytics.html	25.08 KB	-rw-r--r--	2025-09-15 16:13
check_mysql.php	1.33 KB	-rw-r--r--	2025-09-15 23:44
cleanup_duplicates.php	1.46 KB	-rw-r--r--	2025-09-15 23:08
complete_workflow_test.php	4.46 KB	-rw-r--r--	2025-09-15 23:22
create_test_user.php	1.15 KB	-rw-r--r--	2025-09-15 23:20
database.php	4.29 KB	-rw-r--r--	2025-09-15 23:43
database_mysql.php	9.98 KB	-rw-r--r--	2025-09-16 00:08
db_config.php	587 B	-rw-r--r--	2025-09-16 00:07
demo-enhanced.html	45.46 KB	-rw-r--r--	2025-09-15 01:43
deposit.html	10.83 KB	-rw-r--r--	2025-09-15 17:08
error_log	825 B	-rw-r--r--	2025-10-04 15:48
fastearnads.sql	6.12 KB	-rw-r--r--	2025-09-15 23:39
fastearnads_tables_only.sql	5.96 KB	-rw-r--r--	2025-09-16 00:07
final_test.php	4.73 KB	-rw-r--r--	2025-09-15 23:29
import_database.bat	1.03 KB	-rw-r--r--	2025-09-15 23:45
index.php	50.11 KB	-rw-r--r--	2025-09-15 23:40
manage-ads.html	25.39 KB	-rw-r--r--	2025-09-15 16:12
manage-users.html	42.4 KB	-rw-r--r--	2025-09-15 16:54
manage-withdraws.html	49.19 KB	-rw-r--r--	2025-09-15 15:54
migrate_data.php	1.6 KB	-rw-r--r--	2025-09-15 23:40
simple-login.html	1.19 KB	-rw-r--r--	2025-09-15 02:08
start_mysql.bat	948 B	-rw-r--r--	2025-09-15 23:45
test_admin_approval.php	3.55 KB	-rw-r--r--	2025-09-15 23:21
test_connection_with_user.php	1.9 KB	-rw-r--r--	2025-09-15 19:19
test_db_connection.php	1.54 KB	-rw-r--r--	2025-09-15 23:41
test_deposit_fix.php	2.88 KB	-rw-r--r--	2025-09-15 23:09
test_frontend.html	3.49 KB	-rw-r--r--	2025-09-15 23:22
test_user_activity_history.php	2.96 KB	-rw-r--r--	2025-09-15 23:21
user-ads.html	18.36 KB	-rw-r--r--	2025-09-15 14:39
user-dashboard.html	47.77 KB	-rw-r--r--	2025-09-15 23:26
user-login.html	5.78 KB	-rw-r--r--	2025-09-15 02:27
user-profile.html	33.93 KB	-rw-r--r--	2025-09-15 18:33
user-register.html	7.56 KB	-rw-r--r--	2025-09-15 02:27
user-transactions.html	31.83 KB	-rw-r--r--	2025-09-15 22:58
user-withdraw.html	29.48 KB	-rw-r--r--	2025-09-15 21:52
user-withdrawals.html	29.17 KB	-rw-r--r--	2025-09-15 21:51
waiting-approval.html	5.46 KB	-rw-r--r--	2025-09-15 03:23

Rename

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Sep 15, 2025 at 06:30 PM
-- Server version: 8.0.30
-- PHP Version: 8.1.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL UNIQUE,
  `phone` varchar(20) NOT NULL,
  `password` varchar(255) NOT NULL,
  `deposit_status` enum('pending','waiting','approved','rejected') DEFAULT 'pending',
  `balance` decimal(10,2) DEFAULT 0.00,
  `ads_watched` int DEFAULT 0,
  `total_earned` decimal(10,2) DEFAULT 0.00,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` varchar(255) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `notes` text,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `user_activities`
--

CREATE TABLE `user_activities` (
  `id` varchar(255) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `description` text,
  `amount` decimal(10,2) DEFAULT NULL,
  `plan_name` varchar(255) DEFAULT NULL,
  `plan_amount_pkr` decimal(10,2) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `category` varchar(100) NOT NULL,
  `duration` int DEFAULT 30,
  `reward` decimal(10,2) DEFAULT 0.05,
  `status` enum('active','inactive') DEFAULT 'active',
  `url` text NOT NULL,
  `description` text,
  `views` int DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `withdraws`
--

CREATE TABLE `withdraws` (
  `id` varchar(255) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `user_balance` decimal(10,2) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` varchar(100) DEFAULT NULL,
  `account_details` text,
  `notes` text,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `rejection_reason` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `approved_at` datetime DEFAULT NULL,
  `rejected_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `withdraw_methods`
--

CREATE TABLE `withdraw_methods` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `enabled` tinyint(1) DEFAULT 0,
  `accountDetails` text,
  `processingTime` varchar(100) DEFAULT NULL,
  `minAmount` decimal(10,2) DEFAULT 5.00,
  `instructions` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `user_withdraw_permissions`
--

CREATE TABLE `user_withdraw_permissions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `withdraw_enabled` tinyint(1) DEFAULT 0,
  `enabled_methods` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` varchar(255) NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `admin_activities`
--

CREATE TABLE `admin_activities` (
  `id` varchar(255) NOT NULL,
  `admin_email` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `description` text,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_email` (`user_email`);

--
-- Indexes for table `user_activities`
--
ALTER TABLE `user_activities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_email` (`user_email`),
  ADD KEY `type` (`type`);

--
-- Indexes for table `ads`
--
ALTER TABLE `ads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `withdraws`
--
ALTER TABLE `withdraws`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_email` (`user_email`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `key` (`key`);

--
-- Indexes for table `admin_activities`
--
ALTER TABLE `admin_activities`
  ADD PRIMARY KEY (`id`);
COMMIT;