ROCKVIEW UNIVERSITY — STUDENT STUDIOS API INTEGRATION

Canonical API base URL
https://intranet.rockviewuniversity.ac/student_slps/api/

WHAT THIS UPDATE CHANGES
- News, Forms, Workspace and Users clients use the independent Student Studios API base and X-Studio-Session token.
- News and Forms management are routed to hr_news.php and hr_forms.php, using the Student Studios database/session helper in this package.
- Workspace supports authenticated Events, Announcements, Surveys, Media and Showcase records, Dashboard/Reports metrics, media uploads/listing/deletion.
- Audit events are written to studio_audit_events.
- Database migration creates workspace and media tables and adds the Forms campus_name compatibility column.
- db_diagnostic.php is excluded from this deployment package.

DEPLOYMENT
1. Back up the current Student Studios backend folder and database first.
2. Keep the existing live config/database.php on the server. This package intentionally does not contain your database password. It must return an array with host, port, database, username, password and optional sslmode. Do not upload a sample config over the live configuration.
3. Upload the contents of student_slps/ into the existing /student_slps/ directory, preserving config/database.php.
4. Run database/student_studios_api_integration.sql against intranetrockview_slps_studio after the original student_studios_schema.sql.
5. Ensure PHP has pdo_pgsql, fileinfo and mbstring enabled.
6. Ensure student_slps/uploads/ is writable by PHP. The supplied .htaccess prevents script execution in uploads.
7. Test login, News bootstrap/get/save/upload/status/delete/public newsroom, Forms bootstrap/create/publish/public submission/responses, workspace list/save/delete, media upload/list/delete and Studio Users.

API ROUTES
- POST/GET api/studio_auth.php?action=login|me|logout
- GET/POST api/studio_users.php?action=bootstrap|save|status|reset_password|delete
- GET/POST/DELETE api/hr_news.php?action=bootstrap|get|save|upload|status
- GET/POST api/hr_forms.php?action=bootstrap|get|responses and POST operations create|update|publish|close|reopen|delete
- GET/POST api/studio_workspace.php?action=health|list|save|delete|media_list|upload|media_delete
- Public form respondent routes remain available through api/hr_forms.php and api/hr_form.php.

VERIFICATION AND SCOPE
- PHP files were checked for syntax in this environment. No live connection to the hosting server/database was available, so live endpoint behaviour must be verified after deployment.
- Events, Announcements, Surveys and Showcase currently use a shared persistent CRUD model (title, description, status, metadata). Event registration, survey voting and showcase submission workflows are not included in this iteration.
- Media upload supports JPG, PNG, WebP, PDF, DOC, DOCX and MP4 up to 20 MB.
- Reports currently aggregate workspace, user, news, forms and media totals; advanced exports and detailed report filters are not yet implemented.
- Rotate the database password if the previously uploaded credential was live.
