Crystal Control
Admin Login
Temporary access for internal review.
Dashboard
Crystal Users
Signed in as admin
Daily Summary
Summary is generated from the selected date start time to the next day end time based on the 5:59 AM KL cutoff.
Loading summary...
User Possesed Crystal
Users from `user_currency` with `country_id = 3` and `currency_type = CRYSTAL`.
Loading data...
| User Currency ID | User ID | Name | UUID | Mobile Number | Thumbnail Preview | Balance | Action |
|---|
Page 1
Admin Settings
Change the shared 4-digit security PIN used for crystal add, minus, and counter topup actions.
Updating PIN...
Online Available Users
Recent Singapore online users from PostgreSQL since the latest 6:00 AM reset, joined to `users` for name, picture, and girls status.
Loading data...
| UID | User Acc | Name | Picture Preview | Crystal | Girls | Last Online | Action |
|---|
Page 1
Girls Listing
PostgreSQL `users` records where `girls = true`.
Loading data...
| Picture Preview | Name | UID | Girls | Last Online | Action |
|---|
Page 1
Fomopay Invoice Listing
PostgreSQL rows from `fomopayinvoice` where `date > 1770307197`, joined to `users` by `uid`.
Loading data...
| FOMO ORDER ID | User ID | Name | Picture Preview | SGD AMOUNT | CRYSTAL GAINED | Date |
|---|
Page 1
GST Topups
Combined topup list from `BGM_GST_TRANS` and Fomo, with a source filter when you want only one side.
Loading data...
| Source | Picture | Name | UID | Crystal Amount | SGD Amount | Reference | Date |
|---|
Page 1
Gift History
PostgreSQL `gifthistory` rows where `type = p2p` and `country = singapore`.
Loading data...
| Gift | Sender Name | Sender UID | Receiver Name | Receiver UID | VCrystal | Date |
|---|
Page 1