. */ 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(`PersonID`) AS `people` FROM `persons` 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`, `MemberClaimedBy` FROM `ab_bodies` WHERE `BodyStatus`='C' OR `BodyStatus`='CA' OR `BodyStatus`='A' 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 ) { if( strlen($row['MemberClaimedBy'])>17 ) { echoln(" "); }else { 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']." ".substr($row['MemberClaimedBy'], 0, 15)."...	".$row['MemberClaimed']." ".$row['MemberClaimedBy']."				x		".$row['BodyCode']."	".$row['BodyCode']."	".$row['BodyName']."	".$row['BodyName']." (".$row['BodyStatus'].")

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