function appendNewsNodeItems($newsNode, $newsitem)
{
global $doc, $root;
appendAttribute($doc, $newsNode, 'url', $newsitem['url']);
appendAttribute($doc, $newsNode, 'id', $newsitem['id']);
$sectionNode = appendElement($doc, $newsNode, 'section');
appendTextNode($doc, $sectionNode, $newsitem['section']);
$headlineNode = appendElement($doc, $newsNode, 'headline');
appendTextNode($doc, $headlineNode, urldecode($newsitem['headline']));
$summaryNode = appendElement($doc, $newsNode, 'summary');
appendTextNode($doc, $summaryNode, urldecode($newsitem['summary']));
$byNode = appendElement($doc, $newsNode, 'byline');
appendTextNode($doc, $byNode, $newsitem['byline']);
$updatedNode = appendElement($doc, $newsNode, 'updatedTime');
appendTextNode($doc, $updatedNode, $newsitem['updatedTime']);
$createdNode = appendElement($doc, $newsNode, 'createdTime');
appendTextNode($doc, $createdNode, $newsitem['createdTime']);
$pubNode = appendElement($doc, $newsNode, 'pubDate');
appendTextNode($doc, $pubNode, $newsitem['pubDate']);
}
while ($dbRow = $dbResult->fetch(PDO::FETCH_ASSOC)) {
if ($firstRow) {
$firstRow = false;
} else {
$maxIdList .= ", ";
}
$maxIdList .= $dbRow["max"];
}
$sql = "SELECT * FROM cl_callers " . "WHERE id IN (" . $maxIdList . ")" . "AND line <= {$numLines} " . "ORDER BY line";
} else {
if ($allCallers) {
$sql = "SELECT * FROM cl_callers " . "WHERE line <= {$numLines} " . "ORDER BY id DESC " . "LIMIT 100";
} else {
$sql = "SELECT * FROM cl_callers " . "WHERE online = 1 " . " AND line <= {$numLines} " . "ORDER BY priority, id";
}
}
clLog($sql);
$dbResult = $dbConn->query($sql);
while ($dbRow = $dbResult->fetch(PDO::FETCH_ASSOC)) {
$callerEl = $respXML->createElement("caller");
$callersEl->appendChild($callerEl);
appendTextNode($respXML, $callerEl, "id", $dbRow["id"]);
appendTextNode($respXML, $callerEl, "line", $dbRow["line"]);
appendTextNode($respXML, $callerEl, "time", $dbRow["time"]);
appendTextNode($respXML, $callerEl, "priority", $dbRow["priority"]);
appendTextNode($respXML, $callerEl, "online", $dbRow["online"]);
appendTextNode($respXML, $callerEl, "name", $dbRow["name"]);
appendTextNode($respXML, $callerEl, "topic", $dbRow["topic"]);
}
$dbResult->closeCursor();
echo $respXML->saveXML();
