PHPMYADMIN running sql query for

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • xsngx
    New Member
    • Oct 2001
    • 23

    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!
  • xsngx
    New Member
    • Oct 2001
    • 23

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

    Comment

    • tubedogg
      Senior Member
      • Feb 2001
      • 13602

      #3


      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 15 Apr '02, 5:37pm.

      Comment

      • xsngx
        New Member
        • Oct 2001
        • 23

        #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

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #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

          • xsngx
            New Member
            • Oct 2001
            • 23

            #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

            • tubedogg
              Senior Member
              • Feb 2001
              • 13602

              #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...