$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"]);