Announcement

Collapse
No announcement yet.

PHPMYADMIN running sql query for

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

  • PHPMYADMIN running sql query for

    Ok i need to run a sql query on PHPMYADMIN

    i need to make it so all my users are using this setting

    Receive mailings from admins
    Yes

    Show email
    Yes

    Invisible on 'Online users' list
    No

    Receive PMs
    Yes

    Email on PM
    Yes

    PM Popup
    Yes

    Show Signatures
    Yes

    Show Avatars
    Yes

    Show Images
    Yes

    Show VBcode
    Yes

    Use email notification by default
    No

    Remember Username and password
    Yes

    Browse boards with cookies
    Yes

    Can someone help me write a sql query to do that for phpmyadmin? Thanks!

  • #2
    anyone know how to write a sql query that will do that?

    Comment


    • #3
      http://vbulletin.com/forum/showthrea...threadid=29122

      UPDATE user SET invisible=0, showemail=1, adminemail=1, receivepm=1, emailnotification=0, nosessionhash=1, emailonpm=1, pmpopup=1, cookieuser=1
      Last edited by tubedogg; Mon 15th Apr '02, 5:37pm.

      Comment


      • #4
        Hey tubedog thanks for replying but i get a error

        Error
        SQL-query :

        UPDATE user SET invisible=0,showemail=1,adminemail=1,receivepms=1,emailnotification=0,nosessionhash=1,emai lonpm=1,pm
        popup=1,cookieuser=1

        MySQL said:


        You have an error in your SQL syntax near 'popup=1,cookieuser=1' at line 2

        Back

        Comment


        • #5
          You have a line feed between 'pm' and 'popup'. Remove it and try again. That query needs to be entered as one long line.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment


          • #6
            Error
            SQL-query :

            UPDATE user SET invisible=0,showemail=1,adminemail=1,receivepms=1,emailnotification=0,nosessionhash=1,emai lonpm=1,pmpopup=1,cookieuser=1

            MySQL said:


            Unknown column 'receivepms' in 'field list'

            Back


            I get this error now...

            Comment


            • #7
              There was an error in it, I've fixed it in my post above.

              Comment

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