mirror of
https://github.com/perlbot/perlbuut
synced 2025-06-07 18:55:44 -04:00
14 lines
400 B
Perl
14 lines
400 B
Perl
use DBI;
|
|
no warnings 'void';
|
|
sub {
|
|
my( $said, $pm ) = @_;
|
|
|
|
my $dbh = DBI->connect("dbi:SQLite:dbname=var/hosts.db");
|
|
|
|
my $recs = $dbh->selectall_arrayref( "SELECT * FROM hosts where nick = ?", {Slice=>{}}, $said->{body} );
|
|
|
|
print "$said->{body}: ", join ", ", map $_->{host}, @$recs;
|
|
};
|
|
|
|
__DATA__
|
|
nick_lookup <nickname>; returns all of the hostnames this bot has seen a particular nick name use.
|