| Version 3 |
| <ul> |
| <?php |
| require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_foundation_ro.class.php"; |
| |
| $_dbcf = new DBConnectionFoundation(); |
| $_dbhf = $_dbcf->connect(); |
| |
| $peeps = array(); |
| $activ = array(); |
| $anyact = array(); |
| |
| $sql = " |
| select distinct People.PersonID, ProjectID |
| from People, PeopleProjects |
| where People.PersonID = PeopleProjects.PersonID |
| and People.IsMember |
| and PeopleProjects.Relation = 'CM' |
| and PeopleProjects.InactiveDate is null |
| and People.PersonID NOT IN ( |
| SELECT PersonID |
| FROM OrganizationContacts |
| WHERE Relation = 'EMPLY') |
| AND Email NOT LIKE '%ibm%' ORDER BY ProjectID |
| "; |
| $result = mysql_query( $sql, $_dbhf ); |
| while( $row = mysql_fetch_array($result) ) { |
| $peeps[$row[0] . ' x ' . $row[1]] = $row[0]; |
| } |
| /* |
| * Get all the committer activity |
| */ |
| $blob = file("http://dash.eclipse.org/dash/commits/web-api/commits-index.php"); |
| foreach( $blob as $line ) { |
| $words = split( "\t", $line ); |
| if( substr($words[0],0,1) == '#' ) { |
| continue; |
| } |
| if( $words[2] == 9 && $words[1] > 0 ) { |
| $activ[$words[0] . ' x ' . $words[3]] = 1; |
| $anyact[$words[0]] = 1; |
| } |
| } |
| /* |
| * Figure out which non-corporate committers are inactive |
| */ |
| foreach( $peeps as $key => $value ) { |
| if( !isset($activ[$key]) ) { |
| if( !isset($anyact[$value]) ) |
| echo "<li>$key</li>"; |
| } |
| } |
| ?> |
| </ul> |