X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=PA.pm;h=43e8e45c74ff5bf9cc0653d366485cfd6a03ded6;hb=474115c110e67e05dd2cf15dd7745570d9bc7bb7;hp=da637fc7ba20a3fcc3d935541e3594da02721da3;hpb=81822d07bee44db52925e34d2381a0328aa48b91;p=NDIRC.git

diff --git a/PA.pm b/PA.pm
index da637fc..43e8e45 100644
--- a/PA.pm
+++ b/PA.pm
@@ -38,10 +38,10 @@ sub checkPlanet {
 		$x = $1;
 		$y = $2;
 		$z = $3;
-	}elsif (officer() && defined $msg){
+	}elsif ((officer() || ia()) && defined $msg){
 		$nick = $msg;
 	}else{
-		$ND::server->command("notice $ND::nick usage .p X:Y:Z".(officer() ? ' or .p nick' : ''));
+		$ND::server->command("notice $ND::nick usage .p X:Y:Z".(officer() || ia() ? ' or .p nick' : ''));
 		return;
 	}
 	my $f = $ND::DBH->prepare(q{SELECT coords(x,y,z),ruler,planet,race,score,size,value,scorerank,sizerank,
@@ -54,7 +54,7 @@ sub checkPlanet {
 			$planet->{$_} = valuecolor(1,$planet->{$_});
 		}
 		my $ally = "";
-		if (officer() || dc()){
+		if (officer() || ia() || dc()){
 			$ally = "Alliance=$planet->{alliance} ($planet->{relationship}), Nick=$planet->{nick} ($planet->{planet_status}), Channel: $planet->{channel}, Hostile Count: $planet->{hit_us},";
 		}
 		$ND::server->command("notice $ND::nick $planet->{coords} $planet->{ruler} OF $planet->{planet},$ally Race=$planet->{race}, Score=$planet->{score} ($planet->{scorerank}), Size=$planet->{size} ($planet->{sizerank}), Value=$planet->{value} ($planet->{valuerank}), XP=$planet->{xp} ($planet->{xprank})");
@@ -72,11 +72,13 @@ sub checkGal {
 	}else{
 		$ND::server->command("notice $ND::nick syntax: .g X:Y");
 	}
-	my $f = $ND::DBH->prepare("SELECT score,size,value FROM galaxies WHERE x = ? AND y = ? and tick = (SELECT max(tick) from galaxies)");
+	my $f = $ND::DBH->prepare(q{SELECT score,scorerank,size,sizerank,value,valuerank,planets
+		FROM galaxies WHERE x = ? AND y = ? AND tick = (SELECT max(tick) from galaxies)
+	});
 	$f->execute($x,$y);
 	while (my @row = $f->fetchrow()){
 		@row = map (valuecolor(1),@row);
-		$ND::server->command("notice $ND::nick $x:$y  Score=$row[0], Size=$row[1], Value=$row[2]");
+		$ND::server->command("notice $ND::nick $x:$y  Score=$row[0] ($row[1]), Size=$row[2] ($row[3]), Value=$row[4] ($row[5]), Planets=$row[6]");
 	}
 }
 
@@ -269,7 +271,7 @@ sub findCovOpper {
 	}
 	my $attackers = $ND::DBH->prepare(q{
 		SELECT coords(p.x,p.y,p.z), ruler, planet FROM current_planet_stats p JOIN planet_stats ps using (id) WHERE 
-		ps.tick = $1 AND (2000*$2*$3/ps.value)::int = $4 ;
+		ps.tick = $1 AND (2000.0*$2*$3/ps.value)::int = $4 ;
 		});
 	$attackers->execute($tick,$agents,$value,$stolen);
 	if ($attackers->rows == 0){