Sort by article length (#8119)

* Sort by article length
fix https://github.com/FreshRSS/Extensions/issues/378
Very basic using simply SQL `LENGTH()` function.

<img width="492" height="217" alt="image" src="https://github.com/user-attachments/assets/7cf37303-76c8-4411-b8b1-075e81535b60" />

* Improve content length retrieval

27 files changed, 54 insertions, 0 deletions

diff --git a/app/i18n/cs/index.php b/app/i18n/cs/index.php
index 255f0b18b..18b7fd655 100644
--- a/app/i18n/cs/index.php
+++ b/app/i18n/cs/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/de/index.php b/app/i18n/de/index.php
index f2d3346e3..41c192f71 100644
--- a/app/i18n/de/index.php
+++ b/app/i18n/de/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Älteste zuerst',
 			'id_desc' => 'Neueste zuerst',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// IGNORE
 			'link_desc' => 'Link Z→A',	// IGNORE
 			'rand' => 'Zufällige Reihenfolge',
diff --git a/app/i18n/el/index.php b/app/i18n/el/index.php
index 8ac8a4927..251eb9353 100644
--- a/app/i18n/el/index.php
+++ b/app/i18n/el/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/en-US/index.php b/app/i18n/en-US/index.php
index a65b752f7..d112d143e 100644
--- a/app/i18n/en-US/index.php
+++ b/app/i18n/en-US/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// IGNORE
 			'id_desc' => 'Freshly received first',	// IGNORE
+			'length_asc' => 'Content length 1→9',	// IGNORE
+			'length_desc' => 'Content length 9→1',	// IGNORE
 			'link_asc' => 'Link A→Z',	// IGNORE
 			'link_desc' => 'Link Z→A',	// IGNORE
 			'rand' => 'Random order',	// IGNORE
diff --git a/app/i18n/en/index.php b/app/i18n/en/index.php
index 47e89f148..d0a39a7a5 100644
--- a/app/i18n/en/index.php
+++ b/app/i18n/en/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',
 			'id_desc' => 'Freshly received first',
+			'length_asc' => 'Content length 1→9',
+			'length_desc' => 'Content length 9→1',
 			'link_asc' => 'Link A→Z',
 			'link_desc' => 'Link Z→A',
 			'rand' => 'Random order',
diff --git a/app/i18n/es/index.php b/app/i18n/es/index.php
index 6ace58d64..73a5e3e39 100644
--- a/app/i18n/es/index.php
+++ b/app/i18n/es/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/fa/index.php b/app/i18n/fa/index.php
index 588bfba4b..65f331a5f 100644
--- a/app/i18n/fa/index.php
+++ b/app/i18n/fa/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'آخرین مورد، به تازه گی دریافت شد',
 			'id_desc' => 'نخستین مورد دریافت‌شده به تازگی',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'لینک A→Z',
 			'link_desc' => 'لینک Z→A',
 			'rand' => 'ترتیب تصادفی',
diff --git a/app/i18n/fi/index.php b/app/i18n/fi/index.php
index bcda1b982..311d13077 100644
--- a/app/i18n/fi/index.php
+++ b/app/i18n/fi/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Uusimmat viimeisenä',
 			'id_desc' => 'Uusimmat ensimmäisenä',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Linkki A→Ö',
 			'link_desc' => 'Linkki Ö→A',
 			'rand' => 'Satunnainen järjestys',
diff --git a/app/i18n/fr/index.php b/app/i18n/fr/index.php
index ab7bc08cb..f51a09ba6 100644
--- a/app/i18n/fr/index.php
+++ b/app/i18n/fr/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Reçus récemment en dernier',
 			'id_desc' => 'Reçus récemment en premier',
+			'length_asc' => 'Longueur du contenu 1→9',
+			'length_desc' => 'Longueur du contenu 9→1',
 			'link_asc' => 'Lien A→Z',
 			'link_desc' => 'Lien Z→A',
 			'rand' => 'Ordre aléatoire',
diff --git a/app/i18n/he/index.php b/app/i18n/he/index.php
index 16037eba3..d52319cba 100644
--- a/app/i18n/he/index.php
+++ b/app/i18n/he/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/hu/index.php b/app/i18n/hu/index.php
index 36c945f78..2345f1249 100644
--- a/app/i18n/hu/index.php
+++ b/app/i18n/hu/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Frissen fogadott utoljára',
 			'id_desc' => 'Frissen fogadott először',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// IGNORE
 			'link_desc' => 'Link Z→A',	// IGNORE
 			'rand' => 'Véletlen sorrend',
diff --git a/app/i18n/id/index.php b/app/i18n/id/index.php
index 7b14a9ee8..c06292759 100644
--- a/app/i18n/id/index.php
+++ b/app/i18n/id/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Yang baru diterima terakhir',
 			'id_desc' => 'Yang baru diterima paling awal',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Tautan A→Z',
 			'link_desc' => 'Tautan Z→A',
 			'rand' => 'Acak',
diff --git a/app/i18n/it/index.php b/app/i18n/it/index.php
index 12f2a9a72..1c9a3b2f1 100644
--- a/app/i18n/it/index.php
+++ b/app/i18n/it/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Dal meno recente',
 			'id_desc' => 'Dal più recente',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// IGNORE
 			'link_desc' => 'Link Z→A',	// IGNORE
 			'rand' => 'Ordine casuale',
diff --git a/app/i18n/ja/index.php b/app/i18n/ja/index.php
index 831029974..a0879d7b8 100644
--- a/app/i18n/ja/index.php
+++ b/app/i18n/ja/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => '新着を最後に並べる',
 			'id_desc' => '新着を最初に並べる',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'リンクURL順 A→Z',
 			'link_desc' => 'リンクURL順 Z→A',
 			'rand' => 'ランダムに並べる',
diff --git a/app/i18n/ko/index.php b/app/i18n/ko/index.php
index c54bbe7c2..bce49f545 100644
--- a/app/i18n/ko/index.php
+++ b/app/i18n/ko/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/lv/index.php b/app/i18n/lv/index.php
index f985e67c3..db22eda5b 100644
--- a/app/i18n/lv/index.php
+++ b/app/i18n/lv/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/nl/index.php b/app/i18n/nl/index.php
index ea7582845..2993a43b6 100644
--- a/app/i18n/nl/index.php
+++ b/app/i18n/nl/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Nieuw ontvangen laatst',
 			'id_desc' => 'Nieuw ontvangen eerst',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// IGNORE
 			'link_desc' => 'Link Z→A',	// IGNORE
 			'rand' => 'Willekeurige volgorde',
diff --git a/app/i18n/oc/index.php b/app/i18n/oc/index.php
index dce2e1ac6..8f28b6ca6 100644
--- a/app/i18n/oc/index.php
+++ b/app/i18n/oc/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/pl/index.php b/app/i18n/pl/index.php
index 8cf9d999b..a335a2f22 100644
--- a/app/i18n/pl/index.php
+++ b/app/i18n/pl/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Najpożniej otrzymane',
 			'id_desc' => 'Najwcześniej otrzymane',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Odnośnik A→Z',
 			'link_desc' => 'Odnośnik Z→A',
 			'rand' => 'Losowa kolejność',
diff --git a/app/i18n/pt-BR/index.php b/app/i18n/pt-BR/index.php
index 777e5f895..787dea15d 100644
--- a/app/i18n/pt-BR/index.php
+++ b/app/i18n/pt-BR/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/pt-PT/index.php b/app/i18n/pt-PT/index.php
index c57d6907f..127bef26f 100644
--- a/app/i18n/pt-PT/index.php
+++ b/app/i18n/pt-PT/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/ru/index.php b/app/i18n/ru/index.php
index d341d5712..96d43b733 100644
--- a/app/i18n/ru/index.php
+++ b/app/i18n/ru/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/sk/index.php b/app/i18n/sk/index.php
index 87a352449..d4aa174b1 100644
--- a/app/i18n/sk/index.php
+++ b/app/i18n/sk/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/tr/index.php b/app/i18n/tr/index.php
index 38fc548a9..50b81b517 100644
--- a/app/i18n/tr/index.php
+++ b/app/i18n/tr/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Son alınanlar en sonda',
 			'id_desc' => 'Son alınanlar başta',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Bağlantı A→Z',
 			'link_desc' => 'Bağlantı Z→A',
 			'rand' => 'Rastgele sıralama',
diff --git a/app/i18n/uk/index.php b/app/i18n/uk/index.php
index 533b51b80..0922444a6 100644
--- a/app/i18n/uk/index.php
+++ b/app/i18n/uk/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Спершу найдавніше отримані',
 			'id_desc' => 'Спершу щойно отримані',
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Посилання А→Я',
 			'link_desc' => 'Посилання Я→А',
 			'rand' => 'Довільний порядок',
diff --git a/app/i18n/zh-CN/index.php b/app/i18n/zh-CN/index.php
index 87aaa8399..ae134e954 100644
--- a/app/i18n/zh-CN/index.php
+++ b/app/i18n/zh-CN/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO
diff --git a/app/i18n/zh-TW/index.php b/app/i18n/zh-TW/index.php
index 1a1b52ba4..45bf17c1b 100644
--- a/app/i18n/zh-TW/index.php
+++ b/app/i18n/zh-TW/index.php
@@ -89,6 +89,8 @@ return array(
 			),
 			'id_asc' => 'Freshly received last',	// TODO
 			'id_desc' => 'Freshly received first',	// TODO
+			'length_asc' => 'Content length 1→9',	// TODO
+			'length_desc' => 'Content length 9→1',	// TODO
 			'link_asc' => 'Link A→Z',	// TODO
 			'link_desc' => 'Link Z→A',	// TODO
 			'rand' => 'Random order',	// TODO