Announcement

Collapse
No announcement yet.

Switching UserID's..

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

  • Switching UserID's..

    How can I change the userid of 2 people? like switch them around. I want to switch the userid of 1 & 2 with each other. I tried through phpmyadmin, but now the whole thing is upside up. lol, all the posts and stuff are switched and stuff. How can I switch the userids without messing up the posts/avatar and other stats??

  • #2
    well you have to switch every instance of userid in the db
    there are a lot of tables where the userid is stored,and you have to switch in every single of them
    The price of freedom is eternal vigilance!
    - Thomas Jefferson

    Comment


    • #3
      That seems like a lot of work.. isn't there any way to do it faster?

      run a query or something?
      Last edited by AViO 07; Mon 24 Feb '03, 1:37pm.

      Comment


      • #4
        the work above is combined with queries ^^
        30 queries or something like

        the way faster is to do nothing.
        why do you want to change the id's?
        it's just a number, nothing more..
        The price of freedom is eternal vigilance!
        - Thomas Jefferson

        Comment

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