function show()
{
global $page, $db, $fs, $proj, $user;
$page->setTitle($fs->prefs['page_title'] . L('svnlog'));
// check for last repo update
$db->setLimit(30);
$logdb = $db->x->getAll('SELECT content, last_updated, topic FROM {cache}
WHERE type = ? AND project_id = ?
ORDER BY last_updated DESC', null, array('svn', $proj->id));
$logsvn = array();
// check if nothing is cached yet oder older than 1 day
if (!count($logdb) || $logdb[0]['last_updated'] < time() - 60 * 60 * 24) {
$svninfo = new SVNinfo();
$svninfo->setRepository($proj->prefs['svn_url'], $proj->prefs['svn_user'], $proj->prefs['svn_password']);
$currentRevision = $svninfo->getCurrentRevision();
if (!$currentRevision) {
FlysprayDo::error(ERROR_INPUT, L('svnnoconnection'));
}
// Get last 30 log entries
$logsvn = $svninfo->getLog(count($logdb) ? $logdb[0]['topic'] : $currentRevision - 30, $currentRevision);
$stmt = $db->x->autoPrepare('{cache}', array('type', 'content', 'topic', 'project_id', 'last_updated'));
foreach ($logsvn as $log) {
$stmt->execute(array('svn', serialize($log), $log['version-name'], $proj->id, strtotime($log['date'])));
}
$stmt->free();
// server sends oldest entry first
$logsvn = array_reverse($logsvn);
}
for ($i = 0; $i < count($logdb); ++$i) {
$logdb[$i] = unserialize($logdb[$i]['content']);
}
$svnlog = array_merge($logsvn, $logdb);
foreach ($svnlog as $key => $log) {
// Make first line of summary bold
$svnlog[$key]['comment'] = $page->text->render(trim($svnlog[$key]['comment']), true);
$svnlog[$key]['comment'] = explode("\n", $svnlog[$key]['comment']);
$svnlog[$key]['comment'][0] = '<strong>' . $svnlog[$key]['comment'][0] . '</strong>';
$svnlog[$key]['comment'] = implode("\n", $svnlog[$key]['comment']);
}
$page->assign('svnlog', $svnlog);
$page->pushTpl('svnlog.tpl');
}
}
if (!$proj->prefs['svn_url']) {
die('No URL to SVN repository entered in PM area.');
}
$project_prefixes = $db->x->GetCol('SELECT project_prefix FROM {projects}');
$look = array('FS#', 'bug ');
foreach ($project_prefixes as $prefix) {
$look[] = preg_quote($prefix . '#', '/');
}
$look = implode('|', $look);
echo '<h2>' . $proj->prefs['project_title'] . '</h2>';
// use backward-compatible column name
$cols = $db->x->getRow('SELECT * FROM {related}');
$col = isset($cols['is_duplicate']) ? 'is_duplicate' : 'related_type';
$revisions = $db->x->GetCol('SELECT topic FROM {cache} WHERE project_id = ? AND type = ?', null, $proj->id, 'svn');
$svninfo = new SVNinfo();
$svninfo->setRepository($proj->prefs['svn_url'], $proj->prefs['svn_user'], $proj->prefs['svn_password']);
$currentRevision = $svninfo->getCurrentRevision();
// retrieve stuff in small portions
$stmt = $db->x->autoPrepare('{cache}', array('type', 'content', 'topic', 'project_id', 'last_updated'));
for ($i = 1; $i <= $currentRevision; $i += 50) {
echo sprintf('<p>Importing revisions %d to %d...', $i, $i + 49);
flush();
$logsvn = $svninfo->getLog($i, $i + 49);
foreach ($logsvn as $log) {
if (in_array($log['version-name'], $revisions)) {
continue;
}
// fill related revisions
preg_replace_callback("/\\b(" . $look . ")(\\d+)\\b/", 'add_related', $log['comment']);
$stmt->execute(array('svn', serialize($log), $log['version-name'], $proj->id, strtotime($log['date'])));