✅ Database connection successful
✅ Table 'users' exists
✅ Table 'divisions' exists
✅ Table 'application_forms' exists
✅ Table 'international_exhibition_data' exists
✅ Table 'regional_offices_data' exists
✅ Table 'work_submissions' exists
✅ Table 'activity_logs' exists
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int | NO | PRI | auto_increment | |
| varchar(255) | NO | UNI | |||
| password | varchar(255) | NO | |||
| role | enum('Super Admin','Admin','Division Role','Moderator') | NO | |||
| full_name | varchar(255) | NO | |||
| division_id | int | YES | MUL | ||
| created_at | timestamp | YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED | |
| last_login | timestamp | YES | |||
| is_active | tinyint(1) | YES | 1 |
Total users: 12
| ID | Role | Name | Division | Active | Password Hash | |
|---|---|---|---|---|---|---|
| 1 | [email protected] | Super Admin | Super Administrator | NULL | Yes | 60 chars |
| 2 | [email protected] | Admin | Administrator | NULL | Yes | 60 chars |
| 3 | [email protected] | Moderator | Content Moderator | NULL | Yes | 60 chars |
| 4 | [email protected] | Division Role | Textile Manager | 1 | Yes | 60 chars |
| 5 | [email protected] | Division Role | Engineering Manager | 2 | Yes | 60 chars |
| 6 | [email protected] | Division Role | Agro Manager | 3 | Yes | 60 chars |
| 7 | [email protected] | Division Role | Service Manager | 4 | Yes | 60 chars |
| 8 | [email protected] | Division Role | IMDD Manager | 5 | Yes | 60 chars |
| 9 | [email protected] | Division Role | WE Manager | 6 | Yes | 60 chars |
| 10 | [email protected] | Admin | Secondary Admin | NULL | Yes | 60 chars |
| 11 | [email protected] | Division Role | Division Lead | NULL | Yes | 60 chars |
| 12 | [email protected] | Moderator | Content Reviewer | NULL | Yes | 60 chars |
Total divisions: 6
| ID | Name | Code | Description |
|---|---|---|---|
| 1 | Textile | TXT | Textile and Fashion Division |
| 2 | Engineering | ENG | Engineering and Technology Division |
| 3 | Agro | AGRO | Agriculture and Food Division |
| 4 | Service | SVC | Service Industry Division |
| 5 | IMDD | IMDD | International Marketing and Development Division |
| 6 | WE | WE | Women Empowerment Division |
✅ User found: Super Administrator
Role: Super Admin
Division ID: NULL
Active: Yes
✅ Password verification successful!
Run: cpanel_setup.php to create sample data
Password hashes might be corrupted. Try:
Import the SQL file manually: