#**************************************************************************
#   Copyright (C) 2006 by Michael Andreen <harvATruinDOTnu>               *
#                                                                         *
#   This program is free software; you can redistribute it and/or modify  *
#   it under the terms of the GNU General Public License as published by  *
#   the Free Software Foundation; either version 2 of the License, or     *
#   (at your option) any later version.                                   *
#                                                                         *
#   This program is distributed in the hope that it will be useful,       *
#   but WITHOUT ANY WARRANTY; without even the implied warranty of        *
#   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *
#   GNU General Public License for more details.                          *
#                                                                         *
#   You should have received a copy of the GNU General Public License     *
#   along with this program; if not, write to the                         *
#   Free Software Foundation, Inc.,                                       *
#   51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.         *
#**************************************************************************/
package NDIRC::PA;
use strict;
use warnings;
use ND::DB;
use ND::Include;
use NDIRC::Access;
use NDIRC::Misc;
use POSIX;
require Exporter;

our @ISA = qw/Exporter/;

our @EXPORT = qw/checkPlanet checkGal shipEff shipStop parseValue prettyValue calcXp/;

sub checkPlanet {
	my ($msg) = @_;

	DB();
	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 = "";
		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 {
	my ($x,$y) = @_;
	DB();
	my $f = $ND::DBH->prepare("SELECT name,score,size,value 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::target $x:$y $row[0], Score=$row[1], Size=$row[2], Value=$row[3]");
	}
}

sub shipEff {
	my ($msg,$value) = @_;
	my ($amount,$ship);
	if($msg =~ /^(-?\d+(?:\.\d+)?[hkMG]?) (\w+)$/){
		if (defined $value){
			$value = parseValue($1);
			$value *= -1.5 if $value < 0;
			my $feud = '';
		}else{
			$amount = parseValue($1);
		}
		$ship = "\%$2\%";
	}else{
		my $command = (defined $value ? "veff" : "eff");
		$ND::server->command("notice $ND::nick syntax: .$command amount ship");
		return;
	}
	my $feud = '';

	my @ship = $ND::DBH->selectrow_array(q{
SELECT name,target,"type",damage,metal+crystal+eonium,init,"class",guns,race
FROM ship_stats WHERE name ILIKE ?
		}, undef, $ship);
	if (@ship){
		my $type = "kill";
		$type = "stun" if $ship[2] eq 'Emp';
		$type = "steal" if ($ship[2] eq 'Steal') or ($ship[2] eq 'Pod');

		if (defined $value){
			$amount = int(($value*100/$ship[4]));
			$feud = '(FEUD: '.prettyValue(int($amount/0.80)).') ';
		}
		$value = prettyValue(($amount*$ship[4]/100));
		my $text = prettyValue($amount)." $feud $ship[0] ($ship[5]:$value) will $type:";
		my $st = $ND::DBH->prepare(q{
			SELECT name,"class","type",armor,metal+crystal+eonium,init,target,eres,race
			FROM ship_stats WHERE "class" = ?
			});
		$st->execute($ship[1]);
		while (my @target = $st->fetchrow()){
			my $dead = $ship[2] eq 'Emp' ? int($amount*$ship[7]*(100-$target[7])/100) : int($amount*$ship[3]/$target[3]);
			$value = prettyValue($dead*$target[4]/100);
			if (($target[6] eq $ship[6]) and ($target[5] <= $ship[5])){
				$target[5] = "${ND::C}04$target[5]$ND::C";
			}elsif(($target[6] eq $ship[6]) and ($target[5] > $ship[5])){
				$target[5] = "${ND::C}12$target[5]$ND::C";
			}
			$target[0] = "${ND::C}04$target[0]$ND::C" if $target[2] eq 'Norm' || $target[2] eq 'Cloak';
			$target[0] = "${ND::C}12$target[0]$ND::C" if $target[2] eq 'Emp';
			$target[0] = "${ND::C}13$target[0]$ND::C" if $target[2] eq 'Steal';
			$text .= " $ND::B$dead$ND::B $target[0] ($target[5]:$value),";
		}
		chop $text;
		$ND::server->command("notice $ND::target $text");
	}
	#print $text;
}

