/SQL/scripts/db/dbinfo.asp
ASP | 53 lines | 50 code | 3 blank | 0 comment | 1 complexity | 58d287585e662425ab60fbd5c05bece1 MD5 | raw file
1<!-- #INCLUDE FILE="../inc/mla_sql_include.asp" --> 2<% 3 Dim myDbName, myNodeId, myArrInfo, myArrFileInfo, myFileCount, i, myStrTree 4 myNodeId = Request.QueryString("nid") 5 myDbName = Request.QueryString("db") 6 openConnection 7 myStrTree = getTreeStr(Mid(myNodeId, 2), Array(myDbName)) 8 myArrInfo = getDbInfo(myDbName) 9 myArrFileInfo = getDbFileInfo(myDbName) 10 closeConnection 11 If isArray(myArrFileInfo) Then myFileCount = UBound(myArrFileInfo, 2) Else myFileCount = 0 End If 12%> 13<!-- #INCLUDE FILE="../inc/metaheader.asp" --> 14<BODY> 15 <P CLASS="treeinfo"><% = myStrTree %></P> 16 17 <TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 CLASS="hcontent" SUMMARY="Database Information"> 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 <TR><TD CLASS="info"><% = myTObj.getTerm(121) %> :</TD><TD><% =myArrInfo(0, 0) %></TD></TR> 20 <TR><TD CLASS="info"><% = myTObj.getTerm(122) %> :</TD><TD><% =myArrInfo(1, 0) %></TD></TR> 21 <TR><TD CLASS="info"><% = myTObj.getTerm(123) %> :</TD><TD><% =myArrInfo(2, 0) %></TD></TR> 22 <TR><TD CLASS="info"><% = myTObj.getTerm(131) %> :</TD><TD><% =myArrInfo(3, 0) %></TD></TR> 23 <TR><TD CLASS="info"><% = myTObj.getTerm(132) %> :</TD><TD><% =myArrInfo(4, 0) %></TD></TR> 24 <TR><TD CLASS="info"><% = myTObj.getTerm(133) %> :</TD><TD><% =myArrInfo(5, 0) %></TD></TR> 25 <TR><TD CLASS="info" COLSPAN=2> </TD></TR> 26 <TR><TD CLASS="info"><% = myTObj.getTerm(124) %> :</TD><TD> </TD></TR> 27 <% For i = 0 To myFileCount %> 28 <TR><TD CLASS="formlabel"><% = Trim(myArrFileInfo(0, i)) %></TD><TD> </TD></TR> 29 <TR> 30 <TD> </TD> 31 <TD> 32 <TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 ALIGN=CENTER SUMMARY="Database Files Information"> 33 <TR><TD CLASS="info"><% = myTObj.getTerm(125) %> :</TD><TD><% = myArrFileInfo(2, i) %></TD></TR> 34 <TR><TD CLASS="info"><% = myTObj.getTerm(126) %> :</TD><TD><% = myArrFileInfo(3, i) %></TD></TR> 35 <TR><TD CLASS="info"><% = myTObj.getTerm(127) %> :</TD><TD><% = myArrFileInfo(4, i) %></TD></TR> 36 <TR><TD CLASS="info"><% = myTObj.getTerm(128) %> :</TD><TD><% = myArrFileInfo(5, i) %></TD></TR> 37 <TR><TD CLASS="info"><% = myTObj.getTerm(129) %> :</TD><TD><% = myArrFileInfo(6, i) %></TD></TR> 38 <TR><TD CLASS="info"><% = myTObj.getTerm(130) %> :</TD><TD><% = myArrFileInfo(7, i) %></TD></TR> 39 </TABLE> 40 </TD> 41 </TR> 42 <% Next %> 43 </TABLE> 44 45 <SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"> 46 <!-- 47 if (window.parent.frames['Tree']) window.parent.frames['Tree'].oTree.expandNode('<% = myNodeId %>'); 48 //--> 49 </SCRIPT> 50 51</BODY> 52</HTML> 53<!-- #INCLUDE FILE="../inc/mla_sql_end.asp" -->