{
$data_queries[] = substr($line, 0, strlen($line) - 1);
+ // this line does not, too
+ }
+ elseif (strtolower(substr($line,0,6)) == "update")
+ {
+ $data_queries[] = substr($line, 0, strlen($line) - 1);
+
// this line does not, too
}
elseif (strtolower(substr($line, 0, 20)) == "drop table if exists")
$table = true;
$table_queries[] = $line . "\n";
}
+ elseif (strtolower(substr($line, 0, 11)) == "alter table")
+ {
+ $data_queries[] = substr($line, 0, strlen($line) - 1);
+ }
// the current line belongs to a create sql query
}
{
// create sql query ending in this line
- if (strtolower(substr($line, 0, 1)) == ")")
+ if (strtolower(substr($line, 0, 1)) == ")") {
$table = false;
+ $line = substr($line,0,strlen($line)-1);
+ }
$table_queries[count($table_queries) - 1] .= $line . "\n";
}
}
{
//if ($CONF['import_error']) echo $data_query."\n<div class=\"bold_left\">".mysql_error()."</div><br>\n";
$sql_error = true;
+ return false;
}
}
}