Launch Readiness
Final checks before sending traffic to the course.
✅ Student flow
Locked lesson sequence, quiz gate, final candlestick lesson, and certificate unlock are active.
🔐 Approval gate
New students stay pending until an admin approves their account from Student Approvals.
⚠️ Supabase
Local mode works for testing. Connect Supabase before a full paid launch for secure cloud accounts.
🏆 Certificate
One certificate per learner is enforced locally and Supabase-ready for database-level protection.
📱 Mobile check
Test at least one iPhone and one Android screen before launch.
Student Approvals
Approve new students before they can access the course. Suspended or pending students are blocked at login.
| Name | Role | Created | Status | Action |
|---|
Certificates
Track issued certificates and prevent duplicate certificate attempts.
| Student | Email / Learner ID | Certificate ID | Issued | Status |
|---|
Course Control
Use these controls while testing. Do not expose reset controls to students.
Reset local progress
Clears progress on this device for testing the student flow from scratch.
Clear local certificate
Removes the certificate record on this device. Use only during testing.
Unlock all lessons
Marks all lessons complete for preview/testing only.
Supabase Setup Status
Replace the placeholders in login.html, admin.html, and the course file when ready.
Authentication
Checking...
Admin Security
For live use, admin access should be controlled by the profiles.role = admin value in Supabase.
Certificate Security
Add the SQL file included with this package so each user can only have one certificate per course.
Recommended Database Tables
Use the included SQL file when setting up Supabase.
| Table | Purpose | Protection |
|---|---|---|
| profiles | Stores name, email, role, and profile details. | RLS by user ID, admin can read all. |
| course_progress | Stores completed sections and progress percentage. | Unique user + course record. |
| certificates | Stores issued certificate IDs. | Unique user + course, prevents duplicates. |