Refactor Group Chats

[SamShanks1]

Pull Request Description A full rework of the group system

Feature Specs:

• Group Avatar
• Leave group chats
• Add to group chats
• Edit group chat name

Tasks Progress:

• [x] Leave Groups
• [ ] Add to groups
• [x] Remove people from groups
• [x] Store who created groups
• [ ] Change group name
• [ ] Group avatar with edit
• [x] System messages (join/leave/add)
• [x] If owner leaves then assign someone else owner (first in participant list)

Preview

The following SQL needs to be ran

ALTER TABLE npwd_messages ADD COLUMN `is_system` tinyint(4) NOT NULL DEFAULT 0;
ALTER TABLE npwd_messages ADD COLUMN `system_type` varchar(48) NOT NULL DEFAULT '';
ALTER TABLE npwd_messages ADD COLUMN `system_number` varchar(48) NOT NULL DEFAULT '';
ALTER TABLE npwd_messages_conversations ADD COLUMN `owner` varchar(48) NOT NULL DEFAULT '';

#610

Pull Request Checklist:

• [x] Have you followed the guidelines in our Contributing document and Code of Conduct?
• [x] Have you checked to ensure there aren't other open Pull Requests for the same update/change?
• [x] Have you built and tested NPWD in-game after the relevant change?

[SamShanks1]

One problem I just thought about will be groups that were created before this and don't have the "createdBy" defined, I could make it so any groups that don't have that will allow any member to remove another member. I also don't know if any errors will be created if "createdBy" is left blank

[SamShanks1]

Tested with no createBy date, everything still works however no one can remove people (may add it so everyone can remove in the future). Also just added leaving groups

[TasoOneAsia]

Also appears CI is failing for the frontend due to a couple small ESLint complaints.

[SamShanks1]

Just need to do some last testing but this should be finished, @Mojito-Fivem would you prefer I do a separate PR for adding members to groups or keep it here

[LiamDormon]

It's all under the same feature and I think it would create more issues having this without the adding members functionality

[SamShanks1]

Added system messages

Preview

The following SQL is now needed (added to the original message)

ALTER TABLE npwd_messages ADD COLUMN `is_system` tinyint(4) NOT NULL DEFAULT 0;
ALTER TABLE npwd_messages ADD COLUMN `system_type` varchar(48) NOT NULL DEFAULT '';
ALTER TABLE npwd_messages ADD COLUMN `system_number` varchar(48) NOT NULL DEFAULT '';

[AlamoRoleplayFiveM]

Will there not be any chance of group calling?

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[TonybynMp4]

this needs to be revived 😢