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.