Looking for a sql command

[calorie]

There is the pmtotal field in the vB user table:

# change vb3_ to your vB table prefix

# this query sets all PM totals to zero

UPDATE vb3_user SET pmtotal = 0;

There is also a pmunread field in the vB user table.

Not sure what you are trying to do, but there you go.