The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Mark all PM's read for single user
I recently used ImpEx to transfer a MyBB forum to vBulletin. I had approximately 3,500 PM's in my inbox which for the time being I do NOT want to delete or remove. However, vBulletin has marked all of these as unread. What is the easiest way to to mark all of my PM's as read?
Thanks for your suggestions! |
#2
|
||||
|
||||
you need to run 2 sql queries.
This sets new pm count for every user to 0: Code:
UPDATE vb4_user SET pmunread = 0 Code:
UPDATE vb4_pm SET messageread = 1 This sets new pm count for the user with id 42 to 0: Code:
UPDATE vb4_user SET pmunread = 0 WHERE userid = 42 Code:
UPDATE vb4_pm SET messageread = 1 WHERE userid = 42 It's safer to test these in a safe environment first, I suggest to copy the table before trying to run those queries. |
#3
|
||||
|
||||
Disasterpiece,
Thanks a ton for that! It worked perfectly. Much appreciated. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|