Greater / less than table data search operators

diff --git a/mysql/CHANGELOG b/mysql/CHANGELOG
index e5ec3ad..e79d337 100644 (file)
--- a/mysql/CHANGELOG
+++ b/mysql/CHANGELOG
@@ -92,3 +92,5 @@ The information_schema database is no longer included when backing up all databa
 Added a collation order field to the database creation form.
 Added an option to the backup form to do backup in a single transaction, for InnoDB tables.
 The default MySQL table type can now be set on the MySQL Server Configuration page.
+---- Changes since 1.510 ----
+Added greater than / less than selectors to the table data search form.

diff --git a/mysql/lang/en b/mysql/lang/en
index de78ae4..033f9fe 100644 (file)
--- a/mysql/lang/en
+++ b/mysql/lang/en
@@ -194,6 +194,8 @@ view_match0=contains
 view_match1=matches
 view_match2=doesn't contain
 view_match3=doesn't match
+view_match4=greater than
+view_match5=less than
 view_searchok=Search
 view_searchhead=Search results for $1 in field $2 ..
 view_searchhead2=Advanced search results on $1 fields ..

diff --git a/mysql/view-lib.pl b/mysql/view-lib.pl
index 6fd6fa7..6b2c623 100755 (executable)
--- a/mysql/view-lib.pl
+++ b/mysql/view-lib.pl
@@ -86,7 +86,10 @@ local $qu = $module_name eq "mysql" ? '"' : "'";
 return $match == 0 ? "like $qu%$for%$qu" :
        $match == 1 ? "like $qu$for$qu" :
        $match == 2 ? "not like $qu%$for%$qu" :
-       $match == 3 ? "not like $qu$for$qu" : " = \"\"";
+       $match == 3 ? "not like $qu$for$qu" :
+       $match == 4 ? "> $for" :
+       $match == 5 ? "< $for" :
+                    " = \"\"";
 }
 
 1;

diff --git a/mysql/view_table.cgi b/mysql/view_table.cgi
index b09f887..4f9ea3a 100755 (executable)
--- a/mysql/view_table.cgi
+++ b/mysql/view_table.cgi
@@ -437,7 +437,7 @@ if (!$in{'field'} && $total > $displayconfig{'perpage'}) {
        $sel = &ui_select("field", undef,
                        [ map { [ $_->{'field'}, $_->{'field'} ] } @str ]);
        $match = &ui_select("match", 0,
-                       [ map { [ $_, $text{'view_match'.$_} ] } (0.. 3) ]);
+                       [ map { [ $_, $text{'view_match'.$_} ] } (0.. 5) ]);
        print "<td>",&text('view_search2', "<input name=for size=20>", $sel,
                           $match);
        print "&nbsp;&nbsp;",

diff --git a/postgresql/CHANGELOG b/postgresql/CHANGELOG
index 1b635af..ce13a75 100644 (file)
--- a/postgresql/CHANGELOG
+++ b/postgresql/CHANGELOG
@@ -69,3 +69,5 @@ Improve support for PostgreSQL 8.3 on Ubuntu 8.04.
 ---- Changes since 1.440 ----
 Re-wrote the entire user interface to use Webmin's new UI library, for a more consistent and themable look.
 Added a history of previous commands to the Execute SQL page.
+---- Changes since 1.510 ----
+Added greater than / less than selectors to the table data search form.

diff --git a/postgresql/lang/en b/postgresql/lang/en
index cabd8a6..8ecf1bb 100644 (file)
--- a/postgresql/lang/en
+++ b/postgresql/lang/en
@@ -185,6 +185,8 @@ view_match0=contains
 view_match1=matches
 view_match2=doesn't contain
 view_match3=doesn't match
+view_match4=greater than
+view_match5=less than
 view_searchok=Search
 view_searchhead=Search results for $1 in field $2 ..
 view_searchhead2=Advanced search results on $1 fields ..