/SQL/scripts/db/dbinfo.asp

http://github.com/khaneh/Orders · ASP · 53 lines · 50 code · 3 blank · 0 comment · 1 complexity · 58d287585e662425ab60fbd5c05bece1 MD5 · raw file 

    

  1. <!-- #INCLUDE FILE="../inc/mla_sql_include.asp" -->

    2. 

  2. <%

    3. 

  3. 	Dim myDbName, myNodeId, myArrInfo, myArrFileInfo, myFileCount, i, myStrTree

    4. 

  4. 	myNodeId = Request.QueryString("nid")

    5. 

  5. 	myDbName = Request.QueryString("db")

    6. 

  6. 	openConnection

    7. 

  7. 	myStrTree = getTreeStr(Mid(myNodeId, 2), Array(myDbName))

    8. 

  8. 	myArrInfo = getDbInfo(myDbName)

    9. 

  9. 	myArrFileInfo = getDbFileInfo(myDbName)

    10. 

  10. 	closeConnection

    11. 

  11. 	If isArray(myArrFileInfo) Then myFileCount = UBound(myArrFileInfo, 2) Else myFileCount = 0 End If

    12. 

  12. %>

    13. 

  13. <!-- #INCLUDE FILE="../inc/metaheader.asp" -->

    14. 

  14. <BODY>

    15. 

  15. 	<P CLASS="treeinfo"><% = myStrTree %></P>

    16. 

  16. 

    17. 

  17. 	<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 CLASS="hcontent" SUMMARY="Database Information">

    18. 

  18. 		<TR><TD CLASS="caption" COLSPAN=2><IMG SRC="../../themes/<% = mla_cfg_theme %>/images/mylittletree/database.gif" WIDTH="16" HEIGHT="16" BORDER=0 ALIGN="MIDDLE" ALT="Database"> <% = myTObj.getTerm(120) & " [ " & myDbName & " ]" %></TD></TR>

    19. 

  19. 		<TR><TD CLASS="info"><% = myTObj.getTerm(121) %> :</TD><TD><%  =myArrInfo(0, 0) %></TD></TR>

    20. 

  20. 		<TR><TD CLASS="info"><% = myTObj.getTerm(122) %> :</TD><TD><%  =myArrInfo(1, 0) %></TD></TR>

    21. 

  21. 		<TR><TD CLASS="info"><% = myTObj.getTerm(123) %> :</TD><TD><%  =myArrInfo(2, 0) %></TD></TR>

    22. 

  22. 		<TR><TD CLASS="info"><% = myTObj.getTerm(131) %> :</TD><TD><%  =myArrInfo(3, 0) %></TD></TR>

    23. 

  23. 		<TR><TD CLASS="info"><% = myTObj.getTerm(132) %> :</TD><TD><%  =myArrInfo(4, 0) %></TD></TR>

    24. 

  24. 		<TR><TD CLASS="info"><% = myTObj.getTerm(133) %> :</TD><TD><%  =myArrInfo(5, 0) %></TD></TR>

    25. 

  25. 		<TR><TD CLASS="info" COLSPAN=2>&nbsp;</TD></TR>

    26. 

  26. 		<TR><TD CLASS="info"><% = myTObj.getTerm(124) %> :</TD><TD>&nbsp;</TD></TR>

    27. 

  27. 		<% For i = 0 To myFileCount %>

    28. 

  28. 		<TR><TD CLASS="formlabel"><% = Trim(myArrFileInfo(0, i)) %></TD><TD>&nbsp;</TD></TR>

    29. 

  29. 		<TR>

    30. 

  30. 			<TD>&nbsp;</TD>

    31. 

  31. 			<TD>

    32. 

  32. 				<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 ALIGN=CENTER SUMMARY="Database Files Information">

    33. 

  33. 					<TR><TD CLASS="info"><% = myTObj.getTerm(125) %> :</TD><TD><% = myArrFileInfo(2, i) %></TD></TR>

    34. 

  34. 					<TR><TD CLASS="info"><% = myTObj.getTerm(126) %> :</TD><TD><% = myArrFileInfo(3, i) %></TD></TR>

    35. 

  35. 					<TR><TD CLASS="info"><% = myTObj.getTerm(127) %> :</TD><TD><% = myArrFileInfo(4, i) %></TD></TR>

    36. 

  36. 					<TR><TD CLASS="info"><% = myTObj.getTerm(128) %> :</TD><TD><% = myArrFileInfo(5, i) %></TD></TR>

    37. 

  37. 					<TR><TD CLASS="info"><% = myTObj.getTerm(129) %> :</TD><TD><% = myArrFileInfo(6, i) %></TD></TR>

    38. 

  38. 					<TR><TD CLASS="info"><% = myTObj.getTerm(130) %> :</TD><TD><% = myArrFileInfo(7, i) %></TD></TR>

    39. 

  39. 				</TABLE>

    40. 

  40. 			</TD>

    41. 

  41. 		</TR>

    42. 

  42. 		<% Next %>

    43. 

  43. 	</TABLE>

    44. 

  44. 

    45. 

  45. 	<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">

    46. 

  46. 		<!--

    47. 

  47. 		if (window.parent.frames['Tree']) window.parent.frames['Tree'].oTree.expandNode('<% = myNodeId %>'); 

    48. 

  48. 		//-->

    49. 

  49. 	</SCRIPT>

    50. 

  50. 

    51. 

  51. </BODY>

    52. 

  52. </HTML>

    53. 

  53. <!-- #INCLUDE FILE="../inc/mla_sql_end.asp" -->
    54.