';
$prg = pg_query("select
h.name as hallname,
to_char(starts_at, 'DD FMMonth - FMDay') as dt,
to_char(s.starts_at,'HH24:MI') as start, to_char(s.ends_at,'HH24:MI') as end,
e.title, e.language,
e.abstract,
t.name as tname, t.color as tcolor,
sp.first_name || ' ' || sp.last_name as spname
from
slots s join halls h on h.id=s.hall_id
join events e on s.event_id = e.id
join tracks t on t.id=e.track_id
join users u on u.id=e.user_id
join speaker_profiles sp on sp.user_id=u.id
where
not s.event_id is null
order by date(s.starts_at),s.hall_id, s.starts_at
");
$bgpost = array();
$enpost = array();
$bgpost['ID'] = $sched_bg;
$enpost['ID'] = $sched_en;
$bgpost['post_title'] = "Програма";
$enpost['post_title'] = "Schedule";
$bgpost['post_name'] = "schedule";
$enpost['post_name'] = "schedule";
$cdate='';
$chall='';
while ($row = pg_fetch_object($prg)) {
if ($chall!=$row->hallname && strlen($chall)>1) {
$bg.= "\n";
$en.= "\n";
}
if ($cdate!=$row->dt) {
$cdate = $row->dt;
$bg.= "
$cdate
\n";
$en.= "
$cdate
\n";
}
if ($chall!=$row->hallname) {
$chall = $row->hallname;
echo pll_translate_string($chall, 'en_US')."\n";
$en.= "
".pll_translate_string($chall, 'en')." Hall";
$bg.= "\n";
$en.= "