. */ function membersList($bodyCode, $appendToUrl) { global $setup, $Body; if( !defined("MAXLISTLENGTH") ) { define("MAXLISTLENGTH", $setup['MaxList']); } require_once("./include/List/ListPager.php"); echoln("

List of members for ".$Body[ $bodyCode ]."

"); $query = "SELECT `GivenName`, `Surname`, `CSN`, `DateBirth`, `MemberSince`, `Fee` FROM `memberlist` WHERE `BodyCode`='".$bodyCode."'"; if( ($res=doquery($query)) && mysql_num_rows($res)>0 ) { $data = array(); while( $row=mysql_fetch_array($res) ) { $data[] = $row; } $list = new ListPager("members", $appendToUrl); $list->setDefaultSort("GivenName"); $list->setSortTranslator(array('GivenName'=>"GivenName,Surname", 'Surname'=>"Surname,GivenName")); $list->addColumn(new CounterColumn("Counter", "#")); $list->addColumn(new TextColumn("GivenName", "Given name")); $list->addColumn(new TextColumn("Surname", "Surname")); #$list->addColumn(new TextColumn("CSN", "CSN")); #$list->addColumn(new DateColumn("DateBirth", "Date of birth")); #$list->addColumn(new DateColumn("MemberSince", "Member since")); $list->addColumn(new MoneyColumn("Fee", "Membership fee")); echoln($list->display($data)); }else { echoln("No members found."); } } ?>