$xml .= '<site>';
$xml .= add_XML_value('id', $site_array['id']);
$xml .= add_XML_value('name', $site_array['name']);
$xml .= add_XML_value('description', stripslashes($siteinformation_array['description']));
$xml .= add_XML_value('processoris64bits', $siteinformation_array['processoris64bits']);
$xml .= add_XML_value('processorvendor', $siteinformation_array['processorvendor']);
$xml .= add_XML_value('processorvendorid', $siteinformation_array['processorvendorid']);
$xml .= add_XML_value('processorfamilyid', $siteinformation_array['processorfamilyid']);
$xml .= add_XML_value('processormodelid', $siteinformation_array['processormodelid']);
$xml .= add_XML_value('processorcachesize', $siteinformation_array['processorcachesize']);
$xml .= add_XML_value('numberlogicalcpus', $siteinformation_array['numberlogicalcpus']);
$xml .= add_XML_value('numberphysicalcpus', $siteinformation_array['numberphysicalcpus']);
$xml .= add_XML_value('totalvirtualmemory', getByteValueWithExtension($siteinformation_array['totalvirtualmemory'] * 1048576) . 'iB');
$xml .= add_XML_value('totalphysicalmemory', getByteValueWithExtension($siteinformation_array['totalphysicalmemory'] * 1048576) . 'iB');
$xml .= add_XML_value('logicalprocessorsperphysical', $siteinformation_array['logicalprocessorsperphysical']);
$xml .= add_XML_value('processorclockfrequency', getByteValueWithExtension($siteinformation_array['processorclockfrequency'] * 1000000, 1000) . 'Hz');
$xml .= add_XML_value('outoforder', $site_array['outoforder']);
if ($projectid && $project_array['showipaddresses']) {
$xml .= add_XML_value('ip', $site_array['ip']);
$xml .= add_XML_value('latitude', $site_array['latitude']);
$xml .= add_XML_value('longitude', $site_array['longitude']);
}
$xml .= '</site>';
// List the claimers of the site
$siteclaimer = pdo_query('SELECT firstname,lastname,email FROM ' . qid('user') . ',site2user
WHERE ' . qid('user') . ".id=site2user.userid AND site2user.siteid='{$siteid}' ORDER BY firstname");
while ($siteclaimer_array = pdo_fetch_array($siteclaimer)) {
$xml .= '<claimer>';
$xml .= add_XML_value('firstname', $siteclaimer_array['firstname']);
$xml .= add_XML_value('lastname', $siteclaimer_array['lastname']);
if (isset($_SESSION['cdash'])) {
' . qid('user') . '.firstname,' . qid('user') . '.lastname,' . qid('user') . '.id AS userid
FROM build AS b, siteinformation AS si, site as s
LEFT JOIN site2user ON (site2user.siteid=s.id)
LEFT JOIN ' . qid('user') . ' ON (site2user.userid=' . qid('user') . ".id)\n WHERE s.id=b.siteid\n AND b.starttime<'{$end_UTCDate}' AND b.starttime>'{$beginning_UTCDate}'\n AND si.siteid=s.id\n AND b.projectid='{$projectid}' GROUP BY s.id,s.name,si.processorclockfrequency,\n si.description,\n si.numberphysicalcpus,s.ip,s.latitude,s.longitude," . qid('user') . '.firstname,' . qid('user') . '.lastname,' . qid('user') . '.id');
} else {
$site = pdo_query('SELECT s.id,s.name,si.processorclockfrequency,
si.description,
si.numberphysicalcpus,s.ip,s.latitude,s.longitude,
' . qid('user') . '.firstname,' . qid('user') . '.lastname,' . qid('user') . '.id AS userid
FROM build AS b, siteinformation AS si, site as s
LEFT JOIN site2user ON (site2user.siteid=s.id)
LEFT JOIN ' . qid('user') . ' ON (site2user.userid=' . qid('user') . ".id)\n WHERE s.id=b.siteid\n AND b.starttime<'{$end_UTCDate}' AND b.starttime>'{$beginning_UTCDate}'\n AND si.siteid=s.id\n AND b.projectid='{$projectid}' GROUP BY s.id");
}
echo pdo_error();
while ($site_array = pdo_fetch_array($site)) {
$xml .= '<site>';
$xml .= add_XML_value('name', $site_array['name']);
$xml .= add_XML_value('id', $site_array['id']);
$xml .= add_XML_value('description', $site_array['description']);
$xml .= add_XML_value('processor_speed', getByteValueWithExtension($site_array['processorclockfrequency'] * 1024 * 1024));
$xml .= add_XML_value('numberphysicalcpus', $site_array['numberphysicalcpus']);
$xml .= add_XML_value('latitude', $site_array['latitude']);
$xml .= add_XML_value('longitude', $site_array['longitude']);
$xml .= add_XML_value('longitude', $site_array['longitude']);
$xml .= add_XML_value('maintainer_name', $site_array['firstname'] . ' ' . $site_array['lastname']);
$xml .= add_XML_value('maintainer_id', $site_array['userid']);
$xml .= '</site>';
}
$xml .= '</cdash>';
// Now doing the xslt transition
generate_XSLT($xml, 'viewMap');
$xml .= "<site>";
$xml .= add_XML_value("id", $site_array["id"]);
$xml .= add_XML_value("name", $site_array["name"]);
$xml .= add_XML_value("description", stripslashes($siteinformation_array["description"]));
$xml .= add_XML_value("processoris64bits", $siteinformation_array["processoris64bits"]);
$xml .= add_XML_value("processorvendor", $siteinformation_array["processorvendor"]);
$xml .= add_XML_value("processorvendorid", $siteinformation_array["processorvendorid"]);
$xml .= add_XML_value("processorfamilyid", $siteinformation_array["processorfamilyid"]);
$xml .= add_XML_value("processormodelid", $siteinformation_array["processormodelid"]);
$xml .= add_XML_value("processorcachesize", $siteinformation_array["processorcachesize"]);
$xml .= add_XML_value("numberlogicalcpus", $siteinformation_array["numberlogicalcpus"]);
$xml .= add_XML_value("numberphysicalcpus", $siteinformation_array["numberphysicalcpus"]);
$xml .= add_XML_value("totalvirtualmemory", getByteValueWithExtension($siteinformation_array["totalvirtualmemory"] * 1048576) . "iB");
$xml .= add_XML_value("totalphysicalmemory", getByteValueWithExtension($siteinformation_array["totalphysicalmemory"] * 1048576) . "iB");
$xml .= add_XML_value("logicalprocessorsperphysical", $siteinformation_array["logicalprocessorsperphysical"]);
$xml .= add_XML_value("processorclockfrequency", getByteValueWithExtension($siteinformation_array["processorclockfrequency"] * 1000000, 1000) . "Hz");
$xml .= add_XML_value("outoforder", $site_array["outoforder"]);
if ($projectid && $project_array['showipaddresses']) {
$xml .= add_XML_value("ip", $site_array["ip"]);
$xml .= add_XML_value("latitude", $site_array["latitude"]);
$xml .= add_XML_value("longitude", $site_array["longitude"]);
}
$xml .= "</site>";
// List the claimers of the site
$siteclaimer = pdo_query("SELECT firstname,lastname,email FROM " . qid("user") . ",site2user\n WHERE " . qid("user") . ".id=site2user.userid AND site2user.siteid='{$siteid}' ORDER BY firstname");
while ($siteclaimer_array = pdo_fetch_array($siteclaimer)) {
$xml .= "<claimer>";
$xml .= add_XML_value("firstname", $siteclaimer_array["firstname"]);
$xml .= add_XML_value("lastname", $siteclaimer_array["lastname"]);
if (isset($_SESSION['cdash'])) {
$xml .= add_XML_value("email", $siteclaimer_array["email"]);
