$order .= ' DESC' if $order eq 'hit_us';
my $members = $dbh->prepare(q{
- SELECT coords(x,y,z), nick, ruler, planet, race, size, score, value, xp
+ SELECT id, coords(x,y,z), nick, ruler, planet, race, size, score, value, xp
,planet_status,hit_us, sizerank, scorerank, valuerank, xprank
FROM current_planet_stats p
WHERE p.alliance_id = ?
,((resources/planets*scoremem)/300 + (hidden/planets*scoremem)/100)::bigint AS scoregain2
,(score + (resources/planets*scoremem)/300
+ (hidden/planets*scoremem)/100)::bigint AS nscore2
- ,((s.size::int8*(1400-tick())*250)/100 + score + (resources/planets*scoremem)/300
+ ,((s.size::int8*(1150-tick())*250)/100 + score + (resources/planets*scoremem)/300
+ (hidden/planets*scoremem)/100)::bigint AS nscore3
- ,(s.size::int8*(1400-tick())*250)/100 AS scoregain3
- FROM (SELECT alliance_id AS id,sum(metal+crystal+eonium) AS resources, sum(hidden) AS hidden, count(*) AS planets
- FROM planets p join planet_scans c ON p.id = c.planet GROUP by alliance_id) r
- NATURAL JOIN alliances a
+ ,(s.size::int8*(1150-tick())*250)/100 AS scoregain3
+ FROM (SELECT alliance_id AS id,sum(metal+crystal+eonium) AS resources
+ , sum(hidden) AS hidden, count(*) AS planets
+ FROM planets p join current_planet_scans c ON p.id = c.planet
+ GROUP by alliance_id
+ ) r
+ NATURAL JOIN alliances a
LEFT OUTER JOIN (SELECT *,LEAST(members,60) AS scoremem FROM alliance_stats
WHERE tick = (SELECT max(tick) FROM alliance_stats)) s ON a.id = s.id
ORDER BY $order