Re: Add a first post to a topic
Reply #1 –
With the current way sorting posts is implemented, this is rather tricky without rely on... tricks.
The posts (and messages) are sorted by default based on the message/topic id, and these ids are automatically and sequentially assigned by mysql/postgresql when the message/topic is created. So the only way to achieve that would be the way I used for the sticky first message (i.e. another query), but in that case it would likely require at least another column, maybe another table...
Re: Add a first post to a topic
Reply #2 –
Hm... Does this mean "sorry, much to complicated"?
Re: Add a first post to a topic
Reply #3 –
Second thoughts on this? It seems other software can do this. It would be really helpful when splitting, moving and bring threads together.
Maybe we can use a trick? Give the (new) first post of the thread a date and time before the following? Give it a negative ID (if even possible)? Make it sticky like threads can be?
Re: Add a first post to a topic
Reply #5 –
My idea there was very simply not to use tricks with ids/dates and really just have another table with the "first messages" that would go on top of everything else.