The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
can someone give me the sql query please to delete a single pm by its ID? thanks
|
#2
|
|||
|
|||
![]()
DELETE FROM pm WHERE pmid = <pmid>
|
#3
|
||||
|
||||
![]()
wouldn't you also want to
DELETE FROM pmtext WHERE id = <pmid> ? |
#4
|
|||
|
|||
![]()
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. |
#5
|
|||
|
|||
![]()
Thank you for this information, the both of you!
![]() |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|