User Breakdown
Database Tables
Top Active Users
Sent Mail — Last 7 Days
| Metric | Value | Table |
|---|
Users
—
| ID | Username / Email | Password (LoginPass) | PIN | Status | License Expiry | Send Limit | Reseller | Actions |
|---|
Blocked Addresses
—
| UUID / MAC | Actions |
|---|
Login Activity
—
| Time | User ID | PC / MAC |
|---|
Sent Mail
—
| ID | Sender Gmail | Total Sent | Executed At | User | UniqueID (MAC) |
|---|
System Logs
—
| ID | PC Name | IP | MAC | Version | Time |
|---|
Data Limits
—
| ID | User | Limit | Sent | Used % | Last Updated |
|---|
User History
—
| ID | User | Username | Type | Total | PC Info | Date |
|---|
Activations
—
| Date | Series | Username | Type | Total | Details | Time |
|---|
Reset History—
| ID | User ID | Username | Device Info | Time |
|---|
Data Limit History—
| ID | User | Limit | Sent | Remarks | Backup Time |
|---|
Data Pick Log—
| ID | User | Qty | Created At |
|---|
Test Mails—
| User ID | Username | Actions |
|---|
Email Patterns (Block List)—
| Pattern | Actions |
|---|
Email Subjects—
| Subject Name | Actions |
|---|
sys_license Queue—
| ID | License Key | Expire Days | Status | Execute At | Remarks | Actions |
|---|
OnlyDataList
TFN Info
Batch Manager
নতুন Series Batch তৈরি করুন
Existing Series (Registration table)
| Series | Total | Active ✓ | Inactive (Status=0) | Range | Actions |
|---|---|---|---|---|---|
Loading… | |||||
License Manager
| Series | Total | Active | Available | Action |
|---|---|---|---|---|
| Loading... | ||||
Batch Activate (ActivateUsers)
Prefix দাও, কতজন activate করবে সেটা দাও — password+pin auto generate হবে।
Single Activate (ActivateVerifierUser)
Series থেকে পরবর্তী ১টা user activate করবে + SendLimit set করবে।