diff options
author | Aleksey Lim <alsroot@member.fsf.org> | 2010-09-12 15:56:20 (GMT) |
---|---|---|
committer | Aleksey Lim <alsroot@member.fsf.org> | 2010-09-12 15:56:20 (GMT) |
commit | e007ec92c865b8765485007c6264558d22a5994c (patch) | |
tree | 4678487df94af3934652a375613eca304db27d60 | |
parent | 19f49247d9fdd2774b32f1ccaeab61765fe816fa (diff) |
Use LIKE for searching; decrease days per page to 7
-rwxr-xr-x | cgi/search.pl | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/cgi/search.pl b/cgi/search.pl index ce7663e..2c2ca8d 100755 --- a/cgi/search.pl +++ b/cgi/search.pl @@ -19,7 +19,7 @@ use utf8; my $conf = Config::File::read_config_file("cgi.conf"); my $base_url = $conf->{BASE_URL} || "/"; -my $days_per_page = 10; +my $days_per_page = 7; my $lines_per_day = 50; # not yet used my $lines_of_context = 2; @@ -86,12 +86,12 @@ if (length($nick) or length($qs)){ my @sql_conds = ('channel = ? AND NOT spam'); my @args = ($channel); if (length $nick){ - push @sql_conds, '(nick = ? OR nick = ?)'; - push @args, $nick, "* $nick"; + push @sql_conds, '(nick = ? OR nick LIKE ?)'; + push @args, $nick, "% $nick"; } if (length $qs) { - push @sql_conds, 'MATCH(line) AGAINST(?)'; - push @args, $qs; + push @sql_conds, 'line LIKE ? AND nick != \'\''; + push @args, "%$qs%"; } my $sql_cond = 'WHERE ' . join(' AND ', @sql_conds); |