karlsemple wrote: if you are after changing the poster of a post you will need to change the poster_id in the phpbb_posts database table to the user id of the user you wish the post to be owned by for the post in question. Also if its a new topic post you will have to do the same for the topic_poster column in the phpbb_topics database table
KimberlyTeed.com wrote: The poster id is correct for these messages ... it's only the Author on the viewtopic pages that are messed up ...
Code: Select all
UPDATE phpbb_topics
SET topic_poster = 4
WHERE topic_id IN
( SELECT t.topic_id
FROM phpbb_topics t, phpbb_posts p
WHERE p.post_id = t.topic_first_post_id
AND t.topic_poster != p.poster_id )