tblPMMessage - delete indicator?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
rooq Members Profile Find Members Posts Newbie Joined: 26 November 2016 Status: Offline Points: 2	Post Options Post Reply Quote rooq Report Post Thanks(0) Quote Reply Topic: tblPMMessage - delete indicator? 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?

Jagoop Members Profile Find Members Posts Groupie Joined: 17 August 2009 Location: Denmark Status: Offline Points: 49	Post Options Post Reply Quote Jagoop Report Post Thanks(0) Quote Reply 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)

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.