Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2025-09-15 16:52
DB	[ DIR ]	drwxr-xr-x	2024-01-26 18:47
Documentation	[ DIR ]	drwxr-xr-x	2025-08-31 15:59
Documentation.1	[ DIR ]	drwxr-xr-x	2025-10-30 18:23
FASTEARNADS	[ DIR ]	drwxr-xr-x	2025-09-15 19:14
Files	[ DIR ]	drwxr-xr-x	2025-10-30 18:23
admin	[ DIR ]	drwxr-xr-x	2025-10-18 00:49
admin.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
admin.2	[ DIR ]	drwxr-xr-x	2025-10-18 21:54
app	[ DIR ]	drwxr-xr-x	2025-09-15 01:54
asset	[ DIR ]	drwxr-xr-x	2024-01-15 11:35
assets	[ DIR ]	drwxr--r--	2025-10-18 01:49
assets.1	[ DIR ]	drwxr--r--	2025-10-18 02:06
assets.2	[ DIR ]	drwxr-xr-x	2025-10-17 23:09
assets.3	[ DIR ]	drwxr--r--	2025-10-18 02:13
assets.4	[ DIR ]	drwxr-xr-x	2025-10-18 21:42
bootstrap	[ DIR ]	drwxr-xr-x	2025-09-15 21:09
cgi-bin	[ DIR ]	drwxr-xr-x	2025-08-31 15:33
cgi-bin.1	[ DIR ]	drwxr-xr-x	2025-11-14 14:25
cgi-bin.2	[ DIR ]	drwxr-xr-x	2026-03-06 11:21
core	[ DIR ]	drwxr-xr-x	2025-11-21 11:34
core.1	[ DIR ]	drwxr-xr-x	2025-11-21 15:51
data sycho	[ DIR ]	drwxr-xr-x	2026-03-18 10:25
database	[ DIR ]	drwxr-xr-x	2025-09-15 01:47
db	[ DIR ]	drwxr-xr-x	2025-10-17 23:00
db.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
debug.php	[ DIR ]	drwxr-xr-x	2026-03-13 16:15
deployment_package	[ DIR ]	drwxr-xr-x	2025-10-18 02:05
deployment_package.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
earnonline	[ DIR ]	drwxr-xr-x	2025-10-18 17:55
includes	[ DIR ]	drwxr-xr-x	2025-10-17 21:12
includes.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
includes.2	[ DIR ]	drwxr-xr-x	2025-10-18 21:40
loading	[ DIR ]	drwxr-xr-x	2025-01-23 07:37
public	[ DIR ]	drwxr-xr-x	2025-09-15 19:19
resources	[ DIR ]	drwxr-xr-x	2025-09-15 01:28
routes	[ DIR ]	drwxr-xr-x	2025-09-15 21:08
serive	[ DIR ]	drwxr-xr-x	2024-10-22 19:23
shearearn	[ DIR ]	drwxr-xr-x	2025-10-17 21:12
storage	[ DIR ]	drwxr-xr-x	2025-09-15 01:56
uploads	[ DIR ]	drwxr--r--	2025-10-18 01:49
uploads.1	[ DIR ]	drwxr--r--	2025-10-18 02:06
uploads.2	[ DIR ]	drwxr-xr-x	2025-10-17 23:08
uploads.3	[ DIR ]	drwxr--r--	2025-10-18 02:13
user	[ DIR ]	drwxr-xr-x	2025-10-17 23:42
user.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
user.2	[ DIR ]	drwxr-xr-x	2025-10-18 22:14
vendor	[ DIR ]	drwxr-xr-x	2025-09-15 01:53
.env	1.2 KB	-rw-r--r--	2025-09-15 19:24
.env.example	1.19 KB	-rw-r--r--	2025-09-15 01:27
.htaccess	281 B	-rw-r--r--	2025-09-15 16:51
.htaccess.1	1.08 KB	-rw-r--r--	2025-10-18 21:45
.htaccess.2	913 B	-rw-r--r--	2023-12-27 04:45
.htaccess.3	281 B	-rw-r--r--	2025-12-23 09:40
.htaccess.4	1.38 KB	-rw-r--r--	2025-12-23 09:40
.htaccess.5	812 B	-rw-r--r--	2025-12-23 09:40
.htaccess.6	281 B	-rw-r--r--	2026-02-22 15:25
.htaccess.7	5.15 KB	-rw-r--r--	2025-12-23 09:40
.htaccess.8	1.02 KB	-rw-r--r--	2025-12-23 09:40
.htaccess.9	281 B	-rw-r--r--	2025-12-23 09:40
.trash_restore	11.24 KB	-rw-------	2026-03-30 15:07
.well-known_2.zip	66.1 MB	-rw-r--r--	2025-07-10 15:10
.well-known_3.zip	69.98 MB	-rw-r--r--	2025-07-18 07:02
6clube by Tha_perfect_provider (1).zip	67.84 MB	-rw-r--r--	2025-11-21 12:25
DEPLOYMENT_INSTRUCTIONS.md	3.05 KB	-rw-r--r--	2025-10-18 01:48
FASTEARNADS.zip	26.04 MB	-rw-r--r--	2025-09-15 19:10
FIX_DUPLICATE_COMMISSIONS.md	3.63 KB	-rw-r--r--	2025-10-18 00:32
FIX_DUPLICATE_COMMISSIONS.md.1	3.63 KB	-rw-r--r--	2025-10-18 00:32
FIX_USER_EDIT_ISSUE.md	6.15 KB	-rw-r--r--	2025-10-18 00:44
FIX_USER_EDIT_ISSUE.md.1	6.15 KB	-rw-r--r--	2025-10-18 00:44
Hyipe rio_2.zip	56.84 MB	-rw-r--r--	2025-08-31 15:56
IMPROVEMENTS_SUMMARY.md	4.11 KB	-rw-r--r--	2025-10-18 00:40
IMPROVEMENTS_SUMMARY.md.1	4.11 KB	-rw-r--r--	2025-10-18 00:40
MRby91club.sql	32.58 MB	-rw-r--r--	2025-11-09 05:09
MRby91club.zip	58.89 MB	-rw-r--r--	2025-11-09 05:09
PropLab v1.0 Nulled.zip	67.55 MB	-rw-r--r--	2025-11-21 11:36
README.md	6.77 KB	-rw-r--r--	2025-09-15 01:24
README.md.1	3.01 KB	-rw-r--r--	2025-10-18 21:46
README.txt	2.34 KB	-rw-r--r--	2025-10-17 23:08
README.txt.1	2.34 KB	-rw-r--r--	2025-10-17 23:08
README_DEPLOYMENT.txt	1.74 KB	-rw-r--r--	2025-10-18 01:49
README_REFERRAL_COMMISSIONS.md	4.02 KB	-rw-r--r--	2025-10-18 00:22
README_REFERRAL_COMMISSIONS.md.1	4.02 KB	-rw-r--r--	2025-10-18 00:22
SQL_CHANGES_SUMMARY.md	2.02 KB	-rw-r--r--	2025-10-18 00:25
SQL_CHANGES_SUMMARY.md.1	2.02 KB	-rw-r--r--	2025-10-18 00:25
Vinance-Digital-Trading-Platform-V2.7[www.shop.softbdteam.com].zip	39.3 MB	-rw-r--r--	2025-11-28 16:01
apply_database_fixes.php	5.17 KB	-rw-r--r--	2025-10-18 00:39
apply_database_fixes.php.1	5.17 KB	-rw-r--r--	2025-10-18 00:39
artisan	1.7 KB	-rw-r--r--	2025-09-15 01:54
check_commission_levels.php	3.16 KB	-rw-r--r--	2025-10-18 00:53
check_commission_levels.php.1	3.16 KB	-rw-r--r--	2025-10-18 00:53
check_database_structure.php	3.9 KB	-rw-r--r--	2025-10-18 00:55
check_database_structure.php.1	3.9 KB	-rw-r--r--	2025-10-18 00:55
check_duplicate_commissions.php	4.38 KB	-rw-r--r--	2025-10-18 00:32
check_duplicate_commissions.php.1	4.38 KB	-rw-r--r--	2025-10-18 00:32
check_referrals_table.php	2.28 KB	-rw-r--r--	2025-10-18 00:39
check_referrals_table.php.1	2.28 KB	-rw-r--r--	2025-10-18 00:39
complete_setup.sql	5.34 KB	-rw-r--r--	2025-10-18 00:25
complete_setup.sql.1	5.34 KB	-rw-r--r--	2025-10-18 00:25
complete_setup_for_import.sql	5.36 KB	-rw-r--r--	2025-10-18 01:59
complete_setup_for_import.sql.1	5.36 KB	-rw-r--r--	2025-10-18 01:59
composer.json	1.83 KB	-rw-r--r--	2025-09-15 01:27
composer.lock	294.45 KB	-rw-r--r--	2025-09-15 01:52
config.php	2.63 KB	-rw-r--r--	2025-10-18 17:56
crazydeveloperbd_auto-ptc.sql	320.06 KB	-rw-r--r--	2025-02-03 11:56
crazydeveloperbd_auto-ptc.sql.1	320.06 KB	-rw-r--r--	2025-02-03 11:56
create_table_direct.php	3.44 KB	-rw-r--r--	2025-10-18 00:09
create_table_direct.php.1	3.44 KB	-rw-r--r--	2025-10-18 00:09
css_test.php	999 B	-rw-r--r--	2025-10-18 02:06
data sycho.1	0 B	-rw-r--r--	2026-03-18 10:25
database.sql	13.77 KB	-rw-r--r--	2025-10-18 22:24
debug_referral_chain.php	6.88 KB	-rw-r--r--	2025-10-18 00:54
debug_referral_chain.php.1	6.88 KB	-rw-r--r--	2025-10-18 00:54
demo-enhanced.html	45.46 KB	-rw-r--r--	2025-09-15 01:43
earnonline.zip	88.67 KB	-rw-r--r--	2025-10-18 17:55
error.php	3.84 KB	-rw-r--r--	2025-10-18 21:45
error_log	488 B	-rw-r--r--	2025-07-04 21:02
error_log.1	37.29 KB	-rw-r--r--	2025-11-21 16:03
favicon.png	2.71 KB	-rw-r--r--	2025-06-07 20:15
favicon.png.1	6.62 KB	-rw-r--r--	2022-08-31 22:45
favicon.png.2	50.48 KB	-rw-r--r--	2025-07-18 10:14
favicon.png.3	2.21 KB	-rw-r--r--	2025-07-18 10:19
fix_css_paths.bat	1.85 KB	-rw-r--r--	2025-10-18 02:06
fix_duplicate_commissions.php	2.67 KB	-rw-r--r--	2025-10-18 00:31
fix_duplicate_commissions.php.1	2.67 KB	-rw-r--r--	2025-10-18 00:31
fix_referral_commissions.sql	677 B	-rw-r--r--	2025-10-18 00:25
fix_referral_commissions.sql.1	677 B	-rw-r--r--	2025-10-18 00:25
fix_referral_commissions_for_import.sql	705 B	-rw-r--r--	2025-10-18 01:59
fix_referral_commissions_for_import.sql.1	705 B	-rw-r--r--	2025-10-18 01:59
index-8df9a8d8.js	1.09 MB	-rw-r--r--	2026-03-18 15:16
index.php	25.73 KB	-rw-r--r--	2025-10-18 01:40
index.php.1	26.17 KB	-rw-r--r--	2025-10-18 02:11
index.php.2	23.31 KB	-rw-r--r--	2025-10-18 22:32
index.php.3	1.77 KB	-rw-r--r--	2023-12-27 04:45
index.php.backup	25.74 KB	-rw-r--r--	2025-10-18 02:05
index_professional.php	26.17 KB	-rw-r--r--	2025-10-18 02:12
index_with_css_fix.php	25.82 KB	-rw-r--r--	2025-10-18 02:06
login.php	4.14 KB	-rw-r--r--	2025-10-17 23:09
login.php.1	4.15 KB	-rw-r--r--	2025-10-18 02:12
logo.png	18.18 KB	-rw-r--r--	2025-06-07 20:15
logo.png.1	46.68 KB	-rw-r--r--	2025-07-18 10:12
logo.png.2	46.68 KB	-rw-r--r--	2025-07-18 10:11
logo.png.3	920.77 KB	-rw-r--r--	2023-07-01 15:03
logout.php	88 B	-rw-r--r--	2025-10-17 23:02
logout.php.1	88 B	-rw-r--r--	2025-10-17 23:02
mailer.php	10.16 KB	-rw-r--r--	2026-03-30 14:45
mobile-demo.html	23.36 KB	-rw-r--r--	2025-09-15 01:32
register.php	6.57 KB	-rw-r--r--	2025-10-17 23:09
register.php.1	6.58 KB	-rw-r--r--	2025-10-18 02:12
run_setup.bat	714 B	-rw-r--r--	2025-10-18 00:23
run_setup.bat.1	714 B	-rw-r--r--	2025-10-18 00:23
servertime.php	128 B	-rw-r--r--	2024-09-27 12:16
setup_referral_commissions.php	2.73 KB	-rw-r--r--	2025-10-18 00:21
setup_referral_commissions.php.1	2.73 KB	-rw-r--r--	2025-10-18 00:21
shearearn.zip	3.2 MB	-rw-r--r--	2025-10-17 21:11
test.html	203 B	-rw-r--r--	2025-10-17 23:16
test.php	59 B	-rw-r--r--	2025-10-17 23:16
test.php.1	59 B	-rw-r--r--	2025-10-17 23:16
test_commission_application.php	6.93 KB	-rw-r--r--	2025-10-18 00:55
test_commission_application.php.1	6.93 KB	-rw-r--r--	2025-10-18 00:55
test_commission_display.php	3.26 KB	-rw-r--r--	2025-10-18 00:19
test_commission_display.php.1	3.26 KB	-rw-r--r--	2025-10-18 00:19
test_commission_fix.php	3.16 KB	-rw-r--r--	2025-10-18 00:39
test_commission_fix.php.1	3.16 KB	-rw-r--r--	2025-10-18 00:39
test_mobile_menu.php	2.73 KB	-rw-r--r--	2025-10-18 01:24
test_mobile_menu.php.1	2.73 KB	-rw-r--r--	2025-10-18 01:24
test_referral.php	2.07 KB	-rw-r--r--	2025-10-17 23:55
test_referral.php.1	2.07 KB	-rw-r--r--	2025-10-17 23:55
tradex (1).sql	189.14 KB	-rw-r--r--	2025-11-21 15:51
update_referral_commissions.sql	682 B	-rw-r--r--	2025-10-18 00:25
update_referral_commissions.sql.1	682 B	-rw-r--r--	2025-10-18 00:25
update_referral_commissions_for_import.sql	710 B	-rw-r--r--	2025-10-18 01:59
update_referral_commissions_for_import.sql.1	710 B	-rw-r--r--	2025-10-18 01:59
update_referrals_table.sql	398 B	-rw-r--r--	2025-10-18 00:31
update_referrals_table.sql.1	398 B	-rw-r--r--	2025-10-18 00:31
update_referrals_table_for_import.sql	426 B	-rw-r--r--	2025-10-18 01:59
update_referrals_table_for_import.sql.1	426 B	-rw-r--r--	2025-10-18 01:59
verify-code.php	8.79 KB	-rw-r--r--	2026-03-30 14:55
verify_commissions.php	3.28 KB	-rw-r--r--	2025-10-18 00:20
verify_commissions.php.1	3.28 KB	-rw-r--r--	2025-10-18 00:20
verify_commissions_working.php	8.2 KB	-rw-r--r--	2025-10-18 00:56
verify_commissions_working.php.1	8.2 KB	-rw-r--r--	2025-10-18 00:56
website_deployment_package.zip	648.91 KB	-rw-r--r--	2025-10-18 01:49
website_deployment_package_final.zip	657.48 KB	-rw-r--r--	2025-10-18 02:06
website_deployment_package_professional.zip	667.46 KB	-rw-r--r--	2025-10-17 21:14
website_deployment_package_updated.zip	653.07 KB	-rw-r--r--	2025-10-18 01:59

