function getAlldbFields($tableName, $filter = array())
{
$allFields = $this->getAllFields($tableName);
$alldbFields = array();
if (!isError($allFields)) {
foreach ($allFields as $field) {
$type = $field['Type'];
if (substr($type, 0, 3) == 'int') {
$dbtype = DB_TYPE_INT;
} elseif (substr($type, 0, 6) == 'string') {
$dbtype = DB_TYPE_STRING;
} elseif (substr($type, 0, 5) == 'text') {
$dbtype = DB_TYPE_TEXT;
} else {
$dbtype = DB_TYPE_STRING;
}
$maxSize = $field['MaxLength'];
$dbField = new dbField($field['Field'], $dbtype, (int) $maxSize);
$dbField->canBeNull = $field['Null'];
if (!in_array($dbField->getName(), $filter)) {
//var_dump ($dbField);
$alldbFields[] = $dbField;
}
}
return $alldbFields;
} else {
return $allFields;
}
}
function getAlldbFields($tableName, $filter = array())
{
$allFields = $this->getAllFields($tableName);
$alldbFields = array();
if (!isError($allFields)) {
foreach ($allFields as $field) {
$type = $field['Type'];
if (substr($type, 0, 3) == 'int') {
$dbtype = DB_TYPE_INT;
} elseif (substr($type, 0, 7) == 'varchar') {
$dbtype = DB_TYPE_STRING;
} elseif (substr($type, 0, 5) == 'text') {
$dbtype = DB_TYPE_TEXT;
} elseif (substr($type, 0, 5) == 'enum') {
$dbtype = DB_TYPE_ENUM;
} else {
$dbtype = DB_TYPE_STRING;
}
$maxSize = 0;
if ($dbtype != DB_TYPE_ENUM) {
if (strpos($type, '(') and strpos($type, '(')) {
$maxSize = substr($type, strpos($type, '(') + 1, strpos($type, ')') - strpos($type, '(') - 1);
}
}
$dbField = new dbField($field['Field'], $dbtype, (int) $maxSize);
if ($field['Null']) {
$dbField->canBeNull = true;
}
if (!in_array($dbField->getName(), $filter)) {
$alldbFields[] = $dbField;
}
}
return $alldbFields;
} else {
return $allFields;
}
}
function dbEnumField($name, $type, $value)
{
parent::dbField($name, $type);
$this->_posValues = array();
for ($i = 2; $i < func_num_args(); $i++) {
$this->_posValues[] = func_get_arg($i);
}
}
