Training & Development - recovered Investigator Field Guide

Open Training & Development > Investigator Field Guide in the left menu.
Available to Administrators, Case Managers and Investigators. Clients and
Accounting users cannot access the page, forms or guide downloads.

Content recovered from the original Cases seven-part backup:
- 32 original field guide topics, with the original wording and reading links.
- 23 original YouTube references in their original topic categories.
- Eight original blank field forms and fictional sample reports.
- Topic search, Add/Edit guide, editable reading/video links, file uploads,
  file title/description editing, administrator Delete, Print/Save PDF and
  editable Word downloads.

Administrators and Case Managers can add/edit and upload. Only Administrators
can delete guides/files. Investigators have read/download access. Deletion uses
the shared Confirm Delete/Cancel dialog. Published edits are stored in the
existing settings table; this patch requires no database upgrade.

Guide uploads accept the original PDF, DOC/DOCX, TXT, CSV, XLSX, PPTX and image
formats, at most 15 MB each and 30 files per guide. Files are stored privately
on the server and mirrored to the configured Dropbox folder when connected.
Verified Dropbox transfers appear as Dropbox; failed transfers retain the
server copy and offer Retry Dropbox upload. Full system backups include the
private training files. The existing case records are not imported or changed.

Recovery limitation:
Both the supplied MySQL export and the newest SQL backup inside Cases.zip
(October 11, 2026) contained no rows in the guide override/file tables. The
separate legacy Surveillance Training, SIU Training, Social Media Training and
Pretext Training pages were not present in either database or recovered source.
No missing pages or attachments were invented. A current original-site backup
is needed to recover any additional live-only pages, edits or uploaded files.
External video/link availability has not been verified against the providers.

PATCH INSTALLATION (existing GIB installation):
1. Take a full system backup.
2. Extract the patch into the existing application root, overwriting its named
   files and keeping the app/training and assets subdirectories.
3. Reload the page. Training & Development appears beneath Field Operations.
   Check using an administrator, case manager and investigator account.
Use the full installers only for a fresh installation; they include this patch.

Validation: PHP 8.3 parsing, persistent guide create/edit/delete tests, CSRF,
role restrictions and stale-edit checks; 72 mobile/tablet/desktop layout and
topic-search checks. Original topic/template data compared byte-for-byte.
Live MySQL, Dropbox transfer, external playback and production installation
have not been exercised in this environment.
