tblPMMessage - delete indicator?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=31427
Printed Date: 29 March 2026 at 4:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: tblPMMessage - delete indicator?
Posted By: rooq
Subject: tblPMMessage - delete indicator?
Date Posted: 26 November 2016 at 7:08pm
Hello
I have a website which has a web wizard forum in one of its subdirectories.
On the main page of the website I have added an alert which looks for unread messages in tblPMMessage (Read_Post = 0). If there are no unread messages, it is supposed to report how many saved messages there are - I thought this would be simply Read_Post = 1.
However, even after deleting the messages, they are still being shown in the table and so are still reported as "saved messages" on my main website page.
How can I identify that a PM is non-deleted?
|
Replies:
Posted By: Jagoop
Date Posted: 30 November 2016 at 10:17pm
AS far as I can tell, the various fields in the tblPMMessage has the following functions:
PM_ID - the ID of that individual message
Author_ID - the ID of the recipient of the message (Author_ID can be joined with tblAuthor to find name, etc.)
From_ID - the ID of the sender of the message (Author_ID can be joined with tblAuthor to find name, etc.)
PM_Tittle - message title
PM_Message - message content
PM_Message_Date - the date the message was sent
Read_Post - has value 1 if the recipient has read the message, otherwise the value is 0
Email_notify - I believe this shows if the sender want to be notified of replies to the message
Inbox - is message visible in recipients inbox (ie. is not deleted by the recipient)
Outbox - is message visible in the senders outbox (ie. is not deleted by the sernder)
|
|