and forgot to include the sql for counting tickets with severities...

diff --git a/FS/FS/TicketSystem/RT_External.pm b/FS/FS/TicketSystem/RT_External.pm
index a105c27..26420de 100644 (file)
--- a/FS/FS/TicketSystem/RT_External.pm
+++ b/FS/FS/TicketSystem/RT_External.pm
@@ -53,6 +53,7 @@ sub num_customer_tickets {
     select count(*) from tickets 
        where ( status = 'new' or status = 'open' or status = 'stalled' )
          and target = 'freeside://freeside/cust_main/$custnum'
     select count(*) from tickets 
        where ( status = 'new' or status = 'open' or status = 'stalled' )
          and target = 'freeside://freeside/cust_main/$custnum'

+         $priority_sql

   ";
 
   my $sth = $dbh->prepare($sql) or die $dbh->errstr;
   ";
 
   my $sth = $dbh->prepare($sql) or die $dbh->errstr;