instant message system advise cheers.

[redarrow]

I am currently at the end of a long project and want to
add an instant message system design by my self
but need also advise please.

The database as the following ( any tips more then welcomed).


field name 1:
member_messages

colum names:

id
sent_id
time
date
hasread
message

field name2:
messages_saved

colum names:

sent_id
time
date
message

field name3:
Band _messenger

sent_id
time
date


field name4:
report_user

sent_id
date
time
message

[.josh]

are you asking for database structure advice? maybe you should post this in the database forum. Or maybe you are looking for advice in general, such as IM features or something? Mebbe you should post this in the Misc. section? Dunno m8, I dun see any code to fix...

[redarrow]

[!--quoteo(post=381058:date=Jun 7 2006, 04:27 PM:name=Crayon Violent)--][div class=\'quotetop\']QUOTE(Crayon Violent @ Jun 7 2006, 04:27 PM) [snapback]381058[/snapback][/div][div class=\'quotemain\'][!--quotec--]
are you asking for database structure advice? maybe you should post this in the database forum. Or maybe you are looking for advice in general, such as IM features or something? Mebbe you should post this in the Misc. section? Dunno m8, I dun see any code to fix...
[/quote]

What i need to no is the stucture for the database correct before programing.

[.josh]

i guess that kinda depends on what all you want the IM to do? make a list of everything you want it to do, and go from there.

[redarrow]

[!--quoteo(post=381062:date=Jun 7 2006, 04:33 PM:name=Crayon Violent)--][div class=\'quotetop\']QUOTE(Crayon Violent @ Jun 7 2006, 04:33 PM) [snapback]381062[/snapback][/div][div class=\'quotemain\'][!--quotec--]
i guess that kinda depends on what all you want the IM to do? make a list of everything you want it to do, and go from there.
[/quote]

get users to send messages to one another and

also save a copy of the message and then let the user have the abilty

to band a messenger or send a bad message to the admin.

lol, but does the database structure look correct to you cheers.

if i put a the sent message in a session and uptate the database via that session is that possable cheers.

[wisewood]

On the intranet system i created for my employers, i added a simple messaging system.

Users can send messages to each other, reply to messages, forward messages, delete messages from their inbox.

the "my_messages" table looks like this;

id (integer - primary key)
date_time
sender
recipient
read
deleted
subject
message

sender and recipient fields store the user id number from the users table, and read and deleted fields are updated with 1 if they have been read or deleted respectively.

From this basic structure, you could expand it to allow other functions.

Having a users table which is something like this;

id
username
password
can_send_messages
can_receive_messages
banned


You could also have a blocked_users table

id
username (user id of user doing the blocking)
is_blocking (user id of the user to be blocked by that user)
reason

You'll get the idea. Build something that does the basics, but leave enough scope to expand it later as required. Personal folders to move mail out of your inbox etc are something that i plan to implement into my system... as well as global announcements to all staff.