}else{
my $req = $c->model->prepare(q{
SELECT * FROM scan_requests
-WHERE uid = (SELECT uid FROM users WHERE hostmask ILIKE $1)
+WHERE uid = $1
AND pid = $2 AND type = $3 AND NOT sent
});
- $req->execute($c->host,$planet,$type);
+ $req->execute($c->uid,$planet,$type);
my $id;
if(my $scan = $req->fetchrow_hashref){
}else{
$req = $c->model->prepare(q{
INSERT INTO scan_requests (uid,nick,pid,type)
-VALUES((SELECT uid FROM users WHERE hostmask ILIKE $1),$2,$3,$4) RETURNING (id)
+VALUES($1,$2,$3,$4) RETURNING (id)
});
- $req->execute($c->host,$c->nick,$planet,$type);
+ $req->execute($c->uid,$c->nick,$planet,$type);
$id = $req->fetchrow;
}
if ($id){
- $c->message("msg $ND::scanchan"
+ $c->message(privmsg => $c->disp->targets->{scan}
,"<b>$id</b> http://game.planetarion.com/waves.pl?id=$typeid&x=$x&y=$y&z=$z"
. " ($x:$y:$z $type) | <".$c->nick."> $msg"
);
my ($self, $c, $msg) = @_;
my ($target,$mess) = $msg =~ /^(\S+) (.*)$/ or die 'ARGS';
- $c->message("msg $target", "<b>$mess</b> <c04>(reply with /msg "
+ $c->message(privmsg => $target, "<b>$mess</b> <c04>(reply with /msg "
.$c->channel.")</c>");
- $c->message("msg ".$c->channel, "<c03>$target << $mess</c>");
+ $c->message(privmsg => $c->channel, "<c03>$target << $mess</c>");
}
sub addscan
INSERT INTO scans (scan_id,tick,groupscan,uid) VALUES (LOWER($1),tick(),$2,COALESCE($3,-1))
});
my $user = $dbh->selectrow_hashref(q{SELECT uid,username, scan_points, tick()
- FROM users WHERE hostmask ILIKE ? },undef,$c->host);
+ FROM users WHERE uid = ? },undef,$c->uid);
my $groupscans = 0;
my $scans = 0;
eval {