sub shipStop {
	my ($msg,$value) = @_;
	my ($amount,$ship);
	if($msg =~ /^(-?\d+(?:\.\d+)?[hkMG]?) (\w+)$/){
		if (defined $value){
			$value = parseValue($1);
			$value *= -1.5 if $value < 0;
			my $feud = '';
		}else{
			$amount = parseValue($1);
		}
		$ship = "\%$2\%";
	}else{
		my $command = (defined $value ? "vstop" : "stop");
		$ND::server->command("notice $ND::nick syntax: .$command amount ship");
		return;
	}
	my $feud = '';

	my @ship = $ND::DBH->selectrow_array(q{
SELECT name,target,"type",armor,metal+crystal+eonium,init,"class",eres,race
FROM ship_stats WHERE name ILIKE ?
		}, undef, $ship);
	if (@ship){
		$ship[0] = "${ND::C}04$ship[0]$ND::C" if $ship[2] eq 'Norm';
		$ship[0] = "${ND::C}12$ship[0]$ND::C" if $ship[2] eq 'Emp';
		$ship[0] = "${ND::C}13$ship[0]$ND::C" if $ship[2] eq 'Steal';

		if (defined $value){
			$amount = int(($value*100/$ship[4]));
			$feud = '(FEUD: '.prettyValue(int($amount/0.80)).') ';
		}
		$value = prettyValue(($amount*$ship[4]/100));
		my $text = "To stop $amount $feud $ship[0] ($ship[5]:$value) you need:";
		my $st = $ND::DBH->prepare(q{
			SELECT name,"class","type",damage,metal+crystal+eonium,init,target,guns,race
			FROM ship_stats WHERE "target" = ?
			});
		$st->execute($ship[6]);
		while (my @stopper = $st->fetchrow()){
			my $needed = $stopper[2] eq 'Emp' ? ceil($amount*100/(100-$ship[7])/$stopper[7]) : ceil($amount*$ship[3]/$stopper[3]);
			$value = prettyValue($needed*$stopper[4]/100);
			if (($stopper[1] eq $ship[1]) and ($ship[5] <= $stopper[5])){
				$stopper[5] = "${ND::C}04$stopper[5]$ND::C";
			}elsif(($stopper[1] eq $ship[1]) and ($ship[5] > $stopper[5])){
				$stopper[5] = "${ND::C}12$stopper[5]$ND::C";
			}
			$stopper[0] = "${ND::C}04$stopper[0]$ND::C" if $stopper[2] eq 'Norm' || $stopper[2] eq 'Cloak';
			$stopper[0] = "${ND::C}12$stopper[0]$ND::C" if $stopper[2] eq 'Emp';
			$stopper[0] = "${ND::C}13$stopper[0]$ND::C" if $stopper[2] eq 'Steal';
			$text .= " $ND::B$needed$ND::B $stopper[0] ($stopper[5]:$value),";
		}
		chop $text;
		$ND::server->command("notice $ND::target $text");
	}
	#print $text;
}

sub calcXp {
	my ($x,$y,$z,$roids,$cap) = @_;

	my ($avalue,$ascore) = $ND::DBH->selectrow_array(q{
		SELECT value,score FROM current_planet_stats WHERE 
			id = (SELECT planet FROM users WHERE hostmask ILIKE ?);
		}, undef, $ND::address);
	my ($tvalue,$tscore,$tsize) = $ND::DBH->selectrow_array(q{
		SELECT value,score,size FROM current_planet_stats WHERE 
		x = ? AND y = ? and z = ?;
		}, undef, $x,$y,$z);
	$cap = 0.25 unless $cap;
	unless($roids){
		$roids = int($tsize*$cap);
	}elsif ($roids < 10){
		$tsize = ceil($tsize*.75**($roids-1));
		$roids = int($cap*$tsize);
	}
	$tsize -= $roids;
	unless (defined $avalue && defined $ascore){
		$ND::server->command("notice $ND::target You don't have a planet specified");
		return;
	}
	unless (defined $tvalue && defined $tscore){
		$ND::server->command("notice $ND::target Doesn't seem to be a planet at $x:$y:$z");
		return;
	}
	my $xp = pa_xp($roids,$ascore,$avalue,$tscore,$tvalue);
	my $score = 60 * $xp;
	my $value = $roids*200;
	my $totscore = prettyValue($score + $value);
	$ND::server->command("notice $ND::target You will gain $ND::B$xp$ND::B XP, $ND::B$score$ND::B score, if you steal $roids roids ($ND::B$value$ND::B value), from $ND::B$x:$y:$z$ND::B, who will have $ND::B$tsize$ND::B roids left, total score gain will be: $ND::B$totscore$ND::B in total,");
}

sub findCovOpper {
	my ($stolen) = @_;

	my $tick = $ND::tick;
	my $agents;

	if ($stolen =~ /(\d+) (\d+) (\d+)/){
		$tick = $1;
		$agents = $2;
		$stolen = $3;
	}elsif ($stolen =~ /(\d+) (\d+)/){
		$tick = $1;
		$stolen = $3;
	}

	my ($value,$score) = $ND::DBH->selectrow_array(q{
		SELECT value,score FROM planet_stats WHERE 
			id = (SELECT planet FROM users WHERE hostmask ILIKE ?) AND tick = ?;
		}, undef, $ND::address,$tick);
	my ($coords) = $ND::DBH->selectrow_array(q{
		SELECT coords(p.x,p.y,p.z) FROM current_planet_stats p JOIN planet_stats ps using (id) WHERE 
		ps.tick = ? AND (2000*?*?/ps.value)::int = $stolen ;
		}, undef, $tick,$agents,$value,$stolen);
	$ND::server->command("notice $ND::target The planet that cov opped you is: $coords");
}

1;
