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');
?>