<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 = [