{

include("cdash/config.php");

require_once("cdash/pdo.php");

$dates = array();

$db = pdo_connect("$CDASH_DB_HOST", "$CDASH_DB_LOGIN", "$CDASH_DB_PASS");

pdo_select_db("$CDASH_DB_NAME", $db);

$dbQuery = pdo_query("SELECT nightlytime FROM project WHERE name='$projectname'");

if(pdo_num_rows($dbQuery)>0)

{

$project = pdo_fetch_array($dbQuery);

$nightlytime = $project['nightlytime'];

//echo "query result nightlytime: " . $nightlytime . "<br/>";

}

else

{

$nightlytime = "00:00:00";

//echo "default nightlytime: " . $nightlytime . "<br/>";

}

if(!isset($basedate) || strlen($basedate)==0)

{

$basedate = gmdate(FMT_DATE);

}

// Convert the nightly time into GMT

$nightlytime = gmdate(FMT_TIME,strtotime($nightlytime));

$nightlyhour = time2hour($nightlytime);

$nightlyminute = time2minute($nightlytime);

$nightlysecond = time2second($nightlytime);

$basemonth = date2month($basedate);

$baseday = date2day($basedate);

$baseyear = date2year($basedate);

$dates['nightly+2'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond,

$basemonth, $baseday+2, $baseyear);

$dates['nightly+1'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond,

$basemonth, $baseday+1, $baseyear);

$dates['nightly-0'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond,

$basemonth, $baseday, $baseyear);

$dates['nightly-1'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond,

$basemonth, $baseday-1, $baseyear);

$dates['nightly-2'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond,

$basemonth, $baseday-2, $baseyear);

// Snapshot of "now"

//

$currentgmtime = time();

$currentgmdate = gmdate(FMT_DATE, $currentgmtime);

// Find the most recently past nightly time:

//

$todaymonth = date2month($currentgmdate);

$todayday = date2day($currentgmdate);

$todayyear = date2year($currentgmdate);

$currentnightly = gmmktime($nightlyhour, $nightlyminute, $nightlysecond,

$todaymonth, $todayday, $todayyear);

while ($currentnightly>$currentgmtime)

{

$todayday = $todayday - 1;

$currentnightly = gmmktime($nightlyhour, $nightlyminute, $nightlysecond,

$todaymonth, $todayday, $todayyear);

}

$dates['now'] = $currentgmtime;

$dates['most-recent-nightly'] = $currentnightly;

$dates['today_utc'] = $currentgmdate;

$dates['basedate'] = gmdate(FMT_DATE, $dates['nightly-0']);

// CDash equivalent of DART1's "last rollup time"

if ($dates['basedate'] === $dates['today_utc'])

{

// If it's today, it's now:

$dates['last-rollup-time'] = $dates['now'];

}

else

{

// If it's not today, it's the nightly time on the basedate:

$dates['last-rollup-time'] = $dates['nightly-0'];

}

return $dates;

{

// Sort directory names lexicographically in ascending order:

// (A, B, C, ... Z)

//

$d1 = $e1['directory'];

$d2 = $e2['directory'];

if ($d1<$d2)

{

return -1;

}

if ($d1>$d2)

{

return 1;

}

// Sort file names lexicographically in ascending order

// (A, B, C, ... Z)

//

$f1 = $e1['filename'];

$f2 = $e2['filename'];

if ($f1<$f2)

{

return -1;

}

if ($f1>$f2)

{

return 1;

}

// Sort time stamps numerically in descending order

// (newer changes before older changes)

//

$t1 = $e1['time'];

$t2 = $e2['time'];

if ($t1<$t2)

{

return 1;

}

if ($t1>$t2)

{

return -1;

}

// Identical entries:

//

return 0;

{

$xml = "<updates>\n";

$xml .= "<timestamp>".date(FMT_DATETIMETZ, $dates['nightly-0'])."</timestamp>";

// Get revision numbers for the current day and "the last time it ran before that..."

// Only works if the LIMIT 2 query below returns exactly 2 records and the date from

// the most recent record matches the current 'nightly-0' date... If those criteria

// are not met, the revision strings will be empty and no revision information will

// be displayed on the resulting web page.

//

$revision_current = '';

$revision_prior = '';

$qry = "SELECT date, revision FROM dailyupdate ".

"WHERE projectid='$projectid' ".

" AND date <= '".gmdate(FMT_DATE, $dates['nightly-0'])."' ".

"ORDER BY date DESC LIMIT 2";

$rows = pdo_all_rows_query($qry);

if (count($rows) == 2)

{

if ($rows[0]['date'] == gmdate(FMT_DATE, $dates['nightly-0']))

{

$revision_current = $rows[0]['revision'];

$revision_prior = $rows[1]['revision'];

}

}

$xml .= add_XML_value("revision", $revision_current);

$xml .= add_XML_value("priorrevision", $revision_prior);

$xml .= add_XML_value("revisionurl", get_revision_url($projectid, $revision_current, $revision_prior));

$xml .= add_XML_value("revisiondiff", get_revision_url($projectid, $revision_prior, '')); // no prior prior revision...

$xml .= "<javascript>\n";

// Args to dbAdd : "true" means directory, "false" means file

//

$xml .= "dbAdd(true, \"Updated files (".count($commits).")\", \"\", 0, \"\", \"1\", \"\", \"\", \"\", \"\", \"\")\n";

$previousdir = "";

usort($commits, "sort_by_directory_file_time");

$projecturl = get_project_property($projectname, "cvsurl");

foreach($commits as $commit)

{

$directory = $commit['directory'];

if($directory != $previousdir)

{

$xml .= "dbAdd(true, \"".$directory."\", \"\", 1, \"\", \"1\", \"\", \"\", \"\", \"\", \"\")\n";

$previousdir = $directory;

}

$filename = $commit['filename'];

$revision = '';

if($commit['priorrevision'] != "-1")

{

$revision = $commit['revision'];

}

$time = gmdate(FMT_DATETIME, strtotime($commit['time']));

$author = $commit['author'];

// Only display email if the user is logged in

if(isset($_SESSION['cdash']))

{

if(isset($commit['email']))

{

$email = $commit['email'];

}

else

{

$email = get_author_email($projectname, $author);

}

}

else

{

// If the author is an email (git for instance) we remove everything after the @

$posat = strpos($author,'@');

if($posat !== false)

{

$author = substr($author,0,$posat);

}

$email = "";

}

$comment = $commit['comment'];

$comment = str_replace("\n", " ", $comment);

// Do this twice so that <something> ends up as

// &amp;lt;something&amp;gt; because it gets sent to a

// java script function not just displayed as html

$comment = XMLStrFormat($comment);

$comment = XMLStrFormat($comment);

$diff_url = get_diff_url(get_project_id($projectname),$projecturl, $directory, $filename, $revision);

$diff_url = XMLStrFormat($diff_url);

$xml .= "dbAdd(false, \"".$filename." Revision: ".$revision."\",\"".$diff_url."\",2,\"\",\"1\",\"".$author."\",\"".$email."\",\"".$comment."\",\"".$commit['bugurl']."\",\"".$commit['bugid']."\",\"".$commit['bugpos']."\")\n";

}

$xml .= "</javascript>\n";

$xml .= "</updates>";

return $xml;