Rename

-- Share & Earn Database Setup
CREATE DATABASE IF NOT EXISTS shareearn;
USE shareearn;

-- Drop existing tables if needed (for fresh setup)
DROP TABLE IF EXISTS referrals;
DROP TABLE IF EXISTS referral_commissions;
DROP TABLE IF EXISTS transactions;
DROP TABLE IF EXISTS ads;
DROP TABLE IF EXISTS dpins;
DROP TABLE IF EXISTS withdraws;
DROP TABLE IF EXISTS deposits;
DROP TABLE IF EXISTS methods;
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS plans;

-- Create all tables
CREATE TABLE plans (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    duration INT NOT NULL,
    daily_ads INT NOT NULL,
    per_ad_earning DECIMAL(10, 2) NOT NULL,
    status ENUM('active', 'inactive') DEFAULT 'active'
);

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    fullname VARCHAR(100) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    phone VARCHAR(20),
    password VARCHAR(255) NOT NULL,
    referral_code VARCHAR(50) UNIQUE NOT NULL,
    referred_by INT DEFAULT NULL,
    joined_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    balance DECIMAL(10, 2) DEFAULT 0.00,
    current_plan INT DEFAULT NULL,
    FOREIGN KEY (referred_by) REFERENCES users(id),
    FOREIGN KEY (current_plan) REFERENCES plans(id)
);

