FairPropReviewer Platform 📊

A modern prop firm review platform where users can share experiences, earn points, and redeem them to purchase funded accounts.

Project Overview

FairPropReviewer is a web application designed for traders to explore, review, and compare proprietary trading firms. Users can submit detailed reviews, rate prop firms, and earn reward points that can be redeemed for discounted or full account access. I was hired to revamp the UI and enhance backend functionalities to support review submissions and a custom gamified reward system.

Core Features

1. Prop Firm Reviews

• Detailed firm listings with ratings and comparisons
• Real user-submitted reviews and feedback
• Search and filter by firm name, reputation, or features

2. User Review & Point System

• Authenticated users can post reviews
• Each approved review grants reward points
• Points can be tracked in the user dashboard

3. Point Redemption for Accounts

• Users redeem points to purchase prop firm accounts
• Account tiers available based on accumulated points
• Integrated purchase flow with optional top-up

4. Redesigned Frontend (Blade + TailwindCSS)

• Clean and responsive user interface
• Intuitive review submission experience
• Enhanced admin dashboard for review moderation

5. Backend Logic Updates

• Points logic integrated into review approval system
• Admin tools for managing users, firms, and redemptions
• Optimized DB structure and validation logic

Technical Implementation

Database Schema Highlights

-- Reviews table
CREATE TABLE reviews (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  user_id BIGINT,
  firm_id BIGINT,
  content TEXT NOT NULL,
  rating INT CHECK (rating BETWEEN 1 AND 5),
  status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
  FOREIGN KEY (user_id) REFERENCES users(id),
  FOREIGN KEY (firm_id) REFERENCES prop_firms(id)
);

-- User Points table
CREATE TABLE user_points (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  user_id BIGINT,
  points INT DEFAULT 0,
  FOREIGN KEY (user_id) REFERENCES users(id)
);