Debreceni Egyetem
in English  |  Magyarul
"; $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 "
"; query("SELECT talk_id AS id,name,SUBSTRING(title,1,30) AS title,DATE_FORMAT(starttime,'%Y-%m-%d %H:%i') AS stime,length FROM kongress_IX RIGHT JOIN kongress_IX_timetable ON (id=talk_id) WHERE (accept>=1 AND title!='') OR talk_id<0 ORDER BY starttime,name"); while ($r = next_arow()){ if ($r['name'] == '' and $r['length']<=60) $name = 'Coffee break'; elseif ($r['name'] == '' and $r['length']>60 and $r['length']<120) $name = 'Lunch break'; elseif ($r['name'] == '' and $r['length']>=120) $name = 'Dinner'; else $name = $r['name']; if ($r['id']==-9) $name = 'Opening by Prof Dr Jzsef Plinks'; if ($r['id']==-10) $name = 'Birds of the "Puszta'; if ($r['id']==-11) $name = 'Welcome Party'; if ($r['id']==-12) $name = 'Welcome notes by Zoltan Barta'; if ($r['id']==-14) $name = 'Reception opens'; print ""; } print "
name title starttime length send
 
$name {$r['title']}...
"; } 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']}

"; } ?>