X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=PA.pm;h=72050d851a77a7fce5902d222e5de807e412e8de;hb=8492985c19c12b19d892a78664409590aeb57f47;hp=afc5b05861801cfec845aeb7060d4027f26c2368;hpb=a1d98bc55c2ea2df2f2be3ff78386542b096c4dc;p=NDIRC.git

diff --git a/PA.pm b/PA.pm
index afc5b05..72050d8 100644
--- a/PA.pm
+++ b/PA.pm
@@ -28,59 +28,7 @@ require Exporter;
 
 our @ISA = qw/Exporter/;
 
-our @EXPORT = qw/checkPlanet checkGal shipEff shipStop parseValue prettyValue calcXp findCovOpper/;
-
-sub checkPlanet {
-	my ($msg) = @_;
-
-	my ($x,$y,$z,$nick);
-	if ($msg =~ /(\d+)\D+(\d+)\D+(\d+)/){
-		$x = $1;
-		$y = $2;
-		$z = $3;
-	}elsif ((officer() || ia() || intel()) && defined $msg){
-		$nick = $msg;
-	}else{
-		$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,
-		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 = "";
-		if (officer() || ia() || dc() | intel()){
-			$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})");
-	}else{
-		$ND::server->command("notice $ND::nick Couldn't find planet: $msg");
-	}
-}
-sub checkGal {
-	my ($msg) = @_;
-
-	my ($x,$y,);
-	if ($msg =~ /(\d+)\D+(\d+)/){
-		$x = $1;
-		$y = $2;
-	}else{
-		$ND::server->command("notice $ND::nick syntax: .g X:Y");
-	}
-	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] ($row[1]), Size=$row[2] ($row[3]), Value=$row[4] ($row[5]), Planets=$row[6]");
-	}
-}
+our @EXPORT = qw/shipEff shipStop parseValue prettyValue calcXp findCovOpper tick_time/;
 
 sub shipEff {
 	my ($msg,$command) = @_;
@@ -285,4 +233,24 @@ sub findCovOpper {
 	$ND::server->command("notice $ND::nick The planet that cov opped you is one of: $coords");
 }
 
+sub tick_time {
+	my ($msg,$command) = @_;
+	my $tick = $ND::tick;
+	my $timezone = 'GMT';
+	if ($msg =~ /^(\d+)(?: (\S+))?/){
+		$tick = $1 if defined $1;
+		$timezone = $2 if defined $2;
+	}elsif ($msg =~ /^(\S+)/){
+		$timezone = $1;
+	}elsif ($msg){
+		$ND::server->command("notice $ND::nick syntax: .time [tick] [timezone] | Gives the time at the specied tick. Assumes GMT if no timezone is given and current tick if no tick is given.");
+		return;
+	}
+	my $query = $ND::DBH->prepare(q{SELECT date_trunc('seconds',now() + (($1 - tick()) || ' hr')::interval) AT TIME ZONE $2});
+	$query->execute($tick,$timezone);
+	my $time = $query->fetchrow_array;
+	$ND::server->command("notice $ND::nick Time at tick $ND::B$tick$ND::O, timezone $ND::B$timezone$ND::O: $ND::B$time$ND::O");
+
+}
+
 1;