![]() |
SQL Query to delete a single pm by its id?
can someone give me the sql query please to delete a single pm by its ID? thanks
|
DELETE FROM pm WHERE pmid = <pmid>
|
wouldn't you also want to
DELETE FROM pmtext WHERE id = <pmid> ? |
Not really.
When a PM is sent the following happens: - A new row is inserted into the pmtext table with the text of the PM. - A new row is inserted into the pm table for each receipant of the PM, and 1 for the sender of the PM Removing the row from the PM table, will make the PM unreachable for this receipant/sender. Stale pmtext rows (ie a pmtext with no row in the pm table anymore) are cleaned up on a regular basis by a scheduled task. |
Thank you for this information, the both of you! :)
|
All times are GMT. The time now is 08:56 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|