Announcement

Collapse
No announcement yet.

changing userid's a problem?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    vBR
    Senior Member

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

    Leave a comment:

  • John_770
    Member

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

    Leave a comment:

  • SiXXGuNNZ
    Member

  • SiXXGuNNZ
    replied
    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

    Leave a comment:

  • vBR
    Senior Member

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

    Leave a comment:

  • John_770
    Member

  • John_770
    started a topic changing userid's a problem?

    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X