if (strlen($autoincrement) > 0) { $table_key = $autoincrement; } #------------- # 0.0.4: END # define('EDIT_TABLE_RRN_FIELD', $table_key); define('EDIT_TABLE_IS_LAST_USER', $isLAST_USER); # 0.0.2 array_push($_RESERVED_FIELDS, $table_key); } //echo '$autoincrement['.$autoincrement.']<br>'; //echo '$table_key['.$table_key.']<br>'; //echo '<code>The record key in use for this table is: <b>'.EDIT_TABLE_RRN_FIELD.'</b></code><br />'; #debug if (!defined('EDIT_TABLE_DESC')) { $info = table_get_table_info(MAINSITE_DB, EDIT_TABLE_NAME); $desc = $info[0]['Comment']; if ($desc == '') { $desc = $info[0]['Table']; } define('EDIT_TABLE_DESC', $desc); } //var_dump($info); //echo __FILE__.'|'.EDIT_TABLE_NAME.'|'.$_T_FIELDS.'|'.time().'<br>'; //include_once(SITE_ROOT.'common/fun2inc/get_last_table_update.inc'); //include_once(SITE_ROOT.'common/fun2inc/get_site_languanges.inc'); if (!defined('IN_TABLE_DEFS')) { // # prepare a list with the available definitions // # // include_once(SITE_ROOT.'common/fun2inc/get_dir_list.inc'); // #
function table_get_tables($db) { #~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ $sql = 'SHOW FULL TABLES FROM `' . $db . '` '; $sth = db_query($sql, __LINE__, __FILE__); $rows = db_fetch($sth[0]); /* var_dump($rows); [0]=> array(2) { ["Tables_in_dev_thinkdog"]=> string(5) "citta" ["Table_type"]=> string(10) "BASE TABLE" } } */ for ($i = 0; $i < $sth[1]; $i++) { $table = $rows[$i]['Tables_in_' . $db]; //echo $table.'<br>'; $table_fields = table_get_table_info($db, $table); //var_dump($table_fields);echo '<hr>'; //var_dump($table_fields[0]['Comment']);echo '<hr>'; $rows[$i]['Name'] = $rows[$i]['Tables_in_' . $db]; $rows[$i]['Comment'] = $table_fields[0]['Comment']; } //var_dump($rows);echo '<hr>'; return $rows; }