update search

diff --git a/mubot4fb.pl b/mubot4fb.pl
index 1c20ee2..ad891a0 100755 (executable)
--- a/mubot4fb.pl
+++ b/mubot4fb.pl
@@ -126,7 +126,9 @@ sub _db_delete {
 sub _db_search {
        my ($me, $word) = @_;
 
-       my $sth = $me->{dbh}->prepare('select * from posts where match(prefix,uri,suffix) against(?) order by post_time desc limit 1000');
+       $column ? $word =~ !://! ? 'uri' : 'path';
+
+       my $sth = $me->{dbh}->prepare('select * from posts where match(prefix,'.$column.',suffix) against(?) order by post_time desc limit 1000');
        $sth->bind_param(1, $word, SQL_VARCHAR);
        $sth->execute();