<?php
$strTA0=$HTTP_POST_VARS['jmb'];
$strTA1=$HTTP_POST_VARS['sado'];
$strTA2=$HTTP_POST_VARS['sadoo'];
$strTA3=$HTTP_POST_VARS['spos'];
$strTA4=$HTTP_POST_VARS['spoos'];
$strTB1=$HTTP_POST_VARS['tab'];
$strTB3=$HTTP_POST_VARS['grid'];
$strTB7=$HTTP_POST_VARS['hrid'];
$strTB4=$HTTP_POST_VARS['ad'];
$ppoc=0;
if($strTA1!=""){
file_put_contents($strTB1."/".$strTA1.".txt", $strTA3); 
}
if($strTA2!=""){
file_put_contents($strTB1."/".$strTA2.".txt", $strTA4);
}
$contents = file_get_contents($strTB1."/".$strTB4.".txt");
$misto =StrPos ($contents, "praaa=");
$mmisto =StrPos ($contents, "hle=");

$am =$mmisto+4;
$bm =$misto-$am;
$vysledek = SubStr ($contents, 4, $mmisto-4);//je to delka, nikoli misto
$avysledek = "now=".$vysledek.$strTB7;
$vvysledek = SubStr ($contents, $am, $bm);
$bvysledek = "hle=".$vvysledek.$strTB3;
$cvysledek =$avysledek.$bvysledek;
file_put_contents($strTB1."/".$strTB4.".txt", $cvysledek); 
$zk2 = file_get_contents($strTB1."/".$strTB4.".txt");
$dta = strlen($zk2);
//$deldatab=StrPos (" " . $strTB3, "praaa=");
$deldatab=StrPos ($strTB3, "praaa=");
if(StrPos ($strTB3, "*")===0){
$vysdatab = SubStr ($strTB3, 1, $deldatab-1);
}else
{
$vysdatab = SubStr ($strTB3, 0, $deldatab);
}
$pab=explode(",",$vysdatab);
$strTB7v=$strTB7;
if(StrPos ($strTB7, "*")===0){
$strTB7v=SubStr ($strTB7,1);
}
$pabv=explode(",",$strTB7v);
$count = count($pab);
$countv = count($pabv);
if($count>8){
for ($i = 8; $i < $count; $i++) {
if($i==8){
$poclok=",".$pab[$i].",";
}else{
$poclok.=$pab[$i].",";
}
}
}
$pocix=0;
$polv=0;
for ($pv = 0; $pv < $countv; $pv++) {
$polv++;
if($polv>4){
$pocix+=$pabv[$pv-4];
$polv=0;
}
}
$this_table=$strTA0;
$this_tablev=$this_table."v";
$delstan=StrrPos ($strTB4, "-");
$jmstan=SubStr ($strTB4,0, $delstan);
$delstan=StrrPos ($jmstan, "-");
$jmstan=SubStr ($strTB4,0, $delstan);
$delstan=StrrPos ($jmstan, "-");
$jmstan=SubStr ($strTB4,0, $delstan);
$datstan=SubStr ($strTB4,$delstan+1);
require_once('OtevriDB.inc');
do{
if(!OtevriDB()) break;
$kolv=0;
if (mysql_query("SELECT 1 FROM `".$this_table."` LIMIT 0"))
{
mysql_query("INSERT INTO ".$this_table."(stan, dstan, cislo, odjezd, prijezd, z_kol, na_kol, po_kol, datum, smer, cel, lokomotiva ) values ('" . $jmstan . "','" . $datstan . "','" . $pab[0] . "','" . $pab[1] . "','" . $pab[2] . "','" . $pab[3] . "','" . $pab[4] . "','" . $pab[5] . "','" . $pab[6] . "','" . $pab[7] . "','" . $pocix . "','" . $poclok . "')");
$jmstanv=mysql_insert_id();
$poc=mysql_affected_rows();
for ($iv = 0; $iv < $countv; $iv++) {
$kolv++;
if($kolv>4){
$bbix=$pabv[$iv-3];
$bix="";
$pocbix=strrpos($pabv[$iv-3], "!");
if(strrpos($pabv[$iv-3], "!")===false)
{
}else
{
$bbix=SubStr ($pabv[$iv-3], $pocbix+1);
$bix=SubStr ($pabv[$iv-3],0, $pocbix+1);
}
mysql_query("INSERT INTO ".$this_tablev."(v_id, pocet, stav, rada, rezim, firma, material ) values ('" . $jmstanv . "','" . $pabv[$iv-4] . "','" . $bix . "','" . $bbix . "','" . $pabv[$iv-2] . "','" . $pabv[$iv-1] . "','" . $pabv[$iv] . "')");
$ppoc+=mysql_affected_rows();
$kolv=0;
}
}
} 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), cel VARCHAR(20), lokomotiva VARCHAR(100))");
mysql_query("INSERT INTO ".$this_table."(stan, dstan, cislo, odjezd, prijezd, z_kol, na_kol, po_kol, datum, smer, cel, lokomotiva ) values ('" . $jmstan . "','" . $datstan . "','" . $pab[0] . "','" . $pab[1] . "','" . $pab[2] . "','" . $pab[3] . "','" . $pab[4] . "','" . $pab[5] . "','" . $pab[6] . "','" . $pab[7] . "','" . $pocix . "','" . $poclok . "')");
$jmstanv=mysql_insert_id();
$poc=mysql_affected_rows();
mysql_query("CREATE TABLE ".$this_tablev."(id INT AUTO_INCREMENT PRIMARY KEY, v_id VARCHAR(20), pocet VARCHAR(20), stav VARCHAR(20), rada VARCHAR(20), rezim VARCHAR(20), firma VARCHAR(20), material VARCHAR(20))");
for ($iiv = 0; $iiv < $countv; $iiv++) {
$kolv++;
if($kolv>4){
$bbix=$pabv[$iiv-3];
$bix="";
$pocbix=strrpos($pabv[$iiv-3], "!");
if($pocbix===false)
{
}else
{
$bbix=SubStr ($pabv[$iiv-3], $pocbix+1);
$bix=SubStr ($pabv[$iiv-3],0, $pocbix+1);
}
mysql_query("INSERT INTO ".$this_tablev."(v_id, pocet, stav, rada, rezim, firma, material ) values ('" . $jmstanv . "','" . $pabv[$iiv-4] . "','" . $bix . "','" . $bbix . "','" . $pabv[$iiv-2] . "','" . $pabv[$iiv-1] . "','" . $pabv[$iiv] . "')");
$ppoc+=mysql_affected_rows();
$kolv=0;
}
}
}
mysql_close();
}while(false);
print("odpoved1=".$zk2);
print("&odpoved2=".$poc);
print("&odpoved3=".$ppoc);
print("&odpoved4=".$strTA4);
print("&odpoved5=".$dta);
?>