MyBB Community Forums

Full Version: many sql querry needed
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
hey i have user account ( as normal member )

from time to time i login and i check if everything is fine
i login today i found
all this not enabled :
Hide your email from other members.
Receive private messages from other users.
Alert me with a notice when I receive a Private Message.
Notify me by email when I receive a new Private Message.

Display posts in classic mode.
Display users' signatures in their posts.
Display users' avatars in their posts.
Show the quick reply box on the view thread page.


Show friendly redirect pages.
Show the MyCode formatting options on the posting pages.



dunno why !

so if you plz guys i need sql query to change them , ALL MEMBERS

Receive private messages from other users.
Alert me with a notice when I receive a Private Message.
Notify me by email when I receive a new Private Message.
Display users' signatures in their posts.
Display users' avatars in their posts.
Show the quick reply box on the view thread page.
Show friendly redirect pages.
Show the MyCode formatting options on the posting pages.




Sorry for bothering :$
They should be enabled by default... are you saying they're unselected on a newly registered user?? If you really need it...

UPDATE `mybb_users` SET `receivepms` = '1';

UPDATE `mybb_users` SET `pmnotice` = '1';

UPDATE `mybb_users` SET `pmnotify` = '1';

UPDATE `mybb_users` SET `showsigs` = '1';

UPDATE `mybb_users` SET `showavatars` = '1';

UPDATE `mybb_users` SET `showquickreply` = '1';

UPDATE `mybb_users` SET `showredirect` = '1';

UPDATE `mybb_users` SET `showcodebuttons` = '1';
no on new registration everything is fine
Matt plz i need Also
BY DEFAULT [Notify me by email when I receive a new Private Message.]

Thx u Very much
That is selected by default... Confused
by default its not , you can notice that in registration
http://haifafans.net/fanclub/member.php?...n=register
Hmm, it's selected on my localhost, maybe I changed something.

In member_register, find:

<tr>
<td valign="top" width="1"><input type="checkbox" class="checkbox" name="emailpmnotify" id="emailpmnotify" value="1" {$emailpmnotifycheck} /></td>
<td valign="top"><span class="smalltext"><label for="emailpmnotify">{$lang->email_notify_newpm}</label></span></td>
</tr>

replace with:

<input type="hidden" name="emailpmnotify" id="emailpmnotify" value="1" />

That'll turn it on and remove the option to change it.