my $findid = $ND::DBH->prepare_cached(q{SELECT nick, id FROM planets
WHERE id = planetid(?,?,?,tick())});
my ($oldnick,$id) = $ND::DBH->selectrow_array($findid,undef,$x,$y,$z);
my $findid = $ND::DBH->prepare_cached(q{SELECT nick, id FROM planets
WHERE id = planetid(?,?,?,tick())});
my ($oldnick,$id) = $ND::DBH->selectrow_array($findid,undef,$x,$y,$z);
my $aid;
if ($ally ne 'unknown'){
($aid,$ally) = $ND::DBH->selectrow_array("SELECT id,name FROM alliances WHERE name ILIKE ?",undef,$ally);
my $aid;
if ($ally ne 'unknown'){
($aid,$ally) = $ND::DBH->selectrow_array("SELECT id,name FROM alliances WHERE name ILIKE ?",undef,$ally);
my $findid = $ND::DBH->prepare_cached(q{SELECT id,channel FROM current_planet_stats
WHERE x = ? AND y = ? and z = ?});
my ($id,$c) = $ND::DBH->selectrow_array($findid,undef,$x,$y,$z);
my $findid = $ND::DBH->prepare_cached(q{SELECT id,channel FROM current_planet_stats
WHERE x = ? AND y = ? and z = ?});
my ($id,$c) = $ND::DBH->selectrow_array($findid,undef,$x,$y,$z);