Looking for a sql command

[bashy]

Hi

I am currently playing on my dev board and i am trying to figure out how to remove pm totals from the database, at present i am struggling to do this.

Please can some one show me what sql code i need to set all pm totals back to 0

[briansol]

remove PM totals?

you can't...

totals are a computed count query when run... there is no 'field' for totals.

[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.

[bashy]

Thanks a lot calorie, that worked a treat ;)