============================================
FILES TO UPLOAD TO CPANEL FOR PIN SYSTEM
============================================

STEP 1: RUN SQL FIRST
======================
File: add_pin_column.sql
Location: Root directory
Action: Open in phpMyAdmin and run the SQL


STEP 2: UPLOAD NEW FILES
=========================
1. core/app/Http/Controllers/User/Auth/PinController.php
2. core/resources/views/templates/crystal_sky/user/auth/pin_verify.blade.php
3. core/resources/views/templates/crystal_sky/user/auth/pin_setup.blade.php
4. core/resources/views/templates/crystal_sky/user/auth/pin_change.blade.php
5. core/resources/views/admin/users/set_pin.blade.php


STEP 3: REPLACE EXISTING FILES
===============================
1. core/app/Http/Controllers/User/Auth/LoginController.php
2. core/app/Http/Controllers/Admin/ManageUsersController.php
3. core/resources/views/admin/users/detail.blade.php
4. core/routes/user.php
5. core/routes/admin.php


UPLOAD PATH ON SERVER
=====================
All files go to: /home/wessssyz/bank.wessextrustint.org/

Example:
- PinController.php goes to: 
  /home/wessssyz/bank.wessextrustint.org/core/app/Http/Controllers/User/Auth/PinController.php

- pin_verify.blade.php goes to:
  /home/wessssyz/bank.wessextrustint.org/core/resources/views/templates/crystal_sky/user/auth/pin_verify.blade.php


IMPORTANT NOTES
===============
1. BACKUP existing files before replacing them
2. Run the SQL migration FIRST before uploading code files
3. After upload, delete test-db.php and disable-recaptcha.php if still present
4. Test the login flow with a test user account


VERIFICATION CHECKLIST
======================
☐ SQL migration ran successfully (check in phpMyAdmin - users table should have 'pin' and 'pin_set' columns)
☐ All new files uploaded to correct locations
☐ All modified files replaced
☐ Test user login → should ask for PIN setup
☐ Admin can see PIN status in user detail page
☐ Admin can set/reset user PIN


QUICK TEST
==========
1. Try to login with any user account
2. After password, should see PIN verification or PIN setup page
3. If you see this, the system is working!
