<?
include("../inc/config.inc.php");
	head();
	mn_root("tb_editor");

if ( $tblister!="") {
	?><TABLE width=600 class=table_border align=center>
	<TR>
		<TD><PRE>&lt;?
include("../inc/config.inc.php");
head();
mn_root("yyy");

$tbname="<? echo $tblister?>";
<?
$result = mysql_query("SHOW COLUMNS FROM $tblister");
if (!$result) {
   echo 'Could not run query: ' . mysql_error();
   exit;
}

$c=0;
   while ($r = mysql_fetch_assoc($result)) {
	   $c++;
	   if ($r[Field]=="id" || $r[Field]=="ordr" ) {
		continue;
	   }
	   //printr($r);
	   $fieldtype='text';
	   if ($row[Type]=="longtext" ) {
		   $fieldtype='longtext';
	   }
	   if ($row[Type]=="double" ) {
		   $fieldtype='number';
	   }
       //print_r($row);
	   $ordr=1000;
	   if ($r[Field]=='classid') {
			$ordr=50;
	   }
	   if ($r[Field]=='name') {
			$ordr=100;
	   }
	   if ($r[Field]=='type') {
			$ordr=150;
	   }
?>


$c[<? echo $c;?>][text]="<? echo ucfirst($r[Field]);?>::l::<? echo ucfirst($r[Field]);?>";
$c[<? echo $c;?>][field]="<? echo $r[Field];?>";
$c[<? echo $c;?>][fieldtype]="<? echo $fieldtype;?>";
$c[<? echo $c;?>][descr]="";
$c[<? echo $c;?>][defval]="<? echo $r["Default"];?>";<?
   }
   
   ?>


//dsp
<?
$result = mysql_query("SHOW COLUMNS FROM $tblister");
if (!$result) {
   echo 'Could not run query: ' . mysql_error();
   exit;
}

$c=0;
   while ($r = mysql_fetch_assoc($result)) {
	   $c++;
	   if ($r[Field]=="id" || $r[Field]=="ordr" ) {
		continue;
	   }
	   //printr($r);
	   $fieldtype='text';
	   if ($row[Type]=="longtext" ) {
		   $fieldtype='longtext';
	   }
	   if ($row[Type]=="double" ) {
		   $fieldtype='number';
	   }
       //print_r($row);
	   $ordr=1000;
	   if ($r[Field]=='classid') {
			$ordr=50;
	   }
	   if ($r[Field]=='name') {
			$ordr=100;
	   }
	   if ($r[Field]=='type') {
			$ordr=150;
	   }
?>


$dsp[<? echo $c;?>][text]="<? echo ucfirst($r[Field]);?>::l::<? echo ucfirst($r[Field]);?>";
$dsp[<? echo $c;?>][field]="<? echo $r[Field];?>";
$dsp[<? echo $c;?>][width]="30%";<?
   }
   
   ?>



fixform_tablelister($tbname," 1 ",$dsp,"yes","yes","yes","mi=$mi",$c);

foot();
?&gt;</PRE></TD>
	</TR>
	</TABLE><?
}

?>
<TABLE width=780 align=center>
<TR>
	<TD><?
$result = tmq_list_tables($dbname);
while ($row = mysql_fetch_row($result)) {
    echo "Table:<A HREF=\"import.php?editorid=$row[0]\" onclick=\"return confirm('sure?');\"> $row[0]</A>";
	echo " -- <A HREF=\"import.php?editorid=$row[0]&dsp=yes\">display only</A>";
	echo " -- <A HREF=\"preimport.php?tblister=$row[0]\">display as tblister</A><BR>";
}
?>

</TD>
</TR>
</TABLE><?

foot();
?>