Is it possible for someone to take over a thread?
I have groups on my forum and a group leader just resigned.
The new owner wants to own the threads the previous leader created.
(Example, the main thread about group requirements and such).
How do I make the new leader the owner of that thread?
Try this SQL. Make a backup first.
update mybb_posts set uid=newUID, username='newUsername' where uid=oldUID;
update mybb_threads set uid=newUID, username='newUsername' where uid=oldUID;
(2012-11-13, 11:50 PM)spork985 Wrote: [ -> ]update mybb_posts set uid=newUID, username='newUsername' where uid=oldUID;
update mybb_threads set uid=newUID, username='newUsername' where uid=oldUID;
That code will make
all posts from one user be attributed to the other person, not the posts in a particular forum.
To select particular post add an AND clause into your SQL:
AND pid=the pid in question;
(2012-11-14, 12:55 AM)Wildcard Wrote: [ -> ] (2012-11-13, 11:50 PM)spork985 Wrote: [ -> ]update mybb_posts set uid=newUID, username='newUsername' where uid=oldUID;
update mybb_threads set uid=newUID, username='newUsername' where uid=oldUID;
That code will make all posts from one user be attributed to the other person, not the posts in a particular forum.
To select particular post add an AND clause into your SQL:
AND pid=the pid in question;
That's what he wants to do...
I just want the user to be the owner of that particular thread.
You will need to replace the UID and USERNAME thread fields for that thread, as well as edit the old author to decrease his post count by one.