Welcome to the Browser-Base Game Zone forums!
I'm having trouble describing how i'd do it though, every decent method I can think of is OO
I have only 1 outbox (for private messages), so it is irrelevant. Group/community messages have only inboxes.
I managed to fit them in the message page (but looks cluttered and not the best...). The biggest problem is the main menu, I need to make a notification when new message arrived.
There are typically 3 forms of communication available in games:
Maybe I'm simplifying this too much but why isn't there just 1 inbox and each of these is just a "type" of message?
CREATE TABLE message( id INT UNSIGNED NOT NULL, type INT UNSIGNED NOT NULL, author INT UNSIGNED NOT NULL, subject VARCHAR(32) NOT NULL, body VARCHAR(255) NOT NULL, PRIMARY KEY (id));CREATE TABLE message_recipient( msg INT UNSIGNED NOT NULL, recipient INT UNSIGNED NOT NULL, PRIMARY KEY (msg, recipient), FOREIGN KEY (msg) REFERENCES message (id) ON DELETE CASCADE, FOREIGN KEY (recipient) REFERENCES group (id) ON DELETE CASCADE);
SELECT t1.* FROM message AS t1 JOIN message_recipient AS t2 ON t1.msg = t2.id WHERE t2.recipient = %d && t1.type = %d;
So, you say to make in-game forum with auto created boards like "Your faction", "Your kingdom" and then put on the interface a single notification that you have a new forum post.
Have you tried asking your users for their opinions on this topic?
I have a hard time understanding several of the last posts. Do you suggested to make one window with all messages from all boxes tossed together (with some type indicator next to it)? In such case, it won't work, because there are too many of such messages daily on average. It would be completely unreadable.