PDA

View Full Version : Utility to update User table - pmtotal and pmunread?


Quarterbore
02-08-2007, 02:43 PM
I had my PM table go bad on me and I had to restore it from a backup... I am done fixing the tables in my database BUT now the usertable and specifically the pmtotal and pmunread fields are not accurate...

I have looked through the various vBulletin maintenace tools and I have tried rinning just anout all of the scripts but none of the tools seem to rebuild these two values...

Is there a script that I can use to do this or will I need to write my own script to do this?

I can write it but it just seems like something that should already exist...

EDIT - I wrote a script to do this...

I will post it in the appropriate forum after I get a chance to make the code look nice!

OK, I couldn't find an answer so I coded it...

It is released here:

https://vborg.vbsupport.ru/showthread.php?t=138827