errorPermission(); } // ################################################################### header('Content-type: application/xml'); $syndicate = ''; $timestamp = (can_perform('canviewhidden', 0, fetch_guest_user()) ? 'lastposttime' : 'hiddenlastposttime'); $lastupdated = 0; $buglist = array(); $bugs_fetch = $db->query(" SELECT bug.*, comment.comment_parsed FROM " . TABLE_PREFIX . "bug AS bug LEFT JOIN " . TABLE_PREFIX . "comment AS comment ON (bug.initialreport = comment.commentid) WHERE bug.product IN (" . fetch_on_bits('canviewbugs', fetch_guest_user()) . ") AND (!bug.hidden OR (bug.hidden AND bug.product IN (" . fetch_on_bits('canviewhidden', fetch_guest_user()) . "))) ORDER BY " . (can_perform('canviewhidden', 0, fetch_guest_user()) ? "bug.lastposttime" : "bug.hiddenlastposttime") . " DESC LIMIT " . bugdar::$options['syndicateditems'] ); foreach ($bugs_fetch as $bug) { $syndicate .= ' bug://report/' . $bug['bugid'] . ' ' . $bug['summary'] . ' ' . gmdate('Y-m-d\TH:i:s\Z', $bug["$timestamp"]) . ' ' . $bug['username'] . ' ' . htmlspecialchars('
' . T('Bug ID') . ': ' . $bug['bugid'] . '
' . T('Summary') . ': ' . $bug['summary'] . '
' . T('Product/Component/Version') . ': ' . bugdar::$datastore['product']["$bug[product]"]['title'] . '/' . (($bug['component']) ? bugdar::$datastore['product']["$bug[component]"]['title'] . '/' : '') . bugdar::$datastore['version']["$bug[version]"]['version'] . '
' . T('Status') . ': ' . bugdar::$datastore['status']["$bug[status]"]['status'] . '
' . T('Severity') . ': ' . bugdar::$datastore['severity']["$bug[severity]"]['severity'] . '

' . $bug['comment_parsed'] . '

') . ' ' . htmlspecialchars($bug['comment_parsed']) . ' '; $lastupdated = $bug["$timestamp"]; } echo ' ' . sprintf(T('%1$s Syndication Feed'), bugdar::$options['trackertitle']) . ' ' . gmdate('Y-m-d\TH:i:s\Z', $lastupdated) . ' '; echo $syndicate; echo ' '; ?>