From e654b3b4861dec789680e63218431b079fc7d9cf Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Wed, 4 Apr 2018 03:42:36 +0100
Subject: [PATCH] lib/php/db/table.php

---
 lib/php/db/table.php   | 3 +--
 lib/postgres/grant.sql | 3 ---
 share/db/update.sh     | 2 +-
 3 files changed, 2 insertions(+), 6 deletions(-)
 delete mode 100644 lib/postgres/grant.sql

diff --git a/lib/php/db/table.php b/lib/php/db/table.php
index c1c77343..f7d7811a 100644
--- a/lib/php/db/table.php
+++ b/lib/php/db/table.php
@@ -728,7 +728,7 @@ Class Table extends nb {
 
 		if ($prev>=0) $html .= '<span class="prev"><a href="'.$this->url_list('limit',preg_replace('/^0,/','',"$prev,$y")).'">&lt;&lt;</a></span>&nbsp;';
 
-		$html .= '<span class="count">'.($tot ? ($x+1) : 0).' - '.( $count<($x+$y) ? $count : ($x+$y) ).' / '.$tot.' results</span>';
+		$html .= '<span class="count">'.($tot ? ($x+1) : 0).' - '.( $count<($x+$y) ? $count : ($x+$y) ).' / '.$tot.'</span>';
 
 		if ($next<$tot) $html .= '&nbsp;<span class="prev"><a href="'.$this->url_list('limit',"$next,$y").'">&gt;&gt;</a></span>';
 
@@ -1331,7 +1331,6 @@ Class Table extends nb {
 			$this->tot = $opt['tot'] = $tot;
 
 		} # < is_html
-		$this->tot = $opt['tot'] = $count;
 
 		if ($count === 0 and !$format) {
 			echo $this->{"rows_begin_$format"}($fields,$opt);
diff --git a/lib/postgres/grant.sql b/lib/postgres/grant.sql
deleted file mode 100644
index b7a2bed0..00000000
--- a/lib/postgres/grant.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-GRANT ALL ON ALL TABLES IN SCHEMA public TO www;
-GRANT ALL ON ALL TABLES IN SCHEMA public TO root;
-GRANT ALL ON ALL TABLES IN SCHEMA public TO nico;
diff --git a/share/db/update.sh b/share/db/update.sh
index 04a510e1..7bab10cf 100755
--- a/share/db/update.sh
+++ b/share/db/update.sh
@@ -13,4 +13,4 @@ cd "$(dirname "$0")" && (
 	nb_api '/pub/dump/sqlite?table-name=!~^(zipcode|geo)'
 	echo 'VACUUM;'
 
-) | sqlite3 "nb.db"
+) | sqlite3 "/tmp/nb.db"
-- 
2.47.3