Mercurial > hg > reproctool-df
annotate reproctool.cgi @ 32:583e4c324c24
Adding file copyright
author | Dominic Cleal <dominic@computerkb.co.uk> |
---|---|
date | Sun, 25 Jan 2009 17:55:47 +0000 |
parents | d1028107ab75 |
children | a4197a854e79 |
rev | line source |
---|---|
0 | 1 #!/usr/bin/perl -T |
32
583e4c324c24
Adding file copyright
Dominic Cleal <dominic@computerkb.co.uk>
parents:
30
diff
changeset
|
2 # |
583e4c324c24
Adding file copyright
Dominic Cleal <dominic@computerkb.co.uk>
parents:
30
diff
changeset
|
3 # CGI script for assessing reprocessing value of items in EVE-Online based |
583e4c324c24
Adding file copyright
Dominic Cleal <dominic@computerkb.co.uk>
parents:
30
diff
changeset
|
4 # on mineral prices. |
583e4c324c24
Adding file copyright
Dominic Cleal <dominic@computerkb.co.uk>
parents:
30
diff
changeset
|
5 # |
583e4c324c24
Adding file copyright
Dominic Cleal <dominic@computerkb.co.uk>
parents:
30
diff
changeset
|
6 # Released under the revised BSD licence |
583e4c324c24
Adding file copyright
Dominic Cleal <dominic@computerkb.co.uk>
parents:
30
diff
changeset
|
7 # Copyright (c) 2009 Dominic Cleal |
583e4c324c24
Adding file copyright
Dominic Cleal <dominic@computerkb.co.uk>
parents:
30
diff
changeset
|
8 # Portions copyright (c) 2009 Bjorn Hamels |
0 | 9 |
10 use warnings; | |
11 use strict; | |
12 | |
22
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
13 use Switch; |
0 | 14 use CGI; |
15 use DBI; | |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
16 use LWP::UserAgent; |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
17 use Storable qw/store_fd fd_retrieve/; |
0 | 18 |
27
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
19 # Settings from params.cgi |
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
20 our (@dbparams, $img_http_path, $eve_central_url, |
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
21 $marks_cache, $marks_cache_expiry); |
0 | 22 |
27
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
23 $img_http_path = '/itemimgs'; |
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
24 $eve_central_url = 'http://eve-central.com/api/evemon'; |
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
25 $marks_cache = 'minerals.cache'; |
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
26 $marks_cache_expiry = 4 * 60 * 60; # 4 hours |
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
27 |
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
28 require './params.cgi'; |
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
29 |
789877ff0e1a
Changing dbparams to contain all settings
Dominic Cleal <dominic@computerkb.co.uk>
parents:
26
diff
changeset
|
30 # Begin script |
0 | 31 my $cgi = new CGI; |
32 print $cgi->header(-type => 'text/html', | |
33 -pragma => 'no-cache', | |
34 -expires => '-365d'); | |
35 | |
12
6d5296efb9ef
Shows user-errors to output, not dying
Dominic Cleal <dominic@computerkb.co.uk>
parents:
11
diff
changeset
|
36 sub user_error |
6d5296efb9ef
Shows user-errors to output, not dying
Dominic Cleal <dominic@computerkb.co.uk>
parents:
11
diff
changeset
|
37 { |
6d5296efb9ef
Shows user-errors to output, not dying
Dominic Cleal <dominic@computerkb.co.uk>
parents:
11
diff
changeset
|
38 my $text = shift; |
6d5296efb9ef
Shows user-errors to output, not dying
Dominic Cleal <dominic@computerkb.co.uk>
parents:
11
diff
changeset
|
39 print<<END; |
6d5296efb9ef
Shows user-errors to output, not dying
Dominic Cleal <dominic@computerkb.co.uk>
parents:
11
diff
changeset
|
40 <html><head><title>Error</title></head> |
13 | 41 <body><font color="#FF0000"><b>Error:</b></font> $text</body></html> |
12
6d5296efb9ef
Shows user-errors to output, not dying
Dominic Cleal <dominic@computerkb.co.uk>
parents:
11
diff
changeset
|
42 END |
6d5296efb9ef
Shows user-errors to output, not dying
Dominic Cleal <dominic@computerkb.co.uk>
parents:
11
diff
changeset
|
43 exit; |
6d5296efb9ef
Shows user-errors to output, not dying
Dominic Cleal <dominic@computerkb.co.uk>
parents:
11
diff
changeset
|
44 } |
6d5296efb9ef
Shows user-errors to output, not dying
Dominic Cleal <dominic@computerkb.co.uk>
parents:
11
diff
changeset
|
45 |
24
266c93756c1b
Putting inputs next to each other again
Dominic Cleal <dominic@computerkb.co.uk>
parents:
21
diff
changeset
|
46 # Inputs |
266c93756c1b
Putting inputs next to each other again
Dominic Cleal <dominic@computerkb.co.uk>
parents:
21
diff
changeset
|
47 my $cols = $cgi->param('cols') || 4; |
266c93756c1b
Putting inputs next to each other again
Dominic Cleal <dominic@computerkb.co.uk>
parents:
21
diff
changeset
|
48 my $str_items = $cgi->param('items'); |
266c93756c1b
Putting inputs next to each other again
Dominic Cleal <dominic@computerkb.co.uk>
parents:
21
diff
changeset
|
49 |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
50 # Generate the first page, where eve-central mineral prices are prefilled. |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
51 unless ($str_items) |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
52 { |
29 | 53 # Try and pull the marks out of a stored cache |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
54 my $marks; |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
55 if (-e $marks_cache) |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
56 { |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
57 open CACHE, "< $marks_cache" || die("Can't open cache $marks_cache: $!"); |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
58 $marks = fd_retrieve(*CACHE) || die("Can't read marks from cache: $!"); |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
59 close CACHE; |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
60 |
29 | 61 # Check expiry time |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
62 if (time > ($marks->{timestamp} + $marks_cache_expiry)) |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
63 { |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
64 $marks = undef; |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
65 } |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
66 } |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
67 |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
68 unless ($marks) |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
69 { |
29 | 70 # If cache was unavailable or had expired, pull again from eve-central |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
71 my $ua = LWP::UserAgent->new; |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
72 $ua->agent('reproctool'); |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
73 my $resp = $ua->request(HTTP::Request->new(GET => $eve_central_url)); |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
74 |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
75 if ($resp->is_success) |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
76 { |
29 | 77 # Store as Mineral => 1234 |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
78 $marks = { timestamp => time }; |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
79 foreach (split(/[\n\r]/, $resp->content)) |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
80 { |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
81 next unless (/<name>(.+)<\/name>.*<price>([0-9\.]+)<\/price>/i); |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
82 $marks->{$1} = $2; |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
83 } |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
84 |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
85 if (-e $marks_cache) |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
86 { |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
87 unlink $marks_cache |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
88 || die("Unable to unlink cache $marks_cache: $!"); |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
89 } |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
90 |
29 | 91 # Store into the cache |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
92 open CACHE, "> $marks_cache" |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
93 || die("Can't open cache $marks_cache to write: $!"); |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
94 store_fd($marks, *CACHE) || die("Can't write to cache: $!"); |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
95 close CACHE; |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
96 } |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
97 else |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
98 { |
29 | 99 # User can enter their own numbers if eve-central was down |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
100 $marks->{$_} = 1 foreach ('Tritanium', 'Pyerite', 'Mexallon', |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
101 'Isogen', 'Nocxium', 'Zydrine', |
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
102 'Megacyte', 'Morphite'); |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
103 } |
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
104 } |
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
105 |
28
61fb1a6de2c5
Fixing timestamp entry sometimes left
Dominic Cleal <dominic@computerkb.co.uk>
parents:
27
diff
changeset
|
106 delete $marks->{timestamp} if exists $marks->{timestamp}; |
61fb1a6de2c5
Fixing timestamp entry sometimes left
Dominic Cleal <dominic@computerkb.co.uk>
parents:
27
diff
changeset
|
107 |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
108 # What evenutally will be printed. |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
109 print<<END; |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
110 <html> |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
111 <body> |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
112 |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
113 <form method="post"> |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
114 <textarea rows="5" cols="80" name="items"></textarea> |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
115 <table border="0" cellspacing="4"> |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
116 <tr> |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
117 END |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
118 # Lists the name of the minerals. |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
119 print "<td>$_</td>\n" foreach (keys %{$marks}); |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
120 print "</tr><tr>"; |
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
121 |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
122 foreach (keys %{$marks}) |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
123 { |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
124 my $sname = lc substr($_, 0, 4); |
25
ccbd8fa63b9f
Adding a cache for mineral marks
Dominic Cleal <dominic@computerkb.co.uk>
parents:
24
diff
changeset
|
125 my $fmt = sprintf('%.2f', $marks->{$_}); |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
126 print "<td><input type='text' name='$sname' size='7' value='$fmt' /></td>\n"; |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
127 } |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
128 |
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
129 print <<END; |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
130 </tr> |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
131 </table> |
18
67f13a371c18
Adding columns input
Dominic Cleal <dominic@computerkb.co.uk>
parents:
17
diff
changeset
|
132 Columns: <input type='text' name='cols' size='2' value='4' /><br /><br /> |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
133 <input type="submit" /> |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
134 </form> |
21
5ae40a1161e6
Added eve central credit (still need to cache some vals, got an idea on that dom?)
df
parents:
20
diff
changeset
|
135 <br /> |
5ae40a1161e6
Added eve central credit (still need to cache some vals, got an idea on that dom?)
df
parents:
20
diff
changeset
|
136 Mineral prices are empire averages from <a href="http://www.eve-central.com/">Eve-central</a>. |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
137 </body> |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
138 </html> |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
139 END |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
140 |
17
a79168f03fc4
Replacing XML::DOM with LWP and regex, tidying code
Dominic Cleal <dominic@computerkb.co.uk>
parents:
16
diff
changeset
|
141 exit; |
8
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
142 } |
ccd5e74fa58e
Untested xml import of prices from evecentral. solution is a dead end, as the rammsrdi.com dont support dom xlm.
df
parents:
7
diff
changeset
|
143 |
0 | 144 # Load mineral prices |
15
50d8619bce32
Improving mineral errors
Dominic Cleal <dominic@computerkb.co.uk>
parents:
14
diff
changeset
|
145 my $trit = $cgi->param('trit') || user_error('No tritanium price'); |
50d8619bce32
Improving mineral errors
Dominic Cleal <dominic@computerkb.co.uk>
parents:
14
diff
changeset
|
146 my $pyer = $cgi->param('pyer') || user_error('No pyerite price'); |
50d8619bce32
Improving mineral errors
Dominic Cleal <dominic@computerkb.co.uk>
parents:
14
diff
changeset
|
147 my $mexa = $cgi->param('mexa') || user_error('No mexallon price'); |
50d8619bce32
Improving mineral errors
Dominic Cleal <dominic@computerkb.co.uk>
parents:
14
diff
changeset
|
148 my $isog = $cgi->param('isog') || user_error('No isogen price'); |
50d8619bce32
Improving mineral errors
Dominic Cleal <dominic@computerkb.co.uk>
parents:
14
diff
changeset
|
149 my $nocx = $cgi->param('nocx') || user_error('No nocxium price'); |
50d8619bce32
Improving mineral errors
Dominic Cleal <dominic@computerkb.co.uk>
parents:
14
diff
changeset
|
150 my $zydr = $cgi->param('zydr') || user_error('No zydrine price'); |
50d8619bce32
Improving mineral errors
Dominic Cleal <dominic@computerkb.co.uk>
parents:
14
diff
changeset
|
151 my $mega = $cgi->param('mega') || user_error('No megacyte price'); |
50d8619bce32
Improving mineral errors
Dominic Cleal <dominic@computerkb.co.uk>
parents:
14
diff
changeset
|
152 my $morp = $cgi->param('morp') || user_error('No morphite price'); |
0 | 153 |
1
c39512d94605
Adding dbparams config
Dominic Cleal <dominic@computerkb.co.uk>
parents:
0
diff
changeset
|
154 my $db = DBI->connect(@dbparams) |
0 | 155 or die("Database connection failure: $DBI::errstr"); |
156 | |
157 # Strip out line endings | |
158 $str_items =~ s/[\n\r]+//g; | |
159 | |
160 # If the items string contains the contract info too, strip it out | |
161 $str_items = $1 if ($str_items =~ /The container .+ contains the following items:(.+)/); | |
162 $str_items = $1 if ($str_items =~ /(.+)Are you sure you want to continue?/); | |
163 | |
9
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
164 my @item_names = split(/\s*,\s*/, $str_items); |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
165 |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
166 # SQL fragment to match all items |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
167 my $sql_typenames = ''; |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
168 $sql_typenames = 'types.typeName = ?' if ($#item_names >= 0); |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
169 $sql_typenames .= " OR types.typeName = ?" foreach (1..$#item_names); |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
170 |
0 | 171 # SQL lookup for reprocessing amounts |
172 my $sql_reprocess = <<END; | |
173 SELECT | |
174 types.typeID, | |
175 types.typeName, | |
9
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
176 groups.groupName, |
3
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
177 attrs.valueInt, -- metaLevel |
0 | 178 types.basePrice, |
179 graphics.icon, | |
3
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
180 SUM(CASE WHEN m1.requiredTypeID = 34 THEN m1.quantity ELSE 0 END), -- [Tritanium] |
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
181 SUM(CASE WHEN m1.requiredTypeID = 35 THEN m1.quantity ELSE 0 END), -- [Pyerite] |
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
182 SUM(CASE WHEN m1.requiredTypeID = 36 THEN m1.quantity ELSE 0 END), -- [Mexallon] |
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
183 SUM(CASE WHEN m1.requiredTypeID = 37 THEN m1.quantity ELSE 0 END), -- [Isogen] |
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
184 SUM(CASE WHEN m1.requiredTypeID = 38 THEN m1.quantity ELSE 0 END), -- [Nocxium] |
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
185 SUM(CASE WHEN m1.requiredTypeID = 39 THEN m1.quantity ELSE 0 END), -- [Zydrine] |
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
186 SUM(CASE WHEN m1.requiredTypeID = 40 THEN m1.quantity ELSE 0 END), -- [Megacyte] |
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
187 SUM(CASE WHEN m1.requiredTypeID = 11399 THEN m1.quantity ELSE 0 END) -- [Morphite] |
0 | 188 FROM invTypes types |
11
f749981ad862
Fixes items with no metalevel attribute, improves sorting
Dominic Cleal <dominic@computerkb.co.uk>
parents:
10
diff
changeset
|
189 LEFT JOIN dgmTypeAttributes attrs ON types.typeID = attrs.typeID AND attrs.attributeID = 633 |
0 | 190 INNER JOIN typeActivityMaterials m1 ON types.typeID = m1.typeID |
9
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
191 INNER JOIN invGroups groups ON types.groupID = groups.groupID |
0 | 192 INNER JOIN eveGraphics graphics ON types.graphicID = graphics.graphicID |
9
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
193 WHERE $sql_typenames |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
194 GROUP BY types.typeID |
11
f749981ad862
Fixes items with no metalevel attribute, improves sorting
Dominic Cleal <dominic@computerkb.co.uk>
parents:
10
diff
changeset
|
195 ORDER BY groups.categoryID DESC, groupName ASC, typeName ASC |
0 | 196 END |
197 my $pre_reprocess = $db->prepare($sql_reprocess); | |
198 | |
9
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
199 # Execute, bring back one row per item |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
200 my ($tid, $tname, $gname, $meta, $basePrice, $icon, |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
201 $ttrit, $tpyer, $tmexa, $tisog, $tnocx, $tzydr, $tmega, $tmorp); |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
202 |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
203 $pre_reprocess->execute(@item_names) or die("Can't lookup items: $DBI::errstr"); |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
204 $pre_reprocess->bind_columns(undef, \$tid, \$tname, \$gname, \$meta, \$basePrice, |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
205 \$icon, \$ttrit, \$tpyer, \$tmexa, \$tisog, |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
206 \$tnocx, \$tzydr, \$tmega, \$tmorp); |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
207 |
0 | 208 my @output = (); |
9
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
209 while ($pre_reprocess->fetch()) |
0 | 210 { |
211 my $item = {}; | |
9
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
212 my $isk = ($trit * $ttrit) + ($pyer * $tpyer) + ($mexa * $tmexa) + |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
213 ($isog * $tisog) + ($nocx * $tnocx) + ($zydr * $tzydr) + |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
214 ($mega * $tmega) + ($morp * $tmorp); |
20
877806fb69a3
Fixed double use of var, and added reprocessing details in ALT
df
parents:
18
diff
changeset
|
215 my $repDetails = sprintf( "Trit=%d Py=%d Mex=%d Iso=%d Nocx=%d Zyd=%d Mega=%d Morp=%d", |
877806fb69a3
Fixed double use of var, and added reprocessing details in ALT
df
parents:
18
diff
changeset
|
216 $ttrit, $tpyer, $tmexa, $tisog, $tnocx, $tzydr, $tmega, $tmorp ); |
9
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
217 |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
218 $meta = 0 unless defined $meta; |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
219 $item = { id => $tid, name => $tname, meta => $meta, icon => $icon, |
20
877806fb69a3
Fixed double use of var, and added reprocessing details in ALT
df
parents:
18
diff
changeset
|
220 price => $basePrice, reprocessIsk => $isk, reprocessDetails => $repDetails }; |
9
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
221 |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
222 # If this item exists multiple times in the input, then they weren't stacked |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
223 # so output it multiple times |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
224 my @matching_in = grep({ $_ eq $tname } @item_names); |
6b98a17fbe22
Changing to a single SQL query for type-based sorting and efficiency
Dominic Cleal <dominic@computerkb.co.uk>
parents:
7
diff
changeset
|
225 push @output, $item foreach (0..$#matching_in); |
0 | 226 } |
227 | |
228 my $col = 0; | |
229 print<<END; | |
230 <html> | |
231 <head> | |
232 <style type="text/css"> | |
22
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
233 .reg |
3
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
234 { |
4
4351c0bf33d4
Improving IGB formatting
Dominic Cleal <dominic@computerkb.co.uk>
parents:
3
diff
changeset
|
235 text-align: center; |
3
e640eb6cefc3
Making DB stuff more generic, fixing missing mineral
Dominic Cleal <dominic@computerkb.co.uk>
parents:
1
diff
changeset
|
236 } |
0 | 237 </style> |
238 </head> | |
4
4351c0bf33d4
Improving IGB formatting
Dominic Cleal <dominic@computerkb.co.uk>
parents:
3
diff
changeset
|
239 |
0 | 240 <body> |
241 <table> | |
242 END | |
243 | |
30
d1028107ab75
Pretty numbers function
Dominic Cleal <dominic@computerkb.co.uk>
parents:
29
diff
changeset
|
244 sub pretty_numbers |
d1028107ab75
Pretty numbers function
Dominic Cleal <dominic@computerkb.co.uk>
parents:
29
diff
changeset
|
245 { |
d1028107ab75
Pretty numbers function
Dominic Cleal <dominic@computerkb.co.uk>
parents:
29
diff
changeset
|
246 my $num = shift; |
d1028107ab75
Pretty numbers function
Dominic Cleal <dominic@computerkb.co.uk>
parents:
29
diff
changeset
|
247 $num = sprintf('%.2f', $num); |
d1028107ab75
Pretty numbers function
Dominic Cleal <dominic@computerkb.co.uk>
parents:
29
diff
changeset
|
248 $num = reverse $num; |
d1028107ab75
Pretty numbers function
Dominic Cleal <dominic@computerkb.co.uk>
parents:
29
diff
changeset
|
249 $num =~ s/(\d\d\d)(?=\d)(?!\d*\.)/$1,/g; |
d1028107ab75
Pretty numbers function
Dominic Cleal <dominic@computerkb.co.uk>
parents:
29
diff
changeset
|
250 return reverse $num; |
d1028107ab75
Pretty numbers function
Dominic Cleal <dominic@computerkb.co.uk>
parents:
29
diff
changeset
|
251 } |
d1028107ab75
Pretty numbers function
Dominic Cleal <dominic@computerkb.co.uk>
parents:
29
diff
changeset
|
252 |
10
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
253 my $igb = ($ENV{HTTP_USER_AGENT} =~ /EVE-minibrowser/i); |
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
254 |
0 | 255 for my $item (@output) |
256 { | |
257 if ($col == $cols) | |
258 { | |
259 print "</tr><tr>\n"; | |
260 $col = 0; | |
261 } | |
262 | |
22
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
263 my ($img, $text, $link, $colour); |
0 | 264 |
265 if (defined $item->{id}) | |
266 { | |
10
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
267 if ($igb) |
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
268 { |
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
269 $img = "typeicon:$item->{id}"; |
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
270 $link = "showinfo:$item->{id}"; |
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
271 } |
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
272 else |
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
273 { |
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
274 $img = "$img_http_path/icons/icons_items_png/64_64/icon$item->{icon}.png"; |
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
275 } |
de10d02dc715
Using item images for non-IGB browsers
Dominic Cleal <dominic@computerkb.co.uk>
parents:
9
diff
changeset
|
276 |
22
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
277 switch ($item->{meta}) |
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
278 { |
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
279 case 0 { $colour = "#666600"; } |
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
280 case 1 { $colour = "#777777"; } |
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
281 case 2 { $colour = "#BBBBBB"; } |
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
282 case 3 { $colour = "#FFFFFF"; } |
23 | 283 case 4 { $colour = "#4444FF"; } |
22
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
284 case 5 { $colour = "#FF0000"; } |
23 | 285 case [6..30]{ $colour = "#00FF00"; } |
22
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
286 } |
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
287 |
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
288 if ($item->{meta} >= 4) |
0 | 289 { |
290 $text = $item->{name}; | |
291 } | |
292 else | |
293 { | |
20
877806fb69a3
Fixed double use of var, and added reprocessing details in ALT
df
parents:
18
diff
changeset
|
294 $text = $item->{reprocessIsk}; |
0 | 295 } |
296 } | |
297 else | |
298 { | |
299 $text = 'Unknown item'; | |
5
42268fc087a9
Improving IGB integration with links and images
Dominic Cleal <dominic@computerkb.co.uk>
parents:
4
diff
changeset
|
300 $img = "typeicon:07_15"; |
0 | 301 } |
302 | |
22
66a63068fb23
Cleaned up the styles and added colour s on meta level .... the happy colour show.
df
parents:
21
diff
changeset
|
303 print "<td width='64' class='reg'>"; |
5
42268fc087a9
Improving IGB integration with links and images
Dominic Cleal <dominic@computerkb.co.uk>
parents:
4
diff
changeset
|
304 print "<a href='$link'>" if defined $link; |
14
9b8670ac1bcc
Adding title attr to images
Dominic Cleal <dominic@computerkb.co.uk>
parents:
13
diff
changeset
|
305 print "<img src='$img' width='64' height='64' border='1' "; |
20
877806fb69a3
Fixed double use of var, and added reprocessing details in ALT
df
parents:
18
diff
changeset
|
306 print "title=\"$item->{name}\" alt=\"$item->{name} ($item->{reprocessDetails})\" />"; |
5
42268fc087a9
Improving IGB integration with links and images
Dominic Cleal <dominic@computerkb.co.uk>
parents:
4
diff
changeset
|
307 print "</a>" if defined $link; |
42268fc087a9
Improving IGB integration with links and images
Dominic Cleal <dominic@computerkb.co.uk>
parents:
4
diff
changeset
|
308 print "<br />"; |
42268fc087a9
Improving IGB integration with links and images
Dominic Cleal <dominic@computerkb.co.uk>
parents:
4
diff
changeset
|
309 print "<font color='$colour'>" if defined $colour; |
42268fc087a9
Improving IGB integration with links and images
Dominic Cleal <dominic@computerkb.co.uk>
parents:
4
diff
changeset
|
310 print $text; |
42268fc087a9
Improving IGB integration with links and images
Dominic Cleal <dominic@computerkb.co.uk>
parents:
4
diff
changeset
|
311 print "</font>" if defined $colour; |
0 | 312 print "</td>\n"; |
313 | |
314 $col++; | |
315 } | |
316 | |
317 print<<END; | |
318 </tr> | |
319 </table> | |
320 </body> | |
321 </html> | |
322 END | |
323 |