sub _db_insert {
my ($me, $db_args) = @_;
- my ($scheme, $path) = split(!://!, $db_args->{uri});
+ my ($scheme, $path) = split(/:\/\//, $db_args->{uri});
my $sth = $me->{dbh}->prepare("insert into posts (submitter, fb_post_id, uri, prefix, suffix, scheme, path, post_time) values (?, ?, ?, ?, ?, ?)");
$sth->bind_param(1, $db_args->{submitter}, SQL_TEXT);
$sth->bind_param(2, $db_args->{fb_post_id}, SQL_BIGINT);
sub _db_search {
my ($me, $word) = @_;
- $column ? $word =~ !://! ? 'uri' : 'path';
+ $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);