X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=PA.pm;h=f085535c0edfed470c3ae32669b9b474ed4f2be2;hb=f8ae81b53b3edb30da430d26b1f161683f31c6f2;hp=e5f20bf7b42fa743282232816e77c686efa48329;hpb=fc167faac866a3bcccc2d4d78e96572c5fa0bc65;p=NDIRC.git

diff --git a/PA.pm b/PA.pm
index e5f20bf..f085535 100644
--- a/PA.pm
+++ b/PA.pm
@@ -31,15 +31,35 @@ our @ISA = qw/Exporter/;
 our @EXPORT = qw/checkPlanet checkGal shipEff shipStop parseValue prettyValue calcXp/;
 
 sub checkPlanet {
-	my ($x,$y,$z,$intel) = @_;
+	my ($msg) = @_;
+
 	DB();
-	my $f = $ND::DBH->prepare("SELECT ruler,planet,race,score,size,value,scorerank,sizerank,valuerank, xp, xprank, alliance FROM current_planet_stats WHERE x = ? AND y = ? and z = ?");
-	$f->execute($x,$y,$z);
-	while (my @row = $f->fetchrow()){
-		@row = map (valuecolor(1),@row);
+	my ($x,$y,$z,$nick);
+	if ($msg =~ /(\d+)\D+(\d+)\D+(\d+)/){
+		$x = $1;
+		$y = $2;
+		$z = $3;
+	}elsif (officer()){
+		$nick = $msg;
+	}else{
+		$ND::server->command("notice $ND::target usage .p X:Y:Z".(officer() ? ' or .p nick' : ''));
+	}
+	my $f = $ND::DBH->prepare(q{SELECT coords(x,y,z),ruler,planet,race,score,size,value,scorerank,sizerank,
+		valuerank, xp, xprank, alliance, relationship, nick, planet_status, hit_us, channel
+		FROM current_planet_stats WHERE (x = $1 AND y = $2 and z = $3) OR nick ILIKE $4 LIMIT 1
+	});
+	$f->execute($x,$y,$z,$nick);
+	if (my $planet = $f->fetchrow_hashref()){
+		for (keys %{$planet}){
+			$planet->{$_} = valuecolor(1,$planet->{$_});
+		}
 		my $ally = "";
-		$ally = " Alliance=$row[11]," if $intel;
-		$ND::server->command("notice $ND::target $x:$y:$z $row[0] OF $row[1],$ally Race=$row[2], Score=$row[3] ($row[6]), Size=$row[4] ($row[7]), Value=$row[5] ($row[8]), XP=$row[9] ($row[10])");
+		if (officer() || 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::target $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})");
+	}else{
+		$ND::server->command("notice $ND::target Couldn't find planet: $msg");
 	}
 }
 sub checkGal {