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.