+ my $ircreqs = $dbh->prepare(q{SELECT id,username,message,channel FROM irc_requests NATURAL JOIN users WHERE not sent});
+ my $upircreq = $dbh->prepare(q{UPDATE irc_requests SET sent = TRUE WHERE id = ?});
+ $ircreqs->execute;
+ while (my $req = $ircreqs->fetchrow_hashref){
+ if ($req->{channel} eq 'def'){
+ $self->toTarget(def => "> __**## $req->{username} via webbie ##**__ >> $req->{message}");
+ }else{
+ $self->toTarget($req->{channel} => "> <$req->{username} via webbie> $req->{message}");
+ }
+ $upircreq->execute($req->{id});
+ }
+ my $defmissions = $dbh->prepare(q{
+SELECT username,call,tick,dm.fleet,p.value
+ ,100 * SUM(fs.amount * (metal + crystal + eonium) / 100) / p.value AS value
+FROM users u
+ JOIN current_planet_stats p USING (pid)
+ JOIN launch_confirmations USING (uid)
+ JOIN fleets f USING (fid)
+ JOIN fleet_ships fs USING (fid)
+ JOIN defense_missions dm ON f.fid = dm.fleet
+ JOIN ship_stats ss USING (ship)
+WHERE NOT dm.announced
+GROUP BY username,call,tick,dm.fleet,p.value
+ });
+ my $updefmis = $dbh->prepare(q{UPDATE defense_missions SET announced = TRUE WHERE fleet = ?});
+ $defmissions->execute();
+ while (my $mission = $defmissions->fetchrow_hashref){
+ $self->toTarget(def => "<c06>$mission->{username} sent def</c> to call $mission->{call}, $mission->{value}% of value (tick $mission->{tick}) https://nd.ruin.nu/calls/edit/$mission->{call}");
+ $updefmis->execute($mission->{fleet});
+ }
+