Jump to content


Photo

instant message system advise cheers.


  • Please log in to reply
5 replies to this topic

#1 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 07 June 2006 - 02:21 PM

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
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#2 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 07 June 2006 - 04:27 PM

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...
Did I help you? Feeling generous? Buy me lunch! 
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community :)

#3 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 07 June 2006 - 04:30 PM

[!--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) View Post[/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.
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#4 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 07 June 2006 - 04:33 PM

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.
Did I help you? Feeling generous? Buy me lunch! 
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community :)

#5 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 07 June 2006 - 04:38 PM

[!--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) View Post[/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.
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#6 wisewood

wisewood
  • Members
  • PipPipPip
  • Advanced Member
  • 226 posts
  • LocationRotherham, England

Posted 08 June 2006 - 12:18 PM

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.
wisewood: proven fact, I am both wise, and wooden.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users