I have a taf that queries a database at login to check for personal
messages. This is not done via email, but is totally browswer based.
When logging in, if there is a message, or messages in the que, a
pop-up is generated with the messages with the ability to delete or
return the message. To send a message is a simple form that can be
filled out by any user. Only authenticated users can send messages to
each other. This is strictly for use within a secure intranet.
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
--
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
