Show birthdays in menu

[ndwebbie.git] / lib / NDWeb / Controller / Root.pm

diff --git a/lib/NDWeb/Controller/Root.pm b/lib/NDWeb/Controller/Root.pm
index 16f0e8cb8719db5ddd900f35d8613f83ddc806fc..a1eac62c9f76b8cf7bd932a97dd14a4ba56d4c83 100644 (file)
--- 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,29 +32,45 @@ 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'));
 }
 
@@ -89,15 +107,34 @@ ORDER BY r.tick+c.wave,x,y,z});
        $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 {
        my ($self, $c) = @_;
        my $dbh = $c ->model;
 
        $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){
@@ -111,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';
 
 }
@@ -129,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/)){
@@ -138,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,
@@ -153,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