Расписание движения для поезда N ".mysql_result($Tres,0,rootnumber)."
\"".mysql_result($Tres,0,startpoint).
"\" - \"".mysql_result($Tres,0,stoppoint)."\"
(".mysql_result($Tres,0,traintype).")";
$tr_time=triptime(mysql_result($Tres,0,"startpoint"),
mysql_result($Tres,0,"stoppoint"),
mysql_result($Tres,0,"rootnumber"),"ru");
If($tr_time != "")
{ echo "Время в пути: ".str_replace(":"," час ",$tr_time)." мин.
"; }
else {echo "
"; }
$nom=urlencode($r_number);
$pzd=mysql_result($Tres,0,rootnumber);
$start1=mysql_result($Tres,0,startpoint);
$stop1=mysql_result($Tres,0,stoppoint);
$str_de=urlencode($start1);
$stp_de=urlencode($stop1);
echo "
";
// For SMS-sending
$v_puti=$tr_time;
// end of SMS sending
$query_pr="select startpoint, stoppoint from roots_r where rootnumber='$r_number'";
$res_pr=mysql($db, $query_pr);
$from_city=mysql_result($res_pr,0,"startpoint");
$to_city=mysql_result($res_pr,0,"stoppoint");
echo "
";
// ------ start of weather inserting ------------
$query_pr2="select * from weather where st_name='$from_city'";
$res_pr2=mysql($db, $query_pr2);
$num_pr2=mysql_numrows($res_pr2);
if($num_pr2>0)
{
echo "| ";
$weather_id=mysql_result($res_pr2,0,"weather_id");
echo "";
echo " | ";
}
echo " | ";
/* Get prices to stations */
$st_query="select startpoint, stoppoint from roots_r where rootnumber='$r_number'";
$st_res=mysql($db, $st_query);
$st_name1=mysql_result($st_res,0,"startpoint");
$st_name2=mysql_result($st_res,0,"stoppoint");
$pr_query1="Select * from price_tern where city='$st_name1'";
$pr_query2="Select * from price_tern where city='$st_name2'";
$pr_res1=mysql($db, $pr_query1);
$pr_res2=mysql($db, $pr_query2);
$pr_numr1=mysql_numrows($pr_res1);
$pr_numr2=mysql_numrows($pr_res2);
If($pr_numr1>0)
{$par_ur=urlencode("Все станции");
echo "
Стоимость проезда от Тернополя
до станции ".$st_name1.
"
";
If(mysql_result($pr_res1,0,"plackart")<>"" and mysql_result($pr_res1,0,"plackart")<>"0.00")
{echo "Плацкарт: ".mysql_result($pr_res1,0,"plackart")." грн.
";
}
If(mysql_result($pr_res1,0,"kupe")<>"" and mysql_result($pr_res1,0,"kupe")<>"0.00")
{echo "Купе: ".
mysql_result($pr_res1,0,"kupe" )." грн.";
}
If(mysql_result($pr_res1,0,"sv")<>"" and mysql_result($pr_res1,0,"sv")<>"0.00")
{echo "СВ: ".
mysql_result($pr_res1,0,"sv")." грн.";
}
echo " | ";
}
echo " | ";
If($pr_numr2>0)
{$par_ur=urlencode("Усі станції");
echo "
Стоимость проезда от Тернополя
до станции ".$st_name2."
";
If(mysql_result($pr_res2,0,"plackart")<>"" and mysql_result($pr_res2,0,"plackart")<>"0.00")
{echo "Плацкарт: ".
mysql_result($pr_res2,0,"plackart")." грн.
";
}
If(mysql_result($pr_res2,0,"kupe")<>"" and mysql_result($pr_res2,0,"kupe")<>"0.00")
{echo "Купе: ".
mysql_result($pr_res2,0,"kupe")." грн.";
}
If(mysql_result($pr_res2,0,"sv")<>"" and mysql_result($pr_res2,0,"sv")<>"0.00")
{echo "СВ: ".
mysql_result($pr_res2,0,"sv")." грн.";
}
echo " | ";
}
echo " | ";
$query_pr3="select * from weather where st_name='$to_city'";
$res_pr3=mysql($db, $query_pr3);
$num_pr3=mysql_numrows($res_pr3);
if($num_pr3>0)
{
echo "";
$weather_id=mysql_result($res_pr3,0,"weather_id");
echo "";
echo " | ";
}
// ------ end of of weather inserting ------------
echo "
";
switch ($sort_by) {
case "stationorder": $sort_str="порядку следования"; break;
case "stationname": $sort_str="алфавитному порядку"; break;
default: $sort_str="порядку следования"; $sort_by="stationorder";
}
$query="select trainnumber, stationname, intime,
outtime, stoptime, workday, stationorder
from stationsr
where trainnumber='$r_number'
order by $sort_by";
$res=mysql($db, $query);
$numr=mysql_numrows($res);
echo "
Найдено станций: ".$numr."
Сортировка по: ".$sort_str."
Переслать данные на мобилку (SMS) - бесплатно! См. ниже.";
// For SMS-sending
$stanciy=$numr;
// end of SMS sending
echo "
| Название станции |
Время прибытия |
Стоянка |
Время отправления |
";
$poezda="*".mysql_result($res,$i,"stationname").":otpavlenie-".mysql_result($res,$i,"outtime");
$mystart=$poezda; // Select start station
for($i=0; $i" : "";
$station=mysql_result($res,$i,"stationname");
$station_ur=urlencode($station);
echo "| "."$station"." | ";
echo "".mysql_result($res,$i,"intime")." | ";
echo "".mysql_result($res,$i,"stoptime")." | ";
echo "".mysql_result($res,$i,"outtime")." | ";
// For SMS-sending for first and last station not include here - see up and down of cicle
if (($i>0) and ($i<(mysql_numrows($res)-1)))
{$poezda=$poezda."*".$station.":"."-".mysql_result($res,$i,"intime").",".mysql_result($res,$i,"stoptime")."min.";}
// end of SMS sending
$konec=mysql_result($res,$i,"intime");
echo " ";
}
echo " ";
echo " |
";
$poezda=$poezda."*".$station.":"."pribitie:".$konec;
$mystop="*".$station.":"."pribitie-".$konec; // Last station - arrival station
mysql_close();
echo "
|
|
| ";
//------ SMS Start ------->
echo "
Рады Вам помочь !
|