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

List of members for ".$Body[ $bodyCode ].($previous?" (".$setup['PreviousMemberlist'].")":"")."

"); $query = "SELECT `GivenName`, `Surname`, `CSN`, `DateBirth`, `MemberSince`, `Fee` AS `FeeLocal`, `Fee`*`currencies`.`rate` AS `FeeEuro`, `currencies`.`short` AS `currency`, `currencies`.`rate` AS `rate` "; $query.= "FROM ".$dbPrefix."`memberlist` AS `memberlist` "; $query.= "INNER JOIN ".$dbPrefix."`ab_bodies` AS `ab_bodies` ON `ab_bodies`.`BodyCode` = `memberlist`.`BodyCode` "; $query.= "INNER JOIN ".$dbPrefix."`currencies` AS `currencies` ON `currencies`.`id` = `ab_bodies`.`MemberFeeCurrencyId` "; $query.= "WHERE `memberlist`.`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("FeeLocal", "Membership fee", $data[0]['currency'])); if( $data[0]['rate']!=1 ) { $list->addColumn(new MoneyColumn("FeeEuro", "Membership fee (converted)", "€")); } echoln($list->display($data)); }else { echoln("No members found."); } } ?>