I tried this extention on system but i now problems. Sorry for english. Need help!

Otrs 2.4.5, ubuntu 7.04

1 - Not Event Based Notifications
after installing this extentions event based notifications is not working anymore but before on Otrs 2.4.5 fine

2 - Memory Leak
i use mod_perl, after 1 h httpd take over 260mb Otrs is geting slow

3 - count of all tickets in escalation view not colected to the real count of tickets
i found hard coded IDs in module Kernel/System/Ticket/IndexAccelerator/RuntimeDB.pm line 91, my IDs in db is different

# CiCS-capeIT
    my $ViewableState  = $Param{ViewableState} || 0;
    if ( $ViewableState ) {
        @ViewableLockIDs = ('1','2','3')
    }
# EO CiCS-capeIT

    if (@QueueIDs) {
        my $SQL = "SELECT count(*) FROM ticket st WHERE "
            . " st.ticket_state_id IN ( ${\(join ', ', @ViewableStateIDs)} ) AND "
            . " st.queue_id IN (";


4 - agent group permissions get ignored and SQL injections (security)

I found Kernel/Output/HTML/CustomerUserTicketCount.pm and us it. But it shown more tickets as i find in system with my agent. As i can see no agent permission check is in. Also security issues found, SQL injection possible - just add SQL to From line of every incoming email and it get executed. 

    my $SQL = "SELECT count(*) "
        ."FROM ticket t "
        ."WHERE "
        . " LOWER(customer_id) = '"
        . lc( $Param{Data}->{UserCustomerID} )
        . "' ";
       
    my $Count = 0;   
    $Self->{DBObject}->Prepare( SQL => $SQL.$SQLExt );
    while ( my @Row = $Self->{DBObject}->FetchrowArray() ) {
        $Count = $Row[0];
    }


5 - count of all tickets are not collected to the real count of tickets

In file Kernel/Modules/AgentTicketQueue.pm i found hard coded IDs again.
# CiCS-capeIT  
#    $Self->{ViewAll} = $Self->{ParamObject}->GetParam( Param => 'ViewAll' )  || 0;
    my %Preferences = $Self->{UserObject}->GetPreferences(UserID => $Self->{UserID});
    $Self->{ViewAll} = $Self->{ParamObject}->GetParam( Param => 'ViewAll' )
        || $Preferences{ViewAllTickets} || '0';

    my @ViewableLockIDs = $Self->{LockObject}->LockViewableLock( Type => 'ID' );
    if ( $Self->{ViewAll} ) {
        @ViewableLockIDs= qw(1 2 3);
    }
    $Self->{ViewableLockIDs} = \@ViewableLockIDs;

# EO CiCS-capeIT


6 - broken signs in AgentTicketZoom

i use GB2312 becaus of local email clients of clients, not utf8. But I see utf8 is hard coded in ticket zoom. before was working fine on Otrs 2.4.5 - maybe the problem is:

    use utf8;
    utf8::decode( $Param{ArticleContentFilterString} );

7 - problems with GUI
see pics

8 - 50% on translation is missing 
see pics

9 - many patched files
i see also Kernel/System/Ticket.pm in package - so it seems if i install new Otrs no new patches of new patch release get applied (this is maybe reason on 1, see also http://bugs.otrs.org/show_bug.cgi?id=4257 which was already fixed on Otrs 2.4.5)