Announcement

Collapse
No announcement yet.

mysql command

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] mysql command

    I've to mass modify all my existing users so that if they have the option to show a popup when a private message is received, this option is reverted to not to show the popup.

    How can I do that using a MySQL query?

    Thank you very much...

  • #2
    1. Try this on a development installation before doing live.

    2. I'm only showing you the SQL as asked. I have no idea what implications this might have.

    UPDATE vb_user SET pmpopup = 1 WHERE pmpopup = 0
    Community manager at Thailand Friends

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X