SQL Query

[GloballyUnited]

How can i run an sql query that enables the PM system for all members. for some reason all members cannot PM because it is turned off be defualt upon registration and i do not want to go through 10,000 members and turn it on. i was wonderin if there is a quick sql query to do this.

Thanks!!

--------------- Added 1258612605 at 1258612605 ---------------

Anyone? Is there some sort of query that can be run to change this?

[Alexey?]

first of all check if this options enabled in their user group
secondly you can run sql query from your admincp , in your maintain options.

[Floris]

How can i run an sql query that enables the PM system for all members. for some reason all members cannot PM because it is turned off be defualt upon registration and i do not want to go through 10,000 members and turn it on. i was wonderin if there is a quick sql query to do this.

Thanks!!

--------------- Added 1258612605 at 1258612605 ---------------

Anyone? Is there some sort of query that can be run to change this?


is this what you're looking for?
http://dl.dropbox.com/u/693961/Screen%20shot%202009-11-19%20at%203.49.08%20PM.png
http://dl.dropbox.com/u/693961/Screen%20shot%202009-11-19%20at%203.49.02%20PM.png

at least it might be an example (in source code) what tables/field/etc you might need to run

[GloballyUnited]

Thanks a ton Floris I was not eve aware.