[otrs] Stats - modifyed script

30 May 2003

      Hi all,

I decided to reduce number of variables on stats graph and changed
mkStats.pl like this:

# only NewTicket, Forward, Bounce, SendAnswer
sub GetHistoryTypes {
    my %Stats;
    my $SQL = "SELECT id, name FROM ticket_history_type " .
    " WHERE " .
    " valid_id = 1" .
    " and id=1 or id=6 or id=7 or id=8";

    $CommonObject{DBObject}->Prepare(SQL => $SQL);
    while (my @RowTmp = $CommonObject{DBObject}->FetchrowArray()) {
        $Stats{$RowTmp[0]} = $RowTmp[1];
    }
    return %Stats;
}

When i run whole script i get nice pretty graph, but i think the values
are wrong, infact i suspect that only legend shows wrong colors at wrong
names. How is that possible? What am I doing wrong?

With regards,

Alex

[otrs] Stats - modifyed script

Alex Mihicinac