Announcement

Collapse
No announcement yet.

Setting everyone's styleid to 34?

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

  • Setting everyone's styleid to 34?

    What query do I run to set everyone's style they're using to styleid 34?

    Thanks,
    9.

  • #2
    Oh and another question, how would I go about deleting everyone's custom titles so they just have the standard ones?

    Comment


    • #3
      Ok just one more thing for now:

      What do I need to do, in order for everyone's avatar (EXCEPT FOR THOSE USING CUSTOM AVATARS!) to be set to nothing, ie. if you are using one of the 530 avatars we offer which aren't custom, it gets set so you aren't using an avatar?

      Comment


      • #4
        Ok Ok nevermind, lol, I did a bit of sql learning myself and learnt how to do everything I wanted to!

        Here's how I did it for future reference!

        To set everyone's styleid to 34:

        UPDATE user SET styleid = '34'

        To delete everyone's CT:

        UPDATE user SET usertitle = ''

        Then:

        UPDATE user SET customtitle = '0'

        The avatar thing:

        UPDATE user SET avatarid = '0'


        Done!

        Comment


        • #5
          There is a edit button you know.

          Comment

          Loading...
          Working...
          X