Use % for any host

diff --git a/mysql/save_host.cgi b/mysql/save_host.cgi
index 820bb6e..4c1822a 100755 (executable)
--- a/mysql/save_host.cgi
+++ b/mysql/save_host.cgi
@@ -42,7 +42,7 @@ else {
                        }
                $sql = sprintf "insert into host (%s) values ('%s', '%s', %s)",
                        join(",", map { $desc[$_]->{'field'} } (0 .. &host_priv_cols()+2-1)),
-                       $in{'host_def'} ? '' : $in{'host'}, $db,
+                       $in{'host_def'} ? '%' : $in{'host'}, $db,
                        join(",", @yesno);
                }
        else {
@@ -53,7 +53,7 @@ else {
                        }
                $sql = sprintf "update host set host = '%s', db = '%s', %s ".
                               "where host = '%s' and db = '%s'",
-                       $in{'host_def'} ? '' : $in{'host'}, $db,
+                       $in{'host_def'} ? '%' : $in{'host'}, $db,
                        join(" , ", @yesno), $in{'oldhost'}, $in{'olddb'};
                }
        &execute_sql_logged($master_db, $sql);

diff --git a/mysql/save_user.cgi b/mysql/save_user.cgi
index 60221c5..a691911 100755 (executable)
--- a/mysql/save_user.cgi
+++ b/mysql/save_user.cgi
@@ -22,7 +22,7 @@ else {
 
        map { $perms[$_]++ } split(/\0/, $in{'perms'});
        @desc = &table_structure($master_db, 'user');
-       $host = $in{'host_def'} ? '' : $in{'host'};
+       $host = $in{'host_def'} ? '%' : $in{'host'};
        $user = $in{'mysqluser_def'} ? '' : $in{'mysqluser'};
        if ($in{'new'}) {
                # Create a new user