X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FWeb%2FPages%2FMain.pm;h=0a795d0db6eab04086113e769af41109427162ad;hb=1dd5131f6b4484797de54bd9bd2d67220c921608;hp=655ed4014ccd70c7b10abab74093cbf6a4a2fbfd;hpb=b9ef107dd273c96b9cc10214de41323b5d0925a5;p=ndwebbie.git diff --git a/ND/Web/Pages/Main.pm b/ND/Web/Pages/Main.pm index 655ed40..0a795d0 100644 --- a/ND/Web/Pages/Main.pm +++ b/ND/Web/Pages/Main.pm @@ -47,15 +47,19 @@ sub render_body { ($id) = $DBH->selectrow_array($fleet,undef,$ND::UID); } my $delete = $DBH->prepare("DELETE FROM fleet_ships WHERE fleet = ?"); - $delete->execute($id); my $insert = $DBH->prepare('INSERT INTO fleet_ships (fleet,ship,amount) VALUES (?,?,?)'); $fleet = param('fleet'); $fleet =~ s/,//g; + my $match = 0; while ($fleet =~ m/((?:[A-Z][a-z]+ )*[A-Z][a-z]+)\s+(\d+)/g){ + unless($match){ + $match = 1; + $delete->execute($id); + } $insert->execute($id,$1,$2) or $error .= '

'.$DBH->errstr.'

'; } $fleet = $DBH->prepare('UPDATE fleets SET landing_tick = tick() WHERE id = ?'); - $fleet->execute($id); + $fleet->execute($id) if $match; $DBH->commit; }elsif (param('cmd') eq 'Recall Fleets'){ $DBH->begin_work; @@ -86,9 +90,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 +116,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 +182,7 @@ ORDER BY f.fleet $BODY->param(Fleets => \@fleets); $BODY->param(SMS => $sms); + $BODY->param(Hostname => $hostname); $BODY->param(Error => $error); return $BODY; }