Thanks for this one mate!

But one thing, it only seems to work when I'm on the owner of the bot. Others experiencing the same?

Cheers for this I was just starting to write my own - saved me the hassle so I owe you one

G

NOTE: These are code snippets, to use them copy them into the main module. If you are not sure about that leave it for now and wait for an updated module (if Getrix want this to be part of his module that is)

I added a new function showall (code below) basically returns a blob with the times of all alts as well.

    function timer_show_all($name, $args) {
        if (!empty($args)) {
          $name = mysql_real_escape_string($args);
        }

        $findmain = $this -> bot -> db -> select("SELECT main FROM alts WHERE alts.alt='$name'");
if (empty($findmain)) {$main=$name;}
else {$main = current($findmain[0]);}
$output = "<Center>##ao_infoheadline##:::: Offline timer info for $main and alts ::::##end##</Center>\n\n";

$chk_time = $this -> bot -> db -> select("SELECT * FROM #___timer_aa WHERE timeraa_username='$main'");
          if (!empty($chk_time)) {
            foreach ($chk_time as $aa) {
                $timeraa_start      = $aa[2];
                $timeraa_end        = $aa[3];
                $timeraa_cooldown   = $aa[4];
                $today  = time();
                $diff = $this->get_time_difference($today, $timeraa_end);

                $output .= "$main has ".$diff['days']." days, ".$diff['hours']." hour, ".$diff['minutes']." min, ".$diff['seconds']." sec left until cooldown.\n";
            }
        }
        else { $output .= "$main has no timer set.\n"; }

$altlist = $this -> bot -> db -> select("SELECT alt FROM alts WHERE alts.main='$main'");
if (!empty($altlist)) {
  foreach ($altlist as $charlist) {
   foreach ($charlist as $charname) {
    $chk_time = $this -> bot -> db -> select("SELECT * FROM #___timer_aa WHERE timeraa_username='$charname'");
            if (!empty($chk_time)) {
              foreach ($chk_time as $aa) {
                $timeraa_start      = $aa[2];
                $timeraa_end        = $aa[3];
                $timeraa_cooldown   = $aa[4];
                $today  = time();
                $diff = $this->get_time_difference($today, $timeraa_end);
                $output .= "$charname has ".$diff['days']." days, ".$diff['hours']." hour, ".$diff['minutes']." min, ".$diff['seconds']." sec left until cooldown.\n";
              }
    }
    else { $output .= "$charname has no timer set.\n"; }
  }
}
}
$output = $this -> bot -> core("tools") -> make_blob("AA timers for $main", $output);
return $output;
}
It will also need an extra case in the sub_handler:

            case 'showall':
                return($this -> timer_show_all($name, $com['args']));
            break;

Usage: (As I didn't update the help)
!timeraa showall [character]

It will find the character's main and then list all timers in a blob, if no character is specified it will show for the person who typed the command.

Yeah, very nice and useful module, thanx @ Getrix! This makes the AA overview much easyer, even with 8 lvl 80 chars! 

It 'cost' me a few hours until I found that the select statement provided an array of arrays.

What I would like to still do on the showall is:
* filter out non 80's (non 80's can't train on time)
* sort the output by skill time left (probably a matter of putting the output strings in an array and sorting it

What I would like to still do on the showall is:
* filter out non 80's (non 80's can't train on time)
* sort the output by skill time left (probably a matter of putting the output strings in an array and sorting it

Still working on this, have some nice ideas but raids prevented me from executing them

Great module, thank you for your hard work.

I just wanted to ask... what happens when the bot is down? (maintenance or something) will the time spend in offline state be counted or will it just mess things up and delay the counter, so that the actual time-left is incorrect?

Thanks for answering me