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

?><BR>
<TABLE align=center width=650 class=table_border>
<FORM METHOD=POST ACTION="step2.php">
<TR class=table_head>
	<TD colspan=5><? echo getlang("กรุณาเลือกตาราง::l::Please choose table.");?></TD>
</TR>
<TR class=table_head>
	<TD ><? echo getlang("ชื่อตาราง::l::Table name.");?></TD>
	<TD ><? echo getlang("จำนวนคอลัมน์::l::Columns.");?></TD>
	<TD ><? echo getlang("จำนวนข้อมูล::l::Records.");?></TD>
	<TD ><? echo getlang("คอลัมน์ปัจจุบัน::l::Current.Col");?></TD>
	<TD ><? echo getlang("ข้อมูลปัจจุบัน::l::Current.Rec.");?></TD>
</TR>
<?
$link=mysql_connect($ui_host, $ui_user, $ui_passwd);
if (!$link) {
    echo 'Could not connect to mysql';
    exit;
}


/////////////////tables form our db
        $tables=mysql_list_tables($dbname, $conn);
        $num_tables=@tmq_num_rows($tables);
        $i=0;
		$tbdb=Array();
        while ($i < $num_tables) {
			$tbdb[]=  mysql_tablename($tables, $i);
			$i++;
		}
/////////////////
//print_r($tbdb);

$sql = "SHOW TABLES FROM $ui_dbname";
$result = mysql_db_query($ui_dbname,$sql,$link);

if (!$result) {
    echo "DB Error, could not list tables\n";
    echo 'MySQL Error: ' . mysql_error();
    exit;
}

while ($row = mysql_fetch_row($result)) {
?>
<TR>
	<TD class=table_td><INPUT TYPE="radio" NAME="ui_table" value="<? echo $row[0]?>" style="border: 0px;"> <? echo $row[0]?></TD>
	<TD class=table_td align=right><?
	$sql="show columns from  $row[0]";
	$info = mysql_db_query($ui_dbname,$sql,$link);
	echo mysql_error();
	echo number_format(tmq_num_rows($info));
?></TD>
	<TD class=table_td align=right><?
	$sql="select count(*) from $row[0]";
	$info = mysql_db_query($ui_dbname,$sql,$link);
	echo mysql_error();
	$info=tmq_fetch_array($info);
	echo number_format($info[0]);
?></TD>
	<TD class=table_td align=right><?
if (in_array("$row[0]", $tbdb)) {
	$sql="show columns from  $row[0]";
	$info = tmq($sql);
	echo mysql_error();
	echo number_format(tmq_num_rows($info));
} else {
	echo " - ";
}
?></TD>
	<TD class=table_td align=right><?
if (in_array("$row[0]", $tbdb)) {
	$info = tmq("select count(*) from $row[0]");
	$info=tmq_fetch_array($info);
	echo number_format($info[0]);
} else {
	echo " - ";
}
?></TD>
</TR>
<?
}

mysql_free_result($result);
//mysql_close($link);

?>
<INPUT TYPE="hidden" name="ui_host" value="<?echo $ui_host?>">
<INPUT TYPE="hidden" name="ui_user" value="<?echo $ui_user?>">
<INPUT TYPE="hidden" name="ui_passwd" value="<?echo $ui_passwd?>">
<INPUT TYPE="hidden" name="ui_dbname" value="<?echo $ui_dbname?>">
<TR>
	<TD class=table_td colspan=5 align=center><? echo getlang("ล้างข้อมูลในตารางเดิม::l::Clear data in table");?> <INPUT TYPE="checkbox" NAME="isclearold" value="yes"  style="border: 0px"></TD>
</TR>
<TR>
	<TD class=table_td colspan=5 align=center><INPUT TYPE="submit" value="     Connect     "></TD>
</TR>
</FORM></TABLE>
<BR><?
foot();
?>