Version: 3.00, by Quarterbore
Developer Last Online: Aug 2020
Category: Administrative and Maintenance Tools -
Version: 3.6.4
Rating:
Released: 02-07-2007
Last Update: 02-09-2007
Installs: 12
Additional Files
No support by the author.
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!
Not a bad idea; technically this utility is only necessary because occasionally the pmtotal and pmunread numbers can go crazy. That's the bug. This utility provides a "fix."
I have this issue on my forums. I recently updated to the latest version Vb and then all my users PM totals went wonky (is that a word?). Anyways my question is, how do i run this script?
Do I upload it to a specific folder on my server then go to that url? Do i import it with VB product manager? I'm clueless, please help...
It's a PHP file. So U have to run it, by opening it, or by using WGET or something. I don't know if vB task manager can run .PHP files, but im pretty sure of it.
It's a PHP file. So U have to run it, by opening it, or by using WGET or something. I don't know if vB task manager can run .PHP files, but im pretty sure of it.
Ok so how would I specifically go about it? Cause I uploaded the script to my forums main directory and then went to that URL and just got a error page saying nothing important.
Utility to update pmtotal and pmunread in user table Details »»
About Developer
Visit Web Site
Additional Files 
No support by the author.
02-19-2007, 02:38 PM
