use strict;
use warnings;
+use feature ':5.10';
use Moose;
use MooseX::MethodAttributes;
}
}
+sub g
+ : Help(usage: .g X:Y)
+{
+ my ($self, $c, $msg) = @_;
+
+ my ($x,$y) = ($msg =~ /(\d+)\D+(\d+)/) or die 'ARGS';
+
+ my $f = $c->model->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);
+ $c->reply("$x:$y Score=$row[0] ($row[1]), Size=$row[2] ($row[3]), Value=$row[4] ($row[5]), Planets=$row[6]");
+ }
+}
+
+sub time
+ : Help(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.)
+{
+ my ($self, $c, $msg) = @_;
+ my ($tick,$timezone) = $msg =~ /^(\d+)?\s*(\S+)?$/ or die 'ARGS';
+
+ eval {
+ $tick //= $c->model->selectrow_array(q{SELECT tick()});
+ $timezone //= 'GMT';
+ my $query = $c->model->prepare(q{
+SELECT date_trunc('seconds',now() + (($1 - tick()) || ' hr')::interval) AT TIME ZONE $2
+ });
+ $query->execute($tick,$timezone);
+ my $time = $query->fetchrow_array;
+ $c->reply("Time at tick <b>$tick</b>, timezone <b>$timezone</b>: <b>$time</b>");
+ };
+ given ($@){
+ when(/time zone "(.+?)" not recognized/){
+ $c->reply("<c04>$1</c> is not a valid timezone.");
+ }
+ die $@ if $@;
+ }
+}
1;