$maybecomma = ",";
}
+ $sth3 = $dbh->prepare("SELECT UNIQUE s.string FROM strings s, " .
+ "imembers i, list l WHERE l.name = " .
+ $dbh->quote($name) .
+ "AND l.list_id = i.list_id " .
+ "AND i.member_type = 'KERBEROS' " .
+ "AND i.member_id = s.string_id") || exit $MR_DBMS_ERR;
+ $sth3->execute || exit $MR_DBMS_ERR;
+
+ while (($member) = $sth3->fetchrow_array) {
+ # If principal is @ATHENA.MIT.EDU, strip realm, otherwise skip.
+ if ($member =~ /\@ATHENA.MIT.EDU/) {
+ $member =~ s/\@ATHENA.MIT.EDU//;
+ } else {
+ next;
+ }
+ $row = "$maybecomma$member";
+ $row =~ s/\0//g;
+ print OUT $row;
+ $maybecomma = ",";
+ }
+
$row = "\n";
$row =~ s/\0//g;
print OUT $row;