$c->stash(comma => \&comma_value);
$c->stash(u => $dbh->selectrow_hashref(q{SELECT planet,defense_points
,attack_points,scan_points,humor_points
- , (attack_points+defense_points+scan_points/20) as total_points
+ , (attack_points+defense_points+scan_points/20)::NUMERIC(5,1) as total_points
, sms,rank,hostmask FROM users WHERE uid = ?
},undef,$c->user->id)
);
(uid,channel,message) VALUES($1,$2,$3)
});
$query->execute($c->user->id,$c->req->param('channel'),$c->req->param('message'));
+ system 'killall','-USR1', 'irssi';
$c->flash(reply => "Msg sent to: ".$c->req->param('channel'));
$c->res->redirect($c->uri_for('ircrequest'));
my $query = $dbh->prepare(qq{SELECT username,defense_points,attack_points
,scan_points,humor_points
- ,(attack_points+defense_points+scan_points/20) as total_points
+ ,(attack_points+defense_points+scan_points/20)::NUMERIC(4,0) as total_points
, count(NULLIF(rc.launched,FALSE)) AS raid_points
FROM users u LEFT OUTER JOIN raid_claims rc USING (uid)
WHERE uid IN (SELECT uid FROM groupmembers WHERE gid = 2)