X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FWeb%2FPages%2FGraph.pm;fp=ND%2FWeb%2FPages%2FGraph.pm;h=9d8db070d7218c259d9108a48b1fa26b6942cfbb;hb=865806b6cccd8a063ec7c22bfa80eebbfaad715a;hp=0000000000000000000000000000000000000000;hpb=33379bf7e2909a0f46ccf771a919121e48f9ab41;p=ndwebbie.git

diff --git a/ND/Web/Pages/Graph.pm b/ND/Web/Pages/Graph.pm
new file mode 100644
index 0000000..9d8db07
--- /dev/null
+++ b/ND/Web/Pages/Graph.pm
@@ -0,0 +1,130 @@
+#**************************************************************************
+#   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 ND::Web::Pages::Graph;
+use strict;
+use warnings FATAL => 'all';
+use CGI qw/:standard/;
+use ND::Include;
+use GD::Graph::lines;
+
+$ND::PAGES{graph} = {parse => \&parse, process => \&process, render=> \&render};
+
+sub parse {
+	my ($uri) = @_;
+	$ND::USETEMPLATE = 0;
+}
+
+sub process {
+
+}
+
+sub render {
+	my ($DBH,$uri) = @_;
+
+	my $type;
+	my ($x,$y,$z);
+	if ($uri =~ m{^/\w+/(stats|ranks)/(.*)}){
+		$type = $1;
+		if ($2 =~ m{(\d+)(?: |:)(\d+)(?:(?: |:)(\d+))(?: |:(\d+))?$}){
+			$x = $1;
+			$y = $2;
+			$z = $3;
+		}
+	}
+
+	die "Not a proper type" unless defined $type;
+
+	my %graph_settings = (
+		line_width => 2,
+		y_number_format => sub { prettyValue abs $_[0]},
+		legend_placement => 'BL',
+		#x_label => 'tick',
+		y_label => '',
+		x_label_skip => 50,
+		x_tick_offset => 13,
+		zero_axis => 1,
+		box_axis => 0,
+		boxclr => 'black',
+		axislabelclr => 'black',
+		title => $type,
+		y1_label => 'size',
+		y2_label => 'rest',
+
+
+	);
+
+	my $findGraph;
+	if (defined $z){
+		$findGraph = $DBH->prepare(q{SELECT graph FROM planet_graphs WHERE planet = planetid($1,$2,$3,$4) AND tick = $4 AND type = $5});
+		$findGraph->execute($x,$y,$z,$ND::TICK,$type) or die $DBH->errstr;
+	}
+
+	my $img;
+	if (defined $findGraph and my $graph = $findGraph->fetchrow_hashref){
+		$img = $graph->{graph};
+	}elsif(defined $z){
+		my $planets = $DBH->prepare(q{SELECT id, tick,size,coords(x,y,z),score,size,value,xp,scorerank,sizerank,valuerank,xprank from planets natural join planet_stats where id = planetid($1,$2,$3,$4) ORDER BY tick ASC});
+		$planets->execute($x,$y,$z,$ND::TICK) or die $DBH->errstr;
+
+		my @score;
+		my @size;
+		my @value;
+		my @xp;
+		my @ticks;
+		
+		while (my $tick = $planets->fetchrow_hashref){
+			push @ticks,$tick->{tick};
+			if ($type eq 'stats'){
+				push @score,$tick->{score};
+				push @size,$tick->{size};
+				push @value,$tick->{value};
+				push @xp,$tick->{xp}*60;
+			}elsif($type eq 'ranks'){
+				push @score,-$tick->{scorerank};
+				push @size,-$tick->{sizerank};
+				push @value,-$tick->{valuerank};
+				push @xp,-$tick->{xprank};
+			}
+
+		}
+		my $graph = GD::Graph::lines->new(500,300);
+		if ($type eq 'stats'){
+			$graph->set_legend(qw{score size value xp*60}) or die $graph->error;
+			$graph_settings{two_axes} = 1;
+			$graph_settings{use_axis} = [2,1,2,2];
+		}elsif($type eq 'ranks'){
+			$graph->set_legend(qw{score size value xp}) or die $graph->error;
+			$graph_settings{y_max_value} = 0;
+			$graph_settings{two_axes} = 1;
+			$graph_settings{use_axis} = [2,1,2,2];
+		}
+		$graph->set(%graph_settings);
+		my $gd = $graph->plot([\@ticks,\@score,\@size,\@value,\@xp]) or die $graph->error;
+		$img = $gd->png;
+	}
+
+	die 'no image' unless defined $img;
+
+	print header(-type=> 'image/png', -Content_Length => length $img);
+	binmode STDOUT;
+	print $img;
+}
+
+1;