[Openfirst-cvscommit] base/config index.php,1.6,1.7

[Tim G. <xt...@us...>]

Update of /cvsroot/openfirst/base/config
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19760

Modified Files:
	index.php 
Log Message:
Add encryption selection option to setup, show database statistics if they are supported by the database server type which is selected (currently supports mysql and mssql); this functionality is based loosely on the phpBB statistics

Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/base/config/index.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** index.php	1 Nov 2003 18:16:07 -0000	1.6
--- index.php	5 Apr 2004 10:26:50 -0000	1.7
***************
*** 38,41 ****
--- 38,80 ----
    </tr>
  </table>
+ 
+ <?php
+  // The statistics feature is loosely inspired by that of phpBB.
+ 
+  if($dbasetype == "mysql" || $dbasetype == "mssql") { ?>
+ <table>
+  <tr>
+   <th colspan="2">Statistics</th>
+  </tr>
+  <tr>
+   <th>Database Version</th><td>
+ <?php
+   if($dbasetype == "mysql") { 
+     $v = ofirst_dbfetch_object(ofirst_dbquery("SELECT VERSION() AS mysql_version"));
+     echo("MySQL $v->mysql_version");
+   } elseif($dbasetype == "mssql") {
+     echo("Microsoft SQL Server");
+   }
+ ?></td>
+  </tr>
+  <tr>
+   <th>Database Size</th><td>
+ <?php
+   if($dbasetype == "mysql") {
+     $dbsize = 0;
+     $dq = ofirst_dbquery("SHOW TABLE STATUS FROM $sqldatabase");
+     while($d = ofirst_dbfetch_object($dq)) {
+       $dbsize += $d->Data_length + $d->Index_length;
+     }
+     echo (int) (($dbsize + 0.5) / 1024 * 10) / 10 . " KB";
+   } elseif($dbasetype == "mssql") {
+     $s = ofirst_dbfetch_object(ofirst_dbquery("SELECT ((SUM(size) * 8.0) * 1024.0) as dbsize FROM sysfiles"));
+     echo (int) (( $s->dbsize + 0.5) / 1024 * 10) / 10 . " KB";
+   }
+ ?>
+ </table>
+ <?php } ?>
+ 
+ <br>
  <table width="50%">
    <tr>