8){
for ($i = 8; $i < $count; $i++) {
$poclok.=$pab[$i].",";
//$poclok.="bb";
}
}
print("odpoved5=".$dta);
print("&odpoved4=".$strTA4);
print("&odpoved1=".$montents);
print("&odpoved6=".$strTB7);
//echo "odpoved5=".$dta;
//print("&odpoved1=".$odpo);
//echo "odpoved4=".$strTA4;
$this_table="jdatavlak";
$this_tablev=$this_table."v";
//$cislo="AA";
//$prijezd="BB";
//$odjezd="CC";
require_once('OtevriDB.inc');
do{
if(!OtevriDB()) break;
$delstan=StrrPos (" " . $strTB4, "_");
//$delstan=StrrPos ($delstan . $strTB4, "_");
$jmstan=SubStr ($strTB4,0, $delstan-1);
$delstan=StrrPos (" " . $jmstan, "_");
$jmstan=SubStr ($strTB4,0, $delstan-1);
$delstan=StrrPos (" " . $jmstan, "_");
$jmstan=SubStr ($strTB4,0, $delstan-1);
//$jmstan=$delstan;
$datstan=SubStr ($strTB4,$delstan);
$kolv=0;
if (mysql_query("SELECT 1 FROM `".$this_table."` LIMIT 0"))
{
$avysled=mysql_query("SELECT * FROM ".$this_table."");
$apoc=mysql_num_rows($avysled);
mysql_query("INSERT INTO ".$this_table."(stan, dstan, cislo, odjezd, prijezd, z_kol, na_kol, po_kol, datum, smer, lokomotiva ) values ('" . $jmstan . "','" . $datstan . "','" . $pab[0] . "','" . $pab[1] . "','" . $pab[2] . "','" . $pab[3] . "','" . $pab[4] . "','" . $pab[5] . "','" . $pab[6] . "','" . $pab[7] . "','" . $poclok . "')");
$jmstanv=mysql_insert_id();
for ($iv = 0; $iv < $countv; $iv++) {
$kolv++;
if($kolv>4){
if($pabv[$iv-3]>4){
}
mysql_query("INSERT INTO ".$this_tablev."(v_id, pocet, stav, rada, rezim, firma, material ) values ('" . $jmstanv . "','" . $pabv[$iv-4] . "','" . $pabv[$iv-3] . "','" . $pabv[$iv-3] . "','" . $pabv[$iv-2] . "','" . $pabv[$iv-1] . "','" . $pabv[$iv] . "')");
$kolv=0;
}
}
$poc=mysql_affected_rows();
//echo "existuje
";
//echo "pocet vytvorenych zaznamu ".$poc."
";
} else
{
mysql_query("CREATE TABLE ".$this_table."(id INT AUTO_INCREMENT PRIMARY KEY, stan VARCHAR(20), dstan VARCHAR(20), cislo VARCHAR(20), odjezd VARCHAR(20), prijezd VARCHAR(20), z_kol VARCHAR(20), na_kol VARCHAR(20), po_kol VARCHAR(20), datum VARCHAR(20), smer VARCHAR(20), lokomotiva VARCHAR(100))");
mysql_query("INSERT INTO ".$this_table."(stan, dstan, cislo, odjezd, prijezd, z_kol, na_kol, po_kol, datum, smer, lokomotiva ) values ('" . $jmstan . "','" . $datstan . "','" . $pab[0] . "','" . $pab[1] . "','" . $pab[2] . "','" . $pab[3] . "','" . $pab[4] . "','" . $pab[5] . "','" . $pab[6] . "','" . $pab[7] . "','" . $poclok . "')");
$jmstanv=mysql_insert_id();
mysql_query("CREATE TABLE ".$this_tablev."(id INT AUTO_INCREMENT PRIMARY KEY, v_id VARCHAR(20), pocet VARCHAR(20), rada VARCHAR(20), rezim VARCHAR(20), firma VARCHAR(20), material VARCHAR(20))");
//mysql_query("INSERT INTO ".$this_tablev."(v_id, pocet, rada, rezim, firma, material ) values ('" . $jmstan . "','" . $datstan . "','" . $pab[0] . "','" . $pab[1] . "','" . $pab[2] . "','" . $pab[3] . "')");
for ($iiv = 0; $iiv < $countv; $iiv++) {
$kolv++;
if($kolv>4){
mysql_query("INSERT INTO ".$this_tablev."(v_id, pocet, rada, rezim, firma, material ) values ('" . $jmstanv . "','" . $pabv[$iiv-4] . "','" . $pabv[$iiv-3] . "','" . $pabv[$iiv-2] . "','" . $pabv[$iiv-1] . "','" . $pabv[$iiv] . "')");
$kolv=0;
}
}
$ppoc=mysql_affected_rows();
//echo "Nově vytvořeno
";
//echo "pocet vytvorenych zaznamu ".$ppoc."
";
}
$bvysled=mysql_query("SELECT * FROM ".$this_table."");
$bpoc=mysql_num_rows($bvysled);
mysql_close();
//echo "pocet pocatecnich zaznamu ".$apoc."
";
//echo "pocet konecnych zaznamu ".$bpoc."
";
//echo "zapsano";
}while(false);
?>