1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Moving My ID to User #1

Discussion in 'General PHP and MySQL Discussions' started by Nelson T., Apr 2, 2016.

  1. Nelson T.

    Nelson T. Guest

    There is no user #1 on my forum.
    I would like to be user #1

    Is there a SQL query that I can run to move my account to #1 in the database?
     
  2. Jeremy P

    Jeremy P Well-Known Member

    The user ID is stored in many different places all over the database, so it wouldn't be a simple query and isn't really practical to do.
     
  3. Chris D

    Chris D XenForo Developer Staff Member

    I concur with Jeremy P.

    Do not do this.

    As well as data being stored across various tables, there is also various pieces of cached data. It's not practical, nor simple to do. There's too much scope for it to go wrong, all for something which ultimately couldn't matter less.

    It's always a nice fuzzy feeling inside to know you're numero uno, but in terms of anyone else they won't care, or even appreciate the significance.
     
  4. Nelson T.

    Nelson T. Guest

    Gotcha. I will leave it alone.
    I should have been more careful when I switched to XF not to delete my original account.
     

Share This Page