<div id="page-inner">
<div id="tabContainer"></div>
</div>
<script type="text/javascript">
//v2
var showTimer,hideTimer;
var arr = [
<?php
$com = "";
foreach ($dbs as $db) {
$owner = mysql__select_val("SELECT concat(ugr_FirstName,' ',ugr_LastName,' ',ugr_eMail,', ',ugr_Department,' '," . "ugr_Organisation,' ',ugr_State,' ',ugr_Interests) FROM " . $db . ".sysUGrps where ugr_id=2");
$owner = str_replace("'", "\\'", $owner);
$owner = str_replace("\n", "", $owner);
//ID Records Values RecTypes Fields Terms Groups Users Version DB Files Modified Access
print $com . "['" . substr($db, 4) . "'," . mysql__select_val("select cast(sys_dbRegisteredID as CHAR) from " . $db . ".sysIdentification where 1") . "," . mysql__select_val("select count(*) from " . $db . ".Records") . "," . mysql__select_val("select count(*) from " . $db . ".recDetails") . "," . mysql__select_val("select count(*) from " . $db . ".defRecTypes") . "," . mysql__select_val("select count(*) from " . $db . ".defDetailTypes") . "," . mysql__select_val("select count(*) from " . $db . ".defTerms") . "," . mysql__select_val("select count(*) from " . $db . ".sysUGrps where ugr_Type='workgroup'") . "," . mysql__select_val("select count(*) from " . $db . ".sysUGrps where ugr_Type='user'") . "," . mysql__select_val("select concat_ws('.',cast(sys_dbVersion as char),cast(sys_dbSubVersion as char)) " . " from " . $db . ".sysIdentification where 1") . "," . mysql__select_val("SELECT Round(Sum(data_length + index_length) / 1024 / 1024, 1)" . " FROM information_schema.tables where table_schema='" . $db . "'") . "," . round(dirsize(HEURIST_UPLOAD_ROOT . substr($db, 4) . '/') / 1024 / 1024, 1) . ",'" . mysql__select_val("select max(rec_Modified) from " . $db . ".Records") . "','" . mysql__select_val("select max(ugr_LastLoginTime) from " . $db . ".sysUGrps") . "','" . $owner . "']";
$com = ",\n";
}
//foreach
?>
];
var myDataSource = new YAHOO.util.LocalDataSource(arr, {
responseType : YAHOO.util.DataSource.TYPE_JSARRAY,
responseSchema : {
fields: ["dbname","db_regid","cnt_recs", "cnt_vals", "cnt_rectype",
"cnt_fields", "cnt_terms", "cnt_groups", "cnt_users", "db_version",
"size_db", "size_file", "date_mod", "date_login","owner"]
}});
?>
<!-- Table generation script -->
<script type="text/javascript">
//v2
var showTimer,hideTimer;
var arr = [
<?php
$com = "";
$i = 0;
foreach ($dbs as $db) {
$owner = mysql__select_val("SELECT concat(ugr_FirstName,' ',ugr_LastName,' ',ugr_eMail,' ',ugr_Organisation) " . "FROM " . $db . ".sysUGrps where ugr_id=2");
$owner = str_replace("'", "\\'", $owner);
$owner = str_replace("\n", "", $owner);
//ID Records Values RecTypes Fields Terms Groups Users Version DB Files Modified Access Owner Deleteable
print $com . "['" . substr($db, 4) . "'," . mysql__select_val("select cast(sys_dbRegisteredID as CHAR) from " . $db . ".sysIdentification where 1") . "," . mysql__select_val("select count(*) from " . $db . ".Records") . "," . mysql__select_val("select count(*) from " . $db . ".recDetails") . "," . mysql__select_val("select concat_ws('.',cast(sys_dbVersion as char),cast(sys_dbSubVersion as char)) " . " from " . $db . ".sysIdentification where 1") . "," . mysql__select_val("select max(rec_Modified) from " . $db . ".Records") . "','" . mysql__select_val("select max(ugr_LastLoginTime) from " . $db . ".sysUGrps") . "','" . $owner . "','" . $sysadmin . "']";
$com = ",\n";
}
//foreach
?>
];
var myDataSource = new YAHOO.util.LocalDataSource(arr, {
responseType : YAHOO.util.DataSource.TYPE_JSARRAY,
responseSchema : {
fields: ["dbname","db_regid","cnt_recs", "cnt_vals", "cnt_rectype",
"cnt_fields", "cnt_terms", "cnt_groups", "cnt_users", "db_version",
"size_db", "size_file", "date_mod", "date_login","owner","deleteable"]
}});
var myColumnDefs = [
