- $target->{scorebash} = 'bash' if ($target->{score}/$planet->{score} < 0.4);
+ $target->{cap} = min(0.25,0.25 * pow($target->{value}/$planet->{value} , 0.5));
+ $target->{scorebash} = 'bash' if ($target->{score}/$planet->{score} < 0.6);
my $unitscans = $dbh->prepare(q{
SELECT DISTINCT ON (name) fid, name, tick, amount
my $unitscans = $dbh->prepare(q{
SELECT DISTINCT ON (name) fid, name, tick, amount
my $xp = 0;
if ($planet && $planet->{score}){
$xp = pa_xp($roids,$planet->{score},$planet->{value},$target->{score},$target->{value});
my $xp = 0;
if ($planet && $planet->{score}){
$xp = pa_xp($roids,$planet->{score},$planet->{value},$target->{score},$target->{value});
my $targetquery = $dbh->prepare(qq{SELECT r.id,coords(x,y,z),comment,size
,score,value,race,planet_status,relationship,r.planet, s.scans
my $targetquery = $dbh->prepare(qq{SELECT r.id,coords(x,y,z),comment,size
,score,value,race,planet_status,relationship,r.planet, s.scans
FROM raid_targets r
JOIN current_planet_stats p ON p.id = r.planet
LEFT OUTER JOIN ( SELECT planet, array_accum(s::text) AS scans
FROM raid_targets r
JOIN current_planet_stats p ON p.id = r.planet
LEFT OUTER JOIN ( SELECT planet, array_accum(s::text) AS scans
WHERE r.raid = ?
GROUP BY r.id,x,y,z,comment,size,score,value,race
,planet_status,relationship,comment,r.planet, s.scans
WHERE r.raid = ?
GROUP BY r.id,x,y,z,comment,size,score,value,race
,planet_status,relationship,comment,r.planet, s.scans
for my $i (1 .. $target->{waves}){
$claims->execute($target->{id},$i);
my $claimers;
for my $i (1 .. $target->{waves}){
$claims->execute($target->{id},$i);
my $claimers;
my ($self, $c, $alliances, $order) = @_;
my $dbh = $c->model;
my ($self, $c, $alliances, $order) = @_;
my $dbh = $c->model;
$c->stash(allies => $alliances);
$alliances ||= '';
my @alliances = split /,/, $alliances;
$c->stash(allies => $alliances);
$alliances ||= '';
my @alliances = split /,/, $alliances;
SELECT p.id,p.value,p.score,metal_roids, crystal_roids, eonium_roids, ds.total, race
FROM raids r
JOIN raid_targets rt ON r.id = rt.raid
SELECT p.id,p.value,p.score,metal_roids, crystal_roids, eonium_roids, ds.total, race
FROM raids r
JOIN raid_targets rt ON r.id = rt.raid