• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Insert new post before first in thread

Jeff Fuqua

Well-known member
#1
I run into the occasional issue of a poster who reports some news which is quickly followed by a thread started by an RSS feed from an official source.

I'd like to make the official source the first post in the thread and merge the threads together. When I merge, the original post remains the first one.

Is there a way to insert a new post which becomes the first in the thread or promote an existing one in the existing thread to move to #1?

Thanks.
 

Daniel Hood

Well-known member
#2
Run this query in phpmyadmin:

Code:
SELECT * FROM `xf_post` WHERE thread_id = 1 ORDER BY position ASC
You're going to have two rows (possibly more if more than one merge is done) with position: 0. The positions aren't re-calculated upon merging so that's where the issue lies. If you change the position on one of the rows to 1 instead of 0, it should be correct. If that's the case, a fix will be relatively simple. I think this might be better off as a bug report and fixed by @Mike instead of as an add on though.

Unless of course I'm wrong.
 

AndyB

Well-known member
#6
Is there a way to insert a new post which becomes the first in the thread or promote an existing one in the existing thread to move to #1?
This is fairly easy to do with phpmyadmin. Are you comfortable editing the database directly using phpmyadmin?
 

Jeff Fuqua

Well-known member
#7
This is fairly easy to do with phpmyadmin. Are you comfortable editing the database directly using phpmyadmin?
I try to stay away from messing with the database whenever possible. I was hoping there might be interest in an add-on which would allow an admin to select a post and make it the first one of a thread.
 

DRE

Well-known member
#8

RobParker

Well-known member
#9
Someone (Chris?) has an addon that changes the post time. If you used that on the RSS thread and then merged, that would work wouldn't it?