On 7/15/03 10:34 AM, "Bill Conlon" <[EMAIL PROTECTED]> wrote:
> What I do for mail can easily be expanded to provide messaging. Because > of legacy issues with the mail action (took too long) I queue messages > into a database and use a cron job to remove them from the queue and > send them. You could likewise queue messages and check the queue on > login. > > > > Since messages could have multiple recipients, I split the system into > two tables: > > messages.id > messages.sender (foreign key to your users table) > message.subject > messages.q_timestamp > messages.text > messages.retain (enumerated yes/no) > > recipients.id > recipients.address (foreign key to your users table) -- in my case it's > the email address > recipients.q_timestamp > recipients.sent_timestamp > recipients.status (enumerated sent/pending -- in your case read/pending) > recipients.retain (enumerated yes/no) > recipients.messages_id (foreign key to the messages table) > > Creating a message is straightforward. My cron job, checks for a pending > recipient. If one is present, the corresponding message is sent via an > email action. Then the recipient row is updated/or deleted based on the > retain column. If no recipients are present, then I delete all messages > that are not to be retained. > > At login, you would just select all unread messages matching the login. > If not null, turn on the message waiting indicator, linked to > read_message.taf. This selects all messages for the user, sorted by > timestamp, and shows the status, read or not read. > > > > >> Off topic and one that I am not for sure is possible. >> >> Fiirst off haven�t posted in a while, but still enjoy this great list! >> Secondly, the question. >> >> I have a users portal that is pretty nice. It contains a lot of different >> data from many different tables. I want to include in my user portal the >> abiliity to leave a user a message. That is, when the user logs in and >> authenticates, they will see if anyone has left them a message. I don�t >> want to use email, I don�t want to sue forums. >> >> Has anyone had this situation or has anyone ever seen a taf that would do >> this? Maybe just leave a message for another user that populates a database >> and then it shows until a paramter is met and then it shows Inactive? >> >> Any help or suggestions are appreciated. >> Thanks >> Steve >> >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > > Bill Conlon > > To the Point > 345 California Avenue Suite 2 > Palo Alto, CA 94306 > > office: 650.327.2175 > fax: 650.329.8335 > mobile: 650.906.9929 > e-mail: mailto:[EMAIL PROTECTED] > web: http://www.tothept.com > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf Thank you for this detailed explanation. This will certainly get me on my way. Thanks again Steve ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
