<?php
	; 
		
        include ("../inc/config.inc.php");
		head();
        mn_root("upgrade_table");
			pagesection("Upgrade Table");

?><BR>
<?
$link=mysql_connect($ui_host, $ui_user, $ui_passwd);
if (!$link) {
    echo 'Could not connect to mysql';
    exit;
}


/////////////////tables form our db
$sql = "SHOW columns FROM $ui_table";
$result = tmq($sql);
$my_col=Array();
while ($r=tmq_fetch_array($result)) {
	$my_col[]=$r[0];
}
///////////////////
$sql = "SHOW columns FROM $ui_table";
$result = mysql_db_query($ui_dbname,$sql,$link);
$my_col=Array();
while ($r=tmq_fetch_array($result)) {
	$my_col[]=$r[0];
}

if ($isclearold=="yes") {
	tmq("delete from $ui_table");
}

///print_r($my_col);

$sql = "select * FROM $ui_table";
$result = mysql_db_query($ui_dbname,$sql,$link);
$content="";
$i=0;
		while ($row=mysql_fetch_row($result)) {
            $insert = "INSERT INTO $ui_table set ";
            for ($j=0; $j < mysql_num_fields($result); $j++) {
				if (!in_array($my_col[$j],$my_col)) {
					echo "not in array $my_col[$j]<BR>";
					continue;
				}
				$insert.=" $my_col[$j]=";
                if (!isset($row[$j]))
                    $insert.="NULL,";
                else if ($row[$j] != "")
                    $insert.="'" . addslashes($row[$j]) . "',";
                else
                    $insert.="'',";
			}
			$insert=ereg_replace(",$", "", $insert);
			$insert.=";\n";
			$content.=$insert;
	
			tmq($insert);
			$i++;
		}
			
?><CENTER><? echo getlang("เรียบร้อย นำเข้าจำนวน $i รายการ::l::DONE,  ecexcuted  $i  records"); ?>.</CENTER>
<BR><?
foot();
?>