Jump to content

instant message system advise cheers.


redarrow

Recommended Posts

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
Link to comment
Share on other sites

[!--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.
Link to comment
Share on other sites

[!--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.
Link to comment
Share on other sites

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.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.