} else {
if ($xml_state == XML_USER) {
$username .= $data;
} else {
if ($xml_state == XML_PWD) {
$pwd .= $data;
function GetCorrectDataType($result, $j)
{
$data = NULL;
WriteLog("Enter GetCorrectDataType");
switch (mysql_field_type($result, $j)) {
case "int":
if (mysql_field_len($result, $j) <= 4) {
$data = "smallint";
} elseif (mysql_field_len($result, $j) <= 9) {
$data = "mediumint";
} else {
$data = "int";
}
break;
case "real":
if (mysql_field_len($result, $j) <= 10) {
$data = "float";
} else {
$data = "double";
}
break;
case "string":
$data = "varchar";
break;
case "blob":
$textblob = "TEXT";
if (strpos(mysql_field_flags($result, $j), "binary")) {
$textblob = "BLOB";
}
if (mysql_field_len($result, $j) <= 255) {
if ($textblob == "TEXT") {
$data = "tinytext";
} else {
$data = "tinyblob";
}
} elseif (mysql_field_len($result, $j) <= 65535) {
if ($textblob == "TEXT") {
$data = "mediumtext";
} else {
$data = "mediumblob";
}
} else {
if ($textblob == "TEXT") {
$data = "longtext";
} else {
$data = "longblob";
}
}
break;
case "date":
$data = "date";
break;
case "time":
$data = "time";
break;
case "datetime":
$data = "datetime";
break;
}
WriteLog("Exit GetCorrectDataType");
return convertxmlchars($data);
}
