|
Conference session will take place in following places:
- Hall A – conference hall at Rector's Office of Belarusian State Unviversity (Nezavisimosti ave., 4)
- Hall B – great conference hall at Presidium of National Academy of Sciences of Belarus (Nezavisimosti ave., 66)
>","»",$s);
return $s;
}
function t2authors($s)
{
$s=str_replace("(","",$s);
$s=str_replace(")","",$s);
for ($i=0;$i<9;$i++) {
$s=str_replace($i,"",$s);
}
$s=str_replace(",",", ",$s);
$s=str_replace(".",". ",$s);
$s=str_replace(". ",". ",$s);
$s=str_replace(", ",", ",$s);
$s=str_replace(" ,",",",$s);
$s=str_replace(" ,",",",$s);
$s=str_replace(" ,",",",$s);
$s=str_replace(" ,",",",$s);
$s=str_replace(" .",".",$s);
$s=str_replace(" .",".",$s);
$s=str_replace(" .",".",$s);
$s=str_replace(",,",",",$s);
$s=str_replace(",,",",",$s);
return $s;
}
function t2speaker($a,$s)
{
$s=str_replace(" ","",$s);
//echo $a;
if (strlen($a)) {
$p=strpos($a,$s);
if (!($p===false))
{
//echo $p;
$c=-1;
$la=strlen($a);
do {
$i=$c+1;
$c=strpos($a,',',$c+1);
} while (!($c===false) and $c<$p);
//echo $i;
$c=strpos($a,',',$i+1);
$f=($c?$c-1:$la);
$fio=substr($a,$i,$f-$i+1);
$a=str_replace($fio,"".$fio."",$a);
}
}
return $a;
}
$d_host="localhost";
$d_login="root";
$d_db="congress2011";
$d_password="miscellaneous";
mysql_connect($d_host, $d_login, $d_password) or die("Ошибка соединения с базой данных.");
mysql_select_db($d_db) or die("Ошибка таблицы в базе данных.");
$result = @mysql_query("SET NAMES cp1251;");
$result=@mysql_query("SELECT * FROM sessions where id>=20 order by date, time, hall;");
$rows=@mysql_num_rows($result);
$cday=0;
for ($id=0;$id<$rows;$id++)
{
$sess_num=mysql_result($result,$id,0);
$title= mysql_result($result,$id,1);
$title_en= mysql_result($result,$id,2);
$hall= mysql_result($result,$id,3);
$date= mysql_result($result,$id,4);
$time=mysql_result($result,$id,5);
$event_en=mysql_result($result,$id,6);
$event_time=mysql_result($result,$id,7);
$event=mysql_result($result,$id,8);
$letter=mysql_result($result,$id,9);
$pres=mysql_result($result,$id,10);
$pres_en=mysql_result($result,$id,11);
$tlen=strlen($time);
$h=substr($time,3,2);
$m=substr($time,6,2);
switch ($date)
{
case 25:
$week="Sunday";
$day="September 25";
$dd="Su";
break;
case 26:
$week="Monday";
$day="September 26";
$dd="Mo";
break;
case 27:
$week="Tuesday";
$day="September 27";
$dd="Tu";
break;
}
$sa=$dd.$date.$letter."(".$hall.")";
if ($cday<$date)
{
$cday=$date;
echo "".upper($week.", ".$day)." ";
if ($date==26) echo "10:00 – 13:00 PLENARY TALKS OF III CONGRESS OF PHYSICISTS OF BELARUS (talks will be given in Russian) ";
}
echo "$sa $title (hall $hall)";
$pl="ь";
if (strpos($pres,",")) $pl="и";
if ($sess_num<>16) echo "
Presider: ".$pres_en."";
if ($sess_num==16) echo " 14:00 — 16:00
Размер места для постера составляет 100 см (высота)на 75 см (ширина).";
echo " ";
if ($sess_num==16) echo "
";
$result1=@mysql_query("SELECT email, authors, title, place, time, duration, sname, org
FROM congress where session=$sess_num order by time;");
$rows1=@mysql_num_rows($result1);
for ($id1=0;$id1<$rows1;$id1++)
{
$email=mysql_result($result1,$id1,0);
$authors=t2authors(mysql_result($result1,$id1,1));
$title_rep=mysql_result($result1,$id1,2);
$place=mysql_result($result1,$id1,3);
$time_rep=mysql_result($result1,$id1,4);
$duration=mysql_result($result1,$id1,5);
$sname=mysql_result($result1,$id1,6);
$org=mysql_result($result1,$id1,7);
$authors=t2speaker($authors,$sname);
$tlen_rep=strlen($time);
$h_rep=substr($time_rep,0,2);
$m_rep=substr($time_rep,3,2);
if ($sess_num<>16) echo "$h_rep:$m_rep ";
echo "$sa".($id1+1)."
$authors ($org)
".t2site($title_rep)."";
if ($sess_num<>16) echo " ($duration minutes)";
echo "
";
}
if ($date==26) echo "16:30 – 18:20 FEDOROV MEMORIAL SYMPOSIUM
(talks will be given in Russian) ";echo "
";
if (strlen($event))
{
echo "".t2site($event_time." ".$event_en)."
";
}
}
?>
|
