X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FWeb%2FPages%2FMain.pm;fp=ND%2FWeb%2FPages%2FMain.pm;h=4fa2a316acfe8d758806b9ed534b1661b7e5915e;hb=787cf3bba39678ead6b902b28e497f2f9a10ec6f;hp=655ed4014ccd70c7b10abab74093cbf6a4a2fbfd;hpb=31002632ecb3035490e5074455282cd1fba4abf6;p=ndwebbie.git diff --git a/ND/Web/Pages/Main.pm b/ND/Web/Pages/Main.pm index 655ed40..4fa2a31 100644 --- a/ND/Web/Pages/Main.pm +++ b/ND/Web/Pages/Main.pm @@ -86,9 +86,14 @@ sub render_body { $DBH->commit or $error .= '

'.$DBH->errstr.'

'; } } - if (param('sms')){ my $query = $DBH->prepare('UPDATE users SET sms = ? WHERE uid = ?'); + if (param('sms')){ + my $query = $DBH->prepare('UPDATE users SET sms = ? WHERE uid = ?'); $query->execute(escapeHTML(param('sms')),$ND::UID); } + if (param('hostname')){ + my $query = $DBH->prepare('UPDATE users SET hostmask = ? WHERE uid = ?'); + $query->execute(escapeHTML(param('hostname')),$ND::UID); + } if ($self->isMember() && !$self->{PLANET} && defined param('planet') && (param('planet') =~ m/(\d+)(?: |:)(\d+)(?: |:)(\d+)/)){ my $query = $DBH->prepare(q{ UPDATE users SET planet = @@ -107,9 +112,9 @@ sub render_body { $BODY->param(Groups => \@groups); - my $query = $DBH->prepare(q{SELECT planet,defense_points,attack_points,scan_points,humor_points, (attack_points+defense_points+scan_points/20) as total_points, sms,rank FROM users WHERE uid = ?}); + my $query = $DBH->prepare(q{SELECT planet,defense_points,attack_points,scan_points,humor_points, (attack_points+defense_points+scan_points/20) as total_points, sms,rank,hostmask FROM users WHERE uid = ?}); - my ($planet,$defense_points,$attack_points,$scan_points,$humor_points,$total_points,$sms,$rank) = $DBH->selectrow_array($query,undef,$ND::UID); + my ($planet,$defense_points,$attack_points,$scan_points,$humor_points,$total_points,$sms,$rank,$hostname) = $DBH->selectrow_array($query,undef,$ND::UID); $self->{PLANET} = $planet unless $self->{PLANET}; @@ -173,6 +178,7 @@ ORDER BY f.fleet $BODY->param(Fleets => \@fleets); $BODY->param(SMS => $sms); + $BODY->param(Hostname => $hostname); $BODY->param(Error => $error); return $BODY; }