home *** CD-ROM | disk | FTP | other *** search
/ PC User 2003 December / Australian PC User - December 2003 (CD2).iso / software / apps / files / dwmx2k4.exe / Disk1 / data1.cab / Configuration_En / ServerDebugOutput / ColdFusion / cfdebugout.xsl next >
Encoding:
Extensible Markup Language  |  2003-09-05  |  35.6 KB  |  1,181 lines
  1. <?xml version="1.0"?>
  2. <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
  3. <xsl:output method="xml" cdata-section-elements="template path name value jumptoline icon timestamp"/>
  4.  
  5. <!-- ******************************** -->
  6. <!-- beginning of Localizable Strings -->
  7. <!-- ******************************** -->
  8. <xsl:variable name="general_name" select="'General'"/>
  9. <xsl:variable name="timestamp_name" select="'Timestamp'"/>
  10. <xsl:variable name="product_name" select="'Product'"/>
  11. <xsl:variable name="product_version_name" select="'Product Version'"/>
  12. <xsl:variable name="locale_name" select="'Locale'"/>
  13. <xsl:variable name="user_agent_name" select="'User-Agent'"/>
  14. <xsl:variable name="remote_ip_name" select="'Remote IP'"/>
  15. <xsl:variable name="host_name_name" select="'Host Name'"/>
  16. <xsl:variable name="server_file_name" select="'Server File'"/>
  17. <xsl:variable name="template_name" select="'Template'"/>
  18. <xsl:variable name="exceptions_name" select="'Exceptions'"/>
  19. <xsl:variable name="exception_type_name" select="'Type'"/>
  20. <xsl:variable name="exception_detail_name" select="'Detail'"/>
  21. <xsl:variable name="exception_error_code_name" select="'Error Code'"/>
  22. <xsl:variable name="exception_extended_info_name" select="'Extended Information'"/>
  23. <xsl:variable name="template_stack_name" select="'Template Stack'"/>
  24. <xsl:variable name="total_execution_time_name" select="'Total Execution Time'"/>
  25. <xsl:variable name="database_name" select="'Database'"/>
  26. <xsl:variable name="sql_queries_name" select="'SQL Queries'"/>
  27. <xsl:variable name="sql_dsn_name" select="'DSN'"/>
  28. <xsl:variable name="sql_record_count_name" select="'Record Count'"/>
  29. <xsl:variable name="sql_columns_name" select="'Columns'"/>
  30. <xsl:variable name="sql_statement_name" select="'Statement'"/>
  31. <xsl:variable name="object_queries_name" select="'Object Queries'"/>
  32. <xsl:variable name="object_query_statement_name" select="'Statement'"/>
  33. <xsl:variable name="object_query_ids_name" select="'Object IDs'"/>
  34. <xsl:variable name="stored_procs_name" select="'Stored Procedures'"/>
  35. <xsl:variable name="dbserver_name" select="'Database Server'"/>
  36. <xsl:variable name="params_name" select="'Parameters'"/>
  37. <xsl:variable name="sql_type_name" select="'SQL Type'"/>
  38. <xsl:variable name="return_value_name" select="'Return Value'"/>
  39. <xsl:variable name="input_value_name" select="'Input Value'"/>
  40. <xsl:variable name="result_set_number_name" select="'Result Set Number'"/>
  41. <xsl:variable name="max_row_name" select="'Maximum Rows'"/>
  42. <xsl:variable name="null_name" select="'Null'"/>
  43. <xsl:variable name="results_name" select="'Results'"/>
  44. <xsl:variable name="variables_name" select="'Variables'"/>
  45. <xsl:variable name="variables_form_name" select="'Form'"/>
  46. <xsl:variable name="variables_request_name" select="'Request'"/>
  47. <xsl:variable name="variables_server_name" select="'Server'"/>
  48. <xsl:variable name="variables_application_name" select="'Application'"/>
  49. <xsl:variable name="variables_url_name" select="'URL'"/>
  50. <xsl:variable name="variables_cgi_name" select="'CGI'"/>
  51. <xsl:variable name="variables_client_name" select="'Client'"/>
  52. <xsl:variable name="variables_cookie_name" select="'Cookie'"/>
  53. <xsl:variable name="variables_session_name" select="'Session'"/>
  54. <xsl:variable name="trace_path_name" select="'Trace Path'"/>
  55. <xsl:variable name="tracepoint_logged_name" select="'Logged'"/>
  56. <!-- ******************************** -->
  57. <!-- end of Localizable Strings       -->
  58. <!-- ******************************** -->
  59.  
  60. <!-- ******************************** -->
  61. <!-- beginning of icon names          -->
  62. <!-- ******************************** -->
  63. <xsl:variable name="general_icon" select="'General.gif'"/>
  64. <xsl:variable name="timestamp_icon" select="'Timestamp.gif'"/>
  65. <xsl:variable name="product_icon" select="'Product.gif'"/>
  66. <xsl:variable name="product_version_icon" select="'ProductVersion.gif'"/>
  67. <xsl:variable name="locale_icon" select="'Locale.gif'"/>
  68. <xsl:variable name="user_agent_icon" select="'UserAgent.gif'"/>
  69. <xsl:variable name="remote_ip_icon" select="'RemoteIP.gif'"/>
  70. <xsl:variable name="host_name_icon" select="'HostName.gif'"/>
  71. <xsl:variable name="server_file_icon" select="'ServerFile.gif'"/>
  72. <xsl:variable name="exceptions_icon" select="'Exception.gif'"/>
  73. <xsl:variable name="exception_icon" select="'Exception.gif'"/>
  74. <xsl:variable name="exception_type_icon" select="'Exception.gif'"/>
  75. <xsl:variable name="exception_detail_icon" select="'Exception.gif'"/>
  76. <xsl:variable name="exception_error_code_icon" select="'Exception.gif'"/>
  77. <xsl:variable name="exception_extended_info_icon" select="'Exception.gif'"/>
  78. <xsl:variable name="template_stack_icon" select="'TemplateStack.gif'"/>
  79. <xsl:variable name="template_icon" select="'Template.gif'"/>
  80. <xsl:variable name="total_execution_time_icon" select="'TotalExecutionTime.gif'"/>
  81. <xsl:variable name="database_icon" select="'Database.gif'"/>
  82. <xsl:variable name="sql_queries_icon" select="'DatabaseSub.gif'"/>
  83. <xsl:variable name="sql_query_icon" select="'DatabaseSub2.gif'"/>
  84. <xsl:variable name="sql_dsn_icon" select="'DatabaseSub2.gif'"/>
  85. <xsl:variable name="sql_record_count_icon" select="'DatabaseSub2.gif'"/>
  86. <xsl:variable name="sql_columns_icon" select="'DatabaseSub2.gif'"/>
  87. <xsl:variable name="sql_column_icon" select="'DatabaseSub2.gif'"/>
  88. <xsl:variable name="sql_execution_time_icon" select="'DatabaseSub2.gif'"/>
  89. <xsl:variable name="sql_statement_icon" select="'DatabaseSub2.gif'"/>
  90. <xsl:variable name="object_queries_icon" select="'DatabaseSub.gif'"/>
  91. <xsl:variable name="object_query_icon" select="'DatabaseSub2.gif'"/>
  92. <xsl:variable name="object_query_statement_icon" select="'DatabaseSub2.gif'"/>
  93. <xsl:variable name="object_query_ids_icon" select="'DatabaseSub2.gif'"/>
  94. <xsl:variable name="object_query_id_icon" select="'DatabaseSub2.gif'"/>
  95. <xsl:variable name="stored_procs_icon" select="'DatabaseSub.gif'"/>
  96. <xsl:variable name="stored_proc_icon" select="'DatabaseSub2.gif'"/>
  97. <xsl:variable name="dbserver_icon" select="'DatabaseSub2.gif'"/>
  98. <xsl:variable name="params_icon" select="'DatabaseSub2.gif'"/>
  99. <xsl:variable name="param_icon" select="'DatabaseSub2.gif'"/>
  100. <xsl:variable name="return_value_icon" select="'DatabaseSub2.gif'"/>
  101. <xsl:variable name="sql_type_icon" select="'DatabaseSub2.gif'"/>
  102. <xsl:variable name="input_value_icon" select="'DatabaseSub2.gif'"/>
  103. <xsl:variable name="result_set_number_icon" select="'DatabaseSub2.gif'"/>
  104. <xsl:variable name="max_row_icon" select="'DatabaseSub2.gif'"/>
  105. <xsl:variable name="null_icon" select="'DatabaseSub2.gif'"/>
  106. <xsl:variable name="results_icon" select="'DatabaseSub2.gif'"/>
  107. <xsl:variable name="result_icon" select="'DatabaseSub2.gif'"/>
  108. <xsl:variable name="variables_icon" select="'Variables.gif'"/>
  109. <xsl:variable name="variables_form_icon" select="'VariableParent.gif'"/>
  110. <xsl:variable name="variables_request_icon" select="'VariableParent.gif'"/>
  111. <xsl:variable name="variables_server_icon" select="'VariableParent.gif'"/>
  112. <xsl:variable name="variables_application_icon" select="'VariableParent.gif'"/>
  113. <xsl:variable name="variables_url_icon" select="'VariableParent.gif'"/>
  114. <xsl:variable name="variables_cgi_icon" select="'VariableParent.gif'"/>
  115. <xsl:variable name="variables_client_icon" select="'VariableParent.gif'"/>
  116. <xsl:variable name="variables_cookie_icon" select="'VariableParent.gif'"/>
  117. <xsl:variable name="variables_session_icon" select="'VariableParent.gif'"/>
  118. <xsl:variable name="variable_icon" select="'Variable.gif'"/>
  119. <xsl:variable name="trace_path_icon" select="'TracePath.gif'"/>
  120. <xsl:variable name="trace_point_icon" select="'TracePoint.gif'"/>
  121. <xsl:variable name="trace_point_variable_icon" select="'Variable.gif'"/>
  122. <!-- ******************************** -->
  123. <!-- end of icon names                -->
  124. <!-- ******************************** -->
  125.  
  126. <!-- ******************************** -->
  127. <!-- beginning of input parameters    -->
  128. <!-- ******************************** -->
  129. <xsl:param name="config_folder" select="''"/>
  130. <xsl:param name="temp_file_name" select="''"/>
  131. <xsl:param name="real_file_name" select="''"/>
  132. <!-- ******************************** -->
  133. <!-- end of input parameters          -->
  134. <!-- ******************************** -->
  135.  
  136. <xsl:template match="/">
  137.         <xsl:apply-templates select="debug_root"/>
  138. </xsl:template>
  139.  
  140. <!-- root -->
  141. <xsl:template match="debug_root">
  142.     <serverdebuginfo>
  143.         <context>
  144.             <template>
  145.                 <xsl:call-template name="subst_name">
  146.                     <xsl:with-param name="this" select="general/uri"/>
  147.                 </xsl:call-template>
  148. <!--            <xsl:value-of select="general/uri"/> -->
  149.             </template>
  150.             <path>
  151.                 <xsl:call-template name="subst_name">
  152.                     <xsl:with-param name="this" select="general/file"/>
  153.                 </xsl:call-template>
  154. <!--            <xsl:value-of select="general/file"/> -->
  155.             </path>
  156.             <timestamp>
  157.                 <xsl:value-of select="general/timestamp"/>
  158.             </timestamp>
  159.         </context>
  160.         <!-- these could be combined using an | operator, -->
  161.         <!-- but keeping them separate allows us to       -->
  162.         <!-- enforce a particular order in the display    -->
  163.         <xsl:apply-templates select="general"/>
  164.         <xsl:apply-templates select="exceptions"/>
  165.         <xsl:apply-templates select="template_stack"/>
  166.         <xsl:apply-templates select="database"/>
  167.         <xsl:apply-templates select="cfoql_queries"/>
  168.         <xsl:apply-templates select="variables"/>
  169.         <xsl:apply-templates select="trace_path"/>
  170.     </serverdebuginfo>
  171. </xsl:template>
  172.  
  173. <!-- general -->
  174. <xsl:template match="general">
  175.     <debugnode>
  176.         <name>
  177.             <xsl:value-of select="$general_name"/>
  178.         </name>
  179.         <!-- icon -->
  180.         <xsl:call-template name="icon">
  181.             <xsl:with-param name="icon_variable" select="$general_icon"/>
  182.         </xsl:call-template>
  183.         <xsl:apply-templates select="timestamp"/>
  184.         <xsl:apply-templates select="product"/>
  185.         <xsl:apply-templates select="product_version"/>
  186.         <xsl:apply-templates select="locale"/>
  187.         <xsl:apply-templates select="user_agent"/>
  188.         <xsl:apply-templates select="host_name"/>
  189.         <xsl:apply-templates select="remote_ip"/>
  190.         <xsl:apply-templates select="file"/>
  191.         <xsl:apply-templates select="uri"/>
  192.         <xsl:apply-templates select="total_execution_time"/>
  193.     </debugnode>
  194. </xsl:template>
  195.  
  196. <xsl:template match="general/timestamp">
  197.     <debugnode>
  198.         <name>
  199.             <xsl:value-of select="$timestamp_name"/>
  200.         </name>
  201.         <!-- icon -->
  202.         <xsl:call-template name="icon">
  203.             <xsl:with-param name="icon_variable" select="$timestamp_icon"/>
  204.         </xsl:call-template>
  205.         <value>
  206.             <xsl:value-of select="."/>
  207.         </value>
  208.     </debugnode>
  209. </xsl:template>
  210.  
  211. <xsl:template match="general/product">
  212.     <debugnode>
  213.         <name>
  214.             <xsl:value-of select="$product_name"/>
  215.         </name>
  216.         <!-- icon -->
  217.         <xsl:call-template name="icon">
  218.             <xsl:with-param name="icon_variable" select="$product_icon"/>
  219.         </xsl:call-template>
  220.         <value>
  221.             <xsl:value-of select="."/>
  222.         </value>
  223.     </debugnode>
  224. </xsl:template>
  225.  
  226. <xsl:template match="general/product_version">
  227.     <debugnode>
  228.         <name>
  229.             <xsl:value-of select="$product_version_name"/>
  230.         </name>
  231.         <!-- icon -->
  232.         <xsl:call-template name="icon">
  233.             <xsl:with-param name="icon_variable" select="$product_version_icon"/>
  234.         </xsl:call-template>
  235.         <value>
  236.             <xsl:value-of select="."/>
  237.         </value>
  238.     </debugnode>
  239. </xsl:template>
  240.  
  241. <xsl:template match="general/locale">
  242.     <debugnode>
  243.         <name>
  244.             <xsl:value-of select="$locale_name"/>
  245.         </name>
  246.         <!-- icon -->
  247.         <xsl:call-template name="icon">
  248.             <xsl:with-param name="icon_variable" select="$locale_icon"/>
  249.         </xsl:call-template>
  250.         <value>
  251.             <xsl:value-of select="."/>
  252.         </value>
  253.     </debugnode>
  254. </xsl:template>
  255.  
  256. <xsl:template match="general/user_agent">
  257.     <debugnode>
  258.         <name>
  259.             <xsl:value-of select="$user_agent_name"/>
  260.         </name>
  261.         <!-- icon -->
  262.         <xsl:call-template name="icon">
  263.             <xsl:with-param name="icon_variable" select="$user_agent_icon"/>
  264.         </xsl:call-template>
  265.         <value>
  266.             <xsl:value-of select="."/>
  267.         </value>
  268.     </debugnode>
  269. </xsl:template>
  270.  
  271. <xsl:template match="general/remote_ip">
  272.     <debugnode>
  273.         <name>
  274.             <xsl:value-of select="$remote_ip_name"/>
  275.         </name>
  276.         <!-- icon -->
  277.         <xsl:call-template name="icon">
  278.             <xsl:with-param name="icon_variable" select="$remote_ip_icon"/>
  279.         </xsl:call-template>
  280.         <value>
  281.             <xsl:value-of select="."/>
  282.         </value>
  283.     </debugnode>
  284. </xsl:template>
  285.  
  286. <xsl:template match="general/host_name">
  287.     <debugnode>
  288.         <name>
  289.             <xsl:value-of select="$host_name_name"/>
  290.         </name>
  291.         <!-- icon -->
  292.         <xsl:call-template name="icon">
  293.             <xsl:with-param name="icon_variable" select="$host_name_icon"/>
  294.         </xsl:call-template>
  295.         <value>
  296.             <xsl:value-of select="."/>
  297.         </value>
  298.     </debugnode>
  299. </xsl:template>
  300.  
  301. <xsl:template match="general/file">
  302.     <debugnode>
  303.         <name>
  304.             <xsl:value-of select="$server_file_name"/>
  305.         </name>
  306.         <!-- icon -->
  307.         <xsl:call-template name="icon">
  308.             <xsl:with-param name="icon_variable" select="$server_file_icon"/>
  309.         </xsl:call-template>
  310.         <value>
  311.             <xsl:call-template name="subst_name">
  312.                 <xsl:with-param name="this" select="."/>
  313.             </xsl:call-template>
  314. <!--            <xsl:value-of select="."/> -->
  315.         </value>
  316.     </debugnode>
  317. </xsl:template>
  318.  
  319. <xsl:template match="general/uri">
  320.     <debugnode>
  321.         <name>
  322.             <xsl:value-of select="$template_name"/>
  323.         </name>
  324.         <!-- icon -->
  325.         <xsl:call-template name="icon">
  326.             <xsl:with-param name="icon_variable" select="$template_icon"/>
  327.         </xsl:call-template>
  328.         <value>
  329.             <xsl:call-template name="subst_name">
  330.                 <xsl:with-param name="this" select="."/>
  331.             </xsl:call-template>
  332. <!--        <xsl:value-of select="."/> -->
  333.         </value>
  334.     </debugnode>
  335. </xsl:template>
  336.  
  337. <xsl:template match="general/total_execution_time">
  338.     <debugnode>
  339.         <name>
  340.             <xsl:value-of select="$total_execution_time_name"/>
  341.         </name>
  342.         <!-- icon -->
  343.         <xsl:call-template name="icon">
  344.             <xsl:with-param name="icon_variable" select="$total_execution_time_icon"/>
  345.         </xsl:call-template>
  346.         <value>
  347.             <xsl:value-of select="."/>
  348.         </value>
  349.     </debugnode>
  350. </xsl:template>
  351.  
  352. <!-- exceptions -->
  353. <xsl:template match="exceptions">
  354.     <debugnode>
  355.         <!-- exceptions name -->
  356.         <name>
  357.             <xsl:value-of select="$exceptions_name"/>
  358.         </name>
  359.         <!-- icon -->
  360.         <xsl:call-template name="icon">
  361.             <xsl:with-param name="icon_variable" select="$exceptions_icon"/>
  362.         </xsl:call-template>
  363.         <xsl:apply-templates select="exception"/>
  364.     </debugnode>
  365. </xsl:template>
  366.  
  367. <!-- exception -->
  368. <xsl:template match="exception">
  369.     <debugnode>
  370.         <xsl:apply-templates select="message"/>
  371.         <!-- icon -->
  372.         <xsl:call-template name="icon">
  373.             <xsl:with-param name="icon_variable" select="$exception_icon"/>
  374.         </xsl:call-template>
  375.         <xsl:apply-templates select="jump_to_line"/>
  376.         <xsl:apply-templates select="type"/>
  377.         <xsl:apply-templates select="detail"/>
  378.         <xsl:apply-templates select="error_code"/>
  379.         <xsl:apply-templates select="extended_info"/>
  380.     </debugnode>
  381. </xsl:template>
  382.  
  383. <!-- exception summary -->
  384. <xsl:template match="exception/message">
  385.     <xsl:if test=". != ''">
  386.         <name>
  387.             <xsl:value-of select="."/>
  388.         </name>
  389.     </xsl:if>
  390. </xsl:template>
  391.  
  392. <!-- exception type -->
  393. <xsl:template match="exception/type">
  394.     <xsl:if test=". != ''">
  395.         <debugnode>
  396.             <name>
  397.                 <xsl:value-of select="$exception_type_name"/>
  398.             </name>
  399.             <xsl:call-template name="icon">
  400.                 <xsl:with-param name="icon_variable" select="$exception_type_icon"/>
  401.             </xsl:call-template>
  402.             <value>
  403.                 <xsl:value-of select="."/>
  404.             </value>
  405.         </debugnode>
  406.     </xsl:if>
  407. </xsl:template>
  408.  
  409. <!-- exception detail -->
  410. <xsl:template match="exception/detail">
  411.     <xsl:if test=". != ''">
  412.         <debugnode>
  413.             <name>
  414.                 <xsl:value-of select="$exception_detail_name"/>
  415.             </name>
  416.             <xsl:call-template name="icon">
  417.                 <xsl:with-param name="icon_variable" select="$exception_detail_icon"/>
  418.             </xsl:call-template>
  419.             <value>
  420.                 <xsl:value-of select="."/>
  421.             </value>
  422.         </debugnode>
  423.     </xsl:if>
  424. </xsl:template>
  425.  
  426. <!-- exception error code -->
  427. <xsl:template match="exception/error_code">
  428.     <xsl:if test=". != ''">
  429.         <debugnode>
  430.             <name>
  431.                 <xsl:value-of select="$exception_error_code_name"/>
  432.             </name>
  433.             <xsl:call-template name="icon">
  434.                 <xsl:with-param name="icon_variable" select="$exception_error_code_icon"/>
  435.             </xsl:call-template>
  436.             <value>
  437.                 <xsl:value-of select="."/>
  438.             </value>
  439.         </debugnode>
  440.     </xsl:if>
  441. </xsl:template>
  442.  
  443. <!-- exception extended info -->
  444. <xsl:template match="exception/extended_info">
  445.     <xsl:if test=". != ''">
  446.         <debugnode>
  447.             <name>
  448.                 <xsl:value-of select="$exception_extended_info_name"/>
  449.             </name>
  450.             <xsl:call-template name="icon">
  451.                 <xsl:with-param name="icon_variable" select="$exception_extended_info_icon"/>
  452.             </xsl:call-template>
  453.             <value>
  454.                 <xsl:value-of select="."/>
  455.             </value>
  456.         </debugnode>
  457.     </xsl:if>
  458. </xsl:template>
  459.  
  460. <!-- template stack -->
  461. <xsl:template match="template_stack">
  462.     <debugnode>
  463.         <name>
  464.             <xsl:value-of select="$template_stack_name"/>
  465.         </name>
  466.         <xsl:call-template name="icon">
  467.             <xsl:with-param name="icon_variable" select="$template_stack_icon"/>
  468.         </xsl:call-template>
  469.         <xsl:apply-templates select="template"/>
  470.         <xsl:apply-templates select="../general/total_execution_time"/>
  471.     </debugnode>
  472. </xsl:template>
  473.  
  474. <!-- template -->
  475. <xsl:template match="template">
  476.     <debugnode>
  477.         <name>
  478.             <xsl:value-of select="execution_time"/>
  479.         </name>
  480.         <xsl:call-template name="icon">
  481.             <xsl:with-param name="icon_variable" select="$template_icon"/>
  482.         </xsl:call-template>
  483.         <value>
  484.             <xsl:call-template name="subst_name">
  485. <!--                <xsl:with-param name="this" select="jump_to_line/uri"/> -->
  486.                 <xsl:with-param name="this" select="jump_to_line/file"/>
  487.             </xsl:call-template>
  488. <!--        <xsl:value-of select="jump_to_line/uri"/> -->
  489.         </value>
  490.         <xsl:apply-templates select="jump_to_line"/>
  491.         <xsl:apply-templates select="template"/>
  492.     </debugnode>
  493. </xsl:template>
  494.  
  495. <!-- total execution_time -->
  496. <xsl:template match="general/total_execution_time">
  497.     <debugnode>
  498.         <name>
  499.             <xsl:value-of select="."/>
  500.         </name>
  501.         <xsl:call-template name="icon">
  502.             <xsl:with-param name="icon_variable" select="$total_execution_time_icon"/>
  503.         </xsl:call-template>
  504.         <value>
  505.             <xsl:value-of select="$total_execution_time_name"/>
  506.         </value>
  507.     </debugnode>
  508. </xsl:template>
  509.  
  510. <!-- database -->
  511. <xsl:template match="database">
  512.     <debugnode>
  513.         <name>
  514.             <xsl:value-of select="$database_name"/>
  515.         </name>
  516.         <xsl:call-template name="icon">
  517.             <xsl:with-param name="icon_variable" select="$database_icon"/>
  518.         </xsl:call-template>
  519.         <xsl:apply-templates select="sql_queries"/>
  520.         <xsl:apply-templates select="object_queries"/>
  521.         <xsl:apply-templates select="stored_procs"/>
  522.     </debugnode>
  523. </xsl:template>
  524.  
  525. <!-- sql queries -->
  526. <xsl:template match="sql_queries">
  527.     <debugnode>
  528.         <name>
  529.             <xsl:value-of select="$sql_queries_name"/>
  530.         </name>
  531.         <xsl:call-template name="icon">
  532.             <xsl:with-param name="icon_variable" select="$sql_queries_icon"/>
  533.         </xsl:call-template>
  534.         <xsl:apply-templates select="sql_query"/>
  535.     </debugnode>
  536. </xsl:template>
  537.  
  538. <!-- sql query -->
  539. <xsl:template match="sql_query">
  540.     <debugnode>
  541.         <name>
  542.             <xsl:value-of select="execution_time"/>
  543.         </name>
  544.         <xsl:call-template name="icon">
  545.             <xsl:with-param name="icon_variable" select="$sql_query_icon"/>
  546.         </xsl:call-template>
  547.         <value>
  548.             <xsl:value-of select="name"/>
  549.         </value>
  550.         <xsl:apply-templates select="jump_to_line"/>
  551.         <xsl:apply-templates select="dsn"/>
  552.         <xsl:apply-templates select="record_count"/>
  553.         <xsl:apply-templates select="column_list"/>
  554.         <xsl:apply-templates select="statement"/>
  555.     </debugnode>
  556. </xsl:template>
  557.  
  558. <!-- sql dsn -->
  559. <xsl:template match="dsn">
  560.     <xsl:if test=". != ''">
  561.         <debugnode>
  562.             <name>
  563.                 <xsl:value-of select="$sql_dsn_name"/>
  564.             </name>
  565.             <xsl:call-template name="icon">
  566.                 <xsl:with-param name="icon_variable" select="$sql_dsn_icon"/>
  567.             </xsl:call-template>
  568.             <value>
  569.                 <xsl:value-of select="."/>
  570.             </value>
  571.         </debugnode>
  572.     </xsl:if>
  573. </xsl:template>
  574.  
  575. <!-- sql query record count -->
  576. <xsl:template match="record_count">
  577.     <xsl:if test=". != ''">
  578.         <debugnode>
  579.             <name>
  580.                 <xsl:value-of select="$sql_record_count_name"/>
  581.             </name>
  582.             <xsl:call-template name="icon">
  583.                 <xsl:with-param name="icon_variable" select="$sql_record_count_icon"/>
  584.             </xsl:call-template>
  585.             <value>
  586.                 <xsl:value-of select="."/>
  587.             </value>
  588.         </debugnode>
  589.     </xsl:if>
  590. </xsl:template>
  591.  
  592. <!-- sql query columns -->
  593. <xsl:template match="column_list">
  594.     <debugnode>
  595.         <name>
  596.             <xsl:value-of select="$sql_columns_name"/>
  597.         </name>
  598.         <xsl:call-template name="icon">
  599.             <xsl:with-param name="icon_variable" select="$sql_columns_icon"/>
  600.         </xsl:call-template>
  601.         <xsl:apply-templates select="column"/>
  602.     </debugnode>
  603. </xsl:template>
  604.  
  605. <!-- sql query column -->
  606. <xsl:template match="column_list/column">
  607.     <debugnode>
  608.         <name/>
  609.         <xsl:call-template name="icon">
  610.             <xsl:with-param name="icon_variable" select="$sql_column_icon"/>
  611.         </xsl:call-template>
  612.         <value>
  613.             <xsl:value-of select="."/>
  614.         </value>
  615.     </debugnode>
  616. </xsl:template>
  617.  
  618. <!-- sql query statement -->
  619. <xsl:template match="sql_query/statement">
  620.     <debugnode>
  621.         <name>
  622.             <xsl:value-of select="$sql_statement_name"/>
  623.         </name>
  624.         <xsl:call-template name="icon">
  625.             <xsl:with-param name="icon_variable" select="$sql_statement_icon"/>
  626.         </xsl:call-template>
  627.         <value>
  628.             <xsl:value-of select="."/>
  629.         </value>
  630.     </debugnode>
  631. </xsl:template>
  632.  
  633. <!-- object queries -->
  634. <xsl:template match="object_queries">
  635.     <debugnode>
  636.         <name>
  637.             <xsl:value-of select="$object_queries_name"/>
  638.         </name>
  639.         <xsl:call-template name="icon">
  640.             <xsl:with-param name="icon_variable" select="$object_queries_icon"/>
  641.         </xsl:call-template>
  642.         <xsl:apply-templates select="object_query"/>
  643.     </debugnode>
  644. </xsl:template>
  645.  
  646. <!-- object query -->
  647. <xsl:template match="object_query">
  648.     <debugnode>
  649.         <name>
  650.             <xsl:value-of select="execution_time"/>
  651.         </name>
  652.         <xsl:call-template name="icon">
  653.             <xsl:with-param name="icon_variable" select="$object_query_icon"/>
  654.         </xsl:call-template>
  655.         <xsl:apply-templates select="jump_to_line"/>
  656.         <value>
  657.             <xsl:value-of select="type"/>
  658.         </value>
  659.         <xsl:apply-templates select="statement"/>
  660.         <xsl:apply-templates select="ids"/>
  661.     </debugnode>
  662. </xsl:template>
  663.  
  664. <!-- cfoql query statement -->
  665. <xsl:template match="object_query/statement">
  666.     <debugnode>
  667.         <name>
  668.             <xsl:value-of select="$object_query_statement_name"/>
  669.         </name>
  670.         <xsl:call-template name="icon">
  671.             <xsl:with-param name="icon_variable" select="$object_query_statement_icon"/>
  672.         </xsl:call-template>
  673.         <value>
  674.             <xsl:value-of select="."/>
  675.         </value>
  676.     </debugnode>
  677. </xsl:template>
  678.  
  679. <!-- cfoql query IDs -->
  680. <xsl:template match="object_query/ids">
  681.     <debugnode>
  682.         <name>
  683.             <xsl:value-of select="$object_query_ids_name"/>
  684.         </name>
  685.         <xsl:call-template name="icon">
  686.             <xsl:with-param name="icon_variable" select="$object_query_ids_icon"/>
  687.         </xsl:call-template>
  688.         <xsl:apply-templates select="id"/>
  689.     </debugnode>
  690. </xsl:template>
  691.  
  692. <!-- object query id -->
  693. <xsl:template match="object_query/ids/id">
  694.     <debugnode>
  695.         <name>
  696.             <xsl:value-of select="."/>
  697.         </name>
  698.         <xsl:call-template name="icon">
  699.             <xsl:with-param name="icon_variable" select="$object_query_id_icon"/>
  700.         </xsl:call-template>
  701.     </debugnode>
  702. </xsl:template>
  703.  
  704. <!-- stored procs -->
  705. <xsl:template match="stored_procs">
  706.     <debugnode>
  707.         <name>
  708.             <xsl:value-of select="$stored_procs_name"/>
  709.         </name>
  710.         <xsl:call-template name="icon">
  711.             <xsl:with-param name="icon_variable" select="$stored_procs_icon"/>
  712.         </xsl:call-template>
  713.         <xsl:apply-templates select="proc"/>
  714.     </debugnode>
  715. </xsl:template>
  716.  
  717. <!-- stored proc -->
  718. <xsl:template match="stored_procs/proc">
  719.     <debugnode>
  720.         <name>
  721.             <xsl:value-of select="execution_time"/>
  722.         </name>
  723.         <xsl:call-template name="icon">
  724.             <xsl:with-param name="icon_variable" select="$stored_proc_icon"/>
  725.         </xsl:call-template>
  726.         <value>
  727.             <xsl:value-of select="name"/>
  728.         </value>
  729.         <xsl:apply-templates select="jump_to_line"/>
  730.         <xsl:apply-templates select="dsn"/>
  731.         <xsl:apply-templates select="dbserver"/>
  732.         <xsl:apply-templates select="proc_params"/>
  733.         <xsl:apply-templates select="proc_results"/>
  734.     </debugnode>
  735. </xsl:template>
  736.  
  737. <xsl:template match="proc/dbserver">
  738.     <debugnode>
  739.         <name>
  740.             <xsl:value-of select="$dbserver_name"/>
  741.         </name>
  742.         <xsl:call-template name="icon">
  743.             <xsl:with-param name="icon_variable" select="$dbserver_icon"/>
  744.         </xsl:call-template>
  745.         <value>
  746.             <xsl:value-of select="."/>
  747.         </value>
  748.     </debugnode>
  749. </xsl:template>
  750.  
  751. <xsl:template match="proc_params">
  752.     <debugnode>
  753.         <name>
  754.             <xsl:value-of select="$params_name"/>
  755.         </name>
  756.         <xsl:call-template name="icon">
  757.             <xsl:with-param name="icon_variable" select="$params_icon"/>
  758.         </xsl:call-template>
  759.         <xsl:apply-templates select="param"/>
  760.     </debugnode>
  761. </xsl:template>
  762.  
  763. <xsl:template match="proc_params/param">
  764.     <debugnode>
  765.         <name>
  766.             <xsl:value-of select="db_var_name"/>
  767.         </name>
  768.         <xsl:call-template name="icon">
  769.             <xsl:with-param name="icon_variable" select="$param_icon"/>
  770.         </xsl:call-template>
  771.         <value>
  772.             <xsl:value-of select="type"/>
  773.         </value>
  774.         <xsl:apply-templates select="sql_type"/>
  775.         <xsl:apply-templates select="return_variable"/>
  776.         <xsl:apply-templates select="value"/>
  777.         <xsl:apply-templates select="result_set"/>
  778.         <xsl:apply-templates select="max_row"/>
  779.         <xsl:apply-templates select="null"/>
  780.     </debugnode>
  781. </xsl:template>
  782.  
  783. <xsl:template match="proc_params/param/sql_type">
  784.     <debugnode>
  785.         <name>
  786.             <xsl:value-of select="$sql_type_name"/>
  787.         </name>
  788.         <xsl:call-template name="icon">
  789.             <xsl:with-param name="icon_variable" select="$sql_type_icon"/>
  790.         </xsl:call-template>
  791.         <value>
  792.             <xsl:value-of select="."/>
  793.         </value>
  794.     </debugnode>
  795. </xsl:template>
  796.  
  797. <xsl:template match="proc_params/param/return_variable">
  798.     <debugnode>
  799.         <name>
  800.             <xsl:value-of select="$return_value_name"/>
  801.         </name>
  802.         <xsl:call-template name="icon">
  803.             <xsl:with-param name="icon_variable" select="$return_value_icon"/>
  804.         </xsl:call-template>
  805.         <value>
  806.             <xsl:value-of select="."/>
  807.         </value>
  808.     </debugnode>
  809. </xsl:template>
  810.  
  811. <xsl:template match="proc_params/param/value">
  812.     <debugnode>
  813.         <name>
  814.             <xsl:value-of select="$input_value_name"/>
  815.         </name>
  816.         <xsl:call-template name="icon">
  817.             <xsl:with-param name="icon_variable" select="$input_value_icon"/>
  818.         </xsl:call-template>
  819.         <value>
  820.             <xsl:value-of select="."/>
  821.         </value>
  822.     </debugnode>
  823. </xsl:template>
  824.  
  825. <xsl:template match="proc_params/param/result_set">
  826.     <debugnode>
  827.         <name>
  828.             <xsl:value-of select="$result_set_number_name"/>
  829.         </name>
  830.         <xsl:call-template name="icon">
  831.             <xsl:with-param name="icon_variable" select="$result_set_number_icon"/>
  832.         </xsl:call-template>
  833.         <value>
  834.             <xsl:value-of select="."/>
  835.         </value>
  836.     </debugnode>
  837. </xsl:template>
  838.  
  839. <xsl:template match="max_row">
  840.     <debugnode>
  841.         <name>
  842.             <xsl:value-of select="$max_row_name"/>
  843.         </name>
  844.         <xsl:call-template name="icon">
  845.             <xsl:with-param name="icon_variable" select="$max_row_icon"/>
  846.         </xsl:call-template>
  847.         <value>
  848.             <xsl:value-of select="."/>
  849.         </value>
  850.     </debugnode>
  851. </xsl:template>
  852.  
  853. <xsl:template match="proc_params/param/null">
  854.     <debugnode>
  855.         <name>
  856.             <xsl:value-of select="$null_name"/>
  857.         </name>
  858.         <xsl:call-template name="icon">
  859.             <xsl:with-param name="icon_variable" select="$null_icon"/>
  860.         </xsl:call-template>
  861.         <value>
  862.             <xsl:value-of select="."/>
  863.         </value>
  864.     </debugnode>
  865. </xsl:template>
  866.  
  867. <xsl:template match="proc_results">
  868.     <debugnode>
  869.         <name>
  870.             <xsl:value-of select="$results_name"/>
  871.         </name>
  872.         <xsl:call-template name="icon">
  873.             <xsl:with-param name="icon_variable" select="$results_icon"/>
  874.         </xsl:call-template>
  875.         <xsl:apply-templates select="result"/>
  876.     </debugnode>
  877. </xsl:template>
  878.  
  879. <xsl:template match="proc_results/result">
  880.     <debugnode>
  881.         <name>
  882.             <xsl:value-of select="name"/>
  883.         </name>
  884.         <xsl:call-template name="icon">
  885.             <xsl:with-param name="icon_variable" select="$result_icon"/>
  886.         </xsl:call-template>
  887.         <xsl:apply-templates select="result_set"/>
  888.         <xsl:apply-templates select="max_row"/>
  889.     </debugnode>
  890. </xsl:template>
  891.  
  892. <xsl:template match="proc_results/result/result_set">
  893.     <debugnode>
  894.         <name>
  895.             <xsl:value-of select="$result_set_number_name"/>
  896.         </name>
  897.         <xsl:call-template name="icon">
  898.             <xsl:with-param name="icon_variable" select="$result_set_number_icon"/>
  899.         </xsl:call-template>
  900.         <value>
  901.             <xsl:value-of select="."/>
  902.         </value>
  903.     </debugnode>
  904. </xsl:template>
  905.  
  906. <!-- variables -->
  907. <xsl:template match="variables">
  908.     <debugnode>
  909.         <name>
  910.             <xsl:value-of select="$variables_name"/>
  911.         </name>
  912.         <xsl:call-template name="icon">
  913.             <xsl:with-param name="icon_variable" select="$variables_icon"/>
  914.         </xsl:call-template>
  915.         <xsl:apply-templates select="application"/>
  916.         <xsl:apply-templates select="cgi"/>
  917.         <xsl:apply-templates select="client"/>
  918.         <xsl:apply-templates select="cookie"/>
  919.         <xsl:apply-templates select="form"/>
  920.         <xsl:apply-templates select="request"/>
  921.         <xsl:apply-templates select="server"/>
  922.         <xsl:apply-templates select="session"/>
  923.         <xsl:apply-templates select="url"/>
  924.     </debugnode>
  925. </xsl:template>
  926.  
  927. <!-- application variables -->
  928. <xsl:template match="variables/application">
  929.     <debugnode>
  930.         <name>
  931.             <xsl:value-of select="$variables_application_name"/>
  932.         </name>
  933.         <xsl:call-template name="icon">
  934.             <xsl:with-param name="icon_variable" select="$variables_application_icon"/>
  935.         </xsl:call-template>
  936.         <xsl:apply-templates select="variable"/>
  937.     </debugnode>
  938. </xsl:template>
  939.  
  940. <!-- cgi variables -->
  941. <xsl:template match="variables/cgi">
  942.     <debugnode>
  943.         <name>
  944.             <xsl:value-of select="$variables_cgi_name"/>
  945.         </name>
  946.         <xsl:call-template name="icon">
  947.             <xsl:with-param name="icon_variable" select="$variables_cgi_icon"/>
  948.         </xsl:call-template>
  949.         <xsl:apply-templates select="variable"/>
  950.     </debugnode>
  951. </xsl:template>
  952.  
  953. <!-- client variables -->
  954. <xsl:template match="variables/client">
  955.     <debugnode>
  956.         <name>
  957.             <xsl:value-of select="$variables_client_name"/>
  958.         </name>
  959.         <xsl:call-template name="icon">
  960.             <xsl:with-param name="icon_variable" select="$variables_client_icon"/>
  961.         </xsl:call-template>
  962.         <xsl:apply-templates select="variable"/>
  963.     </debugnode>
  964. </xsl:template>
  965.  
  966. <!-- cookie variables -->
  967. <xsl:template match="variables/cookie">
  968.     <debugnode>
  969.         <name>
  970.             <xsl:value-of select="$variables_cookie_name"/>
  971.         </name>
  972.         <xsl:call-template name="icon">
  973.             <xsl:with-param name="icon_variable" select="$variables_cookie_icon"/>
  974.         </xsl:call-template>
  975.         <xsl:apply-templates select="variable"/>
  976.     </debugnode>
  977. </xsl:template>
  978.  
  979. <!-- form variables -->
  980. <xsl:template match="variables/form">
  981.     <debugnode>
  982.         <name>
  983.             <xsl:value-of select="$variables_form_name"/>
  984.         </name>
  985.         <xsl:call-template name="icon">
  986.             <xsl:with-param name="icon_variable" select="$variables_form_icon"/>
  987.         </xsl:call-template>
  988.         <xsl:apply-templates select="variable"/>
  989.     </debugnode>
  990. </xsl:template>
  991.  
  992. <!-- request variables -->
  993. <xsl:template match="variables/request">
  994.     <debugnode>
  995.         <name>
  996.             <xsl:value-of select="$variables_request_name"/>
  997.         </name>
  998.         <xsl:call-template name="icon">
  999.             <xsl:with-param name="icon_variable" select="$variables_request_icon"/>
  1000.         </xsl:call-template>
  1001.         <xsl:apply-templates select="variable"/>
  1002.     </debugnode>
  1003. </xsl:template>
  1004.  
  1005. <!-- server variables -->
  1006. <xsl:template match="variables/server">
  1007.     <debugnode>
  1008.         <name>
  1009.             <xsl:value-of select="$variables_server_name"/>
  1010.         </name>
  1011.         <xsl:call-template name="icon">
  1012.             <xsl:with-param name="icon_variable" select="$variables_server_icon"/>
  1013.         </xsl:call-template>
  1014.         <xsl:apply-templates select="variable"/>
  1015.     </debugnode>
  1016. </xsl:template>
  1017.  
  1018. <!-- url variables -->
  1019. <xsl:template match="variables/url">
  1020.     <debugnode>
  1021.         <name>
  1022.             <xsl:value-of select="$variables_url_name"/>
  1023.         </name>
  1024.         <xsl:call-template name="icon">
  1025.             <xsl:with-param name="icon_variable" select="$variables_url_icon"/>
  1026.         </xsl:call-template>
  1027.         <xsl:apply-templates select="variable"/>
  1028.     </debugnode>
  1029. </xsl:template>
  1030.  
  1031. <!-- session variables -->
  1032. <xsl:template match="variables/session">
  1033.     <debugnode>
  1034.         <name>
  1035.             <xsl:value-of select="$variables_session_name"/>
  1036.         </name>
  1037.         <xsl:call-template name="icon">
  1038.             <xsl:with-param name="icon_variable" select="$variables_session_icon"/>
  1039.         </xsl:call-template>
  1040.         <xsl:apply-templates select="variable"/>
  1041.     </debugnode>
  1042. </xsl:template>
  1043.  
  1044. <!-- variable -->
  1045. <xsl:template match="variable">
  1046.     <debugnode>
  1047.         <name>
  1048.             <xsl:value-of select="name"/>
  1049.         </name>
  1050.         <xsl:call-template name="icon">
  1051.             <xsl:with-param name="icon_variable" select="$variable_icon"/>
  1052.         </xsl:call-template>
  1053.         <value>
  1054.             <xsl:value-of select="value"/>
  1055.         </value>
  1056.     </debugnode>
  1057. </xsl:template>
  1058.  
  1059. <!-- trace path -->
  1060. <xsl:template match="trace_path">
  1061.     <debugnode>
  1062.         <name>
  1063.             <xsl:value-of select="$trace_path_name"/>
  1064.         </name>
  1065.         <xsl:call-template name="icon">
  1066.             <xsl:with-param name="icon_variable" select="$trace_path_icon"/>
  1067.         </xsl:call-template>
  1068.         <xsl:apply-templates select="trace_point"/>
  1069.     </debugnode>
  1070. </xsl:template>
  1071.  
  1072. <!-- trace point -->
  1073. <xsl:template match="trace_point">
  1074.     <debugnode>
  1075.         <name>
  1076.             <xsl:if test="timestamp != ''">
  1077.                 <xsl:value-of select="timestamp"/>
  1078.             </xsl:if>
  1079.             <xsl:if test="category != ''">
  1080.                 <xsl:if test="timestamp != ''">
  1081.                     <xsl:text> </xsl:text>
  1082.                 </xsl:if>
  1083.                 <xsl:value-of select="category"/>
  1084.             </xsl:if>
  1085.             <xsl:if test="type != ''">
  1086.                 <xsl:if test="timestamp != '' or category != ''">
  1087.                     <xsl:text> </xsl:text>
  1088.                 </xsl:if>
  1089.                 <xsl:value-of select="type"/>
  1090.             </xsl:if>
  1091.             <xsl:if test="logged != ''">
  1092.                 <xsl:if test="timestamp != '' or category != '' or type != ''">
  1093.                     <xsl:text> </xsl:text>
  1094.                 </xsl:if>
  1095.                 <xsl:value-of select="$tracepoint_logged_name"/>
  1096.             </xsl:if>
  1097.         </name>
  1098.         <xsl:call-template name="icon">
  1099.             <xsl:with-param name="icon_variable" select="$trace_point_icon"/>
  1100.         </xsl:call-template>
  1101.         <xsl:apply-templates select="jump_to_line"/>
  1102.         <xsl:if test="text != ''">
  1103.             <value>
  1104.                 <xsl:value-of select="text"/>
  1105.             </value>
  1106.         </xsl:if>
  1107.         <xsl:apply-templates select="variable"/>
  1108.     </debugnode>
  1109. </xsl:template>
  1110.  
  1111. <!-- jump-to-line -->
  1112. <xsl:template match="jump_to_line">
  1113.     <jumptoline>
  1114.         <xsl:if test="line_number != ''">
  1115.             <xsl:attribute name="linenumber">
  1116.                 <xsl:value-of select="line_number"/>
  1117.             </xsl:attribute>
  1118.         </xsl:if>
  1119.         <xsl:if test="start_position != ''">
  1120.             <xsl:attribute name="startposition">
  1121.                 <xsl:value-of select="start_position"/>
  1122.             </xsl:attribute>
  1123.         </xsl:if>
  1124.         <xsl:if test="end_position != ''">
  1125.             <xsl:attribute name="endposition">
  1126.                 <xsl:value-of select="end_position"/>
  1127.             </xsl:attribute>
  1128.         </xsl:if>
  1129.         <xsl:if test="uri != ''">
  1130.             <template>
  1131.                 <xsl:call-template name="subst_name">
  1132.                     <xsl:with-param name="this" select="uri"/>
  1133.                 </xsl:call-template>
  1134. <!--            <xsl:value-of select="uri"/> -->
  1135.             </template>
  1136.         </xsl:if>
  1137.         <xsl:if test="file != ''">
  1138.             <path>
  1139.                 <xsl:call-template name="subst_name">
  1140.                     <xsl:with-param name="this" select="file"/>
  1141.                 </xsl:call-template>
  1142. <!--            <xsl:value-of select="file"/> -->
  1143.             </path>
  1144.         </xsl:if>
  1145.     </jumptoline>
  1146. </xsl:template>
  1147.  
  1148. <!-- icon -->
  1149. <xsl:template name="icon">
  1150.     <xsl:param name="icon_variable"/>
  1151.     <xsl:if test="$icon_variable != ''">
  1152.         <icon>
  1153.             <xsl:value-of select="$config_folder"/><xsl:value-of select="$icon_variable"/>
  1154.         </icon>
  1155.     </xsl:if>
  1156. </xsl:template>
  1157.  
  1158. <!-- substitue real file name for temp file name -->
  1159. <xsl:template name="subst_name">
  1160.     <xsl:param name="this" select="." />
  1161.     <xsl:choose>
  1162.         <xsl:when test="$temp_file_name != ''">
  1163.             <xsl:choose>
  1164.                 <xsl:when test="contains($this, $temp_file_name)">
  1165.                     <xsl:value-of select="substring-before($this, $temp_file_name)"/>
  1166.                     <xsl:value-of select="$real_file_name"/>
  1167.                 </xsl:when>
  1168.                 <xsl:otherwise>
  1169.                     <xsl:value-of select="$this"/>
  1170.                 </xsl:otherwise>
  1171.             </xsl:choose>
  1172.         </xsl:when>
  1173.         <xsl:otherwise>
  1174.             <xsl:value-of select="$this"/>
  1175.         </xsl:otherwise>
  1176.     </xsl:choose>
  1177. </xsl:template>
  1178.  
  1179.  
  1180. </xsl:stylesheet>
  1181.