browser = Array();
$this->php = Array();
$this->server = Array();
$this->database = Array();
$this->phpBB = Array();
}
function table_exists($table_name) {
global $db;
$found_table = false;
// Check to see if the requested Zen Cart table exists
$sql = "SHOW TABLES like '".$table_name."'";
$tables = $db->Execute($sql);
//echo 'tables_found = '. $tables->RecordCount() .'
';
if ($tables->RecordCount() > 0) {
$found_table = true;
}
return $found_table;
}
function field_exists($table_name, $field_name) {
global $db;
$sql = "show fields from " . $table_name;
$result = $db->Execute($sql);
while (!$result->EOF) {
// echo 'fields found='.$result->fields['Field'].'
';
if ($result->fields['Field'] == $field_name) {
return true; // exists, so return with no error
}
$result->MoveNext();
}
return false;
}
function field_type($table_name, $field_name, $field_type, $return_found = false) {
global $db;
$sql = "show fields from " . $table_name;
$result = $db->Execute($sql);
while (!$result->EOF) {
// echo 'fields found='.$result->fields['Field'].'
';
if ($result->fields['Field'] == $field_name) {
if ($result->fields['Type'] == $field_type) {
return true; // exists and matches required type, so return with no error
} elseif ($return_found) {
return $result->fields['Type']; // doesn't match, so return what it "is", if requested
}
}
$result->MoveNext();
}
return false;
}
}
?>