MyBB Community Forums

Full Version: how can i change topic owner
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
hi all
i have a problem, how can i change topic owner?
because i have 60 users, but i write all topics from admin username, i want change user for some topic to xxx user and other topic to yyy user.

how can i do it?
i tried from phpmyadmin, but its not easy, a topic is relation 3 or 5 table.

For this station any module or plugin?

please help, sory for my bad english.
there is any idea?
If it's an announcement's writer you want to change, then it's fairly simple.
ACP -> Forum Management -> Announcements -> *NAME OF ANNOUNCEMENT WHO'S OWNER YOU WISH TO CHANGE* -> [edit] -> Press save without editing anything. In forum, go to your announcement that you edited, and look in the author column, your name should be there instead of the original authors'.

For posts: Copy the post's contents, delete it(if it is locked), then re-post the thread and paste the post contents you copied in to the message body text area.
You'll have to do it through phpMyAdmin:
Assuming you know the thread ID and post ID of the thread and the first post of the thread, and also the User ID of the new author, run these queries in the phpMyAdmin:

UPDATE mybb_threads SET uid=X WHERE tid=Y
UPDATE mybb_posts SET uid=X WHERE pid=Z
Replace:
X with the new author's user ID
Y with the thread ID
Z with the post ID of the first post in thread Y