MyBB Community Forums

Full Version: how to set value by db query.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
question :
Quote:hey man
i was having a problem with this plugin , but when i change my hosting working GREAT now but with new Users

i mean , when any new user Register in my forum its working great

but old Users Pm Notice don't appear



how can i force all member View This Plugin


Answer
Quote:Hi,

that sounds curious... Hm, the plugin should replace the default mybb pm alert and so the ajax message depents on the setting "Alert me with a notice when I receive a Private Message" in UserCP.

Please check, if old members have set this option. Maybe you can set this value for all members with a db query.

how can i set this values by db query for all members :
- "Alert me with a notice when I receive a Private Message" in UserCP
- " Show the quick reply box on the view thread page." in UserCP ( cz not All Member can See the Quick Reply
UPDATE `mybb_users` SET `pmnotice` = '1'
UPDATE `mybb_users` SET `showquickreply` = '1'

Check your table prefix first.
ConfusedConfusedConfused
i go to phpmy admin , i browse my sql

i go to mybb_user > then i click on
showquickreply (edit ) > i change (default) 0 to 1


i log in with user account ( quick reply not apear on it ) still the Same

i go to mybb_user > then i click on pmnotice ? i change (default) 0 to 1

i login with same user account , not apear !


do i should deactivate my plugin then activate ?
Thx u
i love u Big Grin i really love u Big Grin
So it works...??
yeah thx u Big Grin