Simple Machines Community Forum

I want to be able, as an administrator, to change, as if the users themself changed, if they will receive email notifications of  new PMs or not (or only from the friends list). And i want to do this for all users at once.
I know there is no settings in administrative panel of SMF but I'm sure somebody who knows mySQL can alter between 1 and 0 the tabel where this information stands. But I don't know where SMF stores this information.
If you know where is this information and how to alter the default settings from phpmyadmin and you are willing to make this query for me i will be willing to pay a little with my paypal account to yours (i am a student, i can pay 5 Euro  :'( ). I know maybe somebody else will want to do this so you cant post the code/query directlly here (and your paypal account), i don't want this information to keep for myself.

Thanks in advance

You bascially want to have a email sent over a PM ? or you dont want users to have a email when they recieve a PM ?

It is basically nothing with database if u want to do that.

Second thing. I don't want users to receive notification emails when they receive new PM.

So the settings in PM Settings isn't stored in the database? (there are 3 options: always, only from my friends, never).

I changed my first post to be more clear. I want to change this option to user by user basis, but all users at once.

Thanks for reply!

Just run the following query in phpMyAdmin > SQL tab:

UPDATE `smf_members` SET `pm_email_notify`=0

0 = Never, 1 = Always, 2 = Buddies only

Also change smf_ prefix if you use a different one.

Thank you very much, this is exactly what i wanted. Just donated 6$ to you (my first donation, i didn't know that it works with dollars, not EURO)

i think it was just possible from resetting theme options ?

Nope. In theme options you can reset if they want to show the pop-up window when you have new PM.

oh yea... i just checked the options. It is bascially in each users PM settings. But u cant go into each users profile and do it. Hence this is a better option ;)