if (!secure($_GET)) die('Unexpected request.');
include('loads/kurzus/dfuncs.php');
print_head('IX/index.php:Top;IX/1.php:Programme;IX/2.php:Participants;IX/3.php:Practical issues;IX/4.php:Organisers;','Participants');
?>
if (isset($Tuser) and $Tuser!='' and ($Tstate==1 or $Tstate==2)) {
if (isset($timetable)) {
if (isset($psend)) {
$tmp = 'length_'.$psend;
$length = $$tmp;
$tmp = 'starttime_'.$psend;
$starttime = $$tmp;
print "$length, $starttime, $psend";
query("SELECT talk_id FROM kongress_IX_timetable WHERE talk_id=$psend");
if($nur) {
$cmd = "UPDATE kongress_IX_timetable SET length='$length',starttime='$starttime' WHERE talk_id=$psend";
}
else $cmd = "INSERT INTO kongress_IX_timetable (talk_id,length,starttime) VALUES ($psend,'$length','$starttime')";
sqlcmd($cmd);
query("SELECT talk_id FROM kongress_IX_timetable LEFT JOIN kongress_IX ON (talk_id=id)
WHERE UNIX_TIMESTAMP(starttime) BETWEEN UNIX_TIMESTAMP('$starttime') AND
UNIX_TIMESTAMP(DATE_ADD('$starttime', INTERVAL $length+1 MINUTE)) AND
talk_id!=$psend ORDER BY starttime DESC, name ASC");
// print "SELECT talk_id FROM kongress_IX_timetable LEFT JOIN kongress_IX ON (talk_id=id)
// WHERE UNIX_TIMESTAMP(starttime) BETWEEN UNIX_TIMESTAMP('$starttime') AND
// UNIX_TIMESTAMP(DATE_ADD('$starttime', INTERVAL $length MINUTE)) AND
// talk_id!=$psend ORDER BY starttime DESC, name ASC
";
$lh = $length;
while ($r=next_row()){
mysql_query("UPDATE kongress_IX_timetable SET starttime=DATE_ADD('$starttime',INTERVAL $length MINUTE) WHERE talk_id=$r[0]",$ID);
// print "UPDATE kongress_IX_timetable SET starttime=DATE_ADD('$starttime',INTERVAL $length MINUTE) WHERE talk_id=$r[0]
";
$length += $lh;
}
}
print "
";
} else print "
";
query("SELECT id FROM kongress_IX WHERE accept>=1");
$rv = $nur;
printf("
Rsztvevk: %d",$nur);
query("SELECT id FROM kongress_IX WHERE title!='' AND accept>=1");
printf("
Eladk: %d",$nur);
query("SELECT id FROM kongress_IX WHERE vegetarian=1 AND accept>=1");
print "
Vegetrinus men: $nur";
query("SELECT id FROM kongress_IX WHERE backing=1 AND accept>=1");
$bc = $nur;
print "
Tmogats ignyls: $nur";
printf("
Regisztrcis dj: %d
",($rv-$bc)*14500);
query("SELECT name,institute,title,abstract,backing,accessories,authors,email,vegetarian,reddet FROM kongress_IX WHERE accept>=1 AND title!='' ORDER BY name ASC");
while ($r = next_arow()) {
print "
{$r['name']} - {$r['institute']}
";
print $r['authors']. "
";
print "
{$r['title']}
{$r['email']}
";
print $r['abstract']."
";
print "Kellkek: ";
print $r['accessories']. "
";
print "Tmogats: ";
if ($r['backing']==0) print 'nem'.'
';
elseif ($r['backing']==1) print 'igen'.'
';
if ($r['backing']==1) print $r['reddet'].'
';
//else print 'fully';
$r['vegetarian'] == 1 ? print 'Vegetarian meal' : print 'Non-vegetarian meal';
print '
';
}
query("SELECT name,institute,backing,email,vegetarian FROM kongress_IX WHERE accept>=1 AND title='' ORDER BY name ASC");
while ($r = next_row()) {
print "
$r[0] - $r[1]
$r[3]";
print "
";
print "Tmogats: ";
if ($r[2]==0) print 'nem'.'
';
elseif ($r[2]==1) print 'igen'.'
';
//else print 'fully';
$r['vegetarian'] == 1 ? print 'Vegetarian meal' : print 'Non-vegetarian meal';
print '
';
}
}
else {
query("SELECT name,institute FROM kongress_IX WHERE accept>=1 ORDER BY name");
while ($r = next_arow())
print "
{$r['name']} - {$r['institute']}
";
}
?>
print_head('IX/index.php:Top;IX/1.php:Programme;IX/2.php:Participants;IX/3.php:Practical issues;IX/4.php:Organisers;','Participants');
?>