Announcement

Collapse
No announcement yet.

Setting everyone's styleid to 34?

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

  • xShanex
    replied
    There is a edit button you know.

    Leave a comment:


  • N9ne
    replied
    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!

    Leave a comment:


  • N9ne
    replied
    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?

    Leave a comment:


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

    Leave a comment:


  • N9ne
    started a topic Setting everyone's styleid to 34?

    Setting everyone's styleid to 34?

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

    Thanks,
    9.
Loading...
Working...
X