Discord Integration & Point-Based System Development

Project Title: Full-Stack Developer: Advanced Point Economy, Referral System & Discord Role Sync
Project Status

Website & Domain: Ready and live.

Discord Integration: Basic OAuth2 integration is completed.

Job Description & Key Responsibilities

1. Advanced Discord Role Synchronization

The system must read specific user roles from our Discord Server (ID: 1459148252116156428) once the account is connected.

Detected roles must be displayed prominently on the website dashboard.

Fallback Logic: If a user connects their Discord but does not possess a specific premium role, the system must automatically assign the "〢Free Member" tier to their profile.

2. Fully Functional Referral & Point System

Build a robust referral engine where each user has a unique shareable code/link.

Reward Logic: For every successful referral (new user signs up via Discord), the referrer earns 100 points.

Cap: Referral rewards are limited to a maximum of 40 successful invites (Total cap: 4,000 points).

3. Social Media Tasks Module

Develop a "Tasks" section where users can earn points by completing social actions (e.g., following specific social media accounts).

Each successfully verified task must reward the user with 100 points.

4. Point Redemption & Membership Economy

Implement a redemption store where points can be exchanged for:

Membership Rank S (1 Year Access): Cost 5,000 points.

Membership Rank S (2 Months Access): Cost 1,000 points.

20% Discount Voucher: Users can spend 3,000 points to get a 20% discount on any membership package purchase.

5. Backend & Database Optimization (Supabase)

Manage and secure the profiles, points_transactions, and referrals tables in Supabase.

Apply Row Level Security (RLS) and SQL Triggers to ensure point balances cannot be manipulated by users.