Announcement

Collapse
No announcement yet.

Change ownership of a thread

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

  • Eagle Creek
    replied
    Originally posted by SaN-DeeP View Post
    There is a hack on Vb.org by Xenon, "advanced edit options" provides an easy interface for same.
    I know about that hack, thankyou.

    Leave a comment:


  • SaN-DeeP
    replied
    Originally posted by Eagle Creek View Post
    Hi!

    Thread ID 500 is posted by Mario. But I want to change this to Erik.

    Can I edit the mysql table THREADS, ID 12 and then put in the user ID and username of Erik in place?
    Cause when I do this I don't see any changes. When I run the vB "update threads-tool" it's restored into the database to the old values (Mario).
    There is a hack on Vb.org by Xenon, "advanced edit options" provides an easy interface for same.

    Leave a comment:


  • Lats
    replied
    Try these 2 queries...
    Code:
    UPDATE 
        post 
    SET 
        username = 'Erik', 
        userid = [COLOR=blue]X[/COLOR] 
    WHERE postid = [COLOR=blue]Y[/COLOR]
    
    UPDATE
        thread
    SET
        postusername = 'Erik',
        postuserid = [COLOR=blue]X[/COLOR]
    WHERE
        threadid = 500
    Change X & Y as required.

    Leave a comment:


  • Eagle Creek
    replied
    Aah, off course! That makes sense.

    Thank you!

    *stupid me*

    If you really want to update it directly in the database
    There isn't a default vBoption, is there?

    Leave a comment:


  • Colin F
    replied
    If you really want to update it directly in the database you'd have to update both the thread and the post table.

    Leave a comment:


  • Eagle Creek
    started a topic Change ownership of a thread

    Change ownership of a thread

    Hi!

    Thread ID 500 is posted by Mario. But I want to change this to Erik.

    Can I edit the mysql table THREADS, ID 12 and then put in the user ID and username of Erik in place?
    Cause when I do this I don't see any changes. When I run the vB "update threads-tool" it's restored into the database to the old values (Mario).

Related Topics

Collapse

  • sudbury8
    Cant login
    by sudbury8
    Can some tell how to find the file to do this.Thanks
    UPDATE user AS user
    SET token = concat(MD5(concat(MD5('pass1234'), user.token)),' ', user.token), scheme = 'legacy'
    WHERE userid...
    Tue 19 Aug '14, 6:23am
Working...
X