Avatar

How to sort Sticky topics ? (General)

by Auge ⌂, Monday, February 18, 2019, 10:58 (1891 days ago) @ Jean-Michel3

Hello

Go to phpmyadmin, table xxx_entries, there you have all the posts. The sticky notes are defined by the column "Sticky" = 1. Don't touch this. Go to the column "time". The most recent sticky note displays on top.

It's much more simpler.

I don't know if there is an impact on the subposts of the changed entry, I don't think so.

The order depends on the date of the last entry in a thread. You only have to manipulate the timestamp of the latest reply of the thread you want to set to top. The id of the entry in the database is identifiable by the URL-parameter id of the entry. So the id of your posting I'm answering to is 11593 (taken from the URL: https://mylittleforum.net/forum/index.php?id=11593).

Only the timestamp of the opening posting beats this rule (you used it in your example) but this can lead to inconsistencies if one sets a more actual timestamp for a thread (instead an older one). This is because in this scenario the timestamp of the opener could be newer than a timestamp of one of it's replies.

To manipulate the latest answer is IMHO the safer and more consistent way.

Tschö, Auge

--
Trenne niemals Müll, denn er hat nur eine Silbe!


Complete thread:

 RSS Feed of thread