+command getanti => {
+ help => q(Usage: .getanti class [eta] | class is the target class, like fi or bs, eta is optional max eta for the ships.),
+ acl => q(irc_getships),
+}, class extends NDIRC::Command {
+ method execute ($c,$msg) {
+ my ($class,$eta) = $msg =~ /^(\S+)(?: (\d+))?$/ or die 'ARGS';
+ my $dbh = $c->model;
+
+ $eta //= 9;
+
+ my @classes = qw/Fi Co Fr De Cr Bs/;
+ for (@classes){
+ if (lc $class eq lc $_){
+ $class = $_;
+ last;
+ }
+ }
+
+ while ($eta < 9){
+ pop @classes;
+ pop @classes;
+ $eta++;
+ }
+
+ my $f = $dbh->prepare(q{
+SELECT username, ship, amount, CASE WHEN $1 = t1 THEN 't1' ELSE 't2' END AS t
+FROM available_ships a
+ JOIN ship_stats s USING (ship)
+WHERE uid IN (SELECT uid FROM groupmembers WHERE gid = 'M')
+ AND class = ANY($2)
+ AND $1 IN (t1,t2)
+ORDER BY amount*(metal+crystal+eonium)*CASE WHEN $1 = t1 THEN 1.0 ELSE 0.6 END DESC
+ });
+ $f->execute($class,\@classes);
+ my $text;
+ my $i = 0;
+ my $total = 0;
+ while (my $user = $f->fetchrow_hashref){
+ $text .= "($user->{username}: $user->{ship} $user->{amount} $user->{t}) ";
+ $i++;
+ $total += $user->{amount};
+ }
+ if ($text){
+ $c->reply("<b>$i</b> fleets with anti-<b>$class</b>: $text");
+ }else{
+ $c->reply("Couldn't find any user with anti-<b>$class</b>");
+ }
+ }
+};
+
+command getpass => {
+ help => q(Gives new users a random password.),
+ type => q(pm)
+}, class extends NDIRC::Command {
+
+###########################################################
+# Written by Guy Malachi http://guymal.com
+# 18 August, 2002
+###########################################################
+ sub generate_random_string
+ {
+ my $length_of_randomstring=shift;# the length of
+ # the random string to generate
+
+ my @chars=('a'..'z','A'..'Z','0'..'9','_');
+ my $random_string;
+ foreach (1..$length_of_randomstring)
+ {
+ # rand @chars will generate a random
+ # number between 0 and scalar @chars
+ $random_string .= $chars[rand @chars];
+ }
+ return $random_string;
+ }
+
+ method execute ($c,$msg) {
+ my $dbh = $c->model;
+
+ my $password = generate_random_string 16;
+ my $update = $dbh->do(q{
+UPDATE users SET password = $1
+WHERE uid = $2 AND password IS NULL
+ },undef,$password,$c->uid);
+ if ($update > 0){
+ $c->reply("Password set to: $password (you can change it on webbie)");
+ }else{
+ $c->reply("Couldn't set password. Either it has already been set or you don't have an account");
+ }
+ }
+};
+