common/commit-kpis-2.php

<?php
require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection_portal_rw.class.php");
$dbc_p = new DBConnectionPortalRW();
$dbh_p = $dbc_p->connect();
function portal_sql( $sql ) {
	global $dbh_p;
	return mysql_query( $sql, $dbh_p );
}

header("Content-type: text/plain");
?>Version 8
<?php
$sql = "SELECT param1, param2, MONTH(NOW()) - MONTH(sent) AS mon FROM immediate_emails
	WHERE class = 'meta_data_warning'";
$result = portal_sql( $sql );
$data = array();
while( $row = mysql_fetch_assoc($result) ) {

	$param1 = $row['param1'];
	$param2 = $row['param2'];
	$x = explode( '@', $param1 );
	$project = $x[0];
	$homepage = 0;
	if( preg_match( '/Project home page/', $param2 ) ) {
		$homepage = 1;
	}
	if( $homepage ) 
		$data[$project][$row['mon']] = 1;
}
ksort( $data );
foreach( $data as $key => $rec ) {
	if( isset($rec[0])
	 && count($rec) > 1 ) {
	 	echo "$key\n";
	 }
}
?>