Delete ALL users PM´s with a query?

[Danbc]

Hey guys (and girls)...

After the import from phpbb, we have had some wierd issues with duplicate PM´s being imported aswell on all the users in our db. So what we wanna do, is to delete every PM in every users inbox with a query..

Is that possible and how?

[Jake Bunce]

These queries should do the trick:

DELETE FROM pm

DELETE FROM pmreceipt

DELETE FROM pmtext

UPDATE user SET pmtotal = 0, pmunread = 0, pmpopup = IF(pmpopup=2, 1, pmpopup)

[Danbc]

Worked like a charm, thanks Jake!

[Danbc]

Oh another QQ...

How do I delete templates? I can only find an add/edit function

[Jake Bunce]

In vB3, reverting is the same as deleting. In the template manager, select the "revert" option for a template you want to delete.

[Danbc]

Ahhh, sneaky

Thanks jake!