How Do I change Receive Private Messages to 'yes'

[Sir_Yaro]

Im just import my old forum (IPB) to vb 3.0.7 and I got one problem..

How Do I change, for all user (over 4500) "Receive Private Messages" and "Receive Admin Emails" option to "Yes". Becase after conversion 99% users have "No".
And I cannot send msg about changes to anybody...

im just find an answer here
http://www.vbulletin.com/forum/showthread.php?t=102136

[Marco van Herwaarden]

AdminCP->Import&Maintenance->Execute SQL Query->Automaitc query: Yes - Receive Privat Messages

PS Your userid will have to be permitted sql access in your config.php

[Sir_Yaro]

PS Your userid will have to be permitted sql access in your config.php
im just comment line
print_stop_message('no_permission_queries');
in file ./forum/admincp/queries.php
:D

but big thanks anyway :up:

[Marco van Herwaarden]

im just comment line
print_stop_message('no_permission_queries');
in file ./forum/admincp/queries.php
:D

but big thanks anyway :up:Very bad choice i must say.

Good way of doing it:
Edit includes/config.php and add you userid to '$canrunqueries =...'