sub index : Local Path Args(0) {
my ( $self, $c ) = @_;
- $c->visit('/wiki/index');
+ $c->visit('/wiki/main');
}
sub default : Path {
my ($self, $c) = @_;
if ($c->login){
- my $gi = Geo::IP->new(GEOIP_STANDARD);
+ my $gi = Geo::IP->new("/usr/share/GeoIP/GeoIP.dat");
my $country = $gi->country_code_by_addr($c->req->address) || '??';
my $remember = 0;
my ($self, $c) = @_;
my $dbh = $c->model;
+ $c->stash(template => 'default.tt2');
+
+ return unless $c->req->param('apiMsgId');
+
my $sms = $dbh->prepare(q{
UPDATE sms SET status = $2, cost = $3
,time = TIMESTAMP WITH TIME ZONE 'epoch' + $4 * INTERVAL '1 second'
,$c->req->param('charge')
,$c->req->param('timestamp'));
- $c->stash(template => 'default.tt2');
}
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
+ my $query = $dbh->prepare(q{SELECT t.id, r.id AS raid, r.tick+c.wave-1 AS landingtick,
+ 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
+ JOIN current_planet_stats p USING (pid)
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;
sub listAlliances : Private {
my ($self, $c) = @_;
my @alliances;
- push @alliances,{id => -1, name => ''};
- my $query = $c->model->prepare(q{SELECT id,name FROM alliances ORDER BY LOWER(name)});
+ push @alliances,{aid => '', alliance => ''};
+ my $query = $c->model->prepare(q{SELECT aid,alliance FROM alliances ORDER BY LOWER(alliance)});
$query->execute;
while (my $ally = $query->fetchrow_hashref){
push @alliances,$ally;
my $fleetupdate = 0;
if ($c->check_user_roles(qw/member_menu/)){
$fleetupdate = $dbh->selectrow_array(q{
-SELECT tick FROM fleets WHERE planet = ? AND tick > tick() - 24
+SELECT tick FROM fleets WHERE pid = ? AND tick > tick() - 24
AND mission = 'Full fleet' AND name IN ('Main','Advanced Unit');
},undef,$c->user->planet);
$fleetupdate = 0 unless defined $fleetupdate;
newposts => $newposts,
unreadposts => $unread
});
- $c->stash->{user}->{attacker} = $c->check_user_roles(qw/attack_menu/)
- && (!$c->check_user_roles(qw/member_menu/)
- || ($c->user->planet && (($c->stash->{TICK} - $fleetupdate < 24)
- || $c->check_user_roles(qw/no_fleet_update/)))),
+ $c->stash->{user}->{attacker} = $c->check_user_roles(qw/attack_menu/);
$c->forward('listTargets');
}
my $birthdays = $dbh->prepare(q{SELECT username