+sub login : Local {
+ my ($self, $c) = @_;
+
+ if ($c->login){
+ my $gi = Geo::IP->new(GEOIP_STANDARD);
+ my $country = $gi->country_code_by_addr($c->req->address) || '??';
+
+ my $remember = 0;
+ if ($c->req->param('remember')){
+ $c->session_time_to_live( 604800 ); # expire in one week.
+ $remember = 1;
+ }
+ my $log = $c->model->prepare(q{INSERT INTO session_log
+ (uid,time,ip,country,session,remember)
+ VALUES ($1,NOW(),$2,$3,$4,$5)
+ });
+ $log->execute($c->user->id,$c->req->address
+ ,$country,$c->sessionid,$remember);
+
+ my $ref = $c->req->referer;
+ $ref =~ s/^http:/https:/ unless $c->debug;
+ $c->res->redirect($ref);
+ return;
+ }
+}
+
+sub logout : Local {
+ my ($self, $c) = @_;
+ $c->logout;
+ $c->delete_session("logout");
+ $c->res->redirect($c->uri_for('index'));
+}
+
+sub begin : Private {
+ my ($self, $c) = @_;
+
+ $c->res->header( 'Cache-Control' =>
+ 'no-store, no-cache, must-revalidate,'.
+ 'post-check=0, pre-check=0, max-age=0'
+ );
+ $c->res->header( 'Pragma' => 'no-cache' );
+ $c->res->header( 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT' );
+}
+
+sub listTargets : Private {
+ my ($self, $c) = @_;
+
+ my $dbh = $c ->model;
+
+ my $query = $dbh->prepare(q{SELECT t.id, r.id AS raid, r.tick+c.wave-1 AS landingtick,
+ (released_coords AND old_claim(timestamp)) AS released_coords, coords(x,y,z),c.launched,c.wave,c.joinable
+FROM raid_claims c
+ JOIN raid_targets t ON c.target = t.id
+ JOIN raids r ON t.raid = r.id
+ JOIN current_planet_stats p ON t.planet = p.id
+WHERE c.uid = $1 AND r.tick+c.wave > tick() AND r.open AND not r.removed
+ORDER BY r.tick+c.wave,x,y,z});
+ $query->execute($c->user->id) or die $dbh->errstr;
+ my @targets;
+ while (my $target = $query->fetchrow_hashref){
+ push @targets, $target;
+ }
+
+ $c->stash(claimedtargets => \@targets);
+}
+
+sub listAlliances : Private {