Enable Private Messaging via SQL?

[itzkr0me]

I recently transferred an IPB board over to a vB installation. In doing so (for whatever reason), all of my existent users have private messaging turned off. I need to globally turn that back on. Is there a SQL statement (not too familiar with SQL) that will allow me to handle this?

Any help is much appreciated.

[kh99]

If you go tothe adminCP, Maintenance > Execute SQL Query, one of the automatic queries in the dropdown list allows you to set "receive PMs" to yes for all users.