/**
* Creates a table with the changelog { WhoChangedIt | logLine }
* @return string XHTML content
*/
function changeLogHtmlTable(&$contact)
{
//global $errorHandler;
global $CONFIG_DB_PREFIX, $CONFIG_REL_XML_OTHER_PROPERTIES, $CONFIG_REL_XML_DATE_PROPERTIES, $CONFIG_RELT_XML_OTHER_PROPERTIES, $CONFIG_RELT_XML_DATE_PROPERTIES;
$db = DB::getSingleton();
// we prepare the content as XHTML
$content = "<table>\n";
// fetch log
$id = $contact->contact['id'];
$db->query("SELECT * FROM `{$CONFIG_DB_PREFIX}ContactChangeLogger` as log WHERE contactId={$id}", 'CCL');
while ($r = $db->next('CCL')) {
$c = new User($r['whoModifiedId']);
$content .= '<tr><td>' . htmlspecialchars($r['changeDescription']) . '</td><td>' . $c->generateFullName() . '</td></tr>';
}
$content .= "</table>\n";
return $content;
}