CREATE TABLE deposits (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    amount DECIMAL(10, 2) NOT NULL,
    method VARCHAR(50) NOT NULL,
    receipt VARCHAR(255),
    status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

CREATE TABLE withdraws (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    method VARCHAR(50) NOT NULL,
    amount DECIMAL(10, 2) NOT NULL,
    status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

CREATE TABLE dpins (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    pin_code VARCHAR(50) UNIQUE NOT NULL,
    status ENUM('active', 'used', 'expired') DEFAULT 'active',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    used_at TIMESTAMP NULL,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

CREATE TABLE ads (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    link TEXT NOT NULL,
    description TEXT,
    reward DECIMAL(10, 2) NOT NULL,
    duration INT NOT NULL,
    status ENUM('active', 'inactive') DEFAULT 'active'
);

CREATE TABLE transactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    type ENUM('deposit', 'withdraw', 'commission', 'ad') NOT NULL,
    amount DECIMAL(10, 2) NOT NULL,
    note TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

CREATE TABLE referrals (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    referred_user_id INT NOT NULL,
    level INT NOT NULL,
    commission_amount DECIMAL(10, 2) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id),
    FOREIGN KEY (referred_user_id) REFERENCES users(id)
);

CREATE TABLE methods (
    id INT AUTO_INCREMENT PRIMARY KEY,
    type ENUM('deposit', 'withdraw') NOT NULL,
    name VARCHAR(100) NOT NULL,
    account_number VARCHAR(100),
    holder_name VARCHAR(100),
    instructions TEXT
);

CREATE TABLE referral_commissions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    level INT NOT NULL UNIQUE,
    commission_percentage DECIMAL(5, 2) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- Insert sample data
INSERT INTO plans (name, price, duration, daily_ads, per_ad_earning) VALUES
('Basic Plan', 500.00, 30, 10, 2.00),
('Premium Plan', 1000.00, 30, 20, 3.00),
('VIP Plan', 2000.00, 30, 30, 5.00);

INSERT INTO methods (type, name, account_number, holder_name, instructions) VALUES
('deposit', 'Easypaisa', '03001234567', 'Share & Earn', 'Send money to this Easypaisa account and upload screenshot'),
('deposit', 'JazzCash', '03211234567', 'Share & Earn', 'Send money to this JazzCash account and upload screenshot'),
('deposit', 'Bank Transfer', '1234567890123456', 'Share & Earn', 'Transfer to this bank account and upload receipt'),
('withdraw', 'Easypaisa', '03001234567', 'Enter your Easypaisa number', 'Enter your Easypaisa number where you want to receive money'),
('withdraw', 'JazzCash', '03211234567', 'Enter your JazzCash number', 'Enter your JazzCash number where you want to receive money'),
('withdraw', 'Bank Transfer', 'Provide your bank details', 'Provide your bank account details', 'Provide your complete bank account details');

INSERT INTO ads (title, link, description, reward, duration) VALUES
('Watch Our Product Video', 'https://www.youtube.com/watch?v=dQw4w9WgXcQ', 'Watch this 30-second video to earn rewards', 2.00, 30),
('Visit Our Website', 'https://www.example.com', 'Visit our website and spend 45 seconds browsing', 3.00, 45),
('Try Our New Feature', 'https://www.example.com/new-feature', 'Try our new feature for 60 seconds', 5.00, 60);

INSERT INTO referral_commissions (level, commission_percentage) VALUES
(1, 10.00),
(2, 5.00),
(3, 2.00);