AVideo Security and Stability Improvements in Recent Updates

The open-source AVideo platform has seen a flurry of activity in the past week, with developers focused on improving the security and stability of the software. Here are the key highlights:

Security Enhancements:
- Update video_password handling to support bcrypt hashes and improve security
- Refactor SQL queries to use prepared statements, preventing SQL injection
- Enhance security in url_get_contents and wget functions to prevent SSRF attacks
- Implement rate limiting for various API endpoints to prevent abuse

Stability Fixes:
- Remove unnecessary whitespace and cast comments_id_pai to integer to prevent issues
- Sanitize videos_id in Like class to prevent SQL injection
- Correct variable name for playlist visibility checks and enhance permission handling

Dependency Updates:
- Bump jQuery from 3.7.1 to 4.0.0
- Bump phpseclib/phpseclib from 3.0.49 to 3.0.50
- Bump socket.io-parser from 4.2.4 to 4.2.6

Impact: The security and stability improvements in these updates are critical for AVideo users, as they help protect against common web application vulnerabilities like SQL injection and SSRF attacks. The dependency updates also ensure the platform is running on the latest secure versions of key libraries.

Breaking Changes: No, these changes do not introduce any breaking changes that would require significant migration effort.

Key Highlights:
- Improved video password handling and SQL injection prevention
- Enhanced security against SSRF attacks and API abuse
- Stability fixes for playlist management and comment handling
- Dependency updates for jQuery, phpseclib, and socket.io-parser