function DownGrade($s, $show = true)
{
$tmp = explode(",", $s);
//echo "<pre>";print_r($tmp);echo "</pre>";
for ($i = 0; $i < count($tmp); $i++) {
$t = strtolower($tmp[$i]);
if (strpos($t, "collate ")) {
$tmp2 = explode(" ", $tmp[$i]);
for ($j = 0; $j < count($tmp2); $j++) {
if (strtolower($tmp2[$j]) == "collate") {
$tmp2[$j] = "";
$tmp2[$j + 1] = save_bracket($tmp2[$j + 1]);
$j++;
}
}
$tmp[$i] = implode(" ", $tmp2);
}
if (strpos($t, "engine=")) {
$tmp2 = explode(" ", $tmp[$i]);
for ($j = 0; $j < count($tmp2); $j++) {
if (substr(strtoupper($tmp2[$j]), 0, 7) == "ENGINE=") {
$tmp2[$j] = "TYPE=" . substr($tmp2[$j], 7, strlen($tmp2[$j]) - 7);
}
if (substr(strtoupper($tmp2[$j]), 0, 8) == "CHARSET=") {
$tmp2[$j] = "";
$tmp2[$j - 1] = save_bracket($tmp2[$j - 1]);
}
if (substr(strtoupper($tmp2[$j]), 0, 8) == "COLLATE=") {
$tmp2[$j] = save_bracket($tmp2[$j]);
$tmp2[$j - 1] = "";
}
}
$tmp[$i] = implode(" ", $tmp2);
}
// character Set sprache entfernen
if (strpos($t, "character set")) {
$tmp2 = explode(" ", $tmp[$i]);
$end = false;
for ($j = 0; $j < count($tmp2); $j++) {
if (strtolower($tmp2[$j]) == "character") {
$tmp2[$j] = '';
$tmp2[$j + 1] = save_bracket($tmp2[$j + 1]);
$tmp2[$j + 2] = save_bracket($tmp2[$j + 2]);
}
}
$tmp[$i] = implode(" ", $tmp2);
}
if (strpos($t, "timestamp")) {
$tmp2 = explode(" ", $tmp[$i]);
$end = false;
for ($j = 0; $j < count($tmp2); $j++) {
if ($end) {
$tmp2[$j] = "";
}
if (strtolower($tmp2[$j]) == "timestamp") {
$tmp2[$j] = "TIMESTAMP(14)";
$end = true;
}
}
$tmp[$i] = implode(" ", $tmp2);
}
}
$t = implode(",", $tmp);
if (substr(rtrim($t), -1) != ";") {
$t = rtrim($t) . ";";
}
return $t;
}
function DownGrade($s, $show = true)
{
// if (MSD_NEW_VERSION && strpos(strtolower($s),"collate ") && ($show) ) {
// return $s;
// } else {
$tmp = explode(",", $s);
//echo "<pre>";print_r($tmp);echo "</pre>";
for ($i = 0; $i < count($tmp); $i++) {
$t = strtolower($tmp[$i]);
if (strpos($t, "collate ")) {
$tmp2 = explode(" ", $tmp[$i]);
for ($j = 0; $j < count($tmp2); $j++) {
if (strtolower($tmp2[$j]) == "collate") {
$tmp2[$j] = "";
$tmp2[$j + 1] = save_bracket($tmp2[$j + 1]);
$j++;
}
}
$tmp[$i] = implode(" ", $tmp2);
}
if (strpos($t, "engine=")) {
$tmp2 = explode(" ", $tmp[$i]);
for ($j = 0; $j < count($tmp2); $j++) {
//echo $j.": ".$tmp2[$j]."<br>";
if (substr(strtoupper($tmp2[$j]), 0, 7) == "ENGINE=") {
$tmp2[$j] = "TYPE=" . substr($tmp2[$j], 7);
}
if (substr(strtoupper($tmp2[$j]), 0, 8) == "CHARSET=") {
$tmp2[$j] = "";
$tmp2[$j - 1] = save_bracket($tmp2[$j - 1]);
}
if (substr(strtoupper($tmp2[$j]), 0, 8) == "COLLATE=") {
$tmp2[$j] = save_bracket($tmp2[$j]);
if (isset($tmp2[$j + 1])) {
$tmp2[$j + 1] = save_bracket($tmp2[$j + 1]);
}
$tmp2[$j - 1] = "";
}
}
$tmp[$i] = implode(" ", $tmp2);
}
// collate entfernen
if (strpos($t, "collate")) {
$tmp2 = explode(" ", $tmp[$i]);
$end = false;
for ($j = 0; $j < count($tmp2); $j++) {
if (strtolower($tmp2[$j]) == "collate") {
$tmp2[$j] = save_bracket($tmp2[$j]);
$tmp2[$j + 1] = save_bracket($tmp2[$j + 1]);
}
}
$tmp[$i] = implode(" ", $tmp2);
}
// character Set sprache entfernen
if (strpos($t, "character set")) {
$tmp2 = explode(" ", $tmp[$i]);
$end = false;
for ($j = 0; $j < count($tmp2); $j++) {
if (strtolower($tmp2[$j]) == "character") {
$tmp2[$j] = '';
$tmp2[$j + 1] = save_bracket($tmp2[$j + 1]);
$tmp2[$j + 2] = save_bracket($tmp2[$j + 2]);
}
}
$tmp[$i] = implode(" ", $tmp2);
}
if (strpos($t, "timestamp")) {
$tmp2 = explode(" ", $tmp[$i]);
$end = false;
for ($j = 0; $j < count($tmp2); $j++) {
if ($end) {
$tmp2[$j] = "";
}
if (strtolower($tmp2[$j]) == "timestamp") {
$tmp2[$j] = "TIMESTAMP(14)";
$end = true;
}
}
$tmp[$i] = implode(" ", $tmp2);
}
}
$t = implode(",", $tmp);
if (substr(rtrim($t), -1) != ";") {
$t = rtrim($t) . ";";
}
// if (strpos($t,'en_rules')) die ("<hr>".$t."</hr>");
return $t;
// }
}
