package ND::Include;
use strict;
use warnings FATAL => 'all';
+use CGI qw{:standard};
require Exporter;
our @ISA = qw/Exporter/;
-our @EXPORT = qw/isMember isHC isDC isBC isOfficer isScanner isIntel parseMarkup min max listTargets
- alliances intelquery/;
+our @EXPORT = qw/isMember isHC isDC isBC isOfficer isScanner isIntel isTech parseMarkup min max listTargets
+ alliances intelquery generateClaimXml markThreadAsRead/;
sub isMember {
- return exists $ND::GROUPS{Members};
+ return exists $ND::GROUPS{Members} || isTech();
}
sub isHC {
- return exists $ND::GROUPS{HC};
+ return exists $ND::GROUPS{HC} || isTech();
}
sub isDC {
- return exists $ND::GROUPS{DC};
+ return exists $ND::GROUPS{DC} || isTech();
}
sub isBC {
- return exists $ND::GROUPS{BC};
+ return exists $ND::GROUPS{BC} || isTech();
}
sub isOfficer {
- return exists $ND::GROUPS{Officers};
+ return exists $ND::GROUPS{Officers} || isTech();
}
sub isScanner {
- return exists $ND::GROUPS{Scanners};
+ return exists $ND::GROUPS{Scanners} || isTech();
}
sub isIntel {
- return exists $ND::GROUPS{Intel};
+ return exists $ND::GROUPS{Intel} || isTech();
+}
+
+sub isTech {
+ return exists $ND::GROUPS{Tech};
}
sub parseMarkup {
my ($text) = @_;
$text =~ s{\n}{\n<br/>}g;
- $text =~ s{\[B\](.*?)\[/B\]}{<b>$1</b>};
+ $text =~ s{\[B\](.*?)\[/B\]}{<b>$1</b>}gi;
return $text;
}
+sub markThreadAsRead {
+ my ($thread) = @_;
+ my $rows = $ND::DBH->do(q{UPDATE forum_thread_visits SET time = now()
+WHERE uid = $1 AND ftid = $2},undef,$ND::UID,$thread);
+ if ($rows == 0){
+ $ND::DBH->do(q{INSERT INTO forum_thread_visits (uid,ftid) VALUES ($1,$2)}
+ ,undef,$ND::UID,$thread) or $ND::ERROR .= p($ND::DBH->errstr);
+ }elsif(not defined $rows){
+ $ND::ERROR .= p($ND::DBH->errstr);
+ }
+}
+
sub min {
my ($x,$y) = @_;
return ($x > $y ? $y : $x);
sub alliances {
my ($alliance) = @_;
my @alliances;
+ $alliance = -1 unless defined $alliance;
push @alliances,{Id => -1, Name => ' ', Selected => not $alliance};
my $query = $ND::DBH->prepare(q{SELECT id,name FROM alliances ORDER BY name});
$query->execute;
ORDER BY i.tick DESC, i.mission};
}
+
+sub generateClaimXml {
+ my ($raid, $from, $target) = @_;
+
+ my ($timestamp) = $ND::DBH->selectrow_array("SELECT MAX(modified)::timestamp AS modified FROM raid_targets");
+ $ND::BODY->param(Timestamp => $timestamp);
+ if ($target){
+ $target = "r.id = $target";
+ $_ = listTargets();
+ $ND::BODY->param(TargetList => $_);
+ }else{
+ $target = "r.raid = $raid->{id}";
+ }
+
+ if ($from){
+ $from = "AND modified > '$from'";
+ }else{
+ $from = '';
+ }
+ my $targets = $ND::DBH->prepare(qq{SELECT r.id,r.planet FROM raid_targets r WHERE $target $from});
+ $targets->execute or print p($ND::DBH->errstr);
+ my $claims = $ND::DBH->prepare(qq{ SELECT username,joinable,launched FROM raid_claims
+ NATURAL JOIN users WHERE target = ? AND wave = ?});
+ my @targets;
+ while (my $target = $targets->fetchrow_hashref){
+ my %target;
+ $target{Id} = $target->{id};
+ $target{Coords} = $target->{id};
+ my @waves;
+ for (my $i = 1; $i <= $raid->{waves}; $i++){
+ my %wave;
+ $wave{Id} = $i;
+ $claims->execute($target->{id},$i);
+ my $joinable = 0;
+ my $claimers;
+ if ($claims->rows != 0){
+ my $owner = 0;
+ my @claimers;
+ while (my $claim = $claims->fetchrow_hashref){
+ $owner = 1 if ($ND::USER eq $claim->{username});
+ $joinable = 1 if ($claim->{joinable});
+ $claim->{username} .= '*' if ($claim->{launched});
+ push @claimers,$claim->{username};
+ }
+ $claimers = join '/', @claimers;
+ if ($owner){
+ $wave{Command} = 'Unclaim';
+ if ($raid->{released_coords}){
+ $target{Coords} = $ND::DBH->selectrow_array('SELECT coords(x,y,z) FROM current_planet_stats WHERE id = ?',undef,$target->{planet});
+ }
+ }elsif ($joinable){
+ $wave{Command} = 'Join';
+ }else{
+ $wave{Command} = 'none';
+ }
+ }else{
+ #if (!isset($planet) || ($target->value/$planet->value > 0.4 || $target->score/$planet->score > 0.4))
+ $wave{Command} = 'Claim';
+ }
+ $wave{Claimers} = $claimers;
+ $wave{Joinable} = $joinable;
+ push @waves,\%wave;
+ }
+ $target{Waves} = \@waves;
+ push @targets,\%target;
+ }
+ $ND::BODY->param(Targets => \@targets);
+}
+
1;