From 0764a20a19fdbd3e9dfbca45e7d42b8a861cde1c Mon Sep 17 00:00:00 2001
From: Jakub Vrana <jakub@vrana.cz>
Date: Thu, 19 Jun 2025 09:34:55 +0200
Subject: [PATCH] New plugin: Display row numbers in select (fix #1106)

---
 CHANGELOG.md            |  1 +
 plugins/row-numbers.php | 24 ++++++++++++++++++++++++
 2 files changed, 25 insertions(+)
 create mode 100644 plugins/row-numbers.php

diff --git a/CHANGELOG.md b/CHANGELOG.md
index 168a8959..dd7bc56a 100644
--- a/CHANGELOG.md
+++ b/CHANGELOG.md
@@ -13,6 +13,7 @@
 - PostgreSQL 11-: Avoid duplicate oid in table status (bug #1089)
 - Elasticsearch: Support dropping aliases
 - Plugins: Methods processList() and killProcess()
+- New plugin: Display row numbers in select (bug #1106)
 
 ## Adminer 5.3.0 (released 2025-05-04)
 - Align numeric functions right
diff --git a/plugins/row-numbers.php b/plugins/row-numbers.php
new file mode 100644
index 00000000..64cf4dc3
--- /dev/null
+++ b/plugins/row-numbers.php
@@ -0,0 +1,24 @@
+<?php
+
+/** Display row numbers in select
+* @link https://www.adminer.org/plugins/#use
+* @author Jakub Vrana, https://www.vrana.cz/
+* @license https://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
+* @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
+*/
+class AdminerRowNumbers extends Adminer\Plugin {
+
+	function backwardKeys($table, $tableName) {
+		return array(1);
+	}
+
+	function backwardKeysPrint($backwardKeys, $row) {
+		static $n = $_GET["page"] * Adminer\adminer()->selectLimitProcess();
+		$n++;
+		echo "$n.\n";
+	}
+
+	protected $translations = array(
+		'cs' => array('' => 'Zobrazí čísla řádek ve výpisu'),
+	);
+}
-- 
2.39.5