OpenSparrow Files

Added

• One-to-one user chat (api/chat.php, spw_chat_messages), opened from the Chat entry in the avatar menu, with immediate in-app bell notifications, demo seed data and docs. Sending and hiding require the editor role; viewers can read their conversations.
• Token-protected HTTP cron trigger (public/cron.php, unlocked by the CRON_SECRET environment variable) for shared hosts without a CLI cron. The notification cron is refactored into a shared runner reused by both the CLI entry and the HTTP endpoint.

Changed

• Admin tables now size columns to their content and scroll horizontally instead of squeezing them.
• Cron secrets embedded in URLs use hex (openssl rand -hex 32); host-specific launcher references were dropped.

Removed

• Nothing.

Fixed

• The new-chat bell notification rendered the raw i18n key chat.new_message; the key is now defined in all 20 languages.

Upgrade notes

• Run System → Migrations → Initialize System Tables to apply the 4.4_user_chat database migration (creates spw_chat_messages). No files or config keys are removed.
• To use the HTTP cron trigger, set CRON_SECRET (e.g. openssl rand -hex 32); an empty value disables the endpoint.

Full changelog: https://github.com/wrobeltomasz/OpenSparrow/compare/4.3...4.4