Utility to update pmtotal and pmunread in user table
Mod Version: 3.00, by Quarterbore
This modification is in the archives.
| vB Version: 3.6.4 | Rating:  (0 vote - 0 average) |
Installs: 12 |
| Released: 08 Feb 2007 | Last Update: 10 Feb 2007 | Downloads: 128 |
 Not Supported
 Additional Files
|
||
About this Script:
This script will update the PM Count and Undead PM counts in the user table.
Why Did I write this:
Well, I wrote it as I could not find a built in function in vBulletin to rebuild these values! I had my PM table become corrupted during an install process and while it was easy to restore the PM tables (there are three of them) I had issues as the USER table did not accurately represent the values in the PM table.
I tried searching for a solution and I learned that others have had this issue with board imports, pruning old PMs, or as in my case when it was necessary to recover data from a backup.
What does the script do:
This script updates the USER table to show the correct count of TOTAL PMs and UNREAD PMs for all users.
Why is this so "unrefined"?
This is intended as a utility. I included a permissions check to verify the person running the script is an Admin. I would suggest that this is not a script that you would want sitting on your server all the time but instead is being shared as a tool for cases where someone needs it!
Credits and Revisions
9-Feb-2007 Version 2
thincom2000 did a major rewrite of the script to go from three SQL queries down to one. The script is much faster now and he is listed as Co-author! THANKS!
9-Feb-2007 Version 3
Fixed this bug:
This script will update the PM Count and Undead PM counts in the user table.
Why Did I write this:
Well, I wrote it as I could not find a built in function in vBulletin to rebuild these values! I had my PM table become corrupted during an install process and while it was easy to restore the PM tables (there are three of them) I had issues as the USER table did not accurately represent the values in the PM table.
I tried searching for a solution and I learned that others have had this issue with board imports, pruning old PMs, or as in my case when it was necessary to recover data from a backup.
What does the script do:
This script updates the USER table to show the correct count of TOTAL PMs and UNREAD PMs for all users.
Why is this so "unrefined"?
This is intended as a utility. I included a permissions check to verify the person running the script is an Admin. I would suggest that this is not a script that you would want sitting on your server all the time but instead is being shared as a tool for cases where someone needs it!
Credits and Revisions
9-Feb-2007 Version 2
thincom2000 did a major rewrite of the script to go from three SQL queries down to one. The script is much faster now and he is listed as Co-author! THANKS!
9-Feb-2007 Version 3
Fixed this bug:
Spoiler (click to open)
Got it... $lastuser is being overwritten with a boolean when it should have the lastuser's id.
Line 31 should have this
$lastuser = $pms['userid'];
Line 31 should have this
$lastuser = $pms['userid'];
Close
Download
This modification is archived, downloads are still allowed.
PM-Count-Updater.zip (1.0 KB, 115 downloads)
Supporters / CoAuthors
- thincom2000