X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FRoot.pm;h=a1eac62c9f76b8cf7bd932a97dd14a4ba56d4c83;hb=48c13dfb589d4f8f83d8fdc2df772c32d4145659;hp=6685c8537c812e0a41624c6808c24de5dd6625f0;hpb=49c23244b1ba61909b726bb9189665a33027a1af;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/Root.pm b/lib/NDWeb/Controller/Root.pm index 6685c85..a1eac62 100644 --- a/lib/NDWeb/Controller/Root.pm +++ b/lib/NDWeb/Controller/Root.pm @@ -5,6 +5,8 @@ use warnings; use parent 'Catalyst::Controller'; use ND::Include; +use Geo::IP; + # # Sets the actions in this controller to be registered with no prefix @@ -30,34 +32,58 @@ NDWeb::Controller::Root - Root Controller for NDWeb sub index : Local Path Args(0) { my ( $self, $c ) = @_; + + $c->res->redirect($c->uri_for('/wiki')); } sub default : Path { my ( $self, $c ) = @_; - $c->res->body( 'Page not found' ); $c->response->status(404); } sub login : Local { my ($self, $c) = @_; + if ($c->login){ - $c->res->redirect($c->uri_for('index')); + 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; } - - $c->stash(error => 'Bad password'); - $c->stash(template => 'index.tt2'); - $c->forward('index'); } sub logout : Local { my ($self, $c) = @_; $c->logout; + $c->delete_session("logout"); $c->res->redirect($c->uri_for('index')); } -#sub begin : private { -#} +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) = @_; @@ -78,7 +104,23 @@ ORDER BY r.tick+c.wave,x,y,z}); push @targets, $target; } - $c->stash(targets => \@targets); + $c->stash(claimedtargets => \@targets); +} + +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)}); + $query->execute; + while (my $ally = $query->fetchrow_hashref){ + push @alliances,$ally; + } + $c->stash(alliances => \@alliances); +} + +sub sslurl { + return $_[0]; } sub auto : Private { @@ -87,9 +129,12 @@ sub auto : Private { $c->stash(dbh => $dbh); + $c->stash(sslurl => \&sslurl); + $dbh->do(q{SET timezone = 'GMT'}); $c->stash(TICK =>$dbh->selectrow_array('SELECT tick()',undef)); + $c->stash(STICK =>$dbh->selectrow_array('SELECT max(tick) FROM planet_stats',undef)); $c->stash->{game}->{tick} = $c->stash->{TICK}; if ($c->user_exists){ @@ -103,9 +148,6 @@ sub auto : Private { sub access_denied : Private { my ($self, $c, $action) = @_; - $c->log->debug('moo' . $action); - - # Set the error message $c->stash->{template} = 'access_denied.tt2'; } @@ -121,6 +163,16 @@ sub end : ActionClass('RenderView') { my $dbh = $c ->model; + if (scalar @{ $c->error } ){ + if ($c->error->[0] =~ m/Can't call method "id" on an undefined value at/){ + $c->stash->{template} = 'access_denied.tt2'; + $c->clear_errors; + }elsif ($c->error->[0] =~ m/Missing roles: /){ + $c->stash->{template} = 'access_denied.tt2'; + $c->clear_errors; + } + } + if ($c->user_exists && $c->res->status == 200){ my $fleetupdate = 0; if ($c->check_user_roles(qw/member_menu/)){ @@ -130,7 +182,8 @@ sub end : ActionClass('RenderView') { $fleetupdate = 0 unless defined $fleetupdate; } - my ($unread,$newposts) = $dbh->selectrow_array(unread_query,undef,$c->user->id) or die $dbh->errstr; + my ($unread,$newposts) = $dbh->selectrow_array(q{SELECT * FROM unread_posts($1)} + ,undef,$c->user->id); $c->stash(user => { id => $c->user->id, @@ -145,6 +198,15 @@ sub end : ActionClass('RenderView') { || $c->check_user_roles(qw/no_fleet_update/)))), $c->forward('listTargets'); } + if ($c->res->status == 200){ + my $birthdays = $dbh->prepare(q{SELECT username + ,date_part('year',age(birthday)) AS age + FROM users WHERE birthday IS NOT NULL + AND mmdd(birthday) = mmdd(CURRENT_DATE) + }); + $birthdays->execute; + $c->stash(birthdays => $birthdays->fetchall_arrayref({})); + } } =head1 AUTHOR