public function create_table($maxtableid) { if ($maxtableid) { XDB::query('SET SQL_QUOTE_SHOW_CREATE=0', 'SILENT'); $db =& XDB::object(); $query = XDB::query("SHOW CREATE TABLE %t", array($this->get_table_name())); $create = $db->fetch_row($query); $createsql = $create[1]; $createsql = str_replace(XDB::table($this->get_table_name()), XDB::table($this->get_table_name($maxtableid)), $createsql); XDB::query($createsql); return true; } else { return false; } }
public function show_table_columns($table) { $data = array(); $db =& XDB::object(); if ($db->version() > '4.1') { $query = $db->query("SHOW FULL COLUMNS FROM " . XDB::table($table), 'SILENT'); } else { $query = $db->query("SHOW COLUMNS FROM " . XDB::table($table), 'SILENT'); } while ($field = @XDB::fetch($query)) { $data[$field['Field']] = $field; } return $data; }