Announcement

Collapse
No announcement yet.

changing userid's a problem?

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

  • changing userid's a problem?

    Ive recently placed the userid# within my postbit. Ive got a member of my forums who has been with my site through alot of changes/re-installs, etc..i would like to make him userid#2 (the current #2 is a test account i created, so im assuming i can just delete it and #2 will no longer be allocated..?)

    are there any problems associated with changing someones userid?

  • #2
    You can, but then you have the problem of associating all the posts etc made by that user with the new userid.

    Comment


    • #3
      you need to delete the user that is a test user.

      then you need to change the user id to 2 for the guy you want to be 2 in "user" & "userfield" tables.

      then you need to run these queries
      Code:
      UPDATE thread SET postuserid='2' WHERE postusername='username'
      replace username with the name of the member you changed to user id 2
      Code:
      UPDATE post SET userid='2' WHERE username='username'
      replace username with the name of the member you changed to user id 2

      now update your counters

      only sidenote, the user will have to reupload his custom avatar

      Comment


      • #4
        great! thanks for the quick responses! im assuming that i should keep the ' ' around the username?
        Last edited by John_770; Mon 24 Mar '03, 8:00pm.

        Comment


        • #5
          Originally posted by Grunt
          great! thanks for the quick responses! im assuming that i should keep the ' ' around the username?
          Yes.

          Comment

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