Change ownership of a thread

[Eagle Creek]

There is a hack on Vb.org by Xenon, "advanced edit options" provides an easy interface for same.

I know about that hack, thankyou.

[SaN-DeeP]

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.

[Lats]

Try these 2 queries...

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.

[Eagle Creek]

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?

[Colin F]

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

[Eagle Creek]

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).