Messaging System Mods

[faguss]

On my host using "NOT IN ()" is invalid so I've added condition replace empty data with zero. Plus I only retrieve required columns instead of everything.

Function

Code:

fetchMessageUsers()

is used twice which isn't necessary. I actually removed this function and instead make a query on the top.

https://pastebin.com/XMLGFXVv (lines 34-39).

Column msg_exempt violates 1NF guideline. A different way would be to make a new column in users table or create a new table.

Also the same avatar-related modification from messages.php applies to message.php as well.