. */ include("./include/include.php"); admin_header(true); if( !in_array("agoralist_view", $_SESSION['sess_functions']) ) { echoln("You are not authorized to see this page."); }else { $participants = array(); $query = "SELECT `BodyCode`, COUNT(`id`) AS `people` FROM `applications` WHERE `Accepted`='yes' OR `Accepted`='pending' OR `Accepted`='confirmed' OR `Accepted`='arrived' GROUP BY `BodyCode`"; if( @mysql_num_rows( $res=doquery($query) )>0 ) { while( $row=mysql_fetch_array($res) ) { $participants[ $row['BodyCode'] ] = $row['people']; } } switch( $_REQUEST['show'] ) { case "jcregistration": echoln("

Juridical Commission registration list

"); $query = "SELECT `BodyCode`, `BodyName`, `BodyStatus`, `MemberClaimed` FROM `ab_bodies` WHERE `BodyStatus`='C' OR `BodyStatus`='CA' OR `BodyStatus`='A' ORDER BY `BodyCategoryOrder`, `BodyName`"; /* SELECT `BodyCode`, `BodyName`, `BodyStatus`, `MemberClaimed`, ( SELECT GROUP_CONCAT(CONCAT(`FirstName`, ' ',`LastName`) ORDER BY `FirstName`, `LastName` SEPARATOR '
') FROM `applications` WHERE `applications`.`BodyCode`=`ab_bodies`.`BodyCode` AND (`Accepted`='yes' OR `Accepted`='pending' OR `Accepted`='confirmed' OR `Accepted`='arrived') AND `ParticipantType`='delegate' ) AS `delegates` FROM `ab_bodies` WHERE `BodyStatus`='C' OR `BodyStatus`='CA' OR `BodyStatus`='A' HAVING `delegates` IS NOT NULL ORDER BY `BodyCategoryOrder`, `BodyName` */ break; case "prytanium": echoln("

Prytanium list

"); $query = "SELECT `BodyCode`, `BodyName` FROM `ab_bodies` WHERE `BodyStatus`='A' ORDER BY `BodyCategoryOrder`, `BodyName`"; break; case "attendance": default: echoln("

Attendance list

"); $query = "SELECT `BodyCode`, `BodyName`, `BodyStatus` FROM `ab_bodies` WHERE `BodyStatus`='C' OR `BodyStatus`='CA' OR `BodyStatus`='A' ORDER BY `BodyCategoryOrder`, `BodyName`"; break; } if( @mysql_num_rows( $res=doquery($query) )>0 ) { echoln(""); echoln(" "); echoln(" "); echoln(" "); if( $_REQUEST['show']=="jcregistration" ) { echoln(" "); echoln(" "); echoln(" "); echoln(" "); }else { echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln(" "); while( $row=mysql_fetch_array($res) ) { echoln(" "); if( $_REQUEST['show']=="jcregistration" ) { if( isset($participants[ $row['BodyCode'] ]) && $participants[ $row['BodyCode'] ]>0 ) echoln(" "); else echoln(" "); echoln(" "); if( $row['MemberClaimed']>0 ) { echoln(" "); }else { echoln(" "); } echoln(" "); if( isset($participants[ $row['BodyCode'] ]) && $participants[ $row['BodyCode'] ]>0 ) echoln(" "); else echoln(" "); echoln(" "); }else { if( isset($participants[ $row['BodyCode'] ]) && $participants[ $row['BodyCode'] ]>0 ) echoln(" "); else echoln(" "); if( $_REQUEST['show']=="prytanium" ) echoln(" "); else echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln(" "); } if( $_REQUEST['show']!="jcregistration" ) { for( $i=1; $i<=10; $i++ ) { echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); } } echoln("

Code	Body name	Members	Votes	Delegate name	Signature
".$row['BodyCode']."	".$row['BodyCode']."	".$row['BodyName']." (".$row['BodyStatus'].")	".$row['MemberClaimed']."				x		".$row['BodyCode']."	".$row['BodyCode']."	".$row['BodyName']."	".$row['BodyName']." (".$row['BodyStatus'].")

"); }else { echoln("No bodies found. Address Book data missing?"); } } admin_footer(true); ?>