fix bug when adding new agent types, noticed by Julius Igugu

2 files changed, 5 insertions, 2 deletions

diff --git a/httemplate/edit/agent.cgi b/httemplate/edit/agent.cgi
index f8d0edc..cb64ad8 100755
--- a/httemplate/edit/agent.cgi
+++ b/httemplate/edit/agent.cgi
@@ -75,7 +75,7 @@ Agent #<%= $hashref->{agentnum} ? $hashref->{agentnum} : "(NEW)" %>
     my @queueids = sort { $a <=> $b } keys %queues;
   %>
     <TR>
-      <TD ALIGN="right">Ticketing</TD>
+      <TD ALIGN="right">Ticketing queue</TD>
       <TD>
         <SELECT NAME="ticketing_queueid">
           <OPTION VALUE=""><%= $default_queue %>
diff --git a/httemplate/edit/agent_type.cgi b/httemplate/edit/agent_type.cgi
index 84f4b65..5addbbd 100755
--- a/httemplate/edit/agent_type.cgi
+++ b/httemplate/edit/agent_type.cgi
@@ -42,7 +42,10 @@ Select which packages agents of this type may sell to customers<BR>
                'hashref'   => { 'disabled' => '' },
                'select'    => 'part_pkg.*',
                'addl_from' => 'LEFT JOIN type_pkgs USING ( pkgpart )',
-               'extra_sql' => 'OR typenum = '. $agent_type->typenum,
+               'extra_sql' => ( $agent_type->typenum
+                                  ? 'OR typenum = '. $agent_type->typenum
+                                  : ''
+                              ),
             })
    ) {
 %>